Data Project
Resume:
Belide Rohan
Oracle PL/SQL Developer
ac0ak3@r.postjobfree.com
Professional Summary:
Designated as IT Analyst with 5 years of experience at Tata Consultancy Services.
Extensively worked on data warehousing by developing SQL scripts joining complex tables.
Responsible for all activities related to the development and implementation for large scale data warehouses.
Had experience in data modeling using Star Schema Modeling, and FACT and Dimensions tables.
Good knowledge on indexes, storing data in partitioned tables and performance tuning and dynamic SQL.
Good experience in creating dashboards using APEX.
Actively involved in developing all the phases of SDLC.
Strong skills in Data Analysis, Data Requirement Analysis and Developing scripts for processes.
Hands on experience in performance tuning, identifying and resolving performance bottlenecks.
Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.
Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages).
Well versed in UNIX shell scripting.
Experienced at Creating Effective Test data and development thorough Unit test cases to ensure successful execution of the data.
Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.
Proficient in Data Cleansing techniques, Microsoft Office Suite, including Excel, SharePoint, Outlook, PowerPoint, graph making, formulas, pivot tables.
Technical Skills:
RDBMS: Oracle 11g, Toad, PLSQL Developer
ETL Informatica 9.1
Database skills: Stored Procedures, Database Triggers, Curser, Packages
Languages: SQL, PL/SQL, UNIX
OS: UNIX, Windows
Tools: Dollar Universe, Control-M, Visio, Autosys, MS office
Work Experience:
Project Intelligent RX
Period April 2015 December 2015
Client Name Humana Inc.
Position Developer
Responsibilities
●Developing Oracle SQL scripts and writing PL/SQL blocks to execute the business requirements.
●Used SCD logics to insert/update the target tables for the incremental data.
●Improving the quality of application by using Performance Tuning concepts.
●Data profiling on source’s data and ensuring data quality between systems.
●Writing SQL loader scripts to load the data into stage tables from the flat files.
●Spooling data into flat files in the UNIX server and FTP the files to remote location.
●Understanding the high level design documents and Business requirement specification document.
●Estimating and preparing the plan for development delivery.
●Communication to stakeholders – Business partners and IT Management
●Unit testing.
Description Intelligent RX project is a development project with team size of 3 associates. The project involves activities to build data warehouse for incremental data by applying business transformations for various upstream data sources such as patient coverage, drug claims, patient demographic details, medical claims, medical claim codes and lab details. The incremental data extracted for these processes will be shared to the clients after exporting the data into flat files.
Project Lab Improvements
Period July 2014 March 2015
Client Name Humana Inc.
Position Developer
Responsibilities
●Developing SQL loader scripts to load the data into staging tables using SQL Loader from flat files.
●Developing data marts for different vendors using PL/SQL blocks and SQL queries by joining the dimension tables and lookup tables.
●Building data warehouse by integrating the data marts using complex queries.
●Improving the quality of application by using Performance Tuning concepts.
●Data profiling on sources data and ensuring data quality between systems.
●Understanding the high level design documents and Business requirement specification document.
●Estimating and preparing the plan for development delivery.
●Unit testing.
●Communication to stakeholders – Business partners and IT Management
Description The project lab improvements is a development project with a team size of 7 members. The project involves in creating multiple data marts for various vendors which leads in creation of a final data warehouse for lab data which deals with the data of Enterprise data warehouse. Lab improvements solution is to build the reports on lab data which comes from different vendors or source systems like Oschener, Advocate etc.
Project Intraday calls
Period March 2013–June 2014
Client Name Humana Inc.
Position Developer
Responsibilities
●Build star schema data warehouse for the live OLTP calls related data
●Pull the data from source server where the de-normalized data is stored in the Microsoft SQL Server database using informatica ETL tool and loaded into target Oracle database tables.
●Apply business transformations on the target data to normalize it using pivoting concepts.
●Build data warehouse for the normalized data joining the tables using SQL scripts.
●Applying performance turning concepts at both informatica level and Oracle database also.
●Developed Logical and Physical model design and created SQL development scripts.
●Involved in business analysis and prepared the Detail Design Document (DDD), data mappings document, developed the technical specifications and involved in the design part using Visio diagrams.
●Worked on mapping development, Mapplets, re-usable objects, User Defined Functions.
●Utilized Informatica PowerCenter 9.1.0/9.6.1 to extract data from various sources like Flat files, Mainframe files and CSV Files into staging tables and loading transformed data into Oracle environment for Analytics.
●Used active transformations and passive transformations based on the business requirement (like Expression, Sequence Generator, Filter, Router, Lookup, Aggregator, Update Strategy, Joiner etc…) and utilized the optimization techniques to improve the performance of the jobs at mapping level and session level.
●Unit testing.
Description Intraday calls is a development project with a team size of 3 associates. It deals with the data that is related to the calls that are done between the customer and Humana operators. This is an OLTP project where the source database is refreshed every half an hour. All the business transformations, ETL logics and table refresh are to be made within this 30 minutes. The data that is finally extracted from source, transformed and loaded into the target fact tables is used by a Qlikview application to create dashboards and represent the data to the clients for the areas of improvement for the business expansions. Entire process is completed in 30 minutes and Qlikview application will generate a dashboard for the refreshed data residing in the target tables.
Project Enterprise DWH/T&C ADHOC
Period April 2012–February 2013
Client Name Wolters Kluwer
Position Developer
Responsibilities
●Analyzing the requirements and developing the logics to build enterprise data warehouse for the health insurance related data.
●Developing PL/SQL blocks, procedures and functions as per the requirements.
●Involved in developing complex joins on the dimension and fact tables to design the data warehouse.
●Understanding the functional specifications 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 reports.
●Developing the autosys scripts using JIL language and deploying the scripts in various environments like development, testing and production.
●Unit Testing.
●Managing knowledge gained in utilizing it for other modules.
●Communication to stakeholders – Business partners and IT Management
●Improving the quality of application by using Performance Tuning concepts.
Description The Enterprise DWH/T&C ADHOC project main purpose is to build Data Warehouses for different vendors by applying various transformations on dimension and fact tables. The later part of the project is to generate reports from the fact tables. The reports are generated periodically and the adhoc reports were generated on demand.
Title T&C ADHOC
Period February 2011 March 2012
Client Name Wolters Kluwer
Position 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 load the data into the fact tables.
●Extensively involved in developing analytical and aggregation logics.
●Spooling the aggregated data into files and sharing them to the clients.
●Unit Testing
●Bug Fixing of the application in various areas before moving the code and scheduling scripts to production.
●Spooling data into flat files and FTP to the remote location.
●Well versed in creating reports by using various standards when viewing the reports.
Description T&C ADHOC project main purpose is to build the database objects as per the customer requirements and pull the reports and share them to the client in an adhoc request. All the reports were generated manually without using any automation tools. These reports which are spooled into the UNIX server are FTP’d to the remote location. These reports are analyzed by the clients and are used in their business analysis.
Education
Masters in Computer Science at Rivier University – Nashua, NH – GPA – 3.5, Year – 2017
Bachelors in Computer Science Engineering at Guru Nanak Engineering College – Hyderabad, India, Year – 2010
Contact this candidate