SUMMARY:

• Over 9+ years of Experience in IT industry as a developer with experience in total life cycle of software development applications involving Design Analysis, Development, Maintenance, Implementation and Testing.
• 9+ years of experience in data Warehousing on Extraction, Transformation and Loading (ETL) processes using Data Stage (Designer, Administrator, Manager, Director), Parallel Extender EE, Quality Stage.
• 3+ Years of working experience with latest version - InfoSphere Information Server 9.1
• 2+ years of experience in other SSIS ETL Tool - Develop, Unit Test and deploy the packages to Prod.
• 2+ Years of experience in using Erwin Tool for creating LDM, PDM’s.
• Strong Knowledge of Business Intelligence, Enterprise Data Warehousing (EDW), Enterprise Data Base (EDB) Model, Operational Data Store (ODS) and OLTP.
• Experience in Implementing Full cycle Data Warehousing and Conversion Projects.
• Good understanding in analyzing Star Schema/Snowflake Schema, Dimensional Data Modeling, Logical and Physical Data Modeling.
• Good understanding of ETL methodologies, Business intelligence and Data Warehousing principles and architecture including the concepts, design and usage of data warehouse and data marts.
• Experience in RDBMS with Oracle 11g/10g/9i, DB2-10/9.5, SQL Server 2008/2005 and MS Access.
• Strong experience in SQL, PL/SQL for coding Stored Procedures, Functions and database Triggers.
• Experience in Installations and Configuring Data Stage and setting up connections with different databases like Oracle, SQL Server and DB2-UDB Z/OS.
• Experience in writing SQL Queries for different Data Bases very efficiently.
• Experience in using Parallel Extender (PX) for Parallel Processing to improve job performance while working with bulk data sources.
• Worked on different phases of SDLC (Systems Development Life Cycle) such as design, development, integration, Unit testing, production deployments and application support.
• Working experience on SSIS as a backup resource when needed and created few packages involving Control flow and data flows.
• Experience in working with offshore/onsite teams and provided 24*7 on call production support.
• A strong team member with good communication skills.

TECHNICAL PROFILE:

Data Ware housing/ETL Tool: IBM Info Sphere Information Server 9.1/ 8.7/8.5/8.1/8.0 , Ascential Data Stage 7.5.2/7.0/6.5/5.2 , Parallel Extender, Quality Stage, Meta stage, Profile Stage (Information Analyzer), MS SQL Server Integration Services (SSIS).

Databases: DB2 10/9.5, Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005 and MS Access.

Data Base Tools: PL/SQL Developer, SQL Developer, TOAD for Oracle 9.5, Toad for DB2 2.0, Info Maker 7/6, Rapid SQL, Info Maker and IBM Control Center.

Languages: SQL, PL/SQL, UNIX Shell Scripts.

Operating Systems: Windows 95/98/NT/2000/XP, NT, UNIX-AIX 6.1/5.0, HP-UX, OS390, LINUX, SOLARIS 2.10.

Scheduling Tools: BMC Control M 6.4/6.1, CA 7 Workload Automation EE. (ESP).

Other Tools: Business Objects 6.5, XIR2, CA ERWin r9, IBM Clear Case 7.1, IBM Data Studio, Ultra Edit, Microsoft Office Suite (2003/2007/2011/2016 MS Word, MS Excel, MS Power Point and MS Visio 5.0) and XManager4.

Skills: Data Warehousing, Integrated Application Systems, Convert Project Specifications (Specs Analysis).

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL Data Stage Developer/ Sr. ETL Analyst.

