We provide IT Staff Augmentation Services!

Programmer Analyst Resume

0/5 (Submit Your Rating)

Scotts Valley, CaliforniA

PROFESSIONAL SUMMARY:

  • 9 years of experience as a Project Lead/Techno - Functional Consultant in Oracle EBS across Modules (AP, AR, Payments, OM, GL, CSI, OKS).
  • Have been performing the project lead role and leading large teams technically and been responsible for delivery of projects on time and gain customers confidence at onsite.
  • Good in analyzing requirements, identifying the gaps, coordinating with the cross flow teams and designing solutions to bridge the gaps.
  • Have been responsible for estimating the efforts, planning the delivery and managing the resources effectively and do the delivery first time right and on time every time.
  • Highly appreciated and recognized for handling multiple critical projects at a time at onsite and delivering on time.
  • Possess excellent hands on both in Oracle EBS11i, R12 and Technical knowledge on Modules AP, AR, CE, OM, CSI, OKS. Also worked on interface/reports for and has basic knowledge on HRMS.
  • Excellent technical skills in SQL, PL/SQL, SQL*Loader, Forms 6i/10g, Reports 6i/10g, Interfaces, Data migrations, conversions, Form Personalization, UNIX shell script and Oracle Alerts.
  • Extensively worked on RICE components.
  • Posses fare functional knowledge across the Oracle EBS modules like AP, OM, AR and at a basic level on INV, GL, CE, CSI
  • Highly Collaborative and possess very good communication, presentation and interpersonal skills with good analytical & logical abilities and excellent academic record.
  • Have taken around 50 interviews for different project requirements and scrutinized more than 100 profiles to identify the required candidates/skill sets for open requirements.

TECHNICAL SKILLS:

Operating Systems: DOS, Windows 95/98/2000/ME/XP/Vista/7/8

ERP: Oracle EBS (release 11i and R12)

Modules: Modules: - Financial Modules (AR, AP,GL, Payments)

CRM Modules (CSI,OKS): And good knowledge on OM and at basic level on INV,PO,HRMS

Technical Components: RICE (Reports, Interfaces, Conversions, Extensions), Loaders.

GUI: Forms 6i/10g, Reports 6i/10g/11g

Languages: SQL, PL/SQL. XML

Tools: TOAD, SQL Developer, Toad, Putty, WinSCP

PROFESSIONAL EXPERIENCE:

Confidential, Scotts Valley, California

Programmer Analyst

Environment: Languages: SQL, PL/SQL, UNIX Database: Oracle 11gTools: Oracle EBS 12.0.3SQL*Loader, Toad, SQL Developer

Responsibilities:

  • Interact the business teams and gather the requirements.
  • Document the requirements, review with the business and IT teams.
  • Analyze and design the solution to integrate the credit payment processing using cyber Source (Industry leading Credit Card processing company).
  • Work with the DBA teams and lead the installation of Cyber Source with Oracle EBS R12 ERP.
  • Review the solution with the cross flow teams and make sure all the required scenarios are covered and test cases are prepared.
  • Implement the solution and test.
  • Work along with other teams to fix any issues and get the solution/code migrated to appropriate instances.
  • Demonstrating the implemented solution to business users and provide support during Biz SIT and UAT.
  • Migrate the solution to Prod and provide post go live support.

Confidential, San Jose, California

Project Lead

Environment: Languages: SQL, PL/SQL, UNIX Database: Oracle 11gTools: Oracle Applications 12.0.3SQL*Loader, Toad, SQL Developer

Responsibilities:

  • Analyzing the existing Credit Card capability in Oracle EBS 11i and do a feasibility study wrt EBS R12.
  • Responsible for reviewing the BRD, analyzing the requirements and coordinating with biz team to understand the requirements.
  • Responsible for identifying the gaps in the present system to fulfill the user requirements.
  • Estimate the efforts required and plan the different phases and drive the design/dev and deployment.
  • Responsible for working with the cross flow/dependent teams to design solutions and bridge the identified gaps as per user requirements.
  • Responsible for getting the required setups done and documenting the same.
  • Responsible for technical design, coordination with the development team and implement the Credit Card functionality.
  • Responsible for making the necessary documentations as per Oracle/Cisco standards, get the reviews done.
  • Responsible for unit testing and helping the development offshore team fix the issues and document the test results.
  • Responsible for coordinating with the QA team in testing, get any bugs fixed and deploying the code as appropriate.
  • Work with third party Cyber Source team for integration with AR and resolve nay issues.
  • Coordinate with the team, delegate and monitor the progress on assigned items as per set milestones.
  • Conduct reviews and demonstrate the solutions to business and other dependent cross flow teams.
  • Participate in design review meetings conducted by other cross flow teams having dependencies with Credit Card.
  • Participate in transition to get the code propagated into appropriate environments as per project release cycle/timelines till go live into production.

Confidential, San Jose, California

Project Lead

