SUMMARY

• Around 8 years of experience in the development of client/server and multi tired applications using Oracle Database, SQL and PL/SQL of different platforms like Windows NT/2000/XP, UNIX and Linux. Good knowledge of key Oracle performance - related features, such as Query Optimizer, Execution Plans, Hints, Indexes, Clusters, Partitioning, analysis, design, development, and testing of business applications in web based Client/Server architectures.
• Hands on experience in closing the tickets for the CDP/VBS application environment.
• Client interaction for the business process.
• Hands on experience in Coordinating and maintaining the Operational Readiness Review Database.
• Handling the review meetings with the work streams and stakeholders.
• Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Implementation and Post Implementation surveys.
• Good knowledge of Data Base Administration.
• Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL, DBA back end applications Development Toad, SQL Plus, PL/SQL Developer, UNIX and working knowledge of UNIX editors, Debuggers.
• Solid Experience and knowledge in ETL and Data warehousing concepts.
• Hands on experience with Data warehousing tools, Data Analysis, Data Mapping, Unit Testing, Migration, Conversions and Process Documentation.
• Experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams
• Good Knowledge in Oracle Apps 11i Technical and Functional with the modules like GL, AP, AR, I-Expenses, PO, FA, I-Supplier, Bill of Material, Work in Process, and AME.
• Strong in using tools such as PL/SQL developer, SQL developer, SQL*Loader, oracle Discoverer, TOAD and SQL*Plus.
• Experience in performance Tuning and Explain plan, SQL loader, DBMS Scheduler, Utl File, Triggers, Indexes, Import and Export utilities and Shell scripting for auto process.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records, Types, Dynamic SQL and Analytical Functions.
• Well-versed with different stages of Software Development Life Cycle (SDLC).
• Hands on experience in SQL, PL/SQL Programs, Packages, Stored Procedures, Triggers, Cursors, Dynamic SQL, SQL*Loader, SQL*Plus, UNIX Shell scripting, Performance tuning and Query Optimization.
• Experienced in Dynamic SQL, PL.SQL Collections and Exception handling.
• Extensively used PL/SQL to build Oracle Packages, stored procedures, and functions.
• Triggers, cursors, Oracle Reports 10g and views for processing data, enforcing referential integrity and needed business rules.
• Involved in database design, tuning, triggers, functions, materialized views, Oracle Job Scheduler, Oracle Advanced Queuing.
• Having knowledge in Perl Scripting.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.
• Proactively interacted with Business Analytical, technical analysts, Developers, Testers and External clients.
• Expertise in Oracle 10g and migration of Oracle Reports from 4.x/6i/9i to Oracle 10g.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, Oracle reports 10g/9i/6i, ETL, Oracle Portal, SQL, PL/SQL, SQL Server 2005.

Languages: SQL, PL/SQL, MS-SQL, C, C++, XML, HTML, CSS.

Query Tools: TOAD, PL/SQL Developer, SQL Developer, and SQL* PLUS, ETL.

GUI Tools: Oracle Forms 6i / 9i and 10g, Oracle Reports 6i/9i/10g.

Operating Systems: Windows 95/2000/XP/Vista/Windows 7, UNIX.

Other Tools: Discoverer 9i, SQL*Loader, Putty, TWS, PVCS, CYGWIN, WinSCP.

PROFESSIONAL EXPERIENCE

Confidential - Albany, NY

Oracle Developer

Responsibilities:

• Played the role in understanding the user requirement for Regional Office and how it is related to existing NYSE-CON project.
• Played the role in designing Data model.
• Working for the development of Regional Office in the NYSECON - DOH.
• Work with the Data Base Specialist and Technical Architect on the design work of the application.
• Creating database object like package, function, procedures
• Responsible for moving the source code to Production.
• Involved in gathering the requirements, Documenting and Review from the work streams & performance teams.
• Involved in activity of diagrams for the complete flow of this application.
• Involved in the mock up design work with the Java Architect and Analyst for the UI.
• Responsible for moving the source code to UAT.
• Responsible for installation of Oracle software on Windows.
• Other duties as assigned.

Environment: s: Oracle 11g, SQL Developer 4.0, Windows 7.

Confidential - Lafayette, IN

Oracle Developer

Responsibilities:

• Analyze, design, implement and test ad-hoc and standard reports using University Development systems.
• Work with customers, which include Development Officers, Purdue Alumni Association and the Development Senior Team, to provide timely, accurate, consistent and meaningful data utilizing a variety of reporting tools.
• Develop special reports using SQL, PL/SQL, Cognos Reporting Suite and other Business Intelligence tools (e.g. Advizor) as necessary.
• Create highly complex prompted reports, troubleshoot, and fix reports.
• Provide report content for ‎‎approval and submission to outside entities that include Council for Aid to Education (CAE), Council for Advancement & Support of Education (CASE) and other publications.
• Design and model data projects and partner with IT Enterprise Applications to create reporting structures.
• Work with programmer analysts in IT Enterprise Applications and the Systems Administration team to assist in testing system changes.
• Prepare major annual reports and assist in special reporting projects both internally and externally.
• Create and maintain report documentation.
• Interact with clients to understand reporting needs and assist in optimizing outcomes.
• Analyzing requests for information and recommend standard or best practice report formats.
• Provide reports as necessary for various customers (Development Officers, Purdue Alumni Association and Development Senior Team).
• Direct internal customers to existing report tools whenever possible to meet reporting needs.
• Assist the Assistant Director of Advancement Information Systems as assigned on special projects and/or fulfilling special ‎customer ‎needs.

Environment: s: Oracle 10g, PL/SQL Developer 10.0.2, Windows 7.

Confidential - Cincinnati, OH

