Lenina Mirza

• Developed and implemented indexing strategies in SQL server to optimize query execution on tables with millions of rows, resulting in faster response times for complex analytical queries.
• Supported Campaigns team to prepare Recall data for DM’s and eDM also giving insights for past and present claims, recalls, stock for best customer communication practices.
• Utilized Power BI to analyze data using diverse visualizations, including cross tabs, maps, scatter plots, pie charts, bar charts, and density charts implemented several reports to find stakeholders performance in organization.
• Automated data extraction and transformation process using ETL tools such as SSIS, streamlining data pipelines and reducing manual effort by 50%.

Achievements

• Identified unnecessary shipping costs for mailing and reduced shipping charges per recall by 15%.
• Successfully prepared reports identifying incorrect claims and avoiding faulty claims which led to reduced losses in warranty claims.
• Assisting in developing profitable pricing model by providing detailed and user-friendly insights for non-technical stakeholders.

• Created Tableau dashboards for pricing analysis to optimize product pricing strategies, leveraging historical sales data and competitor pricing information to maximize profitability while remaining competitive in market.
• Implemented advanced Excel functions and techniques to streamline data analysis processes, resulting in a 30% reduction in report generation time.
• Conducted in-depth analysis of customer purchase behavior using SQL queries and Tableau visualizations, leading to identification of key customer segments and development of targeted marketing campaigns.
• Performing analysis on financials and supporting queries from internal stakeholders.

Achievements

• Automated reports and reduced report generation time from more than 2 days to 10 minutes.
• Performed detail analysis and identified data quality gaps and resolved them resulting in reduction of data discrepancies.
• Extensively used calculations, variables, filters, conditions, sorting, drill down charts, data blending, action Filters and parameters for building dashboards for non-technical stakeholders.
• Coordinating with QA team in resolving bugs and enhancement requests.