Technical Architect & Team Lead for Implementation Team at State treasury Office

Responsibilities:

• Work with STO IT department with the capacity of a technical team lead to support, manage and triage the day to day ongoing operations and maintainance activity related to technology and best practices for DMS applications (Oracle FMW and Oracle databases).
• Collaborate with STO cross functional team (ITD, PFD, and EMT) & DMSII Implementation team and Conduct System analysis and provide technical leadership to the team at State Treasurer's Office for Support, implementation and modernization of Debt Management System (From 11g to 12c) for the California State Treasurer’s Office.
• Technical leadership in performing Database and FMW fixes or configuration in the DMS production/DMSP), DMS test/DMST, DMS staging/DMSS and DMS pre-prod/DMSG environments which involved Analysis, design, development, testing and implementation to meet business needs.
• Contribute in reviewing the current architecture of applications, propose changes, data modelling and create new data models to the Debt Management System and interfaces as a part of new architecture.
• Responsible for DBA, design, development (Oracle Forms/Oracle Reports/Oracle Pl/SQL), testing, implementation and support of various new enhancements & defect fixes as required by the Business Programs.
• As a Technical Lead Responsible for ongoing support and maintenance work of the DMSII applications (Oracle FMW and Oracle databases) like day to day monitoring of Oracle FMW and Oracle database servers, creating and monitoring backend Jobs, configuring and tuning instances (Oracle FMW and Oracle databases), configuring and executing DMS Batch Job,restarting/bouncing of Oracle FMW and Oracle databases, database & materialized views refresh, backup schedules, Server space management, setting databases on fixed dates, rolling dates in databases, Patch plan & execution, upgrade, preparing systems for releases, working on release management and supporting SDLCS process by Database refreshes.
• Prepare and conduct KT agreement, Work Product Expected document (WPED), KT Logs, and lesson learned documents on the Work Products Implemented for State Treasurer's Office systems.
• Worked on DMS defect remediation for the defects lodged in TrackIT & HP ALM (Defect Tracking System).
• Design, developed and conduct the Deployment Plan and Disaster Recovery Plan for State Treasurer's Office systems.
• Work and report to PMO on Product Readiness and Stabilization of Solutions implemented for State Treasurer's Office.
• Work closely with business analysts and assist in developing business concepts and Middle Tier Analysis.
• Provide Post Production Stabilization and support on data conversion for Systems implemented for State Treasurer's Office.
• Provide overall coordination of DMS S/W release management & Provide leadership and guidance to PMO and ITD in release management activities, prepare Release checklist and conduct release of application, Conduct dry run and deployments of releases componants to Production environment.
• Worked with PMO, IV&V, and Floyd Layher for Project managemrnt, Project approvals and Oversight for the DMSII Project.
• Coordinate and manage proper communication between the Technical team, Business and Test Leads, for conducting different releases in the DEV and TEST and Stage environments.
• Verify processes in the RLMP-Release Management Plan and comply with the process being followed, Identify “fall back” plan to reverse release package from PROD environment in case of a rollback situation.
• Ensure proper transition thru the Knowledge Transfer aggrement KT for ITD (IT Department) release deployment activities to STAGE (UAT), PROD and Disaster Recovery DR.
• Work hand in hand with STO IT department for the Implementation and upgrade of Analysis tools like PITSS.CON to facilitate future developments process in STO.
• Worked closely with the STO Release manager,STO test lead ,STO business lead and prepared release checklist for release of the application (Oracle Forms, Oracle Reports) and database componants (Oracle PL/SQL Packages,Procedures,Functions,synonyms,triggers,sequences) to DEV,TEST,STAGE and PROD environments for 5 different releases on DMS application successfully executed at STO premises.
• Coordinate with the STO Release Manager to align task activity for STO-managed CI categories, Gather and monitor release management metrics and Recommend process improvement, as needed.
• Worked on very tight timelines using AGILE development (SCUM) process to meet the challenging timelines for the TPW items.
• Reviewed the functional & technical design documents like FDD,TDD,MD50, MD70, Unit testing, Integration testing, estimates for the development and customizations as per FWRICE, & AIM methodologies and Oracle 12c Process.
• Analysis, design and development of database tracking analysis activity for specified business application areas, provided ability for “as of” flashback and audit trail functionality.
• Plan and migrated HP ALM (Defect Tracking System) to Production Instance for State Treasurer's Office.
• Involved in Implementation and configuration of multiple instances of Oracle databases & Oracle Fusion Middleware for Debt Management System (DMS) Implementation and modernization for State Treasurer's Office.
• Involved in Installation, Configuration of Jdeveloper, Oracle SOA suite 12C and Oracle BPM Suite 12C for State Treasurer's Office.
• Track and control project performance, manage communication on the project through meetings as needed to resolve ongoing Support SR , project issues and timely reporting project status on a weekly basis to PMO ,STO management and the project team, assisted in preparing the weekly status report to for the client managers.
• Provide knowledge transition and educate STO staff and DMSII application users on the new enhancement done to the existing Oracle 12c DMS application.