Sr. PLSQL Developer

Responsibilities:

• Working for development of Confidential bank credit card points system.
• Creating database object like package, function, procedure loading table through Sql-loader.
• Create a staging table and staging table history and a control file.
• Created packages to validate and load data from Confidential into the database.
• Developed ETL programs using Informatica to implement the business requirements.
• Writing business logics to insert into database from staging tables running it from shell scripts.
• Reviewed the logical model with application developers, DBAs and testing team to provide information about the data model and business requirements.
• Created packages to extract the data from database into text filesto send themto Confidential .
• Used bulk collect and bulk bind for improved results for both extraction as well as load.
• Used utl file utility in order to load and to insert the extracted data in text file.
• Responsible for moving the source code to UAT.
• Involved in Debugging and resolving the problem.

Environment: s: Oracle 10g, PL/SQL Developer 9.0, Putty 0.62, Windows 7, SQL*Plus, UNIX.

Confidential - Rochester, NY

Sr. PLSQL Developer

Responsibilities:

• Analysis of business requirements and major developments.
• Involved in gathering the requirements, Documenting and Review from the CDB/VBS. Teams from offshore and onshore.
• Handling the CDB database completely.
• Responsible for moving the source code to Production.
• Involved in Production Changes is the major part.
• Scheduled review & status updates meetings with the stake holders and off shore team.
• Scheduled XMX/IMM meetings weekly and MOM process monthly.
• Based on the feedback, small enhancements have been implemented into the CDB/VBS.
• Used XMS application
• Involved in resolving the problem and requesting a solution in Problem Management and Change Management using MKS.
• Lead experience with the offshore and onsite from India Development team.
• Worked with Oracle Business Object Developers in planning sessions with PM, BA and team members to analyze business requirements.
• Worked with Test Environment Management team in solving the raised issues.
• Supported developers for efficient SQL query and performance.
• Created, maintained the Contract Database as per the required schedule dates and get the approvals before moving to production.
• Given transition to the new project mates.

Environment: s: Oracle 10g, SQL Developer 3.1, Putty 0.62, RCS, Windows 7, SQL*Plus, MY SQL, UNIX, Forms & Reports10g, Citrix, MKS.

Confidential, MN

Tech Lead/Project Coordinator

Responsibilities:

• Maintaining the Operation Readiness Review database for the LVTS.
• Analysis of business requirements and major developments.
• Involved in gathering the requirements, Documenting and Review from the SLM’s, work streams & performance testing teams.
• Handling the ORR database completely.
• Responsible for moving the source code to Production.
• Involved in Pre-Production Changes that are part of a Pre-Production Environment.
• Scheduled review & status updates meetings with the stake holders and off shore team.
• Based on the feedback, small enhancements have been implemented into the ORR database.
• Involved in resolving the problem and requesting a solution in Problem Management and Change Management.
• Created ManageNow id’s as per the requirement.
• Lead experience with the offshore and onsite from India/ China Development team.
• Worked with Oracle Business Object Developers in planning sessions with PM, BA and team members to analyze business requirements.
• Worked with Test Environment Management team in solving the raised issues.
• Supported developers for efficient SQL query and performance.
• I am involved in developing Oracle Reports; maintain the database using PL/SQL.
• Created the Environment Tasks Plan for Monitoring, Readiness, DR setup & other tasks.
• Created the Batch jobs using TWS.
• Involved in writing the shell scripts for checking the web, application provided production support and played a major role in debugging errors during implementation and deployment.
• Given transition to the new project mates.

Environment: Oracle 10g, ORR database, GIM Application, TWS, SQL & PL/SQL Development, Forms & Report, Dynamic SQL, SQL*Loader, Oracle SQL Developer, UNIX Shell Scripting and Windows XP.

Confidential

PLSQL Developer

Responsibilities:

• Developing the Oracle reports based on the project requirements.
• Conducting the unit testing and performance testing on the reports.
• Experience in Oracle Backend programming in SQL and PL/SQL, Procedures, functions, triggers and packages in Oracle database server and also for Oracle Application Server using PL/SQL.
• Wrote DDL Scripts to create new database objects like tables, views, sequences, synonyms, and indexes.
• Created Materialized views and Materialized view logs.
• Wrote extensive Exception handling procedures to handle exceptions.
• Generated monthly reports in different formats like tabular, form and matrix using Oracle Reports.
• Created LOV’s for data elements in Oracle Forms.
• Created Master/Detail forms.
• Wrote SQL scripts to perform Back End testing of the Oracle database using SQL.
• Involved in writing Unit Test Cases and Test Scripts for Manual Testing from Use Cases.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Attended Design meetings, code review and test review meetings.
• Data loading from other databases and text files into Oracle Database using SQL*LOADER.
• Extensive experience in loading high volume data and Performance tuning.
• Experience in Performance Tuning using various types of Hints, Partitioning and Indexes.
• Expertise in handling errors using Exceptions.
• Attended Design meetings, code review and test review meetings.
• Attended meetings and review to discuss current issues and processes to tackle issues.
• Worked as a Developer, did requirement analysis, design, developed (Oracle - PL/SQL), tested and implemented and provided infant care on production.
• Gathered the requirement from the client and translated the business design into technical design.
• Involved in creating Procedures, Functions, Packages, and Triggers. Creating reports using Reports 6i.
• Extensively involved in writing SQL queries (sub queries and join conditions) for generating complex reports.
• Involved in the development of UNIX shell scripts.
• Performed tuning of the SQL queries using Explain Plan.

Environment: Oracle 9i, SQL & PL/SQL Development, Oracle Forms and Reports 6i, HTML & CSS, Windows 98/2000/XP.