SUMMARY

• 15+ 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 OLAP tools like Information Server/ Infosphere DataStage 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 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.
• 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.
• 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 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.

Firewall: Sonicwall, Siemens, Belkin, Linksys and Netgear.

PROFESSIONAL EXPERIENCE

Confidential, Peoria,IL

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, WASA Server, Tidal, MQ series and Windows 2008.

Confidential, San Francisco, CA

ETL Lead/Architect/Administrator

Responsibilities:

• Participating in the call of Business Requirements Designs from business users and work with team for shaping out the Design of ETL tasks lists.
• Involved in the complete Design & Architecture of tables for ETL logic, written high level Designs & Detail Designs for ETL mappings as per business requirements. Attending the designers call to clarify the issues in the designs to the developers
• Ensure the work progressing to different environment as per schedule with quality by tracking the status of team members’ work, co-coordinating with off-shore team and consolidating the issues and help the team to understand and fix the issues.
• IBM Information server installation and configuration on a distributed environment and responsibilities include installation and configuration of Information Server on DEV, UAT and PROD environments.
• Make sure developed DataStage Jobs migrate from DEV to UAT and UAT to PROD.
• 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.
• Prepared Documentation for Information server installation and configuration.
• Problem determination and support during testing phases. (Application support and trouble shooting).
• Developed Shell scripts to reset DataStage jobs and unlock the DataStage jobs.
• 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, Aix WebSphere Application server, MQ series, Oracle, SQL Server, DB2, Tivoli work scheduler and Windows 2003

Confidential, Fort Worth, TX

ETL Lead/ Administrator

Responsibilities:

• Data Stage installation and configuration on a distributed environment.
• Responsibilities include installation and configuration of Data Stage on DEV, UAT and PROD environments.
• Migrating developed DtatStage Jobs from DEV to UAT and UST to PROD.
• DataStage PROD support and trouble shooting.
• Involved in planning and implementation of DataStage
• Installed DataStage Clients on end user desktops/laptops and troubleshooting daily issues.
• Data Stage DR back up.
• Prepared Documentation for DataStage installation and configuration.
• Problem determination and support during testing phases. (Application support and trouble shooting).
• Written Configuration files for Performance and production environment.
• Developed Shell scripts to reset DataStage jobs and unlock the DataStage jobs.
• 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: Data stage, Aix Java, Websphere Application server, Tivoli work Scheduler and Windows 2003

Confidential

Responsibilities:

• Hyperion system 9 installation and configuration on a distributed environment.
• Responsibilities include installation and configuration of Hyperion System 9(Essbase, Financial Reporting and Planning) on DEV, UAT and PROD environments.
• Migrating developed Applications/Data from DEV to UAT and UST to PROD.
• Hyperion systems 9 on call PROD support and trouble shooting.
• Hyperion System 9 weekly and daily back up.
• Involved in planning and implementation of Hyperion System 9.
• Installed Hyperion System 9 Clients on Citrix server for international users
• Installation of Weblogic server on HP-Unix and Solaris.
• Hyperion System 9 DR back up.
• Configuring Hyperion System 9 Print server.
• Prepared Documentation for Hyperion System 9 installation and configuration.
• Problem determination and support during testing phases. (Application support and trouble shooting)
• Trouble shooting Database connectivity problems and Created documentation for various administration activities.

