Keerthi Allu

12+ years of experience on Data warehouse projects in all phases of Analysis, Administration, Design, Development, Implementation and support of Data warehousing applications using Informatica power center 10.x& 9.x, Informatica Cloud IICS, Azure Data factory (ADF) SQL, Oracle, Teradata and Unix. Expertise on data extraction, Transformation and loading data from various sources like Oracle, SQL Server,Redshift,GCP,S3 Bucket and Flat files using Informatica Power Center. Excellent technical and analytical skills with clear understanding of ETL design and project architecture based on ETL requirements. Excellent knowledge in developing the complex SQL queries, unions and multiple tables joins and experience with views. Perform data validation tasks after data load and identify the data mismatches. Experienced in performance tuning of mappings, sessions and workflows. Experienced in SDLC including Analyze, Design/Model, Implement, Test and Maintenance. Wide experience of working on Agile Model. Extensive knowledge on Data marts, Data warehouse, Data migration, Data Quality, Data Analysis, Data integration, Metadata Management, ETL and Data Modeling. Proficient in grasping new technical concepts and utilizing them in an effective manner. Proven capability of meeting project goals using technical, inter personal and team work skills. Provide the Estimation to work requests or change Requests. Assisting Informatica Admin for Migration. Knowledge on .Net technology and could able to implement solutions according to given requirements.

• Mphasis, Party Data Master, Schwab, USA, Windows, Unix, IICS,Powercnter, Teradata,GCP, 7, Development, 04/2020 to 01/2024, The Charles Schwab Corporation is an American multinational financial services company. It offers banking, commercial banking, an electronic trading platform, and wealth management., Integration Development: Designing, developing, and implementing integrations using IICS to connect different systems, applications, and data sources. This involves configuring and customizing integration workflows, mappings, transformations, and data flow. Data Integration: Building data pipelines to extract, transform, and load (ETL) data from multiple sources into target systems. This includes data cleansing, validation, and mapping to ensure data accuracy and consistency. Cloud Integration: Leveraging IICS to integrate cloud-based applications and services, such as Salesforce, Workday, ServiceNow, and more. This involves understanding the APIs and connectivity options provided by various cloud platforms. Data Transformation and Mapping: Defining data transformation logic and mapping rules to ensure the seamless flow of data between different systems. This may involve using built-in functions, scripting languages, or SQL to manipulate and transform data. Error Handling and Troubleshooting: Monitoring integration processes and addressing any errors or issues that arise during data integration. Troubleshooting and resolving issues related to connectivity, data format, data quality, and performance. Security and Compliance: Ensuring the security and compliance of data during integration processes. This includes implementing encryption, access controls, and data protection measures to safeguard sensitive information. Documentation and Reporting: Documenting integration workflows, mapping rules, and configurations for future reference. Generating reports on integration status, data flow, and performance metrics to track and analyze integration processes. Collaboration and Stakeholder Management: Collaborating with cross-functional teams, business analysts, and stakeholders to gather integration requirements, understand business processes, and deliver effective integration solutions. Upgrades and Maintenance: Keeping up-to-date with new releases, features, and enhancements in IICS. Performing system upgrades, maintenance tasks, and applying patches to ensure the stability and optimal performance of integration processes. Continuous Improvement: Identifying opportunities for process improvement, automation, and optimization within the integration landscape. Proactively suggesting and implementing best practices to enhance efficiency and reliability.
• Fission Labs, Reporting and IRIS Integration, CIGNA, USA, Windows, Unix, Informatica, SQL Server, 2, Developer, 02/2018 to 04/2020, Integrating SFDC as CRM data source, IRIS reports on the actual sales done by a customer Within time lines .The reports are enables the mangers to analyze the sale of Alcon products to different customers across two major timelines Month to date & Year to date (MTD&YTD).An user may be interested to know the performance of sales for particular product within timeframe., Created analysis of source systems, business requirements and identification of business rules. Creating SDS document for all of the functional specifications and preparing matrix of implementation. As given instructions from onsite preparing source to target mapping document. Populating base tables using scripts from excel. Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center Worked on complex mappings and workflow to meet the business needs. Designed and developed efficient Error Handling methods and implemented throughout the mappings. Responsible for Data quality analysis to determine cleansing requirements. Worked with several facets of the Informatica Power Center tool - Source Analyzer, Data Warehousing Designer, Mapping Designer and Transformation Designer. Development of Informatica mappings for better performance. Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level for Data Loads. Prepared Technical Specification document, Unit/ Systems Test Plan and the test cases for the developed mappings.
• Fission Labs, ITB Insight Supply Chain Incorporation of bFS, Schneider Electric, Windows, Unix, Informatica, Oracle, Developer, 11/2014 to 02/2018, The transactional system of record for IT Business’ (ITB’s) “non-concurrent service agreements” and “time & material invoices” transactions is transitioning in 2015. The purpose of this project is to ensure completeness and continuity of ITB Orders Revenue reporting for the ITB’s “Non-concurrent Service Agreements” and “Time & Material Invoices” transactions., Extensively involved in ETL (Informatica) testing. Automated the Regression and Unit testing. Involved in developing the ETLs using Informatica for the all modules. Involved in migrating the ETL code between different environments. Working in AGILE Methodology where we send data to modeling environment, which is used by Modelers to refine requirements, till requirements finalize.
• Fission Labs, EDW Build out Losses, Hanover, Informatica 9.5, SQl, Oracle, Developer, 11/2013 to 10/2014, The Enterprise Data Warehouse (EDW) currently contains all HCS claim attributes and loss transactions since 2008-11-04. There are no changes to this process as part of this project other than to derive a small number of additional elements (source system, accounting period) for the current and historical data. The historical population of the EDW with PMS-only direct claim attributes and transactions from 2004-01 forward. HCS claim data flowing thru PMS will be bypassed. The historical population of the EDW with Corporate manual direct claim attributes and loss transactions from 2004-01 forward., Prepare the Design doc based on Requirements sent by Modelers and Statisticians Work is done in AGILE environment where we send data to modeling environment, which is used by Modelers to refine requirements, till requirements finalize. Created analysis of source systems, business requirements and identification of business rules. Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center Worked on complex mappings and workflow to meet the business needs. Designed and developed efficient Error handling methods and implemented throughout the mappings. Responsible for Data quality analysis to determine cleansing requirements.
• Cognizant Technology Solutions, Financial Planning, Hanover, Informatica 9.5, SQl, Oracle, Developer, 05/2011 to 10/2013, This project will re-engineer the existing financial processes and introduce state of the art tools to reduce cycle time, reduce key man reliance, and create powerful analytics and reporting capabilities. Processes will be simplified, standardized, and streamlined, and greater transparency will result. Increased visibility into allocations and expenses will also be a benefit to numerous users., Created analysis of source systems, business requirements and identification of business rules. Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center Worked on complex mappings and workflow to meet the business needs. Designed and developed efficient Error handling methods and implemented throughout the mappings. Responsible for Data quality analysis to determine cleansing requirements. Worked with several facets of the Informatica Power Center tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplets Designer and Transformation Designer. Development of Informatica mappings for better performance. Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads Prepared Unit/ Systems Test Plan and the test cases for the developed mappings.