SUMMARY

• Associated with IT industry for 7+ years in different projects as a developer and team lead with design, architecture, development, Quality Assurance, implementation, Support and maintenance of various business applications.
• Worked closely with end - users/clients through complex problems involving development and production Support. Pro-actively identify areas of opportunity and work to find solutions that meet the business needs of the customer.
• Rich experience in Oracle Architecture, Database Development, Data Migration and ETL process.
• Expertise in PL SQL Packages, Stored procedures, Function, Triggers, Views, Materialized Views, Oracle Objects, RICE (Reports, Interfaces, Customization and Extensions) components.
• Experience with Incident management, change management, defect tracking, Code migration, Version control, Interface, Data warehouse concepts, ETL, Conversions and Data Migration.
• UNIX Shell Scripting
• Experience in developing External Tables, Joins, Unions, Indexes and sequences.
• Designed ER diagram, to set the logical and physical relationships of database.
• Exposure to Oracle applications R12.
• Good understanding of Procurement and Finance business cycles.
• Onsite - Offshore Coordination, Support & Technical Assistance to the team members.
• Proven ability to interface and coordinate with cross functional teams and cultures, analyze existing systems, wants and needs, design and implement database solutions.
• Excellent business analysis skills.
• Developed Functional Design, Technical Design, Unit Test Plans, Unit Test Results, Migration Documents.
• Experienced in tuning offensive SQL using Explain Plan, TKPROF & SQL Trace.
• Extensively worked on Design, Development, Deployment & Maintenance of ETL process to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML SQL/ Oracle) to different targets (DB/Files) using Oracle utilities SQL * loader. Exposure to Informatica.
• Solid experience in Designing, Developing, Re-engineering, Deploying and fine-tuning Oracle Stored Procedures and packages.
• Great learning skills to adapt the rapid changing technologies and implementing the same. Well versed with Both Oracle AIM and AGILE methodologies
• Excellent communication, coordination, organizational and follow-through skills, Efficient in the execution of all assignments, eager to take on new challenges.
• Recognized by clients for exceptional performance and sustained excellence in service delivery.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g/12c.

Scripting: SQL, UNIX.

Languages: SQL, PLSQL, UNIX.

Tools: TOAD, PLSQL Developer, SQL plus, WINSCP, Telnet, Putty

Version Control: Subversion, Star Team

Change Management: ITG, Change Management tool

Ticketing System: Clarify, Remedy, Jira

Scheduler: AppWorx, CronJob

ETL Tool: UTIL FILE, SPOOL, SQL Loader, Informatica

Applications: Oracle Applications R12, Custom Java based finance application

Communication: MS Office, Lotus Notes, Outlook, WebEx

OS: Windows 7, Windows Vista, XP, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Oracle Technical Consultant

Environment: Oracle Applications R12, Oracle 12c database

Responsibilities:

• Worked on L3(Development) form followed by L2 Support for various applications viz. I-procurement, Procure to Pay, Invoice and payments modules.
• As a part of Merger project, developed e-Invoice Conversion process to migrate last 1 year active legacy invoices to the new Oracle system.
• Designed vendor conversion and Interface, vendor address interfaces, Ariba and payday Invoice Interface using SQLLDR.
• Designed pl/sql procedure which generates output file send to bank servers (positive pay file) and print house for check printing.
• Worked on query optimization, performance tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Collect, Creation of global temporary tables.
• Worked on various small development projects as lead and developer.
• Deigned various reports using pl/sql, util file and spool.
• Understanding and Mapping Requirements to prepare the Technical design Documents (MD70).
• Worked on resolving/prioritizing change requests to modify/create Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes.
• Participate in management, minor enhancements, break fix activities, problem management and stability analysis.
• UNIX shell scripting and ftp program creation and maintenances.
• Interacted with the Data Warehouse module to load data into the remote database tables from oracle through DBLINK between the two databases.
• Prepared ER diagrams, Unit Test Plans, Migration Documents and Code Reviews.
• Interacted with the business team to discuss requirements and acted as first point of contact to business team for any changes/escalations.
• Co-ordination with various third party teams/DBA/SMEs during business impacting changes and deployments.
• Worked on Month close issues, Interface and program failures along with L2 Support team.
• Attending calls with the Business and Offshore team on daily basis for Requirement clarifications and delivery Issues.
• Periodic update about project & Defect status to project Manager.
• Involved in Deployment and Troubleshooting issues in the application.

