SUMMARY

• 18+ years of IT experience in software Analysis, Architect, Development, Implementation and production Support of various Client/Server and Web based applications. Has strong hands - on 10+ years of experience in using ETL and BI tools like Information Server/ Infosphere DataStage 11.5/11.3/91/8.7/8.5/8.1/7.5.2 and Hyperion (Essbase, HFM, MDM and FDM), customer data and data modeling, data warehousing, ETL data integration, Excellent interpersonal and mentoring skills.
• Experience in planning, Installation and Administration of Hyperion Essbase, HFM, MDM, Planning, FDM, CIM, IBM MQSeries, and Weblogic on various platforms like UNIX, Linux, HP-Unix, Solaris, AIX and Windows NT/2000/2003.
• Experience in Installation, configuration, setup and Administration of Infosphere Suite.
• Experience in DataStage Administrator to create/modify/delete projects and cleanup projects and Implemented security among DataStage users and projects.
• Experience in Analysis, Modeling, Design and development (Extraction, Transformation and Load (ETL)) for Data Warehousing / Data Mart Applications using IBM Information Server 8.1/8.5 & IBM WebSphere (Ascential) DataStage7.5 (Designer, Manager, Director and Administrator).
• Lead discussions with client leadership explaining architecture options and recommendations. Have both hands-on as well as have ability to define and explain complex concepts and solutions. As an architect I possess the knowledge of Data analysis, Data integration, Data modeling, Data warehousing and designing.
• Extensive experience in technical architecture, data modeling, proof of concept, requirement study, system analysis, testing and development of decision support systems.
• Experience in Planning, Installation and Administration of IBM MQSeries, Websphere Application server, and Weblogic on various platforms like UNIX, Linux, HP-Unix, Solaris, AIX and Windows NT/2000/2003.
• Experience in working with RDBMS like, DB2, TERADATA, ORACLE and SQL Server.
• Knowledge across all aspects of Workflow-documenting business processes, analyzing processes, recommending improvements.
• Strong analytical and problem solving skills with the ability to quickly adapt to new environments and learn new technologies.

TECHNICAL SKILLS

BI-DW Tools: IBM Infosphere suite 11.5/11.3/9.1/8.7/8.5/8.1/ Data Stage 7.5.2 and Hyperion System 9.3.1 & 11.x (Essbase, Financial Reporting and Planning).

OS Platforms: Linux/Unix/Solaris/AIX/HP-Unix and Windows 2008/2003/2001/ NT Server and XP/Windows 7.

RDBMS: SQL Server, Oracle, DB2 and MySQL

Web/ Application Servers: IIS, Tomcat, Websphere, Weblogic and Apache.

Web Technologies: PERL, ASP, PHP, HTML, DHTML and Java Script.

Network Technologies: TCP/IP Suite, DNS, DHCP and WINS.

PROFESSIONAL EXPERIENCE

Confidential

ETL Lead/Architect/Administrator

Responsibilities:

• Confidential is completely Migration project from 8.7 to 11.5. We closely worked with MDM team.
• Lead the entire ETL team (offshore & onsite) and mentor the team.
• Migrated Patient information and lab reports and insurance information.
• IBM Information server 11.5 installation and configuration on a distributed environment.
• Preparing the servers, file system, and storage for HADR.
• Configure the servers, the network, and the storage device for HADR.
• Prepared the HADR documentation with all the required to setups to ring up the servers during DR exercise.
• Installed Datastage, Quality Stage information analyzer, IMAM and IGC.
• Involved in DR exercise and bring up the environment ever Quarter.
• Configured the Quality stage URLS to communicate with IBM MDM and resolved the issues.
• Assign the roles in the IIS console. Users mapped with DSengine credentials.
• Responsibilities include installation and configuration of Information Server on QA, and PROD environments.
• Migrated jobs from 8.7 to 11.5 and resolved the issues during migration.
• Documentation about the code change during migration.
• As a part of migration, we migrated ODBC connection, Oracle, DB2, and all RDBMS connections, resolved the Database connection issues.
• Working unix and storage team and properly mounted the file systems across the servers.
• Trouble shooting all kind of installation and migration issue.
• Coordinating with business-line team and technical teams and find out the required components to backup and recovery for DR.
• Installed Information Server/DataStage Clients on end user desktops/laptops/Citrix and troubleshooting daily issues.
• Prepared Documentation for Information server suite installation and configuration, prepared documentation for DR. Also prepared SRP’s for DR.
• Problem determination and support during testing in DR environment. (Application support and troubleshooting) and DataStage production support.
• Mentor the offshore teams
• Excessive usage of DataStage Director for monitoring Job logs to resolve issues.
• Developed Shell scripts to automate file manipulation and data loading procedures.

