SUMMARY

• Over 7+ years of progressive experience in Information Technology area with major strengths in Enterprise Architecture, Data Quality, Data Governance, Data Warehousing, Grid computing, System Administration and Metadata Management.
• Have a strong focus on continuous improvement, self - motivated and eager to learn.
• Worked as DataStage Engineer and Administrator performing Capacity Planning, Installations, Configuration, Administration and Operations of Infosphere Information Server Suite & Suite Components (DataStage & Quality Stage, Information Analyzer, Business Glossary, Fast Track, Metadata Workbench and other components) on HA, Grid & Standalone Architecture for several release versions of IIS Suite.
• Have deep knowledge of IIS Suite Architecture for High Availability deployments on Grid, Cluster and Standalone Deployments for release version’s 8.x, 9.x & 11.x. Also have thorough understanding of Grid Resource management tools like load leveler and Platform LSF.
• Have hands on Experience in planning the architecture for the SDLC environments, Configuring & Building the systems and Deploying the Environments for the IIS Server version’s 8.X, 9.X and 11.X.
• Have thorough understanding of all components surrounding the IIS Infrastructure, have worked with teams to setup NAS & NFS Storage, MQFTE, Webshpere MQM, Autosys, CA7, Classic Fedaration Server, Connect Direct (NDM), etc...
• Have worked on IIS Administration activities like Code Migration, Connection Setup to various databases (Teradata, Oracle, DB2, SQL Server, etc...), User Role Setup, Helped Debugging Production Failures and Issues, etc.
• Proficient in UNIX scripting and worked on setting up automated code backups (using istools), Disaster Recovery Synchronization and several Maintenance scripts.
• Created technical documentation for Installation and Configuration, authored Operations and Maintenance Manuals for IIS suite components.
• Have experience Developing DataStage jobs and shell scripts for capturing operational metadata and server monitoring.
• Extensively worked with Production Support Teams and Development teams to debug, Analyze and Fix failures in Production and Non-Prod Environments with Data loads.
• Worked on Admin tasks like setting up user and group roles, establishing connectivity to various databases through TNS and ODBC settings, configuration of projects, and setting up backup policies and alert system for application storage mounts.
• Have worked on-call rotation supporting Production Environments on a 24x7 basis.
• Good team player with excellent communication skills.

TECHNICAL SKILLS

ETL Tools: DataStage and Qualitystage 8.x, 9.x and 11.x (Grid and Standalone Architecture), Informatica 7.1

Grid Management Tools: Load Leveler, Platform LSF.

Scheduling tools: Autosys and Cron.

Databases: Oracle, MS SQL Server, DB2, Adabas, Teradata.

Data Loading Utilities: Bteq, Fast Load, Mload, Tpump.

Operating systems: Windows, Linux and AIX.

Languages: C++, Java, PL/SQL, UNIX Scripting.

Other Tools: TOAD, MS Office, SQL plus, Tableau, StarTeam.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Application Architect (DataStage)

Responsibilities:

• Have worked with the system Architects to plan and design new 11.5 environments for true HA using Big IP, redhad clustering, GPFS file systems and Platform LSF as resource manager.
• Part of ETL COE team supports 12 individual DataStage platforms ranging from standalone systems to very high capacity, High availability Grid environments for various Lines of Business.
• Worked on testing and documenting optimal configurations for Platform LSF based on batch user, queue names and priority of the parallel jobs.
• Worked with application teams on configuring Platform LSF to optimize the batch run times and fully utilize the grid resources.
• Worked with the application teams to define and setup automated code backups on critical projects using istool utility.
• Have been working as both Support engineer helping with production environments and also part of build team planning and installing various components for IIS.
• Responsible for maintaining multiple Grid and standalone environments with unique architecture for every environment.
• Supported and worked on various maintenance activities like OS patching, SAN migration, Network Card Upgrades etc.
• Developed and scheduled shell scripts to proactively monitor and maintain the DataStage servers and report any issues regarding the DataStage daemons, certain critical processes and filesystems.
• Worked on code migration process for DataStage components from Development to Test and Production environments and worked on automation where necessary.
• Coordinating Installation IBM Information Server Patches, Fix Packs & Rollup Patches from IBM fix Central.
• Coordinated with Customer and IBM technical Support for Problem Management Requests.
• Have worked on POC’s for DataStage on Hadoop and ISD services for International address validation with AVI components.

Confidential, Charlotte, NC

Sr Engineer

Responsibilities:

• Worked with Subject Matter Experts, Solution Architects and Engineering teams to build and finalize the Architecture and the topology of the IIS DataStage 11.x Environment.
• Worked with System Engineering teams to build a POC for 11.3 and executed several test cases on the server.
• Worked and built a standard prerequisites document and performed prerequisite checks and validations to make the servers install ready.
• Worked with Network teams to define the Canonical Names for HA architecture, F5 switch configuration for HA server switching and private network configurations.
• Worked with the Oracle DBA team to setup Xmeta, ODB, IADB repositories for various DataStage 11.3 environments.
• Worked with IBM Engineers, Websphere team and Oracle DBA’s to install and configure the DataStage 11.3 Environments.
• Worked with AD security teams to setup User and Group policies for DataStage 11.x Environment.
• Worked on installing and deploying various environments on 11.3 Grid Architecture and configured the Grid tool Kit and the Grid resource management tool (Platform LSF).
• Worked on performing the inplace upgrade for 11.3 Environments, gathering the prerequisites and patching the WAS and IIS to apply the mod packs for 11.5.
• Worked on installing and configuring the Information Analyzer (IA) and migration of profiling projects from 9.x to 11.x environments.
• Deployed Maintenance scripts for monitoring resource utilization, Disk Utilization and Memory Utilizations. Worked with Tivoli and Splunk teams to setup server monitoring and alerting systems based on set parameters for the 11.x Infrastructure.
• Have worked on WebSphere Network Deployment cluster to update RAC settings for Xmeta databases for a High Availability Architecture.
• Worked on Installstion and configuration of various Database clients like Oracle, Teradata, DB2, Classic Federation Server (Adabas) etc.
• Coordinated and worked with different teams on Setup and Configuration of other necessary clients like WebSphere MQ Client, Autosys, CA7, MQFTE agents, etc...
• Worked on Hadoop POC and successfully tested the integration of DataStage 11.x with Cloudera Hadoop and Hive connectivity with Kerberos authentication.
• Worked on Code migrations, project setup and configurations for 8.x to 11.x upgrade and 9.x to 11.x upgrade.

Confidential, Charlotte, NC

Sr Administrator

Responsibilities:

• Worked in a team of four IIS Administrators to Stabilize, Support and Maintain the Infosphere Information server 8.1 SDLC Infrastructure.
• Worked extensively with Production Support teams and Development teams to understand and help trouble shoot environmental issues and resolve production failures.
• Have worked on patching the SDLC environments for IIS Suite and also coordinated all patching/upgrade of components surrounding the IIS DataStage 8.1 Infrastructure.
• Worked on Project setup, configuration and support across SDLC Environments and supported production releases and Production Batch cycles.
• Developed Automation Scripts and scheduled periodic Code backups for SDLC environments and for Disaster Recovery Scenarios.
• Participated in multiple Disaster Recovery tests/simulations and built operational manuals for such scenarios.
• Worked on defining and setting up critical alerts in IBM Tivoli Monitoring tool to alert on events related to File Systems Growth and crucial processes and services like dsrpc, Loadleveler agent, WAS serviced, Autosys, MQFTE agents, etc...
• Actively involved in Incident Management and Incident Resolution process by working on issues involving IIS Infrastructure or other surrounding components.
• Worked on regularly scheduled Maintenance activities for Production and Non-Prod Servers by coordinating with Development and Infrastructure teams.
• Performed everyday Administration tasks like user access, code migration, incident resolution, database connection setup, support production implementations, etc.
• Worked on several POC projects including DataStage 9.1 on Amazon Cloud, IBM CDC, DataStage 8.7, DataStage and IA on 9.1.
• Conducted working sessions with developers to improve their understanding of the Grid Environment and Grid settings.
• Actively involved in Alaram point rotation procedure, supporting the production environment on a 24/7 basis.

Confidential, Charlotte, NC

DataStage Administrator

Responsibilities:

• Worked as ETL Administrator supporting the code conversion activities from the Informatica release 7.x & 8.x to IIS DataStage 8.1 Project.
• Extensively worked with the IBM conversion team to understand and replicate the ETL and Middleware processes like MQFTE, Websphere MQ, Storage Replication, etc…
• Worked with Subject matter experts to understand the Requirements and build a solution based on the Standards Documents.
• Worked on documenting the procedures for code migration and authored standards documents from an Admin perspective.
• Worked with Conversion teams to make them better understand the Grid architecture and helped performance tune the code for optimal run times.
• Worked on code migration process across various SDLC environments including production and Desaster Recovery sites.
• Worked with Informatica admin’s to setup landing zones for Files/DataSets and rsync process for file replications.
• Worked on defining user and group security policies on the 8.1 servers and user and group roles in DataStage 8.1 Environments.
• Worked on production code implementations and Incident resolutions.
• Actively involved in Alaram point rotation procedure, supporting the production environment on a 24/7 basis.

Confidential, Charlotte, NC

Developer/Administrator

Responsibilities:

• Worked in a team developing an Enterprise Data Warehouse and reporting solution platform on IIS DataStage 8.0.
• Participated in requirement gathering sessions with Business analysts and Reporting teams.
• Worked with Metadata tables and views to generate SQL scripts.
• Worked as a support DBA to create and Manage Database, tables, Views, Sequences, Groups, password encryption and User access.
• Implemented Data Controls and ETL Audit processing.
• Worked with Cognos team to create report specific views to improve reports performance.
• Worked on delta processing for daily incremental loads.
• Worked with QA team during testing phase in resolving defects.
• Developed a common code approach for one of the module in the project.
• Involved in DataStage Administrative activities like code migrations to IT, UAT, Connection management and maintained TNS and ODBC files.
• Worked on several source systems hosted on DB2, SQL Server, Oracle, Sybase and DB2 database as a target.
• Did Setup the DataStage test environments and DataStage Version Control.
• Used UNIX Shell scripting for different Audit purposes and in automating the DataStage process flow.
• Closely worked with QA teams during UAT for quick defect resolution.