• Implemented the DataStage Upgrade of 7.5.2 to 9.1. Convert close to 3000 PJ’s/500 JS’s/50 Containers.
• In the process of upgrading 9.1 to DS 11 version.
• Integration of Insurance application systems from various systems to one platform (POC- Point of Contact Application) for 7 states (ND, NE, IL, IN, MN, IA, WI, MI, East Tennessee States).
• Extracted data from North Region databases, loaded into South Region staging area, target tables after cleansing and validation as per the Technical Design Document.
• Created Data stage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.
• Extensively using Lookup, Join, Merge, Remove Duplicates, Aggregator and Transformer while building the jobs.
• Worked closely with Architects for the requirement gatherings and experience in working with offshore team to pass the requirements and get the things done on time.
• Experience in migrating the jobs from different environments using Version Control in 7.5 and thru Information Server Manage (via - TFS) in 9.1.
• Extensive experience in working with DataStage tools like DataStage Designer and DataStage Director for developing the jobs and view the log for errors.
• Created Data Stage Parallel Jobs to Fact and Dimension Tables used for reporting services.
• Address performance issues, Scaling issues and solve them efficiently under tight deadlines.
• Worked on using SSIS for data extractions from MS excel files from business users to load them to tables.
• Experience in creating Technical Spec documents as well as Unit test document.for CMT and Service Now Incidents.
• Convert project specifications to Technical specs as per the needs of the project.
• Troubleshoot the issues of UI with multiple customers.
• Tuned the parallel jobs using appropriate partitioning techniques used in the jobs and worked closely with DBA to create the proper indexes to handle the long run jobs.
• Extensive experience in writing SQL to check the data loaded by DS Jobs.
• 24*7 production support to NR Applications.

ENVIRONMENT: IBM InfoSphere Information Server 9.1.2, Ascential Data Stage 7.5.2, SSIS - Microsoft Visual Studios 2012, TFS- Eclipse, DataStage Version Control, DB2 9.7, Info Maker 7.0/6.0, BMC Control M 6.4, UNIX AIX 6.1, X Manager/X Browser, MS Visio, File Zilla/Win SCP/Putty.

Confidential, Houston, Texas

Sr. Data Stage Developer

• Knowledge of full life cycle development for building a Data Warehouse, Data mart, Enterprise Database Model (EDB).
• Designing of Mapping Documents from source to target (with transformation rules), Technical Specifications, Data flows, work plans and Test Cases.
• Involved in high-level architectural design discursion with data architects and team leads.
• Involved in gathering requirements, high level architecture design meeting, understanding the Business.
• Design of data SYNC jobs for various environments (transferring data from production to all other non production environments).
• Extensively worked on Error handling, cleansing of data, Creating Hash files and performing lookups for faster access of data.
• Extensively used Shared Containers and Job Sequencer to make complex jobs simple and to run the jobs in sequence.
• Designed many server jobs using Transformer, Sort, Aggregator, Link Collector, FTP, DB2-UDB, Hash File and Sequential File Stages.
• Developing complex transformations, surrogate keys, routines, jobs to load dimension and fact tables.
• Used Environment Variables, Stage Variables and Routines for developing Parameter Driven Jobs and debugging them.
• Extensive usage of Email Notification, Wait for file Activity, Routine Activity, Execute command stage and Exception Handler.
• Implemented Performance Tuning logic on targets, sources and stages to provide maximum efficiency and performance.
• Interact with business users and understand the business needs of the applications.
• Support 24*7 for Vehicle and Parts Warehouse/ Daily GST applications.  
• Team player with good communication skills.

ENVIRONMENT: Ascential Data Stage 7.5.2/7.5.3 Server Edition, DB2 z/OS 9.7/10.0, Oracle 10g/11g, Toad for Oracle 9.5, Toad for DB2 2.0, Workload Automation EE(ESP) and MS Access.

Confidential, Evansville, Indiana

Sr. Data Stage Developer.

