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.7/11.5/11.3/9.1 on Windows/Unix/Linux Platforms in Dev, QA, Stage and Prod environments.
• Two (2.5+) years of experience in Configuration and Administration of IBM WebSphere Application Server WAS 9.x/8.x7.0.0.11/.
• 5+ years of experience in Configuration, Administration and Development of IBM InfoSphere Information Server IIS 11.7/11.5/11.3/9.1 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 18c/12c/11g, DB2 11.x/10.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.7/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, ability to work independently or cooperatively in a team,

TECHNICAL SKILLS

ETL: IBM DataStage 11.7/11.5.x/11.3.x/9.x, IBM InfoSphere Information Server 11.7/11.5/11.3/9.1, InfoSphere Information Analyzer ProfileStage, QualityStage, Metadata Work bench, Business glossary, Pentaho 4.4.2.

Databases: Oracle 18c/12c/11g, DB2 11.x/10.x/9.x, Informix 5.0/6.0, Greenplum 4.2, MySQL

Programming: Shell Scripting, python

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

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

Connectivity: Citrix, Putty, Cygwin X, WinSCP, Secure CRT

PROFESSIONAL EXPERIENCE

Confidential, TX

DataStage Admin

Responsibilities:

• Installed, Configured and Administered DataStage & QualityStage, ProfileStage of InfoSphere Information Server 11.7, 11.5, 11.3, 9.1 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 11.7/11.5/11.3/9.1 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, 11.5,11.7 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, 11.5 & 11.7 Suite DataStage, QualityStage, ProfileStage/Information Analyzer Oracle 18c/12c/11g/10gR2, DB2 11.x/10.x/9.5, J2EE, SQL, PL/SQL, Crontab Utility, OBIEE, Shell Scripts, Red Hat Linux x86-64,Solaris 10.

Confidential, FL

DataStage Admin

• Installed, Configured and Administered DataStage & QualityStage, ProfileStage of InfoSphere Information Server 9.1/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 target 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 - Chicago, IL

DataStage Admin

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/10g, 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).