Charan Kasthala Email and Phone Number

▪ Analyzed the Business requirements and documented the technical specification documents.▪ Lead Financial Transformation project to move PeopleSoft application to Oracle cloud using Python and AWS technologies (S3 and EC2) for handling files and Used OIC (Oracle Integration Cloud) to move the data in to Oracle ERP.▪ Used and created API’s to call automic jobs.▪ Analyze and Profile the existing Legacy systems and design the conversion strategy.▪ Involved in Change Request requirement analysis, impact analysis and solution documentation.▪ Analyzed and identified several data quality issues from the source systems and designed scalable error/exception handling process.▪ Data ingestion from Oracle/SQL Server to snowflake/Redshift through S3. Perform validations and consolidations for the imported data▪ Implemented Dash boards that handle snowflake queries internally like Aggregation functions▪ Implemented various performance tuning techniques at Informatica and Data base level using clustering keys▪ Used SQL, analytical and Advanced SQL queries to test huge volumes of data on Oracle 12c/11g and SQL Server 2014/2008▪ Used Informatica Power center/Power Exchange to extract/transform and load into different systems involving Oracle, SQL server, XML, Flat files, MQ, AS400.▪ Used snow pipe tasks in snowflake to automate data loads from amazon S3.▪ Developed ETL mappings for Type 1 SCD and Type 2 SCD requirements.▪ Implemented various performance tuning techniques on Sources, Targets, Mappings and Workflows.▪ Involved in writing stored procedures and shell scripts for automating the execution of jobs.▪ Supported the QA resources in SIT and UAT testing phases.▪ Supported the deployment in different environments like SIT, UAT and PROD

▪ Responsible for Onboarding new sites. (Network and security provisioning, overall deployment)▪ Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.▪ Prepared the High Level Design document, ETL reference documents, Implementation plan, Test plan▪ Developed the complex Informatica Mappings to extract the data from Oracle, Flat files and load into Staging, Data warehouse, DataMarts including Dimensions and Facts as per the requirements▪ Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD▪ Designed the effective solutions for data cleansing, exceptions handling and normalizing the data▪ Created and used the reusable Transformations, Mapplets, and Worklets to reduce the redundancy.▪ Monitor and troubleshoot batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.▪ Involved in Unit, Integration, system, and performance testing levels.▪ Reviewing the code and documents prepared by team members before code migration.▪ Giving knowledge transfer on issues, bug fix and enhancements.▪ Provide Level 1 support for the Production jobs and monitor them. Ensure that the ETL jobs get completed as per the SLA▪ Support the smoke testing and code verification after deployment and coordinate with testing team for system testing.Environment: Informatica Power Center 9.1 (Repository Manager, Designer, Workflow Manager, Monitor), Putty, Oracle 10g, PL/SQL, Toad, UNIX

▪ Involved in all phases of SDLC from requirements gathering, analysis, designed functional specifications and technical specifications, unit and integration testing and implementation▪ Understanding the business requirements (BRD) and functional specification document (SDD) clearly.▪ Responsible for preparing the Detailed design document/Technical design as per requirement from SDD▪ Involved in Logical and Physical data modeling using Ervin tool.▪ Responsible for developing SCD1 and SCD2 mappings as per business requirement.▪ Extensively used Power center to load data from Oracle, SQL server, Flat files to Target DB ▪ Developed complex Informatica mappings and tuned them for better performance.▪ Developed unit test cases, test scripts ▪ Used SQL and advanced SQL (Analytical functions) to test different sources, targets and Flat files.▪ Peer reviewed and tested ETL code developed by other developers.▪ Used JIRA to precisely assign defects to ETL/DB developers and track down the tasks▪ Supported reporting analysts for their universe development and tested the reports as and whenever required.▪ Used Appworx scheduling tool to monitor the chains and modules on daily basis▪ Involved in Production support solving the tickets (using Remedy) and provided 24*7 on call support.Environment: Informatica Power Center 8.6(Repository Manager, Designer, Workflow Manager, Monitor), Putty, Appworx, Oracle 10g, PL/SQL, SQL server 2005, Business Objects, Toad, UNIX, Windows XP, SharePoint