SUMMARY:

• Over 8+ years of total IT experience in Analysis, Design, Development, Implementation and Testing of Client/Server and Data Warehousing applications.
• Working knowledge of Software Development Life Cycle (SDLC) and project methodologies, as well as tools and techniques within each phase.
• Seven (7+) years of experience in Support of Products/Applications for data integration/data migration/ data conversion jobs in Data Warehousing and Business Intelligence Areas.
• Six (6+) years of experience in Extraction Transformation and Loading (ETL) processes using DataStage 11.5/11.3/9.1/8.5/8.1.1/8.0 /7.5. x EE (Parallel Extender) on Windows/Unix/Linux Platforms in Dev, QA, Stage and Prod environments.
• 4+ years of experience in Configuration and Administration of IBM WebSphere Application Server WAS 8.5.5/7.0.0.11/ 6.0.2.27/6.1.0.25 /6.1.0.17.
• 6+ years of experience in Configuration, Administration and Development of IBM InfoSphere Information Server IIS 11.5/11.3/9.1/8.5/8.1.1/8.0 Suite.
• 1+ year of experience in configuration and administration of Pentaho 4.4.2.
• Extensive experience on various Database Stages, File Stages, Debug/Development Stages and Processing Stages like Join, Funnel, Merge, Transformer, Lookup, Filter, Sort, Sequential File, Dataset, Remove Duplicate Stages etc to develop Server, Parallel and Sequence jobs.
• 6+ years of combined experience in Teradata V2R5/V2R6/V2R7, Oracle 12c/11g/10g/9i/8i, DB2 9.x/7.x, SQL Server, SQL, Java, J2EE, Web Services, XML and PL/SQL.
• 5+ years of experience in Migration of DataStage and QualityStage Projects and Jobs from previous versions to 8.x version.
• Performed Debugging, troubleshooting, monitoring and performance tuning using DataStage.
• 5+ years of Version Control of Information Manager in DataStage 11.5/11.3/9.1/8.5/8.1/8.0.
• Loaded the data into dimension and fact tables in start and snow flake schemas.
• Provided 24x7 Support at Level 3 for tickets.
• Excellent skills in preparing mapping and technical specification docs facilitate an understanding of the entire ETL process and in corporate changes as and when needed.
• Excellent communication skills, good organizational skills, outgoing personality, self - motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly.

TECHNICAL SKILLS:

ETL: IBM DataStage 11.x/9.x/8.x/7.5.x EE & SE, IBM InfoSphere Information Server 11.5/11.3/9.1/8.5/8.1.1/8.0 , InfoSphere Information Analyzer ProfileStage, QualityStage, Metadata Work bench, Business glossary, Pentaho 4.4.2.

Data Modeling: Dimensional, Logical & Physical Data Modeling, Star Schema, Snow-Flake Schema

Databases: Oracle 12c/11g/10g, Teradata V 13.10/2R5/R6, DB2 9.x/7.x, Informix 5.0/6.0, Greenplum 4.2

Programming: C, Java, J2EE, Perl, SQL, PL/SQL, Shell Scripting, XML, Web Services, WebSphere Application Server, MQ Series.

Operating System: AIX, Unix, Red Hat Linux, HP-UX, Solaris, Windows NT/XP/2000/2003 server.

Scheduling: Automic, Control-M, Autosys, Crontab Utility, CA7, D-Series.

Connectivity: Citrix, Putty, Cygwin X, Infosphere Stream, Sales force V1.5.0,SAP R3V6.5.0.1,Hadoop, WinSCP, Exceed, Edit++

PROFESSIONAL SUMMARY:

Confidential, Vernon hills, IL

Administrator

Responsibilities:

• Installed, Configured and Administered DataStage & QualityStage, ProfileStage of InfoSphere Information Server 11.3 & 11.5 suite in Dev, UAT and Prod Environments.
• Stopped and started DataStage Engine, WebSphere Application Server 8.5.5.1 and Information Server and managed logs.
• Stopped and Started Logging Agent, ASBAgent, DataStage Services & WAS and managed logs.
• Assigned suite roles and suite components roles for users in Information Server Web Console.
• Configured ODBC connections, maximum no. of processes per node.
• Installed and configured SAP R3 V6.5.0.1 Plugins connectivity.
• Installed and configured Sales Force V1.5.0 plugins connectivity.
• Installed and configured Hadoop plugin connectivity for Bigintegrate and Big quaiity.
• Installed and configured Operational console on IIS 11.3 & 11.5 for checking the run time statistics and also performance of Server.
• Validated and debugged the developed jobs.
• Setting up the SSH (Secure Shell) for DSADM & Userids.
• Unlocked jobs and also releases Xmeta locks. Set up Configuration Files, Job
• Parameters, Environment variables and Data Connections across jobs in a project.
• Involved in migration of DataStage and QualityStage projects and jobs from earlier versions to 11.3 & 11.5version.
• Worked with Administrator Client to manage projects and set their properties.
• Worked with Director Client to schedule, run and view the logs of jobs.
• Configured .odbc.ini, dsenv, uvconfig, DSParams, uvodbc.config files at both engine and project levels.
• Worked on performance tuning of ETL jobs using SQL queries, data connections,
• Configuration files, parameter sets and environment variables.
• Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Responsible for building and loading dimension tables and fact tables for the Confidential warehouse system.
• Used DataStage Designer/Manager/Director to design and run jobs to implement the Import and Export Interfaces.
• Imported table definitions from ODBC/Plug-in table definitions available.
• Used ISTOOL to migrate job objects between different environments in IS Manager.
• DataStage disk usage - projects, system files, datasets & scratch. Used Orchadmin Utility for deleting datasets.
• Backup and Restore of IIS 11.3 & 11.5 Suite.
• ETL support and resolution of errors at level 3 support.
• Provided Production support 24 * 7 week.
• Prepared disk, file, network resources and packages. Modified kernel parameters and user limits.
• Involved in DataStage security - assigned IIS suite and suite component roles in IIS Web Console.
• DataStage disk usage - projects, system files, datasets & scratch.
• Designed Technical Specification and Mapping Docs for DataStage jobs.
• Used IIS Console for Information Analyzer and Information Services Director tasks.
• Created PMRs with IBM for interim fixes, refresh packs, patches and fix packs.
• Used Control-M & automic for auto scheduling of DataStage jobs.
• Used ISTOOL to migrate job objects between different environments in IS Manager.

Environment: IBM InfoSphere Information Server V11.3 & 11.5 Suite DataStage, QualityStage, ProfileStage/Information Analyzer, SAP R3 V6.5.0.1, Sales force V1.5.0, Hadoop, Oracle 11g, DB2 9.5, SQL Server 2005, WAS8.5.5.1, Java, J2EE, SQL, PL/SQL, Crontab, Automic & Control-M, Business Objects, Shell Scripts, Windows 7 and Solaris 10.

Confidential, Sunnyvale, CA

Administrator

Responsibilities:

• Installed, Configured and Administered DataStage & QualityStage, ProfileStage of InfoSphere Information Server 9.1 & 11.3 suite in Dev, UAT and Prod Environments.
• Stopped and started DataStage Engine, Logging Agent, ASBAgent, DataStage Services & WebSphere Application Server and Information Server and managed logs.
• Assigned suite roles and suite components roles for users in Information Server Web Console.
• Configured ODBC connections, maximum no. of processes per node.
• Installed and configured Sales force V1.5.0 & SAP R3 V6.5.0.1 Plugins connectivity.
• Validated and debugged the developed jobs.
• Setting up the SSH (Secure Shell) for DSADM & Userids.
• Unlocked jobs and also releases Xmeta locks. Set up Configuration Files, Job
• Parameters, Environment variables and Data Connections across jobs in a project.
• Involved in migration of DataStage & QualityStage projects and jobs from earlier versions to 9.1 & 11.3 version.
• Installed and configured Hadoop plugin connectivity.
• Configured Infosphere Stream to analyzes massive data volumes in real-time to turn data into actionable insight.
• Worked with Administrator Client to manage projects and set their properties.
• Worked with Director Client to schedule, run and view the logs of jobs.
• Configured .odbc.ini, dsenv, uvconfig, DSParams, uvodbc.config files at both engine and Project levels.
• Worked on performance tuning of ETL jobs using SQL queries, data connections.
• Configured & administered of pentaho 4.4.2 and also assigned roles to users.
• Configuration files, parameter sets and environment variables.
• Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Used DataStage Designer/Manager/Director to design and run jobs to implement the Import and Export Interfaces.
• Imported table definitions from ODBC/Plug-in table definitions available.
• Used Crontab Utility for auto scheduling of DataStage jobs in Production environment.
• DataStage disk usage - projects, system files, datasets & scratch. Used Orchadmin Utility for deleting datasets.
• Backup and Restore of IIS 9.1 & 11.3 Suite.
• 24x7 DataStage ETL support and resolution of errors.
• Prepared disk, file, network resources and packages. Modified kernel parameters and user limits.
• Involved in DataStage security - assigned IIS suite and suite component roles in IIS Web Console.
• DataStage disk usage - projects, system files, datasets & scratch.
• Used IIS Console for Information Analyzer and Information Services Director tasks.
• Created PMRs with IBM for interim fixes, refresh packs, patches and fix packs.
• Used ISTOOL to migrate job objects between different environments in IS Manager.

