SUMMARY:

• Over 15 years of experience in IT industry as Senior IBM Datastage Administrator on Datastage 11.5,11.3.1.2, 9.1.2 ( IBM Infosphere Information Server 11.5,11.3.1.2, 9.1.2 (Datastage, Quality Stage, Information Analyzer, Buisness Glossary, Data Quality console, Metadata workbench, IMAM,)), Datastage 8.1, Ascential Data Stage 6.1,7.5.1, 7.5.2EE
• Architect, Installation, Configuration, Capacity Planning, Migration, Administration & Upgradation of Datastage 8.1,9.1.2,11.3,11.5 on Red Hat Enterprise Linux Server release 5.6,6.6(HA Availability),AIX 7.1, IBM Infosphere information Server 8.1(HA Availability)) on IBM AIX 5.3,6.1
• Administration on IBM Infosphere information Server 8.1, 9.1.2,11.3,11.5(Datastage, Quality Stage, Information Analyzer, Buisness Glossary, Data Quality console, Metadata workbench, IMAM) on Infosphere Information Server Grid Environment with Multiple Head Nodes and Multiple Compute Nodes on Red Hat Enterprise Linux Server release 6.6,Suse Linux 10
• Installation and configuration of SAP plug - ins SAP BW Pack, SAP R/3 pack 6.5.0.2, V8.0 for ECC
• Installation & Configuration of Information Governance Dashboard, Data Governance
• Installation and configuration of Grid Enable Toolkit 4.3.7,5.0.7
• Installation and configuration of Platform LSF 9.1 on Datastage GRID Environment
• Installation and configuration of QSAVI(Address Verification Interface10.5) & USAC(US Address ) to develop Quality stage Jobs, Debug Quatlity stage issues & recommendation
• Installation and configuration of Fixpacks, Patches for Infosphere Information Server 8.1,9.1.2,11.3.1.2 & 11.5
• Import Physical and Logical ERWIN Data MODELS from IMAM(Infosphere Metadata Assest Manager) Preview, Analyze & share to Meta data Repository, Use ldsm2bg commands to populate Terms and Categories automatically on Business Glossary
• Configure Hadoop connectivity for Information Analyzer, MapR v3.0.2 Hadoop 1.0.3 Hive server 2.0
• Intergating Datastage 9.1.2, 11.5 with Cognos 10.1 via Infosphere Metadata Assest Manager
• Experience in IBM Information Analyzer administrative tasks such as Analysis Settings, Analysis Database, Analysis Engine, Import various source Data stores, Manage users and Groups, Import Metadata, create IA projects, Data Rule Definition, Data Rule, Rule set definition.
• Manage Business glossary Terms, Category, Business and Data Lineage, Information Governance Rules & policies
• Installation & Configuration of XMETA,IADB on oracle 12c,10g,11g,DB2 9.7,10.5
• Installation and Configuration of Websphere Application Server 6.0.2.27 & 8.5 (Domain Layer)
• Create and contact IBM regarding IBM PMR’s
• Development on Datastage 6.x, 7.x, 8.x,9.x,11.3,11.5
• Knowledge Transfer, Mentor & to existing/new team members
• Strong Analytical and Technical exposure. Working effectively as a Team Member.

SOFTWARES USED:

Database: TeradataV2R6,V12,V14.0,Oracle 8i, 9i,10G,11g, Microsoft SQL Server 2000,/2005,Sybase 12.5, JD Edward’s, DB2

Operating systems: IBM AIX 6.1, 5.3, Sun Solaris 5.10, Suse Linux 10,Window2000/2003 Server, IBM AS/400, Red Hat Enterprise Linux Server release 5.6

ETL Tool: IBM Infosphere Information Server(Datastage, Quality stage, Information analyzer,Buisness Glossary,Metadataworkbenc,IMAM)

Web Application Server: Websphere Application server, Apache/Weblogic

Scheduling Tools: Tivoli Work Scheduler(TWS), Autosys V3.2,V4.0,Appworx scheduler, Control M,UC4

Change Request management Tool: Maximo, Remedy

Source Control Tool: CVS source control, Rational Clear case, Datastage Version control, TFS

OLAP Tools: Business Objects 6.5/XIR2,Cognos,Microstrategy

Scripting: Unix shell scripting

KEY PROJECTS EXECUTED:

Confidential, Lansing, MI

