SUMMARY:

• Around 8 years of diversified experience in SDLC (Software development life cycle) involving analysis, design, development, testing and implementation of applications using OLTP and OLAP environments as an Oracle PL/SQL Developer
• Have good experience handling financial, healthcare (RAPS & MMIS) and Communication platform projects.
• Expertise in using Oracle 8i/9i/10g/11g and had hands on experience in building advanced Relational database objects in Oracle 8i/9i/10g/11g database
• Have good knowledge on Data warehousing concepts for implementing ETL using Start schema and Snowflake schema
• Have good knowledge in Informatica ETL tool 8.6.0/8.6.1, OWB and ODI tools.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, fact and Dimensional tables and Operational Data Store (ODS).
• Expertise in creating and modifying database objects like Tables, Indexes, Views, Stored Procedures, Functions, Packages, Triggers, Synonyms, Sequences and Materialized views using SQL and PL/SQL
• Expertise in using user defined and system defined Exceptions for Error handling
• Implemented PL/SQL advanced topics like Bulk Collects, Ref Cursors, Collections, and External tables
• Extensively worked on PL/SQL Object Types, Autonomous transaction and Table Partitioning.
• Worked wif various Performance tuning techniques using tools provided by Oracle like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE, HINTS, DBMS PROFILER etc.
• Working Knowledge on UNIX, Windows and UNIX Shell Scripting, PERL scripting.
• Good team spirit and organized working habits wif a willingness to learn new concepts and ready to work in 24*7 environments
• Excellent analytical, problem solving, decision - making and presentation skills in a fast paced team environment
• Strong oral and written communications skills, analytical and interpersonal skills

TECHNICAL SKILLS:

RDBMS: Oracle 12c/11g/10g/9i/ 8i, SQL Server, Sybase, DB2

GUI S: Developer/2000 (Forms 10g/9i/6i/5.0/4.5& Reports 10g/9i/6i/3.0/2.5),Crystal Reports

LANGUAGES: SQL, PL/SQL, C, HTML, XML, VB.NET, java script, Pro*C

ADMINISTRATION: SQL*Loader, Export, Import.

Tools: TOAD, SQL*PLUS, SQL*LOADER, PL/SQLDEVELOPER, COLD FUSION,SQL*NAVIGATOR, SQL DEVELOPER, Erwin, Oracle Ware House Builder (OWB),Oracle Data Integrator (ODI). TWS 8.5(Tivoli), Git/Stash

OPERATING SYSTEM: Windows7/ NT/2000/98/95, DOS 6.0/3.0, UNIX, Linux, SUN SOLARIS

PROFESSIONAL EXPERIENCE:

Confidential, Eden Prairie, Minnesota

Sr.PL/SQL Developer

Responsibilities:

• Created and Developed Technical Design documents based on Business and functional requirement documents.
• Built and maintained Medicaid Management information Systems (MMIS) as per CMS guidelines.
• Worked on developing complex SQL scripts for Client Reports.
• Analyzed and designed application specific data model for IRADS using ERWIN data modeler.
• Developed PL/SQL Stored Procedures, Functions, Packages and Package Constructors and ETL processes to load data from Flat files, XML and Excel spreadsheet into the target Oracle database by applying required business logic for inserting and updating records when loaded.
• Created Control file scripts and used SQLLDR to load data into the staging table from external files.
• Debugged Existing procedures to fix defects and included new business requirements into the Pl/Sql code.
• Developed User Defined String Aggregation functions to meet specific data reporting requirements.
• Developed reports using Oracle Crystal Reports.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Optimized SQL and PL/SQL performance using Oracle utilities like Explain Plan, SQL TRACE and TKPROF.
• CreatedPL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Developed UNIX Shell Scripts to FTP the flat files and for firing the stored procedures dat reside on oracle database.
• Actively Involved in Code Deploys on all Production Environments.
• Involved in Release Management Process for moving code from one environment to another environment.
• Participated in Production Support activities
• As a team member interacted wif Business Analysts, Data architect and client representatives for requirements gathering, research and solving client specific data issues

Environment: Oracle 12c, TOAD, SQL developer, PLSQL Developer, SQL* Plus, UNIX Shell script, Perl scripts.

Confidential

Sr.PL/SQL Developer

Responsibilities:

• Responsible for gathering requirements from Process team and documenting them into detailed functional and technical specifications and test cases
• Performed heavy SQL development for various ETL process.
• Extensively used Bulk Collects in procedures to do data repairs on production data
• Worked on UNIX. Created shell scripts to SFTP files from windows to UNIX directories.
• Worked in coordination wif the testing team to fix ETL defects
• Worked closely wif the DBAs to performance tune the ETL mappings from a database and OWB perspective
• Extensively used EXPLAIN PLAN utility to leverage SQL queries
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan
• Involved in the continuous enhancements and fixing of production problems
• Applied table partitions for faster access of data and increase performance.
• Tuning SQL scripts for faster execution using Explain Plan, SQL Trace and TKPROF utilities.
• Responsible for creating UNIX scripts for batch processing.
• Developed procedures using Dynamic SQL and built-in packages like UTL FILE.
• Involved in Testing (Both Unit and Integration Level) and Implementation.
• Responsible for documentation and provided on-site production support.
• Involved in enhancement of existing Data flow diagrams, ER Diagrams and Data Models.

Environment: Oracle 11g, Oracle Warehouse Builder 10.2 and 11.2, UNIX Shell Scripting.

Confidential, Chicago, IL

Sr.PL/SQL Developer

Responsibilities:

• Developed PL/SQL Stored Procedures, Functions, Packages and Package Constructors to load data into database tables from flat files.
• Extensively used Cursors, Ref Cursors, Collections, Dynamic SQL and Exceptions in developing Packaged Procedures and Functions.
• Created control file scripts and used SQLLDR to load data into the staging table from external files.
• Created indexes on the tables for faster retrieval of the data to enhance database performance
• Optimized SQL and PL/SQL performance using Oracle utilities like Explain Plan and SQL Trace
• Extensively wrote UNIX Shell scripts to automate the data load from SQLLDR to staging table.
• Extensively used External tables for data conversion in staging area before loading the data into the respective Database tables.
• Extensively scheduled oracle procedures using DBMS JOB and DBMS SCHEDULER packages
• Involved in Release Management Process for moving code from one environment to another environment.
• Have good experience in Production Support activities
• As a team member interacted wif Business Analysts, Data architect and client representatives for requirements gathering, research and solving client specific data issues

Environment: Oracle 11g, TOAD, SQL developer, PLSQL Developer, SQL* Plus, UNIX Shell script, Eclipse.

Confidential, Chicago, IL

Sr.PL/SQL developer

Responsibilities:

• Involved in designing Entity Relationship Data model as per the requirement.
• Created SQL*Loader control files for moving the data from flat files to staging area tables.
• Implemented Complex business Logic as per the client requirement.
• Involved in creating Procedures, packages and appropriate REF Cursors to handle BULK collects DBMS PROFILER and BULK binds.
• Worked on applying Constraints on table’s columns and writing Triggers on database tables to meet the required business rules.
• Extensively handled all types of Exceptions in PL/SQL programs.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Developed Crystal Reports to extract the monthly sales information of policies.
• Performed Unit testing on queries and Crystal reports.
• Responsible for code migration of existing application from SQL Database to Oracle Database.
• Reviewed data transformation rules and provided technical suggestions in data transformation logic and pseudo code (PL/SQL) program asynchronously.
• Developed systematic strategy for measurements of free space in table spaces & trend analysis of dis growing database
• Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users.
• Transformed complex business rules to Oracle PL/SQL.

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Crystal Reports.

Confidential

Sr.PL/SQL Developer

Responsibilities:

• Worked on Database design wif the team.
• Worked on Logical, Physical and conceptual design of Database Data Modeling, and Data Architecture wif the use of Erwin and MS VISIO as a modeling tool.
• Generated SQL and PL/SQL scripts to create and drop database objects including Tables, Views, Indexes, Constraints, Sequences and Synonyms.
• Created Stored Procedures, Functions, Packages, Triggers and Cursors based on requirement.
• Created indexes for faster access of data and hence improving the performance of queries.
• Used Dynamic SQL to implement DDL statements in PL/SQL programs
• Worked on Database tuning and performance monitoring.
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to files.
• Designed Unix shell scripts and set up cron jobs.

Environment: Oracle 10g, UNIX shell scripting, TOAD, SQL*Plus, Erwin, MS Visio, Crystal Reports.

Confidential, Dublin, OH

Sr.PL/SQL Developer

Responsibilities:

• Involved in analyzing the existing business process, application and Database design.
• Development new PL/SQL packages, stored procedures and triggers and performed Unit testing.
• Written Stored Procedures and functions using PL/SQL for common utilities.
• Developed UNIX shell scripts and set the cron jobs.
• Created Jobs and stored procedures using Dynamic SQL for refreshing materialized views.
• Created scripts, PL/SQL stored procedures and functions.
• Extensively used PL/SQL to implement Cursors, Triggers, and Packages.
• Created SQL*Loader scripts and Oracle external tables.
• Worked wif QA and provided timely technical resolutions for defects.

Environment: Oracle 9i, SQL * Plus, TOAD, SQL Loader, Shell Scripts, Erwin, Reports 9i.