Anusha Gadde
Lead Data Analyst Business Analyst @Erie Insurance Group
Signup · Get unlimited contacts
WORK HISTORY
Lead Data Analyst Business Analyst @Erie Insurance Group
Erie, PA, US
Leading the Data Lake Accessibility Project focused on migrating Mainframe source data (COBOL copybooks) to AWS Cloud for enterprise-wide reporting and analytics.Writing complex substring queries against DB2 databases to extract raw COBOL copybook data and convert it into CSV format for downstream processing.Collaborating with development teams to support the transformation of CSV outputs into Parquet files using Python, enabling scalable cloud-based data analysis.Creating detailed data mapping documents that define precise source-to-target relationships, field-level transformations, and business logic, ensuring accurate data integration.Developing Athena DDLs to enable efficient querying and reporting on data stored in Parquet format in AWS S3.Working closely with stakeholders and business users to gather and validate requirements, ensuring alignment with data accessibility and reporting goals.Conducting comprehensive data analysis to identify trends, ensure data integrity, and support strategic decision-making.Building and maintaining dashboards to monitor key metrics and data pipeline status.Championing data quality efforts by implementing robust validation, cleansing, and consistency checks throughout the migration process.Tools & Technologies: SQL, DB2, COBOL, Athena, Python, Excel, MarkLogic Query Console, AWS (S3, Glue, Athena)
EDUCATION
Sree Vidyanikethan Engineering College
Bachelor's degree, Electronics and Instrumentation Engineering
Narayana Junior College
Intermediate, MPC
University of Central Missouri
Master's degree, computer information systems and information technology
ABOUT ANUSHA GADDE
Experienced Data Analyst and Business Analyst with strong expertise in the Property & Casualty (P&C) Insurance domain, delivering data-driven solutions across enterprise, legacy, and cloud-based platforms.I specialize in end-to-end data lifecycle management, including data extraction from source systems, data cleansing, transformation, and validation, working with large and complex datasets to support analytics, system integrations, and business reporting. My technical expertise includes advanced SQL/PL/SQL, IBM Data Studio, MarkLogic, and OneShield Policy Administration Systems (OSPAS), including OneShield Dragon Designer, with hands-on experience across the full SDLC in Agile environments.I work extensively with mainframe and enterprise data platforms, supporting data lake accessibility using the Medallion Architecture (Bronze, Silver, Gold) and legacy-to-AWS cloud migrations. My experience includes creating and managing AWS Athena tables using Athena DDLs, enabling scalable, governed access to curated datasets while ensuring data quality and performance.I am AWS Certified Cloud Practitioner and SAFe Agile certified, bringing a strong foundation in cloud concepts and Agile delivery. Known for strong analytical, problem-solving, and communication skills, I thrive in cross-functional teams, effectively bridging business requirements with technical solutions to deliver measurable business value.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.