Data Analyst
Zurich Insurance
Total des années d'expérience :12 years, 6 Mois
Projects and Achievements
• Developed Alteryx workflows to automate and streamline data-analysis standard regulatory data processes including APRA standard reports eliminating manual submissions and improving performance.
• Built and maintained ETL pipelines using Snowflake Streams, Tasks and Python, ensuring eficient data loading and processing.
• Designed, developed, and implemented FSC data automated workflow using Alteryx, SQL and for policy and customer data significantly reducing submission processing time.
• Collaborated with cross-functional teams to gather requirements and deliver actionable insights.
• Built claims SLA report dashboard using Power BI to provide insights into claims processing time matrices.
• Processed unstructured data using Python extracting and transforming policy commission data from around 250 pdf files.
Projects and Achievements
• Designed and developed PTIPS data ingestion ETL pipeline containerized using Python, AWS ECS to load data from AWS S3 to Oracle.
• Automated monthly patronage reporting using Python and AWS services reducing processing time by 80%.
• Developed and maintained ETL data pipelines to load data into companys data warehouse.
• Monitored data processes and identified and resolved issues related to data ingestion, transformation, and integration.
• Applied SQL and Python programming skills to perform complex data manipulation and analysis tasks, ensuring data quality and integrity.
Designing a PL/SQL based integration solution between the new Oracle ERP and the existing Student Management system (SMP)
● Working on Project Unified (replacement of Ascender HR and JDE finance systems with single cloud solution) developing cataloguing interfaces between core applications
● Developing PL/SQL scripts to automate the data migration out of Ascender, for Oracle HCM data load as well as performing Ascender to Oracle HCM field mapping
● Reviewing code and documenting integration process for data transfer between Student Management Package (SMP) to JDE applications
● Attending workshops to discuss detailed business requirements to support development of integrations between Ascender and HCM/ERP
Designing, integrating and enhancing customer profiling for centralized profile management, Individual Life Assurance Solution (ILAS) including reviewing Back Office System-Italy CRM module.
● Lead development team for agile customer profile development designing data structure and documenting technical design.
● Engaged in data migration from BOS (OpenEdge database) to ILAS (SQL Server database) extracting, mapping, analyzing and organizing information as well as writing stored procedures for data transfer.
● Worked closely with the senior management to understand the business needs, to drive the requirements for migrating data out of Back Office Italy System
● Successfully performed Oracle to SQL Server database migration using SQL Server Migration Assistant (SSMA)
Projects and Achievements
• Led end to end Aviva unit link data migration project, legacy systems to modern platforms, ensuring data integrity, accuracy, and consistency throughout the process.
• Conducted data validation and reconciliation activities to ensure accuracy and consistency of reported data.
• Implemented data modeling and database design using SQL databases to
support application requirements.
• Designed and documented processes involving development of customer unification tools using technologies such as SQL and PLSQL providing end users a single point of entry for client/ agent data.
• Developed and successfully implemented Auto Receipt Generation bulk
premium module using Oracle forms for uploading external text files into
system, improving receipt processing time by 80%.
• Designed and developed Direct Debit Premium collection module using Oracle Forms processing automating premium processing.
Projects and Achievements
• Developed Fee Calculation Module for Royal Bank of Scotland Pakistan
• Member of software development team for core banking system named Total Consumer Services Suite (TCSS) at Royal Bank of Scotland Pakistan