PROFESSIONAL SUMMARY

OVERVIEW

Certified IBM Datastage Designer with over 11 years of progressive professional experience as analyst, designer, developer in Data warehouse and Mainframes.

Expert in IBM Infosphere 11.5/9.1/8.5 - DataStage, QualityStage, Information Analyzer, Metadata Workbench.

Expert in Informatica - sources, mappings, targets and sessions.

Expert in SAP BO 4.1 - IDT, Web Intelligence.

Expert in COBOL, JCL, DB2, VSAM, EASYTRIVE, REXX, PL/1.

Expert in scheduling & monitoring the production jobs using CONTROL-M.

Expert in RDBMS with good programming knowledge in Oracle 10g, SQL Server 2008 R2/ 2005, DB2, Netezza, SQL, PL/SQL, DB Triggers, Views, Stored Procedures, Functions and Packages.

Expert in Product Development in Agile/SCRUM and Waterfall Methodology

DOMAIN

P&C Insurance, Telecom, Banking, Business Intelligence

KEY SKILLS

Oversee the implementation of the data integration projects including planning, design, development, maintenance, and coordination of resources and outputs.

Led the development and execution of a strategy to support current and future needs of Data warehouse

Work closely within the business intelligence (BI) group by providing deep technical expertise in database design, hands-on extraction transformation loading (ETL) development.

Partnered with Sr. IT leadership to work with the business to identify and lead effective business solutions.

Participated in the gathering of functional requirements from business users.

Responsible for managing, scheduling, directing activities and development of the Data Warehouse project.

Analyzed potential data quality issues to determine the root cause, and creating effective solutions for daily, weekly and Monthly jobs

Good Conceptual knowledge of Design patterns, RDBMS.

EDUCATION

Bachelor of Technology in year 2004 from JNTU Hyderabad, India.

PRIMARY SKILLS

Technologies

Exp. in yrs.

IBM Datastage

7

IBM DB2

11

IBM NETEZZA

3

Oracle

5

OFSAA

3

COBOL,JCL

4

SAP BO

3

CONTROL-M

7

UNIX

7

IBM RTC

4

Informatica

2

ADDITIONAL SKILLS

MS SQL Server, Borland star Team, HP QC, VSAM, SAR, SQL Developer, Squirrel, MS-Visio, Beyond Compare, Winscp, putty, XPEDITOR, FILEAID, IBM DEBUG, FILE MANAGER, Pegasys, QMF, DB2 ADMIN, ECLIPSE.

CERTIFICATION

Certified IBM DB2 730

Certified IBM DataStage 9.1 Designer

Currently Pursuing PMP certification

PROFESSIONAL EXPERIENCE

United State Automobile Association (USAA), San Antonio TX Jan 2017 - Present

Technical Lead/ Developer

Projects: P&C - FINPAL Euro Currency Exchange

USAA started reporting Euro currency and original currency to Financial General Ledger system for P&C -Auto, Property & Claims systems. Core idea of Euro Currency Exchange project is to generate Euro currency for all LTD-London Companies and carry original transaction currency for all claims data. All this data will be report to General Ledger.

Responsibilities:

●Performed requirements gathering, developed Analysis & Design document (A&D)

●Created UTP, UTR, Wisdom solution, ETL overview & Code walk through documents.

●Developed Jobs, Parameter files, scripts and scheduling jobs

●Involved in Netezza Database design and data modeling

●Extensively used stages like CDC, Joiner, Transformer, Funnel, Sequential, copy, Column Import, Column Export, modify, column generator, row generator

●Managed the authenticity of UNIX components by Checking-in & Checking-out code from IBM- RTC, a code versioning tool.

●Create BO universe and Report based on business requirement.

●Code migration from Dev to Test to Prod. Ensuring the Unit testing, Integration Testing, Job & Environment parameters testing along the way.

●Improved and enhanced various jobs inside different cycles by creating Reusable & Common jobs technique. Extensively used parameters at run time to push in job related parameters.

●Involved in Database design and data modeling

●Extensively used Parameter files, job Parameters

●Report work status on daily basis in daily stand-up meetings.

