Data Architect, Principal Is Consultant Resume
PROFILE:
Hands - on data strategist with 14 years of technical and 5 years of leadership experience. Technology-driven leader and architect specializing in Business Intelligence and Big Data initiatives. Diverse skillset including expertise with functional programming languages, backend data platforms, and business intelligence tools. Expert at scoping business needs and translating in to scope documents for development teams. Experience leading and managing development teams.
SKILLS:
Microsoft SQL Server (SSIS, SSAS, Master Data Services) development and administration. Cloudera platform (Kudu, Spark, Kafka) development. MicroStrategy and Cognos BI tools development and administration. Kimball data warehousing design. Transactional application design. Strong Scala, F#, SQL (T-SQL and Impala). Some HTML, CSS, JavaScript, C# and VB.NET.
EXPERIENCE:
Confidential
Data Architect, Principal IS Consultant
Responsibilities:
- Presently serving as the data architect and business intelligence team leader on full revenue cycle metrics for acute-care large health system, enterprise business intelligence initiative.
- The initiative has innovated analytics within the organization and is in the process of in-housing reporting functionality from an external vendor.
- The product operates on an on-premise Cloudera platform. Data is stored in Kudu and Parquet. ETL and data ingest applications are primarily written in Scala and utilize Spark SQL, Impala, and Kafka.
- Utilizes Master Data Services as a Master Data Management tool. Data models are geared toward direct SQL consumption and consumption by the MicroStrategy BI tool.
BUSINESS DEVELOPMENT
Confidential
Responsibilities:
- Lead a multi-tenant, client-facing analytics initiative that modernized data delivery within a business unit focuses on fulfilling hospital direct to patient outreach campaigns.
- Designed campaign tracking and revenue analytics to quantify ROI and future marketing investments for over 200 acute care hospital clients.
- Served as the principal designer and as developer on both front-end and back-end components.
- Worked with executives to determine cost and benefit, secure capital and operate within budget.
- The team consisted of three additional in-house developers and was augmented with consultants.
- The product utilized Microsoft backend and middle components particularly, SQL Server, SSIS, SSAS, and MDS alongside an IBM Cognos frontend with an add-on to mitigate concerns with the platform for an external, client-facing product.
- In addition to SSIS for internal data ingest, F# applications were utilized for consumption of external data where additional authentication was required.
- The product features interactive dashboards and self-service capabilities.
- Lead technical team for HCAHPS survey and reporting capability for 75 acute care hospitals.
- Managed shared technology associated with the administration of surveys to measure patient satisfaction with hospital services.
- Oversaw operation of an existing analytics application, prepared and submitted CMS required data for inpatient satisfaction.
- Partnered with customers in analysis, quality assurance, and product education.
Clinical Decision Support
Confidential
Responsibilities:
- Chief architect for modernization of a desktop application including transition to an internal web application that provided documentation and workflow capabilities to business unit focused on providing centralized clinical decision support for inpatient admissions.
- Required executive level cost justification to secure capital and show benefit.
- Acted as a SME and worked with operations leaders to create requirements, designed solution, and oversaw offshore development.
- Deployed, collected UAT feedback implemented solutions, and later operated and maintained the solution.
- The solution is a .NET MVC application and Windows Workflow Foundation service.
Confidential
Data Warehouse Administrator
Responsibilities:
- Joined a cross-functional team and later took over development, operations, and client training of a new analytics add-on for a commercial application.
- Apprenticed with a bioinformatics data warehousing architect and professor to model and implement a multi-tenant business intelligence solution that aggregated and benchmarked clinical data across clients and produced CMS submissions that quantified family and patient evaluations of care and clinical quality measures.
- Maintained a hosted Microsoft SQL Server and a MicroStrategy instance.
- Developed MicroStrategy schema and reports, developed and operated T-SQL ETL, and hosted user education workshops.
