SUMMARY:

• Lead SQL Developer and Data Modeler, and ETL specialist on teams and projects spanning many diverse applications, and solutions architectures
• Mentor Data Warehouse teams for meeting SQL and enterprise data management standards and best practices - optimizing ETL and SQL workload, indexing, and the table relationship ERD design if reduction of CDC change data capture overhead merited
• Apply a career of database development project success, in assuring my team s appropriate conceptual and logical data modeling met requirements, and implementation of business rules in the SQL and ETL solutions was effectively mapped, tested, and delivered between source and target systems.
• Platforms (Teradata, Oracle, SQL Server, Hadoop, Progress); ETL/SQL and BI tools (SSIS, Infomatica; SSAS, SSRS; PL/SQL; TSQL; Cognos) Modeling Middleware (ERWin; OpenEdge ABL; Rational Rose)

TECHNICAL SKILLS:

Data Warehouse Development: (SQL Server 10 yrs; Oracle 4 yrs; Teradata 1 yr)

SQL/ETL and BI Tools: - on Microsoft (TSQL 11 yrs, SSIS 6 yrs, SSAS 3 yrs, SSRS 1yr); on Oracle (PL/SQL 6 yrs); on Teradata (1.5 yr); on Cognos (1 yr)

Data Modeling: (ERWin 18 yrs; Rational Rose 1 yr)

PROFESSIONAL EXPERIENCE:

Data Architect

Confidential

Responsibilities:

• Delivered a data reengineering success consolidating core systems (HR etc) for cloud services integration, while leading data team efforts (data mapping, data modeling, and ETL) for parallel development of a new UPG historical data warehouse (SQL Server, TSQL; Oracle PL/SQL, SSIS; ERWin).
• Data Modeled a new Financial Data Warehouse, and built the supporting BI Analytics ETL framework for housing a School of Medicine grant,, and revenue budget reporting system (SQL Server, TSQL; SSAS, ERWin)
• Data Systems Architect, Data Warehouse Review Board Lead at Confidential & Co. (Financial Services, TATA consultant) 2 yrs 6 mo
• Responsible for helping SQL Solution and ETL teams prepare for, and obtain build approval - leading up to 50 design reviews per month at one of the nations largest financial services firms. Assured enterprise data warehouse SQL Standards were applied - and in line with the data modeling, and ETL data flow design (Oracle; Teradata; ERWin; Cognos)
• Delivered a very high velocity and big data traffic solution design for cross enterprise domain sign-on and session activity monitoring - Data Modeling the event tracking alert back end database (Oracle; Exadata; ERwin)
• Solved the complex business rules of online Mortgage Servicing in a web services and service oriented architecture environment, that included federal agency data exchanges (BPaaS) for nationwide loan qualifications (ERWin; Oracle, PL/SQL; SQL Server, TSQL; Progress OpenEdge ABL)

Enterprise Data Modeler

Confidential

Responsibilities:

• Met Basel II mandates for integrating enterprise financial data, gathering business requirements and proposing technical designs in daily Scrum sessions following Agile methodology.
• Data modeled and delivered SQL implementation builds for risk exposure and capital reserve reporting solutions. Schema designs were primarily integration star - schema (Oracle; ERWin).
• Finalized the project team s database development and deployment SQL in middleware, for build out PL/SQL script versioning, and for presenting along with metadata to governance teams.

Data Modeler, BI Developer

Confidential

Responsibilities:

• Managed the load scale and complexity of consolidating big data - data modeling for the multi-state consolidation of Medicaid Provider and Recipient claims (new ODS schema), and for the corresponding BI analytics semantic platform (new EDW schema) - with KPI perspectives across many tiers and hierarchies (ERWin, Oracle, SQL Server).
• Solution engineered with Data Architect an advanced cross platform data management framework, and wrote SQL optimized for ETL source queries in order to manage nightly loads into both the new ODS, and downstream EDW - with many transformations needed for multi-dimensional fact schemas. Load scalability was critical in order to accommodate the claims refresh data, and corresponding mass update of
• Federal Rebate Quarterly Pricing; the daily master data for FDA Rx dispense compliance and licensed Providers; and the rates for contracts based on tiered formulary or manufacturer basis points (Oracle PL/SQL; Infomatica; SQL Server TSQL).

DBA, BI ETL Developer

Confidential

Responsibilities:

• Success in post 2008 retail downturn was delivering a solution design for deep PnL analytics of sales against incentives and offers, and product promotion campaigns, which helped grow company revenue in difficult retail times. Built ETL for new data models, and cube KPI measures, and presented weekly to Executive Leadership team for Agile project delivery of analytical company BI dashboards.
• Applied my ETL framework and SQL optimization skills in delivering the tuning and server load reduction to allow full multidimensional database reloads and cube refresh to be done in peak sales hours, for agile near real - time analysis of web sales offer price changes against product taxonomy - key for analytics strategy (SQL Server, SSIS, SSAS, SSRS, TSQL, ERWin).