PROFILE SUMMARY:

• More than a decade of experience in various SDLC phases of software development projects cycle.
• Knowledge of project management and standard quality assurance.
• Good Knowledge of Oracle Apps 11i Architecture, SOA, flexfields, AOL, API, Open Interfaces, Concurrent Manager, Multi-Org, Alerts, Workflow, working experience on customization and Implementation process.
• Good Knowledge of Oracle Data Warehousing and Oracle Business Intelligence Tools.
• Good knowledge of Oracle Agile PLM, Oracle HRMS & Payroll, Integration with OIC & Oracle Portal.
• Working experience of Oracle 11i E-Business Suite and development scenario (RICEF), AIM methodology.
• Experience in Oracle Developer Suit 10g, Oracle BI Discoverer 11, Data modeling, Data warehouse and Oracle Forms 10g, 9i & 6i Oracle Reports 10g, 9i & 6i, PL/SQL, SQL & toad.
• Knowledge of latest technologies towards development of eBusiness Solutions.
• Knowledge of web Technologies, successful track record of Web Development Projects.
• Experience in Jdeveloper, Jserv, java screens, Servlets, and ASP.
• Knowledge of Testing & debugging process, System Integration testing, Unit testing, White Box testing, Black Box Testing.
• Good understanding of all phases of Software Development Cycle (SDLC), from gathering Business requirements, Analysis, Design, build, Architecture and associated Project Management.
• Good Knowledge of Unix of varied platform Linux, Solaris, HP, AIX, shell scripting, AWK scripting.
• Knowledge of business process and BPR (Business Process Re-engineering).
• Knowledge of ERP Implementation Processes with linkages for web technologies and Supply Chain (SCM) & Customer relation (CRM).
• Knowledge of ERP Implementation Processes. (Migration From existing System to new One.)
• Domain Knowledge of Merchant Navy, Shipping Industry workflow, PMS system, Immersat A/B Mini M, Satellite based data flow system.
• Knowledge of Microsoft Exchange Active Directory, Amos connect Xantic, Marlink emailing system and application developments using above emailing S/W.
• Excellent communication and user interaction skills, capacity to work harmoniously in a group with sincerity and dedication towards work and organization.

Educational and Professional Qualifications

• Ecommerce PhD - From Singhania University, India.
• MBA-Systems 1st class with distinction Utkal University India.
• Bachelor of Science 1st class with distinction from Utkal University India.
• ITIL V3 Certified from EXIN Examination Institute of Information Science.
• Oracle Certified Oracle E-Business Suite R12 Financials Certified Expert Consultant(OCE)
• Oracle Certified Associate from Oracle corp. 1Z0-007 (OCA)
• Advance Diploma in software export technology. ASSET. New Delhi India.
• Diploma in information system management APTECH Ltd. India.
• Diploma in computer science APTECH Ltd. India.

IT EXPERIENCE

Oracle Apps11i Architecture, Implementation and customization using Application Object Libreary (AOL). in Oracle Developer Suit 10g, Oracle Discoverer, Oracle Workflow builder and Oracle Forms 10g, 9i & 6i,Oracle Reports 10g, 9i & 6i, PL/SQL and SQL. SQL*Loader, Data Loader, PL/SQL Procedures, Functions, Packages, Database Triggers and RDBMS concepts. Developing /Deploying Seagate Crystal Reports and BO (Business Objects). developer, Jserv, Servlets, and ASP. development of eBusiness Solutions like B2B, B2C.Knowledge of web Technologies, Web Development Projects.

Project Management

SDLC,SPMP,SQAP,KPI,

Quality

Exposure to HSE, ISO 9001, CMMI level 5-quality system standards implementation

Oracle developer Suit 10g ,Oracle Forms 10g,9i,6i, Oracle Reports 10g,9i,6i,Jdeveloper, for development of applications.

Linux, Sun Solaris, HP Unix, Sco Unix , Novell Netware , Windows 95 /98/NT/2000 Advance Servers Client Server Environment/XP/Vista

Pentium Core 2 Duo, Pentium processors, AMD (Adv Micro Devices), Athlon, Xenon, Centrino based wireless workstations and Servers, IBM, MVS, SUN,HP RAID hot swap Systems, Compaq, Dell based Workstations with Windows 2000, Windows XP,windows vista OS,Servers with Windows 2000 advance servers, Red Hat Enterprise Linux, Sun Solaris and Unix.

Used Oracle Designer 10g .for reverse and forward engineering of applications.

DBA - Database Administrator level knowledge of architecture of Oracle 11g, Oracle10G & Oracle 9i environment , Good Knowledge of Oracle as the backend database for ERP, Web and Ecomm applications.Good knowledge of SQL Server 2005 admin and development.

