Apr 2021 – Sep 2021 · 5 mos

Feb 2018 – Mar 2021 · 3 yrs 1 mo

• Projects
• 1. Developed centroid analysis solution using Python to predict the best DC(Warehouse) location setup for client across North America.
• 2. Upgraded Tableau Server 10.3 to 10.5 and later to 2018.1 & 2018.2, 2019.1.2 showcased the Tableau 10.5 & 2018.1, 2019.1.2 new features to the management.
• 3. Developed Tableau Server Health Checkup Dashboard that will cover the Resource Utilization statistics of Tableau Server machine along with other Tableau Usage Statistics (Tableau, PostgreSQL, Windows Perf Log files).
• 4. Provided training on Tableau Integration with R & Python and Tableau Advance Charts on Sankey, Waterfall, Pareto & Histogram to Advance Analytics Solutions Team.
• 5. Developed a POC using Apache Nifi to load data from CSV to Oracle database using Cluster mode.
• 6. Developed & deployed script to take regular automated backup of Tableau Server data and logs files in dev & prod environment.
• 7. Automated SAP SuccessFactors tool for HRIS team (download Performance Review pages for all employees) using Selenium in Python.
• 8. Automated Oracle EiS eXpress User Reporting tool to download the
• monthly report for Invoicing Operations team using Selenium in Python.
• 9. Developed a Python script for data cleaning steps on a ‘boutique client’ data that contains repeating header/blank rows and additional tabs

Feb 2015 – Feb 2018 · 3 yrs · Seepz

• Projects-
• 1. Warranty Claims analytics project – Identification & segmentation of suspicious claims patterns across dealer warranty claims data. (Tableau, Microsoft SQL Server 2008 & SSIS)
• Execution of R data model for Association rule prepared by Analytics team and visualize the output variables Support, Confidence, Rule Cost in Tableau.
• 2. Airline Supplier analysis dashboard – Order Analysis, Order Performance, Freight Analysis & Inventory Dashboard.
• 3. Chip-Ganassi dashboard – identification & creation of patterns (Good data, same signal data & outliers signal data) across signal strength along the time series data (Tableau & Microsoft SQL Server 2008).
• 4. Perform INS dashboard – Transformation of front end Jasper reports to Tableau and backend database SQL Server to BigData (Hadoop - Hive).
• Enhancing the existing visualizations of Jasper to Tableau charts by adding more interactivity & drill down features.
• 5. EDM-Logistics dashboard – identify the KPI’s like total shipped quantities across time, shipped countries & destinations comparison, detailed view on selection (Qlikview & Microsoft SQL Server 2008).
• 6. Involved in Tableau Partner Licensing and communicate with Tableau Sales consultants.
• 7. Handle and manage Tableau Server – administration, user creation and maintenance of dashboards.
• 8. Worked on Splunk tool to provide Operational Intelligence on web log-data.
• 9. Worked on Tableau API programming using Python & Java to create Tableau Data Extract (TDE) files.
• Certification:
• Tableau Partner Sales Accreditation certificate with a score of 91% (Nov - 2015)
• Awards-
• 1. Participation certificate in contribution towards demonstration of Warranty Analytics solution in Discover Syntel – IP Roadshow event.
• 2. Spot Reward - for contribution in providing exemplary support while creating the Sales Pitch for a potential customer from KPO head.
• 3. Spot Reward - appreciate for efforts, dedication and quick response in creating/customizing Warranty analytics dashboards.

Nov 2013 – Feb 2015 · 1 yr 3 mos · Logitech park