Environment: Information Server/ Datastage 11.3/8/7 Information Analyser, IMAM, IGC, IBM-MDM, Linux, WINDOWS, Citrix, DB2, Netezza, Oracle, SQL-Server, WASA Server.

Confidential

ETL Lead/Architect/Administrator

Responsibilities:

• IBM Information server 11.5 installation and configuration on a distributed environment.
• Installed Datastage, information analyzer, IMAM and IGC.
• Define the security AD and Unix groups and configured IIS with LDAP. Assign the roles in the IIS console. Users mapped with DSengine credentials.
• Responsibilities include installation and configuration of Information Server on QA, and PROD environments.
• Migrated jobs from 8.7 to 11.5 and resolved the issues during migration.
• As a part of migration, we migrated ODBC connection, Oracle, DB2, Netezza and all RDBMS connections, resolved the Database connection issues.
• Preparing the servers, file system, and storage for HADR.
• Configure the servers, the network, and the storage device for HADR.
• Prepared the HADR documentation with all the required to setups to ring up the servers during DR exercise.
• Installed Datastage, Quality Stage information analyzer, IMAM and IGC.
• Involved in DR exercise and bring up the environment ever Quarter.
• Working unix and storage team and properly mounted the file systems across the servers.
• Trouble shooting all kind of installation and migration issue.
• Coordinating with business-line team and technical teams and find out the required components to backup and recovery for DR.
• Installed Information Server/DataStage Clients on end user desktops/laptops/Citrix and troubleshooting daily issues.
• Prepared Documentation for Information server suite installation and configuration, prepared documentation for DR. Also prepared SRP’s for DR.
• Problem determination and support during testing in DR environment. (Application support and troubleshooting) and DataStage production support.
• Mentor the offshore teams
• Excessive usage of DataStage Director for monitoring Job logs to resolve issues.
• Developed Shell scripts to automate file manipulation and data loading procedures.

Environment: Information Server/ Datastage 11.3/8/7 Information Analyser, IMAM, IGC, AIX, WINDOWS, Citrix, DB2, Netezza, Oracle, SQL-Server, WASA Server, and Control-M

Confidential

ETL Lead/Architect/Administrator

Responsibilities:

• Mostly involved in DR exercise IIS DS81 & IIS-DS87, Citizens does DR every quarter.
• Preparing the servers, file system, and storage for HADR.
• Configure the servers, the network, and the storage device for HADR.
• Prepared the HADR documentation with all the required to setups to ring up the servers during DR exercise.
• Installed Datastage, Quality Stage information analyzer, IMAM and IGC.
• Involved in DR exercise and bring up the environment ever Quarter.
• IBM Information server installation and configuration on a distributed environment.
• Create Data Architect technical specification documents for extraction, transformation, cleansing, and load (ETL) programs.
• Responsibilities include installation and configuration of Information Server on QA, and PROD environments.
• Coordinating with business-line team and technical teams and find out the required components to backup and recovery for DR.
• Installed Information Server/DataStage Clients on end user desktops/laptops/Citrix and troubleshooting daily issues.
• Prepared Documentation for Information server suite installation and configuration, prepared documentation for DR. Also prepared SRP’s for DR.
• Problem determination and support during testing in DR environment. (Application support and troubleshooting) and DataStage production support.
• Written Configuration files for Performance tuning in production environment.
• Involved in unit, performance, Regression and integration testing of DataStage jobs and prepared Documentation
• Excessive usage of DataStage Director for monitoring Job logs to resolve issues.
• Developed Shell scripts to automate file manipulation and data loading procedures.

