Consultant

• Jul 2017 - Present

Data Analyst

• May 2016 - Dec 2016

• Extracted and analyzed client’s data to drive product strategy and business insights • Prepared interactive and effective visualizations using Tableau for monthly reporting • Published custom dashboards and stories for clients using DOMO with actionable insights and recommendations • Automated reporting process by performing data transformation & migration using MySQL in DOMO • Provided insights to clients by monitoring activity on client websites using Google Analytics and Spredfast • Wrote complex SQL queries for monthly and ad-hoc reporting of client campaign and social platform data • Created pivot tables and charts to analyze client’s data in excel and answer business questions • Designed data flow model in DOMO ETL to schedule data extraction process from multiple data sources with high volume data sets, expediting visualization process and improving client reaction time • Developed Macros and advanced excel functions in Excel for data cleaning and analysis Show less

Consultant

• Dec 2011 - Jul 2015

• Extracted data for product hierarchies from MS SQL Server by writing SQL queries and stored procedures • Developed reports for analyzing lead times, throughput, defect density which led to improvement in manufacturing processes leading to an increase in yield by 20% • Automated dashboard led to 65% reduction in manual efforts of IT Project managers • Applied Lean - Six Sigma Methodology to save 1½ Man-days / Scenario for a client by creating macro using VB Scripting that converted 300+ test cases to SDLC 5.0 format and saved conversion time by 50% • Migrated legacy reports built in SQL Server Reporting Services to Tableau 9.1 • Analyzed and documented work and data flows by creating flowcharts and use case diagrams • Proposed the use of agile methodology to increase the productivity and reduce the delivery time by 20% • Created Dashboards in MS Excel to report data by using Pivot tables and V-Lookup • Supervised a team of 3 for the Execution and Preparation of Functional Test cases • Interacted with clients on a weekly basis, to understand and document their reporting needs • Expertise in gathering, analyzing and documenting business requirement documents and functional requirement specifications • Active Participation in Peer Review of the test scenarios & scripts as per the TMap Next Test Design Techniques • Implemented End to End database testing from SAP / Legacy systems to JDA Demand and Fulfillment tables in order to improve the forecast accuracy and visibility for overall supply chain • Written Complex SQL queries for creating business related Hierarchies of Master data in the database Show less

Software Quality Assurance Analyst

• Jun 2010 - Dec 2011

• Performed Multiple stages of Software testing for an Insurance based project • Created Requirement traceability matrix for mapping business requirements with test scripts creation • Played an active part in Requirement workshops to determine business needs and adhoc requirements to meet customer expectations and issue resolution • Performed configuration & administration of HP Quality Center (ALM) • Played the role of single point of contact between Business, Design and Test team for New Business / Servicing module • Liaise with SME's on requirement analysis and query resolution • ETL Testing of source to dimensions and facts using complex SQL queries • Created Test Scenarios in Test Case Matrix using TMAP techniques like SYN and DCT • Involved in STLC & Defect life cycle including test case designing & execution, defect raising, tracking & retesting Show less