SUMMARY:

• 5+ years of experience in Oracle database development, ETL, data modeling and developing data warehouses.
• Extensively worked on building dimensional data modeling for OLAP and OLTP applications using SQL and PL/SQL.
• Responsible for all activities related to the database design, development, deployment and post production of applications for large volume data warehouses.
• Experience in data modeling and establishing relations between Dimension and FACT tables. Involved in the design and development of Data warehousing schemas and developed physical data models using Erwin.
• Proficient in creating database object like Tables, Views, Procedures, Functions, Sequences, Triggers, Materialized Views and Packages.
• Adept in working with indexes, storing data in partitioned tables, materialized views, performance tuning and dynamic SQL. Good knowledge of Oracle database architecture and data warehousing methodologies.
• Actively involved in all the phases of SDLC including analysis, database design, code development, unit testing, implementing and maintenance.
• Strong skills in requirements gathering, data analysis and developing scripts for processes.
• Hands on experience in Oracle tuning, identifying and resolving performance bottlenecks using plan table, Oracle Enterprise Manager and Toad.
• Well versed in developing advance complex PL/SQL queries using concepts like Bulk Collect, Bulk Bind and Collections
• Proficient in UNIX commands and UNIX/LINUX shell scripting.
• Expertise loading data from files into tables using SQL Loader, Data Dump and External tables.
• Experience in creating oracle forms and reports and enhancing the reports as per the requirement changes using Oracle Forms 10g and Oracle reports 10g.
• Exposure on working with Oracle APEX by creating dashboards as per the business requirements.
• Experienced in worked with Microsoft SQL server and done Extract, Transform and Load (ETL) using SSIS.
• Adept in data profiling, data cleansing, unit testing and exception handling.
• Participate in daily Scrum meetings, experienced working in agile software methodologies. Familiar with updating story points in version one project management tool.
• Worked in healthcare domain for Humana and Wolters Kluwer. Good knowledge on claims, provider and lab related data.
• Experience on working with ETL tools like Informatica and SSIS to extract data from heterogeneous data sources and worked on transformations like Expression, Joiner, Sequence Generator, Filter, Sorter, Router, Update Strategy, Aggregator, etc., .
• Proficient in using Microsoft office applications like MS Word, MS Excel, MS Visio, MS Power point.
• Excellent written and oral communication skills, highly organized, able to work independently, hand multiple tasks and analytical skills with abilities in resolving complex issues.
• Exposure to healthcare domain and acquire external certification in AHM 250.
• Externally certified as OCA by Oracle.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g, SQL Server 2012

ETL: Informatica 9.1, SSIS

Methodologies: Agile, Waterfall

Languages: SQL, PL/SQL, UNIX/LINUX shell scripting, Java

Operating Systems: UNIX, Windows XP/7/10

Tools: Toad, SQL Developer, Informatica Power center, Oracle Forms 10g, Oracle Reports 10g, Autosys, Dollar Universe, MS office, Version one, ERwin, SVN, BMC Remedy, SSMS.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Developer/ Analyst

Responsibilities:

• Analyze the data models and develop the DDL scripts to create various database objects and develop the relations between tables.
• Created Database Objects like Tables, Views, Stored Procedures, Functions, Packages, Triggers and Indexes.
• Developing Oracle SQL scripts and developed PL/SQL blocks to execute the business requirements.
• Worked on the incremental data and developed logics to update/insert based on the source and target data.
• Improving the quality of application developing Indexes, partition tables, parallel executions and using hints in Structured Query Language (SQL) statements.
• Worked on database designing and creating the Entity Relationship Diagrams (ERD).
• Worked on designing partitioned and non - partitioned tables and developed scripts to insert/delete/update the data in the partitioning tables.
• Use SCD logics to capture the versions of the changing data and implement merge to upsert to maintain integrity of the data warehouse.
• Data profiling and ensuring data quality between source data and target data.
• Developed SQL loader scripts to load the data into staging tables from the flat files located on the UNIX server.
• Understanding the high level technical design documents and Business requirement specification document.
• Developed UNIX/LINUX shell scripts to automate the file load into oracle database using SQL Loader utility.
• Communication with stakeholders - Business partners and IT Management and involved in code reviews.
• Unit test and validate results of the application.

Environment: Oracle 12c, UNIX, SQL Loader, SQL Plus, Toad, Autosys, ERWin, Oracle Enterprise Manager, UNIX Shell Scripting.

Oracle Developer/ETL Developer

Responsibilities:

• Develop DDL and DML scripts to create various database objects like Tables, Views, Indexes, Procedures, Functions and Sequences.
• Developed SQL loader scripts for the data movement into staging tables using SQL Loader from flat files. Loaded data using export/import data from the tables into dump files using data dump utility.
• Developed data marts for different vendors joining the dimension tables and lookup tables. Building data warehouse by integrating the data marts using complex queries in star schema.
• Experience in developing and maintaining oracle forms and reports.
• Worked on designing partitioned and non-partitioned tables and developed scripts to insert/delete/update the data in the partitioning tables.
• Used SCD logics to maintain version history on the incremental data. Good at using merge statements.
• Improving the quality of application by using Oracle Tuning concepts like creating Indexes, Partition Tables and using Structured Query Language (SQL) hints.
• Data profiling and ensuring data quality between source data and target data.
• Understanding the high level technical design documents and Business requirement specification document.
• Estimating and preparing the plan for development delivery and unit testing (UAT) the application.
• Communication with stakeholders - Business partners and IT Management and involved in code reviews.

