SUMMARY:

• Over 7+ years of IT experience in Analysis, Design, Development, Implementation and support Of RDBMS in Production, Development and Test environments using Oracle Tools in client server environments.
• Involved in entire life cycle of implementation (SDLC) from business analysis to final deployment and testing.
• Experience in using Oracle related tools like SQL * Loader, PLSQL Developer and SQL Developer
• Experience in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Object types and Collections.
• Coded test packages and performed unit testing of PLSQL code using PLSQL framework and the SQL Developer unit testing package.
• Experience with Views, Materialized views, Cursors (Implicit and Explicit), Ref Cursors, and External tables, table partitioning, Index partitioning and nested loops, Advanced PLSQL.
• Extensive working knowledge on SQL Loader control programs, and PL/SQL validation scripts to transfer flat file data into oracle database tables
• Good understanding of Data mining concepts, ETL Processes and Data modeling concepts such as Design of the Dataflow, ER Diagrams, UML, Use Cases, Normalization and De - normalization of Tables
• Advanced skills in Oracle database programming using PL/SQL (Stored Procedures, Functions, Packages and Triggers), standard built-in Oracle packages
• Strong technical expertise in UTL FILE, DBMS SQL, DBMS OUPUT, DBMS UTILITY, DBMS JOBS packages.
• Experience in SQL or server level tuning using Explain Plan, TKPROF, STATSPACK Extensively used Cursors, Composite data type and Collections in writing the backend PL/SQL code
• Excellent analytical skills, logical reasoning, interpersonal skills, problem solving skills and communication skills
• Requirement Study, high level design, low-level design, Coding, Testing, Quality assurance Documentation, Implementation and Project Planning.
• Results oriented, with an ability to work with aggressive time lines for any assignment to successful completion within the established project schedule and budgetary constraints.
• Strong management, administrative and leadership skills while working in a team.

TECHNICAL SKILLS:

Programming Languages: Oracle PL/SQL, SQL

RDBMS Databases: Oracle 11g, 10g, 9i

Documentation: Business Requirements Document (BRD), Functional Requirements Document, Technical Specification Document, Functional Setup Document, Test Cases(TE050)

Developer Tools: PLSQL Developer, SQL Developer, JDeveloper, HP Quality Center

Client Operating Systems: Windows XP/Windows-7,8 and CentOS 5.4- 6.5

UNIX Server Environments: IBM AIX, Sun’s Solaris and Red Hat Enterprise Linux

Office Tools: MS PowerPoint, MS Word, MS Excel

PROFESSIONAL EXPERIENCE:

Confidential, Schenectady, NY

Oracle PL/SQL Developer

Responsibilities:

• Confidential has launched this transformation initiative to re-imagine, simplify and migrate its existing OTM SCM Management business processes in alignment with common global solution footprint adopted across all location.
• The focus is to design, configure, build, and deploy new Renewables platform for smoother and enriched business solution.
• Transformed and cleaned up the data from disparate schemas based on the mapping documents provided by the business owners. Loaded the data into the target tables to adhere to the business rules.
• Performed data modeling to create one to many and one to one relationships between various database objects based on the business rules.
• Extensively utilized various character, number, date and conversion functions.
• Created PL/SQL procedure to write out a shell script in order to run into the SQL*loader tool. This was achieved through the use of the built in UTL FILE package.
• Unit testing of the PLSQL code. Identified various test cases, built test packages and ran the unit tests to verify the PLSQL procedures and functions.
• Built SQL queries using the data dictionary that would provide insight into a table’s structure and its foreign key and primary key relations.
• Also used the data dictionary to view the source code and also get information about various database objects.
• Further wrote PL/SQL programs that migrated data from a data warehouse database server to the data mart server while adhering to business rules.
• Mentored junior interns and provided technical assistance. Conducted code review and suggested changes to improve the code readability and maintainability.
• Implemented performance tuning on the SQL statements to optimize the cost and cardinality of the query. Avoided full table scans through judicious and careful use of indexes.
• Reviewed the outer joins that were written by the team to make sure they didn’t adversely affect the performance of the query.
• Rewrote some cumbersome queries on older Oracle 10g to use newer features of Oracle 11g
• Loaded data from different sources into the temporary data backup environment using SQL Loader
• Conducted testing of load procedures and packages to make sure that the business rules were correctly implemented.
• Helped junior developers with debugging their code when they were facing problems identifying where the load logic was breaking which lead to missing or erroneous data being loaded.
• Called the Procedures/Functions in separate audit packages in order to calculate event timestamps, various errors that were occurring along with their codes.
• Analyzed the audit log and audit error tables to identify occurring errors and rectify them through debugging.
• Involved in creating system documentation such as Technical Specification, Unit Test Plan, and Data Flow Diagram using MS-Word.
• Leading Implementation and Development as per requests raised by business

Environment: SQL, Oracle 11g, PL SQL Developer, PL/SQL, SQL* LOADER, Reports 6i, UNIX

Confidential, Wilmington, DE

Oracle PL/SQL Developer

Responsibilities:

• CLAS (Credit Life Administration System) is an integrated credit life policy administration system which includes Insurance Management System, Re-insurance, Financial Services and Reporting. In general CLAS provides insurance to the customer having loan from the financial institute, banks etc. dealing with MetLife as client. Financial institutes send customer information files to MetLife and depending upon this information policy creation, claim registration and payment are made using CLAS Application.
• Working as Onsite Project coordinator and Overall Code remediation Lead for this engagement.
• Involved in requirements gathering, analysis, design, development, testing and deployment.
• Interact with business users and translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Involved in critical conversion Components.
• Identifying reusability/Changes in existing integrations flow from customer Data to Downstream Systems and highlight gaps if any by working closely with the team.
• Involved in developing enhancement components using Oracle PLSQL.
• Involved in creating stored procedures, functions, migration scripts.
• Involved in developing reports.
• Experienced in performance tuning and query optimization.
• Thoroughly reviewing the code developed by the team to provide best possible standards
• Prepared the test plans and executed test cases for unit, integration and system testing.
• Managing the configuration and controlling the versions using SVN
• Involved in production issues and support.
• Actively involved in optimization and tuning of SQL queries through utilizing the explain plan to find out the problem area of the query.
• Also performed optimization of PLSQL procedures. Resolved cursors of huge cost through proper used of splitting into parameterized cursors and then used inner loops to perform the needed operation much quicker.
• Extensively used SQL LOADER to load data into the target tables. Wrote control files based on the both positional mapping and for comma separated or tilde separated values.
• Provided support for the reporting team which was using crystal reports on the database. Analyzed and corrected the SQL queries to give the expected values.
• Created VIEWS in order to support the reporting team and the BI team. Performed tuning of views and resolved cross joins that occurred and held up the BI team.
• Extensively worked with the BA and QA team to fix the defects that were logged through testing.

Environment: SQL, Oracle 11g, PL SQL Developer, PL/SQL, SQL* LOADER, UNIX

Confidential, Whippany NJ

Oracle PLSQL Developer

Responsibilities:

• Involved in development of an online banking application, which enables the bank's customers to access their various accounts through the Internet.
• The application also allowed the users to submit account related queries to the bank including, ordering checks, requesting copies of checks and statements, etc
• Responsible for Study, Analysis, Design, Development/Customization and Testing/Debugging of the application
• Designed and developed master tables, views, sequences and synonyms
• Developed various Complex Queries, Views for Generating Reports
• Written control files to load data into staging tables and DW tables
• Involved in Unit testing PL/ SQL Stored Procedures and Functions.
• Prepared final design documents and general instruction to follow during development.
• Performed the uploading and downloading flat files from UNIX server using FTP
• Fine-tuned the SQL queries using Explain Plan and applying appropriate hints and indexes
• Analysis of customer reported issues, which could be a code issues, Data fix issues, performance issues, setup issues, functional issues or an RDBMS issue.
• Effective Interaction with Support and other Application groups through on call for high priority issues
• Tuned SQL queries using Explain Plan, Analyze, Hints utilities to improve performance.
• Involved in writing data Migration scripts/create table scripts to load data successfully from old schema to new structured schema

Confidential

PL/SQL Developer/Analyst

Responsibilities:

• Confidential is one of the leading Nationalized Banks of India with over 2500 branches all over India. Core Banking Solution has been implemented in Confidential to manage their retail banking operations centrally.
• Involved in all stage of system Development Life Cycle (SDLC): Scoping, Analysis, Design, Construction and testing
• Worked very closely with Business Analyst and Participated in business process evaluation/improvement activities
• Created Technical Design documents for major developments and attended Technical Design Reviews
• Designed and developed database stored procedure, package, functions and triggers
• Performed data modeling including reverse engineering using the Toad Data Modeling tool
• Loaded data in base tables from temporary tables using BULK COLLECT in stored procedure
• Used PL/SQL tables, array structures as a part of oracle collections
• Involved in data Integration send/load received data from different source
• Tuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization
• Working closely with quantitative analysts in a highly fast-paced environment to fix production issues and provide enhancements as per requirements

Environment: SQL, Oracle 11g, PL SQL Developer, PL/SQL, SQL* LOADER, UNIX

Confidential

Technical Developer and Analyst

Responsibilities:

• Confidential, a subsidiary of Panasonic is a leading manufacturer of wires and cables catering to the need of domestic as well as industrial needs in India.
• This project involved implementation of a full Oracle e-business suite focusing on financials, supply chain and projects..
• Documenting the Functional Requirement Specification Document and technical design document that would help any person in understanding the technical design end to end based on the Business Requirements and Solution Design.
• Develop the codes in Pl/SQL packages, procedures, functions, Forms, Reports.
• Developing/enhancing interfaces, Form Personalization, OAF using JDeveloper.
• Document technical Specifications(MD200)
• Preparing setup Documents (BR100/BR110) and perform setup accordingly.
• Extracting test cases from the understanding of the Business Requirement and the components. During implementation of test plan, test scenarios are identified & accordingly test cases are generated with the help of Testify tool.
• Prepare Test Documents and upload the same to Quality Center.
• Building up the new setups and functional changes or to align the gaps in the existing setups as per the business requirements.
• Product Testing (Functionality, Usability, Compatibility, Integration etc.)
• Performed Unit testing and System Integration Testing on all the developed components before start of SIT and traced out the defects at the earliest phase.
• Provide Support to the Users during UAT.
• Providing cutover support before every SIT and Production Go-Live(Raising tickets, supporting DBA for code movement, doing functional setups and performing sanity checks) to ensure a smooth and hassle free cutover.
• Involved in the change management group for supporting the implementation of the change request.

Environment: Oracle Apps 11i, SQL, Oracle 11g, PL SQL Developer, PL/SQL, SQL* LOADER, UNIX, Reports 6i