Rajendra Kumar Chennuri 609-***-****

Rajendra**15 acvk1k@r.postjobfree.com

www.linkedin.com/pub/rajendra-chennuri/aa/239/159/

SUMMARY:

** ***** ** ********* ** Information Technology, which encompasses complete SDLC, developing, testing, deploying, maintaining and supporting in Data Warehousing/ Business Intelligence (BI) environment, Online Analytical Processing and ETL (Extract, Transform, Load) & ELT solutions.

Extensive knowledge in full life cycle of Data Warehouse projects involving data analysis, data extraction, conversion, cleansing and loading in Agile Scrum model.

Hands on different types of sources like XML, Flat Files, EBCDIC files, COBOL pages (Mainframe System) and RDBMS tables.

Having strong background in Data warehousing projects development and solid exposure to diversified technologies like Informatica Power Center 9.6, Informatica Power Exchange, Abinitio, Toad, Oracle, Teradata 15, MS SQL Server, T-SQL, DB2, Autosys, Control-M, HP ALM & Alarm Point.

Proficient and sound in performance tuning of ETL code and Teradata queries.

Expertise in Exporting and Extracting Data using Teradata Utilities like Fast Load, Multi Load, TPUMP, Fast Export and Teradata Parallel Transporter as services in Informatica.

Having Sound knowledge on migration of Informatica tool from old version to latest (8.6 9.1 to 9.6).

Expertise in writing PL/SQL, Stored Procedures, Packages, triggers, Views and Macros.

Having experience in leading the support team for the production environment, including incident support and enhancements.

Solid hands on experience with Data warehousing tools, Data Analysis, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.

Coaches and mentors individuals on the project teams and provides feedback on performance to their leaders.

Experience with Version Control System SVN (Tortoise Subversion Control).

Good knowledge in RDBMS concepts, data models, Star Schema & Snow Flake Schema.

Proficient in communicating effectively across multiple levels (Executive Sponsors to team members).

Excellent debugging and troubleshooting skills, with an enthusiastic attitude to support and resolve customer problems. Having ability to work independently.

Education:

Year: 2004 - Master of Sciences (M.Sc) in computers -Kakatiya University, INDIA.

TECHNICAL SKILLS:

ETL Tools

Informatica Power Center 9.6, Informatica Power Exchange, Ab Initio

Programming Languages

Core Java, SQL, C

Database

Teradata 15.0, Oracle11g, MS SQL Server 2005, Toad, Transact-SQL

Operating System

Windows 7, Windows XP, Windows 2003/2000 Server, UNIX

Data Warehousing (BI)

Data Marts, OLTP, OLAP, Normalization, Dimensional Modeling, Fact, Dimension, Star schema, Snowflake schema, Galaxy Schema, Slowly Changing Dimensions, ELT

Scheduling Tools:

UC4, Autosys, Control M v8 (BMC Workload Automation), Tivoli

Data Merging Tool:

Informatica MDM (Master Data Management) /

Defect Tracker:

Jira, HP Application Lifecycle Management 11.00, Quality Center

Production Support Tools

Alarm Point, Remedy 7.0, Jira

Reporting Tools

Business Objects XI R2

Agile Tool

Rally

PROFESSIONAL EXPERIENCE

PAYPAL, Omaha NE

Database Developer III Jun’15 – Till Date

Data Technologies -Global Operations Team [DTGOPS]

Role: ETL Lead

Environment: Teradata 15.0, Teradata SQL Assistant, Teradata Utilities (TPT, BTEQ, Fast load), Informatica Power Center 9.6, UC4, UNIX, Power Designer, Oracle Golden Gate, oracle SQL Developer, Rally, Jira.

Responsibilities:

Involved in scrum (Agile) implementation (Rally) for all projects in DTGOPS team.

Responsibilities included 70% Development and 30% production support.

Designed and developed data solutions to help the product and business teams make data driven decisions.

Worked closely with Business Systems Analyst’s (BSA’s) to get the requirements and translate them into technical requirements and deliver the solution to end users.

Lead end-to-end efforts, including design, development, and implementation, of the data integration process. Adhered to the best standards for naming conventions and coding practice to ensure consistency of data model.

Responsible for Performance Tuning of High CPU consuming queries and tables with high skew for daily batch jobs.

Interacted closely with data infrastructure and engineering teams to build and extend ETL processes.

Provided consultation to business partners such as analysts, management, end users, and developers to clarify objectives, determine scope, drive consensus, identify problems and recommend solutions.

Supported end users on ad hoc data usage and be a subject matter expert on functional side of the business.

Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from oracle Golden Gate to flat files and then to target Teradata tables.

Created reusable Mapplets and Transformations starting concurrent batch process in server and did backup, recovery and tuning of sessions.

Designed and developed complex mappings to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator, and Update Strategy from varied transformation logics in Informatica.