Senior IBM Infosphere information Server 11.5 Administrator

Technology: IBM Infosphere Information Server 11.5, Red Hat Enterprise Linux Server release 7.3, Oracle 12c,10g,11g,Microsoft SQL Server 2005, SAP R/3 ECC(SAP pack 8.0), UC4 Scheduler

Responsibilities:

• Architect, Installation, Configuration, Capacity Planning, Migration,Administration & Upgradation from Datastage 11.5 on Red Hat Enterprise Linux Server release 7.3
• Administration of IBM Information Server 11.5(Datastage, Quality Stage, information analyzer, IGC, IMAM) on Red Hat Enterprise Linux Server release 7.3
• Installation and configuration of SAP plug-ins SAP R/3 pack 8.0 to extract source data from SAP ECC & BW using ABAP Extract stage
• Extensively Worked on Information Analyzer(source system analysis), DataQuality Console.
• Experience in IBM Information Analyzer administrative tasks such as Analysis Settings,Analysis Database,Analysis Engine, Import various source Data stores, Manage users and Groups, Import Metadata, create IA projects Schedule IA jobs, import and export IA projects
• Experience with Information Analyzer column analysis, Publish Analysis result, Define data rules definitions & Rule set to raise exceptions, understand and resolve IA logs.
• Installation of various Client/Server Datastage patches
• Intergating Datastage 11.5 with Cognos 10.1 via Infosphere Metadata Assest Manager
• Configuration of LDAP Authentication.
• Configuration of PX nodes(APT CONFIG FILE) on IBM Information Server 11.5
• Creation of Datastage XMETA Repository on Oracle11g,12c
• Installation Of Domain layer called Websphere Application Server 6.0.2.27,8.5
• Configuration of various database connectivity(Oracle11g,12c, SQL Server 2005)
• Set up the projects, roles, users, privileges in different environments(DEV,QA,PROD)
• Maintain & monitor Unix file system for Datastage ETL Projects
• Releasing Lock’s & processes on ETL Job’s
• Create and contact IBM regarding IBM PMR’s
• Debug any issue’s between client and server connectivity’s
• Perform ETL job migrations/Promotions(DSX),Files & Unix Scripts from DEV to QA,QA to PROD environment in compliance with Change Control Board.
• Interact and coordinate with DBA team of any database issue's
• Interact and coordinate with Unix Server team
• Interact and coordinate with UC4 of any ETL job Scheduling issues
• Developed parallel ETL jobs making use of different stages like transformer, lookup, join, modify, filter, funnel, pivot, sort, remove duplicates, Aggregator stage, Change Capture stage, Change Apply stage etc.
• Work experience on Information analyzer(Source system analysis)
• Written UNIX shell script to create ETL Project, generating APT CONFIG FILE, Maintenance script.
• Weekly backup of the ETL Projects in the form of DSX file’s, Daily Unix Back up
• Setting up the new Parameter set on the ETL Project Level.
• Support Project teams throughout the project
• Bouncing the Data Stage servers
• Assisting with capacity planning for the Data stage Projects
• Restoration of ETL application in the case of server Crash.
• Log & document all troubleshoot calls

Confidential, Minneapolis, MN

Senior IBM Infosphere information Server 8.1, 9.1.2, 11.3.1.2 Administrator/Architect

Technology: IBM Infosphere Information Server 8.1, 9.1.2 & 11.3.1.2, Red Hat Enterprise Linux Server release 5.6,6.6,AIX 6.1, 7.1,Oracle 11g,Microsoft SQL Server 2005, DB2 9.7,10.5, Teradata 14.0,15.0,Grid Enable Toolkit 4.3.7,5.0.7, Platform LSF 9.1,IBM TWS Scheduler

Responsibilities:

• Architect, Installation, Configuration, Capacity Planning, Migration, Administration Datastage 9.1.2 & 11.3.1.1 on Red Hat Enterprise Linux Server release 6.6( HA Availability) & IBM AIX 6.1,7.1 ( HA Availability)
• Administration of IBM Infosphere Information Server 9.1.2,11.3.1.2 on Grid Environment on Red Hat Enterprise Linux Server release 6.6(Head Node(HA Availability) & Compute nodes)
• Installation and configuration of Grid Enable Toolkit 4.3.7,5.0.7 & plaform LSF 9.1
• Installation and configuration of AVI(Address Verification Interface10.5) & USAC(US Address ) to develop Quality stage Jobs, Debug Quatlity stage issues & recommendation
• Developed Quality Stage jobs for Proof of concept using QSAVI to generate County & Geography info.
• Configuration of LDAP & NT active Directory Authentication.
• Installation of various Client/Server Datastage patches Infosphere Information Server 9.1.2,11.3.1.2
• Import Physical and Logical ERWIN Data MODELS from IMAM, Preview, Analyze & share to Meta data Repository
• Configure Hadoop connectivity for Information Analyzer, MapR v3.0.2 Hadoop 1.0.3 Hive server 2.0
• Extensivley Worked on Information Analyzer(source system analysis), DataQuality Console & WISD
• Experience in IBM Information Analyzer administrative tasks such as Analysis Settings, Analysis Database, Analysis Engine, Import various source Data stores, Manage users and Groups, Import Metadata, create IA projects Schedule IA jobs, import and export IA projects
• Experience with Information Analyzer column analysis, Publish Analysis result, Define data rules definitions & Rule set to raise exceptions, understand and resolve IA logs.
• Configuration of PX nodes(APT CONFIG FILE) on IBM Information Server 8.1, 9.1,11.3.1.2
• Configuration of various database connectivity(Oracle11g, DB2 9.7, Teradata 14.0,SQL Server 2005,Hadoop)
• Set up the projects, roles, users, privileges in different environments(DEV,QA,PROD)
• Debug any issue’s between client and server connectivity’s
• Perform ETL job migrations/Promotions(DSX),Files & Unix Scripts from DEV to QA,QA to PROD environment in compliance with Change Control Board.
• Interact and coordinate with DBA team of any database issue's
• Interact and coordinate with Unix Server team
• Interact and coordinate with TWS Team of any ETL job Scheduling issues
• Developed parallel ETL jobs making use of different stages like transformer, lookup, join, modify, filter, funnel, pivot, sort, remove duplicates, Aggregator stage, Change Capture stage, Change Apply stage etc.
• Support Project teams throughout the project
• Bouncing the Data Stage servers
• Restoration of ETL application in the case of server Crash.
• Log & document all troubleshoot calls

Confidential, Lansing, MI

Senior IBM Infosphere information Server 9.1 Administrator/Architect (Datastage 9.1.2 Administrator)

Technology: IBM Infosphere Information Server 8.1 & 9.1, Red Hat Enterprise Linux Server release 5.6, Oracle 10g,11g,Microsoft SQL Server 2005, SAP R/3 ECC(SAP pack 6.5.0.2), UC4 Scheduler

Responsibilities:

• Architect, Installation, Configuration, Capacity Planning, Migration,Administration & Upgradation from Datastage 8.1 to Datastage 9.1 on Red Hat Enterprise Linux Server release 5.6( HA Availability)
• Administration of IBM Information Server 8.1.0.2 (Datastage, Quality Stage, information analyzer,Business Glossary,Quality Console,Metadata Workbench) on Red Hat Enterprise Linux Server release 5.6
• Installation and configuration of SAP plug-ins SAP R/3 pack 6.5.0.2 to extract source data from SAP ECC & BW using ABAP Extract stage
• Extensivley Worked on Information Analyzer(source system analysis), DataQuality Console.
• Experience in IBM Information Analyzer administrative tasks such as Analysis Settings,Analysis Database,Analysis Engine, Import various source Data stores, Manage users and Groups, Import Metadata, create IA projects Schedule IA jobs, import and export IA projects
• Experience with Information Analyzer column analysis, Publish Analysis result, Define data rules definitions & Rule set to raise exceptions, understand and resolve IA logs.
• Installation of various Client/Server Datastage patches
• Intergating Datastage 9.1 with Cognos 10.1 via Infosphere Metadata Assest Manager
• Configuration of LDAP Authentication.
• Configuration of PX nodes(APT CONFIG FILE) on IBM Information Server 8.1 & 9.1
• Creation of Datastage XMETA Repository on Oracle11g
• Installation Of Domain layer called Websphere Application Server 6.0.2.27,8.5
• Configuration of various database connectivity(Oracle11g, SQL Server 2005)
• Set up the projects, roles, users, privileges in different environments(DEV,QA,PROD)
• Maintain & monitor Unix file system for Datastage ETL Projects
• Releasing Lock’s & processes on ETL Job’s
• Create and contact IBM regarding IBM PMR’s
• Debug any issue’s between client and server connectivity’s
• Perform ETL job migrations/Promotions(DSX),Files & Unix Scripts from DEV to QA,QA to PROD environment in compliance with Change Control Board.
• Interact and coordinate with DBA team of any database issue's
• Interact and coordinate with Unix Server team
• Interact and coordinate with UC4 of any ETL job Scheduling issues
• Developed parallel ETL jobs making use of different stages like transformer, lookup, join, modify, filter, funnel, pivot, sort, remove duplicates, Aggregator stage, Change Capture stage, Change Apply stage etc.
• Work experience on Information analyzer(Source system analysis)
• Written UNIX shell script to create ETL Project, generating APT CONFIG FILE, Maintenance script.
• Weekly backup of the ETL Projects in the form of DSX file’s, Daily Unix Back up
• Setting up the new Parameter set on the ETL Project Level.
• Support Project teams throughout the project
• Bouncing the Data Stage servers
• Assisting with capacity planning for the Data stage Projects
• Restoration of ETL application in the case of server Crash.
• Log & document all troubleshoot calls

