SUMMARY

• Over 11 years of experience in the field of Information Technology, with extensive experience in designing, developing and implementing Data Warehouses and DataMart for Retail and Financial Industries.
• Extensive experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using ETL Tools DataStage EE (Manager, Designer, Director, Administrator), Parallel Extender, Teradata, Informatica, Modeling Tool Erwin, ETL, OLAP and OLTP
• Experienced in Database design using Teradata, Oracle 9i, SQL Server 2000, with knowledge of ER - Diagrams, Entities, Granularity, Cardinality, Entity and Associations.
• Highly motivated, result oriented professional with a short learning curve and excellent communication skills.

TECHNICAL SKILLS

ETL: IBM DataStage 11.3/9.1/8.7/8.5/8.1/8.0/7.5/7.0/6.0/5.2 (Manager, Administrator, Designer, Director, Parallel Extender, Business Glossary), IBM Pack for SAP BW 4.0.1 and Ascential Pack for SAP R/3 5.0,Informatica, Data Warehousing, Metadata, DataMart, OLAP, OLTP, SQL*Plus

Reporting: Oracle SQL, PL/SQL, Teradata, SAP Business Objects

Databases: Oracle 10g/9i/8i/8.0.3/7.3, Teradata v12.0, SQL Server 2000, DB2, MS Access

Data Modeling: Erwin 4.0, Designer 2000, Star Schema, Snowflake Schema

Others: Visual SourceSafe, Clear Case, Korn Shell, Control-M and AutoSys

Programming: UNIX Shell Scripting, SQL, PL/SQL, C, C++, CGI/PERL, Java

Environment: Win 3.x/95/98/2000, UNIX, MS-DOS, and Red Hat Linux.

PROFESSIONAL EXPERIENCE

Confidential, TX

DataStage Architect/Tech Lead/Sr Datastage Developer

Responsibilities:

• Worked on multiple projects to accommodate specific data delivery needs
• Implemented solution architecture for wealth management scorecard and financial advice groups
• Performed data discovery, analysis to provide support to business users on current state situation
• Designed reusable artifacts for data processing
• Supported business users on different business objects reports data drills and associated issues
• Supported UAT environment for verification of data loaded for major high priority fixes
• Involved in planning and effort estimates for different tasks
• Worked on data validations and reconciliations efforts
• Worked on scheduling ETL jobs through control-m for overall integration
• Worked on Hadoop to archive source data and core tables

Environment: IBM InfoSphere Information Server V 9.1/11.3 DataStage, Oracle, IBM Netezza, LINUX, SAP Business Objects,Hadoop, IBM BigInsights and Control-M

Confidential, NJ

DataStage Architect/Tech Lead/Sr Datastage Developer

Responsibilities:

• Worked on data delivery of different replication efforts
• Assisted in Setting up application specific UAT environments
• Designed ETL framework for DR solution copy the production data to backup database
• Supported QA and UAT environments for different data needs
• Worked on Involved in planning and effort estimates for different tasks
• Assisted in infrastructure setups required for environment setups
• Worked on data validations and reconciliations efforts
• Worked on scheduling ETL jobs through autosys for overall integration
• Involved in production support activities on a rotation basis

Environment: IBM InfoSphere Information Server V 9.1 DataStage, Oracle, Green Plum, UNIX and Autosys

Confidential

DataStage Architect/Tech Lead/Sr Datastage Developer

Responsibilities:

• Involved in planning and effort estimates for different tasks
• Gathered requirements for both data and reporting layers
• Assisted in infrastructure setups required for data extraction
• Worked as a data modeler for the datawarehouse build
• Created Mapping document to build the datawarehouse
• Designed ETL framework for to load data from different source systems
• Worked on production support activities on a rotation basis

Environment: IBM InfoSphere Information Server V 8.5 DataStage, DB2, IBM Netezza, Red Hat Linux

Confidential, NY

DataStage Architect/Tech Lead/Sr Datastage Developer

Responsibilities:

• Involved in planning and effort estimates for different tasks
• Designed ETL solution for HR Workday integration
• Analyzed workday extracts to gather requirements
• Created design and mapping documents for different efforts on multiple tasks
• Worked as SME for different key Subject areas
• Worked extensively with XML stage to parse the Workday source data
• Designed data integration pattern for extracting Workday data which includes public API, Custom reports extract from HR Workday to HR Data Warehouse using XML integration with Datastage Web service method.
• Developed and tested the Workday Web service job using SOAP UI and optimized the Workday data extract performance using Webservice Client stage
• Coded and unit tested the complex components to meet the business specific requirements
• Validated the data loaded through datastage programs using sql
• Interacted with business users and OBIEE reporting team on validation issues for bug fixes
• Worked on Performance tuning of datastage designs for faster availability of critical data for reporting
• Proactively interacted with infrastructure team to address capacity management issues
• Worked with team on different phases to ensure application data quality and in-time delivery of the data
• Worked on production support activities on a rotation basis

Environment: IBM InfoSphere Information Server V 9.1 DataStage, SQL Developer, ORACLE 11i/10g, OBIEE, XML, Workday, Red Hat Linux