SUMMARY

• Over Seven Years of overall IT experience in Analyzing, Designing, Developing, Testing, Implementing and Maintaining client/server business systems over six years of experience with IBM InfoSphere/WebSphere Datastage (Designer, Director, Administrator and Manager) to implement ETL solutions and Data Warehousing projects.
• Experience in Data warehousing and Data migration.
• Extensively worked on Datastage Parallel Extender and Server Edition.
• Used both Pipeline and Partition Parallelism for improving performance.
• Developed Parallel jobs using various stages like Join, Merge, Lookup, Surrogate key, SCD, Funnel, Sort, Transformer, Copy, Remove Duplicate, Filter, Pivot and Aggregator stages for grouping and summarizing on key performance indicators used in decision support systems.
• Frequently used Peek, Row Generator and Column Generator stages to debug.
• Expertise in Software Development Life Cycle (SDLC) of Projects - System study, Analysis, Physical and Logical design, Resource Planning, Coding and implementing business applications.
• Expertise in performing Data Migration from various legacy systems to target database.
• Expertise in Data Modeling, OLAP/ OLTP Systems, generation of Surrogate Keys, Data Modeling experience using Ralph-Kimball methodology and Bill-Inmon methodology, implementing Star Schema, Snowflake Schema, using Data Modeling tool Erwin.
• In Depth knowledge in Data Warehousing and Business Intelligence concepts with emphasis on ETL and Life Cycle Development including requirement Analysis, Design, Development, Testing and Implementation.
• Experience in Data Warehouse development, worked with Data Migration, Data Conversion, and (ETL) Extraction/Transformation/Loading using Ascential Datastage.
• Experience in implementing Netezza, DB2, DB2/UDB, Oracle 10.2/ 9i/ 8i/ 8.0, SQL Server, PL/SQL, and SQL *PLUS database applications.
• Extensively used Datastage tools (Data Stage Designer, Datastage Administrator and Datastage Director). Experience in Forward/Reverse Engineering using Erwin.
• Involved in dimensional data modeling (star schema, snowflake schema) and fact and dimension table design, physical and logical data modeling using Erwin tool.
• Extensive experience in development, debugging, troubleshooting, monitoring and performance tuning using Datastage Designer, Datastage Director, Datastage Administrator.
• Creation of jobs sequences and job schedules to automate the ETL process by extracting the data from flat files, Oracle and Teradata into Data Warehouse.
• Experience in Integration of various data sources like Oracle, Teradata, DB2, SQL Server into ODS and DWH areas.
• Knowledge on BI tools like Qlikview and tableau.
• Experience in writing, testing and implementation of procedures, functions, packages and triggers at Database level using PL/SQL.

TECHNICAL SKILLS

ETL Tools: IBM InfoSphere / WebSphere Datastage 8.5/8.0/7.5.2 (Designer, Director, Administrator and Manager).

Reporting Tools: Micro strategy, Business Objects, IBM Cognos.

Database: Oracle 10g/9i/8i, MS SQL Server 2005/ 2000, DB2, MS Access 97/ 2000/ 2007 , Teradata V13.

Languages: SQL, PL/SQL, UNIX Shell Script, C/C++, .Net, XML.

Data Modeling Tools: Erwin 4.0/3.5, Star Schema, Snowflake Schema, OLAP, OLTP Tools TOAD, Win SQL, MS Office, Autosys, SQL Plus, SQL * Loader.

Operating Systems: Windows 7/Vista/2000/NT/XP, MS-DOS, UNIX. HP-UX, Sun Solaris.

PROFESSIONAL EXPERIENCE

Sr. DataStage Developer

Confidential, Ohio

Responsibilities:

• Involved in data modeling session, developed technical design documents
• Creation of unit test case documents
• Discussed with other team for performing integration testing.
• Involved in performance tuning of long running jobs.
• Involved in volume testing and quality testing.
• Reviewing the code developed by the subordinates with respect to naming standards, best practices.
• Involved in creating and maintaining Sequencer and Batch jobs.
• Used the ETL Datastage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Creating the scheduling plan, job execution timings and sharing with scheduling team (Control-M)
• Use the Administrator client to create, delete, and configure project.
• Developed Parallel Jobs using various Development / Debug Stages (Peek Stage, Head and Tail Stage, Row generator stage, Column generator stage, Sample stage) and Processing Stages (Aggregator, Change Capture, Change Apply, Filter, Sort and Merge, Funnel Remove Duplicate Stage).
• Involved in production cutover and implementation plan.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Worked on Autosys for job scheduling to define event dependencies.
• Involved in data discovery in profiling different source data.
• Creation of new instance for the Data warehouse.
• QlikView Connector can transform and validate Strings, Numbers, Dates, Postcodes, Phone Numbers.
• Worked on different databases and joined the data with individual queries and then blend them on within Tableau.
• Participate in evaluating and analyzing utilities and tools offered by BI applications/tools vendors.
• Worked on different stages for creating the jobs based upon business application.
• Creation of a new database to monitor the growth and performance of different instances.
• Developed shell scripts and updated the log for the backups.
• Involved in Unit Testing with the jobs and date loaded in the Target database.

Environment: IBM WebSphere Datastage 9.1, Oracle 10.2, Quality Stage Designer, Director, Administrator), DB2 UDB 8, Teradata, Linux, SQL, PL/SQL, UNIX Shell Scripting, Datastage Version Control, MS SQL server, Mainframe, Autosys, Info analyzer.

Sr. Datastage Developer

Confidential

Responsibilities:

• Incessant usage of UNIX commands for the Sequence Jobs.
• Development of Datastage design concepts, execution, testing and deployment on the client server.
• Designed and developed sequence jobs with stages Nested Condition, Execute Command, Job activity, Sequencer, User variables activity to dynamically loop through multiple jobs.
• Used Datastage Designer for importing the source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions.
• Modifying the existing Job if required.
• Involved in performance tuning of long running jobs.
• Used Datastage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
• Part of volume testing and quality testing.
• Frequent usage of Clear Case version control.
• Running and monitoring of Jobs using Datastage Director and checking logs.
• Unit testing for the Jobs Developed.
• Monitoring all data loads and fixing the errors.

Environment: IBM WebSphere Datastage 8.1,Oracle 9i, DB2, SQL Server 2005, Flat Files, UNIX scripting, Windows 2003, Autosys, Quality stage, Profile stage.

Datastage Developer

Confidential, Bentonville, AR

Responsibilities:

• Involved in design and development of data warehouse environment.
• Translated business processes into Datastage jobs for building data marts.
• Used different databases such as Oracle, SQL Server and Excel and flat files as source.
• Used Datastage Administrator to create repository, user groups, and managed users by setting up their privileges and profile. Identified source systems, their connectivity, related tables and fields and ensured data consistency for mapping.
• Created source table definitions in the Datastage repository by studying the data sources.
• Designed Datastage ETL jobs for extracting data from heterogeneous source systems, transforming and finally loading into the Data Marts using Datastage Designer.
• Involved in performance tuning of long running jobs.
• Involved in volume testing and quality testing.
• Created re-usable components using shared containers for local use or shared use.
• Imported and exported repositories across projects. Created error files and log tables containing data with discrepancies to analyze and re-process the data. Created job schedules to automate the ETL process.

Environment: IBM InfoSphere Datastage 8.1 (Designer, Director, Administrator), Profile Stage, Quality Stage, Oracle 10g, IBM DB2, Toad, Erwin 4.5.2, sequential files, flat files, Autosys.

Datastage Developer

Confidential

Responsibilities:

• Using IBM InfoSphere Datastage software, extracting data from DB2, Oracle and Flat File and Load to target tables.
• Participated in Business Analysis and technical design meeting with business and technical staff to develop Entity Relationship / Data Models, requirements document, and ETL specifications.
• Creating and maintaining Datastage Parallel Jobs for every policy holder from Confidential Securities and Capital Markets.
• Extracted data from text files, using FTP Stage and loaded into different databases.
• Developed Parallel Jobs using various Development / Debug Stages (Peek Stage, Head and Tail Stage, Row generator stage, Column generator stage, Sample stage) and Processing Stages (Aggregator, Change Capture, Change Apply, Filter, Sort and Merge, Funnel Remove Duplicate Stage).
• Designed Parallel jobs using various stages like Join, Merge, Remove Duplicates, Filter, Lookup, Modify, Aggregator and Funnel stages.
• Using Datastage Software Development Kit, Functions like DS Job Info, ICONV and OCONV, Transformers like Data Transform.
• Developed Test Cases and Performed Unit Testing, System, Integration Testing, UAT Testing.
• Used AUTOSYS to Schedule the Datastage ETL batch jobs on a daily, weekly and monthly basis.
• Designed the Datastage Integrity check jobs which check each Dimension ID and Fact table that has a corresponding ID in a Dimension table.
• Involved in developing and rewriting Investigation, Matching, Survivors rules and Standardization using Quality Stage.
• Used Datastage Director for Executing, Monitoring, analyzing logs and scheduling the jobs.

Environment: Ascential Datastage 7.5 (Datastage and Quality stage, Profile stage, and Metadata Server), DB2UDB9.1, Oracle 10g, SQL, PL/SQL, UNIX, IBM-AIX, Erwin 4.5, MS Visio and Autosys.

Datastage Developer

Confidential

Responsibilities:

• Involved in complete Data Warehouse Life Cycle from requirements gathering to end user support.
• Provide day-to-day and month-end production support for various applications like Business Intelligence Center, and Management Data Warehouse by monitoring servers, jobs on UNIX.
• Worked in onsite-offshore environment, assigned technical tasks, monitored the process flow, conducted status meetings and making sure to meet the business needs.
• Involved in Designing, Testing and Supporting Datastage jobs.
• Developed Parallel jobs using various stages like Join, Merge, Lookup, Surrogate key, SCD, Funnel, Sort, Transformer, Copy, Remove Duplicate, Filter, Pivot and Aggregator stages for grouping and summarizing on key performance indicators used in decision support systems.
• Accomplished various development requests through mainframe utilities, CICS Conversation
• Meet the clients on a weekly basis to provide better services and maintain the SLAs.
• Redesigned, modified the existing jobs and shell scripts in production environment to fix the daily aborts.
• Developed plug-ins in C language to implement domain specific business rules
• Used Control-M to schedule jobs by defining the required parameters and monitor the flow of jobs.
• Automated the process of generating daily and monthly status reports for the processing jobs.
• Created Teradata Stored Procedures to generate automated testing SQLs
• Drop indexes, remove duplicates, rebuilt indexes and rerun the jobs failed due to incorrect source data.
• Involved in the process of two client bank mergers by taking care of the customer account numbers, bank numbers, and their respective applications

Environment: Datastage 7.5X2, SunOS 5.8, Control-M 6.4.01, PL/SQL Developer 7.1, Teradata 12, Erwin, Autosys, Toad, Microsoft Visual Studio 2008 (Team Foundation Server), Case Management System, CA Harvest Change Management.

Datastage Developer

Confidential

Responsibilities:

• Involved in the design and development of Data Warehouse.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Involved in creating jobs and analyzing scope of application, defining relationship within and between groups of data, star schema, etc.
• Used Datastage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouse database.
• Performed Import and Export of Datastage components and table definitions using Datastage Manager.
• Used Metastage for managing and collecting metadata from various other tools through the use of MetaBrokers.
• Extensively used Flat File Stage, Hashed File Stage. DB2 UDB Stage, FTP Plug-in Stage and Aggregator Stage during ETL development.
• Used Datastage Director to Run and Monitor the jobs performed, automation of Job Control using Batch logic to execute and schedule various Datastage jobs.
• Documented the Data Warehouse development process and performed knowledge transfer to Business Intelligence Developer.

Environment: Ascential Datastage 7.5 Enterprise Edition (formerly known as Parallel Extender), Administrator, Designer, Manager, Director, Windows NT 4.0/2000, IBM AIX 4.0, IBM IMS, DB2 UDB, Oracle 9i, Erwin 4.0.