Others

PROJECTS

Jan '08 -Till Confidential, (Hallmark), IN
Technical Lead
Project: Oracle E-Business Suit 11i with Oracle Business Intelligence (BI) tools and applications
My current client has implemented Oracle E-Business Suit for companies Operations and MIS needs. The requirement further extends to create a data ware house Integrating Oracle BI Publisher for Enterprise Reporting and high demand delivery channels (FTP, FAX, WebDAV).
Role Description Customization, Integration, Development, Testing, Migration & Support
Responsibilities:

• Designing, Development, Scheduling & Integration of Sales Analysis Reports Using Oracle BI Publisher.
• Designing and Development of Ad hoc Query End User reporting Layer for Sales, discounting and Royalties module with relational & OLAP style analysis.
• Design Development and scheduling of Vendor Matrix Reports using BI publisher RTF template, XML data, XSL elements & SQL expressions.
• Defining and maintaining different data sources, Data model, security center, destinations, system configuration and integration with BI Publisher Services & BI Discoverer.
• Defining various Source System Components from Oracle ebusiness Suit like Various Database Links to collect data for the (EDW) Enterprise Data Warehouse.
• Designing & development of the Collect Programs to (ETL) Extract Transform & Load from OLTP system to the Oracle EDW(Enterprise Data Warehouse) Interface table.
• Map source to the Fact Table and flex field segments to the user defined/Seeded Dimensions using BIS configuration assistant for Data Load Process & Deploy data Configuration to APPS_MRC schema for synchronization and managing messaging and queuing - M & Q Data
• Assisted DBA in Tuning EDW using the Oracle Parallel Query Option (PQO) to significantly speed up the process of data collection, utilizing massively parallel processing (MPP) to execute SQL in a parallel way and start shadow (slave) processes, which speed up the execution of SQL queries and reduce the overall elapsed time for requests.
• Extensive extension work with User defined attributes, DTS, billing Invoicing, Procurement Shipping.
• Design and development of various Sales Statements, RFI & RFP ,IFB reports using Discoverer Plus, Admin & Discoverer Desktop.
• Developing & optimizing various data components for E-Business Intelligence Reports, creating Views On EWD fact tables.
• Assisted in administration of BI Processing Component to schedule alerts to send notifications to target owners and update data for presentation on the performance measure portlet.
• Designing and development of the Styleouts, pre configuration of backbone and integration with order Management.
• Design & Development of EDI, Oracle Gateway module for Trading Partners/Contractors.
• Design and development and integration of PLM-Line plan Application with Oracle Agile PLM using engineering data, BOM Costing, Product costing, and Creating RFQ etc.
• Design & Development of discrepancy Report using Oracle BI Publisher.
• Setup and Pl/SQL codes for the Modifiers and the Qualifiers for the Advance Pricing Module..
• Extensive UNIX shell scripting and extensive usage of crontab to automate EDI/Data Interchange for all the above-mentioned systems.
• Design and development of API, Subroutines to handle Interfaces from Oracle OM, Oracle Pricing systems.
• Design and development of various PL/SQL scripts to customize applications & facilitate data porting,
• Extensive work & Usage of Numra Track IT for Support Ticketing and Work Orders System.
• Involved in migration to Oracle Apps release 12.
• Deployed and Maintained the complete Subversion Edge Tools (Subversion Server ,Apache Web Server ,viewVC Repository ) from Collabnet , Created the Production Repository for the Customized Codes in APPL tier (Forms /Reports/Shell scripts/Sql/PLL) & the Customized codes in Database Schemas .
• Trained The users/Developers in Sunrise on Version Control & Usage of the Tortoise SVN (Client Tool for Connecting to Subversion Server )
• Automated Subversion SCC Plugin for TortoiseSVN to connect to Other Development Tools like TOAD ,JAVA, Visual Studio .NET.

Project Environment
Operating System Solaris, WINDOW 7,
Database & Tools Oracle 11g, Oracle BI Discoverer, Oracle BI Publisher 11g ,Oracle Developer Suit, Data Loader, SQL*Loader, TOAD, SQL tools, Cute FTP.

Oct '07 - Dec'07 Confidential, Mutual, NH
Technical Lead
Project: Oracle HRMS Integration to OIC & Oracle Portal Oracle Incentive & Compensation
Liberty Mutual has implemented Oracle HRMS and Oracle Payroll for companies HR Operations and needs. The requirement further extends to the customization and integration with the OIC (Oracle Incentive And Compensation) for Sales & Nonsales employees it also needs the employees to log into the Portal to view their online statements. Liberty Mutual needs to establish the method to pay the Incentive & compensation to the employees in both Sales and Non Sales team. I was involved in development and support of Oracle application, OIC & Portal.
Role Description Customization, Integration, Development, Testing & Support
Responsibilities:

• Using CWM (Common Warehouse Metadata) transfer wizard to generate ASCII export file .eex to generate the EUL (End User Layer).
• Assisted in transfer metadata from the OWB Repository to Oracle BI Discoverer and monitoring Logs for Collect & load Process.
• Designing and Development & Integration of Participation, Confirmation & Payout Statements using Oracle BI Discoverer Work Books.
• Designing and Development & Integration of Comp Committee reports, Sales person commission report, Executive reports & Online Portal reports.
• Administration and design of various OIC Sales Statements Using Oracle BI Discoverer Plus, Admin & Discoverer Desktop.
• Designing and development of the Resource Sync, Plan Migration, Target Upload and Payment Interfaces Process to Integrate HRMS with the OIC Module.
• Design & Development of Data model for the Oracle Portal Statements using SSO (Single Sign On).
• Design and development for the ETL for loading data into STAR data warehouse Schema, Dimensions & Fact table for the data model of Portal.
• Extensive UNIX shell scripting and extensive usage of crontab to automate ETL/Data loading for all the above-mentioned systems.
• Design and development of API, Subroutines to handle Interfaces from Oracle HRMS, Oracle Payroll Oracle Incentive and compensation and Oracle Portal systems.
• Design and development of various PL/SQL scripts to customize applications & facilitate data porting,
• Various SQL scripts were developed for analysis of data.

Project Environment
Operating System Solaris, WINDOW vista,
Database & Tools Oracle 10G,Discoverer Plus, Oracle Developer Suit, Data Loader, SQL*Loader, TOAD, SQL tools, Putty.

Mar '07 - Sep'07 Confidential, NJ
Technical Consultant
Project: Oracle Application Support
Confidential, has implemented Oracle HRMS and Oracle Payroll for companies HR Operations and needs. The requirement further extends to the customization and integration with the legacy online systems. SRM deals with various third party vendors for outsourcing the activities. I was involved in development and support of Oracle application. I was also involved in undertaking new enhancements and registering them to Oracle Apps Standard.
Role Description Support, integration, Customization, Development, Testing
Responsibilities:

• Designing and Development of Reports for Oracle Payroll, and Oracle HRMS module.
• Customization and registration process of Oracle reports in all the above-mentioned modules of Oracle Apps 11i.
• Data porting for all the above-mentioned systems.
• Design and development of API, Subroutines to handle Open Interfaces Oracle HRMS and Oracle Payroll systems.
• Design and development of various PL/SQL scripts to customize applications, facilitate data porting,
• Extensive Unix shell scripting and various SQL scripts were developed for analysis of data.
• Y role involves customization, development, testing and implementation activity.

Project Environment
Operating System Linux, WINDOW vista,
Database & Tools Oracle 10G,Data Loader, SQL*Loader, TOAD, SQL tool .

Sep '06-Feb '07 Confidential, Malaysia
Technical Consultant
Project : Oracle 11i E-Business Suite Installation (iHRMS) and customization and Implementation for Malaysian Airlines
Integrated Human Resource Management System (iHRMS) is a customized Oracle Applications 11i (HRMS) Implementation for Malaysian Airlines to cater to the massive (over 30K employee) HR needs and requirements
Role Description Customization, development, testing, DBA and implementation.
Responsibilities:

• Work on the technical aspects of Oracle HRMS, Oracle Payroll, irecruitment, SSHR, OTA, OTL, Time and Labor, Fast Formulas in Oracle HRMS 11i sing both Linux and windows platforms.
• Customization/registration of Oracle reports in all the above-mentioned modules of Oracle Apps 11i.
• Data migration for all the above-mentioned systems
• To developed scripts to handle API, Open Interfaces in Oracle apps 11i / Oracle 10G
• Design and developed several PL/SQL scripts to customize applications, facilitate data migration, and Data Extraction from MAS Legacy systems.
• Technical Compliance to the requirements for Project. Ensure timely Deliveries and Adherence to the quality Plan drafted for the project. Production Support.
• Customization, development, testing, DBA activity and implementation

Project Environment
Operating System Sun Solaris, WINDOW XP,
Database Oracle 10G, Sql Server, Data Loader, SQL Loader

