Database Developer Resume CA - Hire IT People

SUMMARY

Over15years experience as a result oriented software developer wif high - volume manufacturing companies and as anentrepreneur.
Extensive experience in analysis, design, development, customization, implementation, tuning, testing and support of Oracle based business applications and mapping complex business logic to efficiently working code.
Strong mathematical and problem solving skills. Extremely proficient at designing, developing and implementing backend and middleware algorithms of any nature and complexity using object oriented and non object oriented paradigms such as PL/SQL stored procedures, C++ and Java beans.
Over a decade of experience performing customizations to Oracle EBS Supply chain modules (Order Management, Inventory and Bills of Material) using PL/SQL. Pro*C and Oracle Forms.
Co-authored three academic papers in Supply Chain Manufacturing and Optimization.
Modest experience in Project Management and Customer Support.

TECHNICAL SKILLS

PL/SQL Stored Procedures for OLTP environments: Triggers, Collections, Ref Cursors, Analytic Functions, Hierarchical Queries, Common Table Expressions, Merge, Regular Expressions, Pipelined Functions, XML processing, Deterministic Functions, Performance Tuning for rows ranging from several thousand to several billion.
Data Modeling and Normalization, Transaction Management and implementing business logic using EJB, Core Java, ETL, C++, Pro*C.
Oracle Database 12c - Toad, SQL*Developer, SQL*Plus, UNIX, Windows.
Shell scripting, UNIX sed/awk, SQL*Loader, Data Warehousing, Goldengate, Oracle Text, XQuery / FLWOR expressions, Business Analysis, Informatica Powercenter.
Multi-dimensional Modeling, OLAP, Business Intelligence, XML DB, Encryption, DBMS Scheduler, Data Mining, JavaScript, Hadoop Ecosystem.

PROFESSIONAL EXPERIENCE

Database Developer

Confidential, CA

Responsibilities:

Performance tuning of reports dat use T-SQL stored procedures.
Achieved significant improvement in teh performance of several time intensive case related queries using CTE, parallelization and indexing involving billions of rows.
Developed several PL/SQL packages for performing CRUD operations on teh underlying tables using pipelined functions and XQuery for .NET based Food Stamp Application forms.
Designed and implemented an advanced algorithm to merge welfare cases wif in-place updates to hundreds of tables and XML maps. Teh algorithm sifts through millions of rows on a daily basis performing updates in an efficient manner.
Front line production support for overnight processing of daily batch of welfare cases received from teh state of New York. Teh batch job processes approximately 100K transactions on a daily basis.
Developed and maintain a DOS batch script to copy cases from production to teh test environments - Teh script automates a number of steps dat were performed manually before calling a host of PL/SQL packages and functions in turn.

Lead PL/SQL Developer

Confidential

Responsibilities:

Lead Developer for teh Ginnie Mae Enterprise Portal GMEP 2.0 for teh Issuer Management (IM) project for GNMA mortgage backed securities program. Followed SDLC including gap analysis, UI design (mockups), writing detailed technical specifications, schema design, database mapping and creation of stored procedures to support teh entire Issuer life cycle from onboarding to a fully operational entity.
Designed and developed teh entire set of PL/SQL packages and procedures to support teh IM User Interface (Java ADF), Sales Force Integration via web services (Informatica, Oracle SOA suite), Legacy DB2 and VSAM Integration (Informatica), Auditing and Concurrency Management. Performed unit testing, coordinated wif testers for QA and end users UAT environments as well.
Developed several SQL scripts and PL/SQL procedures to support Goldengate synchronization from a normalized OLTP database to teh Enterprise Operational Data Store to propagate transactional and reference data to consolidated one-stop locations.