●Task Planning and Release planning

Tools & Environment: Datastage 11.5, SAP BO 4.1, OFSAA, Control-M Scheduler, IBM-RTC Version cotrol, DB2, Netezza,Oracle, SQL Server 2008 R2 /2005

United State Automobile Association (USAA), San Antonio TX Jan 2016 - Dec 2016

Technical Lead/ Developer

Projects: - P&C - SDS Interface

SDS - Staging Data Source

The data provided by the SDS helps model a direct relationship between the Operational and ADS- Analytical Data Source. The core idea to bring all Operational data to wear house and build reports for business.

WDS Project -Wildfire Response program Endorsement, USAA has tie up with WDS external vendor who support wildfire. USAA will provide weekly policy inforce member details to WDS vendor for supporting wildfire. Created new mapping to provide these details to WDS vendor.

Responsibilities:

●Performed requirements gathering, developed Analysis & Design document (A&D)

●Created UTP, UTR, Wisdom solution, ETL overview & Code walk through documents.

●on UNIX environment, created new Parameters, Scripts to be called in CONTROL-M.

●Developed Informatica Mappings, Mapplets reusable Transformations, tasks, sessions and Workflows, for daily process to load heterogeneous data into the data wearhouse. Source file include delimited flat files and DB2 tables.

●Extensively used transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy, Union, SQL and Sequence generator.

●Managed the authenticity of Jobs by Checking-in & Checking-out code from StarTeam, a code versioning tool.

●Create BO universe and Report based on business requirement.

●Transferring the contents of tables between 2 different environments using NZLOAD utility in Netezza

●Code migration from Dev to Test to Prod. Ensuring the Unit testing, Integration Testing, Job & Environment parameters testing along the way.

●Improved and enhanced various jobs inside different cycles by creating Reusable & Common jobs technique. Extensively used parameters at run time to push in job related parameters.

●Implemented Slowly Changing Dimensions(SCD), Type-1 and Type-2

●Involved in Database design and data modeling

●Report work status on daily basis in daily stand-up meetings.

●Task Planning and Release planning

Tools & Environment: Informatica 9.1, SAP BO, DB2, Netezza, UNIX, Control-M Scheduler

United State Automobile Association (USAA), San Antonio TX Feb 2015 - Dec 2015

Technical Lead/ Developer

Projects: - P&C - FINPAL Reinsurance

USAA P&C Financial System Automate reinsurance assumed and ceded activity process in operation area. Business used to perform this activity in CFO area. All this data will be report to General Ledger.

Responsibilities:

●Performed requirements gathering, developed Analysis & Design document (A&D)

●Created UTP, UTR, Wisdom solution, ETL overview & Code walk through documents.

●Developed Jobs, Parameter files, scripts and scheduling jobs

●Extensively used stages like CDC, Joiner, Transformer, Funnel, Sequential, copy, Column Import, Column Export, modify, column generator, row generator

●Managed the authenticity of UNIX components by Checking-in & Checking-out code from IBM- RTC, a code versioning tool.

●Create BO universe and Report based on business requirement.

●Code migration from Dev to Test to Prod. Ensuring the Unit testing, Integration Testing, Job & Environment parameters testing along the way.

●Improved and enhanced various jobs inside different cycles by creating Reusable & Common jobs technique. Extensively used parameters at run time to push in job related parameters.

●Involved in Database design and data modeling

●Extensively used Parameter files, job Parameters

●Report work status on daily basis in daily stand-up meetings.

●Task Planning and Release planning

Tools & Environment: Datastage 9.1, SAP BO 4.1, OFSAA, Control M scheduler, IBM-RTC Version control, DB2, Netezza,Oracle, SQL Server 2008 R2 /2005

United State Automobile Association (USAA), San Antonio TX Jan 2013 - Jan 2015

Developer

Projects: P&C - FINPAL Property Modernization

USAA migrated 30-40 years old legacy P&C Property Financial systems to new technologies ETL, OFSAA and SAP BO reporting. In this project we extracted all existing rules and implemented them in ETL, OFSAA and SAP BO reports.

