Application Analyst Resume Profile
PROFESSIONAL SUMMARY:
- Oracle PL/SQL Developer with over 6 Plus years of extensive experience in SQL PLUS, Oracle SQL, PL/SQL Development Oracle 10g/9i , Application Development, Implementation of ERP Oracle Apps Application, Performance Analysis, Production Support, Software development life cycle, leading and executing deliveries and supporting global clients customers
- Implementation, Development, Enhancement and support of Oracle Modules Account Payables/ Order Management/ General Ledger/ Purchasing/ Cash Management/ Inventory/ Manufacturing
- Experience in Client / Server database application development and Migration using Oracle 9i/10g/11g AS, Oracle Designer and Oracle Developer 9i/10g/11g AS on Windows, AIX and UNIX environment.
- Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well verse in ERWIN
- Experts in PL/ SQL programming, SQL, Application Tuning and SQL loader, Pro C scripts.
- Expert in writing efficient SQL and PL/SQL code Stored Procedure, Functions, Triggers, Autonomous Transactions and Packages on TOAD to analyze very large data sets
- Expertise with ERP implementation and Data Conversions
- Experience in Oracle E-Business Suite 11i and R12 and Oracle Developer Suite
- Expertise in system integration testing, preparing design documents
- Excellent Analytical skills to understand the business process and functionality, requirements and to translate them to system requirement specifications
- Experience in various phases of SDLC like Exploring requirements, Analysis/Design, Development, Testing and deployment, Go-live and Post go-live support
- Experience in preparing Test plans, Test Data and execution of Test cases to ensure application functionality meet the user's requirements
- Well versed with Unix Scripts and Unix Shell Scripting
- Experience in handling Production cases and escalations
- Ensured Project compliance to Quality and Standard implementation methodology Drive QA processes for the project in the program, Participate in CMMI Level 5, Identify, communicate and implement opportunities for process/solution improvement Establish CMMI process to control defects and improved customer satisfaction
- Have good experience in On site-offshore model execution of projects
- Excellent documentation and presentation skills, great verbal and written communication skills
- Customized and modified Forms/Reports in Oracle Financial modules.
TECHENICAL SKILLS
OS | Unix, Windows '95/98 and Windows NT/XP. |
Hardware | HCL, PC-Compatible, Novel NetWare. |
Languages | SQL, PL/SQL, 'C ', Pro C and SHELL. |
RDBMS | Oracle9i/10g/11g, SQL Server 6.5, Utilities Export, Import, SQL |
ERP | Oracle Applications11.5.8 INV, BOM, PO, GL, AOL , CMiC Application V10. |
GUI | Developer 2000 Forms Builder 4.5/5.0/6.0/6i/9i/10g/11g AS , Reports 2.5 / 3.0/6.0/6i/9i/10g AS , Discover 10g, Visual Basic 5.0, Procedure Builder, MS Access, MS Office 2000 and MS Excel, OEM, Designer 2000, SQL Navigator, TOAD 9.0/10, SQL Programmer, PVCS, VSS,VSN. |
Tools | Khameleon Financial Management System Suite V5.1.0 . |
OLAP | Business Objects v4.5/5.1 |
EXPERIENCE
Confidential
Program Analyst.
Responsibilities:
- Designed and Developed the SCS application from document level. Building template form, standard libraries and Package's, which support the daily business and synch with current level of application.
- Designed the various Oracle logical and physical databases for data integration and database developments as application demands for better maintainability.
- Setting up Environment in Oracle 10g application RDBMS, Forms, and Reports for new application.
- Writing SQL, PL/SQL programs, Packages, Stored procedures, Functions and Triggers to automate the interface processes for daily transaction.
- Responsible for tracking the Load the data into the DPS application, which comes in flat files and process them for correctness.
- Developed Complex Forms Using dB packages / reports Web Reports Excel format and PDF format using DEVELOPER 2000 Forms 9i/10g, Reports 9i/10g 10g R2 using custom template form for user screens.
- Building the Dash Board for SCS Applications so that will show only accessible applications/ forms are available for the logged user as per the assigned permissions.
- Responsible for Application integration and supporting the user/business critical issues in 24 x7.
- Maintaining and scheduling the different interfaces, which feed the data from SCS, ORACLE APPLICATIONS and sending forecast data into PASI Custom Application . Also actively participated in monitoring the interfaces and making sure that the process flow completed successfully.
- Ability to work with functional teams in an AGILE environment Established excellent meeting, facilitation, and presentation skills
- Worked with version control system GIT.
- Involved in RDBMS developments include building data migration scripts using Oracle SQL LOADER, and UTL packages.
- Worked with the Sr DBA's and Oracle Support Team for TAR/Service Requests for some critical issues on the Application and User Issues.
- Conducting analysis and design for implementing the project development phases.
- Worked on Performance tuning of Custom PL/SQL Code, Forms and Reports.
- Worked with team of four in the application.
- Development of Functional Design Documents FDD for given task for Business approval and convert then to Technical Design Document TDD before going to development phase.
Demonstrated ability to monitor and track performance, anticipates risks, resolve and debug Issues within Oracle applications and escalate if needed.
Responsible for the Data Mart reporting Project using the Oracle RDBMS Technology 10g AS for higher management.
Keep track of user activities in SCS Application to make sure no user is locked by others.
Migrating the New /Modified Forms/Reports to Oracle Application Portal.
Testing of application with different sample test data in different SCHEMAS like DEV, TEST for accuracy of application before moving to QA and UAT and update in the VSS.
Environment: Oracle 9i/10g SQL PLUS, SQL, PL/SQL , DEVELOPER 2000 FORMS 9i/10g, REPORTS 9i/10g , TOAD, SQL Navigator, Oracle WEB server, Oracle Applications 11. Java Scripting, HTML, Erwin Data Model, Apache Web Server, VSS. Oracle Discover 10g.
Confidential
Program/Application Analyst
Responsibilities:
- Responsible to Supporting and maintain the CMiC Enterprise Application.
- Creating scripts to generate the data for reports developed in Oracle reports/Discoverer as per user requirements.
- Creating Oracle Database objects based on the new requirement Tables, Indexes, views, partitions, constraints, triggers etc.,
- Writing SQL, PL/SQL programs, Packages, Stored procedures, Functions and Triggers to automate the interface processes for daily/incremental loads.
- This is the Java front end application with Oracle Database as a backend, Building/maintaining the Oracle dB for supporting the Java application as a front end.
- Responsible for preparing the migration and deployments scripts for CONV, UAT as well as PRODUCTION environments.
- Coordinating with CMiC Application support and application team for issues and concerns.
- Experience in Database Design, Database programming, SQL and Database Tuning and Performance Tuning, Trouble shooting, maintenance.
- Create the jobs and schedules them to run on the specific times and will not affect the system performance, Email notification setup for failure notifications.
- Worked with the Sr DBA's and CMic Application Support Team for Service Requests for some critical issues on the Application and User Issues.
- Conducting analysis and design for implementing the project development phases.
- Participation in project discussion, trouble shooting and problem solving interactions and user support.
- Designed and coded application components in an Agile environment utilizing a test driven development approach.
- Created and maintained project tasks and schedules.
- Developed Complex forms/ reports using DEVELOPER 2000 Forms 11g, Reports 11g for the Application.
- Extensively used SQL joins, Oracle analytic and grouping functions for data analysis.
- Created complex views for the purpose of extracting the Data and to avoid duplicating the Dictionary tables on data stage/DW.
- Dealing with performance tuning SQL related issues and resolving the Issues with Oracle 10/11g Advanced Functions as to cope up with con-current processes and to make it faster.
- Requirements gathering from Specs, Users/PM's and documentation, data cleansing and extraction, report design and implementation, and testing.
- Making sure all the batch jobs are working with no issues as data and performance wise and available by morning for the business.
Environment: SQL, PL/SQL, Oracle 11g, Developer 2000 Reports 11g, Forms 11g , SQL Loader, Toad 10.5, SQL Navigator V5.5,Oracle SQL developer V3.0, Oracle Discover 11g, CMiC Enterprise Application V10, Erwin.
Confidential
Oracle PL SQL Developer
Responsibilities
- Developing the custom RDF reports on the AP, GL, OM modules and testing the same
- Worked extensively on PL SQL packages, stored procedures and cursors and functions
- Designed and developed the custom tables using Oracle 10g based on existing for the inbound and outbound interfaces
- Migrating the custom tables, PL SQL packages to other environments and testing the custom code
- Worked extensively on registering reports and creating and migrating concurrent programs to other environments
- Worked extensively on UTL FILE functions, UNIX shell scripting
- Co-ordination with the on site team
- User requirement gathering, design development of Inbound and Outbound interfaces in Financial and Manufacturing modules
- Developing Unit test plan
- Performing Unit testing, Integration testing
- Coordinating with functional team leads for functional testing
- Updating the test documents
- Providing support for the post go-live activities
Environment: Oracle 11i, Oracle Reports, Oracle Interfaces, UTL FILE, PL/SQL, SQL, Oracle 9i database, TOAD.
Confidential
Oracle PL SQL Developer
Responsibilities
- Worked extensively on PL SQL packages, stored procedures, functions, cursors and arrays
- Have extensive knowledge in creating global temp tables
- Worked on UNIX shell scripting which sends email to users with text output as an attachment
- Worked on PL SQL code to submit the concurrent programs programmatically and test the process
- Involved in end to end testing of the custom components
- Co-ordination with On site team for the deliverable s
- Understand Client Business process and prepare the design documents and test plans
- Involved in integration testing
Environment: Oracle R12, Oracle Extensions, PL/SQL, SQL, Oracle 10g database, TOAD