Experience

• 

  Equifax

  Nov 2016 - May 2018

  Data analyst

  Applied SAS procedures, including Proc Means, Proc Frequency, and Proc Univariate, to conduct thorough validation of SAS datasets, ensuring accuracy and reliability.Conducted in-depth analysis of production SAS, SQL code, leading to the identification and implementation of optimizations for improved processing efficiency.Proficiently used ODS and PROC Report to generate user-required reports in various formats, contributing to a reduction in report generation time.Enhanced code modification efficiency through strategic modifications to existing SAS programs and the Developed and implemented SAS code for portfolio data validation, ensuring a high level of consistency across diverse portfolios.Implemented comprehensive format and integrity edit checks on CSV files and staging SAS datasets, emphasizing data integrity.Automated repetitive tasks and workflows using Python scripting and automation tools to streamline the EDA process. Show less

• 

  Genpact

  Jul 2018 - Jan 2021

  Associate data analyst

  Identified and implemented process improvements within Power BI, streamlining data collection, analysis, and reporting processes, leading to time and cost savings. Created and optimized DAX queries and calculations to perform complex data transformations and calculations.Designed and implemented data models to support reporting and analysis needs using Power BI Desktop. Ensured data accuracy, integrity, and consistency across Power BI reports by validating and cleansing data sources.Analysed large datasets to derive actionable insights and identified trends using Power BI tools and techniques. Optimised data retrieval through efficient extraction techniques using SAS SQL and Base SAS from primary and secondary sources.Enhanced data accuracy by identifying and removing duplicate records and resolving code errors.Accelerated report generation by efficiently incorporating data in formats other than SAS into SAS datasets for management reports.Improved forecasting accuracy through the use of SAS software and Microsoft Excel to identify, analyze, and interpret patterns and trends in large datasets. Show less

• 

  Tecgeon solutions

  Nov 2020 - Sept 2021

  Data analyst

  Conducted Data Cleaning: Filtered datasets and handled missing values, improving data quality by 30%.Analyzed Data Patterns: Applied statistical tools to reveal trends and insights, enhancing process efficiency by 25%.Created Data Visualizations: Built charts and dashboards that increased stakeholder engagement by 40%.Compiled Insightful Reports: Delivered findings that influenced policies and improved decision accuracy by 15%.Collaborated with Departments: Partnered with teams to meet data needs, boosting project success rates by 20%. Show less

• 

  Optum

  Sept 2021 - now

  Senior data consultant

  Optimized Healthcare Data Retrieval: Executed SQL queries across multiple sources, reducing data processing time by 30%.Enhanced Data Accuracy: Identified and removed 1,000+ duplicate records, improving data accuracy by 20% and reducing reporting errors.Boosted Operational Efficiency: Discovered and implemented 5+ data governance strategies, increasing productivity by 25%.Accelerated Reporting Processes: Reduced report generation time by 40% through streamlined ad hoc materials created in SQL, SAS Base, SAS Macros, and Excel.Streamlined User Support: Provided support for SAS and SQL troubleshooting, resolving issues 50% faster and enhancing team efficiency.Transformed Business Requirements: Successfully converted complex business requirements into 10+ effective technical solutions, ensuring alignment with organizational goals.Led SQL Optimization Initiatives: Spearheaded SQL optimization projects, reducing data retrieval times by 35% and improving report turnaround. Show less