Home

Naresh Reddy - Informatica Developer

[email protected]

Location: Charlotte, North Carolina, USA

Relocation: Yes

Visa: H1B

Naresh Reddy Informatica Developer 984.232.7860 [email protected] Charlotte, NC Yes H1B PROFESSIONAL SUMMARY 9+years of extensive experiencein System/Data analysisand data migration for banking and financial systems. Extensive experience in Data Cleansing, Data Analysis, Data Mapping and ETL Techniques for loading high volume s of data and smooth structural flow of the data. Played multiple roles of ETL on-site coordinator and ETL Developer and Proficient in Analyzing Business processes requirements and translating them into technical requirements. Experience working on Informatica MDM to design,develop,test and review&optimiza Informatica MDM. Experience in integration of various data sources like Oracle, SQL Server, Flat files, XML files into Data Warehouse Designed,Installed,Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console,Hub Store,Hub Server,Cleanse Match Server,Cleanse Adapter,Data Modeling. 5+ years of experience in working with large scale Data Warehouse implementations using Oracle, SQL Server on UNIX and Windows platforms. Expertise in implementing business rules by creating robust Mapping, Workflows using Informatica PowerCenter tools. Strong experience in writing UNIX Shell scripts, SQL Scripts for development, automation of ETL process, error handling, and auditing purposes. Experience working with cross-functional teams in an agile environment Detail oriented with ability to self-manage multiple competing priorities TECHNICAL SKILLS ETL Tools: Informatica PowerCenter, IDQ,Informatica Power Center 9.5 / 9.0.1 / 8.6/10.2 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Datawarehouse Builder, ETL Data ,snow flake ,Data Cleansing, Data Profiling ,Mercury Quality Center, Webservices Programming Languages: SQL, Python,JSON,PL/ SQL Scripting Languages: Shell Scripting Operating Systems: UNIX, Windows XP/2000 Cloud:Aws, Azure, Hadoop, Snowflake Databases: Oracle, SQL Server, MS Access Database Tools: TOAD, SQL Developer, MySQL workbench, Redshift, Oracle 11g/10g/9i/8i, MS SQL Server2008/2005, Teradata DB2,Flat Files Test Management Tools: Quality Center, JIRA EDUCATION MS in Computer Science and Engineering, North-Western Polytechnic University, California July 2016 Bachelor s in Computer Science from JNTU Hyderabad, India May 2010 PROFESSIONAL EXPERIENCE Wells FargoBank Aug 2021 Present Informatica Developer Extensive experience in data analysis and ETL techniques for loading high volumes of data and smooth structural flow of the data. Created work process to interact with in-house frameworks including the advancement of parsing rules for xml and fixed format messages. Created Flow rules to implement approval workflow business logic. Created generic shell scripts to extract data from AWS redshift and HDFS. Created and modified Unix Shell script to compare files and load data based on provided conditions. Involved with Data Sterward Team for designing,documenting and configuring Informatica Data Director for supporting management of MDM data. Understanding Business needs and converting them into technical specs. Used Informatica Power Center to create mappings, sessions and workflows for populating the data into the dimension, facts, and lookup tables simultaneously from different source systems. Deployed new MDM Hub for portals in conjuction with user interface on IDD application. Handled slowly changing dimensions of Type 1/ Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse. Created and Migrated objects from Informatica power center to Informatica cloud environment. Created mapping in IICS and migrated objects from Power center to IICS. Prepare Data Flow Diagrams and Visio Diagrams which explains the process/application execution flow. BBVA USA bank(now PNC) April 2018 Aug 2021 Data Analyst / Informatica Developer Credit Risk Systems: AFS to LIQ Migration (Commercial Lending), Multiple enhancements Worked in various migration projects including AFS to LOAN IQ migration, Recovery Management System to Debt Manager, and PCI tokenization. Performed extensive data mapping between systems in as is state and target state (AFS to LoanIQ). Involved in Analysis of gathered requirements data, verification of requirements and creation of business requirement specifications (BRS). Writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary, Data Migration and Interface Requirements Documents. Involved in the gap analysis and documentation of the current state of systems. Worked on data cleansing using the cleanse functions in Informatica MDM. Performed data validation using SQL Queries to makes sure all modules are integrated properly. Worked with Large DB2 and Oracle, SQL Server databases doing loading, validation and manipulation of data. Publishing Data using message Queues to notify external applications on data change in MDM Hub Base Objects. Worked with cross functional teams to understand the business requirements and framing the business logic. Developed and automated ETL jobs using Informatica to get data from various data sources like XML, flat files into Oracle data warehouse. Created temporary tables, packages and procedures using Toad and SQL developer. Identified bottlenecks/critical issues and fine tuning them for optimal performance. Performed production duties include running production jobs for month-end loads and troubleshooting failures. Worked on job scheduling through Control-M internal job scheduler and worked on code migrations using deployment groups, gathered/reviewed technical metadata documentations. Citadel LLC Oct 2017 March 2018 System Analyst / Informatica Developer Analyzed the business requirements and functional specifications. Designed and developed mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router etc., transformations to implement complex logics while mapping. Used Informatica Power Center Workflow manager to create sessions, workflows, and batches to run with the logic embedded in the mappings. Designed and Developed Autosys to Schedule Informatica workflows. Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs. Involved in the development and testing of the PL/SQL stored procedures and packages. Involved in Performance tuning at source, target, mappings, sessions, and system levels. Prepared migration document to move the mappings from development to testing and then to production repositories. Implemented the concept of slowly changing dimensions to maintain current and historical data in the dimension. AT&T May 2016 Sept 2017 Informatica Developer Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables. Extensively involved in migration of ETL environment, Database objects and EDW. Tested data integrity among various sources, targets, and various performance related issues. Debugged and problem resolution in Reports and Forms. Generated master-detail, matrix groups and tabular reports. Involved in jobs scheduling, monitoring and production support in a 24/7 environment. Cinar Software Technologies July 2010 Sept 2014 Software Engineer Worked for both delivery and production support projects. Worked with the business to understand requirements and business Use Cases Involved in various activities includingtechnical documentation, and User Acceptance Testing. Wrote shell scripts to automate loading files into database using Crontab. Keywords: microsoft procedural language North Carolina