Team Lead/PM for 25 members in 3 different time zones

Responsibilities:

• The aim of the project was to customize, manage and support Ge applications (Implemented using Oracle EBS Financials, Oracle SCM, Oracle Project accounting, Oracle HRMS and Payroll systems).
• Work closely with GE IT department with the capacity of a technical team lead to support and manage the day to day operations and maintainance activity related to GE applications developed (Oracle FMW 12c and Oracle 12c databases, SOA, Oracle Fusion Applications,Oracle Forms & Reports).
• Assist in design of complex, global or strategic development projects. Identify and address interfacing functions and applications and supporting PeopleSoft/Hyperion financial systems using SMAL, OWSM end user task.
• Worked for defined the Classification Categories and Classification Codes to configure the Auto Accounting.
• Provide technical leadership in performing Database and FMW fixes or configuration in the production testing, UAT environments, which involved Analysis, design, development, test and implementation to meet business needs.
• Perform EBS application systems development tasks which include working with users to define system needs, analyzing and designing applications to meet user needs, design and review Technical/Functional documents and provide sign off, preparing flowcharts and diagrams to illustrate logical sequence, translating logic diagrams into program statements using OAF Components, design logical database modeler and implement using JDeveloper, automate deployment & build process.
• Extensive customization using Oracle Forms Oracle Pl/Sql code, Support and maintenance work in Oracle Project Costing, indirect projects, Labor and non-Labor costing raised Service Requests with Oracle to resolve the bugs and other product related issues.
• Extensive Experience in Support, Implementation & Transitioning of Global Systems across US, LATAM, ASIA, EUROPE and Other Global Country Rollouts.
• Extensive development of the Inbound and outbound Interfaces in Oracle & automation of DBMS_Scheduler Jobs sending Extracts of Biller, GL balances and Journals to Other Financial Intelligence Systems.
• Design, development, and Support of Enterprise Standard Oracle Fusion Applications on Oracle Cloud (SaaS & PaaS).
• Worked in OTL time entry, timecard API, Order Import, Holds, Pick Release, Pick Confirm, WMS interfacing & Ship Confirm Process using FNDLOAD utility as per GE & Oracle Apps R12 Process.
• Worked on Supporting the Interfaces from GE CCL GL to Hyperion & MSCA interfaces and build interface for the automation of the to and fro interfacing of information.
• Inbound /outbound design and development for SOA interfaces from GE in house AP systems to Oracle Apps R12 system.
• Design and Development and Support of Common Application Utility objects to be used for implementation common message Queuing & common utility package for Error handling, Issue Logging and reprocessing of the concurrent.
• Flexible in working on very tight timelines using AGILE sprint development (SCUM) process to meet the challenging timelines of the project.
• Prepared the IT system documentation, functional & technical design documents like MD50, MD70, Unit testing, Integration testing, estimates for the development and customizations as per FWRICE & AIM methodologies, SOX compliance and Oracle Apps R12 Process.

Team Lead/ Project Manager for 3 members from client and 12 contractors

Responsibilities:

• Design and development of EDI & 3PL Outbound &Inbound messages using XML Gateway in R12 in O2C & P2P track,Oracle ASCP,Oracle Demantra,MSCA interfaces,the implementation involves, Design and development of the Order information, Inter org transfer of spares, Inventorychanges, Purchase Order 850, ASN856, Invoice 810.
• Development of the Workflow business events and subscription of the events for the specific action to be automated to send the XML messages to the 3PL.
• Extensive development of the Inbound and outbound events in Oracle Workflow & automation and management of Oracle database events in message Oriented middleware, Oracle Advance Queuing (AQ).
• Extensive Oracle EBS, B2B design and development using XML gateway message Designer to create Data Source DTD designs, Create Data Target, Define Document levels, Perform Hierarchy mapping, Perform Element Mapping and create XML Maps (XGM) for inbound and outbound XML messages.
• Design and development of XML gateway services and message Setup, this task include defining the Trading partner /Hub, Define Code Conversion values, definetransactions, identify DTD directory,ensurewell-formed and valid message transfer, identify proper execution of the XML gateway services -execution engine.
• Order Import, inter org transfer by field service technical Portal, Pick Release, Pick Confirm, WMS interfacing & Ship Confirm Processusing UTL_FILE package as per Teradata & Oracle Apps R12 Process.
• Worked on Interfaces from Teradata to map the 3PL (3rd party Logistics) interfaces and build interface for the automation of the to and fro interfacing of information.
• Inbound /outbound design and development for SOA interfaces from Teradata in house systems toOracle Apps R12 system.
• Design and Development of Common Application Utility objects to be used for implementation common message Queuing & common utility package for Error Handling, Issue Logging and reprocessing of the concurrent.
• Worked on very tight timelines using AGILE development (SCUM) process to meet the challenging timelines
• Prepared the functional & design documents like MD50, MD70, Unit testing, Integrationtesting, estimates for the development and customizations as per FWRICE,& AIM methodologies and Oracle Apps R12 Process.

Team Lead for 10 onshore team members

Responsibilities:

• Design and development of Order-to-Cash track Components Order Import, Substitution, proration & Allocation, Palletization, Pick Release, Pick Confirm, WMS interfacing & Ship Confirm Process as per C&S process & Oracle Apps R12(Oracle database & Oracle weblogic) Process.
• Design and development for R12 EBS Financials (Oracle 12c database,Oracle FMW) , AP, AR, General Ledger, customizations, Personalization’s and setting up transaction types in AME rules Required for C& S Business process.
• Design and development of the UpCharge Correction and rebilling Process as per C& S business process. It has many complex process like Price Correction, Weight Corrections and Fixed Price Corrections after the Order has been Invoiced MappingC&S process & Oracle Apps R12 Process.
• Worked on Order Scheduling Process, WMS, OTM interfacing, custom pick slips, Standard credit rates, SOA and EDI customer mapping for C&S business requirements.
• Worked on Interfaces to Teradata and Ad Hub Database for Oracle MDM- PIM Information and data extracts for OBIEE reporting.
• Inbound /outbound design and development for SOA interfaces from Mainframe Systems to Oracle Apps R12 system.
• Design and Development of Common Application Utility objects to be used for implementation of the common framework for Error Handling, Issue Logging and reprocessing of the concurrent Programs in P2P and O2C tracks.
• Worked for development of the functions and packages required for the ADF screens required for the Order Edits, Rush Orders and RMA entry screens for C& S Business.
• Worked on OEM for executing BPEL Process Step by step testing and worked on Oracle BPM for Workflow in approval process and exception handling.
• Worked on very tight timelines using AGILE development (SCUM) process to meet the challenging timelines and used the Special Feature On/Off Code feature of a particular customization to facilitate Dual development /Implementation scenario.
• Prepared the functional & design documents like MD50, MD70, Unit testing, Integrationtesting, estimates for the development and customizations as per FWRICE,& AIM methodologies and Oracle Apps R12 Process.
• Provided support using auto task for support ticketing system, performed user training, project review meeting, created process/program Logic flow documentation which cater to technical &non-technicalaudience, Code review, solved user queries, and maintained clear explanations of problems and resolution logs.