Environment: IBM InfoSphere Information Server V9.1 & 11.3 Suite DataStage, QualityStage, ProfileStage/Information Analyzer Oracle 11g/10gR2, DB2 9.5, Greenplum 4.2,WAS8.5.5.1, Metadata Work bench, Sales force V1.5.0,SAP R3 V6.5.0.1, Hadoop, Infosphere Stream, Pentaho 4.4.2, Java, J2EE, SQL, PL/SQL, Crontab Utility, OBIEE, Shell Scripts, Windows 7, Red Hat Linux x86-64,Solaris 10.

Confidential, Los Angeles, CA

Administrator

Responsibilities:

• Installed, Configured and Administered DataStage & QualityStage, ProfileStage of InfoSphere Information Server 8.5 suite in Dev, UAT and Prod Environments.
• Stopped and started DataStage Engine, WebSphere Application Server and Information Server and managed logs.
• Stopped and Started Logging Agent, ASBAgent, DataStage Services & WAS and managed logs.
• Assigned suite roles and suite components roles for users in Information Server Web Console.
• Configured ODBC connections, maximum no. of processes per node.
• Installed and configured SAP R3 V6.5.0.1 Plugins connectivity.
• Validated and debugged the developed jobs.
• Setting up the SSH (Secure Shell) for DSADM & Userids.
• Unlocked jobs and also releases Xmeta locks. Set up Configuration Files, Job
• Parameters, Environment variables and Data Connections across jobs in a project.
• Involved in migration of DataStage and QualityStage projects and jobs from earlier versions to 8.5 version.
• Worked with Administrator Client to manage projects and set their properties.
• Worked with Director Client to schedule, run and view the logs of jobs.
• Configured .odbc.ini, dsenv, uvconfig, DSParams, uvodbc.config files at both engine and project levels.
• Worked on performance tuning of ETL jobs using SQL queries, data connections,
• Configuration files, parameter sets and environment variables.
• Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Responsible for building and loading dimension tables and fact tables for the Confidential warehouse system.
• Used DataStage Designer/Manager/Director to design and run jobs to implement the Import and Export Interfaces.
• Imported table definitions from ODBC/Plug-in table definitions available.
• Used ISTOOL to migrate job objects between different environments in IS Manager.
• DataStage disk usage - projects, system files, datasets & scratch. Used Orchadmin Utility for deleting datasets.
• Backup and Restore of IIS 8.5 Suite.
• 24x7 DataStage ETL support and resolution of errors.
• Prepared disk, file, network resources and packages. Modified kernel parameters and user limits.
• Involved in DataStage security - assigned IIS suite and suite component roles in IIS Web Console.
• DataStage disk usage - projects, system files, datasets & scratch.
• Designed Technical Specification and Mapping Docs for DataStage jobs.
• Used IIS Console for Information Analyzer and Information Services Director tasks.
• Created PMRs with IBM for interim fixes, refresh packs, patches and fix packs.
• Used D-Series for auto scheduling of DataStage jobs.
• Used ISTOOL to migrate job objects between different environments in IS Manager.

Environment: IBM InfoSphere Information Server V8.5 Suite DataStage, QualityStage, ProfileStage/Information Analyzer, SAP R3 V6.5.0.1,Oracle 11g/10gR2, DB2 9.5, Teradata 13.10 V, SQL Server 2005, WAS7.0.0.11, Java, J2EE, SQL, PL/SQL, D-Series, Business Objects, Shell Scripts, Windows 7 and Suse Linux.

Confidential, AR

Administrator

Responsibilities:

• Participated in meetings with Business users and Subject Matter Experts (SMEs) to understand the business requirements.
• Installed, Configured and Administered DataStage & QualityStage, Infosphere information Analyzer, IS Manager of InfoSphere Information Server 8.5 suite in Dev, UAT and Prod Phases.
• Configured High-Availability to ensure reliable operation, and automatically monitors available compute resources to ensure that no jobs are scheduled to failed machines.
• Configured and Administered the Platform LSF version 7.0 which enables users to run more jobs in less time.
• Configured and Administered the Grid tool kit version 4.2.5 on cluster topology and also Tested performance on multiple resources.
• Stopped and started DataStage Engine, WebSphere Application Server and Information Server and managed logs.
• Stopped and Started Logging Agent, ASBAgent, DataStage Services & WAS and managed logs.
• Installed Patches & fix packs regularly with IBM recommendation.
• Assigned suite roles and suite components roles for the users in Information Server
• Web Console.
• Configured ODBC connections, maximum no. of processes per node and paging space.
• Validated and debugged the developed jobs.
• Setting up the SSH (Secure Shell) for DSADM & Userids.
• Involved in Configuring IBM IS tools to use LDAP user registry with Active Directory.
• Unlocked jobs and also releases Xmeta locks. Set up Configuration Files, Job
• Parameters, Environment variables and Data Connections across jobs in a project.
• Involved in migration of DataStage and QualityStage projects and jobs from earlier versions to 8.5 version.
• Worked with Administrator Client to manage projects and set their properties.
• Worked with Director Client to schedule, run and view the logs of jobs.
• Configured .odbc.ini, dsenv, uvconfig, DSParams, uvodbc.config files at both engine and Project levels.
• Worked on performance tuning of ETL jobs using SQL queries, data connections,
• Configuration files, parameter sets and environment variables.
• Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Responsible for building and loading dimension tables and fact tables for the Confidential warehouse system.
• Used DataStage Designer/Manager/Director to design and run jobs to implement the Import and Export Interfaces.
• Extensively used DataStage Designer components to design various Server and Parallel jobs.
• Imported table definitions from ODBC/Plug-in table definitions available.
• Used CA7 for auto scheduling of DataStage jobs in Production environment.
• Used ISTOOL to migrate job objects between different environments in IS Manager.
• DataStage disk usage - projects, system files, datasets & scratch. Used Orchadmin command for deleting datasets.
• Backup and Restore of IIS 8.5 Suite.
• Migrate code into production on daily basis.
• 24x7 DataStage ETL support and resolution of errors.

Environment: IBM InfoSphere Information Server V8.5 Suite DataStage & QualityStage, ProfileStage/Information Analyzer, IS Manager, Informix 6.0, Oracle 11g/10gR2, DB2 9.7/9.5, Teradata V13.10, WAS7.0.0.11, Java, J2EE, SQL, PL/SQL, CA7, Shell Scripts, Platform LSF 7.0, Grid Tool Kit(4.2.5) Windows XP, Red Hat Linux x86-64.

Confidential, MN

Administrator

Responsibilities:

• Participated in meetings with Business users and Subject Matter Experts (SMEs) to understand the business requirements.
• Installed, Configured and Administered DataStage & QualityStage, Infosphere information Analyzer, IS Manager of InfoSphere Information Server 8.5 suite in Dev, UAT, Stage and Prod Phases.
• Configured High-Availability to ensure reliable operation, and automatically monitors available compute resources to ensure that no jobs are scheduled to failed machines.
• Configured and Administered the Tivoli Load Leveler version 3.5.1 which enables users to run more jobs in less time.
• Involved in Setting up the SSH (Secure Shell) for DSADM & User ids.
• Managed data associations to link related groups, elements, and element values.
• Configured external validation to validate end user data before updating or adding transactions.
• Customized code tables & error messages.
• Performed tracing and monitored logs files via The Transaction Audit Information log (TAIL).
• Configured bootstrap items for configuration repository, management agent, and management console & application configuration client.
• Unlocked jobs. Set up Configuration Files, Job Parameters, Environment Variables and Data Connections across jobs in a project.
• Prepared disk, file, network resources and packages. Modified kernel parameters and user limits.
• Involved in DataStage security - assigned IIS suite and suite component roles in IIS Web Console.
• DataStage disk usage - projects, system files, datasets & scratch.
• Installed and Configured fix pack 1 on IIS 8.5 and resolved errors.
• Involved in migration of DataStage and QualityStage projects and jobs from earlier versions to 8.5 Version.
• Worked with Administrator Client to manage projects and set their properties.
• Worked with Director Client to schedule, run and view the logs of jobs.
• Worked with Designer Client to design server, parallel and sequence jobs using stages.
• Configured the Data Source for ODBC, DB2 and oracle connectors.
• Designed Technical Specification and Mapping Docs for DataStage jobs.
• Used IIS Console for Information Analyzer and Information Services Director tasks.
• Performance tuning of DataStage jobs, IIS suite products and WAS.
• Determined Distinguished Names DN and Configured IBM IS tools to use LDAP user registry with Active Directory and also configured the PAM.
• Stopped and Started Logging Agent, ASBAgent, DataStage Services & WAS and managed logs.
• Participated in application and infrastructure engineering review and security audit.
• Developed Common Error Management and Audit Management process at Project level.
• Enabled IIS and WAS Security and configured internal and external user registries.
• Created PMRs with IBM for interim fixes, refresh packs, patches and fix packs.
• Backup and Restore of IIS 8.5.
• Used Control-M for auto scheduling of DataStage jobs.
• Used ISTOOL to migrate job objects between different environments in IS Manager.
• 24x7 DataStage ETL support and resolution of errors.

Environment: IBM InfoSphere Information Server V8.5 Suite DataStage & QualityStage, ProfileStage/Information Analyzer, IS Manager, Oracle 11g/10gR2, DB2 9.7/9.5, Teradata V13.10, WAS7.0.0.11, Java, J2EE, SQL, PL/SQL, Control-M, Shell Scripts, Tivoli Load Leveler(3.5.1), Grid Tool Kit(4.2.5) Windows XP, Unix (AIX 6.1).

Confidential, TN

Administrator

Responsibilities:

• Installed, Configured and Administered DataStage & QualityStage, ProfileStage, IS Manager and Metadata Server of InfoSphere Information Server 8.1 suite in Dev, UAT and Prod Phases.
• Managed user groups & associated them with transactions or rules of visibility RoV .
• Managed data associations to link related groups, elements, and element values.
• Configured external validation to validate end user data before updating or adding transactions.
• Managed extentions within the framework to extend data elements or extend the behavior of existing transactions.
• Performed tracing and monitored logs files via The Transaction Audit Information log (TAIL).
• Configured bootstrap items for configuration repository, management agent, and management console & application configuration client.
• Installed, Configured and Administered Oracle 10gR2 Metadata Repository Database and WebSphere Application Server 6.0.2.27.
• Unlocked jobs. Set up Configuration Files, Job Parameters, Environment Variables and Data Connections across jobs in a project.
• Prepared disk, file, network resources and packages. Modified kernel parameters and user limits. Resolved incompatible JRE errors during upgradation.
• Involved in DataStage security - assigned IIS suite and suite component roles in IIS Web Console.
• DataStage disk usage - projects, system files, datasets & scratch.
• Installed and Configured fix pack 1 on IIS 8.1 and resolved errors.
• Involved in migration of DataStage and QualityStage projects and jobs from earlier versions to 8.1.1 version.
• Worked with Administrator Client to manage projects and set their properties.
• Worked with Director Client to schedule, run and view the logs of jobs.
• Worked with Designer Client to design server, parallel and sequence jobs using stages.
• Designed Tehnical Specification and Mapping Docs for DataStage jobs.
• Used IIS Console for Information Analyzer and Information Services Director tasks.
• Worked with Information Analyzer and QualityStages to understand and cleanse metadata to build Data Model.
• Performance tuning of DataStage jobs, IIS suite products and WAS.
• Determined Distinguished Names DN and Configured IBM IS tools to use LDAP user registry with Active Directory.
• Stopped and Started Logging Agent, ASBAgent, DataStage Services & WAS and managed logs.
• Participated in application and infrastructure engineering review and security audit.
• Developed Common Error Management and Audit Management process at Project level.
• Enabled IIS and WAS Security and configured internal and external user registries.
• Created PMRs with IBM for interim fixes, refresh packs, patches and fix packs.
• Backup and Restore of IIS 8.1 Suite.
• Used Control-M for auto scheduling of DataStage jobs.
• Used ISTOOL to migrate job objects between different environments in IS Manager.
• 24x7 DataStage ETL support and resolution of errors inwww.salesforce.comtool.

