SUMMARY

• More than 3+ years of Strong experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using IBM Data stage 11.x/9.x/8.x and BODS 4.2 (Business Object Data Services)
• Extensively used Datastage client components like DataStage Designer, Director, and Administrator in Data Warehouse development. Worked with Data Migration, Data Conversion in diverged environment like DB2, Oracle, SQL Server and complex files.
• Good knowledge of Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.
• Expertise in OLTP/OLAP database design and development of database schemas like star schema and snowflake schema that are used in relational, dimensional and multidimensional modeling. Implemented SCD’s (Slowly Changing Dimensions) and CDC (CDCChange Data Capture).
• Good understanding of Ralph Kimball and Bill Inman methodologies/approach.
• Involved in Full Life Cycle Development (Waterfall & Agile) of building a Data warehouse on Unix Platforms for Retail Industry.
• Good knowledge on extracting, cleansing and data transformations from various data sources related to data migration and data conversion projects.
• Good Knowledge in designing Parallel Jobs using various stages like join, lookup, transformer, lookup, merge, change Data Capture, filter, funnel, copy, surrogate key generator, column generator, sort, sequential file, dataset.
• Experience in handling huge volumes of data from one database to another using datastage with required transformations.
• Experienced in preparing the project documentation like technical design documents and technical specification documents.
• Hands on experience in manually validating the data and performing unit testing on test cases.
• Hands on experience on SAP BODS(Business object data services) creating Workflows, Batch jobs, Data flows and scheduling the jobs to run bi - weekly or weekly using Data Service Management Console.
• Ready to learn and explore new technologies.

TECHNICAL SKILLS

• ETL Tools: IBM Infosphere Datastage 11.x/9.x/8.x (Manager, Designer, Director, Administrator), BODS 4.2
• Tools: SQL NAVIGATOR, DBeaver, Filezilla,Jira
• Operating Systems: Windows 98/2003/2000/ XP/7/NT, Unix, MSDOS
• Databases: DB2, Oracle 11g/10g/9i/8i/8.0, My SQL Server
• Scripting: UNIX Shell Scripting
• Web Technology: Web Technology HTML, Java script
• Languages: SQL, PL/SQL, C, C++, XML

PROFESSIONAL EXPERIENCE

Confidential, Bentonville, Arkansas

Datastage Developer

Responsibilities:

• Worked closely with business analysts in requirements gathering, reviewing business rules and identifying data sources. Worked on analyzing the systems and gathering of requirements.
• Work with the project and business teams to understand the business processes involved in the solution.
• Created technical design documents by analyzing functional specification documents that are required for ETL development.
• Extracted the data from DB2 database into flat files, performed required transformations and loaded them into DB2 Staging Tables.
• Developed parallel jobs using various stages like sequential file, data set, lookup, filter, funnel, copy, surrogate key generator, column generator, sort, transformer, change data capture.
• Extensively used stage variables for source validations, to capture rejects and used job parameters for automation of jobs.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Used the datastage director and its run-time engine to monitor the running jobs.
• Involved in all steps of development and deployment processes.
• Prepared documentation for unit, integration and final end - to - end testing.
• Also prepared Technical Design and Technical specification documents for respective objects.
• As part of TRIRIGA project worked on BODS (Business object data services) to provide ECC and JDE Extracts to all the teams.

Environment: IBM InfoSphere Datastage 11.5, 9.1.2, DB2, My SQL Server, Flat Files, Filezilla, Win 7 and UNIX.

Confidential

Datastage Developer

Responsibilities:

• Provided High Level Design, Job Level Design Document.
• Developed Data Stage ETL jobs.
• Designed and developed the ETL jobs using Parallel Extender which distributed the incoming data concurrently across all the processors, to achieve the best performance.
• Designed parallel jobs using stages such as Join, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Lookup, Pivot, Sort, Surrogate key Generator, Change Data Capture, Modify, Row Generator and Aggregator.
• Created Master controlling sequencer jobs using Data Stage Job Sequencer.
• Extensively developed and deployed UNIX Shell scripts as wrappers that provides values to Data Stage jobs during runtime, execute Data Stage jobs.
• Documented the jobs used in ETL processes.
• Involved in enhancement of Existing Data Warehouse.
• Played a key role as a primary contact person for Data Stage production environment.
• Migrated projects from development to QA to Production environments
• Performed the Integration and System testing on the ETL application.
• Joined data from different sources and loaded into data mart.
• Designed and developed validation strategy, validation routines and reports to validate between source and data mart, both on Data Stage and on mainframe host.
• Work with end users to understand their data and reporting requirements.

Environment: IBM DataStage 8.7, Oracle 10, Autosys, Oracle 10g, PL/SQL, Toad, Business Objects 6.0, UNIX Shell Scripts

Confidential

Data Warehouse Developer

Responsibilities:

• Gathered the requirements from the Business Analysts and Project Managers.
• Documented data sources and transformation rules required to populate and maintain data warehouse content.
• Designs, implements and supports data warehousing.
• Implements business rules via stored procedures, middleware, or other technologies.
• Defines user interfaces and functional specifications.
• Responsible for verifying accuracy of data, and maintaining and supporting the data warehouse.
• Familiar with standard concepts, practices, and procedures within a particular field.
• Relies on experience and judgment to plan and accomplish goals.
• Performs a variety of tasks.
• Typically reports to a manager.
• Involved in the development and implementation of ad-hoc reporting system using Business Objects.

Environment: SQL, PL/SQL, Oracle, SQL Server, MS office, Unix, Linux.