Profile

• More than nine years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• Extensive experience with analysis, design, development, customizations and implementation of software applications including a retail banking suite and Siebel CRM.
• Experience in analyzing and translating business requirements to technical requirements and architecture.
• Strong ETL and database skills, Object Oriented Programming and development knowledge.
• Experience in working in teams. Handled multiple roles – Developer, Senior Developer and Technical lead.
• Hold a management degree with specialization in Operations and IT
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

Siebel CRM: Siebel 7.7 Certified Core Consultant, EIM, Siebel Configuration, Siebel EAI
Standr’ds: XSD, WSDL, SOAP
ETL: Informatica Power Center, Workflow manager
RDBMS: Oracle 7, DB2, MS-Access
Languages: C, Pro*C, PL/SQL, Unix shell scripting, Java
O/S: UNIX, AIX, Windows 9x, Linux
Processes: IBM’s QMS (Quality Management System)

• Bachelor’s in Information and Technology

Dec 09 – Till date, Data Migration Lead, Confidential, Bethesda, MD, USA

Project involves data migration from legacy hospitality systems to Siebel eHospitality 8.0. The legacy systems that are being converted are Marriott’s in-house property management system called Next Generation System (NGS) and New Market International’s Delphi system. This project is called Marriott Consolidated Inventory Project phase-II. The project involves writing end to end data migration scripts using Siebel’s proprietary Enterprise Integration Manager (EIM). The data transformation and cleansing was done using ETL(Extract Transform and load) tool called Informatica Power Center.

Apart form data migration, I was also involved in system integration to a limited extend. I integrated certain legacy applications with Siebel using Siebel EAI technologies. I configured Siebel for receiving in-bound web services as well as using out-bound web services provided by external applications.

Responsibilities:

• Preparing configuration files to be used for EIM process.
• Writing wrapper shell scripts for running EIM processes on server manager prompt and Informatica ETL workflows.
• Writing Informatica mapping scripts for EIM table data load.
• Scheduling job conversion job streams on Tivoli Workflow Scheduler.
• Writing PLSQL and Java programs for data validation and post conversion reports.
• Writing stand-alone data management tools, which are run as scheduled jobs.
• Maintenance of code and design documents.
• Configuring Siebel’s integration with external application using inbound and outbound web services, integration objects, workflows and business services.

Environment: Siebel 8.0, DB2, AIX, TWS.

Team Size : 5

Aug 08 – Dec 09, Advisory Consultant, Confidential,Bethesda, MD, USA

Aim of the project was to migrate data from Siebel 6.0 Sales Force Automation to Siebel 8.0 eHospitality. This project is called Marriott Consolidated Inventory Project Release-I. The project involved writing end to end data migration scripts using Siebel’s proprietary Enterprise Integration Manager(EIM). The data transformation and cleansing was done using ETL(Extract Transform and load) tool called Informatica Power Center.

Responsibilities:

• Preparing configuration files to be used for EIM process.
• Writing wrapper shell scripts for running EIM processes on server manager prompt and Informatica ETL workflows.
• Writing Informatica mapping scripts for EIM table data load.
• Writing business services to maintain Siebel application data.
• Writing PLSQL and Java programs for data validation and post conversion reports.
• Maintenance of code and design documents.

Environment: Siebel 8.0, DB2, AIX.
Team Size : 4

Apr 08 – Aug 08, Senior Application Consultant, Confidential, White Plains, NY, USA

Worked as a technical consultant for IBM US’s client, hospitality major. This project involved migration projects from Siebel 6.0 and a legacy system called KAM(Key Account Management) to Siebel 8.0.

Responsibilities:

• Prepare mapping document for data mapping between legacy and current system with the help of business.
• Writing Informatica scripts for EIM table data load.
• Writing code in PL/SQL for data migration/data cleanup in the staging area.
• Designing and writing EIM jobs for data migration into Siebel base tables.
• Tests EIM jobs on development and coordinating with QA team for validations.
• Deployment of data migration code on production.
• Post deployment data support.

Environment: Siebel 8.0, Oracle, Unix.
Team Size : 2

Nov 07 – Apr 08, Senior Application Consultant,Confidential,Braintree, MA, USA

