PROFESSIONAL SUMMARY:

• Over 10 years of IT experience with specialization in PL/SQL programming language, Database Architecture & Design, Database Development and integration, ETL, Data Warehousing and extensive experience in implementing Full Life cycle of Database and Data Warehousing Projects.
• Developed applications using PL/SQL Packages, stored procedures, functions, triggers, cursors, views, indexes for processing data and enforcing referential integrity. Experience in using tools like TOAD, PL SQL Developer, and SQL Developer.
• Developed processes using SQL Shell Scripting and PL/SQL procedures to compare and load daily data into database tables.
• Strong experience tuning database procedures and Views using Partitioning tables, indexes, hints and query optimization techniques.
• Extensive experience in Extraction, Transformation and Loading (ETL) data from various sources such as like flat files, Excel, Oracle, SQL Server into Database tables and use by front - end applications.
• Possess very strong PL/SQL coding, database design & development and analytical skills.
• Expertise in use of advanced analytical functions such as Lead, Lag, Partition by, connect by clause etc.
• Highly skilled in using, Ref Cursors, Collections, PL/SQL tables, bulk collect, Pragma autonomous, Pipelined functions, Regular expressions and other advanced functions.
• Using the latest technologies from Oracle, Informatica and SAP, designed complex data movement, manipulation, and delivery solutions from multiple sources systems into the Datawarehouse.
• Using Informatica developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings.
• Extensive experience in all phases of the SDLC (Software Development Life Cycle) from Analysis, Design, Requirements Gathering, Development, Production Support, Performance Tuning, Trouble-shooting and Maintenance of databases.
• Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques.
• Designed and implemented data warehouses and data marts using components of Kimball Methodology, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.
• Experience in writing Technical design and System design documents and helping creation of Requirements Traceability Matrix.
• Ability to work closely with clients to analyze data, determine project requirements, review functional requirements and develop detailed designs to meet requirements.
• Proficient in Oracle database creation, creating database links, schemas, profiles etc.
• Excellent analytical and problem-solving skills with strong communication and interpersonal skills.
• Extensive experience in conducting Gap Analysis, Impact Analysis and modeling Businesses Processes, and preparing Training manuals and Knowledge Transfer manuals.
• Experience with creating of Data Flow Diagrams and Work Flow Diagrams using UML Rational tools/ MS Visio.

TECHNICAL SKILLS:

Operating Systems: Windows 10/7/98/XP/2000/2003/NT, DOS,UNIX (Sun Solaris, HP-UX), Linux

Database: Exadata, Oracle 12C/11g/10g/9i/8i, MySQL, MS SQL Server,DB2, MS Access 2000

Programming languages: PL/SQL programming, ETL Programming, C++, VC++,C#, VB, Pro*C, Unix scripting, Java, J2EE

Web Technologies: SAP Business Objects, Micro strategy, HTML, DHTML, Cold Fusion, AJAX, XML, JSP

Script Languages: JavaScript, Shell, Perl scripting etc.

Tools: Toad, SAP BODS Data Designer, PLSQL Developer, JIRA for Agile Development, OEM, SQL Navigator, SQL Tools, Erwin Data Modelling tool, Eclipse, Tidal Job development and scheduling tool, Jenkins for code migration, TFS as a code repository, MS Visio, Rational Clearcase, Kalido, Rational requisite pro, ALM for ticket tracking, Oracle Golden Gate technologies, WinSCP, Putty, OEM, GIT

Others: Object Oriented Designing Methodology, UML, RDBMS Concepts

ETL: PL/SQL, SAP BODS, Informatica Power Center 8.1.1, Oracle Golden Gate

EXPERIENCE:

Confidential, Oakland, CA

Sr. PL/SQL Developer/Tech Lead

Responsibilities:

• Worked in the SPG group in the department of Research at Kaiser Permanente. Created the entire backend infrastructure of the Prism application using PL/SQL language for use by doctors and Physicians.
• Created highly complex procedures and views on tables containing millions of records and optimized the queries to return results with in milli seconds.
• Used dynamic sql in procedures to generate queries at run time and modify query based on user input.
• Extracted, transformed and loaded data from various systems into the DOR databases for use by the Front-end applications, Doctors and Data Scientists at Kaiser.
• Used Table partitioning to Store labs data and stored data in yearly partitions to expedite data retrieval and job run time. Performed partition exchange to load and update data into the database.
• Used advanced analytical functions such as Lead, Lag, Partition by, connect by clause to process data at run time based on user input and returned results in real time to the front end users.
• Handled all production support activities that included analyzing Data and PL/SQL packages for data and code issues. Making code changes and deploying the changes promptly. Led a team of developers in various projects.
• Created data model and database architecture from the scratch in a new oracle database to support creation of web-based Prism Application.
• Created PL/SQL packages, procedures, views, functions, tables, index etc. Performance tuned views to perform complex calculations at runtime and return data in milli seconds.
• Used Ref Cursors, Collections, PL/SQL tables, bulk collect, Pragma autonomous, Pipelined functions, Regular expressions and other advanced functions.
• Created and modified Unix shell scripts for the database system to use SAS 9.4 server.
• Developed processes using SQL Shell Scripting and PL/SQL procedures to compare and load daily data into database tables.
• Worked on the enterprise wide migration project of migrating Teradata code and configuration to an Exadata(Oracle) based system. The process Involved PL/SQL code conversion, connection reconfiguration and data/system analysis.
• Created PL/SQL jobs to load the data into the database tables and Pl/SQL packages to feed target tables to be use by front end application.
• Using Informatica developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings.
• Possess strong business and data analysis skills; and worked on all phases of the project including business analysis, system analysis, coding and deployment.
• Normalized tables for best results and created primary key, foreign key, Master tables etc.
• Possess strong performance tuning skills using query tuning, query restructuring, indexing, join order, explain plan etc.
• Loaded flat files by using SQL Loader according to the business requirements.
• Created External table to access flat files.
• Used UTL File to load data from flat files, modified data according to the business logic and saved back in to flat file OR into table.