Confidential

Oracle Plsql Developer

Environment: Custom Java applications, Oracle 11g database

Responsibilities:

• Worked on L2 Production Support, attending production calls, troubleshooting the application and resolving bugs.
• Worked on Support tickets, issues, Interface and program failures, Monitor scheduled Jobs.
• Worked on Interface and program failures, Monitor Jobs in custom financial modules.
• Interacting with Business Users, analyzing change requests, impact analysis, and implementation of the same.
• Supported Interface handling of both inbound and outbound.
• Implemented CTAS (Create Table As Select) to improve performance.
• Performance tuning of the Inbound and Outbound SQL, PL/SQL scripts to suit user needs
• Co-ordination with Development and testing team. Attending weekly calls.
• Identifying risks proactively and proposing solutions to resolve them.

Confidenti

Oracle PLSQL Developer

Environment: Oracle R12, 10g Database

Responsibilities:

• Created Tables, Views, Constraints, Index. Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL in TOAD.
• AP Vendor Conversion, AP Invoice Conversion and Interface Design.
• Understanding and Mapping Requirements to prepare the Technical design Documents.
• Preparing deliverable documents such as, Technical Design, Unit Test cases and Test results
• Tested and debugged Oracle PL/SQL packages.
• Created materialized views to enhance the performance with help of DBA.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction.
• Maintained Subversion code in accordance with company policy.
• Preparing POC (Proof Of Concepts)
• Working along with the business on the CRP and CAT phase
• Timely providing status report, Review of deliverable documents, Code review and defect prevention

Confidential

Oracle Apps Consultant

Environment: Oracle 11i

Responsibilities:

• Worked on L2 Production Support, attending production calls, troubleshooting the application and resolving bugs.
• Worked on Support tickets, issues, Interface and program failures, Monitor scheduled Jobs.
• Worked on various change requests to modify Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes.
• Worked on Interface and program failures, Monitor Jobs in custom financial modules.
• Interacting with Business Users, analyzing change requests, impact analysis, and implementation of the same
• Supported Interface handling of both inbound and outbound.
• Design/Maintenance Unix Shell Scripts to process the files daily.
• Performance tuning of the Inbound and Outbound SQL, PL/SQL scripts to suit user needs
• Co-ordination with various third party teams/DBA/SMEs during business impacting changes and deployments.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
• Attending calls with the Business and Onsite team on daily basis for Requirement clarifications and delivery Issues.
• Identifying risks proactively and proposing solutions to resolve them.

Confidential

Oracle Plsql Developer

Environment: Oracle 11i

Responsibilities:

• Responsible for the full life cycle implementation. Conducted As-Is study and developed a To-Be process with project team members to suit the company’s goals.
• GAP Analysis, Mapping the Requirements from Functional Design Document to TDD. Providing the workarounds to the GAPS identified
• Techno-Functional consulting for procure to pay business cycle.
• Developing PLSQL programs Functions, Procedures and Packages.
• Created database objects like tables, sequence, synonyms, views, Triggers, Materialized Views, db links using Oracle tools like SQL* Plus, PL/SQL and TOAD.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Coordinating with the DBA, UNIX and third party support team.
• Preparing test cases, unit & integration testing.
• Using SQL Loader for inbound interfaces in ETL. Interface to SAP Human resource system.
• Interacting with Business Users, analyzing change requests, impact analysis, and implementation of the same
• Developing the Inbound interfaces and Extraction scripts for Oracle.

Confidential

Engineer

Responsibilities:

• Worked as a Maintenance Engineer in Electrical from .
• Worked in electrical maintenance for enhancement of 132KV Switchyard.
• Worked as a maintenance area in-charge in the automation system with AC.
• Also was an internal auditor for ISO-9001 and ISO-14001.
• Worked as a Commissioning Engineer in Switchyard from for expansion project.
• Worked as a Power User in SAP Team for SAP R/3 PP,PM and MM Module
• Worked on MIS reporting.