Lalitha C

• Highly experienced IT professional with over 12 years of expertise in migration, development, and production support. Proven track record of successfully delivering projects and providing efficient technical support. Skilled in identifying and resolving complex technical issues while maintaining a strong focus on customer satisfaction.
• Expertise in creating Mappings and Mapplets with various transformations such as Source Qualifier, Aggregator, Expression, Lookup, Filter, Joiner, Union, Router, Rank, Sequence Generator, and Update Strategy transformations.
• Proficient in implementing slowly changing dimensions (SCDs) - Type I II and III in different mappings.
• Skilled in designing ETL workflows for SQL Server, Oracle, Teradata, Snowflake and Flat files. Strong debugging skills using Informatica debugger and session logs.
• Experienced in Unit testing, System integration testing, and UAT using Quality Centre.
• Proficient in scheduling workflows through Job scheduler
• Focused on delivering high-quality products on tight schedules. Monitors, trains, and encourages employees to improve skills and meet demanding targets.
• History of successfully developing and managing strong teams through proactive training and issue management.
• Reliable Lead demonstrating high level of ownership and initiative. Possessing exceptional work ethic and desire to go above and beyond to exceed company expectations. Offering knack for building productive working relationships. Successful in fast-paced, deadline-driven environments to manage goals and team development. History of thriving in team-oriented environments.

USCRM is convergence program that unifies various global business units to one. As part of this, code is harmonized to handle all the features of different GBUs and thus enable the end users to use single platform. Here end users are sales representatives and medical users.

CIDF -DMT is a migration/enhancement project, for transforming customer interactions data from legacy systems to new BI platform. The legacy system is on Postgres database with Cognos reporting. The new system lies on Snowflake. The reporting happens through Power BI.

Responsibilities:

• Gathering requirements and design discussions with customer
• Helping the team in development, unit testing, fixing the defects raised during QA testing.
• Reviewing the code and test results
• Delivering the code within deadlines.
• Preparing Implementation checklists while promoting the code to testing and production.

Chubb is the world's largest publicly traded property & casualty insurance company, serving consumers & companies of all sizes.

Claims Path Decommission is a migration project, for transforming claims information from legacy systems to new BI platform. The legacy system is on Netezza database with Cognos reporting. The new system lies on Azure SQL Database. The reporting happens through Qlick.

Westpac Banking Corporation, known simply as Westpac, is an Australian bank and financial services provider headquartered in Sydney, Australia.

CREDR is Credit risk enterprise data repository. Its purpose is to calculate the Basel II Pillar1 and Pillar 3 regulatory reporting requirement. CREDR integrates GDW and other independent data sources and applies various regulatory rules to calculate the credit risk capital requirement. This system collects risk data from different source systems and process and report to APRA (Australian Prudential Regulation Authority) for the Basel II standards

The Bank of America Corporation is an American multinational investment bank and financial services company based in Charlotte, North Carolina, with central hubs in New York City, London, Hong Kong, Minneapolis, and Toronto.

Migration project to bring all the independent process to integrate into a single wholistic process for standardization

Rogers Communications Inc. is a Canadian communications and media company. It operates particularly in the field of wireless communications, cable television, telephone, and Internet connectivity with significant additional telecommunications and mass media assets.

 Teradata Migration - to acquire details on Roger's multiple legacy billing system and its infrastructure and its billing data source, its upstream system and downstream details, billing cycles and sensitivity of the data handled. This project is a short term billing data migration project, for transforming Rogers’ customers’ information from legacy systems to BI platform. Billing system details needs to be gathered from all corners of Rogers’s business. This information facilitates Rogers to develop requirement for its Legacy system Migration.

The Hewlett-Packard Company (commonly referred to as HP) was an American multinational information technology company headquartered in Palo Alto, California. It developed and provided a wide variety of hardware components as well as software and related services to consumers, small- and medium-sized businesses (SMBs) and large enterprises, including customers in the government, health and education sectors.

FLEX is a development and enhancement project. The project is based on data warehousing and business intelligence modelling. The primary purpose of the project is to load data from SFDC systems to SQL server database and then into Vertica database using Informatica PowerCenter. The scheduling tool Tidal which automates the job flow from source to target is used. QlikView is used for building dashboard reports based on the views which are built on Vertica tables.

The project is based on data warehousing and business intelligence modelling. We have provided higher level production support and enhancements at the code level. The primary purpose of the project is to load data from SAP R3 systems to SAP BI and then into Teradata using Informatica PowerCenter. The scheduling tool called Workload control centre which automates the job flow from source to target is used.