• Onsite Project-
• Supply Chain Management Tableau dashboard for a largest apparel manufacturing company in Sri-Lanka.
• 1. Time & Action dashboard – shows overdue by instance, days and quantities at critical stage at each Business unit.
• Risk scoring based on days delayed, quantity involved and production stage.
• 2. Customer Order Performance dashboard – shows dispatch performance (Ex-factory) for last 6 months across customers, delayed quantities are displayed as red and on time with green.
• 3. Customer Order Trend Analysis dashboard – shows monthly trend of Order confirmations, orders shipped and on-time delivery for last 6 months, by Business unit level.
• Other Projects-
• 1. Created dashboards on Service Center Analytics on KPI’s – Volume, Quality and TAT using Tableau and Excel.
• 2. Created campaign dashboards for a German Laundry & Healthcare company using Tableau and Google Analytics - Preparing bi-weekly report, monthly report, and ad hoc reports - Viral video campaign, full view campaign report for the Laundry and Healthcare Company.
• 3. Engage with client to understand and document the requirements and design dashboards as per requirement.
• 4. Created an automated data preparation process in Bi-weekly report. Research done on data integration, blending of data from multiple data sources including Cloud, Tableau Data Extract file creation – Alteryx 9.0

Oct 2011 – Nov 2013 · 2 yrs 1 mo

• Project work-
• 1. Automate weekly, monthly dashboard reports across different accounts using various technologies Excel-VBA, SQL, SSIS, and SSRS & Tableau.
• 2. Co-ordinate with Account manager and Business Heads to understand the requirement and deliver the solution within the agreed time.
• 1. Worked on Tableau 8.0 Business Intelligence tool to create business dashboards like Performance Analysis, Promotion Analysis,
• Market Basket Analysis & Brand Switch Dashboard.
• 2. MIS dashboard automation for Axis Bank Campaign using Excel VBA.
• 3. Monthly Management Report for Tata SKY using ACE Smart Report (Excel Addin) and VBA.
• 4. Automated Weekly churn Tracker report using SQL 2008 & VBA.
• 5. Monthly Management Report for AEGON Religare client using Excel – VBA, PowerPoint and SQL 2005.
• 6. Bivariate Analysis tool – Front end Excel user form and database SQL 2005. Automatic creation of queries, execution and Charts in Excel.
• 7. Text File Parser tool created in JAVA. This tool reads rows from large CSV, txt files and returns the 1st 100 rows in notepad.
• 8. HUL - Web Trail Automation excel macro to extract the product information.
• 9. Google Visualization Tool report to display a web report of Campaign Summary Report – Google Code, JavaScript & Excel.
• Awards-
• 1. Received an Apple Award for creating dashboards on Tableau 8.0
• 2. Received an Apple Award within 1st quarter of joining on Automating MMR Report of Tata SKY report.

Dec 2010 – Oct 2011 · 10 mos

• Lead MIS Analyst - VBA excel, Access, SQL Automation.
• Duties-
• 1. Create P&L Reporting for Traders across EMEA Region.
• 2. Create Daily Volumes report and report to Senior Management.
• 3. Perform WebRS (ETL) tool data upload and create daily reports from Business Object.
• 4. SME on North America region reports and EMEA reports.
• 5. Central point of interaction with BO, FO and Senior Management and Technical team.
• Automation Project-
• Created a macro save down reports as PDF attach and send via Outlook email.
• Daily Report Automation reduces the process from 3 hours to 0.5 hours.
• Awards-
• Awarded spot reward for creating Daily Report Automation process

May 2010 – Dec 2010 · 7 mos

• Designed & Implemented MIS reports Daily/Weekly/Monthly dashboards.
• Understand requirements from stakeholders, process analysts - design and develop automation projects.
• Delivered Excel advanced training (required for day to day job) for Analyst to Team Leader level.
• Created a project as Pragati for Quality team for selection of winners.
• Automation of PDF to excel and report alignment VBA Excel & Adobe.
• 3) Time Tracker Automation for Operations team VBA - Excel & Access.
• 4) Client Trade details Input file Validation - Excel VBA
• 5) PB Prematching Automation - VBA Excel & Outlook
• Received Award for significant contribution towards Operational Excellence Award - Credit Suisse Investment Banking Operations

Jun 2009 – May 2010 · 11 mos