Environment: Languages: SQL, PL/SQL, UNIX Database: Oracle 11gTools: Oracle EBS 12.0.3SQL*Loader, Toad, SQL Developer

Responsibilities:

  • Responsible for reviewing the BRD, analyzing the requirements and coordinating with biz team to understand the requirements.
  • Responsible for identifying the gaps in the present system to fulfill the user requirements.
  • Responsible for working with the cross flow/dependent teams to design solutions and bridge the identified gaps as per user requirements.
  • Responsible for getting the required setups done and documenting the same.
  • Responsible for technical design, coordination with the development team and implement the NGCCRM functionality.
  • Responsible for making the necessary documentations as per Oracle/Cisco standards, get the reviews done.
  • Responsible for unit testing and helping the development offshore team fix the issues and document the test results.
  • Responsible for coordinating with the QA team in testing, get any bugs fixed and deploying the code as appropriate.
  • Conduct reviews and demonstrate the solutions to business and other dependent cross flow teams.
  • Participate in design review meetings conducted by other cross flow teams having dependencies with Enabler.
  • Knowledge transfer to the General Support team.
  • Participate in transition to get the code propagated into appropriate environments as per project release cycle/timelines till go live into production.
  • Provide post go live normalization support.

Confidential, San Jose, California

Project Lead

Environment: Languages: SQL, PL/SQL, UNIX Database: Oracle 11gTools: Oracle EBS 12.0.3SQL*Loader, Toad, SQL Developer

Responsibilities:

  • Responsible for reviewing the BRD, analyzing the requirements and coordinating with biz team to understand the requirements.
  • Responsible for identifying the gaps in the present system to fulfill the user requirements.
  • Responsible for working with the cross flow/dependent teams to design solutions and bridge the identified gaps as per user requirements.
  • Responsible for getting the required setups done and documenting the same.
  • Responsible for technical design, coordination with the development team and implement the NGCCRM functionality.
  • Responsible for making the necessary documentations as per Oracle/Cisco standards, get the reviews done.
  • Responsible for unit testing and helping the development offshore team fix the issues and document the test results.
  • Responsible for coordinating with the QA team in testing, get any bugs fixed and deploying the code as appropriate.
  • Conduct reviews and demonstrate the solutions to business and other dependent cross flow teams.
  • Participate in design review meetings conducted by other cross flow teams having dependencies with Enabler.
  • Knowledge transfer to the General Support team.
  • Participate in transition to get the code propagated into appropriate environments as per project release cycle/timelines till go live into production.
  • Provide post go live normalization support.

Confidential, San Jose, California

Project Lead

Environment: Languages: SQL, PL/SQL, UNIX Database: Oracle 11gTools: Oracle EBS 12.0.3SQL*Loader, Toad, SQL Developer

Responsibilities:

  • Responsible for reviewing the BRD, analyzing the requirements and coordinating with biz team to understand the requirements.
  • Responsible for identifying the gaps in the present system to fulfill the user requirements.
  • Responsible for working with the cross flow/dependent teams to design solutions and bridge the identified gaps as per user requirements.
  • Responsible for getting the required setups done and documenting the same.
  • Responsible for technical design, coordination with the development team and implement the NGCCRM functionality.
  • Responsible for making the necessary documentations as per Oracle/Cisco standards, get the reviews done.
  • Responsible for unit testing and helping the dev team fix the issues and document the test results.
  • Responsible for coordinating with the QA team in testing, get any bugs fixed and migrate the code as appropriate.

Confidential, San Jose

IT Analyst/Tech Lead

Environment: Languages: SQL, PL/SQL, UNIX Database: Oracle 11gTools: Oracle EBS R 12.0.3Oracle DeveloperSuite11g, SQL*Loader, Toad, SQL Developer

Responsibilities:

  • Responsible for identifying the gaps in the present system to fulfill the user requirements
  • Responsible for working with the cross flow/dependent teams to design solutions and bridge the identified gaps as per user requirements.
  • Responsible for getting the required setups done and documenting the same.
  • Responsible for technical design, coordination with the development team and get the code development done.
  • Responsible for making the necessary documentations as per Oracle/Cisco standards, get the reviews done.
  • Responsible for unit testing and helping the dev team fix the issues and document the test results.
  • Responsible for coordinating with the QA team in testing, get any bugs fixed and migrate the code as appropriate.

Confidential

Onsite Tech Lead

Environment: Languages: SQL,PL/SQL,UNIXDatabase: Oracle 10gTools: Oracle EBS R 12.0.1Oracle DeveloperSuite10g, SQL*Loader, Toad, SQL Developer

Responsibilities:

  • Involved for technical discussions for the interfaces that would be required as part of the EBS integration with the other operational applications for the client.
  • Responsible for providing the data specifications and requirements to the client for the integration design.
  • Responsible for helping out the functional team with any sort of technical inputs required to carry on with the analysis/design/implementation tasks.
  • Responsible for technical design, coordination with the development team and get the code development done.
  • Responsible for making the necessary documentations as per Oracle/Cisco standards, get the reviews done.
  • Responsible for unit testing and helping the dev team fix the issues and document the test results and migrate the code to Production.

