PL/SQL Developer Resume Hartford, CT - Hire IT People

EXPERIENCE SUMMARY:

7.5 Years of experience in Development of Data Warehouse applications in Insurance domain.
Experienced in building Relational, Dimensional Data Warehouse.
Skilled in Automating repeated development activity.
Core member for conducting peer code reviews.
Proven ability in data analytics and data mining.
Familiar with Agile, Water - Fall and Hybrid methodologies.
Good Experience in ETL Framework.
Technical Experience in PL/SQL, C++, C#, Shell Scripting, Informatica.
Experienced in developing Desktop Application using C#.NET, Universal Windows Store App (XAML/C#) development.

TECHNICAL SKILLS & TOOLS:

CAREER PROFILE:

Confidential, Hartford, CT

PL/SQL Developer

Responsibilities:

Designed the DataMart for the New Application.
Developed PL/SQL packages to produce the reports from Warehouse with specific point in Time.
Built the data for Reporting in Multiple Layouts to get better understanding of data.
Created C#.Net prototype for Executives who can use their voice command to filter, refresh the data in Dashboard.
Built My Own Voice Assistant using C#.Net to automate my regular activities like Timesheet filling, Launching Favorite Websites, Searching in DataWiki a sharepoint site, Downloading reports from Portal.

Confidential

PL/SQL Developer

Responsibilities:

Analyzing the data available in the existing system to build the new application Built the prototype using VB.NET for library changes in SAS code which can update the library for many files at a time.
Rewrote the SAS code into Teradata SQL to improve the performance.
Implemented and integrated of the new application with the existing system

Confidential

PL/SQL Developer

Responsibilities:

Developed Dynamic PL/SQL packages to handle multiple Lines of Business.
Tuned the PL/SQL code for better performance of the application which was running for more than 10 hrs.
Rewrote the existing code in C++ with PRO*C , improve Performance by executing the Oracle Procedures in threading and handled 3 projects in parallel. Analyzed the Data from downstream application to bring back to the required applications during the emergency situation like Oracle Database Crash.
Developed new approach to simulate the daily ETL process includes Informatica , PL/SQL Procedures, Linux Shell Scripting in bulk mode.
Handled the issues which are arrived during the simulation of daily process into bulk process to make data available as daily processed data.
Developed VB.NET Application to automate the process of Retrofit development (Oracle Table Structure Changes) using Mapping documents as input.
Developed VB.NET Application to modify the Informatica Mapping (XML Files) based on the inputs in Mapping Documents provided by Data Modeller.
Developed C#.NET Application a frontend tool to compare the Database objects and dependency tracing in multiple environments and generate the report.
Completed MAPR Course for Hadoop Developer and obtained Certificate
Provided by MAPR Academy.
Developed Linux Shell Scripts to generate Autosys Jil Scripts using parameters.

Confidential

PL/SQL Developer

Responsibilities:

Developed complex Informatica Mappings and Workflow to load data.
Developed PL/SQL packages containing several Procedures, Functions, Triggers, Cursors, Control Statements, Exceptions and Oracle bulk collect statements.
Identifying the performance bottlenecks and solving the issues in time to meet our SLA.
Developed UNIX shell scripts for file transfer, job automation, Code Migration between Environments.
Developed test cases and performed unit test for the code.
Documented the activities performed during the development and testing phase.