SUMMARY:

• Around 11 years of extensive experience in Design, Development and Maintenance in Healthcare, Telecommunications, Retail, Financial, Manufacturing, and other Software companies on Oracle Databases, SQL Server, MySQL, Informatica, SSIS, SSRS, Oracle Forms and Reports.
• Experience with multiple RDBMS including Oracle 12c/11g/10g/9i/8i, Microsoft SQL Server 2008/2005, MySQL and associated SQL Dialects such as PL/SQL, Transact SQL ( Confidential - SQL), MySQL.
• Good knowledge over the entire Software Development Life Cycle (SDLC) that includes requirements gathering, functional and technical specifications, design, development, testing and production deployment.
• Proficient in creating Tables, Views, Packages , Procedures , Functions , Collections, Exception handling Views, Partitions, Analytical Functions, Virtual Columns, Triggers and various other Database Objects .
• Import, Export and Data conversion from flat files to Oracle database using SQL* Loader, External Tables and implementing Data-cleansing procedures.
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering, Publishing ERWIN Models.
• Proficient in Analyzing data sources and creating interface documents and proficient in Dimensional and Relational Database Management Systems.
• Proficient in developing the Data mart in Star Schema and Snowflake Schema, Flat files and building the Data warehouse, Efficient in developing the Logical & Physical Data model, OLTP/OLAP, ER Diagrams and organizing the data as per the Business requirements.
• Experienced in designing, developing & deploying Reports by blending the financial knowledge of the client with the technical expertise.
• Expert in creating reports using XML publisher, creating and managing workbooks using Discoverer
• Experience in performance Tuning & Optimization of SQL statements using INDEX, Explain plan, optimizer hints, Tkprof and applying adaptive tuning techniques.
• Experienced in writing shell scripts in Unix and Linux platform for automating the process of data loading & Batch Processing.
• Strong knowledge in object oriented programming using C++, JAVA, Pro*C, Clear case.
• Experienced in ETL processing of Designing Workflows, applying Transformations in Informatica Power center tool and Data Services tool.
• Hands on experience in interacting with Business User and Business systems analysts to understand the requirements and documenting the Functional Requirement Document and Technical requirement documents.
• Strong Trouble-shooting, Problem solving, Analytical & Design Skills and ability to quickly master new software and adapt to changing needs
• Excellent communication, interpersonal and versatile team player with problem solving skills.

TECHNICAL SKILLS:

Frontend:  Oracle Developer Suite 11g/10g/9i/2000, QNXT, Forms Builder 10g/9i/6i/5.0 Reports Builder 10g/9i/6i/3.0, SQL * Loader, XML Publisher, Discoverer, QC

Programming:  PL/SQL, TSQL, Bash & Korn Shell Scripting, XML, HTML C/C++, Java

Database:  Oracle 8i/9i/10g/11g/12c, MS Access 2000/2002, SQL server 2008, EXADATA, Confidential -Cloud, MySQL

Third Party Tools:  TOAD 12.5/10.2/8.6/7.5 , PL/SQL Developer, SQL Navigator, Putty, Informatica, MS-Office 2010, Microsoft Visual Source Safe, Clear case, Erwin r7.3/7.x, AccuRev, ER studio, Winscp, TFS (Team Foundation Server), JAWS, Autosys

Operating Systems:  Windows 98/2000/XP/8/10/NT, UNIX, Linux 3.0/4

Others:  XML, HTML, SVN, Microsoft Visual Source Safe (VSS), IBM Rational Clear Case and Clear Quest, Caliber, CVS, Eclipse, Quality Center, Dimensions, Lotus Notes

PROFESSIONAL EXPERIENCE:

Confidential,El Segundo,CA

Sr. Oracle Developer/Production support Analyst

Responsibilities:

• Designed and maintained the data extraction and loading from source systems (PARIS, ACTS, SAP CRM, RIO, WOREC) to target EPS system.
• Actively participated in the daily status meetings for the production issues and resolving tickets.
• Extensively interacted with the Business User and Business system analysts to understand the functionality and resolving the User Acceptance Test issues.
• Wrote Packages to store the business rules and exceptions and wrote PL/SQL code to load data from staging tables to the target schema.
• As a production on-call support, identified the root cause and resolved the job failures by going through the Autosys jobs, Unix shell scripts and corresponding pl/sql packages called inside the shell scripts.
• Identify the bad data coming from the flat files and by error log tables, log files and communicated to the source system to resolve the job failures.
• Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
• Identified the long running SQL queries by going through the AWR reports and AWR related tables in the database.
• Have done the performance tuning on the long running queries.
• Created the DB-Links pointing to the remote database to access the source materialized views.
• Loading the Data into tables using External tables and extracting the files using Package UTL FILE.
• Wrote the Unix scripts for scheduling or running the scripts for day to day transactions.
• Extensively worked with third party database tools like TOAD & PL/SQL Developer, JAWS, SERVICE DESK, AUTOSYS.
• Created materialized view on remote database and automated scheduler of refreshing of materialized view on source side.