Confidential

Project Lead

Environment: Languages: SQL,PL/SQL,UNIX Database: Oracle 10gTools: Oracle EBS R 12.0.1Oracle Developer Suite 10g, SQL*Loader, Toad, SQL Developer, XML Publisher, Workflow.

Responsibilities:

  • Designed and made retrofit to the required components under financial modules.
  • Created new alerts for Annual leave expiry in HRMS and also made changes to the leave entitlements based on employee assignments.
  • Developed new components like the Etext formats for the existing bank payment processes and integrated them to the Oracle Standard Payment Process.
  • Has made the changes to the different leave accrual plans like annual leave plan, off-in-lieu leave plan(Fast Formulas) and their respective carry over formulas and sub accrual formulas.
  • Provided support and resolved all the existing issues as part of the retrofit.
  • Prepared the MD070 document for all the financials components that are developed/ modified.
  • Provided functional assistance to the functional team when ever needed and suggested the solution at times.

Confidential

Consultant

Environment: Languages: SQL,PL/SQL,UNIX Database: Oracle 10gTools: Oracle Reports 6i,forms 6i, SQL*Loader, Toad, SQL Developer

Responsibilities:

  • Taking care of any new Change requests or enhancement requests, developing and duly testing the same before propagating to UAT.
  • Has been responsible for taking care of the code changes to fix the issues that users report on day to day basis.

Confidential

Migration Lead

Environment: Languages: SQL, PL/SQL, UNIX Database: Oracle 10gTools: SQL*Loader, Toad, SQL Developer.

Responsibilities:

  • Involved in the new Data Base design for P2(New system) based on the existing design in P1(operational/old system).
  • Involved in the creation of DB and getting data exported onto new database from old database.
  • Developed the procedures and functions for verifying the source data in P1 tables, validating and migrate the same into P2 tables.
  • Testing the performance at query and procedure levels and does the optimization where required
  • Involve in the Data Verification activity along with users and clarify any doubts they have

Confidential

Technical Consultant

Environment: Languages: PL/SQL

Responsibilities:

  • Responsible for data Migration from legacy system to Apps for CSI and OKS.
  • Responsible for AR and AP invoice interface development to migrate date from legacy systems to Oracle EBS R12.
  • Responsible for Building custom report in CE.
  • Responsible for Building an interface to import bank statements into Oracle cash management.
  • Responsible for Integration between banking system and Oracle apps system.
  • Responsible for performing Unit testing and Code review for developed RICE Components
  • Responsible for migration of new and enhanced components from development instances to CRP, UAT, and QA and eventually to Production environments by employing the Mercury IT Governance tool (Kintana)

Confidential

Technical Consultant

Environment: Languages: PL/SQL Database: Oracle 9iTools: Oracle EBS 11i,Oracle Reports 6iOracle Forms 6i,Toad

Responsibilities:

  • Production Support & Enhancements of GAMS EAST APEX & Sabrix Instance
  • Analyze and work for the resolution of technical issues related to Financial and distributions application modules.
  • Assign/ follow up status of cases/tickets with the team members
  • Code modifications in the form of enhancement requests from the user and providing custom queries impacted into the business.
  • Providing Data fixes wherever required
  • Issue resolutions related to work products
  • Preparing Test cases for testing the code changes in the Development instance
  • Testing application (Includes the Unit Testing and Pre Integration testing)
  • Tools such as TOAD and utility like SQL*PLUS is used as a platform for testing the code developed/modified
  • Preparing Quality Documents conferring to Confidential standards
  • Communication with the Customer.
  • Identify new areas of work. Conduct regular meetings with key customers. Collect feedback from customer.

Confidential

Tech Team Lead

Environment: Languages: PL/SQL Database: Oracle 9iTools: Oracle Reports 6iOracle Forms 6iProject Description:

Responsibilities:

  • Providing the manpower resources to projects for requests from VBU’s, RBU’s, RCC and circles DM’s. Tracking and follow-up with resource requesters to fulfill the requests.
  • Identifying and conducting the s, workshops, competency assignments to enhance the (circle’s business wait) associates skills in the areas of technical, domain, quality and soft skills.
  • Maintaining the associates profile to track the individual and team’s competency strengths in the areas of technical and domain fronts.
  • Recruiting the new resource from outside or from CO RCC by conducting the interviews to meet the demand of resource requesters. Meeting the infrastructure needs of associate. (Providing workstations, Laptops and access to floor).
  • Efficiently making use of senior associate’s services in recruitment interviews and programs.
  • Resource management team operations status update to top management.
  • Addressing associates concerns, ps and aspirations.

We'd love your feedback!