SUMMARY:

• 14+ years of Experience in Information Technology, Business Intelligence, with main focus on Data Integration, Data warehousing Projects.
• Strong knowledge base in Extract Transformation Loading (ETL) applications using IBM Infosphere Information Server Versions 11.7,11.5, 11.3, 9.1, 8.7, 8.5, 7.5.
• 2 years’ experience working with IBM Pure Systems (Netezza) software applications.
• 2 years’ experience with IBM Infosphere Change Data Capture, Delivery technology and integrating it with IBM InfoSphere Information Server for real time data loads.
• Hands on Experience in Installing IBM Infosphere Information Server 11.3, 9.1, 8.7, 7.5.
• Hands on Experience in Installing, configure IBM Infosphere Information Analyzer and IBM Business Glossary and Meta Data Work Bench.
• Hands on experience in Installing IBM Information Server suite on AIX 6.1, 7.1, UNIX, Linux and Windows platforms.
• Experience in coordinating with IBM through their PMR system to resolve the issues.
• Hands on experience in system backup and Restore of IBM Infosphere Information Server and server file systems maintenance like monitoring, managing dataset and archiving files.
• Configured various third party tools, technologies with IBM Infosphere Information Server software.
• Installing server and client patches on IBM Infosphere Information Server.
• Performance Tuning of the Environments for optimizing efficiency.
• Hands on experience in ETL development for Data Warehouse & Data Integration using Datastage.
• Experience in on - site - offshore model of project implementation.
• Involve with end users to understand business needs for data integration.
• Experience in migration and up grade ETL environments from Infosphere lower versions to higher versions.
• Good knowledge on IBM Information Server suite components like Quality stage, Information Analyzer, Meta Data work bench and Business Glossary etc.
• Extensively worked on IBM Infosphere Information Server Administration in both Data Integration and Dataware Housing projects.
• Experience in both production support projects and Development projects.
• Documenting functional specifications, technical specifications, test cases, test results and production support documents.
• Experience in 24X7 on-call production support and troubleshooting issues.

TECHNICAL SKILLS:

ETL Tools: IBM Infosphere Information Server V 11.5/11.3/9.1/8.7/8.5. IBM Change Data Capture/Delivery for zOS and IBM Change Data Delivery V 6.5.

RDBMS: DB2 UDB, Oracle 11g/10g, MS SQL Server 2012/2008, Sybase, IBM Pure Systems (Netezza), SAP BW, SAPBAPI SAP ECC

Languages: SQL, PL/SQL and Unix Shell Scripting.

Other tools: IBM WebSphere Application Server 8.5, 6.1, 6.0, 5.0, SQL*Loader, TOAD, SQL Navigator, Autosys. Rapid SQL and SAP Solution Manager.

Operating Systems: UNIX, LINUX, ZLINUX, RHEL, IBM AIX 6.1/7.1, SOLARIS, WINDOWS NT/95/98/2000.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr IBM Infosphere Administrator

Responsibilities:

• Providing the technical support for the DataStage developers for all the applications.
• Attending different meetings with BU Champions/Managers as part of creating their application in NA region
• Proposed and triggered latest DataStage versions 11.5 (DEV, SIT, QA, PROD and DR) installation and involved in migration meetings.
• Designed and Installed Current Architecture for Datastage versions 11.3 and 11.5, for USAA Infrastructure, Designed and implemented GRID architecture for 11.5v build.
• Created Architecture diagrams, installations and patch installation documents.
• Good understanding of latest version IBM Information Server for Data Warehousing V11.5 and Hadoop implementation trends
• Extensive experience to perform DR exercises 8.1, 8.7, 9.1, 11.3 and 11.5.
• Highly proficient in understanding different Datastage architectures (Single server installation, Multi-engine tier installation using Websphere cluster)
• Planned and Implemented Oracle Metadata server move (XMETA and XMETA STG migration)
• Attending crisis calls in case of any urgent/priority issues and providing them solution in fixing the reported issues.
• Making sure Performance of PROD server is stable all the times and incase of any peeks during major PROD cycle schedules (identify and fix the issues causing the server slow ness)
• Communicating with IBM, getting the resolutions for any complex DataStage issues and implementing them.
• Scheduled and unscheduled application maintenance activities
• Consult and interface with internal/external team members as well as IBM Cognos for service requests, maintenance, and patching
• Case resolution with the help of Cognos Support team using Cognos Support secondary ID
• Installation of Information server on AIX/Linux environment and applying patches if required.
• Worked with Developers for code/design changes of the job for getting better performance by suggesting suitable environment variables.
• Helping Application team to resolve the DS/DB server or network related performance issues, during Production schedule. To complete their load on time.
• Ensuring the DataStage server availability of Production/UAT/Development environments for the full time.
• Maintenance of backups.
• Interacting with clients for all server related activities.
• Leading the 4-member’s admin team and guiding them to perform various tasks.
• Implemented hostname + domain change of Prod server as part of the Server move.
• Worked with IBM in fixing major prod issues, which will impact the business, and able to manage all pressured situation with 100% commitment.
• Working on the access controls for all the Global applications in the bank which includes critical, High risk trading and online banking applications.
• Leading the client access technologies and Access controls teams with various issues related to IAM tools.
• Risk based analysis of the applications and provide guidelines for application owners on various access management related security requirements.
• Analyzing database go live change orders and performing various security checks as part of database security check list and request for any dispensations if there is any risk vulnerabilities

Environment: LINUX (RHEL 6), Sun & AIX 5.1 & 6.1, DataStage 8.1, 8.5 & 9.1, 11.3, 11.5, 11.7, DB2 9.7 & 10.1, Teradata 14.10&Cognos 10.2, MKS, QC, Control-M, ISR, Access Management.

Confidential, Bentonville, AR

Sr IBM Infosphere Administrator

Responsibilities:

• Installed and Configured IBM Infosphere Information Server V 11.5, 9.1, 8.7 FP2 in AIX 6.1/7.1, Unix/ZLinux Environment and configured database connectivity (DB2, Oracle, IBM Pure Systems (Netezza)).
• Hands on experience in applying IBM Server Patches.
• Experience in Managing DataStage Environment Variables & entries in configuration files.
• Experience in Managing DataStage job locks.
• Stopping and Starting of IBM Infosphere Information Server and IIS Components.
• Performed various Development Activities like designing test DataStage jobs.
• Installed Quality Stage QS AVI Part on Application Server and configured it for Address verification.
• Jobs migration between different environments. (DEV/QA/PROD).
• Configured IIS application in MPP Environment using Both Netapp and NFS shared drives.
• Involved with IBM PMR system on resolving product bugs or technical issues.
• Performed DataStage Job scheduling using Autosys, ESP Scheduling Tools.
• Experience in migration and upgrade of Datastage Projects from versions 7.5 to 9.1 and from 8.5 to 11.5.
• Hands on experience in creating projects and setting project level properties, configuring the DataStage for developers, access to projects.
• Developed various UNIX scripts to perform automation of stopping and starting the information server and taking the regular backup of xmeta database and checking the performance of the server and scheduling them through crontab.
• Taking regular backups of DataStage projects by using istool.
• Performance Tuning of the Environments for optimizing efficiency.
• Configured IMAM utility to import Metadata from different sources.
• Participated in decision making and regularly interacted with the Business Analysts, developers to gain a better understanding of the Business Process, Requirements and ETL Design.
• Installed ISA Lite Infosphere tool on server to get the Statistics, to send reports to IBM.
• Estimation and Planning for Change Requests (CR), New Enhancements.
• Worked on documenting and maintaining Application deployment and architecture diagrams.
• Release Management - Coordination with Middleware, DBA groups regarding application down times.
• Developed UNIX Scripts, for automating admin tasks such as taking backups of projects, deleting datasets, archiving files.
• Monitoring application performance regularly and delivering status reports to upper management.
• Providing on Call support 24X7 for troubleshooting the issues related to Infosphere Datastage application Servers.

