SUMMARY

• 7+ years of IT experience in Analysis, Design, Development, Implementation, Testing and supporting software applications in data warehousing and Client/Server environment.
• Involved in complete Software Development life - cycle (SDLC) of various projects, including requirements gathering, system designing, data modeling, ETL development, production enhancement, support and maintenance.
• Extensive experience in analysis and design of database including ER Diagrams and Normalization techniques.
• Experience with Star and Snowflake Schema, Data Modeling, Fact and Dimensional Tables and Slowly Changing Dimensions.
• Experience includes working in various industries like Retail, Telecommunication, Insurance, and Financial.
• Worked in all the phases of Data Warehousing life cycle for Data Warehouses and Data marts with ETL tools such as Accentual Data Stage 9.1/8.5/8.1/7.5/7.1 (DataStage Administrator, DataStage Designer, DataStage Director/QualityStage).
• Strong knowledge of UNIX shell scripting (C, Bourne, Korn and Bash shell), on AIX, HP and C, C++, Pearl, Ruby and Python Programming.
• Utilized SQL to extract data from various Database Stages (Oracle SQL, 11g/10g/ 8i/9i DB2 UDB, Teradata, and SQL Server)
• Developed parallel jobs using different processing stages like Lookup, Join, Merge, Transformer, Column Generator, Funnel, Filter, Switch, Modify, CDC, Pivot, Row Generator, and Lookup.
• Strong knowledge on SQL, Stored Procedures, Functions, Triggers.
• Created local and shared containers to facilitate ease and reuse of jobs.
• Strong understanding of the principles of DW using fact tables, dimension tables and Star and snowflake schema modeling.
• Basic knowledge in Teradata utilities like Fast Load, Multi Load and Fast Export, query tools BTEQ and SQL Assistant, Teradata SQL, Explain Plan, bulk loaders and un-loaders.
• Ability to develop Job Sequences with restart capability for the designed jobs using Job Activity, Exec Command, E-Mail Notification Activities and Triggers.
• Proven track record in addressing production issues like performance tuning, enhancement, data, environment and memory issues.
• Involved in Designing, Compiling, Testing, Scheduling, and running Data stage jobs.
• Expert in Data Warehousing techniques for Data Cleansing, Slowly Changing Dimension.
• Helped functional team in writing up of source to target mapping documents.
• Worked with UNIX shell scripting, FTP scripts and enhancing the job performance.
• Expertise in troubleshooting Data Stage jobs and addressing the production issues.
• Good knowledge on reporting tools like, Business Objects, Congas 7 and micro strategy.
• Good experience in scheduling Jobs using Autopsies, Tivoli, Control M and Corn tab.
• Execution of test plans for loading the data successfully into the targets.
• Highly adaptive to a team environment and proven ability to work in a fast paced teaming environment with excellent communication skills.

TECHNICAL SKILLS

Tools: ETL IBM Info sphere Data stage 9.1/8.5/8.1/8.0.1/7.5.2/7.1 (Administrator, Designer, Director, Manager, Parallel Extender/Orchestrate, Information Server, QualityStage), Information Analyzer, Information Stage, IBM Web Sphere Application Server

Databases: SQL Server 2003/2005/2008 , IBM DB2/UDB, Teradata, Oracle 10g/9i/8i,Green Plum 1.10

Operating Systems: Windows 2000/2003/XP/2007/2008, Windows 8, UNIX, Red Hat Linux, Red hat enterprise Linux 4 AS/3

Languages: SQL, PL/SQL, Unix Shell Scripting, Linux, Java

Scheduling Tools: Autopsies, Tivoli, Control M, Corn tab

Reporting Tools: Business Objects, Congas 7, crystal reports, micro strategy, Netezza

Other Tools: Erwin Data Modeler, Crystal Reports, SQL *Plus, Salesforce

Microsoft Tools: Excel, Word, PowerPoint, Visio, Moviemaker, Access

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Sr. Data stage developer

Responsibilities:

• Designed and developed Data Stage jobs for Loading Staging Data from different sources like Oracle, SQL Server DB into Data Warehouse applying business rules which consists data loads, data cleansing, and data massaging.
• Implemented Aggregate, Filter, Join, Lookup, Rank and Update Strategy transformations.
• Worked towards optimal performance when using Stages like LOOKUP, JOIN, and MERGE.
• Extracted data from various sources Flat Files, SQL server and loaded into a Corporate Data warehouse.
• Designed and developed Data Stage routines to populate the Meta data tables.
• For Parallel jobs, configured the multiple nodes and used parallel engine capacity efficiently as well as designed a master sequence to run multiple jobs in parallel.
• Used the Director to schedule running the job, testing and debugging its components, and monitoring.
• Responsible for data analysis, requirements gathering, report analysis, source-to-target mapping, frequency analysis, process flow diagrams, and documentation.
• Developed Job Sequencer to execute jobs in proper sequence. Also automated email messaging was implemented using Sequencer to notify the operations team of any data load issues such as job failure, dropped rows, rejected rows etc.
• Imported Oracle schema in to data stage with Manager for data mappings
• Handling both development and support teams.
• Used Multi-job-compiler during deployment of projects
• Assisted operation support team for transactional data loads in developing SQL&UNIX scripts.
• Worked with business analyst to identify, develop business requirements, transform it into technical requirements and responsible for deliverables.
• Provide the staging solutions for Data validation and Cleansing with Data Stage ETL jobs.
• Performed functional testing for new release enhancements.
• Participated actively in the team meetings with the developers for bug reviews.
• Worked with Developers to trouble shoot and resolve issues in job logic as well as performance.

