PROFESSIONAL SUMMARY:

• Analytical Expert IT professional with the technical aptitude, career knowledge, and tools to put to use for you Talent to translate my data knowledge into a valuable contribution for your organization and to implement changes and growth in the Data ecosystem.
• During my progressive 20 year career, I have evolved into a Data Architect, having advanced from Software Engineer to Data Scientist.
• My expertise has gained a showcase in the Applications’ areas which include financial services, insurance, Pharma, healthcare, and communications.
• Aptitude to learn new software programs and platforms, design, build and create algorithms.
• For instance, when I was working for the Financial Project at Confidential, I began thinking about ways to improve the “performance” and runtime for processing financial data, and I returned to college and investigated this concept during the preparation of my Master’s thesis.
• Later I applied this knowledge professionally and developed financial algorithms to improve performance of large data sets while working on the Fusion Analytics Project, QTRIPS, POC and RFP Projects.
• As a result, business stakeholders were able to make decisions, which were informed by these improved, high level analytics.
• I possess the knowledge and skill set to recognize the purpose in large scale projects, in order to set project scope, using technologies in the NoSQL and Hadoop ecosystem.
• Last, I am a highly qualified Data Architect and I have extensive experience in this role.
• I have also been successful in other capacities which span: Enterprise Data Architect, Data Architect - Project Manager, Data Warehouse Architect, MDM Architect, Data Analyst, Data Modeler, Business Analyst, Data Scientist, Solutions Architect, SQL jockey, and Business Process Re-engineer (BPR).

TECHNICAL SKILLS:

SOFTWARE: ERwin, Rational Rose, Rational Rose Data Modeler; Select SE, PowerDesigner, UML, MIMB, MetaWorks, Brownstone,Oracle Teradata; DB2/UDB, SQL Server, SQL, SPL, Dynamic SQL, NoSQL, MPP, Redshift, dashDB Data Warehouse, HDFS, Hive, HBase, MongoDB,, SQL Data Warehouse, Cloudera, Horton Works, MAPR, Hadoop, Sqoop, Impala, SpliceMachine, Mahout, Machine Learning (ML & Deep ML), IBM Machine Learning w/Spark, BigInsights, BlueMix, Python, R Studio, schema design (ERWin), Visio, Red Hat Linux, VMware, Amazon AWS Stack, SoftLayer Stack, MS Azure Stack, InfoSphere Data Architect, Informatica, MicroStrategy, Pentaho, Talend, DataStage, AWS Glue (ETL), Syncsort DMX-h, Dashboarding, 15 different BI platform solutions, Data (structured, semi-structured & unstructured data), Microsoft Access, Red Brick, SQL (12 years), QMF, OLTP, OLAP, Evoke, Windows 10, 7 & XP, Unix, MVS; Client/Server mainframe, and IBM mainframe architectures; multi-threading; Hyperion Essbase (ROLAP), ODBC, Anywhere (Sybase) Open Client, SCD Type 1, SCD Type 2 & SCD Type 3, Zachman Enterprise Architecture, CMMI, ITIL, TCP/IP, XML, API, MS Office Pro 2010, Microsoft Basic, Micro Focus Cobol, Object Cobol, DB2 Utilities, Cobol, CICS, CICS/OS2, LU6.2 CICS DPL, BMS, REXX, ECI, VA Java/Smalltalk, Omegamon, Intertest, SyncSort, Microsoft Excel (charts, pivot tables), Collibra, Zachman, blockchain, cryptocurrency

HARDWARE SKILLS: Intel based servers, Workstations, Desktop PCs; Laptop PCs, Dec Alpha; ATT 3B2000; IBM Mainframe servers

EMPLOYMENT HISTORY:

Confidential, NYC / NJ

Business Analyst, Data Analyst

Responsibilities:

• Managed scope, gathered project use-case requirements and built customer journey map (CRM) thru JAD sessions. Built 3NF logical model and implemented physical model for high end billing commission system for Quants & Traders on daily/hourly billing with acute accuracy.
• Implemented project data standards (naming, class word, abbreviation, governance) to standardize development and workflow.
• Design, develop a clickable prototype of system use-cases including: transactional flows & management KPI dashboards /reports.
• Built and tuned database SQL queries to improve database performance and adhere to enterprise best practices and data strategy.
• Gathered requirements, built (with my team), researched, implemented various Analytic/BI and data management platform architecture solutions consisting of Informatica, MicroStrategy, Talend, Pentaho, and Syncsort DMX-h for ETL; write ETL specs, DQ specs and BI analytics specs; data ingestion, Profiling and DQ as well as Data Blending and/or Dashboarding with 16 different Dashboard / BI platform solutions against NoSQL MPP Cloudera Hadoop HDFS, Redshift, Azure SQL Data Warehouse, dashDB, Hive, Cassandra, and MongoDB x-node cluster with open source ecosystem projects including: Presto, Drill, Tajo, Sqoop, Impala, SpliceMachine, Mahout, SparkML Machine Learning, Python, R Studio; schema design (ERWin); running on Red Hat Linux with VMware. Also including RDBMS access to Oracle, DB2 UDB, Teradata, MySQL, SQL Server and Postgres. Vendor management. Research and training on Neo4J graph database and DevOps.
• Improved database performance thru SQL tuning and physical data model design schema on various Cloud technology platform configurations with Hadoop, Amazon AWS (MPP Redshift, S3, EMR, EC2, RDS), SoftLayer (MPP dashDB, Bluemix, Object Storage, IBM SparkML, and MPP DB2 UDB in BigInsights running on Hadoop). Data sources for Redshift were structured, semi-structured and unstructured data.
• Built logical and physical data models using InfoSphere Data Architect or ERwin and implemented on columnar MPP Redshift, dashDB, Azure SQL Data Warehouse, and Hadoop HDFS, Hive, Cassandra, and MongoDB. Cloud provisioning (invoicing) is for: servers, OS’s, Software, Storage, CPU Time, and Bandwidth. Built Linkedin data model with ERwin.
• Supported team with designed & implemented physical data model; platform design; specification for: algos, reports, and dashboards.
• Supported business management decision makers with business tools to assist in making good fact based business decisions.
• Built a BI campaign demographic snowflake schema data warehouse with history (SCD type 2), conformed dimensions, outriggers, ETL specs, and reporting on Redshift from client facing meetings, to support, guide and lead the direction of future campaigns.
• Built process workflow for data ingestion into the Enterprise Data Lake: first large data files are ingested by the Hadoop ecosystem into the data swamp; once data is analyzed and analysis documented, the data is then promoted into the data lake for consumption.
• Built data governance strategy roadmap that includes Collibra and a Collibra bound data content strategy roadmap and subsequent Enterprise/stakeholder alignment (Zachman) resulting in a unified Enterprise with senior management stakeholders.
• Analyzed business, built and implemented Redshift Mobile Device space metadata data model (from semi structured and unstructured data). Used Big Data Insights against Mobile Device big data were used alone or Joined with other inside and/or outside data resulted in discovering: Trends, Patterns, correlations, Predictive Analytics, Prescriptive Analytics, clustering, and classification. Result was a robust BI analytics and Risk-based Monitoring (RbM) Indicators included: KRIs, KPIs, & KQIs.
• Gathered requirements, built and implemented Cross-Device CRM (Mobile & IoT) Management data model and Cross-Device Marketing Data Warehouse data model (sourced from semi structured & unstructured data) in Redshift for a competitive advantage .
• Analyzed use and impact of implementing blockchain on a transaction network and bitcoin as a medium of exchange or some other coin cryptocurrency as a decentralized virtual currency. The project resulted in increased transaction agility for the enterprise.
• Built Cloud Computing Recruiting data model, as-is workflow, and skill taxonomy/ontology set. Write BPR paper outlining how Recruiters can automate Job Order and Candidate matching efficiently, which resulted in a 23% increase in placement revenues.
• Compiled vendor analysis by function, using MS Excel, for evaluation to support the following spaces: data quality, ETL, data integration, data lineage, glossary, vocabulary, metadata management, MDM/RDM, data governance and information governance
• Stay current on the Financial Industry by participating in EDMcouncil.org meetings ( Enterprise Data Management Council ).
• Documented impact of government regulation on IT: Dodd Frank, Volker, CCAR, DFAST, and DFAST vs CCAR, Basel, AML.

Confidential

Enterprise Data Architect & Data Architect

Responsibilities:

• Solely gathered use-case requirements in all 4 projects thru collaborative client facing meetings. Led Algo & RM Software team. After algo team finished algo, it was turned over to head Algo pro who added his proprietary magic to algo that made it work.

Confidential

Data Architect

Responsibilities:

• Maintain enterprise data model using ERwin. GAP Data analysis for Regulatory requirements, on acquired fund clients. Lead and PM back office staff to gather missing client information as part of information governance and regulatory compliance effort.
• Data mapping (As-Is to To-Be model) and data migration for numerous fund acquisitions of fund Confidential clients using ERwin.
• Analyze data (data quality, data definitions, data profiling, data catalogue) and industry data models as needs require using ERwin
• Designed, built and implemented 3NF Confidential Forecasting Model data architecture to forecast recessions using ERwin.
• Acquired, cleaned, and loaded data into database.
• Designed SQL queries to source graphical chart dashboards.
• Maintain data lineage.
• Completed statistical analysis that forecasts probability of recession (predictive analytics, KPIs) given specific graphical patterns.
• Created project POC, designed a project workflow, and built algorithm software architecture to standardize algo development.
• Using Big Data Insights, design & build portfolio of event-driven and long-short trading algorithms to exploit various price pattern, cycle and seasonal trading opportunities using TradeStation. Holding periods vary from several days to up to 6-months.
• Figured out a way to get 4 to 8 day running Big Data Insights down to 4 to 8 hours and invented a “Probe” that runs in 20 to 30 minutes that determines profitability. If the Probe finds profit, then I run the 4 to 8 hour Big Data Insight to identify profit level.
• Design and build a stand-alone risk management algorithm to manage trade risk thru support/resistance-based trailing stop.

