SUMMARY:

• IT: 8.0 years of experience in the field of Information Technology with solid experience in Data Analysis, Design and Development. Experience in the field of Information Technology with solid experience in Software Analysis, Design and Development. Experience in Data warehousing and application development across various verticals.
• Data stage: 5.5 years of extensive experience with Data Warehousing using IBM Data stage PX/EE 8.1/7.5.2/7.5/7.1 (Administrator, Manager, Designer, Mainframes, Director, Parallel Extender, Quality Stage7.5 (Integrity),IBM Information Analyzer, DS Universal Basic Code, LAP and OLTP along with Data Management.
• Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling and Erwin 6.x/4.x/3.x. Proficient at Enterprise Database Integration and Management among Sybase, Oracle, MS Access, Teradata, MS SQL Server and DB2.
• Data Cleansing: Expertise in designing and developing strategies for Data Cleansing using various tools like Quality Stage, Integrity, as well as using SQL and UNIX scripts.
• Scripts: Extensively written Unix Shell Scripts, PERL scripting for the automation of various ETL scripts as well as for scheduling ETL jobs.
• Automation tools & Utilities: Autosys, Control-M, Crontab, Clear Case, Visio, Remedy.
• Programming Languages: C, C++, PL/SQL, COBOL,
• Database Oracle 10g/9i/8i/8.0/7.3, SQL, PL/SQL, SQL*Loader, Stored Procedures, TOAD, Explain Plan, Ref Cursors, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities, V2R6/V2R5/V2R3, IBM DB2 UDB 8.0/7.0, DTS, MS SQL Server 2005/2000/7.0/6.0, Sybase 12.x/11.x, MS Access.

TECHNICAL SKILLS:

ETL: Ascential Data stage PX/EE 8.1/7.5.2/7.1. A/6.0/5.x (Administrator, Manager, Designer, Director, Parallel Extender, Quality Stage7.5/Integrity, Mainframes, OLAP, OLTP, SQL*Plus, SQL*Loader

Business Analysis: Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, Data Analysis, Requirements Analysis, Design, Data Modeling, Data Architecture, Data Flow, Data Cleansing

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 6.1.0/4.5/4.0/3.5, Oracle Designer, Visio and Sybase Power Designer.

Data Cleansing: XML,SQL Scripts, PERL scripting and Unix Scripts

Data Modeling Tools: Erwin 4.0, Designer 2000, Star Schema, Snowflake Schema

RDBMS: Oracle 10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005/2000/7.0/6.0, Teradata V2R6/V2R5/V2R3, Sybase 12.x/11.x, MS Access,IMSOperating Systems Sun Solaris 2.6/2.7, HP-UX 10.20/9.0, IBM mainframe Environment, IBM AIX 4.2/4.3, MS DOS 6.22, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win NT, Red Hat Linux, Sun-Ultra,, SCO Unix, HP9000, RS6000, Win 3.x/95/98, Win 2000, Win XP. MS-Dos

Programming Languages: PL/SQL,VB 6.0,COBOL,JCL,CICS

PROFESSIONAL EXPERIENCE:

SR.Data Stage Developer

Confidential

Responsibilities:

• Used Parallel Extender for distributing load among different processors by implementing pipeline and partitioning of data in parallel extender.
• Involved in Designing Parallel Extender Jobs.
• Worked with Business customers to identify the different sources of data in operational systems and developed strategies to build data warehouse.
• Preparation of technical specification for the development of Extraction, Transformation and Loading (ETL) jobs to load data into various tables in Data marts.
• Used Parallel Extender for distributing load among different processors by implementing pipeline and partitioning of data.
• Used COBOL programs to extract and transform data from the mainframes and create a load ready file.
• Developed JCL Jobs and scheduled jobs to execute COBOL programs to extract data from Mainframe
• Created containers to use in multiple jobs.
• Used debugger to test the data flow and fix jobs.
• Defined data base triggers & PL/SQL stored procedures for business validations.
• Extensively wrote Routines and Transforms.
• Created and Monitored sequences using Data stage sequencer
• Extensively used Parallel Stages like Join, Merge, Lookup, Filter, Remove Duplicates, Funnel, Row Generator, Modify, Peek etc. for development and de-bugging purposes
• Extensively worked with Data Stage Job Sequences to Control and Execute Data Stage Jobs and Job Sequences using various Activities and Triggers.
• Used Data Stage Director and the runtime engine to schedule running the server jobs, monitoring scheduling and validating its components.

Environment: IBM Web Sphere Data Stage 8.5 and 8.1, IBM-AIX, DB2,Oracle 10g,UNIX, MICROSOFT VISIO, ZEEKE, SQL plus, win scp, COBOL,JCL,SAS

Confidential

SR.Data Stage Developer

Responsibilities:

• Involved in understanding the scope of application, present schema, data model and defining relationship within and between the groups of data.
• Interaction with the business users to better understand the requirements and document their expectations, handling the current process, modifying and created the jobs to the updated requirements, handle the load process to data mart and eventually data warehouse.
• Used the Ascetical Data Stage 7.5 extensively to transfer and load data into the staging area and eventually into Warehouse.
• Extensively used the Sequential File Stage, Dataset Stage, File set Stage, Modify Stage, Look-up, transformation and other Database plug-ins and the stage provided by the Data Stage to perform transformation and load the data.
• Designed Mappings between sources to operational staging targets, using Star Schema, Implemented logic to Slowly Changing Dimensions.
• Designed a job template that provides the Environmental parameters for the subsequent use in the projects.
• Extensively used Microsoft Visio for documentation and control m to schedule the jobs.
• Worked with Business users to fix defects and implemented the best practices for conducting best UNIT TESTING and INTEGRATION TESTING and documenting the test results for USER ACEPTENCE.

Environment: IBM Web Sphere Data Stage 7.5.1, IBM-AIX, DB2,Oracle 10g,oracle 11g, UNIX, MICROSOFT VISIO, control-M, SQL plus, Hummingbird,COBOL,JCL.

Confidential

SR.Data Stage Developer

Responsibilities:

• Used Parallel Extender for distributing load among different processors by implementing pipeline and partitioning of data in parallel extender.
• Involved in Designing Parallel Extender Jobs.
• Worked with Business customers to identify the different sources of data in operational systems and developed strategies to build data warehouse.
• Preparation of technical specification for the development of Extraction, Transformation and Loading (ETL) jobs to load data into various tables in Data marts.
• Used Parallel Extender for distributing load among different processors by implementing pipeline and partitioning of data.
• Developed several complex Data Stage jobs for loading Participants to the data warehouse.
• Provide technical support to team members for Design And developing Data stage Jobs.
• Used Data Stage Director and the runtime engine to schedule running the server jobs, monitoring scheduling and validating its components.
• Used Basic Routines to pass values from Sequencer to jobs in runtime.
• Coded Parallel Routines in C++ to cleansing and format data in Transformer.
• Good Experience in working with Control M for Scheduling daily and monthly ETL’s Jobs
• Worked with Business users to fix defects and implemented the best practices for conducting best UNIT TESTING and INTEGRATION TESTING and documenting the test results for USER ACEPTENCE.
• Involved in daily meetings with the client for requirements and provide services to meet the required SLAs.
• Extensively worked with DataStage Job Sequences to Control and Execute DataStage Jobs and Job Sequences using various Activities and Triggers.
• Performed troubleshooting, maintenance and performance tuning of Data Stage Jobs and SQL statements.
• Used the Data Stage Director for monitoring the jobs and debugging the Issues.
• Worked with Data Stage Manager for importing and exporting the DSX of the jobs.
• Designed and developed Master controlling sequencer jobs using the Data Stage Job Sequencer.
• Implementing performance-tuning techniques along various stages of the ETL process

Environment: IBM Web Sphere Data Stage 8.1.1/7.5.2 EE (Parallel Extender, Designer, ManagerAdministrator, Director), Oracle 10g, DB2UDB, SQl, PL/SQL, Shell Scripting, UNIX, Control-MWell mark

Confidential

Data Stage Developer

Responsibilities:

• Used Parallel Extender for distributing load among different processors by implementing pipeline and partitioning of data in parallel extender.
• Involved in Designing Parallel Extender Jobs.
• Worked with Business customers to identify the different sources of data in operational systems and developed strategies to build data warehouse.
• Preparation of technical specification for the development of Extraction, Transformation and Loading (ETL) jobs to load data into various tables in Data marts.
• Used Parallel Extender for distributing load among different processors by implementing pipeline and partitioning of data.
• Used COBOL programs to extract and transform data from the mainframes and create a load ready file.
• Developed JCL Jobs and scheduled jobs to execute COBOL programs to extract data from Mainframe
• Developed several complex Data Stage jobs for loading Participants to the data warehouse.
• Provide technical support to team members for Design And developing Data stage Jobs.
• Extensively used Parallel Stages like Join, Merge, Lookup, Filter, Remove Duplicates, Funnel, Row Generator, Modify, Peek etc. for development and de-bugging purposes.
• Used DataStage Director and the runtime engine to schedule running the server jobs, monitoring scheduling and validating its components.
• Used Quality Stage to profiling, standardization, matching and survivorship.
• Used Basic Routines to pass values from Sequencer to jobs in runtime.
• Coded Parallel Routines in C++ to cleansing and format data in Transformer.
• Extracting data from legacy mainframe operation systems, transferring the data to AIX platform, loading the data into Data Marts using complex flat file Stage.
• Worked with Business users to fix defects and implemented the best practices for conducting best UNIT TESTING and INTEGRATION TESTING and documenting the test results for USER ACEPTENCE.
• Created Oracle Stored Procedures for create partition on target table and Rebuild index for performance tuning.
• Used Control-M to Schedule jobs in SAT, PERFORMANCE and PROD Environments.
• Developed korn Shell scripts to automate file manipulation and FTP files.

Environment: IBM Web Sphere Data Stage 8.1/7.5.2 EE (Parallel Extender, Designer, ManagerAdministrator, Director), Oracle 10g, Sybase IQ, DB2UDB, SQl, PL/SQL, Shell Scripting, COBOL, MVS, DB2, UNIX, Control-M, PVCS

Confidential

Data Stage Developer

Responsibilities:

• Developed several transformations in the process of building Data warehouse database.
• Used server jobs to Extraction, Transformation and Load.
• Analyzed and designed source code documentation for investment Data Warehouse.
• Used DataStage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
• Generating of unique keys for composite attributes while loading the data into Data Warehouse.
• Used COBOL programs to extract data from the mainframes and create a load ready file.
• Used DataStage Manager for managing DataStage repository (view and edit), define custom routines & transforms, Import and export items between different DataStage systems or exchange metadata with other data warehousing tools.
• Extensively used Parallel Stages like Join, Merge, Lookup, Filter, Remove Duplicates, Funnel, Row Generator, Modify, Peek etc. for development and de-bugging purposes
• Extensively worked with DataStage Job Sequences to Control and Execute DataStage Jobs and Job Sequences using various Activities and Triggers.
• Used DataStage Director and the runtime engine to schedule running the server jobs, monitoring scheduling and validating its components.
• Used Hashed file to extract and write data and also to act as intermediate file in a job. Hashed file is also used as table based on single key field.

Environment: DataStage 7.5, Oracle 8i, SQL Server 2000, DB2 UDB, SQl, COBOL, JCL

Confidential

Programmer

Responsibilities:

• Requirement gathering from Business partners and translate into software needs
• Design the application by interacting with other Bank of America applications.
• Preparing high Level and Low-level design documents.
• Development and testing
• Support for System Integration testing and User Acceptance testing
• Project Management

Environment: IBM Z/OS, OS/390, COBOL,DB2,JCL,VSAM, ISPF, QMF, SPUFI, XPEDITER, Endeavor, File Aid and File Aid for DB2.