Environment: IBM Info sphere Data Stage 9.1, Oracle10g/11g, SQL Server 2008/2005/2000 , UNIX, Control M, Salesforce

Confidential, Jersey City, NJ

Data stage Developer

Responsibilities:

• Involved in extracting the data from different data sources like Oracle 8i and flat files.
• Involved in extracting the data from staging to Relational.
• Involved in creating and maintaining Sequencer and Batch jobs.
• For Parallel jobs, configured the multiple nodes and used parallel engine capacity efficiently as well as designed a master sequence to run multiple jobs in parallel.
• Developed Sequences to run Dimensions and Facts and also developed a Master Sequence to run the entire project. Designed and developed of Data stage Server and Parallel jobs.
• Imported Oracle schema in to data stage with Manager for data mappings.
• Installed Data Stage clients /Servers and maintained metadata in repositories.
• Used Shared containers for multiple jobs, which have same business logic.
• Used Data Stage Manager for importing metadata from repository, new job categories and creating new data elements
• Tuned Data Stage jobs for better performance by creating Data Stage Hash files for staging data and lookups. Used Data Stage Director for running Jobs.
• Used Manager to import, export jobs / routines.
• Used the Slowly Changing Dimension Stage itself to implement SCD Type-1 & 2.
• Error handling was done by loading the reject data into the metadata and error tables.
• Resolved the error tickets by revisiting the jobs and
• Used XML Parser to parse the data
• Designed and developed Data Stage routines to populate the meta data tables

Environment: IBM Info Sphere Data Stage 9.1, Oracle11g, Oracle, Teradata, Flat files, UNIX scripting, MS Visio, IBM Info Sphere Information Analyzer, IBM AIX UNIX Shell, MS Office, ServiceNow

Confidential, Dallas, TX

Data Stage Developer

Responsibilities:

• Involved in creating Documentation like preparing high-level design and ETL Specifications.
• Used Parallel Extender for Parallel Processing for improving performance when extracting the data from the sources.
• Data is extracted from Oracle, UDB DB2 and populated into UDB DB2, Teradata.
• Worked in the upgrade from 7.5 to 8.1 data stage versions.
• Used various Parallel Extender Partitioning and collecting methods.
• Worked with Designer to create the Parallel jobs, Parallel Shared Container, Job Sequences.
• Extensively worked with various stages like Join, Merge, Lookup, Filter, Funnel, Column Generator, Change Capture, Change Apply, Aggregator, Transformer, Sequential File, Dataset, DB2 API and Oracle Enterprise stages.
• Extensively worked with Job sequences using Job Activity, Email Notification, Sequencer, Wait for File activities to control and execute the Data stage Parallel jobs.
• Created re-usable components using Parallel Shared containers.
• Used Data stage Manager for Configuring Configuration File like Adding Nodes, Removing Nodes, Reconfiguring Nodes and Exporting and importing the jobs in a project between the production and development servers.
• Used Data stage Manager for creating new job categories, creating new data elements and Data Stage Designer to standardize the changes made to the metadata.
• Used the Data stage Director extensively for testing the application on development.
• Used the Data stage Designer to develop the jobs and Director to compile and running the jobs.
• Used Teradata Tools.
• Generated ETL Scripts leveraging parallel load and unload utilities from Teradata.
• Worked with Data Stage Administrator for Creating Projects and Users and User rights.
• Involved in creating scripts for scheduling.
• Involve in Fine-tuning the Parallel jobs to improve the Performance.
• Developed Korn Shell scripts to automate the file manipulation and to execute the Data Stage jobs.

Environment: Accentual Data Stage 8.1/7.5, Accentual Data stage Version Control, AIXUNIX 5.2, Oracle 9.i/8.i, UDB DB2, Teradata, Erwin 4.1, Korn Shell, Autopsies.

Confidential, Plainsboro, NJ

Data stage Developer

Responsibilities:

• Worked in Operations management for Developing Data stage jobs.
• Created SQLStored procedures and queries and used in the parallel jobs.
• Used Data Stage Designer to develop various jobs to extract, transform, integrate and load data into data warehouse database.
• Responsible for requirements gathering, source-to-target mapping, process flow diagrams, and documentation for Data stage project.
• Used Lookup transformations to manipulate the information.
• Used SQL Developer to created SQL Scripts to load the History and compare the data in different environments.
• Worked with OBIEE testing team to analyze and debug the SQL generated to fix the errors.
• Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
• Extensively worked with CDC stage to capture the change records.
• Also worked on Developing Data stage Server jobs. Used Data Stage manager to export the jobs
• Provided Support during the implementation of the project.

Environment: Accentual Data Stage 7.5.1 Enterprise Edition (Designer, Manager, Director), Oracle, UNIX, Autopsies Scheduling Tool, SQL Developer.

Confidential, San Francisco, CA

Data stage Developer

Responsibilities:

• Complex SQL queries are used for data retrieval.
• Verification of functional specifications and review of deliverables.
• Developed a complex SQL code to use in the common code approach to avoid writing several SQL scripts for different source table/file formats.
• Performance tuning of SQL queries consisting of many tables with large amount of data.
• Created Procedures and Functions that extensively used PL/SQL cursors, user defined object types and exception handling.
• Preparing Technical Design Documents for various interfaces between several applications that have been designed in the project.
• Extensively used Oracle Loader and PL/SQL for ETL.
• Identified business rules for data migration and perform data administration through data models.
• Enhancements and Functional Specifications.
• Optimized Query Performance, Session Performance and Reliability.
• Extensive query optimization and performance tuning.

Environment: Oracle, SQL, PL/SQL, UNIX and SQL*Plus