Confidential

Enterprise Data Architect

Responsibilities:

• Set project scope and list business areas to identify project boundaries for a new Global Client/CRM Confidential Banking system.
• Developed function area document consisting of Context diagram, functional decomposition, and functions to establish project scope and system functions. Maintained system metadata, developed data mappings and data lineage. ITIL.
• Built Confidential Bank’s new Wealth Management system data model from requirements (top down) and existing Siebel RX/SSM online system and documentation (bottom up analysis) using ERwin.

Confidential

Data Architect

Responsibilities:

• Reviewed, validated, verified and normalize Risk Management System 3NF ERwin data model, databases, use cases, reporting (SQL), metadata, data lineage and profiled data to hedge asset classes (algorithms) and regulatory requirements.

Confidential

AVP - Enterprise Data Architect

Responsibilities:

• Developed management approved Enterprise Data Standards to globally standardize data across enterprise.
• Built an SOA MDR.
• Designed, built, implemented Metadata Repository (UML Class Diagram and data model) to integrate and manage Data and Apps.
• Designed, Built (data model) and implemented integration tables to integrate 3 LOBs to eliminate non concurrency.
• Built Enterprise Data Model using industry data models (IAA|ACORD & householding) and silo data models to reduce enterprise redundancy (SOR) as well as maintain metadata, document data lineage and data mapping Capital Market instruments modeled include: fixed income, mortgages, equities, ETFs, preferreds, convertables, Futures & more.
• Lead MDM Data Integration Team tasked with MDM road map, Data Governance, Data Stewardship, identify / solve enterprise MDM & data issues between system silos/LOB as well as Data Warehouse & Data Marts. Customer first, then Account, Product and more. Collaborate with IBM and Informatica MDM product development. Built a conceptual model for IT & CIO. XSD
• Fielded occasional in person questions regarding NYL data by Sy Sternberg, Chairman, President & CEO of New York Life.
• Received a hand written note from Sy Sternberg. The note commends Mr. Kinzinger for his work at Confidential Company and is signed by Sy Sternberg. This note has Sy Sternberg’s multi-colored CEO seal stamp imprinted across the note. Sy Sternberg was once a member of the technology team earlier in his career at New York Life. View this note upon request.

Confidential

AVP - Enterprise Data Architect

Responsibilities:

• Gathered requirements, built a conceptual data model, and Global Corporate Actions workflow Data Flow Model, data flow diagram and As-Is use-case for managements understanding of the fragmented system consisting of manual and automated processes.
• Built capital market Corporate Actions and Multi-Currency Accounting system 3NF data model, from user interviews and industry models, to support strategic goals to increase productivity and lower operating costs through BPR, automation and staff reduction.
• Built, implemented Security Payment Order 3NF data model from stakeholder interviews to automate reconciliation of DTC charges from new elements, metadata repositories, and corporate data dictionary.
• Forward engineered ERwin model into SQL Server..
• Client facing Interviews with Confidential Region VP regarding his need to identify, document, and recommend improvements to the current Portable Provisioning workflow. Gathered and analyzed data and then built a data dictionary and data model (ERwin)
• Client facing Interviews with IT staff and management, from 8 different Oracle systems integrated by workflow, to build and empower management with a current provisioning workflow, data and source an As-Is business use-case document.
• The outcome of my effort with my partner (senior Merrill IT leader), in this successful project, was a recommendation to migrate Confidential Provisioning to the COAST system that would reduce fulfillment time to 10 business days from 22.

Confidential

Data Analyst, Business Analyst

Responsibilities:

• Built Group Life Rating and Dental Rating subject area 3NF data models collaboratively with business stakeholders and IT staff.
• Redesigned, map and migrate Enterprise Data Dictionary from Paradox to MS Access, then DB2 UDB using ERwin as well as maintain Enterprise metadata and built reports (SQL).
• Created Enterprise class word & abbreviation standards to standardize new development. Built Data Administration workflow
• Organized Data Administration with database change request procedures and workflow to maintain Enterprise databases.
• Developed new Recruiting system use-cases, data dictionary, and online prototype thru interviews. PowerPoint Presentations to management. Documented existing Recruiting DB by reverse engineering DB to create ERwin data model; built a Rational Rose Object Model; and empowered developers with Rose Class Diagrams reverse engineered from Java classes at CASE.

Confidential

Data Warehouse Architect

Responsibilities:

• Analyzed data and built INI feed Data Mart data model with conformed dimensions for Unix Red Brick database using ERWin.
• Designed and implemented BI report queries (SQL) in Essbase (in-memory ROLAP multi-dimensional cubes). Built and ran complex queries (SQL) to support adhoc Marketing reporting. Tracked Data lineage, maintained metadata & trained in DataStage.
• Analyzed data, built DataMart data models, wrote ETL specs & pipeline to Integrate data into staging database, DataMarts, and star schema Data Warehouse with conformed dimensions and outrigger dimensions using Inmon and Kimball methodologies.