VICTORIA MELECENT

• 9 Plus years of IT experience in the Analysis, Design, Development, Testing, and Implementation of business application systems for Banking, Insurance, and healthcare Sectors.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Centre, IICS on Oracle and DB2 databases.
• 9 Plus years of experience working on Agile methodology with respective to scrum calls, sprint planning, Sprint Review and Sprint Retrospective.
• Expertise in Data Warehouse/Data mart, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation, and production.
• Extensive experience in Functions, Views and Triggers, Complex SQL queries using SQL Server.
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Strong problem solving, analytical and interpersonal skills. Seasoned development professional well-versed in extraction, transformation and loading management.
• Collaborative team player with project management skills. Knowledgeable about defining requirements, mitigating risk, and developing standards.

• Involved in Quarterly PI meeting for requirement gathering, analysis, design and estimation to deliver the Committed objects within sprints
• Interacted with the PO to meet client requirement's and meet technical specifications
• Primarily responsible for Analysis, developing, Extraction, Transformation and loading process using IICS
• Responsible for developing mcts and mapping as per requirement using IICS, creating sequential workflows and advanced task flows for improving performance
• Implemented jobs with Truncate, slowing changes dimensions (SCD1 and SCD2)
• Handled and addressed issues in client call.
• Developing ETLs to load data from various sources to relational tables.
• Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Preparing Unit documents, Design documents, mapping documents
• Providing knowledge to new joiners and mentoring them

9.8

• Lead a project with limited timelines (severe deadlines). where the requirements would keep changing till the go live date, but with extensive planning strategies and good team collaboration we were able to overcome the struggles with ease.
• Provided technical guidance to fellow teammates.
• Work in a fast-paced environment, under minimal supervision providing technical guidance to the team.
• Conduct code reviews and make sure quality solutions are built and best Practices/standards have been followed and responsible for on-time delivery of high-quality code.
• Responsible of sharing the WSR on time to track the delivery.
• Been the Key resource to showcase the project deliverables during internal Audits.

• Best Employee award (SBU Level) Cognizant Technology Solutions-Received the best employee award for BFS VERTICAL (Comerica), Which was entitled as Project of the year.
• Completed python course on Multiple languages.
• Certified in Cloud data Modernization
• ·Certified in AWS Essentials
• Q1 quarterly awards(IBM) -extra milestone performer award for BCBSMA