SUMMARY

• 6 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS)
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines
• Proficient in database modelling, Data extraction and storage logic building, Convert the business requirement into technical solutions
• Hands on experience in cross - platform migrations from non-Oracle Databases to Oracle Exadata
• Knowledge in C/C++, Pro*C using Pointer, Structures, Macros, Functions
• Knowledge in creating new C/C++, Pro*C Batch Programs with embedded SQL’s, Pl/Sql Procedure calls, Arrays and Dynamic SQL..
• Database migrations from commodity server to Exadata server using various tools like Export data pump (Expdp) and Import data pump (Impdp), cross platform TTS.
• Configured and designed Disaster Recovery systems and implemented the Oracle active data guard on the oracle 12C on Exadata. Configured and managed the storage space on Exadata ASM configured and monitored the storage performance.
• Configured production and standby Database for Oracle Exadata with OLTP using customized shell scripts .
• Experience in gathering, analyzing and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Expertise in Client-Server application development on database versions Oracle 11g/10g/9i/8i, Using PLSQL Developer, SQL *PLUS, TOAD and SQL*Developer
• Good knowledge on logical and physical Data Modelling using normalizing Techniques
• Proficient in writing Stored Procedures, Functions, Packages and Triggers using PL/SQL
• Enforcing security by creating roles, granting system and object privileges on the tables, stored procedures
• Proficient in Oracle Data base design with relational models and very good experience in entity and attribute identification and developing the Entity-Relationships
• Expertise in Oracle distributed query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF and Hints provided by oracle
• Expertise in using Oracle PL/SQL Collections, Bulking techniques, Analytical Functions, Hierarchical Queries, Partition utilization to increase performance
• Automating data loading, extraction, reports generation using UNIX Shell scripting
• Efficient in Optimizing, Debugging and testing SQL queries, views and stored procedures written in Oracle and SQL Server
• Good knowledge of Oracle performance related features such as Query Optimizer, Execution Plans &Indexes
• Knowledge of Database Architecture for OLAP and OLTP Applications, Database designing, Data Migration, Data Warehousing Concepts with emphasis on ETL
• Actively involved in capacity planning, creating views, materialized views, partitioning tables and creating indexes etc for optimization process
• Utilized various Oracle Utilities like UTL FILE, SQL*LOADER, BULK Techniques, EXTERNAL TABLES for efficient data migration
• Well versed with various DBMS utilities like DBMS SCHEDULER, DBMS XML, DBMS PROFILER, DBMS SQL etc

TECHNICAL SKILLS

Database: Oracle 8i/9i/10g/11g, 12c,SQL Server, Exadata

Oracle & BI Tools: Reports Builder 6i/9i/10g, Forms Builder 6i/9i/10g/11g, MARS, Business Objects 4.0/XI 3.1/XI R2/R1/6.x, Business Objects 6.5.

Operating Systems: Windows 2003/XP/7, HP UNIX, Linu x, Sun Solaris

Programming Language: Oracle SQL, PL/SQL, UNIX Shell Scripting ksh(korn shell), Perl Scripting, C and Cobol, Java, C, C++, HTML, CSS, JavaScript

Development Tools: SQL * Plus, SQL * Developer, PLSQL Developer, Toad

Oracle Utilities: SQL* LOADER, UTL FILE, DBMS

ETL and Data Modeling tools: Informatica Power Center 9.5.1/9.0.1/8.5/8.1/7.1 , Data Stage, Erwin, MS Visio, Share point, MS Access

Version Control & Migration Software: Visual Source Safe, Mercury, Quality Centre, PVCS, Remedy, Kintana

PROFESSIONAL EXPERIENCE

Confidential

Oracle PL/SQL Developer

Environment: Oracle Database11g,TOAD, SQL*Loader, Oracle Forms Builder 10g, Reports Builder 10g, SQL Navigator, PL/SQL,Perl Scripting, XML, UNIX.

Responsibilities:

• Work on the MMIS (Medicaid Management Information System) Healthcare system and especially in the Medicaid Eligibility functionality.
• Review the Business/ Functional/ System Requirement Specs, High Level Design Documents, and Detailed Design Documents.
• Design and develop the code for Common Web Portal for Medicaid Eligibility to serve the People
• Create PL/SQL stored procedures, functions, packages and triggers according to the business requirements
• Work on performing several data export and imports operations to load data from different sources using the TOAD and SQL developer.
• Involve in SQL Tuning and optimizing SQL queries by creation of indexes, rebuilding Indexes using Explain Plan, by creating the temp tables, by increasing the partitions or DOP
• Work on Oracle SOL and PLto tune in OLTP and DWH applications using STATSPACK, Explain Plan, TKPROF, and Hints
• Support modules for implementation using PL/SQL Scripts, Unix Shell Scripts and Pro*C.
• Create on automating jobs using UNIX shell scripts to run all the SQL files Developed several packages that are used in oracle forms and reports
• Develop Reports and run Oracle queries and build new report templates to meet business objectives according to specifications
• Develop reports using Oracle Report 11g for the business user's readability and scheduled jobs for the reports to be emailed to the respective people
• Develop custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively
• Write test plans involved for Unit testing and guiding the DBAs while implementing them in DEV, SQA and production.
• Perform unit testing and peer testing for all the modifications made and ensure it passes UAT
• Perform regression of performance testing before pushing new code to production e Identify and troubleshoot query, reporting issues and batch failures
• Solve the complicated run time errors while running the process along with DBA team members.
• Work on Defect Analysis and bug fixes, complex enhancement requests and Provided hands on support to the users

Confidential, Peoria, IL

Oracle PL/SQL Developer

Environment: Oracle Database 12c, Oracle Exadata, Talend(ETL), Windows XP, TOAD, SQL*Loader, Oracle Forms Builder 10g, Reports Builder 10g, SQL Navigator, PL/SQL, JavaScript, Perl Scripting, XML, UNIX, ASP.NET, Hadoop,korn shell(ksh),Netezza 6.0

Responsibilities:

• Prepared Systems Requirement Specification Document and Technical requirement specifications as per the client requirements
• Preparation of class structure and sequence diagrams using Rational Rose
• Conducted ETL development in the Netezza environment using standard design methodologies.
• Monitored progress and documented compliance with ETL best practices standards.
• Assessed the Netezza environment for implementation of the ETL solutions.
• Used cursors and collections for accessing complex data resulted from joining a large number of tables
• Extracted data into comma or pipe delimited files using UTL FILE package/utility
• Involved in testing backend SQL queries for query optimization
• Developed several packages that are used in oracle forms and reports
• Created Embedded SQL and PLSQL scripts using PRO*C and tested the application for optimized performance
• Designed, developed, debugged and tested a web portal for Eligibility system using ASP.NET and ADO.NET
• Worked on various applications to improvise and enhance applications, to meet the requirements for healthcare guidelines
• Dealt with troubleshooting performance and performed root cause analysis on Oracle Exadata, from host to database to storage and network.
• Worked on creating Restful Services using ASP.NET Web API and C#
• Involved in GUI designing using Oracle Developer 10g (Forms 10g and Report 10g)
• Developed stored procedures and triggers to facilitate consistent data entry into the database
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities
• Developed Installation scripts for all the deliverables
• Performed functional testing for different Oracle Forms application functionalities
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose
• Extensively utilized TOAD for performance tuning by generating explain Plans
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages
• Tuned the applications to enhance the speed by utilizing Indexing, SQL HINTS and Materialized Views
• Developed complex SQL queries to perform the back end testing of the Oracle database using SQL and UNIX shell commands
• Interacted with the user group on a regular basis to discuss requirements and updates

Confidential

Sr. Oracle Developer

Environment: Oracle 11g, Oracle Exadata,Forms Builder 11g, Reports Builder 10g, Business Object 4.1,C#,Net, Xcelsius, Dashboards, PL/SQL, TOAD, UNIX Shell Scripting, AIX, WINDOWS XP, MS Visio, Informatica Power Center 9.5.1, HP Quality Center

