Database Developer - Intern Resume - Hire IT People

SUMMARY

Graduated from University of Central Missouri done my master’s with Data Science Specialization, Seeking Full time position available to join immediately.
Result - oriented professional having 3.3 years of Experience on data warehousing in analysis, design, development and providing support for software applications using Informatica Designer 8.6 and 9.5.1, ORACLE (10g,11g), UNIX, Tableau.
Monitored and scheduled daily, weekly and monthly batch jobs through Autosys in UNIX environment.
Good knowledge on data warehousing tools - Informatica & Tableau .
Knowledgeable in UNIX, Autosys, HP Service Manager, Oracle(10g,11g), SQL, PL/SQL.
Knowledgeable in BO and OBIEE reporting tool.
Good Knowledge on Big Data, Machine Learning, R.
Working to improve my skills on Python, Hadoop and Data Science related technologies.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Database Developer - Intern

Confidential

Responsibilities:

Worked on Fuel SMS a student search engine project. Was part of a development team, provided back end support and worked on Database Design and Development part of the project.

Senior Software Engineer

Confidential

basically has the following modules: Funds Transfer Pricing, Profitability Management, Assets and Liability Management and Balance Sheet Planning.
The old application is running in OFSA 4.5 which only captured reports for westwards data (Union Confidential ).
The scope of the work is to load pre-staging tables from different data marts.
Sources for pre-staging tables is CDW, EDW, Green Plum, flat files & Sql loader scripts.
Pre-staging tables load is followed by staging tables & then processing tables which is loaded by OFSAA application.

Returns Manager

Confidential

Responsibilities:

Designed and developed ETL mappings, extensively used various transformations to load warehouse data.
Extensively worked on data extraction, transformation and loading data from various sources like Oracle, Greenplum SQL loader and Flat files.
Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
Used workflow manager to create task and used workflow monitor to monitor and analyse the loading statistics.
Created reports using Tableau reporting tool as per client requirements of deliverables.
Created shell scripts for triggering workflow & updating parameter files used in workflow.
Involved in creating metadata tables containing the statistics of load timing, workflow status & audit information.
Evaluated all functional requirements and map documents and performed troubleshoot on all development processes.
Experience in database programming in PL/SQL (Stored Procedures, Functions and Packages), SQL and Oracle.
Analysed the flow of data and created analysis document for defects.
Involved in defect fixing which were found in System Integration Testing and UAT environment & ensured streamline flow of deliverables to production.