Performed Development using Teradata utilities to populate the data into BI DW like BTEQ, Fast Load, Multi Load and TPT.

Written complex SQLs using Analytical functions (OLAP), joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.

Developed the Teradata BTEQ’s to load data from Incremental/Staging tables to Base tables.

Executing test scripts to verify actual results against expected results by using Oracle Golden Gate for source validation and Teradata for target validations.

Developed the FTP process from the Unix servers to the file services location for vendor delivery

Handled customer service data into the EDW for the BI team to generate reports for the end users.

Executed unit tests and validated expected results; iterating until test conditions has passed.

Performed Teradata SQL assistant Import and Export utility to move data from production to Development to refresh staging tables.

Developed several jobs to improve performance by reducing runtime using different partitioning techniques.

Project: ICDW - CM (Credit Management) Data Mart Sep’14 –May’15

Client: JPMorgan Chase & Co / Columbus (OH)

Role: ETL Lead

Responsibilities:

Gathered requirements by analyzing Abinitio Graphs and Prepared Technical specification document.

Provided Training to team members on JPMC Audit Framework and ICDW architecture.

Actively participated in meetings with Business Analyst, Data Modeler and End Users to understand the requirements.

Coordinated with offshore and onshore teams and allocated tasks.

Developed Informatica sessions with Push Down Optimization in Informatica Power Center.

Prepared team members to follow proper coding standards while coding. Used Standard checklist for peer review.

Developed Informatica mappings and Mapplets. Used Sorter, Normalizer, Sequence Generator, Source Qualifier, Filter, Lookup, Aggregator, Union, Router, Update Strategy, Joiner, XML (Parsers, Generators& XSD) Transformations.

Extracted source data from COBOL pages, EBCIDIC, flat files. Used Informatica Power Exchange to pull data from EBCIDIC files.

Analyzed Production system (Autosys Work Scheduler) gathered existing dependency, schedule & SLA details and created Control M jobs to automate Credit Management ETL jobs.

Data loads were done, using ETL tool, Bteq scripts and Teradata utilities like Fast Load, Multi Load and Teradata Parallel Transport (TPT) scripts.

Leveraged Teradata FastExport utility to extract data from Target tables to provided Outbound Extracts to Third Party Vendors.

Based on the Explain Plan from Teradata optimizer, collected statistics of Index columns, Join Columns and Partition columns to improve query performance.

Helped Team members in preparing Unit Test Cases. Performed Unit Testing of Informatica and Teradata code.

Wrote complex queries in DB2 database to reconcile data between EDW & ICDW.

Participated in Daily Status meetings and updated Status Report to stakeholders.

Worked on ALM testing tool to execute test cases and Defect fix.

Represented Development team in Daily Scrum call. Updated daily status to scrum master.

Worked closely with ETL Testing team for QA & UAT Signoff.

Supported User Acceptance Testing and resolved the issues identified in UAT.

Supported production environment in the warranty support period, including incident support and enhancements.

Environment: Teradata 13, Informatica 9.6, UNIX, Autosys, Control M v8, DB2, Abinitio, Erwin 3.5, HP ALM

Project: JPMC Cards Remodelling – Wave 1 (Credit Cards) Feb’14– Aug’14

Client: JPMorgan Chase & Co / Columbus (OH)

Role: ETL Lead

Responsibilities:

Trained all the team members on ICDW architecture and SOR Factory Model.

Reviewed RE document and gathered the Business logic requirement for SOR.

Developed, tested & migrated BALFD, RWRDS & DCAP applications to higher environments for staging layers.

Prepared DEM sheet, Tech-Spec documents.

Conducted all types of code Reviews.

Helped team in Resolving technical issues.

Used Informatica XML Transformation (Parsers, Generators & XSD) to read XML source files.

Used Normalizer to read Mainframe COBOL pages and EBCIDIC files.

Coordinated with QA team for closure of defects.

Support User Acceptance Testing and resolve the issues identified.

Migrated the code to Production and Supported production environment in the warranty support period, including incident support and enhancements.

Environment: Teradata 11, Informatica 9.1, UNIX, Autosys, Control M v8, DB2, Abinitio, Erwin 3.5, HP ALM

Project: EDW – ICDW MIGRATION WAVE III (Retail) Oct’12 – Jan’14

Client: JPMorgan Chase & Co / Columbus (OH)

Role: ETL Lead

Responsibilities:

Responsible for delivering RDM module for Integration layer.

Involved in mapping document design discussions.

Managed 7 members team for RDM module out of total team members (30).

Conducted all types of code Reviews.

Used Informatica XML Transformation (Parsers, Generators & XSD) to read XML source files.

Used Normalizer to read Mainframe COBOL pages and EBCIDIC files.

