OBJECTIVE:

• To contribute to the success of a business through meeting and exceeding the requirements of internal and external customers in the area of data warehouse and OLTP design data analytics data transport to/from relational, appliance, and NOSQL databases data management and government database development business intelligence

SUMMARY:

• Data Architect with proven ability to bridge your business and technical teams, using a host of approaches, including AGILE and new databases, such as NOSQL
• ORACLE DBA Oracle Certified Professional, solid experience with Teradata, SQL Server, DB2 LUX, Cloudera Apache Hadoop CDH5, and Sybase ASE
• Experienced in developing coding and design standards, processes, and quality controls (including those required for SOX compliance)
• Certified Business Intelligence Professional (CBIP) in Data Analysis and Design
• Finance MBA (4 courses left)
• Knowledge of a variety of backend and front - end Business Intelligence and ETL tools and methodologies to adapt to your business’s needs
• 15+ years database administration and design experience, 7 years of structured development experience, 1 year of O-O development, 5 years leadership of technical teams, both domestic and off-shore

TECHNICAL SKILLS:

Technology and Tools: Database Knowledge Oracle 10x and 11x Sybase ASE 12 SQL Server 2014 DB2 LUX 10 HBase Impala 2.2.x Netezza 7.0.x Teradata 14.1 Apache Hadoop MongoDB 3.6 Database Development Stored Procedures Entity Relationship Diagrams Triggers Data Normalization Performance Tuning Data Security Creating database objects DDL, DML Data Modeling Dimension and Fact Modeling 3rd Normal Form Column Store Design Business Intelligence Tools Microsoft Analysis Services SSAS Microstrategy (from backend) Tableau Qlikview Business Objects Unix Scripting ETL Tools Informatica DTS Data Transformation Services SSIS Sqoop Hive Impala MongoDB shell Data/System Architecture tools Systems Analysis methodologies ERWin 4x, 7x, 8x, 9x Data Warehouse Design Sybase Powerdesigner 16 UML CASE Process Modeling Informatica Data Profiler 9.x Embarcadero ER/Studio Data Architect 10.x Development Knowledge XML Perl Shell scripts Impala shell Java JSP Industry Knowledge Finance Retail Catalog Health Care Insurance Distribution both US and import/export Light Assembly Mortgage Industry Biotechnology Telecommunications both Cable and Telephony Electric Utility Government Platform Knowledge Unix NT

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect

Responsibilities:

• Developed proof of concept usingHadoop (CDH4),Flume, andSqoopas well asmysql5.5database to take data from Social Media aggregator intoHadoop. Ported it into the data warehouse for analysis withPentaho.
• AnalyzedDatasiftandKloutsources as well as both the Facebook and the Twitter API.
• Initial data model (dimensional for BI piece) created, analysis performed againstHadooploaded via Flume and analyzed via Hive.
• Evaluated MongoDB 3.2 for use in tagging certain fields from unstructured dynamically-generated xml object to provide additional cross-selling insights.
• Developed JSON data model to support requirements and optimize Mongo DB queries. Developed queries to extract from ORACLE 11g to populate the Mongo collections.

Confidential

Enterprise Data Architect

Responsibilities:

• Designed Conceptual, Logical, and Physical data models using Erwin 9.x to meet project requirements and enterprise design framework. Documented data structures and generated Data Dictionary. Performed reviews with business, ETL developers, management and colleagues. Mentored more junior colleagues on dimensional design principles.
• Reviewed APIs (JSON) written for data accesses for performance, correctness, and extensibility.
• Partnered with Data Governance team to standardize definitions of entities and attributes utilized for the project across the enterprise.
• Wrote ETL mappings, storing them in the Data Model and modifying them or generating them as “source of record” for lineage and transformations.
• Developed Kimball Enterprise Bus Matrix from previously designed candidate conformed dimensions to document and improve reusability.
• Ported data from SQL Server 2014 databases and ORACLE 12C Exadata databases for data analysis and designed ETL mappings for execution with ORACLE ODI ETL processing.

Confidential

Principal Data Architect, SQL and NOSQL

Responsibilities:

