Analytical and detail-oriented Data Analyst with 3+ years of experience in ETL development, data warehousing, and business intelligence reporting, with a growing focus on automotive and marketing incentive data. Proficient in SQL, Informatica, Power BI, and IBM Cognos, with a solid background in researching, interpreting, and transforming complex incentive and financial datasets. Experienced in ensuring data accuracy, completeness, and timeliness to support strategic decision-making in client-driven environments. Adept at working cross-functionally, conducting audits, and delivering high-quality data solutions that support vehicle sales and marketing effectiveness.
Sales Analytics and Forecasting
Developed ETL workflows to extract sales and customer data from multiple source systems into a centralized data warehouse. Created Power BI dashboards to visualize sales trends, product performance, and regional forecasts for executive reporting.
Technologies Used: Informatica, Power BI, Oracle, SQL, Unix
Finance and Budgeting Reports
Designed ETL jobs to aggregate finance data for budgeting and spend analysis. Created Power BI dashboards for department-wise expenditure monitoring and forecasting.
Technologies Used: Informatica, Power BI, Oracle, Toad, Putty
Pharmaceutical Product Monitoring
Built ETL pipelines to capture and load patient monitoring data for glucose tracking. Developed operational data marts for analysis. Delivered Power BI reports to provide insights into product usage and patient trends.
Technologies Used: Informatica, Power BI, IBM Cognos, SQL Server
Customer Data Integration and Profiling
Consolidated customer records across systems using Informatica. Implemented cleansing rules and duplicate detection logic. Built BI reports for customer segmentation and profiling.
Technologies Used: Informatica, Power BI, SQL, WinSCP
Operational Performance Metrics
Developed ETL processes to load data from manufacturing operations and quality control systems. Built Power BI dashboards for KPIs like production yield, downtime, and defect tracking.
Technologies Used: Informatica, Power BI, SQL, Quality Center 11