SUMMARY:

• Almost 9 years of IT experience in Analysis, Design, Development, Implementation and Testing using Data Modeling, Data Extraction, Data Transformation, Data Loading and Data Analysis Techniques
• Experience in Maintaining and solving issue with existing DataStage jobs as a part of Support project team member
• Worked in Pharma, Insurance domains.
• Experience in all phases of Software development life cycle process starting from requirements analysis to post implementation support in CMMI Level 5 environment.
• Extensive experience and worked on different versions of DataStage and experience in developing DataStage Enterprise Parallel jobs, Server jobs and sequence jobs.
• Experience in Designing, Compiling, Testing, Scheduling and running DataStage jobs. Experience in Scheduler tool Autosys.
• Expertise in both OLTP and OLAP Systems on Study, Analysis and Development.
• Extensively worked with SQL Developer, TOAD and Advanced Query Tool (AQT).
• Extensively worked on Transformer, lookup, join, merge, funnel, Sort, Filter, Remove Duplicates, Copy, Filter, Sequential file, dataset, Change capture and Database stages.
• Developed generic Datastage Parallel jobs for loading multiple flat files to corresponding target tables using Schema File.
• Worked with Oracle PL/SQL Stored Procedures, Table Partitions, Triggers, SQL queries and loading data into OLTP system.
• Worked with DB2 and Teradata sql queries to load data into data warehouse system
• Developed UNIX shell scripts for initialization process and for process control mechanism.
• Experienced and well versed with UNIX (shell, AWK, SED, Wild cards) commands.
• Implemented Data Cleansing, Transformation Scripts, Stored Procedures/Triggers and necessary Test plans to ensure the successful execution of the data loading processes.
• Experience in reverse engineering of existing Datastage jobs to technical source to target mapping sheet.

TECHNICAL SKILLS:

• CRM
• Siebel 8.x
• Siebel Verticals
• Siebel Life Sciences, Insurance
• Siebel, ETL tool DataStage,
• Toad, Oracle SQL Plus, SQL Developer, Advanced Query Tool (AQT)
• Scheduling Tool Autosys, Robot
• Oracle 9.x, Oracle 10g, Oracle 11g, DB2, Teradata
• MS Office
• Win 98, Win NT 4.0/2000/XP
• PL/SQL, Unix

PROFESSIONAL EXPERIENCE:

Confidential, MN

Senior Datastage developer and Support Team member

Technology: DB2, Datastage, Unix, Robot Scheduler

Responsibilities:

• Joined in September 2015 as a senior Datastage developer with techno functional role
• Worked with business team directly for requirement analysis solution development in critical timeline
• Worked on DataStage support for failure and tuning of existing interfaces, ad hoc extract requests, critical data fix in production environment.
• 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 Robot for scheduling new DataStage jobs. Scope involved creation of new DataStage jobs as per business provided requirements, creation of unix script for new job, creation of Robot job to call DataStage jobs, lower environment testing and production migration

Confidential, Charlotte, NC

Lead EIM and Datastage developer and Support Team member

Technology: Oracle 10g, Siebel 8, Datastage

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

Confidential

Lead EIM and PL/SQL, Datastage developer

Technology: Oracle 10g, Siebel 8, PL/SQL, Datastage

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

Confidential

EIM, Datastage Developer

Technology: Oracle 9i, Siebel 8, DataStage, Unix Shell Script

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 in corporate 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.

Confidential

EIM, Datastage Developer

Technology: Oracle 9i, Siebel 7.7, DataStage

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

Confidential

Siebel EIM, Datstage Developer

Technology: Oracle 9i, Siebel 7.7, DataStage

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