• Modeled and prototyped (in JSON) account, performance, entitlements for MongoDB 3.6 collections to support Wealth Management client portfolio reporting for redesign and re-integration of key applications via services and micro-services.
• Analyzed ORACLE 11g stored procs, materialized views, and tables to translate the structures and business logic from RDBMS to NOSQL database and Pentaho ETL.
• Trained and mentored development colleagues in translating and writing NOSQL queries vs legacy RDBMS.
• Maintained source to target mappings, ETL logic, and Mongo DB data dictionary.

Confidential

Data Architect

Responsibilities:

• Ported the complex ETL logic from multiple layers of SQL Server 2014 procs and views into Hadoop using an SCD2 ODS and Hadoop Impala accessed through Hue 2.2.
• Supported Data Governance initiative by documenting discrepant data and ETL logic for same business element. Logged discrepancies and reported to business for resolution. Identified Critical Data Elements for Collibra Data Governance initiative.
• Reverse engineered and documented SCD2 ODS from Hadoop metadata from 6 source systems. Wrote macros to produce Data Dictionary for developer use.
• Designed 7 Kimball Star Schemas using Embarcadero ER/Studio. Generated DDL.
• Developed Data Flows in Visio to document business processes and validated with business. Identified and documented the 7 main business processes and 27 subprocesses for use in Data Governance project management.
• Wrote the SQL scripts, views for the jobs to extract the Hadoop data via Impala-shell to support 30 metrics for Risk Analytics, to be ported into R-routine for risk scoring.
• Worked with dataware engineers on Hue and Hadoop bugs impacting performance and reliability to troubleshoot and resolve.

Confidential

Data Architect

Responsibilities:

• Analyzed over 300 legacy structures to lead migration of undocumented legacy system with 22 feeds from legacy Sybase ASE 12 database to DB2 LUX 10. Developed matrix of best practices, identifying gaps in processing or design quality in legacy system to target improvements for new database.
• Developed Logical and Physical data model for 168 new data structures for Data Warehousing system, including 29 facts, 55 dimensions using Powerdesigner 16.x against DB LUX version 10. Provided knowledge transfer of the models to offshore teams.
• Designed mixture of SCD2 ODS and Kimball data marts using Powerdesigner 16.x for Qlikview version 12 reporting.
• Modeled ETL metadata error capture as well as persistence layer for Qlikview reporting threshold UI using 3rd normal form (OLTP).
• Maintained legacy model for tactical releases, deploying into Sybase ASE 12 database.
• Executed DDL, granted permissions, and optimized physical structures using clustering and indexing strategies for DB2 LUX 10 database.
• Developed logical flow of ETL lookups and processing using Visio, creating proposals to streamline processing, improve error capture, increase documentation and maintainability, and support best practices.
• Worked with the business to obtain configurable cleansing logic, identify and implement default values, and identify source data issues to improve data that supports 30+ metrics across 5 dashboards.
• Supported the creation of approximately 70 ETL logical design specs, including source to target mappings and Data Dictionary. Developed ETL test scripts.

Confidential

Enterprise Data Architect

Responsibilities:

• Designed Enterprise Logical Data Model for both OLTP and Data Warehouse in Erwin 8.x to support emerging Data Management practice, engaging teams from Ad Sales, Digital Marketing, Research, Analytics team, and other members of Enterprise Architecture teams to build consensus on standardization.
• Developed Logical and Physical data model for 100 table OLTP system using Erwin 8.x against SQL Server 14 backend to support capture of PII data for job candidate registration and crewing.
• Developed metadata for Sports Line of Business to support integration of data from 6 disparate systems. Specified Informatica ETL design.
• Profiled large data sets in Pivotal Hadoop 2.0 using Informatica Data Analyst 9.6.1 and Hive.
• Prototyped front-end for business users of Digital Ad Sales data using Tableau 8.2.

Confidential .

Data Architect

Responsibilities:

• Performed and documented an assessment of the FDNY data architecture environment for inspections and scheduling application. Application incorporates risk analytics into scoring for inspection prioritization.
• Assessed and document integration strategy, integration code quality, stored proc quality, use of naming conventions and best practices in indexing, and analyzed performance reports for ORACLE 11.2 database.
• Streamlined 300 table OLTP application for inspection scheduling, using Erwin 9.5, producing a much simpler design that eliminated need for a 3 hour overnight processing job, among other improvements.
• Designed 2 new Data Warehouse marts to support interactive querying of the statistical inputs and the resulting inspections and scheduling metrics using Kimball star schema design patterns.
• Work with Data Scientists to integrate R layer into ORACLE 11.2 database utilizing data sources refreshed daily into ORACLE 11.2 database.

