Senior Analyst Resume

SUMMARY

Over 9 years of experience as Oracle Developer in Analysis, Design, Data Modeling (Logical and Physical), Implementation of Business Applications using the Oracle Relational Database Management System and Performance Tuning.
Good Hands on experience on Agile.
Extensive experience in Design, Development, Customization and Implementation of business applications using SQL, PL/SQL, Linux bash scripting etc.
Strong programming experience in creating Procedures, APIs, Packages, Functions, Triggers views, collections, records, sequences, Materialized views, Constraints and other database objects using SQL and PL/SQL.
Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
Experience in Application tuning using session trace file and TKPROF utility.

TECHNICAL SKILLS

SQL, PL/SQL, Oracle Reports, Shell Scripting
Domain knowledge of Purchasing, Order Management, Healthcare, Accounts Payable, Receivables, Inventory, Manufacturing.

PROFESSIONAL EXPERIENCE

Senior Analyst

Responsibilities:

Develop code, Unit - Test and support deployment.
Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle database.
Experience in Creation of queries, reports and other database objects using PL/SQL.
Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
Code review of team members and Vendors.
Manage documentation.
Support Production instances 24*7.
Development to import data from legacy system or export data to the third party software.
Experience in working in off-shore/on-site model, on-call 24/7 rotational support model and SME support when required.
Design, develop, implement, test, and deploy technical solutions to meet functional requirements.
Work together with functional analyst to figure out functional solution, propose technical solutions.
Debugging of code.
Creating interface and conversions.
Performance tuning.
Developed Data-Fix based upon the requirements.

Senior Analyst

Senior Software Engineer

Responsibilities:

Design, develop, implement, test, and deploy technical solutions to meet functional requirements.
Work together with functional analyst to figure out functional solution, propose technical solutions.
Load data from the Legacy system to Oracle Database.
Coordinate with offshore team.
Debugging of code.
Creating interface and conversions.
Work together with functional analyst to figure out functional solution, propose technical solutions.
Developed new reports.
Experience in working in off-shore/on-site model, on-call 24/7 rotational support model and SME support when required.
Developed Data-Fix based upon the requirements.

Senior Analyst

Oracle Apps Technical Consultant

Responsibilities:

Design, develop, implement and test technical solutions to meet functional requirements.
Develop various Oracle Applications using PL/SQL, SQL*Plus, Reports.
Tuning reports.
Debugging of code.
Creating interface and conversions.
Work together with functional analyst to figure out functional solution, propose technical solutions.
Developed new reports.
Experience in working in off-shore/on-site model, on-call 24/7 rotational support model and SME support when required.
Developed Data-Fix based upon the requirements.