SUMMARY

• I am a Business Analyst with over 20 years’ experience with data and small to enterprise - level solutions.
• I have excellent communication and written skills and have led or worked in full lifecycle business processes.

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

Sr. Business Analyst\Modeler

Responsibilities:

• Working in Professional SCRUM lifecycle;
• Part of the design team for the atomic ODS to combine multi-source data and deliver robust reporting;
• Working with Business Product Owners to translate needs into actionable Business Requirement Definitions;
• Performing, analysis, creating BRDs, and data dictionary definitions and examples for Group Benefits;
• Helping to develop POC to demonstrate available technology and practice was leveraged fully in the design;
• Helping to drive collection of new data and refinement of existing data sources to continually improve data quality;
• Working in a model-driven environment, assessed, redefined and provided POC of the analysis methodology, from application data stores to the ODS, moving process from spreadsheets to modeling;
• Working with Commercial Lines and Group Benefits on the articulation of the data dictionary to ensure definitions are robust and meaningful within the context of the business’ use of its data;
• Turning business requirements into functional and data specifications for the Booklet report via the new ODS;
• Leading the technical lifecycle of data presentation from data sourcing to transforming into user-facing metrics;
• Translating business requirements into a data design models and reverse engineering data dictionary;
• Leading JAD sessions for conversion of high level business requirements into functional and technical specs;
• Developing and maintaining library of function specifications and Change Management via SharePoint;
• Addressing product owner questions, data integrity, monitoring business rules, and reporting requirements;
• Helping to evolve the eDW by working with Product Owners to develop a roadmap for BI reporting and analysis;

Environment: IBM IIW\IAA v8, ErWin 9.1, Infosphere Data Architect v9.1, Rational Software Architect v9.1, SQL Server 15, CA Rally; MS\Excel, MS\Office Suite

Confidential, Farmington, CT

Sr. Business\Data Analyst

Responsibilities:

• Engaged to complete the 2016 Data Initiatives and uncover data issues with the production AMISYS database;
• Worked with Business Product Owners to translate needs into actionable analytic specifications;
• Conducted deep-dive analysis of Claims, ICD\CPT, REV codes across commercial and Medicare lines;
• Lead the team of Business Analysts, for the initiative; including: workload, project support and mentoring;
• As a leader in the healthcare analytics space, the organization consisted of leading Healthcare products;
• Established standards, best practices and processes within the requirements analysis practice to stem the continuation of severe data quality issues and adopt reliable, repeatable specifications;
• Contributed to the overall strategic direction of external data integration for STAR and HEDIS analytic systems;
• Identified and documented all 837 health care claim data rules while designing the data models to stage EDI;
• Conducted MDM analysis and data model design; unearthing entities, attributes, and rules from SMEs and users;
• Wrote the enterprise data dictionary, including data and business rules and constraints, for UBH and personal;
• Developed extensive subject area entity classification and performed access\functionality reviews of data access for analysis of indexes; modeling marts in dimensional and snowflake designs to meet demand of requirements;
• Developed relationships with department managers, directors and staff to uncover requirements for initiatives;
• Developed high-level conceptual models as well as proposed changes for forward engineering to production;
• Wrote complete requirements BRDs and designed solutions within SQL Server 12 and reporting environments;
• Converged disparate data from several databases to be used for CMS and HEDIS and STAR reporting;

Environment: SQL Server 12, Tableau v9.2, Data Architect, AMISYS v6/v7, 837 Data, SSRS, VBA

Confidential, Farmington, CT

Lead Business\Data Analyst

Responsibilities:

• Met with Business Product Owners to develop specifications and wrote Business Requirement Documents;
• Developed and maintained draft conceptual models, supporting the eDW and ODS across business segments;
• Performed analysis of Finance system and developed the requirements for a reporting to replace gaps;
• Prepared recommendations to build consensus on data quality issues and redesign of the reporting database;
• Supervised developer adherence to model definitions as well as rules and distribution of data protection;
• Performed analysis and concept modeling to design Finance eDW and worked with financial analysts;
• Identified data quality issues via SQL Server queries and distribution of results via ODBC Excel executables
• Wrote requirements and code to converge data from tactical databases into the eDW and report staging area;
• Managed the metadata repository and data dictionary; approved all definitions and worked with data steward;
• Designed and developed hyper automation reporting to eliminate manual intervention using Visual Basic for Applications (VBA) into Excel while replacing Crystal Reports and Emailed files

Environment: MS\Access, SQL Server 12, Crystal Reports 10, ER/Win 9.1, MS\SSMA, VBA

Confidential, Bristol, CT

Enterprise Business Data Analyst

Responsibilities:

• My primary responsibility was to manage requirements, promote the analysis practice at Confidential and to assist in preparing databases for enterprise architecture by leading the Data Inventory and Data Quality efforts; including reverse engineering to business models, profiling and organizing tactical models;
• Conducted SQL data analysis and profiling; deliverables included metrics about the data;
• Laid the groundwork for enterprise requirements and data design as the pre cursor to master data governance;
• Built and maintained relationships with data owners and subject matter experts; selected five groups from across the enterprise and reverse engineered their core data requirements into subject areas and entities;
• Led functional requirements analysis and conversion of nine Logistics applications into one vendor provided system; my role was to define the data requirements by employing data profiling and model harmonization.
• Wrote and performed all data analysis for the enterprise data glossary by reverse-engineering Confidential - functional knowledge from databases and meeting with SME’s; including linking the glossary to source data model.
• Performed data modeling to design the Sports Data Repository warehouse and data feeds; working with sports analysts to anticipate reporting needs, utilizing Oracle ODI CDC for mapping and integration
• Identified data quality issues by "mapping" databases to an Enterprise Architecture, as well as identifying disparate and redundant artifacts within Subject Area Models as the basis of Enterprise Data Models (EDMs)
• Managed the metadata repository, recommend data design principles and method
• Created and wrote the enterprise data dictionary by conducting JAD sessions and reverse-engineering Confidential - functional knowledge from databases and working with SME’s; includes linking glossary to the source models;

Environment: Oracle 11g, Business Objects XI, PowerDesigner 15, SSIS 2012, SQL Server 2012

Confidential, Middletown, CT

Business Analyst\Modeler

Responsibilities:

• Lead Information Architect on PROOF OF CONCEPT application that took Prescription Drug data, Health Risk ASSESSMENT data (XML), Claims data and sample EMR data into a single ORACLE database, run against Health Risk ANALYSIS and Predictive Modeling algorithms provided by the University of Michigan;
• Promoted and published Information Architecture principles and strategies to improve the quality and consistency of model-driven designs within the Medical Management Division;
• Built and maintained relationships with business/functional owners and performed Data Analysis and Data Mapping from mainframe databases and transactions to new mission critical applications listed above.
• Responsible for developing and reviewing Domain Information Architecture artifacts, consisting of Crude Matrix Diagrams, Definitions, Naming Standards, Access Path Analysis, Models, Use Cases and Development Designs;
• Designed data models for Member Opportunity Action processing, Member Deficit, Goal and Activity processing;
• Data Profile work and Data Mapping from mainframe databases to mission critical applications listed above;
• Designed and implemented the Radiology Benefit Management reporting mart within the eDW;

Environment: Oracle 10g, SQL Server, Talend, Business Objects XI, PowerDesigner 14, Erwin r8

Confidential, Bloomfield, CT

Business Analyst\Modeler

Responsibilities:

• Worked on an Agile team, designed, and tested incremental components of the design under a RUP framework;
• As part of the Clinical Data Repository (CDR) team, worked directly with business to develop requirements;
• Developed queries to interpret highly complex databases behind the XML Assessment and Questionnaires and transformed them to conform with University of Michigan’s Trend Management;
• Lead Information Architect on their PROOF OF CONCEPT application that took Health Risk ASSESSMENT data (XML), Claims and sample EMR data into a single database, where it was then run against Health Risk ANALYSIS and Predictive Modeling algorithms provided by the University of Michigan.
• Developed queries to interpret highly complex databases behind the XML Assessment and Questionnaires and transformed them to conform to University of Michigan’s Trend Management data.

Environment: ErWin v7, RDA v7, ORACLE 10g, SQL Server 2005, DataStage, ClearCase, SharePoint

Confidential, Danbury, CT

Business Analyst\ Modeler

Responsibilities:

• Relocation, policy, and Business Intelligence applications: As lead, developed models to enhance the ATLAS application through extensive development of complex SQL Server queries to prove data design for marts, POCs,
• Data Profiling: Documented Edge attribute definitions from original specs and through Semantic Analysis; including data mapping from several tactical applications and databases to new Edge universal database;
• Created aggregate and star schemas derived from the normalized database to collapse database to aggregates;
• Worked with BA to document requirements and wrote development specs;
• Created logical and physical models, wrote queries to verify database and ETL\load hierarchal data into reporting;

Environment: ErWin v7, MS Server 2005, T-SQL, MS SSIS, PCVS, Business Objects 6

Confidential, NA

Business Analyst\Data Modeler

Responsibilities:

• Project: Consumer Goods, Demand Planning and Forecasting applications; Designed and implemented projects focused on data transformation, inventory, and in-transit automation of the Gevalia premiums warehouse project;
• Reverse engineered\specified, designed and developed Demand Planning forecasting based on Excel macros;
• Developed procedure code to track movement of Gevalia premiums across the water (Europe and Scandinavia) to support JIT fulfillment; Design included tanker tracking through US Customs.
• Environment: ORACLE 9.2, PL/SQL, MS SQL Server 2000, Manugistics 7.2, ActiveX, ER/Win 4, UNIX, FTP, Net, K-shell,, MS/DTS, T-SQL, MS/Project, UML, MS/DTS Services, dbArtisan v7

Confidential, Stamford, CT

Data Modeler

Responsibilities:

• Developed Legal\Contractual solutions, business requirements and project plan to automate 1st Draft Contracts for the legal department;
• Drafted specs and object models; Staffed the project; Delegated assignments; Prototyped with attorney’s to clarify functionality; Supervised on and off-shore programmers; Managed budget;