Worked as a technical consultant for IBM US’s client, Starwood Hotels and Resorts. The project is called eSales support and development and is being executed from Starwood Technology Center in Braintree, Massachusetts. As part of Level 2 support - it takes care of problem determination to identify what area might have caused a data problem, such as an EIM load, application problem, or a legacy application migration problem. I was the application owner for the sales application which is used by around 150 strong sales team throughout America and is considered a very critical application for the client and its downtime has cost implication. In the capacity of the application owner I was also responsible for coordinating other support teams in case of severity one issues.

Responsibilities:

• Create new EIM jobs and make new changes to existing jobs for each new release.
• Writing SQL embedded C programs and PL/SQL procedures to perform insert, delete, update and merge on SIEBEL tables.
• Design/implement/test changes to EIM jobs after roll out to production.

Environment: Siebel eSales, Oracle, Windows.
Team Size : 2

Aug 04 – Oct 07, Senior Application Consultant, Confidential, Gurgaon, India

Worked as a Technical Lead in DataOps Development project of IGA at IBM Gurgaon. DataOps is part of the Siebel Development Factory, which focuses on legacy data migration and interfaces that transfer data into Siebel. It also reviews data mapping from legacy applications to Siebel during the CRM requirements phases, to identify impacts on current data associated with the business areas. As part of Level 2 support - it takes care of problem determination to identify what area might have caused a data problem, such as an EIM load, application problem, or maybe a legacy application migration problem and provide a suitable fix.

Responsibilities:

• Create new EIM jobs and make new changes to existing jobs for each new release.
• Writing SQL embedded C programs to perform insert, delete, update and merge on SIEBEL tables.
• Notification of reviews for new EIM jobs or changes to EIM jobs.
• Review and approve designs for changes to EIM jobs.
• Designs/implements/tests changes to EIM jobs after roll out to production.
• Perform all EAI maintenance and enhancements.
• Review the code of the assigned team members before code is frozen for functional testing.
• Mentoring and guiding team members on technical issues.

Environment: Siebel Call Center Application, Siebel Partner Portal Application, AIX, DB2.
Team Size : 8 to 10

Nov 02 – Jul 04, Team Member Confidential,M’bai, India

Tata Consultancy Services Limited (TCS) is the world-leading information technology consulting, services, and business process outsourcing organization which, with its interests in Energy, Telecommunications, Financial Services, Chemicals, Engineering & Materials, has a presence in 34 countries across 6 continents.
Worked as a team member of ISBS group. ISBS is a banking software product developed by TCS for Total Branch Automation. It uses ORACLE RDBMS, Pro* C, PL /SQL on SQL Forms 3.0, Forms 4.5. The package caters to front office as well as back office processing requirements of a bank. It is highly parameterized & user friendly. ISBS is logically designed as comprising a core package around which add on modules have been built. The core package is a framework providing basic functions like Transaction processing, accounting, exhaustive querying & reporting facilities. Add on modules could vary from Savings, Current, CCOD, Deposits, Loans, Forex accounts to external interfaces like Tele-banking, ATM and Multi Branch Banking.
Forex Trade Finance has the facility of opening of Letter of Credit (LC), utilization of letter of credit (LC), packing credit (PC), post shipment demand loan, R-Return, XOS statement and other reports, Exchange Earner Foreign Currency (EEFC), Foreign Currency Non Resident (FCNR) etc. FTF (Forex Trade Finance) module consists of following sub modules such as Import, Export, Forward Contract, Remittances, Deposit and Guarantees.
Responsibilities:

• Pilot site in-charge of the FTF module for Bank of Baroda.
• Implementation of various modules In FTF (Forex and Trade Finance) throughout all the branches of Bank of Baroda, Abu Dhabi Commercial bank, Allahabad Bank and Oriental Bank of Commerce in Mumbai and Pune.
• Development of new programs & customization of old programs as per clients requirements
• QMS & Documentation activity for the developments, changes and enhancements
• Conducting training for team members.
• Training to Bank DBA.
• Installation of Oracle RDBMS and other Oracle products.
• Writing PL/SQL, Procedures, Package Bodies and Triggers for enhancing the application.
• Developed Reports Using Pro*C, Forms 3.0/4.5, Unix Shell Scripts and PL/SQL. Designing DBA menus using shell scripts.
• Preparing Test Plans for the Unit testing for the changes in each release.
• Providing support for the Client Acceptance Testing.
• Participating in meetings with client.
• Developing schedule plan for support.
• Preparing training plan and documents for team members.
• Preparing user manual.

Environment: SCO UNIX, Oracle 7 DB.
Team Size : 14 to 16