• Analysis of Data and deliver data to business Stake holders and higher management.
• Support functional data for Back office operations - Deutsche Bank.
• Create Daily/Weekly/Monthly Reports and Dashboards.
• Validation, part of Ramp-up and Ramp-Down of FTE's.
• Automation of Reports using VBA, Excel and SQL Macros.
• Data Warehousing of historical data using Ms-Access.
• 1) Quality Assurance/Quality Checking tool - VBA, Excel and Access.
• 2) Automation of Deutsche Bank Reporting - Web Query Crawler.
• 3) Time Tracker tool - VBA, Excel and Access.

Jan 2007 – May 2009 · 2 yrs 4 mos

• IT.; Role - QBOA: Quality Brand Operational Analyst.
• Provide Data Analytical Solution to a Fortune 500 US Company.
• Perform Promo Audits to ensure 100% Quality.
• Perform Maintenance Audits of entire US Website region including both segments-DCG & BSD Segment.
• Use customized tools (Citrix Environment) to send request for the Promos.
• Client escalation's online using Mails/Instant messengers.
• Create and conduct weekly deck/reports to the client.
• Create Macros in Ms-Excel to capture and analyze the data from web.
• Write SQL queries to create high end OLAP reports to the client.
• Developed software's (Web-Crawler) in VBA (Macro Programming) projects.
• Provided 3 BPI (Business Process Improvement) projects for this quarter.
• 1) E&A Staging\Production Promo Audit.
• 2) Delete Down Check Crawler.
• 3) Active Upsell Audit Crawler.
• Awarded Spot Reward for the contribution towards DMA (VBA+SQL) Project.

Jan 2007 – May 2009 · 2 yrs 4 mos

• IT.; Role - QBOA: Quality Brand Operational Analyst.
• Provide Data Analytical Solution to a Fortune 500 US Company.
• Perform Promo Audits to ensure 100% Quality.
• Perform Maintenance Audits of entire US Website region including both segments-DCG & BSD Segment.
• Use customized tools (Citrix Environment) to send request for the Promos.
• Client escalation's online using Mails/Instant messengers.
• Create and conduct weekly deck/reports to the client.
• Create Macros in Ms-Excel to capture and analyze the data from web.
• Write SQL queries to create high end OLAP reports to the client.
• Developed software's (Web-Crawler) in VBA (Macro Programming) projects.
• Provided 3 BPI (Business Process Improvement) projects for this quarter.
• 1) E&A Staging\Production Promo Audit.
• 2) Delete Down Check Crawler.
• 3) Active Upsell Audit Crawler.
• Awarded Spot Reward for the contribution towards DMA (VBA+SQL) Project.

Sep 2006 – Jan 2007 · 4 mos

• Deliver high end-training for all level of students.
• Part of the corporate training plan at Aptech.
• Delivered training for programming languages - C, C++, C#, Java, Advanced Java & J2EE.
• Project - Track-IT RFID "Access Control System"
• MSc(II) - Information Technology 2006
• Responsibilities
• User friendly software to set the different parameters of the reader from a single point.
• Understanding of the hardware specifications of Reader & Access Card
• Understanding of different parameters required to connect client/server machine
• Developed the code for communication using TCP/IP protocol
• Creation of DLL's in modules which can be upgraded/updated or modified for future requirements
• Created user friendly GUI forms to set/get the different parameters for RFID reader
• Preparation and Execution of test cases for conducting Functional (Client & Server) testing
• Performed various validations related to access card
• TECHNICAL SKILLS Languages: C, C++, ADVANCED JAVA, VB6.0, C#, J2ME,
• Matlab, Excel VBA Macro Programming & Crawlers.
• Database: Oracle 9i, SQL Server 2000, MS-Access.
• Hardware: Assembling machines, installation of Software's- All Windows O.S, Linux, Oracle and SQL 2000.
• MS Office Software: Excel Pivot tables, charts, Macros, Access & Outlook