- Data Engineer with strong SQL skills, database design, and knowledge of the full Software Development Life Cycle. Takes initiative to drive projects forward, very good at seeing overall situation and adapt development to produce fast output.
- Developed complex logic using discrete polynomial estimation for cumulative density function of beta distribution.
- Promoted to be responsible for requirements gathering, design and project planning across 18 projects, totaling $4+ million.
- Designed and completed new Master Data Management and Enterprise Dimensional Models for the US Naval data warehouse for ship availability and maintenance analytics.
- Completed data integration of 3 major Navy systems, created a new data lake and data mart for 12 metrics in 2.5 months for a 4 star Admiral.
- Created and maintained stored procedures, functions, packages for transaction system as part of workflow management and rule based verification modules.
- Performance tuned queries that did not run to run in 2 minutes.
- Analyzed 6+ data sources for profiling for edge cases in data behavior and format irregularities.
- Wrote scripts in PL/SQL to automate ETL jobs for reporting.
- Created complex mappings, procedures, and packages using ODI 12c ETL tool.
- Selected along with 7 people in the entire company (300+ employees) to take CMMI 2.0 Associate training.
- Processed, cleansed, and verified data integrity used for mastering data across accounting, sales and marketing.
- Database design and management using MariaDB 5.3. ETL data from money wire transfer system and created reporting database to facilitate monthly and end of year reports to the IRS.
- ETL data from Point of Sales system to create and maintain master transaction, product, customer tables for accounting analytics and marketing campaigns.
- Wrote scripts for data mining customer profile information to anticipate inventory, sales and marketing intelligence.
- Increased sales by 20 % Implemented POS system to maximize efficiency of cashiers and facilitate creation of database for reports.
- Conducted internal auditing analytics to prevent money laundering.
- Increased money wire income by 25% after introducing customer profile cards/ ids.