Data Architect, Data Modeler, Data Strategist Resume
4.00/5 (Submit Your Rating)
SUMMARY:
- Possesses over fifteen (15) years as Data Architect, Data Modeler, and other roles.
TECHNICAL SKILLS:
COMPUTER SOFTWARE AND LANGUAGES: SQL Server, Oracle, DB2, MS Access, Hadoop, PL/SQL, R, Python 3.5.1, Spark, C++, MS Windows Shell and Power Shell, Linux and UNIX Shell, Visual Basic for Applications (VBA), SSIS and DTS, Informatica Power Center 9.6 and Metadata Manager, JetBrains PyCharm IDE, Spyder 3.0.0 IDE, IPython 5.1.0.
PROFESSIONAL EXPERIENCE:
Confidential
Data Architect, Data Modeler, Data Strategist
Responsibilities:- For the Confidential COO CST Data Management Center of Excellence (CoE), supported the Firm - wide Operational Risk Control Environment (FORCE) program, formerly called the Corporate Operational Risk Ecosystem (CORE), which is the Phoenix program replacement. FORCE is a Risk Control Self-Assessment (RCSA) system designed to manage operational risk at Confidential corporate-wide overseeing all lines of business (LOBs). In parallel, also supported Controls Room program. After a few months onboard at project, acted as RCSA Subject Matter Expert (SME) to data model and database design, data integration, master data management (MDM), metadata management, data quality joint sessions and discussions. Managed and resolved issues by collaborating with onshore and offshore cross-functional teams and staff via tracker spreadsheets, joint discovery sessions, Joint Application Development (JAD) discussions, interviews, research, and working meetings.
- Designed and generated Oracle Data Definition Language (DDL) for several iterations of Data Marts of ten (10) Fact and one-hundred-fifty (150) Dimension tables for the FORCE Risk Event Data (RED), Controls Evaluation Record (CER) also known as Test Capture, RCSA, and Assessment subject areas. Supported the FORCE and Controls Room Logical Data Model (LDM) and Physical Data Model (PDM) by reconciling the datatypes, nullability, and naming conventions. Presented final results of deployment to colleagues and consumers the design rationale and changes using MS PowerPoint and PDF exhibits. Mapped the Report Data Fields Semantic Layer, Technology Objects, and Business Terms in FORCE and Controls Room in order to ensure compliance with Basel Committee on Banking Supervision (BCBS) 239. Coded Oracle PL/SQL across Systems Integration Test (SIT) and User Acceptance Test (UAT) databases to capture list of valid values for Technology Object field. Determined external data sources from Confidential source systems to denote System of Record (SoR) and Authoritative Source (AS).
- Advised management on Data Management Strategy and Policy covering Data Architecture Management, Data Development, Database Operations Management, Data Security Management, Reference and Master Data Management, Data Warehousing and Business Intelligence Management, Document and Content Management, Meta-Data Management, Data Quality Management, and Data Governance. Also advised on an internal corporate Marketing Plan for the Data Management Team.
- Wrote sophisticated Oracle PL/SQL code to automatically gather all FORCE database table column domain of valid values from Production, User Acceptance Test (UAT), and System Integration Test (SIT) environments. Then employed MS Excel VLOOKUP and other functions to merge information for Program Managers, Business Analysts, and Data Analysts to reconcile an enterprise-wide data dictionary.
- Evaluated via Proof of Technology (PoT) several Big Data solutions, computer languages, and software for Confidential corporate applications, such as, Hadoop Distributed File System (HDFS), Map/Reduce, Apache Spark, Cloudera VM and Linux, ‘R’ and Python computer languages, RStudio IDE, RapidMiner, BigML, and Orange software. Rationale strikes three areas, including, high cost, extended design-time-to-production, and persistent performance reporting issues. Also explored Machine Learning procedures using Decision Trees, Ensembles, K-Nearest-Neighbors (KNN), Naïve Bayes Classifiers, and Artificial Neural Networks, Data Mining techniques of Data Reduction, Clustering, Classification, Anomaly Detection, Association Analyses, Regression Analysis, and Text Mining, and, Data Visualization and story-telling mechanisms.
- Used MS Project, ERWIN 9.6, Oracle 11.2 PL/SQL, SQL Plus, Toad 10.1, MS Windows, Microsoft Office Suite, MS Access, and MS Visio, Hadoop, Python 3.5 and R Computer Languages, Apache Pig, HIVE, HBASE and Spark, Linux, JetBrains PyCharm IDE, Spyder 3.0.0 IDE, IPython 5.1.0, Eclipse Neon.2 IDE, IDLE 3.5 IDE.
Confidential, CT, MA
Data Architect, Data Strategist, Data Modeler
Responsibilities:- From the MassMutual Retirement Services Tech Strategy, formed a Data Strategy that includes policies, standards, and procedures for a Data Management Program (DMPgm) managed by a Data Management Office (DMO) patterned after the Project Management Office (PMO) model. The DMPgm and DMO covers policies for Data Architecture Management, Data Development, Database Operations Management, Data Security Management, Reference and Master Data Management, Data Warehousing and Business Intelligence Management, Document and Content Management, Meta-Data Management, Data Quality Management, and Data Governance. Scope of review includes technologies in SAP, Informatica and Metadata Manager, Teradata and Financial Services Logical Data Model (FSLDM), Oracle, OBIEE CRM, DB2, and, SQL Server. Created plans, timelines, statement of work (SOW), technical questions, and use cases from business requirements for Proof of Concept, Pilot of Data Strategy, Data Management, Data Lineage, and Data Governance initiatives, programs, and projects. Reviewed and evaluated data mapping and data modeling processes for feasibility, revamp, and process improvement. Reviewed Informatica PowerCenter 9.0, 9.1., 9.5, and 9.6 versions, and recommended and implemented a Proof of Concept (POC) with Metadata Manager in collaboration with Informatica consultants as solution to interrelate enterprise Executive Leadership Initiative, Business Architecture, Business Model, Tech Strategy, Data Dictionary, Teradata Financial Services Logical Data Model (FSLDM), ERWIN data models, and Informatica Business Glossaries and Repository objects including data mappings, mapplets, source, target, data integration services. Kicked off Data Strategy Pilot by creating ontology structure, and verified traceability using Teradata SQL Assistant, Informatica Power Center and Metadata Manager and SQL Server.
- Explored for evaluation the Big Data and Cloud solutions, such as, Teradata with Hadoop, and Google Cloud Platform (GCP) for a Platform as a Service (PaaS).
- Used Windows 8.1, Microsoft Office Suite 2013 with MS Excel advanced features including Pivot and Functions, Informatica PowerCenter 9.6 Business Glossary and Repository, Power Designer, CA All Fusion ERWIN 8.2 with Model Mart in Oracle, Teradata 13 SQL Assistant, Oracle 11.2 SQL Developer and PL/SQL, SQL Server 2005, 2008, and 2012, DB2, SharePoint, WebEx, Extended Markup Language (XML), Hadoop.
Confidential, CT
Data Architect, Data Modeler
Responsibilities:- Managed over 30 very large transactional and data warehouse data models and databases of up to 12,000 entities and tables and 110,000 attributes and columns and collaborated with enterprise data architecture of up to 250,000 entities and tables and 3.1 million attributes and columns., including, created audit triggers in conjunction with referential integrity and cascade rule actions. Collected and reported data asset and data model inventory, and determined that the scope of responsibility. Analyzed, collaborated, and implemented with managers, enterprise data architects, DBAs, analysts, and developers, and approved service request changes to Cigna and Intra corp Healthcare Integrated Care Management System (ICMS) and other data models and databases on application projects, such as, Health Insurance Exchange (HIX), Diagnosis Related Groups (DRG) standards upgrades from International Classification of Disease Version 10 (ICD-10), Medicare, NY-DRG, NJ-DRG, WA-DRG, Milliman, and APR, Health Information Health Insurance Portability and Accountability Act (HIPAA) compliance, Winstrat to 3M Coding and Reimbursement System (CRS) replacement, and, Value Based Compensation and Reimbursement (VBCR). Gathered records and documentation of historical changes to data models and data bases of past 20 years. Modified canned ERWIN reports using SAP Crystal Reports and Toad for Oracle to produce data dictionary and customized data model reports to publish in SharePoint as ready reference for managers, analysts, and application developers. Reverse-engineered Oracle and DB2 DBs and forward-engineered changes from service request tickets. Attended training and complied with HIPAA laws and guidelines. Used Microsoft Office Suite 2013, CA All Fusion ERWIN 8.2 with Model Mart in Oracle, Oracle 11.2, SQL Developer, PL/SQL with GROUP BY and SUBSELECT, SQL Plus, Quest Software Toad for Oracle Professional 10.1, IBM DB2, SAP Crystal Reports 2011, SharePoint, WebEx, and MS Excel advanced features including Pivot and functions, Extended Markup Language (XML), LDAP, Lync 2010, HP Service Manager, Clarity timekeeper, PeopleSoft timekeeper.