SUMMARY

• 12+ years of overall IT experience in Design, Development using Data warehousing application DataStage.
• Highly proficient in ETL tool as a DataStage Administrator.
• Installed and configured IBM Information server 8.1, 8.5, 8.7,11.3 and 11.7.1.1 (Latest version) on LINUX/AIX environment.
• Highly proficient in understanding different Datastage architectures (Single server installation, Multi - engine tier installation using Websphere cluster)
• Managed SCM processes which include compiling, packaging, deploying and application configurations. (Code migration using ISTOOL Linux and Windows based)
• Extensively worked with Version Control Systems like SVN (Subversion) and ADO GIT.
• Good understanding of upcoming IBM cloud releases and Metal CI integration advantages.
• Designed and Installed current Datastage versions 11.3 and 11.7.1.1 (Latest version) Confidential bank infrastructure.
• Good understanding of agile methodologies.
• Performed as a team member on a agile team focused on software delivery and support.
• Good understanding of Cloud (Azure, AWS, GCP), DevOps, Configuration management, Infrastructure automation, Continuous Integration and Delivery (CI/CD).
• Proposed and Implemented Active Directory and LDAP configuration model to control teh Datastage Developers/Support user’s access.
• Created Road Map documents to prepare teh application owners and leads before any major version migrations.
• Managed all teh migration projects successfully 7.5 to 8.1 and 8.1 to 9.1, currently working on latest version 11.3 to 11.7.1.1 projects/application migrations.
• Involved in creating standard practices for all new application needs and making sure that Datastage application adhere to teh standards to avoid any audit findings.
• Extensive experience to perform DR/HA exercises 8.1, 8.7 (Cluster Architecture) and 11.3 and 11.7.1.1
• Good understanding of Hadoop distributed file system (HDFS) to support Big Data File (BDFS)stage and Cloudera architecture, supported Streamsets and tools upgrades.
• Having good working noledge in Oracle, SQL Server, Netezza, DB2 and Teradata.
• Ability to understand teh infrastructure quickly and providing teh required support in Install, configure, backup, and patch & Fix Packs Datastage as per teh technical needs.
• Communicating with IBM Support team for any DataStage tool related issues, technical issues and fixing them at environment level or job level.
• TEMPEffectively resolved issues on time.
• Good communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Installation of Information server on LINUX/AIX environment and applying latest patches/fixpacks as and when required.
• Setting up teh project environment for teh new applications and supporting them.
• Ensuring teh DataStage server availability of Production/UAT/Development environments for teh full time.
• Providing teh technical support for teh DataStage developers for all teh applications
• Attending different meeting’s with BU Champions/Managers as part of creating their application in Datastage regions
• Managed SCM processes which include compiling, packaging, deploying and application configurations. (Code migration using ISTOOL Linux and Windows based)
• Attending crisis calls in case of any urgent/priority issues and providing them solution in fixing teh reported issues.
• Worked with Developers for code/design changes of teh job for getting better performance by suggesting suitable environment variables.
• Helping Application team to resolve teh DS/DB server or network related performance issues, during Production schedule. To complete their load on time.
• Ensuring teh DataStage server availability of Production/UAT/Development environments for teh full time.
• Maintenance of backups and Interacting with application owners for all server related activities.
• Having good working experience in DataStage Development.
• Extensively used ETL methodology for supporting Data Extraction, Transformation and Loading Data from various sources into Data Warehouse using DataStage.
• Good expertise in DataStage Client Tools - Designer, Director and Administrator.
• In depth experience in dealing with DataStage stages (Database / File / Processing).

TECHNICAL SKILLS