Environment: Hyperion System 9 (Financial Reporting and Planning), Java (JDK 1.2, Weblogic Server, Tivoli work Scheduler, Windows 2003 and UNIX/AIX.

Confidential, Boca Raton, FL

Administrator/Developer

Responsibilities:

• Interacted with business analysts to gather business user requirements.
• Involved in designing and developing IBM Websphere Datastage ETL jobs.
• Created dimensional models using Erwin.
• Created physical designs for implementation on Oracle database.
• Created generic Datastage sequence by integrating korn shell scripts to schedule ETL jobs.
• Generated test environment and production environment migration documents.
• IBM Information server installation and configuration on a distributed environment.
• Responsibilities include installation and configuration of Information Server 8.1 on DEV, UAT and PROD environments.
• Migrating developed DtatStage Jobs from DEV to UAT and UST to PROD.
• DataStage PROD support and trouble shooting.
• Involved in planning and implementation of Information Server 8.1
• Installed Information Server/DataStage Clients on end user desktops/laptops and troubleshooting daily issues.
• Information/Data Stage DR back up.
• Prepared Documentation for Informations server8.1 installation and configuration.
• Problem determination and support during testing phases. (Application support and trouble shooting).
• Written Configuration files for Performance tuning in production environment.
• Developed Shell scripts to reset DataStage jobs and unlock the DataStage jobs.
• 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: Data stage, Sun Solaris - Sparc10 (64bit), Java WebSphere Application server, Tivoli and Windows.

Confidential

Responsibilities:

• Hyperion system 9 installation and configuration on a distributed environment.
• Responsibilities include installation and configuration of Hyperion System 9(Essbase, Financial Reporting and Planning) on DEV, UAT and PROD environments.
• Migrating developed Applications/Data from DEV to UAT and UST to PROD.
• Hyperion systems 9 on call PROD support and trouble shooting.
• Hyperion System 9 weekly and daily back up.
• Involved in planning and implementation of Hyperion System 9.
• Installed Hyperion System 9 Clients on Citrix server for international users
• Installation of Weblogic server on HP-Unix and Solaris.
• Hyperion System 9 DR back up.
• Configuring Hyperion System 9 Print server.
• Prepared Documentation for Hyperion System 9 installation and configuration.
• Problem determination and support during testing phases. (Application support and trouble shooting)
• Trouble shooting Database connectivity problems and Created documentation for various administration activities.

Environment: Hyperion System 9 (Financial Reporting and Planning, HFM, MDM and FDM), Java, Weblogic Server, Windows 2003 and UNIX/Solaris.

Confidential

Responsibilities:

• Installation of Websphere MQ series on PROD, UAT, DEV and BCP systems.
• BPEL PM Installation and configuration of SOA Suite POC environment.
• Responsibilities include installation and configuration of BPEL PM, configuration of adapters (MQ, DB, and JMS).
• Implementation of MQ Queue- Manager clustering across the network.
• Creating and customization of Queue managers on Solaris and HP-Unix.
• Designed, Created and Configured Queue Managers, Queues, Process definitions, Channels.
• Design and integration of native MQ java and JMS application with database.
• Systems integration using WebSphere MQ on distributed environment.
• Installation of WebSphere MQ 7.1 server and clients on distributed platforms (Windows)
• Creation, modification and deletion of MQ objects.
• Documentation for application development. (Middleware specific implementation details)
• Created documentation for various administration activities specific for SOA Engine.

Environment: BPEL PM, MQSeries, Java (JDK 1.2), XML, ilder, Websphere Application Server and Windows 2003.

Confidential, Concord, CA

MQ/WebLogic Administrator

Responsibilities:

• Installation of Websphere MQ series on PROD, UAT, DEV and BCP systems.
• Implementation of MQ Queue- Manager clustering across the network.
• Creating and customization of Queue managers on Solaris and HP-Unix.
• Designed, Created and Configured Queue Managers, Queues, Process definitions, Channels.
• Implementing the Weblogic clustering between Weblogic managed server instances.
• Deploying the applications (JMS, EJB) on Weblogic server on different machines.
• Design and integration of native MQ java and JMS application with database.
• Systems integration using WebSphere MQ on distributed and mainframe.
• Installation of WebSphere MQ 6.0 server and clients on distributed platforms (HP-Unix and Solaris)
• Created documentation for various administration activities specific for SOA Engine.

Environment: MQSeries, Java, Websphere Application Server, Windows NT and UNIX/Solaris.

Confidential

Sr. Software Engineer

Responsibilities:

• Data Stage 7.5.2 installation and configuration on a distributed environment.
• Responsibilities include installation and configuration of Data Stage on DEV, UAT and PROD environments.
• Migrating developed DtatStage Jobs from DEV to UAT and UST to PROD.
• DataStage PROD support and trouble shooting.
• Involved in planning and implementation of DataStage
• Installed DataStage Clients on end user desktops/laptops and troubleshooting daily issues.
• Data Stage DR back up.
• Prepared Documentation for DataStage installation and configuration.
• Problem determination and support during testing phases. (Application support and trouble shooting)
• Trouble shooting Database connectivity problems and Created documentation for various administration activities.

Environment: Data stage, Sun Solaris - Sparc10 (64bit), Java (JDK 1.2), Weblogic Server, Tivoli, Windows 2003 and UNIX/Solaris.

Confidential

Software Engineer

Responsibilities:

• Installation of Websphere MQ series on PROD, UAT, DEV and BCP systems.
• BPEL PM Installation and configuration of SOA Suite POC environment.
• Responsibilities include installation and configuration of BPEL PM, configuration of adapters (MQ, DB, and JMS).
• Implementation of MQ Queue- Manager clustering across the network.
• Creating and customization of Queue managers on Solaris and HP-Unix.
• Designed, Created and Configured Queue Managers, Queues, Process definitions, Channels.
• Design and integration of native MQ java and JMS application with database.

Environment: Sun Solaris - Sparc10 (64bit), Weblogic Server, Tivoli, Windows 2003 and UNIX/Solaris.