Confidential

Enterprise Data Architect

Responsibilities:

• Lead design database efforts on metadata layer in ORACLE 11.2 virtualizating a self-service data layer against data hosted globally in Netezza and Teradata databases. Layer transforms queries localized to those platforms using Erwin 8.0
• Reviewed and provide database design feedback for large financial data warehouse, hosting and financials for the enterprise using Kimball star schema design patterns.
• Lead Data Architect for 3 major e-initiatives, primarily utilizing OLTP modeling in support of web-based applications to support commercial payment systems, primarily for multinationals
• Consolidated applications use of data structures to improve Data Quality, improve visibility in end-to-end processes, and reduce Total Cost of Ownership; designed data hub for authorizing signers on accounts
• Utilize Erwin 7.x to design enhancements for new functionality, including design of workflow persistence, user and group entitlements data, and the management of documents related to client setup within the bank
• Develop DML/DDL and review PL/SQL packages and procedures in an ORACLE 11.x environment, using best practices in development and code promotion
• Develop and communicate standards for database design and management

Confidential

Enterprise Data Architect

Responsibilities:

• Designed 13 Erwin 4.x Subject Areas to accommodate 3 different project needs: Staging area, Distribution Hub, Non- Metadata and the structures to support passing data to and from the Master Data Management platform, which is Golden Source; designed performance data master hub using Federated Hub Architecture approach across all Structured Finance asset classes (RMBS, CMBS, ABS, CDO)
• Utilized AGILE approach in 3-week sprints for software delivery
• Evaluated Enterprise Architecture data Master Data Management strategies in the context of a critical Structured Finance data project, designing data flows for over 23 feeds, performing Informatica mappings, evaluating XML, DVL, and ETL solutions for incremental and bulk updates for a variety of consuming systems
• Performed Data Profiling for integration of millions of records from five different data sources, using SQL, PL/SQL, ORACLE metadata tables, Trillium, and Informatica Data Quality and Powercenter (version 8 and 9)
• Designed 12 fact tables, 13 new dimensions, and reused 12 existing conformed dimensions in Enterprise Data Warehouse to create an analytical platform for statisticians and analysts needing to derive probabilities of default and resulting recoveries for Corporates, Sovereigns, CDS, CDOs, and other Structured Finance instruments. Employed Kimball star schema dimensional design approach, using Erwin 4.x
• Gathered Data Warehousing requirements, iteratively prototyping data content and data availability to the business via pivot tables and SSAS 2005
• Performed data analysis and ETL Mappings from 9 internal source systems in an ORACLE 9i, 10G environment, verifying business relationships and data quality and raising issues as appropriate
• Designed normalized OLTP data model using Erwin 4.x with 50+ tables in order to track, capture, and calculate default and recovery processes and financial impacts for Leveraged Loans and Corporate Bonds; captured debt, equity, and CDS prices as indicators of distress
• Responsible for the review of 4 Data Modelers for accuracy in fulfilling business requirements, completeness, adherence to standards in the Conceptual, Logical, and Physical model and for timely delivery of the models
• Worked with other project team members in the data flow design and data structure review of a generic bulk loader and staging area for the processing of 12 system feeds
• Used Microsoft Analysis Services SSAS 2005 to prototype Excel-based pivot tables for Financials and other Operational metrics
• Responsible for delivery of both OLTP and dimensional data models and data flows for Fundamental data entry and analysis
• Consult internally on a host of different initiatives, working to align data use and data models in ways that leverage existing information assets and increase information sharing across applications, to, cumulatively, deliver a richer, more analytically useful set of applications

Confidential

Enterprise Data Architect

Responsibilities:

• Responsible for re-engineering the ETL load processes to accommodate a set of physical aggregate tables for Microstrategy 8.0 implementation and an ORACLE database
• Led efforts to check-in all code and migrate database from ORACLE 8i to ORACLE 10G, including hundreds of PL/SQL procedures that needed to have dependencies checked and code validated against the new database structures

Confidential

Enterprise Data Architect

Responsibilities:

• Familiar with structuring of secured and unsecured debt instruments, S&P rating "mark to market" rules, tranches, and securities rating
• Experienced in developing models and metrics to report on secured debt performance, including CPR, cumulative loss severity and other performance metrics
• Used a top-down and bottom-up approach to designing five data marts using OLAP cubes: for Loans Available for Sale, Loan Quality, Profitability, Bidding, and Price relative to swap rates, using ERWIN 4.x, ORACLE 9.2, SQL Server 2000, and SQL Server Analysis Services 2000 and SQL Server Analysis Services 2005. Designed star schemas and cubes. Wrote Analysis Services MDX calculated measures. Able to translate business user interviews and data analyses into a rich set of reporting capabilities.
• Developed logical ETL mappings from source to target systems, performed data analyses, developing robust set of business rules through extensive interaction with the business. Wrote SQL Loader scripts for rapid prototyping. Responsible for developing bcp extract, DDL, SQL scripts, and load scripts for promotion to Production. Used DTS and, later, SSIS to port data from legacy SQL Server applications.
• Wrote extract for SEC Reg AB deal performance reporting, and solidified business rules, refined Analysis Services MDX calculated measures and Analysis Services MDX query, and ported sources to meet regulatory end-of-year deadline.
• Developed logical and physical ETL design for the porting of new solutions into existing architecture.
• Mentor to more junior database developers in best practices in Data Warehouse design, architecture, ETL techniques, and philosophical approaches to Data Warehouse problem-solving.

Confidential

Enterprise Data Architect

Responsibilities:

• Reviewed and suggested modifications to an ODS data cleansing application with metadata-driven application code and a Services On Demand bus architecture.
• Identified areas of poorly performing composite key joins, suggesting simplifications that more closely enforced business rules and made the database design more intuitive to database developers.
• Managed 20 ERWIN 4.x subject areas, reconciling missing design elements before publishing DDL and pdfs for weekly release.
• Identified DB2 UDB 8.2 update anomalies caused by extensive use of identifying relationships where unnecessary. Suggested alternate design methods to reduce anomalies and primary key violations.

Confidential

Enterprise Data Modeler

Responsibilities:

• Responded to client’s desire for a Kimball Federated Data Warehouse, as opposed to Inman approaches and methodologies. Conducted and participated in JAD sessions and individual interviews. Defined 42 Enterprise processes to be modeled in an Enterprise Data Warehouse for the B2B businesses and 400+ base and key metrics.
• Identified 30 conformed dimensions across the processes with an end to building a Federated Data Warehouse. Developed Conceptual Data Model and bus matrix.
• Developed Logical Dimensional Data Model for first business process in the Federated Data Warehouse, including 17 dimensions, including 6 slowly changing dimensions, 2 fact tables, using ERWIN 4.1. Participated in documenting business rules for over 500 columns.
• Participated in the development of ETL mappings and templates for capturing ETL logic.
• Performed Data Quality analyses against ORACLE legacy source database for ORACLE 9i target database.

Confidential

Enterprise Data Architecture Consultant

Responsibilities:

• Assessed Confidential ’s Data Warehouse environment from a logical and physical architecture, SDLC process, and human capital perspective. Deliverable was a 70 page strategy paper and assessment
• Implemented recommended physical architecture on ORACLE 9i database including consolidating of six Data Warehouse databases into one.
• Coordinated the move of 11 Terabyte database comprised of 31 applications onto more robust hardware platform.
• Applied best practices in analysis and change management during migration to new hardware to ensure quality.
• Attended Sarbanes Oxley IT meetings to field and translate business requirements into technical plans and to ensure compliance with mandates.
• Instrumental in the creation of a Data Modeler and Application DBA role for the team.
• Coordinated work with these new team members, as well as leaders within the Data Warehouse and larger IT organization to facilitate a new Software Development Lifecycle with version control, thorough design steps, code reviews, and appropriate security and signoffs.
• Performed scripting to implement new Configuration Management software using standardized directory structures and code extensions .
• Introduced automation into manual ETL processes.

Confidential

Data Warehousing Strategy Development

Responsibilities:

• Responsible for interviewing business champions and data warehousing staff, evaluating the data warehouse for best practices, penetration within the business community, opportunities for enhancing enterprise architecture, and recommending best practices in warehousing deployment and Production support.
• Role is as an objective outside expert focused on delivering strategy for the team over the next 3 - 5 years. Deliverable was strategy paper.