SUMMARY:

• 9+ years of overall IT experience in Design, Development using Data warehousing application DataStage and Cognos.
• Highly proficient in ETL tool as a DataStage Administrator.
• Good knowledge on Cognos Administration.
• Highly proficient in understanding different Datastage architectures (Single server installation, Multi - engine tier installation using Websphere cluster)
• Installed and configured IBM Information server 8.1, 8.5, 8.7, 9.1, 11.3 and 11.5 (Latest version) on LINUX/AIX environment.
• Designed and Installed Current Architecture for Datastage versions 11.3 and 11.5, for HSBC bank infrastructure.
• Managed all the migration projects successfully 8.1 to 9.1 and 9.1 to 11.3, currently working on latest version 11.3 to 11.5 projects/application migrations.
• Developed Shell scripts for automation of build and release process.
• Designed and implemented GRID architecture for 11.5v build using LSF.
• Write and update some deploy or application scripts in Shell for various testing and system management purposes.
• Enabling and assisting the developers in scheduling the jobs using SAP BW, Control M.
• Ability to understand the infrastructure quickly and providing the required support in Install, configure, backup, and patch & Fix Packs Datastage as per the technical needs.
• Proposed and Implemented Active Directory and LDAP configuration model to control the Datastage Developers/Support user’s access.
• Automation of manual tasks using Shell scripting.
• Created Road Map documents to prepare the application owners and leads before any major version migrations.
• Highly proficient in creating and providing ETL applications for different project/business needs.
• Involved in creating standard practices for all new application needs and making sure that Datastage application adhere to the standards to avoid any audit findings.
• Designed and developed the projects using GRID Architecture.
• Fixing the issues of installation and configuration and also collecting the data, files and artifacts using ISAlite tool.
• Good understanding of latest version IBM Information Server for Data Warehousing V11.5 and Hadoop implementation trends
• Extensive experience to perform DR/HA exercises 8.1, 8.5, 9.1, 11.3 and 11.5.
• Extensive experience in Architecture, Administration, Development, Tuning and Maintenance of DataStage applications.
• As part of 11.5 migration worked on POC (proof of concept), which helped to identify all 11.3 versions related migration problems. (Installed DEV, SIT, QA, PROD & DR servers)
• Good understanding of Hadoop distributed file system (HDFS) to support Big Data File (BDFS)stage.
• Extensive working knowledge in LINUX/AIX.
• Having good working knowledge in Oracle, SQL Server, Netezza, DB2 and Teradata.
• Communicating with IBM Support team for any DataStage tool related issues, technical issues and fixing them at environment level or job level.
• Good knowledge in Data Warehouse Architecture and Data Warehouse concepts.
• Trained on Informatica Powercenter 8.1 and Installed a test server as part of the POC.
• Effectively resolved issues on time.
• Hands on experience with Cognos Business Intelligence tool & 10 Suite (Framework Manager, Report studio, Query Studio, Analysis Studio, Access Manager, Scheduler, Transformer, TM1, Cognos Report Net v1.0/1.1)
• Performing Cognos maintenance and support of the availability and functionality of these systems which includes OS Patching, Database upgrades and platform upgrades
• Good understanding of technical trends, architectures and highly motivated to know more Skills in analyzing about latest technology, new software and products.
• 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 the project environment for the new applications and supporting them.
• Ensuring the DataStage server availability of Production/UAT/Development environments for the full time.
• 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 Datastage regions
• Attending crisis calls in case of any urgent/priority issues and providing them solution in fixing the reported issues.
• 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 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).
• Handling Informatica Admin Responsibilities as an additional role.
• Work closely with architects and infrastructure groups to ensure system stability and longevity
• Manage timely flow of business intelligence information to users.
• Assist in the development of security tools in Cognos 8 using LDAP and Active directory while holding responsibility for maintaining run books and project documentation in Sharepoint
• 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

TECHNICAL SKILLS:

ETL: DataStage 7.5, 8.1, 8.5, 8.7, 9.1, 11.3 and 11.5 (including Information Analyzer and QualityStage, UNIX shell script (ksh/csh), Informatica PowerCenter 8.1,Cognos.

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

OTHER: GIS, NDM, Humming Bird Exceed & BI Query, Autosys, Control M conversion, shell scripts (ksh/csh), Oracle Enterprise Manager, Developer 2000, SQLPlus, C, Toad, DataStage Version Control, MKS, Quality Control

OLAP: Exposure to Business Objects, Cognos

PROFESSIONAL EXPERIENCE:

Confidential

Senior Datastage Administrator

Responsibilities:

• Providing the technical support for the DataStage developers for all the HSBC NA 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 HSBC bank 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.
• Setting up the project environment for the new HSBC applications and supporting them.
• 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 and 11.5, DB2 9.7 & 10.1, Teradata 14.10&Cognos 10.2, MKS, QC, Control-M, ISR, Access Management.

Confidential

DataStage Administrator for COLT Environments

Responsibilities:

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

Environment: LINUX, DataStage 8.0.1, DataStage Administrator,ISR Admin.

Confidential

DataStage Developer

Responsibilities:

• Analyzing the requirements and implementing the code through DataStage jobs.
• Developing Jobs for extracting, transforming, integrating and loading data into Target tables.
• Developed and Used Shared containers within the Jobs.
• Used the stages like Sequential File, Dataset, Funnel, Transformer, Sort, Lookup, Filter, Join, Merge, Oracle Stage, Netezza and Remove Duplicates stage.
• Designed Sequencer to automate the entire process of data loading.
• Involved in unit testing.
• Supporting and fixing the bugs/enhancing the new requirements of the users in UAT.

Environment: LINUX, DataStage 8.0.1, Oracle9i, Netezza