Confidential, Bristol, CT

Sr. PL/SQL Developer

Responsibilities:

• Lead the implementation of the data warehouse project during its complete life cycle, from requirements gathering to UAT and final delivery to the client.
• Designed and implemented data warehouses and data marts using Slowly Changing Dimensions, Surrogate Keys, Snowflake Schema, etc.
• Extracted, transformed and loaded data from various Systems into company’s BI database.
• Created new Data warehouse to store data from ESPNs core business applications and used analytical tools to extract information quintessential to business users for taking strategic decisions with respect to Confidential ’s day to day activities.
• Created oracle data warehouse design using data modelling tool Irwin.
• Created SAP BODS jobs for moving Source data to Data Warehouse on a daily basis using Tidal Jobs.
• Created Oracle PL/SQL stored procedures, functions, packages and Database triggers to perform ETL operations.
• Designed and developed Mappings in SAP BODS (ETL tool) based on business user requirements and business rules to load data from source tables to target tables.
• Analyzed Reporting requirements of BI Finance group and translated them into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas, Snowflake Schemas, Operational Data Stores, etc.
• Created Real Time data streams using oracle PL/SQL to store and process data changes from the source system into our Operational Database.
• Designed and developed Oracle PL/SQL batch processes for loading data from internal and external systems.
• Used Dynamic SQL and Execute Immediate functionality to perform DDL in PL/SQL blocks and procedures
• Created database tables, indexes, and sequences and large amounts of data retrieved because of single transactions or multiple simultaneous transactions returning only thousands of records.
• Handled PL/SQL Compile-Time, Runtime Errors, and Debugging of stored procedure for errors during development of the application.
• Developed, modified and optimized complex queries for fast data retrieval and modification.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.
• Extensively worked in creating dynamic tables, loops, cursors and conditional operators on the Oracle Form 11g, and using SQL *Plus.
• Interacted with the users and performed troubleshooting of the errors in the application.
• Extensive Use of exception handling methods along with Pragma Exception init in order to associate our own created exception names.

Confidential, Detroit, MI

Sr. Oracle Developer

Responsibilities:

• Created highly complex database views on tables containing billions of records and optimized the queries to return results with in milliseconds for the real time application used by DTE customers.
• Responsible for creating the database design and architecture.
• Created database architecture and partitioned gas and electric tables for the client using range partitioning. Created indexes and organized data for maximum performance.
• Responsible for writing and modification of PL/SQL stored procedures, functions, packages and Database triggers.
• Involved in the complete life cycle of the project, from requirements gathering to UAT and final delivery to the client.
• Handled PL/SQL Compile-Time, Runtime Errors, and Debugging of stored procedure for business logic modification.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions throughout the project.
• Created database tables, indexes, and sequences and worked with large amounts of data retrieved as a result of single transactions or multiple simultaneous transactions returning only a thousand of records.
• Used SQL querying to mine the data, draw business insights and implement changes according to client’s needs.
• Developed processes using SQL Shell Scripts and SQL procedures to compare and load daily data into database tables.
• Wrote Unix shell scripts to process the files and performed activities like renaming the files, extracting data from files, unzipping the files and loading them into the target tables.
• Used Ref Cursors, Synonyms, Indexes, Joins and Exceptions extensively in coding.
• Created Forms Triggers, Alerts, Data Blocks, LOVs, Parameters, and Program units and displayed data using PL/SQL procedures and functions of OOPS methodology.
• Extensively worked in creating dynamic tables, loops, cursors and conditional operators on the Oracle Form 11g, and using SQL *Plus.
• Interacted with the users and performed troubleshooting of the errors in the application.
• Extensive Use of exception handling methods along with Pragma Exception init in order to associate our own created exception names.
• Involved in Designing data models using MS Visio.

Tools: Oracle 11g R3, SQL*Plus, TOAD 9.6.1, Oracle Forms Builder, Rational ClearCase, HP Quality Center, Putty, Winscp 5.1, MS Visio, MS Access, MS Word, MS Power Point, MS Excel and MS SharePoint.