Migrated code to QA, UAT & PROD within the time-lines. (followed client's ITSM process)

Developed Run-book, Playbook for Production migration.

Supported production environment in the warranty support period, including incident support and enhancements.

Interacting with on-site team in various ways by attending architecture meetings, project meetings, business analysis meetings, team meetings etc.

Environment: Teradata 11, Informatica 9.1, UNIX, Control M v8, Tivoli, DB2, Abinitio, Erwin 3.5, HP ALM

Project: GLOBAL SALES & L3 Production Support Jul’11 – Sep’12

Client: DELL / Austin (TX)

Role: ETL Lead

Responsibilities:

Creating reusable and non-reusable mappings/transformations, sessions, workflows using source as Oracle and target as Files and Teradata.

Involved in complete development and Unit testing.

Query tuning and optimization.

Worked on code reusability and shortcut objects in Informatica.

Developed Technical specification document.

Interacting with team in various ways by attending architecture meetings, project meetings, business analysis meetings, team meetings etc.

Environment: Teradata 11, Informatica 9.1, UNIX, Control M, HP Quality Center, Oracle

Project: ITEM TAA DOMINOS Jan’11 – Jun’11

Client: DELL / Austin (TX)

Role: ETL Developer

Responsibilities:

Creating new mappings, sessions, workflows using source as SQL Server and target as Files and Teradata.

Involved in complete development and Unit testing.

Worked on reusable transformations, reusable mappings and sessions

Fixing TTs(bugs) and Implementation of CRs(change request)

Worked on mapping parameters and variables.

Environment: MS SQL, Teradata, Oracle, Informatica, Unix, Control M, HP Quality Center

Project: GLOBAL CUSTOMER-HUB Feb’10 – Dec’10

Client: DELL / Austin (TX)

Role: ETL Developer

Responsibilities:

Creating new mappings, sessions, workflows and enhancements in the existing mappings.

Loaded data from Collection Server (flat files) into INC tables and target tables using appropriate business rules.

Prepared Support Transition documents and successfully transitioned to L3 support.

Involved in complete development and testing (Unit Testing, DIT, SIT, UAT)

Discussed with Client during the development of GCH

Implemented Joiner, Expression, Aggregation, Sorter, Rank, Lookup, Filter, Stored procedure, Router Transformations.

Developed reusable transformations.

Implemented mapping variables in mappings.

Environment: MS SQL, Teradata, Oracle, Informatica, Unix, Control M, HP Quality Center

Project: GLOBAL ITEM Base Jun’09 – Jan’10

Client: DELL / Austin (TX)

Role: ETL Developer

Responsibilities:

Creating new mappings, sessions, workflows and enhancements in the existing mappings.

Loaded data from Collection Server (flat files) into INC tables and target tables using appropriate business rules.

Prepared Support Transition documents and successfully transitioned to L3 support.

Involved in complete development and testing (Unit Testing, DIT, SIT, UAT)

Discussed with Client during the development of GCH

Implemented Joiner, Expression, Aggregation, Sorter, Rank, Lookup, Filter, Stored procedure, Router Transformations.

Developed reusable transformations.

Implemented mapping variables in mappings.

Environment: MS SQL, Teradata, Oracle, Informatica, Unix, Control M, HP Quality Center

Project: MONARCH – Phase II Jul’08 – Mar’09

Client: DELL / Austin (TX)

Role: ETL Developer

Responsibilities:

Creating new mappings, sessions, workflows and enhancements in the existing mappings.

Loaded data from Oracle to LRF (flat files) to INC tables and target tables (Teradata) using appropriate business rules.

Prepared Support Transition documents and successfully transitioned to L3 support.

Created Change Request using Remedy tool to move the code to Production.

Environment: MS SQL, Teradata, Oracle, Informatica, Unix, Control M, HP Quality Center

Project: Q2C (Quote To Cash) Feb’07 – Jun’08 Client: DELL / Austin (TX) / Bangalore- India

Role: ETL Developer

Responsibilities:

Creating new mappings, sessions, workflows and enhancements in the existing mappings.

Loaded data from Oracle to LRF (flat files) to INC tables and target tables (Teradata) using appropriate business rules.

Prepared Support Transition documents and successfully transitioned to L3 support.

Created Change Request using Remedy tool to move the code to Production.

Environment: Teradata, Oracle, Informatica, Unix, Control M, HP Quality Center

Project: DELL DATA DIRECT (D3) May’06 – Jan’07

Client: DELL / Austin (TX) / Bangalore- India

Role: ETL Developer

Responsibilities:

Creating new mappings, sessions, workflows and enhancements in the existing mappings.

Loaded data from Oracle to LRF (flat files) to INC tables and target tables (Teradata) using appropriate business rules.

Prepared Support Transition documents and successfully transitioned to L3 support.

Created Change Request using Remedy tool to move the code to Production.

Environment: Teradata, Oracle, Informatica, UNIX, Control M, HP Quality Center

Contact this candidate