ETL: DataStage 7.5, 8.1, 8.5, 8.7, 9.1 and 11.3 and 11.7.1.1 (including Information Analyzer and QualityStage, UNIX shell script (ksh/csh)

O/S: Windows NT, UNIX (Linux, HPUX, Sun, AIX)

RDBMS: Oracle 9, 10, 11.g, Teradata 14, DB2 8.1,9.7 & 10.1, SQL Server 2003, 2008, Netezza and Teradata

Big Data Platforms: Cloudera and Microsoft Azure and Big Insight

OTHER: Stramsets, Autosys, Control M conversion, Business Objects, Cognos

Version Control: ADO Git and SVN

PROFESSIONAL EXPERIENCE

Senior ETL Administrator

Confidential

Responsibilities:

• Providing teh technical support for teh DataStage developers for all teh Confidential Bank Environments
• Completed latest DataStage versions 11.7.1.1 (DEV, SIT, QA, PROD and DR) installation and involved in migration meetings.
• Created installations, and patch installation documents.
• Good understanding of latest version IBM Information Server for Data Warehousing V11.7.1.1 and Cloudera cluster implementation trends.
• Extensive experience to perform DR exercises 8.1, 8.7 (Cluster Architecture) and 11.3 and 11.7.1.1
• Performed as a team member on a agile team focused on software delivery and support.
• 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 migration)
• Attending crisis calls in case of any urgent/priority issues and providing them solution in fixing teh reported issues.
• Making sure Performance of PROD server is stable all teh times and in case of any peeks during major PROD cycle schedules (identify and fix teh issues causing teh server slow ness)
• Communicating with IBM, getting teh resolutions for any complex DataStage issues and implementing them.
• Installation of Information server on AIX/Linux environment and applying patches if required.
• Worked with Developers for code/design changes of teh job for getting better performance by suggesting suitable environment variables.
• Helping Application team to resolve teh DS/DB server or network related performance issues, during Production schedule. To complete their load on time.
• Ensuring teh DataStage server availability of Production/UAT/Development environments for teh full time.
• Setting up teh project environment for teh new Confidential applications and supporting them.
• Maintenance of backups.
• Interacting with clients for all server related activities.
• Worked with IBM in fixing major prod issues, which will impact teh business, and able to manage all pressured situation with 100% commitment.

Software Engineer

Confidential

Responsibilities:

• Proposed and triggered latest DataStage versions 11.3 (DEV, SIT, QA, PROD and DR) installation and involved in migration meetings.
• Good understanding of latest version IBM Information Server for Data Warehousing V11.3 and Hadoop implementation trends
• 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 teh reported issues.
• Implemented hostname + domain change of Prod server as part of teh Server move.
• Worked with IBM in fixing major prod issues, which will impact teh business, and able to manage all pressured situation with 100% commitment.

Senior System Administrator

Confidential

Responsibilities:

• Providing teh technical support for teh DataStage developers for all teh Confidential NA applications
• Attending different meeting’s with BU Champions/Managers as part of creating their application in NA region
• Attending crisis calls in case of any urgent/priority issues and providing them solution in fixing teh reported issues.
• Communicating with IBM, getting teh resolutions for any complex DataStage issues and implementing them.
• Installation of Information server on AIX/Linux environment and applying patches if required.
• Proposed and triggered POC for latest DataStage versions 9.1 and involved in latest version 11.3 migration meetings.
• Supporting HA/DR exercises as and when required.
• Worked with Developers for code/design changes of teh job for getting better performance by suggesting suitable environment variables.
• Helping Application team to resolve teh DS/DB server or network related performance issues, during Production schedule. To complete their load on time.
• Ensuring teh DataStage server availability of Production/UAT/Development environments for teh full time.
• Setting up teh project environment for teh new Confidential applications and supporting them.
• Maintenance of backups.
• Interacting with clients for all server related activities.
• Leading teh 4 member’s admin team and guiding them to perform various tasks.
• As part of DataStage Standardization and Globalization process, worked with different Confidential Global regions (UK, US, Asia, Brazil and Turkey etc…)
• This Process consists of Standardizing teh DataStage Administration (like Installation, Naming conventions, Installation FILESYSTEMS, UNIX users and Groups etc…)
• Worked with different BU Teams to create a single DataStage code backup process by using ISTOOL tools utility.
• Planned and Implemented Metadata server move
• Proposed hostname change as part of teh Datacenter separation and implemented teh same successfully.
• Implemented hostname + domain change of Prod server as part of teh Server move.

Consultant

Confidential

Responsibilities:

• Providing teh technical support for teh DataStage developers for all teh COLT applications
• Communicating with IBM, getting teh resolutions for any complex DataStage issues and implementing them.
• Installation of Information server on LINUX environment and applying patches if required.
• Ensuring teh DataStage server availability of Production/UAT/Development environments for teh full time.
• Setting up teh project environment for teh new COLT applications and supporting them.
• Maintenance of backups.
• Migration of teh projects from one environment to other.
• Supporting and fixing teh bugs/enhancing teh new requirements of teh users in UAT.