OBJECTIVE:

To seek a challenging position as a software developer in Data Warehousing using ETL tool IBM InfoSphere DataStage 8.5/9.1

SUMMARY:

• Over Thirteen years of experience in Analysis, Design, Development, Implementation and Maintenance of database and software in Client/Server environment using Object Oriented Techniques with relational databases, Data Warehousing and Application Development.
• Experience includes Seven years of Data Warehousing and Business Intelligence applications using IBM Infosphere DataStage 9.1/8.5/8.1/8.0.0/7.5.1/7.5/7.0.1/6 Server/Parallel environments.
• Has Two years of experience in Oracle Applications (Financials and Manufacturing) v 10.7 SC/11i customization of OE, INV, AR, PO and GL modules. Created and monitored many Packages and Stored procedures through Oracle Enterprise Manger. GUI Forms and Reports were generated using Oracle Development tools Oracle*Forms4.5/ 6i and Oracle*Reports 2.5/6i
• Good experience in working with data modeler to create/design the data model and Identify/analyze the Source data.
• Experience in creating Mapping documents with business transformations from source to target by coordinating with Business analysts and getting signoff on various Documents from Business team.
• Proficient in Re - Engineering and developing existing ETL jobs/mappings.
• Expertise in translating business requirements into Data Warehouse and Data Mart design and developing ETL logic based on the requirements using DataStage.
• Expertise in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Proficient in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key Generation.
• Worked extensively on different types of stages like ODBC, Dataset File, Aggregator, Transformer, Merge, Join, Lookup, Sort, Pivot, Shared Containers (Server, Parallel) for developing jobs.
• Used DataStage Director extensively to run, schedule, monitor, debug and test the application on development, and to obtain the performance statistics.
• Good working knowledge of various Databases like Oracle 9i/8i/7.x, and SQL Server.
• Created jobs/ job dependencies and scheduled these jobs through different scheduling tools.
• Good knowledge of Change control process.
• Ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem solving skills.

TECHNICAL SKILLS:

ETL Tools: IBM Infosphere Datastage 7.x/8.x/9.1, Informatica, Oracle Data Integrator

Data Modeling: ERwin 4.0/4.1

Languages: SQL, PL/SQL, C, FORTRAN, COBOL, Basic, Powerscript, HTML, Shell Scripts

Databases: Oracle 10g/9i/8i/7.x, Watcom SQL, MS-ACCESS, Oracle Applications server v10.7/11i

Operating Systems: Windows 95/97/NT/98/2000/XP, UNIX, MS-DOS, Sun Solaris 2.5, Linux

GUI Tools: Power Builder 4.0, Developer-2000, Oracle *Forms 4.5/6i, Oracle *Reports 2.5/6iOracle Graphics 2.5, SQL Loader, SQL Reports, Toad 9, SQL Developer, PVCS

Software: Vantive, AutoCAD, Microsoft Word, Excel, AQTESOLV, MOC, Logdraft.

EXPERIENCE:

Datastage Consultant

Confidential, Raleigh, NC

Responsibilities:

• Multiple projects were built and maintained within the existing Data Warehouse, each project effectively integrates data from multiple data sources into a fully customized Data marts.
• The main scope of these projects is to create and distribute canned and ad-hoc reports to provide information for Sales, Commercial Finance, Marketing Position Analyses, Health Systems Group and monitor the business performance against its competitors.
• Worked with data modeler in creating and designing the data model, Identify and analyze the Source data. Created mapping document with business transformations from source to target by coordinating with Business analysts and getting signoff for Design Document from Business team.
• Used Quality Stage for data quality analysis and data quality operations.
• Dataset rule sets were implemented for standardizations.
• In the re-engineering lifecycle various processes were developed like conditioning/standardizing, matching and survivorship of data.
• Hands on experience in coding parallel and Server Jobs.
• Used Information analyzer for data profiling.
• Used various IBM Infosphere Data Stage Designer Client Suite components in designing the jobs.

Environment: IBM Infosphere Datastage 8.1/8.5, Oracle 10g, SQL Developer, Linux, Windows 7.

Confidential, Lake Forest, IL

Data Stage Consultant

Responsibilities:

• A real time DW project, EDW houses all the sales, financial data and metrics for Grainger and is used to store and analyze costs, revenue and customer centric information.
• The EDW team provides hundreds of statistical and business analysts, marketing managers, and customers with next-day access to complete information on customers, retail sales, inventory, shipments and forecast. This DW project has significant involvement in data extraction and migration from/to variety of RDBMS.
• Currently, all the existing server jobs, software have been changed to DataStage Parallel Jobs.
• Developed and supported the Extraction, Transformation and Load process (ETL) for the data warehouse from various data sources using DataStage Designer. Extensively used the stages in DataStage like Transformer, Data set File, Sequential File, and ODBC. Used DataStage Manager for importing the source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions. Designed and developed Job Sequences for the ETL jobs.
• Prepared Specification Documents for DataStage Jobs. Involved in Unit testing and integration testing to compare data with production data.
• Developed Parallel jobs using various stages like Join, Merge, Funnel, Lookup, Sort, Transformer, Copy, Remove Duplicate, Filter, Peek, Column Generator, Pivot and Aggregator stages for grouping and summarizing on key performance indicators used in decision support systems. Used the DataStage Director to run, schedule, monitor, and test the application on development, and to obtain the performance statistics.
• Worked on Different databases like Oracle, and SQL Server. Configured Oracle, SQL Server in DataStage for accessing and reading from database. Worked with Data Stage Administrator to create/modify/delete projects.
• Worked closely with Project lead/Manager, Architects, and Data Modelers to understand the business process and functional requirements. Identified the business rules to in corporate in the data transforms and flow to the data warehouse.

Environment: Ascential DataStage 6, IBM InfoSphere DataStage 7.0.1/8.1, Oracle 9i, SQL, Windows 2000/XP, UNIX, TOAD 9, Erwin.

Confidential, Milwaukee, WI

Senior Programmer Analyst

Responsibilities:

• Monitored Web site of the publishing company .
• Involved in monitoring the applications for Nuclio Systems an Confidential (management service provider) that manages Internet Infrastructure and applications.
• Created and monitored Packages and Stored procedures through Oracle Enterprise Manger.
• Business rules were enforced using triggers. Entity-Relationship modeling, data normalization techniques and structured charts were followed during the design phase.

Environment: Oracle 9i, Windows NT / 2000