Environment: IBM Infosphere Information Server V 11.5, 11.3, 9.1, IBM WebSphere Application Server V 8.5, Information Analyzer, IBM Business Glossary, Meta data Work Bench, DB2 V 10.5, Oracle 11g, IBM Pure Systems Netezza, AIX 6.1/7.1, Linux, Service-now.

Confidential, Marlborough, MA

DataStage Administrator

Responsibilities:

• Installed and Configured IBM Infosphere Information Server 8.7 FP2 in AIX 6.1/7.1, Unix/ZLinux Environment and configured database connectivity (DB2, Oracle, IBM Pure Systems (Netezza)).
• Installed IBM Change Data Capture/Delivery on AIX 6.1, 7.1 Servers.
• Experience in Managing DataStage Environment Variables and configuration files.
• Experience in Managing DataStage job locks.
• Hands on experience in Installing Datastage packages / applying Patches on Engine, WAS Tiers.
• Stopping and Starting IBM Infosphere Information Server and Netezza Databases.
• Automated the code migration using HP PPM Tool and PTC version control.
• Performed various Development Activities like designing test DataStage jobs.
• Performed Job migration between different environments. (DEV/QA/STAGE/PROD/META STACK PROD)
• Interacted with IBM to fix product bugs or technical issues.
• Scheduled DataStage Jobs by using Autosys and ESP Scheduling Tools.
• Migration of Datastage Projects from version 7.5 to 8.7 FP2.
• Tuning of UVConfig file parameters and upgrading Branded ODBC Drivers to new versions.
• Hands on experience in creating projects and setting project level properties and configuring the DataStage for developers, users.
• Developed several UNIX scripts to perform automation of stopping and starting the information server and taking the regular backup of xmeta database and checking the performance of the server.
• Installed and configured the IBM FastTrack Application for Data mapping purpose.
• Resolved many issues occurred when deploying the Quality stage web services.
• Installed IBM Fix pack 2 and many patches on Infosphere Information Server.
• Installed and configured the IBM Infosphere Information Server V 9.1 on Sand Box and provided Access to Developers to do the IVP’s.
• Taking the regular backups of DataStage projects by using the istool.
• Installed the ISA Lite Infosphere tool on ZLinux server to get the Statistics and to send the reports to the IBM.
• Estimation and Planning for Change Requests, New Enhancements.
• Document and maintain Application deployment and architecture diagrams.
• Release Management - Coordination with Middleware, DBA groups.
• Participate in meetings with DBA, Middleware and Architecture groups for database tuning and application server load balancing strategies.
• Interacted with End users to understand the business requirements and in identifying data sources.
• Analyzing the existing informational sources and methods to identify problem areas and making recommendations for improvement.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Strong experience to work on RCA (Root cause analysis) and adopt best practices to reduce recovery time per SLA.
• Monitor application performance constantly and deliver status on performance improvements to upper management.
• Good Experience in troubleshooting all the issues like connectivity issues, performance issues.
• On Call support 24X7 on rotational basic for troubleshooting the issues related to Servers.

Environment: IBM Infosphere Information Server V 8.7, 8.5 IBM Websphere Application Server V 6.1, Information Analyzer, IBM Fast Track, IBM Business Glossary, Meta data Work Bench, DB2 V 9.5, Oracle 11g, MS SQL Server (2008/2012), IBM Pure Systems Netezza, AIX 6.1/7.1, Linux, ESP, HP PPM, Service-now.

Confidential, Roanoke, VA

Datastage Admin and developer

Responsibilities:

• Installed and Configured IBM Infosphere Information Server in Unix Environment and configured database connectivity (DB2, Oracle, Teradata etc.).
• Hands on experience in Installing, applying Patches on Infosphere Information Server.
• Stopping and Starting the IBM Infosphere Information Server and Datastage Servers.
• Performed Job migration between different environments.
• Performed Migration and up gradation of Datastage versions 7.5.x to 8.1.1
• Tuned the UVConfig parameters, dsenv files and upgrading Branded ODBC Drivers.
• Hands on experience in creating projects and setting project level properties and job level properties and configuring the DataStage for the users and setting permissions for the projects.
• Installed and configured the IBM FastTrack Application for Data mapping purpose.
• Updated JAVA SDK 1.4.2 SR 10 to JAVA SDK 1.4.3 SR 13 in WebSphere Application server.
• Resolved many issues occurred when deploying the Quality stage web services.
• Developed UNIX scripts to automate information server maintenance and backup.
• Installed and configured the IBM Infosphere Information Server V 8.5 on Sand Box and provided Access to Developers to do the IVP’s.
• Estimation and Planning for Change Requests, New Enhancements.
• Document and maintain Application deployment and architecture diagrams.
• Involved in Release Management to co-ordinate with various groups.
• Interacted with End users to understand the business requirements and in identifying data sources.
• Analyzing the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
• Designed and developed ETL processes using Datastage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
• Used Datastage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Used Quality Stage to ensure consistency, removing data anomalies and spelling errors of the source information before being delivered for further processing.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Involved in performance tuning and optimization of Datastage mappings using features like Pipeline and Partition Parallelism and data/index cache to manage very large datasets.
• Analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements.
• Creating Indexes and Aggregate tables for the data warehouse design and development.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, regression testing, functional testing, prepared test data for testing, error handling and analysis.
• Used Autosys job scheduler for automating the regular run of Batch cycle in both production and Staging environments.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Monitor application performance constantly and deliver status on performance improvements to the upper management.
• Configure the Serena to migrate the code to different environments i.e. QA, UAT & PROD.
• Providing on Call support 24X7 for troubleshooting the issues related to Infosphere information Servers and Production Loads.

Environment: IBM Infosphere Information Server V 8.1, 8.5 IBM WebSphere Application Server V 6.1, Information Analyzer, IBM Fast Track, IBM Business Glossary, DB2 V 9.5, Linux, Autosys, SAP ECC, Serena PVCS.

Confidential, Columbus, OH

Datastage Developer

Responsibilities:

• Extensive knowledge on Information Server, Datastage Designer, DataStage Director, Datastage Administrator, Quality Stage.
• Involved in creating specifications for ETL processes, finalized requirements and prepared specification documents.
• Involved in full life cycle of Building a Data Warehouse analysis, planning, design, development processes.
• Hands on experience in design, develop, test and Implement ETL process using IBM DataStage & QualityStage.
• Designed, developed DataStage jobs using Parallel Processing techniques by implementing Pipeline and Partition Parallelism.
• Extracted data from disparate source systems into Source.
• Defined and implemented approaches to load and extract data from database using Datastage.
• Worked closely with data warehouse architects and business intelligence analyst, users in developing software solutions.
• Used Datastage Enterprise Edition/Parallel Extender stages like Sort, Lookup, Change Capture, Funnel, and Plug-in Stage, Row Generator stages in accomplishing the ETL Coding.
• Tuned Datastage jobs for higher performance by dumping the look-up data into hash-file.
• Coordinated with Database Admin to create appropriate indexes for faster execution of jobs.
• Used Administrator to administer the locks on the jobs and other Administration activities for DataStage Application.
• Implemented constraints, integrity, Dimensions and Fact relationship with SURROGATE keys using Erwin.
• Developed UNIX shell scripts to automate the Data Load processes to the target.
• Developed jobs to load data in slowly changing dimensions.
• Assisted operational support team for transactional data loads in developing SQL & UNIX scripts.
• Serena PVCS (Configuration Management Tool) for migration of code between Environments.
• Responsible for performance tuning of ETL procedures and STAR schemas to optimize load and query Performance.
• Provided on Call support 24X7, troubleshooting the issues related to Datastage jobs in Production batch cycle.

Environment: IBM WebSphere Application Server V 6.1/5, IBM DataStage 8.1/7.5 Parallel Extender, IBM Information Server 8.0.1, Quality Stage 7.5, Information Analyzer, HP-UX, Oracle 10.2/9i, DB2 UDB V9.5, UNIX, ZLINUX and Autosys.