PROFESSIONAL SUMMARY

• More than 8 years of experience in IT industry especially in client/server business systems and Decision Support Systems (DSS) analysis, design, development, Testing and implementation.
• Over 8+ years of experience in loading and maintaining Data Warehouses and Data Marts using tools such as Data Stage ETL processes, Profiling, Quality Stage 6.X, Quality Stage 9.X and IBM Information Server 9.0 (Integrated Data Stage and Quality Stage).
• Strong knowledge of Extraction Transformation/Verify and Loading (ETL/EVL) processes using Ascential Data Stage, UNIX shell scripting, and SQL Loader.
• Expertise in working with various operational sources like DB2, DB2UDB, SQL Server, Oracle, Teradata, Sybase, Flat Files into a staging area.
• Extensively worked on Parallel Extender on Orchestrate Environment for splitting bulk data into subsets and to dynamically distribute to all available processors to achieve job performance.
• Experience in Evolving Strategies and developing Architecture for building a Data warehouse by using data modeling tool Erwin.
• Designed and Developed Data Models like Star and Snowflake.
• Excellent database migration experience in Oracle 9i /11, DB2UDB, MS SQL and SQL.
• Hands on experience in writing, testing and implementation of the triggers, Procedures, functions Confidential Database level using PL/SQL.
• Excellent experience in XML stages like XML input, XML transform and XML output stages.
• Extensive experience in loading high volume data, and performance tuning.
• Played significant role in various phases of project life cycle, such as requirements definition, functional & technical design, testing, Production Support and implementation.
• Experienced in manufacturing Industry maintaining sales, inventory, profit & loss, HR, product category and time.
• Extensive experience in loading high volumes of data.
• Excellent team member with problem - solving and trouble-shooting capabilities, Quick Learner, highly motivated, result oriented and an enthusiastic team player.

TECHNICAL SKILLS

ETL tool: IBM Data Stage 5.X/6.0XE/7.5/8.7XI,9.1, INFORMATICA, SAP BW

OLAP Tools: BUSINESS OBJECTS 4.1/5.0/5.1 (Supervisor, Designer, Reports, Broadcast Agent, Set Analyzer), WEB INTELLIGENCE 2.5 / 2.6, SDK, HIPAA EDI X12 transactions like 834, 837, 835, 270, 271, 276, 277

Programming Languages: COBOL, C, C++, JAVA (1.2), SQL, PL/SQL, and TOAD

Internet Technologies: HTML 4.0, JAVASCRIPT 1.2, JSP, IIS (8.0) and SERVLETS.

Databases: ORACLE 9i, SQL SERVER 7.0, DB2, Teradata, GreenPlum 4.2.

Data Modeling Tools: ERWIN, ORACLE DESIGNER, Unix AWK, NAWK, windows power shell.

GUI: ORACLE D2K with FORMS4.x/5.x/6.x, REPORTS 4.x/5.x/6.x, APPLETS, VISUAL BASIC 5.0, Visual C++, CRYSTAL REPORTS.

Hardware: SUN SPARC, IBM COMPATIBLE PC.

Operating Systems: Windows NT/2000, UNIX, AIX, Solaris.

PROFESSIONAL EXPERIENCE

Confidential, WA

Sr.ETL Developer

Role & responsibilities:

• Involved in all phases of SDLC.
• Responsible for creating detailed design and source to target mappings.
• Responsible to communicate with business users and project management to get business requirements and translate to ETL specifications.
• Used DataStage/QualityStage Designer to import/export jobs, table definitions, Custom Routines and Custom Transformations.
• Created Extract Transform and Load (ETL) interfaces and gateways for backend database.
• Designed Mappings between sources to operational staging targets, using Star Schema, Implemented logic for Slowly Changing Dimensions (SCD).
• Extensive hand on experience on design and developing Parallel and server jobs.
• Extensively worked on building datastage jobs using various stages like Oracle Connector, Funnel, Transformer stage, Sequential file stage, LookUp, Join and Peek Stages.
• Extensively used Sort, Merge, Aggregator, Peek, Dataset and Remove Duplicates stages.
• Involved in the migration of DataStage jobs from development to QA and then to production environment.
• Created shared containers to use in multiple jobs.
• Technical and analytical skills with clear understanding of design goals ofER modelingforOLTPand dimension modeling forOLAP.
• Hands on experience upgrading datastage.
• Created Unix shell scripts to run and monitor the jobs and also to execute commands.
• Imported and exported Repositories across DataStage projects using datastage designer.
• Extensively worked on DataStage Job Sequencer to Schedule Jobs to run jobs in Sequence.

