Sr Business Analyst
Resume:
Jayashree Kumar
Summary:
• * years of experience in ORACLE,Qlikview, with over 1.5 years of experience in USA.
• Have strong expertise in Oracle Reports, Oracle Forms, Qlikview,XML Publisher, Oracle ApEx, Oracle Applications, UNIX, Shell Scripting and ORACLE-PL/SQL.
• Good experience in Development, Testing, Debugging, Documenting, Implementation & Maintenance of complete project life cycle in waterfall and Agile methodologies.
• Very strong in PL/SQL, stored procedures/packages, triggers, constraints, cursors, views and writing test scripts.
• Have excellent interpersonal, verbal and written communication as well as presentation skills that are needed to interact with all levels of management, business partners, end users, and applications developers.
• Enhanced the existing SQL queries in different interface modules using various SQL tuning techniques.
• Underwent six sigma yellow belt training and implemented process improvement project using DMAIC methodology.
• Conducted trainings on Oracle Applications, Oracle Forms and Oracle Reports
• Have good experience in working for Oracle On Demand projects.
• Worked with clients from varied industries like Health Insurance,Government, Pharmaceutical, Airlines, Food processing and Co-operative societies.
Education, Certifications & Awards:
• Bachelor of Engineering (B.E) from College of Engineering, Guindy, Anna University, Chennai
• Best Oracle EMEA Project Award for BuZa
Technical Skills:
Systems Software Microsoft Operating Systems, Windows NT/2000/98/95/XP, UNIX
Tools Qlikview 9.0, Oracle Forms 4.5, Oracle Reports 6i, PL/SQL Developer, TOAD,SQL * Plus, Oracle Application Express 3.0, BI Publisher.
Languages SQL, PL/SQL, Unix Shell scripting
Databases Oracle 9i, 10g
Application Oracle E Business Suite R11i
EXPERIENCE:
Client: Humana Inc, Louisville , KY
Duration: Nov2009-Till date
Role: Programmer Analyst
Humana Inc. is a health Insurance Company, offering a range of products and services in their line of business. This project involved the development of Reports using Oracle BI Publisher, and creating database structures using SQL, PL/SQL for its infrastructure. A separate web version using Qlikview was also developed to provide on the fly reporting to business users across the USA.
Responsibilities:
• Lead a team of software professionals to develop, test and deliver Reports within Agile methodology.
• Headed the scrum team with focus on iterative and incremental deliveries.
• Design and create ETL and reports using Qlikview9.0.
• Create Customer facing reports using Oracle BI Publisher
• Creating PL/SQL procedures and packages for implementing complex business logic.
• Assessed the end users business processes and corresponding data requirement.
• Interact with end users to analyze requirements and resolve issues.
• Interpreted the business processing and data requirement into a new logical and physical Data model.
• Performed SQL and design level performance tuning.
• Preparation and review of Acceptance Test Plan and Specifications.
• Reviewing team members' code and quality inspection.
Technologies used: Oracle 9i/10g (PL/SQL),XML Publisher, Oracle Reports 6i, Oracle Applications R11i, UNIX and Shell Scripting.
Employer: Oracle SSI
Duration: Aug2006 – Feb2009
Role: Associate Consultant
Pfizer Project
Pfizer forms the world's largest research-based pharmaceutical company. The entire applications in Pfizer runs on Oracle APPS. This project involved the deelopment, enhancement and debugging of XML based reports using XML Publisher and Oracle Reports 6i.
Responsibilities:
• Enhance existing Customer facing Oracle Reports on Remittance, Purchase orders, dunning letters, Statements, Invoice.
• Creating PL/SQL procedures and packages for implementing complex business logic.
• Assessed the end users business processes and corresponding data requirement.
• Interact with end users to analyze requirements and resolve issues.
• Interpreted the business processing and data requirement into a new logical and physical Data model.
• Developed the Data Model.
• Migrated Concurrent Programs, forms, responsibilities and menus to the Production environment.
• Developing new reports for different countries.
• Creating XSL code for handling the delivery of reports.
• Performed SQL and design level performance tuning. Used Trace files generated when reports are run to track SQLs that needs tuning. Used Explain Plan as a tuning tool.
• Preparation and review of Acceptance Test Plan and Specifications.
• Reviewing team members' code and quality inspection.
Technologies used: Oracle 9i/10g (PL/SQL),XML Publisher, Oracle Reports 6i, Oracle Applications R11i, UNIX and Shell Scripting.
Co-op Project
The Co-operatives UK supports the lay and professional leadership of co-ops, for example by providing training for directors and employees; it is concerned with improving the trading performance of societies; it develops effective partnerships between co-operative sectors and organizations in the UK and promotes co-operation in the UK and world-wide; it maintains good relations with government and parliament in support of co-operative business and principles and organises the annual meeting of the Movement - Co-operative Congress. UK Co-op implemented Oracle Applications 11.5.10 to take care of their business from Sep 2007 till Dec2007.
Responsibilities:
• Removing invasive customisations from custom objects using APIs.
• Upgrading Custom Plls to 11.5.10 using Forms6i.
• Upgrading the Oracle Reports, forms, packages, procedures, functions to 11.5.10
• Involved in writing UNIX shell scripts and ORACLE-PL/SQL to install the upgraded objects.
• Checking the functionality of forms and reports in 11.5.10 Apps environment.
• Migrated Concurrent Programs, forms, responsibilities and menus to the Production environment.
• Preparation and review of Acceptance Test Plan and Specifications.
• Creating release schedules and packaging objects for every release.
• Reviewing team members' code and quality inspection.
Technologies used: Oracle 8i/9i (PL/SQL),Oracle Forms 6i, Oracle Reports 6i, Oracle Applications R11i, UNIX and Shell Scripting.
Emirates Project
The Emirates Group is a dynamic travel and tourism operation with a global reputation for excellence. Emirates Airlines of UAE implemented Oracle Applications 11.5.10 to take care of their business during June2007.
Responsibilities:
• Upgrading Custom Plls to 11.5.10 using Oracle Forms6i tool.
• Upgrading the Oracle Reports, forms, packages, procedures, functions to 11.5.10
• Installing the objects using UNIX shell scripts and ORACLE-PL/SQL in test and production environments.
• Checking the functionality of forms and reports in 11.5.10 Apps environment.
• Migrated Concurrent Programs, forms, responsibilities and menus to the Production environment.
• Preparation and review of Acceptance Test Plan and Specifications.
• Conducting, coordinating and managing Testing
• Creating release schedules and packaging objects for every release.
• Reviewing team members' code and quality inspection.
• Involved in performance tuning of SQL’s.
• Performed SQL and design level performance tuning. Used Trace files generated when reports are run to track SQLs that needs tuning. Used Explain Plan as a tuning tool.
Technologies used: Oracle 8i/9i (PL/SQL),Oracle Forms 6i, Oracle Reports 6i, Oracle Applications R11i, UNIX and Shell Scripting.
PI Greece Project
The Pepsi Bottling Group (PBG) is the world's largest manufacturer, seller and distributor of Pepsi-Cola beverages. The PBG generates nearly $14 billion in annual sales. It operates in the United States, Canada, Greece, Mexico, Russia, Spain and Turkey. PepsiCo Greece completed their Applications upgrade to 11.5.10 during June2007. The Application was made available in Greek and English.
Responsibilities:
• Resolve issues reported by client and optimization of queries to improve the workability of reports.
• Upgrading the Oracle Reports, forms, packages, procedures, functions to 11.5.10
• Performed SQL and design level performance tuning. Used Trace files generated when reports are run to track SQLs that needs tuning. Used Explain Plan as a tuning tool. Performed code review, worked with materialized views,de-normalization and other techniques to improve performance.
• Participate in day to day client calls to speed up resolution and enhance performance of code.
• Involved in writing UNIX shell scripts and ORACLE-PL/SQL to install the upgraded objects.
• Checking the functionality of forms and reports in 11.5.10 Apps environment.
• Migrated Concurrent Programs, forms, responsibilities and menus to the Production environment.
• Preparation and review of Acceptance Test Plan and Specifications.
• Conducting, coordinating and managing Testing
• Involved in performance tuning of SQL’s.
Technologies used: Oracle 8i/9i (PL/SQL),Oracle Forms 6i, Oracle Reports 6i, Oracle Applications R11i, UNIX and Shell Scripting.
BuZa:
The Ministry for Foreign Affairs of Netherlands upgraded their Oracle Applications to 11.5.10 during January 2007. It involved the upgrading of over 3000 customized tables, views, packages, procedures, functions, reports and forms to Oracle On Demand. This project won the Oracle EMEA Best Project Award for the year 2007-08 for Oracle.
Responsibilities:
• Create On Demand solutions to custom objects.
• Upgrading the Oracle Reports, workflows, forms, packages, procedures, functions to 11.5.10
• Involved in writing UNIX shell scripts and ORACLE-PL/SQL to install the upgraded objects.
• Migrated Concurrent Programs, forms, responsibilities and menus to the Production environment.
• Checking the forms and reports in 11.5.10 Apps environment.
• Preparation and review of Acceptance Test Plan and Specifications.
• Conducting, coordinating and managing QA Testing and UAT
• Involved in performance tuning of SQL’s.
Technologies used: Oracle 8i/9i (PL/SQL),Oracle Forms 6i, Oracle Workflow Builder, Oracle Reports 6i, Oracle Applications R11i, UNIX and Shell Scripting.
PRS Project
PRS was an application built using Oracle Application Express 3.0 . It is an application designed to manage reporting, process and projects of Oracle employees. It was used to record information about employees and their hierarchy, create summary and detailed reports on project activities, consolidate reports, assign and monitor activities by individuals, report and track bugs and conduct surveys.
Responsibilities:
• Create database objects to store and process information
• Translate complex business logic into packages, procedures, functions etc
• Develop procedures, functions and PL/SQL blocks to process the business logic involved.
• Create the front end interface for displaying, retrieving data.
• Resolve issues and make enhancements to existing pages.
• Create applications to perform survey and publish results.
• Manage users and roles within the application.
• Developing reports using the data on weekly and monthly basis.
Technologies used: Oracle Application Express 3.0, Oracle 10g(SQL, PL/SQL), Unix and Shell Scripting
Contact this candidate