Project Oracle
Resume:
SUMIT NIGAM
Email:
sumitnigam@hotmail.c
om
Mobile: 513-***-****
San Jose, CA 95122
Residence: 408-***-****
ORACLE TECHNO FUNCTIONAL ANALYST
AR . OM . FA . AP . PO . iProcurement . CM . GL
A dynamic, team spirited and performance driven Oracle ERP professional
with an extraordinary blend of leadership, technical and business knowledge
offering more than six and half years key experience. Recognized for
excellent analytical, problem solving, designing solutions, handle complex
problems and troubleshooting skills. Good knowledge of software development
methodologies and practices. Have strong experience in Oracle Apps Finance
Functional modules - Accounts Receivable, Accounts Payables, and General
Ledger. Possess first-rate communication skills to collaborate on all
business levels and effectively directing and motivating team members at
onsite and remote locations to achieve project goals and bottom line
objectives.
Specializing In:
System Analysis Data collection, evaluating, gap analysis, proposing solutions
Oracle Development Forms, reports, interfaces, workflow, AOL objects, APIs,
performance tuning
Project Management Estimate level of efforts, project planning, execution,
leadership, change management
Documentation Functional solution design, technical design, technical
architecture, performance assessment
Technical Acumen:
. Oracle Forms . Shell Script . PLSQL . Kintana . 170 Systems
6i Developer
. Oracle Reports . Oracle . AppWorx . XML Publisher . Dollar
6i Workflow Universe
. PLSQL . Toad . PVCS . . Quality Center
Personalization
CERTIFICATIONS
. Oracle Certified Associate . Six Sigma Green Belt . Business Management
Program
AWARDS & ACHIEVEMENTS
. Superlative Performance Award from . Letter of Appreciation from Patni
General Electric Computer Systems
. Pat-on-the-Back Award from Satyam . Certificate of Appreciation from Cisco
Computer Services Systems
. Certificate of Appreciation for . Dream Team Member Award for consecutive
organizing Patni Annual Day Celebrations three years i.e. 2005, 2006 and 2007
2006
PROFESSIONAL HIGHLIGHTS
Systems Analyst
Satyam Computer Services, San Jose, CA
August 2008 to Present
IT ANALYST: Worked as IT Analyst for client Cisco Systems on projects
Project 1 Project 2
Project Name C3-DEX CCW 5.0
Oracle Accounts Accounts
Module Receivable Receivable
Duration Mar 2010 to Jan 2010 to
Present Present
Responsibilities:
. Analyze business requirements
. Provide user support for application set-ups, functional definition and
design, coordinating problem resolution and identifying and coordinating
inefficient programs/forms/reports. Provide project leadership and
functional expertise in an Oracle Applications ERP environment to support
business processes and objectives.
. Create documentation for Oracle Applications Financial modules, combining
business processes and application functionality, as well as training the
end-user community
. Prepare project plan, effort estimation, and managing and mentoring on-
site and off-shore team
. Collaborate with business, development and other project stakeholders
. Facilitate knowledge transition to QA and support teams
TECHNICAL LEAD: Performed role of Technical lead for client Cisco Systems
on projects
Project 1 Project 2 Project 3
Project Name ICW 4.0 iCC ICW SWPOC
Oracle Accounts Accounts Accounts
Module Receivable Receivable Receivable, Order
Management
Duration Jun 2009 to Mar Oct 2008 to Jun Aug 2008 to Oct
Responsibilities:
. Lead the development of end-user reporting solutions by understanding
user requirements, designing reporting solutions, and coordinating the
development of solutions in Oracle Applications
. Estimate level of efforts, prepare development project plan, manage
onsite and offshore resources, and allocate tasks in changing priority
environment
. Access impact of change requests, generate options, recalibrate plans and
advise team members
. Design, configure and code reports, user interface, programs, extensions
and interfaces
. Oracle forms and reports development, customization and personalization
. Code review to ensure standards and quality level for build
. Third party application integration with Oracle EBS
. SQL tuning and performance optimization of pl/sql programs
. Prepare and report project performance metrics
Senior Software Engineer
Patni Computer Systems, Cincinnati, OH
Jul 2005 to Aug 2008
IT ANALYST / TECHNICAL LEAD: Perform multifaceted role as IT Analyst and
Technical lead for client GE Aviation and GE Corporate on projects
Project 1 Project 2 Project 3 Project 4 Project 5
Oracle Purchasing Accounts Accounts Accounts AP, PO,
Module Receivable Receivable Receivable iProcurement,
CM
Duration Mar 08 to Aug Feb 08 to May Dec 08 to Mar Sep 07 to Jul Aug 05 to Sep
08 08 08 08 07
Client GE Aviation GE Aviation GE Aviation GE Aviation GE Corporate
Responsibilities:
. Understand business context of requirements to evaluate technology and
solutions
. Understand and provide guidance in defining Oracle Application set-ups
. Perform gap analysis between current state and desired future state
. Provide functional and technical inputs to requirements
. Provide technical analysis and recommendations
. Prepare project plan, effort estimation and managing on-site and off-
shore team
. Prepare Technical Architecture Design
. Interfacing between stakeholders and managers across multiple business
lines
. Create functional and technical design
. Conduct design reviews
. Conduct and participate in code review
. Conduct unit test and performance tuning
. Troubleshoot and fix bugs
. Conduct or consult on testing
. Deploy code to production
. Transfer knowledge to support teams
. Provide functional application support in a production environment and
during enhancement and upgrade projects.
Systems Executive
Inditravel, Delhi, India
Dec 2003 to Jul 2005
PROGRAMMER / ANALYST: Worked as a team member on role of programmer and
analyst to analyze business requirements, design and develop solutions.
Project 1 Project 2
Project Name KBIS TDS
Duration Aug 2004 to Jul Jan 2004 to Jul
2005 2004
Client Taj Trade and Taj Services
Transport
Responsibilities:
. Gather business requirements, analyze and prioritize
. Analyze and translate business requirements into technical system
specifications
. Code, test and debug moderate to highly complex programs
. Assess production problems and solutions
. Reverse engineer legacy systems and translate concept, logic into Oracle
based systems
. Analysis, design and development of solution
. Develop forms and reports
. Develop pl/sql packages, procedures, functions and triggers
. Develop and execute testing and training plans
. Analyze data migration from legacy system to Oracle Purchasing
. Create or update functional and technical documentation
EDUCATION
. Oracle Certified Associate . Master Degree in Computer Application
. Six Sigma Green Belt Certified . Bachelor Degree in Computer Application
. Six Sigma Black Belt Trained . Certification in Business Management
Program
. Certification in SQL/PLSQL from SQL Star . 35 Hrs PMP training (working towards
International certification)
KEYWORDS
Oracle, Oracle Applications, Oracle Apps, Oracle EBS, Receivable, Order
Management, Payable, Purchasing, General Ledger, Analyst, Technical,
Techno, Functional, Consultant, SQL, PL/SQL, Workflow, Shell Script,
Finance, Financial, ERP, API, Development, Customization, Personalization,
Procedures, Functions, Packages, Trigger, Interface, Third Party,
Integration, Testing, Table, Design, Tuning, Performance, Optimization,
Application, Object, Library, Fluent, Communication, Verbal, Motivate,
Bachelor, Team, Player, Forms, Reports, Lead, Metrics, Project Plan,
Associate, Best Practices, Design, Support, Production, AOL, Profile,
Concurrent, Manage, AR, OM, AP, PO, GL, Code, Build, Estimate, Cross
Functional, Analysis, Credit, Collections, Customer, RICE, Quality,
Solution, O2C, Training, Oracle 11i, Analyst, Oracle ERP Analyst,
Functional Analyst, Technical Analyst, ERP Analyst
Contact this candidate