SUMMARY:

• Currently working as Development manager/ lead Oracle eBS techno functional consultant w/ Confidential Solutions US corp
• 9.5 years of global experience working on implementation/ support projects w/ clients across Canada, India and US. During my experience have wore multiple hats of a developer, Team lead, Delivery lead, Project Coordinator (Oracle Apps/SAP), BA & solution architect implementing/ supporting business applications
• Packaged application development: Strong oracle development background & understanding of Oracle application's architecture and data structures with experience of working on solutions built on SOA and cloud based integrations
• Well experienced in various Oracle EBS modules
• Oracle CRM: Install Base, Service Contracts, Field Services, Teleservices, UWQ, Telesales, Trading Community Architecture (TCA), Order Management (OM), Oracle Quoting
• Manufacturing: Inventory, BOM, Configurator
• HRMS: Leave management, PMS, Employee creation, Payroll, i - Recruitment, Self services
• Financials: Receivables. Overall oracle flow understanding for purchasing, procurement to pay, receivables, payables, projects
• Experience in analyzing and gathering requirements via feedback sessions and client meetings in collaboration with all stakeholders, authoring BRDs/ functional/ technical designs, developing effective business solutions, user documentation, defining and executing test plans, user
• Project scoping & planning, process transformation, effort estimations, resource utilization, offshore coordination
• Regular interaction with leadership/ executives/ senior management for reporting and ensuring delivery of project in line with Customer expectations
• Excellent analytical and interpersonal skills with experience of working in cross-cultural teams
• Have domain knowledge on trading systems/ platforms for G-Secs/ bonds/ T-Bills/ Interest rate Swaps/ CBLO/ Forex & worked on building and maintaining trading platforms, clearing and settlement systems for fixed income- capital market client
• Have worked with 2nd largest bank in Canada to manage testing for their mortgages and lending applications
• Have domain s in capital markets, banking, resources- utilities and communication- hi tech industry
• Gained testing experience in SAP OTC and PD modules

TECHNICAL SKILLS:

Software Products/ technologies: Oracle Applications(HRMS, Oracle Contracts, Installed Base, Field service, logistics, quoting, AR, OM, Inventory, BOM), Java script, Core Java, Crystal reports, Business Object, HTML CSS, Oracle Application 11.5.10, Oracle Application 11.0.3, Oracle applications R12, Pl / Sql, VB 6.0, C, C++, Pro*C, XML Publisher, Oracle 9i, Oracle 10g. Unix, SOAP, SOA Toad, Secure CRT,MS-VSS, Raptor, Discoverer reports, XML Publisher, Pl/sql developer, team foundation server, MS visio, HP Quality centre, Oracle warehouse builder, Rational Clear Quest, IBM Maximo, Harvest, Peregrine, Plan IT, PPM, PVCS, RTC, RRC

PROFESSIONAL EXPERIENCE:

Confidential

Oracle dev manager

Responsibilities:

• Managing agile releases in Oracle eBS, CRM, TeleSales, Financials and custom solutions for HealthCare domain. Work on enhancement and prod support- Development in PL/ SQL, unix, forms, performance tuning, work on Oracle SRs and patch follow ups
• Accenture technology Solutions- Techno functional consultant, Oracle Dev lead

Confidential -Boston, MA

Responsibilities:

• Working as tech lead and senior oracle techno functional consultant in Oracle Apps eBS. Modules include Oracle CRM, Service Contracts, Installed Base, Field service, logistics, quoting, Receivables, OM, Inventory, support centre

Baltimore

Responsibilities:

• Oracle data conversions lead for data conversion efforts from legacy systems to Oracle to migrate onto IBM Maximo

Confidential

Business Analyst

Responsibilities:

• Project lead for packaged applications development for oracle HRMS implementation/ production support project

Confidential

Responsibilities:

• Test lead/ Business Analyst for Mortgages and Lending systems of CIBC (2nd largest Canadian bank)

Confidential

Responsibilities:

• Domain knowledge on trading systems/ platforms for G-Secs/ bonds/ T-Bills/ Interest rate Swaps/ CBLO & worked on building and maintaining trading platforms, clearing and settlement systems for fixed income- capital markets

Confidential

Responsibilities:

• Perform development and support using agile methodology for client's custom application which is tightly coupled with Oracle eBusiness Suite
• Development and enhancement in Oracle CRM modules like Telesales, e - Business center, UWQ and Financials AR, iPayment. Oracle Advance collections fit gap analysis.
• Work with Inside sales and business teams to identify pain areas and provide solutions to better enable business and campaigns run by sales team. Example: dialer campaigns for clients due for refill, clients going outside of Aetna for refill or change of plan sponsor
• Enhancement of the application functionalities to support business needs of client including development/ enhancement of PL/SQL code, reports, interfaces, AOLs, Oracle forms, application configuration and set ups.
• Performance and scalability issues- Work on existing perf issues in CRM and financials. Work with dba for tracing db/ forms and programs. Fine tune the jobs.
• R12 upgrade issues- Work to resolve issues caused post R12 upgrade
• Work with Oracle to on SRs and regularly follow up to support and logical conclusion of SRs
• Perform application code releases to integration test environment, user test environment and production environment.

Confidential

Responsibilities:

• With extensive technical and functional experience in Oracle eBS, assist Process teams and System Integration teams in development of BRDs, FDs and TDs in customer services space. Enhancements and redesigning major interfaces/ new objects in OM, quoting, IB, Logistics, Field services, Service contracts, Teleservices, UWQ, Telesales and Receivables.
• Work with Multi vendor teams. Manage 15 people team from Oracle dev, testers, vendors and client teams.
• Due to SAP implementation Oracle CRM CSI modules were heavily impacted and all the interfaces with oracle were re-designed including item master, customer master, ship install, contracts creation, billing, field services and logistics interfaces
• Owned delivery of several complex interfaces and functionalities within client application which requires deep business expertise. Owned delivery for 35 key objects for interfaces/ extensions/ forms/ reports/ config etc, more than 250 sub objects in Oracle.
• End to end QTC experience starting from quoting, orders creation, deliveries and shipment, Installed base config and service contracts creation and contracts billing, renewal etc. And key functionalities in customer service viz SR creation, debrief, T&M charges submission, defective returns, RMA returns etc.
• Solution was built on SOA based architecture and common cloud based integration. Participated in architecture discussions with other vendor integration teams and client teams for seamless Integration of orders, deliveries, invoices, shipments, contracts etc payloads between Oracle and SAP (both inbound/ outbound)
• Co-ordinate cross functional issues for Oracle- projects team for key interfaces on order to projects, order to agreements etc
• Quarter end/ year end support for billing. Responsible for resolution of revenue impacting P1 defects in end to end QTC. (eg: Resolved several contracts creation and billing issues in Production worth $ 200M, and such many other program level issues.)
• Requirements gathering, analysing and fit gap documents, conducting CRP sessions, road shows, user interviews, author use cases, configuration docs
• Responsibilities include defining systems strategy, designing, prototyping, testing custom technology solutions and supporting system implementation
• Solution architect- Work with project PMOs, Client director, Business and Support teams for Project stabilization. Guide Dev/ test teams on delivery of topmost solution concern Work Requests for go-live, stabilization, post go-live agile and quarterly releases.
• Coordinate cutover activities/ steps for project Go-live/ post go-live. Participate in Business readiness prep
• Smoke test co-ordinator for project cycle testing- coordinated with offshore and onshore dev/ test team and integrations team for migration and testing of end to end interfaces
• Defect management: Managed complex P1 defects for Services coordinating with onshore/ offshore project developers, testers, Business and cross functional teams
• Coordination w/ DBA leads, client architects & BI architects to get approvals on key designs and top interfaces for services. Work with architects/ leads from SAP, oracle, integration and BI teams, program solution architects, PMO to resolve key program issues
• Work with Business users, dev teams, integration teams and process teams to align Oracle programs in line with SAP enhancements
• Organize/ Deliver cross functional KT with developers, testers, business transformation groups
• Define coverage plans for onshore/ offshore during business simulation, go-live release, and all post go-live agile releases, weekly, bi-weekly, quarterly releases, migrations plans, plan for Cutover and brown out support, EOQ war room support etc
• Status reporting to Sr. Business director, Sr. IT director, client managers and ACN executives

Confidential

Responsibilities:

• Worked as a SME and dev lead for Enterprise installed base projects which were multi million IB enhancement/ clean up projects at Confidential
• Configurations in Oracle, Solution architecting the objects and cross organizational coordination
• Review and approve requirement documents/ functional designs/ technical designs
• Manage development efforts onshore and offshore, Review RICE components
• Provide estimates, Create and review Dev/ test plans with PMOs and senior management, provide Status updates to executives
• Coordinate design discussions with non oracle teams, integration and Oracle dev
• Production support: Handle enhancement & break fixes for IB, Field service, Service Contracts, Logistics, Tele service, Inventory, OM, BOM
• Implement interfaces between licensing system to Oracle to sync up activation and rehosting of e-licensed software products. Create/ Update SW models in IB for ELA/ VSLA, instance and capacity based models. Maintain machine info and registration info in IB
• Clean up HW models in IB for quantity issues, create model- part relationships, create/ update service contracts
• Process improvements for ticket reduction and continuous improvement
• Author functional designs/ technical designs
• Writing Complex Pl/sql reports in Oracle Apps, Performance Tuning, configuration, forms/ reports
• 24X7 support for prod support environments, Adhere to Respond/ resolve SLAs for tickets
• Coordinate quarterly business review reporting, monthly & weekly status reporting with client

Confidential

Responsibilities:

• Lead a Conversion team of 5 people, Functional analysis of Maximo which is Asset management tool developed by IBM.
• Extraction of 5 different Legacy systems data into Oracle, Transformation and Conversion of data using reusable Pl/sql code.
• Building Technical Design documents from Conversion Functional design documents
• Extraction Programs to get data from various Legacy systems in Oracle, MS Access, Mainframes CSV text files. Transform and Load Programs to load data into IBM Maximo.
• Developing reusable PL/SQL packages and Performance optimization of SQL queries and packages.
• Actively participated in Mock, Dress Rehearsal and Cutover activities
• Host and manage client visit, Talent Management & People development

Confidential

Responsibilities:

• Conduct requirement gathering sessions with client, Analyze of GAP between AS IS and TO BE document.
• Create BR100, MD50 and MD70 documents
• Designing Interfaces for Payroll and Tax plan. Development of RICE objects
• Form personalization/ customizations. Build Reports in XML Publisher, Discoverer
• Single point of contact for SIT and UAT
• Lead team of 4 developers for Post Production support for HRMS Implementation
• Functional testing of Leave management, PMS, Employee creation, Payroll, i-
• Recruitment etc modules of HRMS
• Involved in Account management activities like creating contract, PO, Resource management, Timesheet Approvals, Client billing, Client communication, Project budgeting etc

Confidential

Responsibilities:

• Functional Analysis of CIBC’s Mortgage and Lending systems, Testing CIBC’s mainframe based system
• Coordinating Testing activities between onsite offshore team from clients’ site in Toronto
• Planned, monitored, reported testing activities
• Drive team meetings/Variance meetings/ Client meetings, Worked as VSS Admin
• Functional Analysis of CIBC's Mortgage and Lending systems and testing various applications for mortgage creation and servicing
• Prepared and revised, wherever applicable, project plan, budget/effort and schedule
• Reviewed test strategy, test plan and test results
• Interacted with development manager to exchange status and resolve all issues

Confidential

Responsibilities:

• Multi Modal Settlement of funds in Securities segment
• Unscheduled Holiday Handling
• T-Bill Auction Settlement System
• Clearing and settlement of Rupee Derivatives i.e. Interest rate swaps (IRS) and Forward rate Agreements (FRA)

Confidential

Responsibilities:

• Defining deals and trades structure, Authoring rules for matching, Programmatically compute payment and reset dates and several other attributes in clearing and settlement, Compute revised considerations on outright and repo trades, Compute Accrued interest, repo interest for Outright and repo trades respectively, Compute settlement amounts and handle shortages and securities/ funds, replenishment of securities etc
• Analysis, Design, Implementation, Production/ST/UAT support. Interaction with integration team for technical validations and with Biz and client for transforming functionality into solution design
• Writing FD/ TD for dynamic reports to display deals and trades
• Worked on systematically defining novation/ netting rules for Trades clearance and risk processes to block member margin etc
• Sending and receiving securities and funds files from/ to 3rd party entities like to RBI, IDRBT. Interact with RBI teams for settlement rules, Funds settlement
• Prepare Function point analysis for estimation and Impact analysis for the project
• Writing Technical/Functional design document and Best practices document for TCS portal
• Leading team of 10 developers for all the phases in SDLC, mentoring
• Allocating work to front end, backend and host end teams and carry out functional test with Business analyst/UAT with client
• Involved in Business Continuity Planning, Bod to Eod operations in Clearing and settlement systems and 24X7 support for prod support environments
• Development of VB code, PL/Sql stored procs, Crystal reports. Development of Handlers in C++, Pro*C to do DML operations, Unix shell scripting
• Defect management/ status reporting for the project