SUMMARY

• Analytical Data 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 inspire growth in the Data ecosystem.
• During my progressive 20 year career, I have evolved into a Data Professional, having advanced from Software Engineer to Data Warehouse Architect.
• My expertise in data architecture began when I was a teenager and this passion was behind the skill set that I progressively developed into adulthood. Presently, my ability to adapt to many roles, combined with this long term passion, resulted in remarkable success and has driven me to meet clients’ goals far beyond those original teenage dreams.
• Net gains from my career pursuit include obtaining a college education at Temple University in 4 undergrad specializations Computer Science, Finance, Econ, and Statistics. Right on track and armed with this knowledge, I obtained roles quickly and my acumen enabled me to hold high level positions and continue my career success in these areas: financial services, insurance, pharmaceutical, healthcare, and communications.
• As a problem - solver with an aptitude to learn new software programs and platforms, I continued to seek out and apply changes in the industry, enabling me to use my critical thinking skills and in keeping up with the industry standards and changes which I put into the design, build, and creation of valuable algorithms.
• For instance, while working for the Financial Project at DTG, 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 thesis. Later, I applied this knowledge and developed financial algorithms to improve performance of large data sets while working on the Fusion Analytics, QTRIPS, POC and RFP Projects. As a result of this “probe”, business stakeholders were able to make decisions which were informed by these improvements and high level analytics.
• Also, I re-engineered using Six Sigma practices, the laptop provisioning workflow process, decreasing it from 22 to 10 days, while working for Merrill Lynch. Again, this runtime was reduced to “10” days as a consequence of my detailed data analyses, education, and application of my long term career goals and my IT journey. (See a growing list of “Professional Conferences Attended” at the end of this resume)

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Data Architect and Enterprise Architect skills sets US Trust (Ultra High Net Worth Client base)
• Mapped 950 columns from US Trust systems from acquisition (Data Source) to Merrill Lynch (ML) systems (Target) for BoA. BPI
• Lead group to Best Practices and splitting US Trust loaded columns into individual columns in Target ML data architectures with Best Practices, ETL, DQ and DP Specs to standardize / normalize, store and document Enterprise Data Assets Agile JIRA CMMI

Confidential, NYC, NJ

Data Warehouse Architect/Information Architect

Responsibilities:

• Managed scope, gathered and analyzed project use-case requirements, built BPM and 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, DMBOK) to standardize development.
• Designed and built a clickable prototype of system use-cases, also included are: KPI dashboards/reports, transaction flow and APIs.
• Built and tuned database SQL queries to improve database performance and adhere to enterprise best practices and data strategy.
• Job titles performed here are Data Warehouse Architect, BI Analytics Platform Architect, Business Analyst & Support 15 man team.
• Gathered business analysis requirements, managed scope, lead team, built data warehouse and datamart logical and physical data models; implemented schemas; best practices; built end to end Big Data BI Analytic platform architecture solution designs; and created Data Engineering specs for: DP, DQ, ETL, data access/blending, algorithms, reports and dashboards.
• Built logical and physical data warehouse and datamart Star / Snowflake and hybrid models using ERwin, InfoSphere Data Architect, and ER Studio and implemented on DynamoDB, Redshift, dashDB, Azure Data Warehouse, Snowflake, HDFS, Hive, Cassandra, MongoDB & RDBs (Oracle, MySQL, SQL Server and Teradata). ( IaaS, PaaS, SaaS )
• Built, provided Zachman EAF based IT strategy/technology solution presentations to business and technical mid management.
• Established scope, researched, built (with my team) and implemented various frameworks, BI Analytic and data management platform architecture solutions addressing data ingestion and continuous data ingestion pipelines consisting of: Hadoop, Informatica, MicroStrategy, Talend, Pentaho, DataStage, and Syncsort DMX-h for ETL; write specs for: Data Profiling / DQ / ETL, and BI analytics specs; data mapping; and data lineage as well as information delivery including: data access and Blending specs, visualization specs for dashboarding and reporting with 20 different dashboard/reporting BI analytic platform solutions (Kafka, Spark, SparkML, PySpark, Beam, Tableau, Qlik, Alteryx, Cognos, Sisense, Spotfire, Domo, OBIEE, Apache Zeppelin, DataStax (with Solr & Cassandra), Power BI and BI Semantic Model stack SSAS, SSDT, SSIS, SSMS, SSRS ) against NoSQL MPP Cloudera Hadoop HDFS, DynamoDB, Redshift, dashDB, Azure Data Warehouse, Hive, and MongoDB x-node cluster with open source ecosystem projects including: Presto, Drill, Tajo, Sqoop, Impala, Machine Learning, SparkML Mahout, Python (program very complicated algos for developers), R Studio; schema design (ERWin, ER Studio, IBM DA); running on Red Hat Linux with VMware. Solutions also include RDBMSs: Oracle, DB2 UDB, Teradata, MySQL, SQL Server and Postgres. Beyond Kafka, data migration also into aws S3 using Kinesis Firehose and also Direct Connect, SnowBall (via secured appliance), Storage Gateway, and Transfer Acceleration all driven by use case. Vendor management. Research and training on Neo4J graph database, DevOps (GitLab) and Cloud Design Patterns. Preparing to run a set of POCs using Snowflake, Redis, Glue, Matillion, Kenesis, Spectrum, Athena, and Aurora on the AWS stack and BigTable on the Google stack. Utilize Gartner and Forester global research for insights into Technology solutions leaders.
• Improved database performance thru SQL tuning and physical data model design schema on various Cloud technology platform configurations with Hadoop, Amazon AWS (MPP DynamoDB, Redshift, S3, EC2, RDS), SoftLayer (MPP dashDB, Bluemix, Object Storage, IBM SparkML, and MPP DB2 UDB in BigInsights running on Hadoop). Data sources were structured, semi-structured and unstructured data. Built Linkedin data model with ERwin.
• Supported business management decision makers with analytic solutions to assist in making good fact based business decisions.

Confidential

Data Architect/Enterprise 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.
• Most of these analytics are Predictive Analytics with the remainder Behavioral & Prescriptive in the decision science space. Data Mining methods were used to uncover patterns in data that yielded the highest probability and rate of return on trades.
• Explored and test various AI, neural networks, MachineLearning, and Deep MachineLearning solutions. Explored Spark with ML and Mahout ML libraries. Research various ivy league university studies discussing limitation to these technologies. Work several game theories: Monte Carlo, Bayesian, and Nash Equilibrium. Evaluated and analyzed algo statistical outliers, clustering and more.

Confidential

Data Architecture/Enterprise 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 private clients using ERwin.
• Analyze data (data quality, data definitions, data profiling, data catalogue) and industry data models as needs require using Erwin

Confidential

Predictive Analytics/Behavioral Analytics

Responsibilities:

• Designed, built and implemented 3NF Confidential 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.

Confidential

Predictive Analytics/KPI Analytics

Responsibilities:

• 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.

TECHNICAL SKILLS

Tools: and Software: charts, pivot tables, MS Access, Red Brick, SQL (15 years), OLTP, OLAP, Windows 10, 7 & XP, Unix, iOS and Android; multi - threading; Shared Memory Segments; Hyperion Essbase (ROLAP), ODBC, SQL Anywhere (Sybase) Open Client, SCD Type 1, SCD Type 2 & SCD Type 3, Zachman Enterprise Architecture Framework, BOK, ITIL, CMMI, DMM, DCAM (EDMC), BPR, BPM, TCP/IP, XML, API, Micro Services, MS Office Pro, Microsoft Basic, DB2 Utilities, Evoke, JCL, Collibra, Blockchain, Cryptocurrency, VisualAge for Java/Smalltalk, CICS, ECI, REXX, Omegamon, SyncSort

HARDWARE SKILLS: Intel based servers, Workstations, and Desktop PCs; Mainframes

Mobile Devices: Laptop PCs, Tablets and SmartPhones.