Responsibilities:

●Performed requirements gathering, developed Analysis & Design document (A&D)

●Created UTP, UTR, Wisdom solution, ETL overview & Code walk through documents.

●Developed Jobs, Parameter files, scripts and scheduling jobs

●Extensively used stages like CDC, Joiner, Transformer, Funnel, Sequential, copy, Column Import, Column Export, modify, column generator, row generator

●Managed the authenticity of UNIX components by Checking-in & Checking-out code from IBM- RTC, a code versioning tool.

●Create BO universe and Report based on business requirement.

●Code migration from Dev to Test to Prod. Ensuring the Unit testing, Integration Testing, Job & Environment parameters testing along the way.

●Improved and enhanced various jobs inside different cycles by creating Reusable & Common jobs technique. Extensively used parameters at run time to push in job related parameters.

●Involved in Database design and data modeling

●Extensively used Parameter files, job Parameters

●Report work status on daily basis in daily stand-up meetings.

●Task Planning and Release planning

Tools & Environment: Datastage 9.1, SAP BO 4.1, OFSAA, Control M scheduler, IBM-RTC Version control, DB2, Oracle, SQL Server 2008 R2 /2005

United State Automobile Association (USAA), San Antonio TX Feb 2010 - Dec 2012

Developer

Projects: P&C - FINPAL Auto Modernization

USAA migrated 30-40 years old legacy P&C Auto Financial systems to new technologies ETL, OFSAA and SAP BO reporting. In this project we extracted all existing rules and implemented them in ETL, OFSAA and SAP BO reports

Responsibilities:

●Performed requirements gathering, developed Analysis & Design document (A&D)

●Created UTP, UTR, Wisdom solution, ETL overview & Code walk through documents.

●Developed Jobs, Parameter files, scripts and scheduling jobs

●Extensively used stages like CDC, Joiner, Transformer, Funnel, Sequential, copy, Column Import, Column Export, modify, column generator, row generator

●Managed the authenticity of UNIX components by Checking-in & Checking-out code from IBM- RTC, a code versioning tool.

●Create BO universe and Report based on business requirement.

●Code migration from Dev to Test to Prod. Ensuring the Unit testing, Integration Testing, Job & Environment parameters testing along the way.

●Improved and enhanced various jobs inside different cycles by creating Reusable & Common jobs technique. Extensively used parameters at run time to push in job related parameters.

●Involved in Database design and data modeling

●Extensively used Parameter files, job Parameters

●Report work status on daily basis in daily stand-up meetings.

●Task Planning and Release planning

Tools & Environment: Datastage 9.1, SAP BO 4.1, OFSAA, Control M scheduler, IBM-RTC Version control, DB2, Oracle, SQL Server 2008 R2 /2005

Sprint Corporation, Overland Park, Kansas Jul 2006 - Feb 2010

IBM Mainframe Developer

Projects: AMIS- Access Management Information System

Sprint Nextel one of the major telecom company which provides telecom service in USA. It is the fourth largest wireless network operator in the United States, and serves 58.8 million customers

also offers wireless voice, messaging, and broadband services. The company is headquartered in Overland Park, Kansas

This project involves enhancement and maintenance of the application which acts as the decision support data warehouse for dedicated and user access information used for cost and capacity management, facility assigned directions(ART) financial reporting and pricing analysis. Telecommunication access information is maintained in this application. DB2 batch programming is used to maintain the telecommunication access information in the DB2 tables.

Responsibilities:

●Performed requirements gathering and business community.

●Estimate the project based on requirements.

●Involve in analysis of requirement.

●Involve in software development plan for the requirements.

●Create design strategy documents for all impacted modules and for new functionality.

●Conduct design review.

●Construction and Debugging.

●Created UTP and UTR.

●Involve in system testing.

●Support E2E testing.

●Code migration from Dev to Test to Prod and warranty support.

Tools & Environment: COBOL II, DB2, VSAM, JCL, XPEDITOR, FILEAID, IBM DEBUG, FILE MANAGER, Pegasys, QMF, DB2 ADMIN, ECLIPSE

Contact this candidate