Profile

• 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.
• Certification: Microsoft Certified Professional MCP-WindowsXP
• MCPID-3330418

Work Experience

Confidential

ETL Lead/Architect/Administrator

Confidential is the world's leading manufacturer of construction and mining equipment, diesel and natural gas engines, industrial gas turbines and diesel-electric locomotives. The company also is a leading services provider through Caterpillar Financial Services, Caterpillar Remanufacturing Services and Progress Rail Services.

Responsibilities:

DataStage 8.1 8.5

• 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

ETL Lead/Architect/Administrator

Confidential, with a single store in Confidential, A leading global specialty retailer offering clothing, accessories and personal care products for men, women, children and babies.

Responsibilities:

DataStage 7.5.1a 7.5.2, 8.1 8.5

• 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

ETL Lead/ Administrator

Confidential provides specialty financial services to individuals in the United States and Mexico with over 1,000 locations. Confidential is the largest provider of secured non-recourse loans, commonly referred to as pawn loans, and operate under the brand names Confidential

Responsibilities:

DataStage 7.5.2 8.1

• 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

Hyperion 9.3.1

• 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

Administrator/Developer

Confidential is a global supplier of office products and services. The company was incorporated in 1986 with the opening of our first retail store in Confidential, we sold 15.5 billion of products and services to consumers and businesses of all sizes through our three business segments.

Responsibilities:

DataStage 7.5.2 8.1

• 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.

Hyperion 9.3.1

• 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.

MQ Series 7/ WASA

• 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

MQ/WebLogic Administrator

Confidential is a diversified financial services company providing banking, insurance, investments, mortgage and consumer finance through more than 6,000 stores, the Internet and other distribution channels across North America and internationally. Wells Fargo headquartered in San Francisco, but Wells Fargo decentralized so every local Wells Fargo store is a headquarters for satisfying all our customers' financial needs and helping them succeed financially.

Responsibilities:

MQ Series 6

• 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

Confidential is the world-leading information technology consulting, services, and business process outsourcing organization that envisioned and pioneered the adoption of the flexible global business practices that today enable companies to operate more efficiently and produce more value.

Responsibilities:

DataStage

• 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

Confidential is a leading business and technology-consulting firm that enables companies to achieve world-class business performance. The Global Development Center is located at Hyderabad, AP, INDIA.

Responsibilities:

MQ-Series

• 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.

Confidential

Software Engineer

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

Confidential

Software Engineer

Confidential is software Development Company. The head office is located in Confidential

MCK Merchant connectivity kit Installation and Maintenance

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