NL

Nichols LaPorta

available

Last update: 06.09.2022

Informatics Senior Specialist, Data Analyst, Sr. Business Analyst

Graduation: BS Business Information Systems
Hourly-/Daily rates: show
Languages: English (Full Professional)

Attachments

NickLaPorta-August2021.pdf

Skills

SQL, DB2, Oracle, MySQL, Teradata, Hive, Impala, Hadoop, Python, R, XML, HTML, Google AppsScript, IBM Infosphere suite, Informatica, MS Office Suite, Excel, Access, Outlook, Visio, Project, Word, Clarity, Tableau, SharePoint, Confluence, GoogleApps, Data Studio, Sheets, Docs, Airtable, Data Management, Collibra, Erwin Data Modeler, Data Migration, Agile, Iterative, Waterfall, Windows (7, 8, 10), Linux, Debian, Ubuntu, UNIX, FreeBSD Server, Macintosh OS, Master Data Management, Data Ingestion, requirement gathering, data quality, Metadata, ETL, IBM, Data integration, data analysis, data stores, data profiling, testing strategies, ETL logic, InformaticaPowerCenter, scrum teams, databases, SQL queries, MS Access, Business Objects, SQL Developer, SQL scripts, project estimation, Business Objects tools, UAT testing, heat map, SDLC, add in, UAT, access controls, document library

Project history

12/2019 - Present
Agile Product Owner
Evernorth (Internet and Information Technology, >10.000 employees)

Served as Agile Product owner for two enterprise data capabilities (Data Platform/Pipeline, Master Data Management) delivering
better visibility, traceability and quality of enterprise data through automated process and self-service architecture
  • Agile Product Owner for Data Platform (multiple LOBs)
    • Liaison between technical resources and business leaders to establish, create, and execute deliverables through a multi sprint product backlog
    • Established operating model and framework for enterprise engagement (access, issue and service management)
    • Facilitated support model framework for key strategic initiatives in a matrixed environment (Business & Technical stakeholders)
    • Drove requirements gathering sessions in support of enterprise capability deliverables; Data Ingestion & Wrangling, Curation, User consumption
    • Established foundational requirements for Audit, Balance, and Controls in adherence of key compliance directives (HIPPAA, SOC1, SOC2)
    • Established guidelines for data separation/segregation across multi-corporate brands
  • Agile Product Owner for Master Data Management enterprise capability (multiple LOBs)
    • Established operating model and framework for enterprise engagement (access, issue and service management)
    • Led enterprise MDM inventory and tool evaluation to support disposition strategy and enterprise cost reductions
    • Led requirement gathering for product capability and senior director level recommendation
    • Coordinated MDM proof of concept across multiple customer domain stakeholders for Reltio vendor software
  • Support data governance, data stewardship, and reference data management offering end-user support and training on Collibra tool; Certified Level Expert 1-3
  • Managed change and incident management communications (release updates, system changes, environment notices) to Collibra business user base (~70k users)
  • Maintain Collibra feature enhancement backlog and drive execution with technical team
  • Built, managed, reported and presented monthly automated data quality reports using Hadoop and Tableau; exposing 4 dimensions of data quality data exceptions across source systems to improve overall data health and reporting capability
  • Provide Customer Data Quality reporting metrics using Tableau to improve the Master Data Management (MDM) matching functionality
  • Served as reporting subject matter expert for customer data supporting multiple source systems for customer enterprise Individual Book of Record
  • Partner with the Reference Data Management community to support and maintain all enterprise and industry standard reference data codesets for validity and accuracy

05/2017 - 12/2019
Agile Team Lead & Informatics Senior Specialist
Cigna (Insurance, >10.000 employees)

Served as the Enterprise Metadata Governance team lead developing ETL solutions to support and enrich the enterprise metadata
repository

* Led a team of three individual contributors on multiple metadata sourcing projects; successful extraction of source data for the Enterprise
Metadata Repository from enterprise-scale applications
* Developed ETL processes for Sparx Data Architect, Erwin Data Modeler, IBM Blueworks Live metadata from source system data store
through python development
* Data integration with Hadoop enhancing the Enterprise Metadata Repository store
* Advised and consulted enterprise data owners on the creation, implementation and oversight of enterprise-wide metadata; management,
practices & processes ensuring alignment with Cigna goals
* Educated and supported users in the enterprise on metadata strategy and principles of data governance
* Supported the Podium tool for enterprise metadata integration with the data lake and Hadoop instance

05/2014 - 05/2017
Data Analyst
Unum (Insurance, >10.000 employees)

