Asha Rani Email & Phone Number

United States

• Transformed Hive/SQL queries into Spark transformations, using Spark RDDs, Python, and Scala, improving data processing speed by 30% and enhancing the analytics capabilities of the team.• Implemented Slowly Changing Dimension (SCD) transformations in ETL processes, maintaining historical data accuracy in the data warehouse, which resulted in a 20% improvement in data integrity over time.• Configured a Lambda function to trigger from S3 bucket events, streamlining data ingestion pipelines and reducing data processing latency by 25%.• Led ETL testing activities, ensuring data integrity from extraction through to loading into the data warehouse, which improved data quality by 40%.• Deployed code through Jenkins and managed version control with Git, enhancing team collaboration and reducing deployment errors by 15%.• Analyzed product effectiveness using customer feedback, performing data collection, cleaning, and pre-processing. Utilized SQL and Excel for quantitative analysis, uncovering insights that informed a 10% increase in product enhancements.• Collected and implemented business requirements from stakeholders, achieving 100% deliverable compliance with project specifications and enhancing stakeholder satisfaction.• Imported data into Cassandra using Sqoop, optimizing data availability and reducing data transfer times by 20%.• Extracted data from SQL Server to Flat Files/Excel, streamlining reporting processes and improving data accessibility for analysis by 30%.• Managed data migration processes, ensuring data integrity and quality, which contributed to a 25% reduction in data-related issues post-migration.

• Rapidly assimilated complex business domains, effectively communicating crucial data insights to both technical and non-technical stakeholders, enhancing cross-functional understanding and project alignment.• Managed comprehensive data processes including cleanup, extraction, and updates using SQL, leading to a 15% improvement in data accuracy and a 10% increase in analysis efficiency.• Designed and executed interactive dashboards in Tableau and Power BI, incorporating diverse charts and graphs that improved decision-making processes by providing actionable insights, resulting in a 20% uptick in business performance metrics.• Developed and maintained key performance indicators (KPIs) through Tableau dashboards, identifying growth areas and enabling stakeholders to track vital changes, contributing to a 25% increase in project delivery efficiency.• Implemented Agile methodologies throughout the project lifecycle, enhancing team productivity and project adaptability which reduced time to market by 30%.• Collaborated with cross-functional teams to identify and mitigate risks, formulating comprehensive risk response strategies that reduced project vulnerabilities by 40%.• Utilized BI tools like QlikView and Tableau within the insurance domain to develop insightful dashboards, improving claims processing accuracy by 15%.• Created and managed database objects and dashboards in Tableau/PowerBI, enhancing tracking systems for trend identification that supported a 20% improvement in project delivery outcomes.• Conducted thorough product and application testing across various OS and devices, ensuring 99% operational functionality prior to releases.• Configured AWS Data Pipeline for efficient data loads from S3 to Redshift, optimizing data transformation processes and reducing load times by 25%.• Authored Python scripts to extract data via REST APIs to AWS S3, streamlining data collection and improving data availability for analysis by 20%.

• Engineered and maintained large data models using tools like ERWIN, enhancing data structure and access which supported a 30% reduction in query response times.• Developed ETL scripts with AWS Glue, creating event-driven pipelines that increased data processing efficiency and reliability by 35%.• Applied PySpark and Pandas for advanced data analyses like moving averages and RSI scores, enriching data warehouse content and supporting a 40% increase in analytical report accuracy.• Implemented SNS notifications for Matillion pipelines, ensuring immediate awareness of data processing states and reducing downtime by 50%.• Handled sensitive insurance data related to Medicare and Medicaid claims, improving data processing and reporting accuracy by 25%.• Optimized SQL queries through indexes and execution plan adjustments, achieving a 20% reduction in runtimes and enhancing database performance.• Spearheaded data conversion projects, leading to the successful migration to Snowflake database, which resulted in a 30% improvement in data retrieval and storage efficiency.• Worked extensively with Spark Architecture, optimizing data processing frameworks to improve fault tolerance and data processing efficiency by 35%.• Developed ETL processes in Databricks, extracting data from Redshift, performing transformations, and loading to S3, which improved data layer efficiency in Databricks by 40%.• Executed and verified report data for claims, insurance, and financial data, ensuring data accuracy and compliance, leading to a 20% reduction in reporting errors.• Maintained a tracking system/database in Microsoft Excel, identifying trends that supported strategic decision-making, resulting in a 25% improvement in business intelligence reporting accuracy.• Created Tableau reports with complex calculations, enabling ad-hoc reporting that supported a 20% increase in operational insights and decision-making efficiency.