SUMMARY

• Have 10+ years of IT experience in Data Warehousing application development and full life cycle implementations including analysis, design, development, testing, deployment, post - production support/maintenance, documentation.
• Have 7 Strong work experience onIBM Info Sphere server DATASTAGE 8.x.,7.5.x, Unix Shell Scripting, Scheduling tools like Autosys, MQFTE Oracle and DB2
• Worked on DataStage tools likeDataStage Designer, DataStageDirector and DataStage Administrator.
• Expertise in translating business requirements into Data warehouse and Datamart design and developing ETL logic based on the requirements using DATA STAGE.
• Knowledge in designing Star Schema and Snowflake Schema in implementing
• Strong working experience with Flat files, Delimited files, Oracle, SQL Server, DB2, Teradata, Netezza, including database development, PL/SQL, Stored Proc, query tuning, indexes
• Prepare the TDD's for the all DATA STAGE jobs designed
• Experience in usingshell scripting for automation of DATA STAGE jobs
• Experience handling mainframe based application using mainframe technologies like COBOL II,JCL and DB2 on OS\390 platform
• Experience inscheduling the jobs through Autosys JILandBatch process automations
• Experience in Agile methodologies
• Interacted extensively with clients to gather requirements and perform analysis and design to meet end user requirements.
• Performed debugging, troubleshooting, monitoring and performance tuning using DATA STAGE.
• Self-driven to accomplish goals and meet deadlines. Provided 24/7 production support.
• Highly motivated team player with ability to lead, manage and work in all environments to meet deadlines.

TECHNICIAL SKILL

ETL Tools : IBM InfoSphere DATA STAGE 8.x.0/7.x

Database : Teradata, SQL Server 2000, Oracle 11g,DB2, Netezza

Mainframe: COBOL

Web Technologies: ASP 3.0, CSS, HTML,DHTML,XML

Scripting: VB Script, Java Script,MQFTE

Operating System: Windows NT/2000 Server, UNIX,AIX

Other Tools : TOAD, AUTOSYS, Bi-Query

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. Datastage Developer

Responsibilities:

• Analyzed the source/ target systems to aid the design of the Data stage jobs
• Implementing the new logic according to the change request into the existing Data stage server jobs
• Preparing the Technical Design document and unit Test case /results.
• Reviewing the Technical Design document and unit Test case/ Results with Business Analyst
• Raising CAB request for prod migration and supporting to move the code all the way from DEV to production environment.

Confidential, Plainsbro, NJ

Sr. Datastage Developer

Responsibilities:

• Analyzed the source/ target systems to aid the design of the Datastage jobs
• Redesigned the Job to read the new products using Confidential Infosphere Data Stage Tool and processed the Business Logic and loaded the Data to the Staging Tables into Database using Oracle Connector.
• Used the Data stage Designer to developed Parallel Jobs for extracting, cleansing, transforming, integrating, and loading data into Corporate Data warehouse Database Oracle.
• Used the Data Stage Director and its run-time engine for the Test solutions and debugging its components, and monitoring the resulting executable versions
• Used several stages like Sequential file, Oracle connector, Oracle Enterprise, Sort, Dataset, Sequencer, Transformer, Lookup, XML during the development process of the DATA STAGE jobs
• Develop Technical designs that will be performed in DataStage ETL & Oracle.
• Performed Unit testing and validated the test cases by comparing the actual results with expected results.
• Review the Datastage jobs /Unit Design documents with team.

Confidential, Iselin, NJ

Sr.Data Stage Developer

Responsibilities:

• Responsible for assisting in customization and development of application systems.
• Designs, programs, and codes software in response to specific business requirements.
• Understands how to optimize joint development efforts through appropriate project design, database use, code creation, and software architecture.
• Develops design specifications in compliance with IT Architecture.
• Worked onDatastageDesigner,Administrator and Director.
• Used several stages like Sequential file, ODBC connector, Remove Duplicate, Sort, Dataset, Sequencer, Aggregator, Funnel, Transformer, Merge, Join, Lookup, Copy, Shared Container, XML during the development process of the DATA STAGE jobs
• Quickly understand the existing development & production environment and tool sets Work closely with the business analysts to understand the requirements for functional design.
• Develop Technical designs/Unit Design documents for unit of work that will be performed in DataStage ETL, ORACLE, and UNIX, Shell Scripting etc.
• Preparation of Autosys jils for scheduling the ETL jobs.
• Develop the MQFTE Jobs to transfer the files
• Develop and trouble shoots DataStage parallel jobs, SQL/PLSQL, autosys code.
• Tests and validates developed code.
• Support the execution of the Integration/UA

Environment: Confidential InfoSphere DATA STAGE 8.x, TOAD, Unix, Oracle 9i, Star team, Autosys, MQFTE, Eagle pace

Confidential, Charlotte, NC

Datastage Lead

Responsibilities:

• Interacted with business users in gathering the business requirements, identifying the relationship within and between the groups of data.
• Responsible for effective communication between the project team and the customer. Provide day to day updates to the and regular Deliverable’s status to the customer.
• Creating effort estimation for the project requirements
• Coordinate with Bank Associates and closely monitor the project requirements and design
• Involved in the design of Functional Design Specification and Technical Transformation Design Technical Specification and getting a sign off from business.
• Developed Datastage parallel jobs in Desinger to Extract data from the sources Flat files and CSV files and load into staging tables
• Designed and developed Master controlling sequencer jobs using the DataStage Job Sequencer.
• Preparation of technical specification for the development of Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards.
• Maintained naming standards and warehouse standards while designing the datastage jobs and creating DB tables
• Worked onDatastageDesigner, Administrator and Director.
• Used several stages like Sequential file, ODBC connector, Remove Duplicate, Sort, Dataset, Sequencer, Aggregator, Funnel, Change capture, Transformer, Merge, Join, Lookup, Copy,XML during the development process of the Data Stage jobs
• Extensively used slowly changing dimension Type 2 approach.
• Incorporation of various Data sources from various database technologies
• Designed Technical design Documents to submit to the Client
• Used Data Stage Director for running and monitoring & scheduling the jobs and to see the log files in case of aborted jobs.
• Worked extensively on performance tuning to cut down the Data stage process time.
• Performed Unit Testing using job sequence.
• Preparation of Autosys jils for scheduling the ETL jobs.

Environment: Confidential Infosphere DataStage 8.5, TOAD, Unix, Oracle 9i, SQL Server, DB2, Netezza Subversion Tool, Autosys, Maximo

Confidential, Franklin Lakes, NJ

Sr.Data Stage Developer

Responsibilities:

• Extensively involved in determining the data needed to address business users analytical requirements and design data models to support this analysis
• Moved Jobs from Dev Environment to QA Environment for Testing and then moved to Production Environment.
• Used DATA STAGE Manager for importing metadata into repository and also used for Importing and exporting jobs into different projects.
• ImplementedPL/SQL scriptsin accordance with the necessaryBusiness rules and procedures.
• Developed PL/SQL procedures & functions to support the reports by retrieving the data from the data warehousing application.
• Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development
• Worked onDatastageDesigner, Manager, Administrator and Director.
• Worked with stages like Data Set, Modify, Change Data Capture, Merge, Join, Lookup, ODBC, Sort, Transform stage
• Created Projects thru administrator and Defined user defined Environment Variables
• Used the DATA STAGE Director to run, monitor, and test the application on development, and to obtain the performance statistics.
• Tuning of the jobs and queries to improve the performance.
• Code migration was done from time to time in a proper methodology by filling the migration request forms
• Interpret existing JCL/Cobol programs and make changes as per the requirements.
• Successful completion of the module within the time frame and Participated in UAT (User Acceptance Testing).
• Prepared technical specification Document for the development of DATA STAGE Extraction, Transformation and Loading (ETL) source to target mappings to load data into various tables and defining ETL standards.
• Created Reports and Modified Existing Jobs for better performance.

Environment: Ascential DATA STAGE EE 7.5.1 (Designer, Director, Manager, and Administrator), Teradata, Oracle 9i, SQL Server, DB2, UNIX and Citrix, Mainframe COBOL

Confidential, Palo Alto, CA

Sr.Software Engineer

Responsibilities:

• Worked with Business Analysts to analyze the business requirements and functional specifications
• Involved in extracting the data from different data sources like Oracle and flat files.
• Was also involved in extracting the data from staging to Relational.
• Played an active role in creating and maintaining Sequencer and Batch jobs.
• Developed Parallel jobs using Processing Stages such as Funnel, Join/Merge, Lookup, Sort, Filter, Remove Duplicates and Transformer, ODBC connector, sequential, dataset
• Designed ETL Job flow design.
• Employed ETL to load data into the SQL Server warehouse.
• Utilized the designer and director to schedules and monitor resulting executable versions.
• Was instrumental in creating local and shared containers to facilitate ease and reuse of jobs.
• Played a proactive role in Managing Repository Metadata from Manager.
• Was also involved in Performing Unit Testing and Integration.
• ImplementedPL/SQL scriptsin accordance with the necessaryBusiness rules and procedures.
• Developed PL/SQL procedures & functions to support the reports by retrieving the data from the data warehousing application.
• Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers.
• Documented the Purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes as and when necessary.
• Used Sequential debugging in parallel programs on Orchestrate environment.
• ETL standards were maintained and implemented them into all the jobs/routines and peer code review was also done.
• Maintaining production environment and supporting the application 24/7.
• Email tasks to notify the distribution list or production support team on success or failure of a process.
• Analyzed the performance of the jobs and enhance the performance using the standard techniques & best practices

Environment: DATA STAGE 7.5,SQL Server 2000, Oracle 9i, Windows NT4.0,Toad,Unix,Citrix

Confidential

Software Engineer

Responsibilities:

• Developed and created interfaces from various applications within and SQL Server 2000
• Creating and maintaining ERP designs and coding standards as well as providing custom coding.
• Noting down the requirements and operative patterns for small to big reports and projects
• Gaining an insight into the present trading procedures and preparing recommendations for changes that may have better effectiveness and quality.
• Encountering end users to study business methods, realize needs, and recommending technical answers
• Creating and making architecture and technical documents up to date for follow up and approval
• Repairing software defects, bringing out testing ideas for different units, and checking software, interfaces, and schemes
• Keeping himself up to date with the latest technologies. Listing all functional and operational data necessary for preparation
• Solving doubts by gathering information

Environment: ASP, HTML and SQL Server 2000, JavaScript