Environment: Erwin, DataStage 9.1/11.3, PS EPM PeopleSoft, Oracle 11, DB2 UDB, JDE, AIX,MS Excel 2000, SQL Server 2012, cognos, GreenPlum 4.2, windows power shell, WEBI, SQL Navigator, SQL * Loader, Mainframes, AS400 (iSeries)

Confidential, CA

Sr.ETL Developer

Role & responsibilities:

• Involved in Analysis, Requirements gathering, function/technical specification, development, deploying and testing.
• Created snapshot for the transactional tables in distributed databases.
• Analyzed existing legacy data source and extracted data from it using Datastage.
• Involved in critical multiple instance datastage jobs which will send the outbound files for different Lobs (line of business) Confidential the same time and monitored the jobs accordingly.
• Scheduled the parallel jobs using Datastage Director, which is controlled by DataStage engine and also for monitoring and performance statistics of each stage.
• Used ALTOVA Mapforce Tool to do mapping between source and destination XML and CSV files and exported table definition using datastage director.
• Created Error Tables containing data with discrepancies to analyze and re-process the data.
• Extensively used Parallel Stages like Join, Merge, Lookup, Filter, Aggregator, Modify, Copy, Sort, Funnel, Change Data Capture, Remove Duplicates, Surrogate key Generator, Row Generator, Column Generator, and Peek for development and de-bugging purposes.
• Used DataStage Manager to Import and Export DataStage components and Import table definitions from source databases.
• Used the Folder stage and RTI stage to extract data from .xml type files and load into Oracle database.
• Execute Backend Testing application by writing complex SQL Queries.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages and triggers for the ETL processes.
• Wrote SQL scripts to create and drop the indexes those are passes as parameters in the pre & post sessions.
• Removed errors while migrating jobs from datastage 7.5 to 8.0.
• Developed Unix shell scripts for job scheduling and logging.
• Involved in performance tuning of SQL queries by providing hints, obtaining Explain Plan, analyzing tables and adding indexes.
• Involved in full integration test and code reviews of all jobs within each sequence before migrating the jobs and sequencers from the Development environment (Dev) to the QA environment, and from the QA environment to the Production environment.

Environment: Erwin, DataStage 9.1/11.3, PS EPM PeopleSoft, Oracle 11, DB2 UDB, JDE, AIX, MS Excel 2000, SQL Server 2012, cognos, GreenPlum 4.2, windows power shell, WEBI, SQL Navigator, SQL * Loader, Mainframes, AS400 (iSeries)

Confidential, NC

Sr.ETL Developer

Role & responsibilities:

• Used Ascential Profiling, Integrity for cleansing, the source data coming heterogeneous sources such as ANSI X12 (fixed width flat files), CSV files, and also loaded using DataStage jobs
• Used plug-in stages such as FTP, Merge and Pivot and also various stages like Sequential, Hashed, ODBC, DB2, Aggregator, Links Practitioner/Link collector, and Inter-Process.
• Created Batches (DS job controls) and Sequencers to control set of DataStage jobs.
• Extensively used pre built-in DataStage transforms, functions and routines for conditioning, conversions, validation and loading, and also developed if required
• Created of different types of reports, such as: Master/Detail, Cross Tab and Chart (for trend analysis).
• Scheduled BO reports using Broad Cast Agent and monitored them through Broad Cast Agent console
• Involved in unit testing, system testing and integrity testing.
• Involved in the Analysis of Physical Data Model for ETL mapping and the process flow diagrams for all the business functions.
• Involved in designing the procedures using Ascential Integrity for data cleansing, used pre-built procedures for cleansing the address data of customer for internal business analytical purpose.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Worked with DataStage Director to schedule running the solution, testing and debugging its components and monitoring the resulting executable versions (on adhoc or scheduled basis).
• Extensively used pre built-in DataStage transforms, functions and routines for conditioning, conversions, validation and loading, and also developed if required.
• Developed user defined Routines and transformations to implement business logic and Shell scripts to automate file manipulation and data loading procedures

