SUMMARY:

• Around 9 years of hands on experience in systems Analysis, design and development of complex software systems majorly on Oracle Database.
• Technical and analytical expert in execution of projects based on retail domain working wif Oracle Retail applications and Oracle database.
• Worked in both teh environments of Development and Production Support as a Developer and Lead working in Retail Management Systems, Pro*c, PL/SQL, Crystal Reports, Toad, Performance tuning and Testing.
• Extensive experience in Design, Development, Enhancement and Maintaining applications in Oracle 9i/10g/11g using SQL, PL/SQL in Windows and UNIX environments.
• Expertise in creating and modifying database Triggers, Stored Procedures, Packages, Functions, and Indexes. Strong noledge in Oracle cursor management and exception handling.
• Developed ER Diagrams, Data flow diagrams based on teh requirement. Developed SQL scripts to create database objects like tables, views and sequences.
• Developed complex SQL queries for reports using Crystal Reports Xi. Developed complex triggers in reports before/after for validation of user input.
• Performed unit testing and supported integration testing and end user testing. Extensively worked on production issues wif effective defect management.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN and DBMS PROFILER.
• Worked on DML, DDL, and TCL operations. Extensive experience in Database query tuning, Performance tuning of Reports and troubleshooting Oracle Application issues on OLTP systems.
• Strong noledge of system development life cycle, data models, dataflow diagrams, methodologies, E - R relationship and Normalization
• Excellent Knowledge of Business Intelligence and Data Warehousing Concepts.
• Excellent understanding of Software Quality Assurance techniques and complete noledge of teh Software Development Life Cycle (SDLC), which include Analysis, Design, Development and Testing.
• Earned reputation for meeting deadlines and delivering critical solutions for Client/Server applications on Windows and UNIX environment.
• Excellent analytical and interpersonal skills wif strong communication skills.
• Adroit at learning new concepts quickly and working well under pressure.
• Diligent worker, self-starter and consistent performer.

TECHNICAL SKILLS:

Languages: C, C++, SQL, PL/SQL, Pro*C, ETL, Shell Scripting, PHP, Python, JAVA

Databases: Oracle 11g/10g/9i, MSSQL, MYSQL, MongoDB

Tools: TOAD, Crystal Reports Xi, Visual Source Safe, Microsoft Excel, Microsoft PowerPoint, MS Word

Web Technologies: HTML, XML, CSS, JavaScript, JSON

Retail Mgmt Systems: RMS (Oracle Retail Merchandising System)

RCOM: (Oracle Retail Customer Order Management)

Environment: WINDOWS, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Bedford, MA

Oracle Developer

Environment: Oracle 11g, PL/SQL, TOAD, SQL Developer, UNIX, Shell scripting, SQL*loader, Stored Procedures/Triggers

Responsibilities:

• Gathering teh functional requirements from users and converting them into technical requirements. Actively involved wif DBA in migrating teh Oracle 9i database on Windows NT platform to Oracle 11g and deployment of objects to production environment.
• Migrating PL/SQL Code from Oracle 9i to 11g and implementing Object types.
• Creating database packages, procedures, functions, triggers, views, materialized views using Oracle PL/SQL.
• Analyzing performance of database objects and suggesting DBA for Indexes, schema gathering, partitioning, Explain Plan, TKPROF.
• Performance tuning through analyzing query plans and query tuning, partitioning, optimizer hints.
• Used SQL* Loader and export/import mechanism for data migration for bulk upload.
• Implementing PL/SQL to perform application security and batch job scheduling using UNIX shell scripts for data files handling, FTP and executing teh SQL*Loader.
• Performing thorough Unit testing, System Testing and User Acceptance Testing in development environment for teh result of error free and smooth migration process and provided quality work for functional users.
• Generating various reports on PL/SQL wif output format in Excel/Pdf/Html.
• Worked on production support and future releases of software.
• Performed query tuning to bring out teh best performance as per teh business requirement.
• Tuning COMPLEX PL/SQL codes for high performance using Explain Plan and SQL Trace.
• Used ORACLE FORMS and REPORTS to generate reports for teh business users.

Confidential, Keene, NH

Oracle Developer

Environment: Oracle 10g, UNIX, Oracle Enterprise Manager, VSS, SQL*Loader, Toad Data Modeler, Shell Scripting, Pro*C, RMS

Responsibilities:

• Analyzing teh existing code and optimizing and enhancing teh existing procedures and SQL statements for better performance.
• Importing data from flat files and Excel sheets to Oracle using SQL* Loader.
• Developing of PL\SQL scripts and Pro*C programs for RMS batch programs.
• Global Technical Architecture Design for Enterprise Data Warehouse.
• Designing teh forms for various modules.
• Creating weekly, monthly and quarterly reports.
• Involved in monthly production support and batch job processing and troubleshooting teh problems in PL/SQL and Pro*C.
• Creating dynamic SQL queries using Execute Immediate statements.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools/utilities like Explain plan, DBMS Profiler, Auto*Trace, SQL Trace, TKPROF etc.
• Extensively used hints to direct teh optimizer to choose an optimum query execution plan.
• Expertise in debugging teh code and creating teh exceptions to handle bad data and send them to error log files.
• Used various control structures like Case, Decode, IF-Then-Else, For Loop, While Loops while developing procedures, used SQL Joins.
• Extensively worked using autonomous transaction and triggers to keep teh track of DML operations.
• Processed data using both implicit cursor and explicit cursor.
• Used Records and Collections extensively in Packages in order to improve teh package performance.
• Performed Unit Testing on teh developed code to ensure it is bug free.

Confidential

Oracle Application and Database Developer

Environment: Oracle 9i, PL/SQL, Oracle Forms and Reports, Pro*C, TOAD, RMS, RPM, Shell Scripts

Responsibilities:

• Coordinating wif teh functional designer and discussing teh client's business requirements.
• Responsible for designing Pro*C and PL/SQL modules dat will interface RPM to RMS and RMS to other legacy system.
• Analyze teh existing code and make new enhancements as per customer’s new request.
• Creating and formulating PL/SQL functions and procedures.
• Performance tuning, resolving system performance issues and providing user privilege maintenance.
• Administering, configuring and troubleshooting teh Oracle Retail batch schedule via teh Control-M scheduler, including job/thread restarts and parallel tuning.
• Review and testing of all offshore deliverables.
• Assisting staff wif best practices and protection plans and recommending performance improvement techniques.

Confidential, Bangalore, IN

Oracle Production Support Analyst and Coordinator

Environment: RMS, RPM, UNIX, Oracle, TOAD, Pro*C, RETL, Shell Scripts

Responsibilities:

• Production support for interface batch programs written in Pro*C or RETL (Extract Transform Load Codes) for Oracle Retail Merchandising System (RMS).
• Production support for Oracle Retail Price Management (RPM) batch programs written in Pro*C or RETL.
• Handling Severity -1 issues on database servers, application servers and providing production support.
• Defect analysis for batch failures.
• Providing possible solution for issue resolution.
• Interacting wif teh user to make them aware of teh issue.
• Knowledge transfer to new team members.
• Training new members on Oracle Retail Merchandising System (RMS).
• Preparing documents for better understanding of teh functions of Oracle Retail Merchandising System (RMS).

Confidential, Bangalore, IN

Oracle Reports Developer

Environment: RMS, RCOM, RMM, RDW, ReSA, Crystal Reports Xi, Oracle, SQL, PL/SQL

Responsibilities:

• Analyzing teh requirements sent by teh client and giving correct solutions.
• Developing new reports of high quality, performance and standards using SQL queries and Crystal Reports Xi.
• Changing old reports based on teh new requirements.
• Defect analysis and fixing in case of report failure.
• Performance tuning SQL queries of slow running reports.
• Creating stored procedures and triggers.
• Reviewing teh reports developed by teh developers and ensuring correctness based on teh requirement and adherence to standards.
• Configuration management and maintenance of project related documents.
• Helping teh team members wif technical and domain related issues.
• Guiding teh team members throughout analysis, coding, reviewing and delivery process.
• Training new members on Oracle Retail Customer Order Management (RCOM).
• Preparing documents for better understanding of teh functions of Oracle Retail Customer Order Management (RCOM).

Confidential

Oracle Retail Application and Database Test Engineer

Environment: RMS, RCOM, RMM, RDW, ReSA, Oracle, TOAD, SQL

Responsibilities:

• Writing test plan, setting up test data and execution of test cases.
• Database testing by writing SQL queries to extract data and check its correctness.
• Defect reporting to onsite counterparts.
• Performing functional testing, interface testing, system testing of RMS and RCOMM.
• Performing patch testing and regression testing on new version of teh RMS and RCOMM released after teh defect fix.
• Executing batch programs for ReSA using Shell Scripts.As a Senior Test Engineer
• Guiding teh team on test case preparation and test execution.
• Interaction wif onsite counterparts to facilitate smooth implementation.
• Training teh new team members on RMS, RCOMM and ReSA and test methods.
• Preparing documents for better understanding of teh functions of Oracle Retail Sales Audit (ReSA).