Confidential

Programmer Analyst

Responsibilities:

• Involved in Analysis, Implementation, Development and Maintenance of the Michigan Child Support Enforcement System (MICSES) project for the Department of Technology, Management & Budget State of Michigan. Functioned as unit of work Lead in various projects, and led teams of developers by assigning, analyzing and evaluating work.
• Responsible for writing and modification of PL/SQL stored procedures, functions, packages and Database triggers.
• Handled PL/SQL Compile-Time, Runtime Errors, and Debugging of stored procedure for errors during development of the application.
• Developed, modified and optimized complex queries for fast data retrieval and modification.
• Developed Forms Screens using Oracle Forms Builder to create the user interface for MICSES application.
• Created Forms Triggers, Alerts, Data Blocks, LOVs, Parameters, and Program units; and displayed data using PL/SQL procedures and functions implementing OOPS methodology.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements.
• Used advanced PLSQL concepts such as Bulk collect, Pl/Sql tables and Dynamic SQL for better performance.
• Analyzed data, designed Oracle forms 11g queries, layout, report triggers, parameter form, data models etc.
• Processed data obtained from DHS, Social security, Federal Case Registry and NCOA to ensure that custodial parties obtain the fair support payments from the absent parents.
• Experience in using DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
• Created Materialized views & normal views according to the requirements.
• Extensively used IBM’s Rational tools for Requirements Management, Change & Configuration Management, Quality Management and Administration. Created and mapped technical requirements, logged and managed defects, created and ran test cases & scripts and mapped defects to test cases using Rational tools

Tools: Oracle 11g, SQL*Plus, TOAD 9.6.1, Oracle Forms Builder Rational (RM), Rational (QM), Rational(C&CM), Remedy, MS Visio, MS Access, MS Word, MS Power Point, MS Excel and MS SharePoint.

Systems Analyst

Confidential

Responsibilities:

• Worked on the Report a Change module of the Health Insurance application (AZ HIX) developed by the department of Health Insurance Exchange, Arizona. The application allows public users to screen for their eligibility to the medical and nutrition benefits provided by the state government.
• Coordinated with cross functional teams to gather business information; and developed plans and actions to facilitate application development.
• Created Business Requirement and System Requirement Documents (BRD & SRD).
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements
• Tuned SQL queries and complex procedures to improve performance.
• Delegated routine tasks to five developers for development of application in Dot Net platform.
• Created data mapping in Microsoft Excel using advanced excel functions (v loolup, formulas etc).
• Worked with the project manager to define deliverables, define scope and actively track progress.
• Prepared project proposals involving cost estimations, effort analysis, and resource allocation.
• Used Pivot tables in Excel to analyze Insurance related data and recommended solutions for Business development.
• Organized many Joint Application Development (JAD) sessions and Joint Requirement planning sessions (JRP) with client/ stake holders and the IT group.
• Ensured that all the requirements were implemented as per Requirements Traceability Matrix (RTM).
• Used advanced excel techniques such as Functions, Formulas, Arrays, Pivot Tables, and Charting to generate reports.
• Applied standard procedures to ensure that all system users are properly identified and information/application access is designed on the respective user's job role.
• Used Microsoft Visio for Business process modeling, creating use cases and data flow diagrams.
• Used SQL to query the database for performing data analysis.
• Developed, modified and optimized complex queries for data retrieval and modification

Tools and Technologies: MS Visio, MS Word, MS Power Point, MS Excel and MS SharePoint. Oracle 10g,SQL, SQL*Plus, TOAD, Quality Center, Relational Clear Case, Informatica Power Center 8.1.1, PL Sql Developer,

Confidential

Sr. Software Engineer

Responsibilities:

• Developed insurance underwriting application in PL/ SQL and J2EE programming language. Responsible for design, coding, validation and timely delivery of the project.
• Worked with oracle database containing millions of insurance records, developed procedures and tables to support front end development.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers
• Extensively used SQL & PL/SQL in reports. Highly competent with SQL functions and terminology such as Primary key, Foreign Key, union, joins, aggregate functions and sub queries.
• Participated in entire life cycle of the project right from requirement gathering to final delivery.
• Participated in status meeting and walkthroughs.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Generated PL/SQL reports and Unix Scripts to notify process failure/success.
• Responsible for testing and validation of the project. Ensured timely delivery of projects.
• Also responsible for the defect prevention and analysis, as new features and add-ons are continuously included into the application.
• Proactively guided new resources inducted into the project.
• Used Microsoft Visio for Business process modeling and Data flow diagrams.
• Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.
• Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration and functional testing.
• Employed SQL querying to mine the data and draw business insights.
• Provided 24/7 on call production support.
• Tools and Technologies: Oracle 9i, SQL*Plus, PL/SQL, Toad, HPQC, MS Visio, PL SQL Developer, MS Word, MS Excel, 1.6, JSP 2.0, XML, CSS, Java script, Java, J2EE, Struts, Eclipse.