SUMMARY

• 12+ years of IT experience in Analysis, Design, Development and Implementation of Business Intelligence.
• Client/Server, multi - tier applications, worked through out the System Development Life Cycle.
• Extensive experience in developing Data Warehouse applications using ETL tools DataStage and SSIS
• 3+ years of hands-on experience in SSIS (SQL Server Integration Services)
• 6+ years of hands-on experience in Ascential DataStage 5.1 / 7.1 / 8.0.2
• Very Strong in SSIS packages, DataStage Server Jobs.
• Good experience in Interacting the end-users for Requirement gathering and Change requests.
• Having complete development Life Cycle knowledge of Data Warehousing.
• Comfortable at complete Life Cycle concepts and data model concepts of Data Warehousing.
• Excellent experience in Configuration coordinating.
• Experience in working with Stored Procedures, Triggers, views and Indexes using SQL Server, Oracle and Sybase Databases.
• Worked in different database like Oracle, Sysbase, Sql Server, DB2/400
• Good Exposure in BO, COGNOS and Crystal Reports.
• Excellent interpersonal, analytical, presentation and communication skills.
• Having Project Management experience
• Having experience on Resource Planning / Budgeting

TECHNICAL EXPERTISE

Operating Systems: DOS, Windows XP / Server 2003, UNIX, OS/400

ETL Tool: SSIS (SQL Server Integration Services 2008), Ascential DataStage 8.0.2 / 7.1 / 5.1 (Administrator, Manger, Director, Designer).

Databases: SQLServer 2008, Sybase, Oracle 8.X and DB2/400

Reporting Tools: Crystal Reports, RPG/400

Languages: C, C++, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, NJ

Project Manager

Responsibility:

• Datacenter migration.
• Price migration (to eliminate the dependency of Bloomberg)
• Requirement gathering from Client Services for new feeds.
• Preparing the Functional and Technical Specifications.
• Developing new Feeds using SSIS.
• Enhanced functionality of Existing System.
• Code Review, User Testing and Implementing the DataStage Jobs / SSIS Packages.
• Monitoring Batch (Daily and Monthly) Runs
• Running Sessions and Baches to load the data using DataStage / SSIS

Technology Environment: SSIS, Sql Server 2008, PERL

Confidential, JPM Chase, NY

DWH Consultant / BMR Client Feeds

Responsibility:

• Worked on Datacenter Migration.
• Converting existing DataStage jobs to load into SQL Server instead of Sybase.
• Requirement gathering from Client Services for new feeds.
• Preparing the Functional and Technical Specifications.
• Converting the DataStage Jobs to SSIS.
• Developing new feeds using SSIS.
• Enhanced functionality of Existing System.
• Code Review, User Testing and Implementing the SSIS Packages.
• Monitoring Batch (Daily and Monthly) Runs
• Running Sessions and Baches to load the data using SSIS.

Technology Environment: IBM DataStage 8.0.2, Sybase, SSIS, Sql Server 2008, PERL

Confidential, Bear Stearns, NY

DWH Consultant / BMR Client Feeds

Responsibility:

• Analyzed the existing system.
• Requirement gathering from Client Services for new feeds.
• Preparing the Functional and Technical Specifications.
• Converting the Perl jobs to DataStage.
• Enhanced functionality of Existing System.
• Code Review, User Testing and Implementing the DataStage Jobs.
• Monitoring Batch (Daily and Monthly) Runs
• Running Sessions and Baches to load the data using DataStage / SSIS.
• Managing the team in India.

Technology Environment: IBM DataStage 8.0.2, Sybase, PERL

Confidential

Product Manager

Responsibility:

• Analyzed the existing system.
• Migrating the DataStage projects from 5.1 to 7.1
• Requirement gathering from the SCB users for the new countries.
• Enhance the Application Architecture.
• Enhanced functionality of Existing System.
• Data modeling using ERWIN
• Preparing the Functional and Technical Specifications.
• Monitoring Daily Batch Run (Extraction, Loading and reporting).
• Business Reports Generation on daily and monthly basis for 15 countries.
• Running Sessions and Baches to load the data using DataStage.
• Involved in Creation of New Ports.
• Handled the end user Issues to Accessing the Reports Via Internet.
• Peer reviewing SOW and SLAs
• Reverse engineering for documentation.
• Preparing development Templates.
• Resource Planning / Budgeting / Time Sheeting.
• Maintaining Quality Docs, Conducting internal audits.
• Preparing Status Reports on Monthly basis
• Preparing Metrics Analysis Reports

Confidential

Senior Developer

Responsibilities:

• Preparing the Technical Specification, estimation for modules.
• Developing DataStage Jobs.
• Converting Server jobs in V5.1 to V7.1
• Loading dimensional data
• Production Support.
• Analyzed the existing system.
• Enhanced functionality of Existing System.
• Analyzed the existing system.
• Enhanced functionality of Existing System.
• Developing and modifying the DataStage Jobs.
• Running Sessions and Batches to load the data.
• Testing the whole system.

Technology Environment: Ascential DataStage v7.1, Sybase, PowerBuilder, Ashwin Scheduler

Confidential

Senior Software Engineer / Business Intelligence Solution

Responsibilities:

• Involved in creating / modifying mappings using Informatica Power Mart.
• Involved in testing the mappings through Server Manager.
• Creation of BO Universes.
• Resolved Loops through context to achieve drill-across functionality.
• BO reports generation and customizing the existing reports
• Creating Adhoc Reports & refreshing the BO reports.
• Modification of existing Crystal Reports.

Technology Environment: Informatica 5.1, Business Objects 5.1, Crystal Reports, Oracle 8i, and Windows NT.