Mar '06-sep '06 Confidential, Malaysia
Technical Consultant
Project : Oracle 11i E-Business Suite Installation (iHRMS) interfaces and Documentation as per SOW
Integrated Human Resource Management System (iHRMS) is a customized Oracle Applications 11i (HRMS) Implementation for Malaysian Airlines to cater to the massive (over 30K employee) HR needs and requirements.

Client Confidential
Role Description Documentation, Customization, development, testing, DBA and implementation.
Responsibilities:

• Analysis and understanding of the specs for the existing interfaces to MVS Legacy System.
• Design and developed Interfaces to the iHRMS from MVS Legacy Systems like CMS (Crew Management Systems), IFS (Integrated Financial Systems), SAS and COGNOS systems,
• Develop the Interface Document, which is to be signed off by users and updated in the project Library.
• Setting up FTP jobs to facilitate the automation of auto scheduling the file transfer between the Mainframe systems to Oracle iHRMS system.
• Extensive Unix shell scripting to automate the batch processing jobs.
• Development of FTP Configuration Document, System Integration testing Document, Data extraction and migration document to facilitate the support /Customer care centre for the support scenario of iHRMS system.

Project Environment
Operating System Sun Solaris, WINDOW XP.
Database Oracle 10G, Sql Server, Data Loader, SQL Loader,

Jul '05-Feb '06 Confidential
Technical Consultant
Project : Oracle 11i E-Business Suite Installation and customization and Implementation for SIIX Singapore(Group Companies).

Client - Confidential
Role Description Customization, development, testing, DBA and implementation
Responsibilities:

• Analysis, Design and Development work on the technical aspects of Oracle Financials(AP), Oracle Purchasing & integration with ARIBA procurement module , Work In Progress (WIP), Order Management (OM), BOM (Bill Of Material), Routing, Inventory and other areas of Oracle Manufacturing 11i both on Linux and windows platforms.
• Customization and registration of Oracle reports in all the above-mentioned modules of Oracle Apps 11i.
• Data migration for all the above-mentioned systems.
• Design and development of API, Subroutines to handle Open Interfaces in Oracle Financials, Oracle Purchasing, Work In Progress (WIP), Order Management (OM), BOM (Bill Of Material), Routing, Inventory and other areas of Oracle Manufacturing.
• Extensive Unix shell scripting for automation of jobs , Usage of crontab.
• Design and development of various PL/SQL scripts to customize applications, facilitate data migration, and generate SQL based reports.
• Customization, development, testing, DBA activity and implementation

Project Environment
Operating System UNIX, Linux, WINDOW XP, Red Hat Enterprise Linux, WINDOW XP,
Database Oracle 10G, Sql Server, Data Loader, SQL Loader,

Jul '05-Feb '06 Confidential
Technical Consultant
Project : Oracle 11i E-Business Suite Installation Data Migration,Multi Org Setups, Implementing Patches and customization for HAKUTO Singapore(Group Companies)
Client : Confidential
Role Description Customization, development, testing, DBA and implementation.
Responsibilities:

• Multi Org setup for Hakuto. Execute Adadmin Utility and Adpatch Utility on Linux servers to Implement the patches in Oracle Apps 11i.
• Analysis, Implementation and testing for the pre and post patches setups at the customer site.
• Planning and Executing Data Migration from Hakuto legacy systems.
• Design and Development of Oracle scripts, API, EDI, Procedure, Librearies, Functions to handle Open Interfaces in Oracle apps 11i / Oracle 10G
• Design and development of PL/SQL scripts to customize applications, and facilitate data migration.
• Customization, development, testing, DBA activity and implementation.

Project Environment
Operating System Red Hat Enterprise Linux, WINDOW XP,
Database Oracle 10G, Sql Server, Data Loader ,SQL Loader,

Apr '02-Apr '05 Confidential
System Analyst/PM

Project: Implementation, Customization, Maintenance and support of users in multinational locations across globe like Houston Sugar Land Texas USA, Japan, Singapore, Mumbai, Delhi, Jamnagar, Pune, Chennai,

Client:Confidential
Role Description Project Management, DBA,
Responsibilities:

• Analysis Design and Development of ERM/E-Commerce systems single handedly, which can integrate (13+) offices.
• Using Oracle Development of Automated System which collects data from several (80+) vessels using immersat, emails and auto inserts into the head office database, which is then used to generate valuable analytical report at Head Offices.
• Development of an online and integrated system with three-tier structure to be able to be view on Internet Explorer anywhere anytime.
• Design And development of Data warehouse for OLAP & Reporting .
• Single handedly development and deployment of several multifunctional and user-friendly reports using Seagate crystal reports and BO(Business Objects) integrated with Oracle deployed online on multi organization three tier setups.
• Development of in - house ERP interface systems and EDI with Oracle Apps 11i and third party systems. These systems have been developed using Industry standard Software Development Life Cycle (SDLC) like Analysis, Design, build, development, Documentation testing and Implementation process.
• I was responsible for the maintenance and support of these applications In ESM
• I have been involved in designing, architectures, planning, deployment, operations and maintenance of existing systems and various new technologies emerging in the versatile IT world. Some of my work is listed as follows-
• Wireless Network planning and deployment.
• Global Emailing System (MS Exchange) Server /Storage / Backup planning and deployment.
• Database Servers and Storage planning and deployment.
• Backups and emergency risk planning and deployment.
• ADSL, VHF, UHF technologies, Immersat and Mini-M setups on the vessels planning.
• Firewall / Switches setups and VPN inter offices planning and deployment.
• Replication between servers for DMS planning and deployment.

Project Environment
Operating System UNIX, WINDOWS 2K,WINDOW XP,
Database Oracle 9i, Sql Server, Sybase Central
Web Server Apache, Tomcat, IIS
Tools Oracle Apps 11i, Java Virtual Machine, Java Scripts, java screens Pro*C, Visual Basic, MS Project, visio, MS Office

Confidential, Sept 2000 to March 2001
Feb '02-Apr '02 Mascot Systems (IGATES).
System Analyst/PM
Project Sap-Les interface (FUSION)
Client : Confidential
Project Description
Sap-Les interface (FUSION) is a new interface system under design for interfacing the logistics system of HP in SAP with the order processing system (beacon), which is in Oracle. This system serves as the replacement for the FIRST (a legacy logistic system) interface.
Role Description Project Management, Analysis, design, development, testing, and implementation of Sap-Les TM System.
Responsibilities:

• Analysis, impact analysis and completion of the Analysis Document. I also designed the SAP-LES interface system,
• Design and development in Oracle and Extensive Unix shell scripting, for the batch jobs and processing of this system.

Project Environment
Operating System UNIX, WINDOW NT
Tools Oracle, D2k,PRO*C

May '01-Feb '02 Confidential
Technical Lead
Project Customization Oracle Apps
Client : Confidential
Role Description

• Analysis, design, development, UAT (User Acceptance), MTP (Move to Production), implementation and user support.
• Customization of reports in oracle apps for the purpose of analysis (e.g. sales by salesperson / customer / brand). These were customized to apps standards and registered in oracle apps for different organizations
• Audit trail reports to track the updates in request date, and schedule date in Sales order was made and customized to apps standards and registered in oracle apps.
• Purchase order-updating program for the new rates entered by the users every month was made and customized to apps standards and registered in oracle apps.

Project Environment
Operating System UNIX, WINDOW NT
Tools Oracle, D2k

Mar '01-May '01 Confidential
Oracle Apps Support Consultant
Project Customization of Oracle Apps Programs(Oracle Inventory)
Client : Confidential
Project Description
This project deals with customization of forms and reports in Oracle apps for the purpose customizing the assigned Inventory/sub Inventory module as per the business flow of TEC, The new module was made and customized to apps standards and registered in oracle apps.
Role Description

• Analysis, design, development, testing, UAT, MTP, implementation and user support.
• Responsible to solve the issues raised by the users on a day-to-day basis in the Oracle Inventory module.
• Solved complicated issues in sub inventory transfers. Received testimonial from the customer in appreciation for solving some long term pending issues very quickly.
• Optimization of Oracle programme in the Inventory module for better performance.
• Extensive Unix shell scripting for automation .
• Reduce execution time of complex oracle programme using plan table and hints.

Project Environment
Operating System UNIX, WINDOW NT
Tools Oracle, D2k
Sep '00-Mar '01 Confidential
Project Manager, DBA
Project EOL (Harmony)
Client : Confidential
Role Description
Responsibility:

• Software Project Management, Project Schedules and milestones, Analysis, design, development, and implementation of EOL.
• Project Analysis and interaction with customer over the scope of requirements. Managed a team size of 25 of which 3-team leads report to me.
• I was responsible for the Application database administration.
• I also did the Impact analysis and my approach gave this project a complete new direction so that it was possible to complete this project in time and cost.
• I have used FP (Factory Planned) a third party tool from I2 systems integrated it with Oracle to generate the desired results.
• I was responsible for the low level designing of the system and developing the pre FP and Post FP scripts both in Oracle and Unix.
• I have achieved testimonials for appreciation from the customer for completing this project within deadlines and budget.

Project Environment
Operating System UNIX, WINDOW NT
Tools Oracle, D2k,Pro*C