Confidential, Bentonville, AR

Senior IBM Datastage 8.0.1 fixpack 2 & IBM Datastage 8.1..0.1 Administrator

Technology: IBM Datastage 8.0.1 fixpack 2,, IBM Infosphere Information Server 8.1, IBM AIX 5.3, Grid Suse Linux 10, Oracle 10g,11g,Microsoft SQL Server 2005,Sybase 12.5, Informix, Teradata, CA 7 Scheduler, Remedy, Grid Resource manager

Responsibilities:

• Installation, Configuration, Capacity Planning, Administration of IBM Infosphere information Server 8.1.0.1(Datastage, Quality Stage & information analyzer) on Grid Suse Linux 10( Conductor Node(HA Availability) & compute Nodes)
• Administration of IBM Information Server 8.0.2 (Datastage, Quality Stage, information analyzer, WISD) on IBM AIX 5.3(High Availability Environment)
• Installation of Fixpack1 on Datastage 8.1
• Installation and configuration of plug-ins SAP BW Pack
• Installation and configuration of Information Analyzer, Quality Stage extension & CASS DB
• Update CASS DB every 3 month once for US Address Standardization
• Installation of various Client/Server Datastage patches
• Configuration of LDAP Authentication.
• Configuration of PX nodes(APT CONFIG FILE) on IBM Information Server 8.0.2
• Creation of Datastage XMETA Repository on UDB DB2 v 9.1
• Installation Of Domain layer called Websphere Application Server 6.0.2.27
• Configuration of various database connectivity(Oracle, SQL Server, Sybase,Teradata,DB2,Informix)
• Set up the projects, roles, users, privileges in different environments(DEV,QA,PROD)
• Maintain & monitor Unix file system for Datastage ETL Projects
• Releasing Lock’s & processes on ETL Job’s
• Debug any issue’s between client and server connectivity’s
• Perform ETL migrations/Promotions(DSX),Quality Stage jobs, WISD jobs & Unix Scripts from DEV to QA,QA to PROD environment in compliance with Change Control Board.
• Interact and coordinate with DBA team of any database issue's
• Interact and coordinate with Unix Server team
• Interact and coordinate with CA7 of any ETL job Scheduling issues
• Developed parallel ETL jobs making use of different stages like transformer, lookup, join, modify, filter, funnel, pivot, sort, remove duplicates, Aggregator stage, Change Capture stage, Change Apply stage etc.
• Work experience on Information analyzer(Source system analysis)
• Written UNIX shell script to create ETL Project, generating APT CONFIG FILE, Maintenance script.
• Weekly backup of the ETL Projects in the form of DSX file’s, Daily Unix Back up
• Setting up the new DS environmental Variables on the ETL Project Level.
• Support Project teams throughout the project
• Bouncing the Data Stage servers
• Assisting with capacity planning for the Data stage Projects
• Restoration of ETL application in the case of server Crash.
• Log & document all troubleshoot calls
• Contacting IBM technical support
• 24/7 Rotational on call support of ETL Projects
• Maintain ongoing maintenance of the data warehouse environment( Corporate Data warehouse) to ensure high availability, performance and data integrity
• Monitoring Daily, weekly and monthly Production load
• Attending ETL job failures indicated via pager messages(system alerts & log files )
• Escalating PROD ETL issues to respective development team via Remedy Tickets
• Providing daily & weekly report on DW activities as well as communicate timely updates when there are issues with the Data Warehouse.
• Mentor the new team members on data load process of the ETL projects
• Perform on-demand loads of user maintained data
• Providing overall guidelines to the Production Support
• Document the learning’s in the form of SMTD(System maintenance Technical Documentation) as a deliverable and for the benefit of AMS team