Environment: Information Server/ Datastage 11.3/8/7/8.1/7.5.1 , Information Analyser, AIX, Linux, WINDOWS, Citrix, DB2, Oracle, SQL-Server, WASA Server, and AutoSys

Confidential

ETL Lead/Architect/Administrator

Responsibilities:

• IBM Information server installation and configuration on a distributed (Windows) environment.
• Create Data Architect technical specification documents for extraction, transformation, cleansing, and load (ETL) programs.
• Migrating developed DataStage Jobs from DEV to QA and to PROD.
• Attend Design Review Board (DRB) meetings to discuss the data model changes in detail and attend to Technical Forum meetings to discuss Design/Implementation details of the project, coordinate development activities with Offshore Development Team.
• Installed Information Server/DataStage Clients on end user desktops/laptops/Citrix and troubleshooting daily issues.
• Prepared Documentation for Information server suite installation and configuration.
• Problem determination and support during testing phases. (Application support and troubleshooting) and DataStage production support.
• Gathering Functional requirements from Operational, Dealers & Business Users and translate the Functional requirements to Technical requirements & specifications.
• Written Configuration files for Performance tuning in production environment.
• Involved in unit, performance, Regression and integration testing of DataStage jobs and prepared Documentation
• Excessive usage of DataStage Director for monitoring Job logs to resolve issues.
• Developed Shell scripts to automate file manipulation and data loading procedures.

Environment: DataStage 9.1, Information Analyser, WINDOWS, Citrix, DB2, WASA Server, and AutoSys

Confidential

ETL Lead/Architect/Administrator

Responsibilities:

• Extensive data analysis on profiles (Machine, Dealer and customer) and purchase data.
• Gathering Functional requirements from Operational, Dealers & Business Users and translate the Functional requirements to Technical requirements & specifications.
• IBM Information server installation and configuration on a distributed environment.
• Create Data Architect technical specification documents for extraction, transformation, cleansing, and load (ETL) programs.
• Responsibilities include installation and configuration of Information Server on DEV, QA, PPROD and PROD environments.
• Migrating developed DataStage Jobs from DEV to QA and PPROD to PROD.
• Attend Design Review Board (DRB) meetings to discuss the data model changes in detail and attend to Technical Forum meetings to discuss Design/Implementation details of the project, coordinate development activities with Offshore Development Team.
• Installed Information Server/DataStage Clients on end user desktops/laptops/Citrix and troubleshooting daily issues.
• Extensively worked with SAP stages (IDOC, BW and ABAP) and trouble shoot the connection issue with SAP.
• Prepared Documentation for Information server suite installation and configuration.
• Problem determination and support during testing phases. (Application support and trouble shooting) and DataStage production support.
• Written Configuration files for Performance tuning in production environment.
• Involved in DR exercise, as part of DR we back up the projects, scripts and various required software and restore them in the designated server make the whole environment available for DR testing purpose.
• Involved in unit, performance, Regression and integration testing of DataStage jobs and prepared Documentation
• Excessive usage of DataStage Director for monitoring Job logs to resolve issues.
• Developed Shell scripts to automate file manipulation and data loading procedures.
• Resolved issues occurred during regular testing.
• Trouble shooting Database connectivity problems and Created documentation for various administration activities.

Environment: DataStage 8.5, Information Analyser, Redhat Linux, Citrix, DB2, Oracle, SQL-server, MySQL, PERL, SAP, WASA Server, Tidal, MQ series and Windows 2008.