Responsibilities:

• Analyzed and created the functional & technical specification document for various objects involved in the project. Discuss with business users, BA's and UI Architects to finalize requirements and scope of the project
• Designed the Database and ETL framework for the new enhanced UI for SCT tool
• Created new tables, views, materialized views, Packages, Stored Procedures and functions as per the business requirements
• Created new Informatica Mappings as required
• Installed, Troubleshoot, upgraded and maintained the various Business Objects.
• Created Dashboard using SAP Business Objects Xcelcius Dashboard and MS Excel.
• Perform unit testing, code review and made changes/improvements to the SQL/PLSQL scripts as required for better performance
• Optimized the code to meet SLAs with UI. Used Hints like materialize, parallel, no parallel, etc., to improve the performance
• Involved in migration of Business Objects Documents to Micro Strategy Documents.
• Creation of different data stores to get SAP tables, Developed jobs using Business Objects Data Integrator XI designer to extract data from source databases and flat files into oracle staging area.
• Performed Unit, System and Regression testing of the Business Objects Data Integrator ETL jobs.
• Maintain SVN repository, deploy code base to SIT, QA, UAT, dry-run environments as requested
• Plan production deployment activities, ITSM processes, raise RFCs and coordinate with various teams including DBA Team, UNIX Administrators, Informatica Administrators and developers etc
• Created multiple dashboards, adhoc reports, sub-reports and complex master-detail reports using Reports Builder 10g as per the user requirements
• Worked on creating Restful Services using ASP.NET Web API and C#
• Worked with Web API to provide services to HTTP requests
• Implemented the application using ASP.NET frameworks using C#.Net.
• Designed the responsive Web pages oriented as well as Master Pages using HTML, CSS, Java Scripts.
• Designed and implemented UI application using Oracle Forms Builder 10g. Deployed the forms binary files to the server and compiled them for generating executables
• Developed comprehensive test plans, scripts and cases and performed unit and comprehensive testing with system developers to ensure overall functionality and technical quality of deliverables
• Developed UNIX shell scripts with embedded SQL Loader and PLSQL statements to extract data from the legacy application in the form of flat files and load into current database
• Developed views to facilitate easy interface implementation and enforce security on critical customer information
• Performed activities like troubleshooting technical issues and problems, monitor progress against plan, and communicate status to Leads
• Involved in gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Created tables, Correlated sub queries, Nested Queries, Views, Dynamic SQL for Business Application Development
• Implemented security features of Business Objects like row level, object level and report level to make the data secure.
• Developed back end interfaces using PL/SQL Packages, Stored Procedures, Collections
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc. Designed Database Triggers for audit and validation purpose
• Knowledge in Shell scripting to automate system administration jobs as per Business requirement and applying the changes after creating a change control

Confidential

PL/SQL Developer

Environment: Oracle 9i/10g, Form Builder 6i, Report Builder 6i, SQL, PL/SQL, Toad, UNIX, Perl

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables
• Developing Stored Procedures, Functions and Triggers
• Development was done extensively on collections (Associative Arrays, Nested Tables)
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures
• Maintaining daily batch cycle and providing 24 hour production support
• Developed custom business Libraries for calling in various Forms. Developed complex forms and fixed various issues with existing UI
• Developed complex master detail Reports using Oracle Reports Builder and published them on the MARS application for easy accessibility and printing in client required output format.
• Utilized various features of Reports builder for generating Dynamic reports based on lexical parameters.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing
• Created SQL*Loader scripts to load data into temporary staging tables
• Developed automated scripts to schedule the load of flat files on daily, weekly and monthly basis
• Interaction and coordination with various application teams for resolving issues, patch movements
• Performed SQL tuning using Explain Plan, Hints and indexes
• Partitioned tables and indexes for better performance of application
• Involved in importing the production data to development environments for testing purpose
• Involved in handling the changes in compiling scripts according to the database changes
• Performed Unit Testing and generated scripts for performance and UAT testing