Confidential, Portland, OR

Senior IBM Datastage 7.5.2, IBM Infosphere information Server 8.1 Administrator(Datastage 8.1)

Technology: Datastage 7.5.2, IBM Infosphere Information Server 8.1, IBM AIX 6.1, Oracle 10g,11g,Microsoft SQL Server 2005,Sybase 12.5, Teradata, Control M Scheduler, Maxim

Responsibilities:

• Architect, Datastage Administration, Installation and configuration of IBM Infosphere Information Server 8.1(Datastage, Quality Stage & information analyzer) on DEV, SYS, QA, PROD.
• Implementation, Capacity Planning & Upgradation from Datastage 7.5.2 to IBM Infosphere Information Server 8.1 (Datastage, Quality Stage & information analyzer) on IBM AIX 6.1
• Migration of 80 ETL projects (around 12000 jobs) DS 7.5.1 to IBM information Server 8.1
• Installation of various Datastage patches
• Configuration of LDAP Authentication.
• Configuration of PX nodes(APT CONFIG FILE) on IBM Information Server 8.1
• Creation of Datastage XMETA Repository on Oracle 10g
• Installation Of Domain layer called Websphere Application Server 6.0
• Configuration of various database connectivity(Oracle,SQL Server, Sybase)
• Set up the projects, roles, users, privileges in different environments(DEV,SYS,QA,PROD)
• Maintain & monitor Unix file system for Datastage ETL Projects
• Releasing Lock’s & processes on ETL Job’s
• Debug any issue’s between client and server connectivity’s
• Trouble shooting the Datastage Universe repositories
• Perform ETL migrations/Promotions(DSX) & Unix Scripts from DEV to sys, sys to QA and QA to PROD environment in compliance with Change Control Board.
• Interact and coordinate with DBA team of any database issue's
• Interact and coordinate with Unix Server team
• Interact and coordinate with Control M team of any ETL job Scheduling issues
• Developed parallel ETL jobs making use of different stages like transformer, lookup, join, modify, filter, funnel, pivot, sort, remove duplicates, Aggregator stage, Change Capture stage, Change Apply stage etc.
• Work experience on Information analyzer(Source system analysis)
• Written UNIX shell script to create ETL Project, generating APT CONFIG FILE, Maintenance script.
• Performance tuning on DS Server
• Weekly backup of the ETL Projects in the form of DSX file’s, Daily Unix Back up
• Setting up the new DS environmental Variables on the ETL Project Level.
• Support Project teams throughout the project
• Bouncing the Data Stage servers
• Interact and coordinate with DBA team of any database issue's
• Interact and coordinate with Control M team of any ETL job Scheduling issues
• Assisting with capacity planning for the Data stage Projects
• Restoration of ETL application in the case of server Crash.
• Log & document all troubleshoot calls
• Contacting IBM technical support
• 24/7 Rotational on call support of ETL Projects
• Maintain ongoing maintenance of the data warehouse environment( Corporate Data warehouse) to ensure high availability, performance and data integrity
• Monitoring Daily, weekly and monthly Production load
• Attending ETL job failures indicated via pager messages(system alerts & log files )
• Escalating PROD ETL issues to respective development team via maximo Tickets
• Providing daily & weekly report on DW activities as well as communicate timely updates when there are issues with the Data Warehouse.
• Mentor the new team members on data load process of the ETL projects
• Perform on-demand loads of user maintained data
• Providing overall guidelines to the Production Support
• Document the learning’s in the form of SMTD(System maintenance Technical Documentation) as a deliverable and for the benefit of AMS team

Confidential, St Louis, MO

Senior IBM Datastage 7.5.1, IBM Infosphere information Server 8.1 Administrator

Technology: Datastage 7.5.1,IBM Infosphere Information Server 8.1, Sun Solaris 5.10,Oracle 10g,Microsoft SQL Server 2005, Appworx Scheduler, Maximo

Responsibilities:

• Architect, Datastage administration, Installation and configuration of Datastage 7.5.1 & IBM Infosphere Information Server 8.1(Datastage, Quality Stage & information analyzer) on DEV,QA,UAT,PROD
• Implementation, Capacity Planning & Upgradation from Datastage 7.5.1 to IBM Infosphere Information Server 8.1 (Datastage, Quality Stage & information analyzer) on Sun Solaris 5.10
• Migration & testing ETL Projects(around 2000 jobs) MercyBI & MercyCDW from DS 7.5.1 to IBM Infosphere information Server 8.1
• Installation of various Datastage patches
• Configuration of LDAP Authentication.
• Creation of Datastage XMETA Repository on Oracle
• Installation Of Domain layer called Websphere Application Server
• Configuration of PX nodes on DS 7.5.1, IBM Infosphere Information Server 8.1
• Configuration of various database connectivity
• Set up the projects, roles, users, privileges in different environments(DEV, QA,UAT PROD)
• Maintain & monitor Unix file system for Datastage ETL Projects
• Releasing Lock’s & processes on ETL Job’s
• Debug any issue’s between client and server connectivity’s
• Trouble shooting the Datastage Universe repositories
• Perform ETL migrations/Promotions(DSX) & Unix Scripts from DEV to sys, sys to QA and QA to PROD environment in compliance with Change Control Board.
• Interact and coordinate with DBA team of any database issue's
• Interact and coordinate with Unix Server team
• Interact and coordinate with Appworx team of any ETL job Scheduling issues
• Perform ETL migrations(DSX) & Unix Scripts from DEV to QA, QA to UAT and PROD environment in compliance with Change Control Board
• Developed parallel ETL jobs making use of different stages like transformer, lookup, join, modify, filter, funnel, pivot, sort, remove duplicates, Aggregator stage, Change Capture stage, Change Apply stage etc.
• Implemented exception and error handling to gracefully handle the code.
• Trouble shooting the Datastage Universe repositories
• Performance tuning on DS Server
• Weekly backup of the ETL Projects in the form of DSX file’s, Daily Unix Back up
• Setting up the new DS environmental Variables on the ETL Project Level.
• Scheduling Appworx ETL Job’s
• Maintain ongoing maintenance of the data warehouse environment(MercyBI & MercyCDW( Corporate Data warehouse)) to ensure high availability, performance and data integrity
• Monitoring Daily, weekly and monthly Production load
• Assisting with capacity planning for the Data stage Projects
• Restoration of ETL application in the case of server Crash.
• Log & document all troubleshoot calls
• Contacting IBM technical support
• Document the learnings in the form of SMTD(System maintainence Technical Documentation) as a deliverable and for the benefit of AMS team
• 24/7 Rotational on call support of ETL Projects
• Data Warehouse (DWH) On-Call Team is to ensure the successful operation of the data warehouse (completion of the batch cycle & on-demand requests) so that all data is accurately loaded.
• Attending ETL job failures indicated via pager messages(system alerts & log files )
• Escalating PROD ETL issues to respective development team via maximo Tickets
• Root cause analysis & troubleshooting on MercyBI & MercyCDW ( Corporate Data warehouse) jobs incase of failures of scheduled job with the help of log file generated by ETL job.
• Providing daily & weekly report on DW activities as well as communicate timely updates when there are issues with the Data Warehouse.
• Mentor the new team members on data load process of the ETL projects
• Perform on-demand loads of user maintained data
• Providing overall guidelines to the Production Support

Confidential, Kansas City, MO

Senior IBM Information Server 8.0.1(Datastage) Administrator

Technology: IBM Information Server 8.0.1 fix pack 1a, IBM AIX 5L 5.3, Oracle 10g, Microsoft SQL Server 2005, Autosys

Responsibilities:

• Architect data stage Installation and configuration of IBM Information Server 8.0.1 fixpack 1a(Datastage, Quality Stage & Information analyzer) on DEV,QA,PROD
• Implementation of IBM Information Server 8.1 fixpack 1a (Datastage, Quality Stage & information analyzer) on IBM AIX 5L 5.3
• Configuration of LDAP Authentication.
• Configuration of PX nodes on IBM Information Server 8.1 fixpack 1a
• Creation of Datastage Repository on oracle 10g
• Configuration of Oracle, ODBC connectivity
• Set up the projects, roles, users, privileges in different environments(DEV, QA,PROD)
• Setting up the new Datastage environment on IBM AIX 5L 5.3
• Setting up the new DS environmental Variables on the ETL Project Level.
• Installation of various Datastage patches
• Support Project teams throughout the project
• Bouncing the Data Stage servers
• Trouble shooting the Datastage Universe repositories
• Developed parallel ETL jobs making use of different stages like transformer, lookup, join, modify, filter, funnel, pivot, sort, remove duplicates, Aggregator stage, Change Capture stage, Change Apply stage etc.
• Implemented exception and error handling to gracefully handle the code.
• Releasing Lock’s & processes on ETL Job’s
• Performance tuning on DS Server
• Debug any issue’s between client and server connectivity’s
• Interact and coordinate with DBA team of any database issue's
• Interact and coordinate with Autosys team of any ETL job Scheduling issues
• Perform ETL migrations (DSX) from DEV, QA, and PROD environment.
• Scheduling Autosys ETL Job’s
• Assisting with capacity planning for the Data stage Projects
• Weekly backup of the ETL Application’s in the form of DSX file’s, Daily Unix Back up
• Restoration of ETL application in the case of server Crash.
• Work closely with onsite/offshore Team.
• Log & document all troubleshoot calls
• Contacting IBM technical support
• Maintain ongoing maintenance of the Confidential Corporate Data warehouse to ensure high availability, performance and data integrity
• Monitoring Daily, weekly and monthly Production load
• Document the learnings in the form of SMTD(System maintainence Technical Documentation) as a deliverable and for the benefit of AMS team

Confidential, Lexington, KY

Senior Datastage Architect, Administrator, Upgrade Consultant & Production Support

Technology: DataStage6.1, 7.5.2EE, Oracle 9i,10g,JD Edward’s,DB2,Microsoft SQL Server 2000,/2005, Sun Solaris 5.10,Tivoli Work Scheduler(TWS), Window2000 professional

Responsibilities:

• Datastage administration, Installation and configuration on DS6.1,7.5.2EE
• Upgradtion of DS 6.1 to DS 7.5.2EE(DEV,QA,PROD) on Sun Solaris 5.10
• Migration & testing all the 18 ETL application’s(around 3500 jobs) on New DS 7.5.2EE
• Production Support on few ETL application’s
• Support application teams throughout the project
• Setting up the new Datastage environment on Sun Solaris 5.10
• Installation, Upgrade Data Stage EE server (version 7.5.2EE) and various Data Stage PACKS (Siebel).
• Perform ETL migrations (DSX) & Unix Script’s across DEV, QA and PROD environment.
• Set up the projects, roles, users, privileges in different environments(DEV, QA, PROD)
• Configuration of PX nodes in DataStage EE server
• Configuration of Oracle, ODBC,DB2, connectivity
• Developed parallel ETL jobs making use of different stages like transformer, lookup, join, modify, filter, funnel, pivot, sort, remove duplicates, Aggregator stage, Change Capture stage, Change Apply stage etc.
• Implemented exception and error handling to gracefully handle the ETL code.
• Setting up the new environmental Variables on the ETL Project Level.
• Trouble shooting the Datastage Universe repositories
• Build out Datastage platform’s for DEV, QA and PROD
• Debug the ETL Job’s, Releasing Lock’s & processes on ETL Job’s
• Performance tuning on DS Server
• Debug any issue’s between client and server connectivity’s
• Troubleshooting & Performance tuning the ETL Job’s
• Work closely with onsite/offshore Team.
• Respond to emails from Business users questioning the data
• Assisting with capacity planning for the Data stage Project’s
• Data Warehouse (DWH) On-Call Team is to ensure the successful operation of the data warehouse (completion of the batch cycle & on-demand requests) so that all data is accurately loaded.
• Perform on-demand loads of user maintained data (often .csv files)
• Weekly backup of all the 18 ETL Application’s in the form of DSX file’s
• Weekly backup of all the Unix Script’s pertaining to ETL application’s
• Restoration of ETL’s and Unix script’s in the case of server Crash.
• Monitoring Daily, weekly and monthly Production load
• Log & document all troubleshoot calls
• Contact IBM Ascential Datastage technical support
• Converting Server Job’s to Parallel Job’s
• Provide coverage support for the Datastage change control person
• Document the learnings in the form of SMTD(System maintainence Technical Documentation) as a deliverable and for the benefit of AMS team