Environment: IBM InfoSphere Information Server V8.1.1 Suite DataStage, QualityStage, ProfileStage/Information Analyzer, IS Manager & Metadata Server, Oracle 11g/10gR2, DB2 9.5, Teradata V2R7, SQL Server 2005, WAS 6.0.2.27/6.1.0.25 , Java, J2EE, SQL, PL/SQL, Control-M, Shell Scripts, Windows XP, Unix (AIX 6.1/Solaris 9) and Linux.

Confidential, CA

Developer/Administrator

Responsibilities:

• Developed cluster and grid architecture to enable the integration of metadata between InfoSphere tools and non-InfoSphere tools.
• Upgraded and configured all the tools from IIS Information Server 8.0.1 base version to Fix Pack 1->Fix Pack 1a->Fix Pack 2 and then to 8.1 on different tiers.
• Installed, Configured and Administered DB2 9.5 Metadata Repository Database and WebSphere Application Server 6.0.2.27.
• Installed, Configured & Administered InfoSphere MDM Server 8.5 and WebSphere Application Server 6.1.0.17.
• Managed user groups & associated them with transactions or rules of visibility RoV .
• Managed data associations to link related groups, elements and element values.
• Configured external validation to validate end user data before updating or adding transactions.
• Customized code tables & error messages.
• Managed extentions within the framework to extend data elements or extend the behavior of existing transactions.
• Performed tracing and monitored logs files via The Transaction Audit Information log (TAIL).
• Configured InfoSphere MDM Server Messaging Adapter using WebSphere as the application server and WebSphere MQ as the JMS provider.
• Configured .odbc.ini, dsenv, uvconfig, DSParams, uvodbc.config files at both engine and project levels.
• Configured parallel engine, database connectivity in parallel environment and access to ODBC sources.
• Started and stopped DataStage Engine, WebSphere Application Server and Information Server and managed logs.
• Raised PMRs with IBM on upgradation problems, patches and fix packs.
• Managed Users, Groups, active sessions, logs, schedules and licenses in IIS Web Console.
• Worked on administration command tool AppServerAdmin to update WAS and XMETA user credentials.
• Worked on administration command tool DirectoryAdmin to perform tasks and services of IIS and WAS.
• Worked on Oracle 10gR2 and DataStage Server performance tuning approaches.
• Backed up and restored InfoSphere Information Server suite.
• Configured NLS to support character maps and locales.
• Managed ASBAgent, Logging Agent, DSRPC, Telnet and Engine Resource services.
• Involved in migration of DataStage and QualityStage projects and jobs from earlier versions to 8.1 version.
• Designed parallel, server jobs and sequence jobs using different processing stages like Join, Funnel, Transformer, Surrogate Key Generator etc to load data from different data sources.
• Worked on performance tuning of ETL jobs using SQL queries, data connections, configuration files, parameter sets and environment variables.
• Used Information Analyzer ProfileStage and QualityStage for Data profiling and Quality.
• Enabled operational metadata at project and job levels. Managed operational metadata from job runs.
• Applied Fix Pack 27 and Java SDK on WebSphere Application Server WAS 6.0.2 and enabled tracing, security and configured LDAP user registry in both WAS & IIS.
• Determined Distinguished Names DN and Configured IBM IS tools to use LDAP user registry with Tivoli Directory Server.
• Documented steps for Upgradation, Configuration, administration and Development of IIS suite tools.
• Used DSCMDEXPORT and DSEXPORT to migrate projects and jobs between different environments.
• Used Autosys to schedule jobs and e-mailed the status of ETL jobs to operations team daily.
• Performed Root Cause Analysis RCA in production support for tickets in IBM ESR tool.
• Performed Knowledge Transfer KT to team members and lead the whole project in all the phases.

Environment: IBM InfoSphere Information Server V8.1 Suite DataStage, QualityStage, ProfileStage/Information Analyzer, IS Manager & Metadata Server, InfoSphere MDM Server 8.5, Oracle 10gR2, SQL Server 2005, DB2 9.1, Teradata V2R6, WAS 6.0.2.27/6.1.0.17 , Java, J2EE, SQL, PL/SQL, XML, Autosys, Shell Scripts, Perl, Windows XP, Unix (AIX 5.3/Solaris 9) and Linux