Datastage developer Resume Profile, NC - Hire IT People

Summary:

More than 7 years of experience in requirement gathering, development, support, design and testing.
Worked extensively in Siebel 7.x 8.x with specific focus in Siebel EIM, PL/SQL and ETL tool Datastage.
Major strength is an in-depth understanding of the Siebel Data Model.
Worked extensively in Siebel EIM, Datastage and PL/SQL for 65 months with a strong focus on sales and patient service process.
Experience includes project execution for global corporations across Europe and USA and has been involved across the entire life cycle of solution delivery.

Technical Skills:

Area	Skills
CRM	Siebel 8.x
Siebel Verticals	Siebel Life Sciences, Insurance
Tools	Siebel Products: Siebel 7.x., Siebel 8.x, ETL tool DataStage, Toad, Oracle SQL Plus
RDBMS	Oracle 9.x, Oracle 10g, Oracle 11g
Other Utilities	MS Office
Operating Systems	Win 98, Win NT 4.0/2000/XP
Programming Languages	PL/SQL, Unix

Work Experience:

Confidential

Primary Role:Datastage developer

Responsibilities:

Completed knowledge transition from offshore and joined onsite location in September 2013 as a senior Siebel EIM and Datastage developer with techno functional role
Worked with business team directly for requirement analysis solution development in critical timeline
Worked on Siebel EIM and DataStage support for failure and tuning of existing interfaces, ad hoc extract requests, critical data fix in production environment.
Some of the Adhoc extracts involved crucial production data like home and work phones, emails, ssn of all customers with a file size of 500 MB with sqlplus spool utility and query with parallel hint, transfer of extract to other server at off business hours for next day loading
Tuned existing Datastage jobs to improve performance and reduce loading time. Scope involved modification of job in lower environment, comparison of before and after modification status, migration of updated scripts and jobs to production after business validation, monitoring production run for more than a week and closure of request
Used Autosys for scheduling new data extract jobs. Scope involved creation of extract through SQl script, creation of Autosys script for new job, creation of mqfte script to transfer files across different servers, lower environment testing and production migration.

Environment: Oracle 10g, Siebel 8, Datastage.

Confidential

Primary Role:

Responsibilities:

Developed routines using Siebel EIM, Datastage and PL/SQL
Involved in requirement analysis and change request prioritization by coordinating with Onsite
Worked on critical business requirement using Siebel EIM and PL/SQL
Involved in multiple stakeholders communication including onsite, offshore, client and third party provider
Coordinated User Acceptance Testing for critical change request
Mentored three team members and groom them to become an independent developer

Environment: Oracle 10g, Siebel 8, PL/SQL, Datastage.

Confidential

Primary Role

Responsibilities:

Conducted data specific requirement gathering sessions
Participated in Data migration related solution design including design of Staging area.
Design develop central file specification for Data Migration purpose.
Entity wise mapping to Siebel for migration.
Developed DataStage jobs to incorporate business rules and related transformation for purposes of data migration.
Deployment Activities including Production data load.
Support Transition
Provide support during System Test and User Acceptance Test to facilitate data load validation.

Environment: Oracle 9i, Siebel 8, DataStage, UNIX Shell Script.

Confidential

Primary Role: EIM, Datastage Developer

Responsibilities

ECMS China DMI developer
Data Migration through DataStage EIM and Siebel Base table
Application functionality testing
Support to the onsite team during system testing and UAT during ECMS China Phase I implementation
Participate in UAT at Client location and conduct successful UAT during ECMS China Phase II implementation
Co-ordination with downstream application s to make them aware of Siebel data model and data migration strategy
Support Transition
Warranty Support

Environment: Oracle 9i, Siebel 7.7, DataStage.

Confidential

Primary Role: EIM, DataStage Developer

Project Description:

Responsibilities:

Design develop central file specification pertaining to entities identified for data migration.
Create/validate attributes mappings of different entities across systems including upstream systems.
Data migration using Siebel EIM, SQL and Datastage from old legacy system to new ECMS system.
Was also responsible for development, unit testing and documentation of batch interfaces required for W4 countries.
Modified the existing interfaces for the retrofit countries as per country requirement utilizing Data Stage ETL tool
Co-ordination with downstream application s to make them aware of Siebel data model and data migration strategy
Support Transition
Warranty Support

Environment: Oracle 9i, Siebel 7.7, DataStage.