Environment: Oracle 11g, PL/SQL, SQL Loader, SQL Plus, Oracle Forms 10g, Oracle Enterprise Manager, UNIX, Autosys.

Oracle Developer/ETL Developer

Responsibilities:

• Worked on the live OLTP calls related data.
• Developed physical models based on the specification documents provided after the logical models are developed by the architects.
• Pull the data from source Microsoft SQL Server database using informatica ETL tool and load into target Oracle database tables.
• Involved in design and development part of Informatica Mappings, Mapplets, re-usable transformations, sessions, tasks (email, decision, command, timer etc.), workflows and worklets; schedule and monitoring.
• Used active transformations and passive transformations based on the business requirement (like Expression, Sequence Generator, Filter, Router, Lookup, Aggregator, Update Strategy, Joiner, Normalizer Transformations etc…) and utilized the optimization techniques to improve the performance of the jobs at mapping level and session level.
• Created SQL scripts to repair client data and/or fulfill client data modification requests
• Apply business logics on the target database to normalize the data in the star schema.
• Build data warehouse for the normalized data joining the tables.
• Applying performance turning concepts at both informatica level and Oracle SQL scripts to achieve the task with in the given timeframe.
• Worked on mapping development, re-usable objects, User Defined Functions.
• Utilized Informatica PowerCenter to extract data from SQL Server and flat files into Oracle tables for Analytics.
• Used active transformations and passive transformations based on the business requirement (like Expression, Sequence Generator, Filter, Router, Lookup, Aggregator, Update Strategy, Joiner) and utilized the optimization techniques to improve the performance of the jobs at mapping level and session level.
• Unit testing the application.

Environment: Oracle 11g, PL/SQL, SSIS, SSMS, Informatica Power Center 9.1, SQL Plus, SQL Loader, Toad, UNIX

Oracle PL/SQL Developer

Responsibilities:

• Analyze the data models of the existing application and work on migration impact analysis of the application from PeopleSoft to Workday.
• Analyze the requirement specifications and design the new data models and develop the DDL scripts to create various database objects.
• Developed scripts which involves complex joins on the dimension and fact tables to design the data warehouse.
• Extensively involved in developing the aggregation logics using various aggregation functions in oracle and used these aggregated data in the developing reports.
• Attend meeting with the vendors and gather the requirements for decommissioning the data.
• Created Database Objects like Tables, Views, Stored Procedures, Functions, Packages, Triggers and Indexes.
• Develop PL/SQL scripts for complex business requirements through analysis, development and testing phases of the application.
• Improving the quality of application by using Oracle Tuning concepts like creating Indexes, Partition Tables, Gathering Statistics, parallel processing and using SQL hints.
• Worked on data hygiene/cleansing to remove the unwanted vendor related information from the database by using many delete statements.
• Purge unwanted tables from the recycle bin to avoid any tablespace issues.
• Create IQs in HP ALM to execute the scripts and share the results with validation leads for approvals to implement in further database environments like QA and PROD.
• Data profiling and ensuring data quality between source data and target data.
• Create CRQs (Change Requests) to debug the flaws in the application. New enhancements will be productionized upon implementing the changes in DEV and QA.
• Conduct code walk-thru of the application to ensure the quality of the application and recommend for any changes.
• Schedule the job runs using Autosys to refresh the data in the database on a daily basis from the up streams.
• Unit test and validate results of the application.

Environment: Oracle 12c, SQL Developer, SQLPlus, UNIX, PL/SQL, ISOTrain 6.4, Autosys, HP ALM, MS Office.

Oracle PL/SQL Developer

Responsibilities:

• Analyzing the requirements and developing the logics to build enterprise data warehouse for the health insurance related data.
• Developing DDL scripts and DML operations using PL/SQL blocks, procedures and functions as per the requirements.
• Created Database Objects like Tables, Views, Stored Procedures, Functions, Packages, Triggers and Indexes.
• Involved in developing complex joins on the dimension and fact tables to design the data warehouse.
• Understanding the functional specifications document and develop the physical data model.
• Create tables and develop the relational structures of various database objects as per the specification document.
• Scheduling the scripts to run in an automated environment by using scheduling tool Autosys.
• Extensively involved in developing the aggregation logics using various aggregation functions in oracle and used these aggregated data in the writing reports.
• Develops PL/SQL scripts for complex business requirements through analysis, design, development, testing, debugging and documentation phases
• Developing the Autosys scripts using JIL language and deploying the scripts in various environments like development, testing and production.
• Extensively used UNIX shells scripts to automate files loads, search patterns using awk, sed and grep commands.
• Managing knowledge gained in utilizing it for other modules.
• Communication to stakeholders - Business partners and IT Management and involved in code reviews.
• Improving the quality of application by using Performance Tuning of SQL queries.

Environment: Oracle 11g, UNIX Shell scripting, SQL Developer, Toad, SQL Plus, SQL Loader, Autosys.

Oracle PL/SQL Developer

Responsibilities:

• Developing PL/SQL blocks and creating stored procedures to load the data into tables.
• Developed SQL scripts to pull data from the source tables and develop complex join queries to load the data into the fact tables.
• Provide data to end users in support of ad-hoc data requests
• Extensively involved in developing aggregation logics.
• Spooling the aggregated data into files and sharing them to the clients.
• Designed workflows for automation using Autosys job scheduler.
• Bug Fixing of the application in various areas before moving the code and scheduling scripts in production.
• Spooling data into flat files and FTP to the remote location.
• Well versed in creating reporting techniques by using various standards when viewing the reports.

Environment: Oracle 11g, UNIX Shell Scripting, SQL Developer, Toad, UNIX, Autosys