A competent professional with over 10+ years of experience in IT industry. Expertise in IBM WebSphere message Broker, MQ, WebSphere message Broker, IIB, Oracle, DB2, SQL Server, MySQL, Oracle, DB2, MS SQL server.
operations, test, engines, oracle, architect, class, ibm mq, monitoring, mentoring, visio, basis, financial services, developer, construction, middleware, reporting, shell, natural, sap, cases, testing, reports, web, design, edw, data warehouse, scheduling, business objects, sql, bmc remedy, web ser
Migration of Informatica PowerCenter 9.6.1 to IBM DB2. This includes writing SQL queries, test cases, testing, UAT and production support for the EDW.
Involved in the migration of the project from Oracle to Greenplum database using Informatica Power Center. The data was extracted from source systems, loaded the data into target tables, and then to load the data into the
Worked on Informatica migration project. Created and executed the test plan for the data warehouse and ETL process. Responsible for planning, scheduling, coordinating and managing the UAT activities.
Perform the migration of Informatica 9.5.10 to Oracle 11.1.6.x and IBM DB2 for testing and test planning.
Responsible for the migration of the application from IBM Rational ClearQuest to HP-UNIX and Windows platforms. Involved in writing the test plans and mapping documents.
Planning and scheduling of ETL jobs using BMC Remedy, Oracle database, Netezza, and Autosys. This includes the design, development, testing, and implementation of the OLAP cubes.
Experience in using IBM DB2 for troubleshooting and debugging, and involved in migration of ETL jobs from Dev, test, QA, production, and Prod to PROD.
Worked on IBM WebSphere MQ series for troubleshooting, debugging, and tuning of the ETL jobs. Developed UNIX shell scripts to automate the administrative tasks.
Experience in IBM InfoSphere DataStage 8.1, Oracle 11g, UDB, SQL Server, Windows 2008, HP-UX, OLAP, database design, coding, testing, troubleshooting, training, and implementation.
Involved in the migration of the application from HP ALM to IBM InfoSphere DataStage v184.108.40.206.
Involved in the development of the ETL process from the client and writing the SQL scripts, stored procedures, functions, and packages using IBM InfoSphere Datastage.
Worked on IBM WebSphere application Server, IBM WebSphere MQ, SQL Server, Teradata, and troubleshooting, performance tuning, and Developer support.