SUMMARY

Highly talented and results - oriented technology professional with experience in all facets of architect management, decision analysis, workflow operations, and business information systems. Skilled in driving effective communications throughout organizational levels with the ability to integrate design data and solution standards in achieving business goals. Repeated success building and fostering long term partnerships, collaborating with service providers in driving performance and enhancing data management. Demonstrated proficiency translating business needs into digital tools like Data Management and Analytics. Expertise identifying trends through data analysis, developing new framework for mining data and structuring information focused on improving data governance.

AREAS OF EXPERTISE

• Strategic Planning & Analysis
• Data Warehousing
• Solution Architecture
• Data Analytics
• Business Intelligence
• Requirements Analysis
• Organizational Development
• Team Leadership/Communications

TECHNICAL SKILLS

Languages: PL/SQL, SQL, T-SQL Java, UNIX Shell Scripting, PERL

Database: Oracle 12c/11g/10g, SQL Server, Oracle Exadata, Azure SQL Datawarehouse

Database Tools: Oracle ODI 12c, Azure Data Factory, Oracle OBIEE 11g, Erwin

PROFESSIONAL EXPERIENCE

Data Architect

Confidential, Saint Petersburg, FL

Responsibilities:

• Execute the design and development of customized Mortgage DataMart for Residential Mortgages which were used for Financial Analytics and GL Reporting
• Assisted the Business Team in developing and deploying new data models for loans servicing and CECL Analytics reporting, accomplishing organizational goals through the maximization of technology applications.
• Orchestrated the design of best practices utilized in ODI file loading mechanism using ODI packages, variables and DB Tables to make a generic process.
• Orchestrated Azure Data Factory Pipelines for On-cloud ETL processing leveraging multiple activities such as Data Flow, Copy and For Each activities to load into SQL Datawarehouse using T-SQL Procedures.
• Created custom Azure Data Factory to load data into Azure SQL Data Warehouse using External Tables on Azure Blob using T-SQL and Polybase.

Senior ETL Developer/Data Lead

Confidential, Tampa, FL

Responsibilities:

• Orchestrated the design of custom ODI interfaces for BLT file loading, securing tables from multiple files containing different level of granularity.
• Developed ODI Knowledge Modules, creating user interfaces and packages for use within the NBA Cort project containing incremental loading logic and error handling techniques.
• Customized ODI interfaces for strata tables loading incorporating loading incorporating multi-table quires and pivot logic, maintaining data structures through optimized systems.

Senior ETL Developer

Confidential, Mountain View, CA

Responsibilities:

• Designed ODI ETL for OBIA modules including AP, AR, and GL fact data, in addition to dimension data loads for SDE and SIL mapping.
• Conceptualized the design of custom ODI procedures in building partitions based upon incoming data as a pre-process to the ETL load.
• Created custom ODI Knowledge Modules for ETL of DRM system used for hierarchical flattening and utilizing SCD2 techniques.

Senior ETL Developer/Data Lead

Confidential, Glendale, CA

Responsibilities:

• Analyzed the source system (Claim Center) to understand the source data and table structure along with deeper understanding of business rules and data integration checks.
• Created the normalized logical and the physical model with transactional facts, aggregated fact tables and the dimensions.
• Developed ODI Packages and interfaces for loading the dimensions and facts from various Source tables
• Developed new ODI Package, interfaces, procedures and variables for Policy Monthly Aggregated Snapshots.

Application Architect

Confidential

Responsibilities:

• Developed new ODI Package and multiple Interfaces and implemented ETL and data Validation for Historical load of Policy and Claims Data.
• Performance tuning of Dashboard/Reports and made changes to database by implementing materialized views and partitions, rebuilding of indexes.
• Developed new Data Model for OII for 8.0 release based on Requirement by Business.
• Performance tuning of Dashboard/Reports and made changes to database by implementing materialized views and partitions, rebuilding of indexes.

Oracle Application Consultant

Confidential

Responsibilities:

• Developed new Packages and front end using PL/SQL, MOD PL/SQL and Perl programming to automate file loading for transactions into the ehub system
• Developed New Packages for updating of User Validation tables implementing data validation process along with different criteria’s for update process for different tables.
• Worked on FBW conversion project to implement new GRA to old GRA conversion e-Hub.
• Moved over 100k transactions during the change.
• Worked with the Business team for gathering requirements for providing High level estimations and precise logic was applied and converted into Functional Documentation and Technical design documentation.

Consultant

Confidential

Responsibilities:

• Provided classroom training for SQL and PL/SQL for experienced professionals on Oracle 10g/Oracle 11g environment.
• Developed project on PL/SQL and Java on financial loans and for financial accounting systems.
• Provided classroom training for Oracle DBA and for OCA and OCP 11g certifications; also including new feature in Oracle 11g.

Senior PL/SQL Developer

Confidential, San Francisco, CA

Responsibilities:

• Implementation of the new CA Tools interface by interacting with Materialized views via Data pump where complex materialized views for CA Tools based on the different type of wholesale loans as specified by the business users.
• Worked on Creating new PL/SQL Packages and Procedures for the AU-SU Changes for the LNU reports to run on the architecture framework.
• Developed Stored Procedures, Packages, and Functions for CMS interface using PL/SQL using an architectural framework.

Oracle Developer

Confidential, Fresno, CA

Key Contributions:

• Responsible for coding stored procedures, functions and triggers and other scripts based on functionality of the user Eligibility using PL/SQL.
• Created new custom Loading mechanism for multiple TPA’s to load Eligibility files in a predefined format.
• Participated in data sourcing, extract data investigation process, work with teams to develop PL/SQL, code to extract, clean and sort data for flat file generation.
• Improved Query performance by using EXPALIN PLAN and TKPROF and SQL Trace tuning tools as well as using table Partitioning.