• Designed Mapping documents, ETL architecture documents and specifications.
• Analyzed the Source Data and designed the source system documentation.
• Designing of the Technical specifications for Customer, Material and Employee project.
• Designed Data stage Best practices, Naming conventions to be followed.
• Designed Parallel jobs using Sequential File, Dataset, Join, Merge, Lookup, Change Apply, Change Capture, Remove duplicates, Funnel, Filter, Copy, Column Generator, Peek, Modify, Compare, Oracle Enterprise, Surrogate Key, Aggregator, Transformer, Decode, Row Generator, Head, Tail, SAP R/3 Stages, FTP, Java Transformer, Web Sphere MQ Connector, Split Sub record, XML Input and Output and Wrapped stages.
• Designed many sequencer jobs using Email Notification, Wait for file Activity, Routine Activity, Execute command stage, Exception Handler.
• Tuned Data Stage jobs for better performance by creating Data Stage Lookup files for staging the data and lookups.
• Implemented Data Stage XML (XML pack of Data Stage) such as XML digesting, XML publishing, and transforming functions.
• Worked on data transformation between XML documents and tabular data, Publishing XML document from tabular data & Parsing XML document into tabular data.
• Extensively used the SQL navigator for writing scripts to test the mappings.
• Worked on Reporting, OLAP, Analytics, Data mining, Business Performance Management, Text Mining & Predictive Analysis of Business Intelligence.
• Used ABAP Extract stage to extract the fields from SAP, HRS systems.
• Created Shared Containers to increase Object Code Reusability and to increase thru put of the system.
• Experience developing complex transformations, surrogate keys, routines, dimension tables and fact tables.
• Written many Test Plans, Test Scenarios, Test Cases and Test Scripts and performed the Unit, Integration, system testing and User Acceptance Testing.
• Involved in requirement gathering sessions and discursions.
• Involved in the preparation of ETL documentation (Technical Specs) by following the business rule, procedures and naming conventions.

ENVIRONMENT: IBM Info sphere 8.1, SAP ECC 7.0, SAP R/3, Oracle 10g, Toad 9.7, IBM Data Studio, BMC Control M 6.1.03, Aqua Data Studio 8.0 and UNIX AIX 6.1.

Confidential, New York

Sr. Data Stage Developer.

• Installation of Ascential Data Stage 7.5.2 on Sun Solaris 2.10 and Configuration of ODBC 5.4 drivers.
• Worked on the logical and physical design of the Data warehouse. Identified sources/targets and analyzed source data for dimensional modeling.
• Designed and developed jobs for extracting, transforming, integrating, and loading data into data mart using Data Stage Designer, used Data Stage manager for importing metadata from repository, new job categories and creating new data elements.
• Sequential File, Aggregator, ODBC, Transformer, Hashed-File, Sort, DB2 API, Oracle OCI, XML, FTP, Pivot, Hashed file, Link Partitoner, Link Collector and Plug-ins Stages were extensively used to develop the server jobs.
• Used Parallel Extender for splitting the data into subsets, utilized Lookup, Sort, Merge and other stages to achieve job performance.
• Using Key Management functions Surrogate Keys were generated for composite attributes while loading the data into Data Warehouse.

ENVIRONMENT: Ascential Data Stage 7.5.2/5.2, JD Edwards-DB2/AS 400, Oracle 11g, Toad 9.7.1, BMC Control-M 6.4, Win SCP, Sun Solaris 2.10, UNIX, Windows Server 2003R2.

Confidential, Pittsburgh, PA

Jr. Data Stage Intern/Developer

• Gathered business scope and technical requirements.
• Worked with Data Stage Designer tool in developing Stages and transformations to extract and load the data from flat files, and Oracle to Oracle.
• Created parallel jobs using Change Data Capture (CDC), decode, Look Up stages, and also used all kinds of SAP plug in(ABAP extract stage, IDOC Extract and IDOC Load) to extract data from SAP.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Extensively worked on Error handling, cleansing of data, Creating Hash files and performing lookups for faster access of data.
• Worked with Data Stage Manager for importing metadata.
• Using Data Stage Administrator created new projects and Environment variables for the projects.
• Responsible for System analysis, understanding of business requirements, expertise in understanding the complete information flow, database concepts, Normalization and creation of Database objects

ENVIRONMENT: Data Stage Server 6.5 (Administrator, Manager, Director, Designer), Quality Stage, Meta Stage, MQ Series, SQL, PL/SQL, SQL* Loader, TOAD, XML, ERWIN 4.1, SQL Server 2005, SAP R3, ECC6.0, Sun Solaris 10, Autosys, Windows NT, UNIX-AIX 5.2.