SUMMARY

• Around 10 Years of experience in analysis, design, development and implementation as SQL/PLSQL Developer working on Oracle 9i/10g/11g platforms.
• Strong team player with excellent communication skills.
• Extensive knowledge on PL/SQL components like Procedures, Functions, Cursors, Packages, Triggers and other features such as VARRAYS, Nested Tables, Index by tables, Bulk Collections, Database Triggers using features like Cursors, Collections, Exception Handling and Bulk binding.
• Very strong in full suite of Oracle Tools PL/SQL, SQL* Loader etc.
• Good experience in Business object XIR2 reporting tool along with strong knowledge in Crystal report.
• Experience with oracle and other utilities like PLSQL developer, SQL Navigator and Toad.
• Strong skills in developing applications using Oracle RDBMS 10g/9i and developing reports using reporting tool.
• Experienced in loading data into Oracle Database using Data Loader and SQL*Loader.
• Very proficient in SQL tuning and optimization of queries.
• Strong experience in database designing, database development, enhancement, migration projects.
• Hands on experience working on UNIX platforms in developing shell scripts.
• Proficient in Oracle Tools and Utilities such as TOAD, SQL Plus.
• Experience in Designing and developing reports using BI/BO/crystal report Publisher.
• Experience in working with Oracle Utilities like SQL*Loader, UTL FILE Package and Interfaces.
• Proficient in preparing technical documents based upon user requirement.
• Have strong experience in Leading the team and handling production issues in crisis.

TECHNICAL SKILLS

Data Bases: Oracle 11g/10g, Oracle 9i, Oracle 8i

Oracle Tools: SQL Developer, PLSQL Developer, SQL Navigator, TOAD

Documentation: Small work document (SMW), Test design document TDD

Code Control Tools: CVS, VSS

Languages: Oracle, SQL, PL/SQL, Unix Shell Scripting, Crystal report, BUSINESS OBJECT XIR2

Office Tools: MS Office, MS Project

Development Tools: SQL*Plus, Enterprise Manager (Import/Export)

PROFESSIONAL EXPERIENCE

Confidential, New Britain, CT

PL/SQL Developer

Environment: Oracle 11g/10g, Windows 2008/XP, PL/SQL, SQL*PLUS, TOAD 9.6, SQL Developer, SQL*Loader,UNIX,MS SQL SERVER2005/2008,Erwin, Crystal Reports,MS Outlook 2000/2003, MS Communicator, Oracle Forms10g, Oracle Reports 10g,Report Studio,SQL Navigator.

Responsibilities:

• Participated in phases of development like System Analysis, Design, Coding, Development and Implementation and provide support to existing client databases.
• Extensively used feature of oracle 10g in data pump utilities (EXPDP/IMPDP) for copying of data from development server to test and production server.
• Developed backend processes using SQL, PL/SQL and dynamic SQL to create oracle objects, stored procedures, packages, and triggers.
• Profoundly worked with high - performance PL/SQL features such as REF Cursor, Composite Data Types such as Records, Collections, Bulk Collect and Autonomous Transactions.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, V arrays, Records, Materialized views, Dynamic SQL.
• Developed scripts to migrate data from flat files to target tables performing required validations on the data using ETL.
• Developed interfaces/screens using Forms10g for the users and used Triggers to validate the data.
• Used Explain plan and auto-trace for tuning the SQL and Generated session level trace and used the TKPROF utility to get the report for the trace file.
• Performed SQL tuning to prevent performance issues from impacting production and end users.
• Developed Reports using Reports10g (Creating EUL, Business Areas, Privileges, Administration functionalities, Reports through User Edition).
• Generated Dashboard report, List Reports, Cross Tab Reports and Drill through reports using Report Studio
• Personalized standard reports and forms according to business requirements, using Oracle Forms and Reports.
• Documented all the processes involved in project for future reference.

Confidential, Alpharetta

Tech Lead and Senior Oracle PL/SQL Developer

Responsibilities:

• Involved in gathering requirements from business users, analysis and system design.
• Created and managed data base objects such as Tables, Views, Indexes, Sequences, and Synonyms, procedures, packages.
• Created the PL/SQL packages, procedures, functions applying the business logic to load the data to relevant tables.
• Extensively worked in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Worked in preparing functional document, user document, process flow diagram and flow chart.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Loading with SQL Loader and to base table with interface programs.
• Involved in Extraction, Transformation and Loading (ETL) of the data in the table for Oracle database.
• Developed multiple views using Ref Cursor for reporting purposes on Order management system.
• Created logical and physical database objects - tables, indexes, referential integrity constraints, and Triggers to development needs.
• Worked for Performance tuning.
• Worked on table partitioning (Range and List) and deploying various methods of indexing like local indexes and global indexes on portioned tables.
• Used version control tools VSS/CVS to checking the scripts.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Review of the Technical Designs and Codes.
• Participated in meetings with business users to understand and explain Data requirements.
• Interacted daily with business users and functional resource to gather requirements for dashboard.
• Worked to create Unix shell script for loading data from flat files to Oracle tables.
• Hands on experience in scheduling batch jobs in unix CRONTABS.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application for Oracle procedures as well as Unix scripts.
• Also worked on Migration from Unix to Linux for cloud environment, tested Linux scripts after migration.
• Aware of Golden gate data synchronization process.
• Created Deployment scripts to deploy changes in production environment.

Environment: Oracle 11g, Oracle 10g, flat files, SQL Developer, TOAD, UNIX,LINUX, Windows XP,SQL Loader

Confidential, San Jose, CA

Oracle PL/SQL Developer

Environment: Oracle10g/9iAS, Oracle OEM, Perl 5.1,Oracle Developer 9i, SQL * PLUS, MS-SQL SERVER 2005, Toad 9.6, JAVA,PL/SQL, MS-Visio,HTML, Power Builder 8.03,XML, Developer, ERWIN Unix Shell Scripts, SQL Loader and Crystal reporting, Oracle Forms 10g,6i,Oracle reports 10g,6i.

Responsibilities:

• Gathered requirement from the business users, prepared functional specification and design documents.
• Involved in the design of logical and physical data model of the components.
• Wrote complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse.
• Developed a PowerBuilder application framework and several applications to manage the security and code tables for Oracle database.
• Wrote a PowerBuilder application to track the investments of their executives in a SQL Server database.
• Created Indexes and partitioned the tables to improve the performance of the query.
• Created custom triggers for the validation of input data and to implement business rules.
• Created Ms Access ODBC connection Strings, functions to connect to the oracle database and execute the procedure from the access front end.
• Created Packages, Procedures and Functions that extensively used PL/SQL cursors, user defined object types and exception handling.
• Migration of the existing SQL Server procedures, function and Views into Oracles PL/SQL Packages, Procedures, Functions and views to calculate the manufacturing cost.
• Used SQL trace facility and TK PROF along with Explain Plan and Partitioning to accurately assess the efficiency of the SQL statements when the application runs.
• Generated various timely based Reports and also modified the discrete job data Reports to add custom fields, and altered layouts as per client requirements using Oracle Reports
• Developed necessary Forms based on the business requirements and customized the existing forms using Oracle Forms.
• Used UML and MS-Visio to create data model diagrams.
• Prepared the technical documentation and user support documents.
• Analyzed and designed UML model using ERWIM to reflect existing business models.

Confidential

Business System Analyst

Responsibilities:

• Performed the AS-IS analysis of business processes through discussions with business users and process owners
• Performed Gap Analysis and prepared Functional Specifications for the various Gaps identified
• Contribute to solution development to meet business objectives
• Coordinating Internal Team Meetings.
• Conducting Regular team meeting and process improvement meeting
• Preparation of Functional Test Specification
• Functional Testing of components.
• Provide Active Support to the Client during User Acceptance Testing (UAT)
• Prepare all necessary documentation, e.g. AS-IS, TO-BE, Set-Up Documents, Test Scripts, Functional Specification, Training Manual, CRP and SIT presentations, etc
• Co-ordination with client and stakeholders
• Organizing internal team meeting to finalize the deadline of the delivery where all the requirements would have been implemented.
• Preparing the DP (Defect Prevention) checklist against which the deliverable were reviewed to avert defects.
• To deliver the products of Good Qualities.
• To meet the Client Deliveries
• Perform internal Audits and Quality Checks.
• Analysis and determination of the severity of an incident
• Analysis and resolution of incidents in various systems supported in TFS
• User Support- Resolving all the queries or problems raised by the user during their activities
• Coordination between on-site and offshore team and delegating work to Off-Shore
• Prepare project status report (Summery) top management
• Progress Tracking
• Communicating to the Business about any change, outages, notifications etc.
• Coordinating with Application and Functional Teams for early and effective resolution to incidents
• Co-ordination with client and stakeholders
• Perform system testing.

Environment: SQL, PL/SQL, Oracle 9i database, DB2, Siebel Analytics, Webcat, RPD, Toad,Windows 98/2000/XP, LINUX, UNIX, MVS, OS-390, Windows XP based PC and Sun Server.