Environment: Oracle 12c/11g, PL/SQL, Autosys, JAWS, Toad 12.5, UNIX, LINUX, TFS, True comp

Confidential,Los Angeles,CA

Tech Lead Oracle Developer/Analyst

Responsibilities:

• Designed and maintained the Provider Sync process from source Master Provider Data to target QNXT system.
• Actively participated in the daily status meetings for the Sync issues and resolving Help Desk tickets.
• Extensively interacted with the Business User and Business system analysts to understand the functionality and resolving the User Acceptance Test issues.
• Day to day interacting with the team members on the status of the projects, assigning the new projects and discussing the production issues.
• Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
• Experience of working with Encounter Processes and Transactions (837P, 837I, 837D and NCPDP 4.2 transactions, EVR, 999/777/MAO) along with knowledge of healthcare member eligibility, provider network, claim processing, National Standard Codes
• Involved in the Daily and Monthly Fame Raws file loads from the state and enhancing the Provider assignment process to the members received in weekly HCO files and member eligibility files.
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL Enhanced it with creating exceptions for error handling.
• Modified the queries by applying the oracle hints and using BULK COLLECT, FOR ALL and NOCOPY to reduce the time for performance of the query run time.
• Loading the Data into tables using External tables and extracting the files using Package UTL FILE.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Wrote the Unix scripts for scheduling or running the scripts for day to day transactions.
• Extensively worked with third party database tools like TOAD & PL/SQL Developer.
• Hands on Exposure on 2010 TFS Version Control. This includes splitting and merging of code branches in various Release and Version Management. Experience in Checking in, checking out the code in TFS (Team Foundation Server).
• Created materialized view on remote database and automated scheduler of refreshing of materialized view on source side.
• Experience in using the Trace files and TK proof whenever required for performance issues.

Environment: Oracle 12c/11g, PL/SQL, SQL*Plus, PL/SQL Developer 10.0, Toad 12.5, UNIX, LINUX, TFS, QNXT, Provider Portal, Lotus Notes

Confidential,Bellevue, WA

Sr. Oracle PL/SQL Developer/Analyst

Responsibilities:

• Review the Business requirements, Functional requirement document (FSD), Source System Analysis (SSA) for various modules so as to have a good understanding of the application.
• Participate in daily meetings with the Application Functional managers and work in tandem with them to develop the functional specification documents.
• Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables.
• Created Database Objects such as Partitioned Tables, Views, Synonyms, DB-Links to provide data access to subscribing parties.
• Created tables to capture errors and data that failed Validation Checks and used CASE, DECODE and Analytical functions in data transformations.
• Work with different developers in the team and review their daily work progress to meet the project deadlines.
• Used advanced Oracle features like Virtual column, Unusable Index, Invisible Index, data encryption using DBMS CRYPTO, objects.
• Used Analytical Functions like Rank, Row Number, Dense Rank, Listagg, First, Last to compute an aggregate value based on a group of rows.
• Re-validated corrected data from source and re-processed BAD Files to get them loaded to the oracle target.
• Developed ABC module (Audit Balance Control) - core module in logging and keeping track of job status's, error logging/reporting, record tracking, notifications etc.,
• Used SED and AWK in UNIX Shell scripting to correct the data issues in the SQL-Loader data file.
• Created/modified various Packages, Stored Procedure & Functions as part of the data validation and cleansing process.
• Pro-actively participated in SQL tuning, Used Analyze, dbms stats, Explain plan, SQL Trace and Tkprof.
• Used SQL hints and Indexes as needed to improve SQL performance.
• Wrote UNIX Shell scripts for performing development and DBA activities.
• Work with the DBA team and identify the programs causing performance bottlenecks and work with the development team to fine tune the identified programs.
• Tested the ETL process in testing environment and created test cases.

Environment: Oracle 11g/10g, RAC, SQL, PL/SQL, UNIX, SQL server 2005 Management Studio, TOAD, SQL Loader Export, Import, ETL Power Centre 9.1, Accurev.

Confidential , Peapack, NJ 

Sr. PL/SQL Developer/ Report developer

Responsibilities:

• Created materialized views on remote source database and automated scheduler of refreshing of materialized view on source side.
• Created the DB-Links pointing to the remote database to access the source materialized views.
• Created or Modified the Sequel Script (.sql file) to point to the current source.
• Extracted data from the source views by writing the procedures to load the data into staging tables.
• Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.
• Created the tables and sequences by writing DDL statements for the experimental data load capture.
• Loaded the Contracts, Products, Customers & Sales data into the tables using SQL Loader script
• Wrote Packages to store the business rules and exceptions and wrote PL/SQL code to load data from staging tables to the target schema.
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling.
• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
• Extensively interacted with the Business User and Business system analysts to understand the functionality and resolving the User Acceptance Test issues.
• Exclusively involved in writing the wrapper scripts and SQL scripts in ETL Loading process.
• Created indexes on tables and optimized procedure queries.
• Responsible for writing the functional and technical design specification documents (TDS) and maintaining the documentation.
• Responsible for Unit, System and UAT testing the data and provided the test evidence reports.
• Involved in UAT testing, Bugs fixing and the code was sent to Production.
• Executed the test scripts in Quality Centre and raised the defects.
• Loading the data from source to target using Informatica mapping.

Environment: Oracle 9i/10g/11.2, PL/SQL, SQL*Plus, PL/SQL Developer 6.0, Toad 9.1, UNIX, Informatica power center tool 8.1.1, QC 10.0.

Confidential,NJ 

Sr. Oracle PL/SQL Developer/Analyst

Responsibilities:

• Involved in analysis, design, coding, and implementation
• As a part of Data Mining team provided the data from the database to the Testing teams
• Written the SQL Queries to Data Retrieval Tool
• Upon the Requirement updated and modified the queries in the query tool
• In the process of converting the Accounts from NFS system to BOA system loaded the data from the flat files
• Need to develop the reports everyday from the database to check the accounts migration
• Extensively used inbuilt Oracle PL/SQL packages like UTL FILE, DBMS PIPE, DBMS SQL, DBMS STATS in application development
• Developed PL/SQL packages, procedures, functions, materialized views, SQL Scripts and triggers to populate the historic data in the tables applying business logic
• Extensively involved in writing SQL sub-queries with join conditions and PL/SQL scripts
• Involved in performance tuning of SQL queries and Created indexes on tables and optimizing Stored procedure queries
• Developed triggers for automatic updating of the tables and views
• Created group, tabular, and form reports
• Used UNIX scripting to automate the process by using CRONTAB.

Environment: Oracle 10g, SQL*PLUS, TOAD, SQL*LOADER, Forms 10g, Reports 10g, PL/SQL

Confidential, Detroit, MI

Oracle PL/SQL Developer/ DATA Modeler

Responsibilities:

• Identified tables, Indexes, Stored Procedures, triggers, Constraints and Data types of the existing SQL Server database.
• Came up with the low level detailed design to re-create the objects to Oracle database.
• Implemented and fine tuned the detailed design to fit into the migration process.
• Created and managed primary data base objects such as Tables, Views, Indexes, Sequences, and Synonyms according to corresponding Data types
• Developed PL/SQL code to implement business rules through cursors, ref cursors, procedures, functions, and packages
• Migrated data from flat files to Oracle database using SQL*Loader
• Developed control files for SQL * Loader and PL/SQL scripts for Data Extraction/Transformation/Loading and Mapping, loading data into interface tables from different Legacy systems and validating the data.
• Efficiently developed Conceptual, Logical Data models and transformed them to Physical Data model and Creating Schemas using ERWIN.
• Created PL/SQL stored procedures for database and application validations
• Modified and developed database triggers, cursors, procedures, functions and packages to meet business requirements
• Involved in performance tuning of SQL queries to decrease the execution time
• Created test cases PL/SQL procedures for migrated SQL and PL/SQL procedures
• Used cursor variables to pass query result sets between PL/SQL programs and client application
• Migrated the reports according to the requirement using Oracle Reports 10g
• Responsible for writing the technical documents and maintaining the documentation

Environment: Oracle 10g, SQL and PL/SQL, SQL * Loader, TOAD, SQL * Plus, Reports 10g,clearcase, Erwin, ERD

Confidential,NYC,NY

Oracle PL/SQL Developer/Analyst

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users.
• Based on partially filled reports which comes from CRM department Retrieved the customer data from database
• Referencing the CUSIP id retrieved the customer policy id, premium amount, policy start date, end date, policy interest rate
• Written PL/SQL procedures to retrieve the customer information by giving policy id, cusip id as parameters
• According to given reports, changed the insurance policy by calculating the interest.
• Updated the policy interest rates by calculating the insurance rate then calculated interest for next month
• Developed and updated the reports on different type of bonds like municipal bond, public financial bonds and insurance bonds
• Customized the reports with the new interest rates as per the business needs
• Developed and enhanced existing PL/SQL code extensively to suit changing needs
• Developed new reports using XML publisher in PDF format
• Used UTL FILE package in PL/SQL to read and write data in text files
• Wrote scripts to create tables, functions, procedures, ref cursors, triggers and packages
• Wrote shell scripts for automating the process of data loading and daily process
• Worked with DBA's to help them in data loading process, batch jobs and various administration tasks

Environment: Oracle 9i, SQL, PL/SQL, TOAD, SQL*Loader, Reports 6i, XML publisher, SQL * Plus, Unix, Java