SUMMARY:

• 8 + years of IT experience in various technologies like IBM Data stage and Mainframe with project involving Development, Maintenance, Enhancement and testing.
• Having 4.5 years of experience as an ETL Developer using Data Stage Parallel Extender for both support and development.
• Used Datastage 9.1,8.7 and 8.1 as ETL Tool for Extracting data from various sources like Databases, Flat files and load into target systems.
• Familiar with functionalities of Data Stage client components like Designer, Director.
• Fair knowledge in development Life cycle of Enterprise warehouse and Strong understanding of the principles of Data Warehouse concepts and Dimensional modeling.
• Experience in implementation of transformations like Data Cleansing, Data Scrubbing to improve the quality of data and Worked on Data Transformations, Data Loading, and Data Type Conversion.
• Extensively used Database stages like Oracle, SQL Server, DB2, Teradata and Netezza.
• Good working knowledge on monitoring the jobs using Control - M Scheduler.
• Good knowledge in UNIX commands.
• Smart communication of working with a team and be a part of a successful team.
• Exposed to various Domains of Data warehouses like Banking, HealthCare and Retail.
• Enjoy challenging and thought provoking work and have a strong desire to learn and progress (motivated enough to self learn) Ability to pick up new technology independently.

TECHNICAL SKILLS:

Hardware: IBM PC Compatibles

Operating systems: MVS,ZO/S Windows 98, 2000, XP.Windows 7

Languages: COBOL, Easytrieve, C, SAS

DBMS: IMS DB.DB2

OLTP: CICS

Data Access method: VSAM

Job Process: JCL

Editors: ISPF/PDF

Tools: CHANGEMAN, FILEMASTER, INTERTEST, SDF, QMF, SPUFI,FILEAID,EXPEDITOR,ENDEAVOR

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• USAA has three Holders - Life(000001), P&C (000002) and BANK (000017). Each holder has its own Tax identification Number(TIN).
• Confidential receives item information through both online entry and interfaces with other systems. Confidential cycle processes on a daily basis Sunday through Friday.
• Chesapeake System Solutions, founded in 1993, is an industry leader in the development and delivery of automated solutions for financial management.
• Chesapeake unclaimed Property suits consists of various modules. At the core is the Confidential system that maintains and manages unclaimed properties.
• Confidential is an automated non-financial framework to maintain and manage unclaimed cheques and properties.
• They normally send cheques, member information’s that possess unclaimed cheques and search letters(send letters to members whose cheques are not claimed).
• The inputs to Confidential are from Chesapeake System( Confidential System - Online), Accurate and Peoplesoft(for member info like member no, address) and Search letters.
• Confidential send information’s about cheques to IMCO, Life, Bank, Peoplesoft, Accurate and P & C.
• Certain files are sent to a documentation team called MCM Team. This Team validates the cheques and information’s from there and send the data to B2B.
• Analysis and documentation of existing system. Working on GAP Analysis document and Mapping Doc for various phases of the Project.
• Develop jobs in data stage to fix the ongoing and historical data issue in business DW/DM.
• Writing shell scripts based on requirements.
• Involved in review of Technical, Business Transformation Requirements, Designs
• Handling the production issues.
• Extracted data from application data base as sources like dynamic RDBMS, TeraData connector stage
• Involved in design, mappings between sources to operational staging targets, using data stage designer.
• Extensively worked on different stages in Parallel extender such as Aggregator, Join, Lookup, Sort, Merge, Funnel.
• Worked on Slowly Changed Dimensions
• Experience in running jobs using Job Sequencers and Control-M.
• Involving in performance tuning jobs process identifying and resolve performance issues.
• Write complex extract queries for the source data.
• Actively participated in the Team meetings to gather the business requirements and developing the Specifications.
• Involved in unit testing and fixing bugs.

Confidential

Responsibilities:

• Extensively worked on ODBC, Lookup, Dataset and Sequential file for the different Subject Areas.
• Worked with DataStage Designer for importing metadata from repository, new job Categories and creating new data elements.
• Extensively worked on different stages in Parallel extender such as stored procedure, Join, Lookup, Sort and Funnel.
• Worked on several Development/Debug Stages.
• Running jobs using Job Sequencers.
• Preparing audit table using routines
• Involving in performance tuning jobs process identifying and resolve performance issues.
• Write extract queries for the source data using Unions, joins
• Performed Unit Test Cases for jobs.

Confidential

ETL Developer

Responsibilities:

• · On-line screens for data capture and inquiry
• · Premium determination (Rating)
• · A work in process control mechanism (Workflow)
• · Policy analysis support (Worksheets)
• · Policy detail record feeds to batch processing
• · CICS for data capture and display
• · VSAM Files for data storage, DB2 for few applications.
• · COBOL for application programs
• · An extensive set of editing, control, and factor Tables
• · Tables are managed by the Table Management Facility (TMF)

Confidential, NY

ETL Developer

Responsibilities:

• Confidential is the world’s largest direct selling company of beauty products, with operations in more than 60 countries and products sold in over 120 countries.
• The system processes and maintenance of the database dealings with direct selling business are spread across USA over 4 regions (ATLANTA, NEWARK, MORTON GROVE and PASADENA).
• These 4 regions are further divided into divisions and districts. The key dimensions of the business are the products, employees, representatives who sell the products, orders, and the time of orders. Confidential identifies its sales and processes orders in time periods termed as campaigns.
• The business is streamlined by assigning Mail-plan by to each district for placing orders.
• Both online and batch programs processes the orders placed by the representatives (customers). They also provide interim information about the representatives and order status in different campaigns and each mail-plan.
• This process also includes maintaining the information about district and division managers. These orders can be placed on-line also. So, the mainframe system links to various other systems like client-server, to co-ordinate the business. The data is maintained on DB2, IMS databases and VSAM files.

Confidential, NY

Responsibilities:

• Analysis of the requirements
• Coding new programs and enhancements in batch environment
• Provide the maintenance support like bug fixing to the existing business applications
• Code reviews
• Provide unit testing and integration testing support to the changes
• Status reporting to the client and management
• Prepare application and technical documentation