Environment: Erwin, DataStage 9.1/11.3, PS EPM PeopleSoft, Oracle 11, DB2 UDB, JDE, AIX, MS Excel 2000, SQL Server 2012, cognos, GreenPlum 4.2, windows power shell, WEBI, SQL Navigator, SQL * Loader, Mainframes, AS400 (iSeries)

Confidential

Sr. ETL Datastage Developer

Role & Responsibilities:

• Extensive ETL tool experience usingIBM Infosphere/Websphere DataStage, Ascential DataStage.
• Worked on DataStage tools likeDataStage Designer, DataStageDirector and DataStage Administrator.
• Strong understanding of the principles ofData Warehousingusingfact tables,dimension tables andstar/snowflake schema modeling.
• Worked extensively withDimensional modeling,Data migration,Data cleansing,ETL Processes for data warehouses.
• Developed parallel jobs using different processing stages likeTransformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply and Filter.
• UsedEnterpriseEdition/Parallel stageslike Datasets, Change Data Capture, Row Generator and many other stages in accomplishing the ETL Coding
• Familiar in using highly scalable parallel processing infrastructure using parallel jobs andmultiple node configurationfiles.
• Experienced in scheduling Sequence and parallel jobs usingDataStage Director, UNIX scriptsand scheduling tools.
• Experience introubleshootingof jobs and addressing production issues like data issues, ENV issues, performance tuning and enhancements.
• Knowledge in usingErwinas leading Data modeling tool forlogical (LDM)andphysical data model (PDM).
• Extensive experience in design and development of Decision Support Systems (DSS).
• Assisted in development efforts forData martsandReporting.
• Technical and analytical skills with clear understanding of design goals ofER modelingforOLTPand dimension modeling forOLAP.
• Extensive experience inUnit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT)andPerformance Testing.
• Worked with various databases likeOracle 11g/9i/8i, DB2, Sybase, SQL Server, Teradata.
• Worked SCDs to populate Type I and Type II slowly changing dimension tables from several operational source files
• Implemented multi-node declaration using configuration files (APT Config file) for performance enhancement.
• Debug, test and fix the transformation logic applied in the parallel jobs
• Deployed different partitioning methods like Hash by column, Round Robin, Entire, Modulus, and Range for bulk data loading and for performance boost.
• Designed DataStage Jobs to extract data from XML files using XML input stage, Used XML transformer stage to cleanse and transform the data to load it into the Data Mart.
• Created Universes and reports in Business Object Designer.
• Created, implemented, modified and maintained the business simple to complex reports using Business objects reporting module.

Environment: Ascential DataStage 8.7/8.5/9.1, Parallel Extender, (Designer, Director, Manager), Teradata SQL Assistant, BTEQ, MultiLoad, FastLoad, Erwin, Toad, Dbase3 Files, MS Access, CSV Files, XML Files, Oracle 9i, Greenplum, Windows 2003, IBM AIX 4.2/4.1, TWSd Work Scheduler.

Confidential

Sr. ETL Datastage Developer

Role & Responsibilities:

• Involved in the requirements gathering, analysis to define business and functional specifications.
• Enforced data Integrity rules/ Business Rules. Maintaining huge volume of data.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.
• Wrote SQL, PL/SQL, queries, stored procedures, triggers for implementing business rules and transformations.
• Applied Performance Tuning logic to optimize session performance.
• Created job sequences and job schedules to automate the ETL process using Autosys.
• Created, implemented, modified and maintained the business simple to complex reports using Business objects reporting module.
• Documented the changes made to the jobs, the comparative performances of the old and new jobs and the test plan that was used to test the jobs.
• Used UNIX shell scripts and commands to run the jobs.
• Worked on different partitioning methods (Round Robin, Entire, Hash by Field, Modulus and Range) and collection methods (Round Robin, Order and Sort Merge) in processing sequential data.
• Developed server jobs to load the data from flat files, text files, tag text files and MS SQL.
• Worked SCDs to populate Type I and Type II slowly changing dimension tables from several operational source files.

Environment: Ascential DataStage 8.7/8.5/9.1, Parallel Extender, (Designer, Director, Manager), Teradata SQL Assistant, BTEQ, MultiLoad, FastLoad, Erwin, Toad, Dbase3 Files, MS Access, CSV Files, XML Files, Oracle 9i, Greenplum, Windows 2003, IBM AIX 4.2/4.1, TWSd Work Scheduler.