Data Warehouse Architect/Developer Resume

SUMMARY

Worked as Senior Software Engineer for Various Clients in Agile Development teams.
Experience with Oracle 8i/9i/10g, 11g, 12c - Exadata databases creating PL/SQL packages, procedures, functions, and triggers, as well as Oracle Analytic functions to create complex queries for views and reports.
Experience in creating Oracle code review checklist which defined PL/SQL coding standards, best practices, and process workflows for all PL/SQL code being released to production.
Experience in creating and supporting all development, QA, and production on Windows, Unix, and Linux platforms.
Experience in building .NET software release using Microsoft Visual Studio 2010 on Microsoft Internet Services servers and MS SQL Server 2008 written in C#, XML, Subversion (SVN), and TortoiseSVN for version control.
Worked closely with developer/analysts and talked in-depth with clients in a support role using the Agile Software Development methodologies.
Experience in mentoring new developers.
PostgreSQL DBA experience
Working knowledge of PostgreSQL third-party tools

TECHNICAL SKILLS

Oracle 8i/9i/10g, 11g, 12c - Exadata, PostgreSQL9.6, EnterpriseDB Postgres Advanced Sever9.6, SQLLDR, SQL Navigator, C#, .NET, Erwin, ETL, SQL Plus, PL/SQL, TOAD, Oracle Enterprise Manager, Postgres Enterprise Manager, Visual Basic, StarTeam, Rational ClearQuest/ClearCase, Rally, Microsoft Visual Studio 2010, SQL Server, Java, C/C++, HTML, CVS - Concurrent Versions System, Kentico CMS, Apache Subversion (SVN), TortoiseSVN, Redmine, Salesforce, Oracle VirtualBox, Tableau
Windows 98, Windows NT, Windows 2000, Windows XP, Windows 7, Windows 10, DOS, iOS, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential

Data Warehouse Architect/Developer

Responsibilities:

Migrated all Database objects used in Actuate reporting tool to new Oracle 12c - Exadata Data Warehouse schema and designed custom ETL process to migrate all the data from old schemas to new Warehouse.
Created new DDL for tables and DML for packages, procedures, functions, etc. using pl/sql.
Responsible for unit testing all code being migrated.
Performance tuned any SQL not running satisfactorily.

Confidential

Oracle Data Warehouse Developer/Analyst

Responsibilities:

Create business requirements, design documents, and mapping documents.
Hands on working with Oracle12c-Exadata PL/SQL in large Teradata Warehouse
Responsible for all aspects of Development Life Cycle from design to deployment in Production.
Worked on a few support tasks as well as system, schema, and SQL tuning.
Work with Unix shell scripts for running jobs and Control-M to schedule jobs.
Use Tortoise SVN for version control.
Work closely with development partners and business partners.

Confidential

Sr. Support Engineer/Oracle Developer

Responsibilities:

Responsible for fixing any coding and/or performance issues with pl/sql in migration of Oracle databases to EnterpriseDB products.
Work directly with customers to provide in-depth technical troubleshooting and recommend appropriate workaround(s) and solutions for all EDB product lines and open-source PostgreSQL products
Collaborate with and mentor 1st and 2nd level engineers to triage issues, create reproducible test cases, file bugs, and offer patches when possible
Interact with members of our Engineering team, many of whom are core members and major contributors to the PostgreSQL community, to identify opportunities for product enhancement and product fixes.
Serve as the primary point of contact to our premium customers
Document solutions, whitepapers and standards for customers as well as for internal use
Manage issue escalations between Support and Engineering teams.
Work with managers to drive process and organizational improvements