Key Agile project team member responsible for data analysis, data investigation/mining and data design across multiple IT project initiatives within a highly complex and matrixed environment
* Gather and create detailed data requirements, create source to target mapping (transactional data stores and MDM hub), data profiling and
transformation development instructions through business user and audit review
* Plan and develop automated data testing strategies in Information Analyzer and Data Stage for enterprise wide data transformation project;
communicate and educate testing resources on approach and test effort for comprehensive understanding and delivery
* Lead/facilitate solution design reviews and complex business/data requirement sessions with technical and non-technical partners/stakeholders
* Responsible for identifying gaps in enterprise model to deliver business value and adherence to business specifications
* Supported delivery of data from source to Metadata stores in compliance with the Enterprise Data Management standards
* Develop ETL logic and analysis procedure solutionswith IBM Data Stage, Information Analyzer, InformaticaPowerCenter, Teradata and DB2
* Maintain relationships with cross-functional resources across multiple Agile-scrum teams to achieve enterprise business/technical objectives
* Coordinate enterprise model conversion effort from ERwin to IBM Datasphere Architect

11/2012 - 03/2014
Sr. Business Analyst
Ally Financial Services (>10.000 employees)

Served as the primary business operations support lead and business process SME for 600 employees, contractors and statement of work resources.
* Business process SME for resource on-boarding and off-boarding (Director and Senior Management support level) - Assisted all management
through each of the phases of on-boarding resources and followed-up to ensure appropriate workflow
* Assembled and maintained multiple relational databases within 4 systems of record (SORs) using SQL queries and relational databases (MS
Access, Business Objects, SQL Developer, Excel, Clarity, SharePoint); responsible for keeping data accurate and in a real-time state for
on-demand and scheduled reporting requirements
* Gathered reporting requirements and assembled reports (ad-hoc and scheduled)
* Built and configured SQL scripts for querying personnel data from enterprise-wide data sets
* Prepared executive level reporting, communications, presentations (written and oral) for weekly highlights and staffing summaries
* Supported the Director of Business Support and Sr. Strategic Planning Manager (including but not limited to portfolio planning, project capacity
reporting, monthly financial forecast reporting, Statement of Work resource management, Vendor Management, governance preparation and
execution)
* Developed and administered SharePoint repositories, data stores and workflow lists to aggregate and analyze data; configured access and
controls for all required resources/users to see and manipulate data
* Led resource planning with directors and senior management in portfolio planning cycle for FY 2014; data aggregation, communication and
presentation. Assisted capacity & resource demand discussions
* Maintained multiple sustain contractor and strategic resource financial forecasts; tracking and reporting financial data and variance to plan
* Led time tracking initiative within the Technology Infrastructure business unit to enable and realize capitalized projects as an asset, build a
knowledge base of actual project effort to improve future project estimation, and provide sustain costs by application/system.
* Maintained supporting documentation routinely (Organizational Charts, Process maintenance and improvements)
* Collaborated with HR stakeholders, talent acquisition partners and external vendors/suppliers to support on-boarding activities for resources in
major staffing initiatives

07/2011 - 11/2012
Business Analyst (Consulting with Ally)
Vaco Consulting

Charlotte, NC
Responsible for managing process improvements, change initiatives, metrics and project management software support (Clarity) within the Global
Project Management Organization (GPMO). Provide monthly & impromptu reporting using Business Objects tools (SQL), perform monthly
software UAT testing (Model & Production environments) and qualitative analysis of monthly software releases
* Built and managed a risk mitigation analysis tool (heat map) showing conflicts between environments, project schedules and milestone tasks in
all phases of the SDLC (dev, model, and production)
* Engaged with business partners to drive Clarity improvements and support project implementations on a monthly release schedule
* Designed internal metrics reporting for sr. management providing higher visibility & value-add in the PMO driving efficiencies and productivity
* Developed and facilitated Clarity training within the Technology & Operations organization




* Built and maintained business and system documentation for transparency (FAQ, How To's & Shortcuts, Learning Assessments)
* Developed test strategies based on business requirements analysis and continuous improvement models
* Managed UAT process for monthly Clarity release and continuous improvement cycles
* Developed standard regression test cases for future release testing
* Served as Test Lead/Coordinator for project execution methodology upgrade (APEX 2.0)
* Supported CA Technologies Project and Portfolio Management tool (Clarity) from a business functional role
* Created, established and maintained process workflow improvement for the Clarity release schedule providing a structured roll-out cycle
* Developed and maintained a SharePoint site for a large scale infrastructure migration program; configured group and user access controls as
well as document library management for 400+ users daily

Local Availability

Only available in these countries: USA
Profileimage by Nichols LaPorta Informatics Senior Specialist, Data Analyst, Sr. Business Analyst from SignalMountain Informatics Senior Specialist, Data Analyst, Sr. Business Analyst
Register