Lead Data Analyst Resume
Jacksonville, FloridA
TECHNICAL SKILLS
Languages: SQL, SQR, PL/SQL, UNIX Shell Programming, Java Script, PowerHouse/COGNOS, SPSS
PC: Windows 10; Microsoft Office 2016
Platforms: UNIX HP9000, MPEX HP3000, DEC UNIX, AIX UNIX
Databases: Red Brick Data Warehouse, Allbase, MS - Access, Sybase 12, DB2, Microsoft SQL Server 2005-2012, MongoDb, Oracle 11g, IBM DB2, PostgreSQL
Schedulers: OCS, Maestro, PowerMart
Data Modeling Tools: Erwin, ER/Studio, Power Designer 16.0, PowerBI
Data Design and Extraction Tools: PowerMart, Power Designer, Pervasive Business Integrator Pro 8.10, SSIS, Clover ETL.
Other Tools: SQL Navigator, Cast Workbench, Toad Data Point 4.3, PL/SQL, SQL Developer
Report Designer: JasperSoft Studio Professional, Actuate Report Designer, SSRS
PROFESSIONAL EXPERIENCE
Confidential, Jacksonville, Florida
LEAD DATA ANALYST
Responsibilities:
- Lead data mapping and gap analysis for Florida Blue’s start-up Integrated Customer View (ICV) project which involves identifying customer profile, preference and consent data requirements from many source systems, APIs, various databases, and event bus.
- Create a common data model to be used for a data lake for consumption by all core systems.
- Work in close collaboration with a team of architects, developers, and business system analysts to define a data integration solution for Individuation - a process which will create a single profile of each Party and its roles, and My Life Plan Product for Medicare Advantage member with the Integrated Customer View project.
- Develop and communicate a deep understanding of client needs, perform analytical deep-dives to identify problems, opportunities and specific actions required for designing data migration from DB2 Relational data sources to PostgreSQL Preference and Consent target database.
- Create and maintaining the logical SQL/NoSQL data model for the Preference and Consent Database. Works with developers and architects to implement physical database based on logical data requirements.
- Work with cross-functional teams to rapidly execute and iterate in a Scrum environment.
- Lead analysis and design of data flows for all Florida Blue’s Enrollment processes through creating Visio Data Flow Diagrams which will be used by architects and developers for integration of new Preference Management System.
- Collaborate on design of wire-frames for Consumer Preference Administration User Interface Proof of Concept (POC) for ICV project.
Confidential, Dallas, Texas
DATA MODELER/PROFESSIONAL SERVICE CONSULTANT
Responsibilities:
- Provide professional consulting services on multi-million-dollar project implementations across Canada, and the United States, including projects for the Aspira Connect platforms for government agency systems, including the state of Colorado Departments of Wildlife and Parks and Texas Parks and Wildlife.
- Drive complex deployments of Active Works Outdoors/ Reserve America while working with the customers to solve their unique problems across a variety of use cases.
- Interfaced with government clients at the state/province level daily in both the United States and Canada. (Texas Department of Wildlife Parks and Colorado Parks and Wildlife)
- Internal User Acceptance testing, configuration and implementation of enterprise SaaS product, supporting data migration and operational support.
- Participated in management of projects with many different teams to ensure timely delivery of projects such as: development, product development, quality assurance, project management, client management, technical account management, data services, infrastructure, and support.
- Share best industry practices and create innovative solutions to push user adoption and maximize the value of the Active Works Outdoors and Reserve America platform.
Confidential, Dallas, Texas
SENIOR DATA MODELER/JasperSoft Report Writer
Responsibilities:
- Collects, summarizes, analyzes data to provide insights that facilitates decision making to improve customer experience, to measure the success of the company’s objectives, and to provide solutions for reporting needs
- Improves customer experience by providing technical leadership and best practices in the design, development, and deployment of complex data models.
- Performs report development using JasperSoft Professional Studio for US/CA YMCA client of Confidential including data analysis and SQL query and stored procedure writing.
- Analyzes business requirements and translates them into technical solutions.
- Contributes to the development lifecycle including gathering and understanding of requirements, database and report development using SQL Server 2012.
- Troubles shoot data issues, validate result sets, recommends and implements process improvement
