SUMMARY:

• Over 13.5 years of experience with 12 years in IT specializing as Project Lead for application development, ETL Integrations, Data warehousing, Business Analyst in Supply Chain domain, and Programmer.
• Over 7 years of working experience in Client location (USA) leading various engagements in an Onshore - Offshore delivery model
• Over 4 years of working experience in Oracle Apps SCM with hands on experience in Order Management and Inventory.
• Over 7 years of working experience in leading ETL Integration scope.
• Over 8 years of working experience in Mainframe application development and maintenance (COBOL, IDMS and ADSO). Custom Mainframe application is the Order to Cash cycle module for Confidential Aviation’s Spares business.
• Subject Matter expert in Order to Cash processes—Customers, Pricing, Order entry and Validations, Order Imports, Quote, Allocation, Shipping execution, Inventory and Forecasting
• 6 Years of functional experience in Confidential Aviation Commercial Spares business, 1 year of functional experience in Commercial Spares Forecasting (Servigistics), 5 years of functional experience in Confidential Aviation Military Spares business
• Experience in Mainframe to Oracle migration project for Aviation Spares businesses.
• Experience in leading Application development teams, ETL Integration teams, Business data warehouse teams and data conversion teams.
• Adept at preparing business requirements document (BR150), writing system requirements specifications.
• Experience in all facets of Software Development Life Cycle (SDLC) including Requirements gathering, assessing business objectives, Design, Coding, Use Cases creation, Testing, and Deployment.
• Requirements and design of some of critical data conversions such as Customer Conversion, Sales Order conversion, Price list, Pricing agreements.
• Led functional, technical and Integration teams in Technical design, Development, Testing and implementation.
• Experience in leading 20+ applications team that integrate with Oracle Apps starting with requirements through Cutover execution.
• Experience in leading major Cutover activities for multiple implementations that impacted 20+ applications.
• Experience in leading teams with ability to plan, track and achieve project goals within project constraints. Adept at defining Project plan and delivering project/status reports
• Extremely well organized, with proven ability to multi-task and prioritize workload.
• Experience in Presales/Solutioning with ability to create proposals. Well versed with solutioning capabilitie

TECHNICAL SKILLS:

• Over 12+ years of Supply chain domain experience with strong knowledge on Oracle Apps Order to Cash cycle.
• Specialized in System Integrations primarily on Informatica ETL’s, Business data warehouse ETL integrations with Oracle Applications and legacy applications, Data Conversion from legacy applications (Mainframe) to Oracle, Legacy migration implementations to Oracle.
• Technology: Oracle PL SQL, COBOL, IDMS/ADSO, JCL
• Tools HP ALM, Service now, IBM Utilities for Mainframe, CA7, Appworx Scheduler, Informatica
• Process/Methodology Six Sigma, dPMM ( Confidential ’s In-house Project management methodology), Waterfall and Agile-Scrum
• Project Management Planning, Estimation, Risk Analysis and Mitigation plan, Status review

EXPERTISE AREA:

• Excellent Communication, analytical, interpersonal and presentation skills
• Great team player
• Responsiveness, Initiatives, Customer handling skills, Documentation, Positive attitude, Well thought solutions, Dedication

PROFESSIONAL EXPERIENCE:

Project Lead /Business Analyst

Confidential, Cincinnati, OH

Responsibilities:

• Subject Matter Expert in Confidential Aviation’s ITO-OTR business processes.
• Involved in Requirement gathering for Military Confidential ITR implementation
• Created requirements fit gap, integration fit gap, future process model, data conversion mapping and extraction document, Functional design document for Spares business processes. Some of key processes include Customer setup, Order entry, Order import, Order Validations, RFQ Validations, Hold Apply/Release, Order Acknowledgements, Notifications, Allocation, Shipping, Warranty, Inventory, Forecasting etc.
• Led Functional and technical teams in design, development and implementation for Oracle Order Management modules.
• Led business data warehouse integration and reporting teams that involved in requirement gathering, design, development, testing and Implementation.
• Worked with 20+ applications that integrate with Military during MSO Confidential implementation. This involves requirement gathering, design, development, cutover plan and execution.
• Involved in data warehouse integration mapping from application system, functional and technical design of different datasets for data warehouse reporting. Created technical mapping document that maps Oracle tables/views/fields to legacy BDW data fields for BDW reporting teams.
• Unit testing and Integration testing of Oracle Order Management and Inventory processes.
• Manage team of System Analysts that come up with existing business processes
• Core Member in Presales/Solutioning team for all initiatives
• Worked with application teams and other system integration team for creating detail Cutover plans and execution.
• Project Planning and Tracking, Identify and mitigate risks, proactively identify and escalate issues that may adversely impact project deliverables.
• Status review with Customer.

Technology: IDMS/ADSO, COBOL, JCL, PL/SQL, Informatica

Technical Lead/Business Analyst

Confidential, Cincinnati, OH

Responsibilities:

• Project Lead in leading the initiative from vendor side from Project Initiation thru Completion phase
• Business analyst working closely with Confidential Aviation’s and Snecma‘s functional and IT team
• Core Member in Presales/Solutioning team
• Project status review and Monthly business review with Confidential

Technology: IDMS/ADSO, COBOL, JCL, PL/SQL, Informatica, UNIX, Java, Appworx

Confidential

Responsibilities:

• for implementing OTR in Oracle for Confidential Aviation’s Commercial Spares.
• Manage team of System Analysts that come up with existing business processes
• Business Analyst working closely with Confidential Aviation’s IT and business team.
• Project Lead leading a team of 10+ in implementing this project
• Project status review for Inventory Module with Confidential Confidential leadership team
• Cutover Lead for legacy applications
• Core Member in Presales/Solutioning team

Technology: IDMS/ADSO, COBOL, JCL

• Onshore Project lead for mainframe application managing team of 5
• Business analyst working closely with functional users at Onsite.
• Implemented various projects for Confidential Aviation’s Commercial business as Project lead.
• Took lead in continuously improving quality processes
• Coordination with TSG team in implementing project by following SOX process

Programmer/Team Lead

Confidential

Technology: IDMS/ADSO, COBOL, JCL

Responsibilities:

• Programmer for Confidential application team. Activities include Estimation, Analysis of requirements, Create Design documents, Test case documents, Build and Unit test.
• Promoted to Team Lead in leading a team of 4 associates in a year.
• Work closely with Onshore Project lead in gathering requirements.
• Coordinate and Conduct UAT.