SUMMARY:

• Implements data warehouse and data visualization (BI) solutions focused on heterogeneous data sources that emphasize the exploitation of BIG Data (250+ TB) using various database technologies and tools, and leading many of them as the Senior Architect.
• Works, through discreet technical projects, with organizations that require a seasoned professional who possesses broad domain experience in such fields as: Banking, Energy, Financial Services, Healthcare, Insurance, Manufacturing, Pharmaceuticals, and Telecom; a solid understanding of customer and market dynamics along with the ability to articulate the technical vision to meet those market opportunities.
• Shifts the focus and reusability of the data from sets of stand - alone silos to common universal interface mechanisms (API) that promote concurrent access by different modeling products such as SAS, R and MatLab; as well as by other advanced specialized technologies that present Data Visualization, Geo-spatial, Geographic and Text mining (NLP) paradigms.
• Develops hands-on POC solutions, using data supplied by partners and customers, intended to reflect how the desired functionality can be configured and perform, if deployed in a production environment. Typical recent examples, for Confidential, include P&C claims fraud prediction, Health Care provider scoring and Mortgage fraud analysis.
• He has a proven track record of building 21st Century shared services technology platforms that encapsulate the data analytics and business intelligence function, sometimes from scratch.
• Led (in 2013/2014) the upgrade of the GRID from a 32 bit Windows platform running SAS version 9.1.3 (a five year old version) to a 64 bit LINUX platform running SAS 9.4 (the most recent version). At the same time upgraded the MS SQL Server, the Data Warehouse Platform, from release 2008 R2 to release 2012, while evaluating the move to release 2014. The effort achieved a high-performance parallel Data Architecture system that embraces segmentation and partitioning in its storage while accommodating columnar data access from over 300 heterogeneous sources.
• Participates in efforts to define future state architectures and roadmaps including architecture standards, guidelines, and industry best practices around cloud technologies such as those offered through AWS, and focused on their adoption to support evolving business initiatives. Emphasis placed on collaboration with infrastructure and application groups to assess business readiness for cloud technology adoption, manage stakeholder’s expectations, and promote organizational change and integration into a Service Management framework.
• Researches how new data technologies, such as column-oriented MPP and in-memory NoSQL databases, complements and integrates effectively with the existing enterprise data warehouse. Specifically considered how Hadoop can be an efficient staging and ETL source for the existing data warehouse, based on MS SQL Server 2012.
• Years of working with teams of developers and business partners in fast-paced enterprise environments. Persistent, industrious and with a demonstrated ability to produce high- quality products. Possesses excellent problem-solving, communication and documentation skills.

TECHNICAL SKILLS:

Databases: MS SQL Server, Oracle, DB2, EMC (Greenplum), MySQL, MS Access, Redshift, Snowflake and Sybase

MultiDimensional: MS Analysis Server (SSAS), Hyperion Essbase, SAP BW, and OBIEE

Business Intelligence: BI reporting (ODS, EDW, DM, OLAP, ROLAP, MOLAP), Qlik, Tableau

Data Movement: Data-Transformation (ETL/ELT), MS Integration Server (SSIS), Import/Export, Talend, Datameer, Informatica, SAS, Alteryx

Other: Meta-Data Repository, SQL Tuning and Optimization, TCP/IP, OOD

ERP: SAP R3, Indus Passport, and Oracle Financials

Computer Languages: Java/J2EE, JavaScript, PL/SQL, HTTP, XML, Revolution R Enterprise (an enterprise distribution of R), SAS

Operating Systems: Microsoft Windows for x64, Red Hat Enterprise Linux for x64, Middle Tier, JRE, Amazon Web Services (AWS), and Mainframe OS platforms

PROFESSIONAL EXPERIENCE:

Confidential

Principal

Responsibilities:

• ITG, a professional services practice delivering practical twenty-first century business solutions that infuse innovation and strategic differentiation into existing and new product sets by incorporating predictive analytics over very large datasets. Typical deliverables include technology roadmaps that define a path of development, that incorporates technology platform architecture and application feature functionality, for new and/or enhanced products, services, and/or optimized business processes to exploit big data; as well as procedures and guidelines focused on security and privacy in the data warehouse with the intent to adhere to Data Governance standards around PII and HIPPA data including data use process mapping, data classification, data stewardship and data retention.

Confidential

Director Data Warehouse

Responsibilities:

• Using extensive, hands-on experience in the full cycle of modeling data preparation, achieved the goal by extending the data management platform and its warehouse to in corporate over 300 heterogeneous sources, fed through a Data Lake, and be the central repository for data used in sophisticated analytics by model developers.
• Provided BI and Analytics operating metrics through concise, accurate and attractive reports, graphs and dashboards using enterprise business intelligence/portal technologies including Confidential, Tableau and Qlik, to senior management and others in pursuit of company success. Some of the metrics included Competitive Analysis, Market Share, Market Penetration, as well as Revenue and Burn.
• Continually researched new data sources and established relationships with third-party data vendors to develop partnerships for data integration into Verisk products.
• Overseen the acquisition, enhancement, refreshment, normalization and deployment of the data used by the predictive risk products both while in development and later in production.
• Responsible for the design, development and support of over 200 new and existing ETL packages that leveraged the scheduled bulk loading features obtained in MS SSIS and Stored Procedures, and creating templates that utilize industry standards and best practices to facilitate the asynchronous loading and incremental refreshment of data from diverse sources such as Operations, Customers, Partners Vendors and Public. Exploited the graphical tools and wizards SSIS includes to achieve self-documented packages.
• Ingested more than another 100 data sources using other tools and techniques such as MS SQL Import/Export, SAS, and Informatica.
• Selectively used the data sources to provide model-ready analytic data sets that comprise large, complex structures (e.g. 5+ data sources, 10M+ rows, 100+ columns, multiple appended derived values).
• Hands-on developer/contributor of practical reusable artifacts such as Entity Resolution (Who Is Who) and Network Analytics (Who Knows Who) based on relational set theory and using complex stored procedures.
• Achieved the results while maintaining the unshakeable commitment to not violate internal or external customer’s implicit or explicit assumptions about the privacy of the data. Evangelized protected data and privacy procedures in compliance with corporate privacy and security policies. He has authored the “Verisk Analytical Framework Data Privacy and Security”, articulating the procedures viA follows when handling PII and HIPAA data.

Confidential

Senior Director

Responsibilities:

• Established current and long range objectives, plans, and policies including technologies used, phases and schedules for implementation, and new product lines. Created technical budgets, project plans, allocated resources, and determined schedule of product releases and project deadlines.
• Implemented the initial production release within a period of six months employing Agile methods. Led and managed a team of 50+ highly-skilled software engineers, database programmers, systems administrators and web developers consisting of Confidential employees augmented with selectively outsourced onshore-offshore services, under unified direction and control.
• As the Chief Architect, led the development of the web service based branded application solutions through the use of such technologies as Java/J2EE, XML, HTTP and RDBMS. Continues to identify architectural direction for expanding software capabilities focusing on scalability, cross-platform support and business intelligence reporting.
• Unified relevant BI technologies (e.g. data warehousing, OLAP data marts and cubes, easy to use dashboard and reporting tools) through the proprietary Java based Business Intelligence component designed to work with multi-dimensional data structures generated from software provided by Hyperion, Microsoft, SAP and Oracle; in addition to the other leading relational data base vendors (Oracle, SQL, DB2, and Sybase).
• A sample solution: Implemented a Supply Chain Management Solution (UnipollPlus) for managing liquid inventories in the Oil, Gas and Chemical Industries. It is a good example of a Confidential deployment of contemporary e-commerce systems technologies, including web site and database search, web servers, application servers, catalog and order management technology, application integration middleware, and ERP interfacing. It is an end-to-end solution allowing customers to graphically analyze bulk fluid inventories and tank telemetry data, access and manage workflow routes used to generate wireless alerts and reports, and translate supply chain events into seamless business transactions (e.g. Threshold-based Reorders), all via a standard web browser. By harnessing the power of our data collection processes, Supply Chain information, such as bulk inventory levels, usage rates, and where implemented, custody transfers, is readily available. Confidential a single enterprise view, suppliers and distributors can deliver timely information to their customers as a competitive advantage. In today's market it's critical for suppliers to be able to closely manage inventories and effectively communicate status throughout the supply chain.

Confidential

Director, Professional Services

Responsibilities:

• Reporting to the CEO, created a professional services practice devoted to supplementing licensed software offering and generating necessary revenue ($5M annually, on top of license fees) commensurate with early stage company. Responsibilities included growing the professional services department from 4 to 25 employees over a two year period with a $1.9M budget.
• Exploited the thin-client for SAP Business Warehouse to create local language oriented “universes”. Customers can bring forward historical information from SAP BW and other existing systems into a service-oriented environment. These reusable services, which leverage the Enterprise Business Intelligence technology, simplify access to complex packaged applications, and accelerate dashboard, single-view, ad-hoc reporting, and service-oriented architecture (SOA) projects. They are also a powerful alternative to the EDI and Data transformation (ETL) services available in the marketplace.
• A sample engagement: Chief Architect and Lead Data Engineer for 21st Century version of Confidential &E Energy Management System ( Confidential ). The computers monitoring the electricity supply-chain feed gather (using bespoke ETL) real-time telemetry information into an Oracle data warehouse. The multiple terabyte data warehouse rapidly delivers gigabytes of historical and near real-time data, spanning days, in the form of energy-demand reports and electrical diagrams, to 20,000 Confidential &E employees.