Strong SQL, Data warehousing and Business Intelligence (Tableau, Power BI, and Python) skills.

Application Engineering and Development

• Researched sales and marketing requirements of multiple analytics stakeholders to create Profile Matrix of US Dealers• Designed advanced SQL queries to extract wholesale sales data from snowflake and integrate with raw data from 2 file sources to identify factors affecting the sales and uncover sales opportunity for dealers• Spearheaded the exploratory data analysis of parts sales to find correlation with demographics attributes across 3000+ counties and increase up-time of customers by 4%• Generated Tableau maps using custom geo-coding and identified 2 new potential dealership locations to increase customer base

Responsibilities: • Performed data validation and detailed analysis on different functionalities of Credit reporting application as per the requirement specifications.• Created data mapping for Oracle database migration and validated 12 applications for data integrity and consistency• Developed SQL queries and optimized the code to improve performance and test execution efficiency• Analyzed business requirements for Insurance application to deliver a defect free, robust product in agile• Automated test suit for dependency management & analysis improving processing time by 90%• Acted as a liaison between business and technical teams to evaluate functional requirements and formulated best practices for system implementation•Involved in end to end automation development including requirement analysis, designing test cases, testing, bug fixing and client presentations•Oversaw all phases of software development lifecycle (SDLC) and worked in agile methodology to deliver defect-free products for a Finance domain project for 3 years

Responsibilities:• Implemented ETL using SAS and extracted finance reports using Oracle business intelligence tool which helped the client(UTI mutual fund) to make strategic decisions • Created data entities and integrated data from different sources ensuring absence of data redundancy, inconsistency, incompleteness, thus improving data quality for analysis using OLAP systems• Performed data modelling in SAS tool, creating lookup tables, and loading facts and dimensions in snowflake design• Designed analytical reports in Power BI using DAX and deriving key KPIs for the investment client to make strategic decisions• Developed ETL code in Talend and created optimized jobs to load million records in less than 15 mins•Acted as a liaison between business and technical teams to evaluate functional requirements and formulated best practices for system implementation