Database Developer Resume

SUMMARY

Proactive, conscientious, and self - motivated Data Analyst. Bring in up-to-minute tools and knowledge in collecting, interpreting, cleaning, analyzing and visualizing data.
Recent graduate with a Master’s degree in Computer Science. 6+ years of experience as a Database developer familiar with data, designing databases, recognizes patterns, writing SQL queries, and optimizing queries for greater efficiency.
Collaborated with a diversified group of people ranging from clients to end users.

TECHNICAL SKILLS

Data Manipulation & Visualization: pandas, matplotlib, seaborn, Plotly, NumPy, Beautiful Soup, Tableau

Languages: SQL, PL/SQL, C, C++, Java, Python, R

SQL Tools: Toad, PL/SQL Developer, SQL * Loader

Databases: Oracle11i, MongoDB, PostgreSQL, SQLite

Other Tools: VISIO, Eclipse, Visual Studio, GitHub, MS Excel (VB Scripting, Pivot tables), Flask

Web Technologies: HTML, JavaScript, XML, CSS, Perl, D3.js, Bootstrap, Leaflet.js

PROFESSIONAL EXPERIENCE

Confidential

Database Developer

Responsibilities:

Meticulously designed the Dwelling Fire (DWF) data collect which resulted in the automation of the collection of relevant data from the database tables, that is used by the NPS system to process the DWF policies.
Undertook development of Policy Cancellation (PCAN) process. Found discrepancies in the design, improvised the design to eliminate the discrepancies and flawlessly implemented PCAN.
Developed procedures to update the Staging database for the usage of agencies and agents.

Environment: Java, Agile, Windows 10, Oracle, Toad

Confidential

Database Developer

Responsibilities:

Created Oracle Objects, Stored procedures, packages, views, and triggers.
Profoundly worked with high-performance PL/SQL features such as REF Cursor, Composite Data Types such as Records, Collections, Bulk Collect and Autonomous Transactions.
Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, V arrays, Records, Materialized views, Dynamic SQL.
Developed scripts to migrate data from flat files to target tables performing required validations on the data using ETL.

Environment: Windows 7, JAVA, TOAD, SQL, PL/SQL, Git Hub, Oracle Forms 10g, Oracle Reports 10g

Confidential

Database Developer

Responsibilities:

Developed backend processes using SQL, PL/SQL and dynamic SQL to create Oracle Objects, Stored procedures, packages, views, and triggers.
Generated reports using Oracle Reports.
Actively involved in performance tuning task force team, fine-tuning all the affected processes, which would have High I/O Cluster, waits, Poor Explain Plan, High CPU Cost. Reviewed (by generating trace files, explain plans etc.) and modified (or redesigned) the existing programs to drastically increase the performance.

Environment: JAVA, XML, Agile, Windows, IE, TOAD, SQL, PL/SQL, Oracle Forms 10g, Oracle Reports 10g.