Data Analyst Quality Assurance

John DiMartino

Phone No.:573-***-**** E-Mail: *********@*****.***

Data Analyst – Requirements Gathering Data Structure Quality Assurance Application Design

An accomplished and business savvy professional with robust experience acquired over the years in delivering optimal results & business value in high-growth environments and establishing key relationships with business segments. Dynamic, versatile, and detailed-oriented professional with in-depth knowledge of database types; research methodologies; and big data capture, curation, manipulation, and visualization. Skilled in conducting data mining, data modeling, statistical analysis, business intelligence gathering, trending, and benchmarking. Develop and implement test plans and test cases using documented requirements and design specifications. Work effectively in coordination with functional and technical resources. Ability to recommend improvement to support the development effort. Adept at managing large-scale projects and overseeing the entire implementation cycle. Known for developing and implementing innovative policies and procedures that enhance efficiency and efficacy across operations. Provide documentation of record layout and mapping for files delivered to and from Brokerage Data Management. Create Stored Procedures that update log tables with process steps of a SSIS Package. Design and develop SQL to access IBM AS400-DB2 data that tracks the transactions during marketing windows where special benefits or rewards are offered. Use quantitative data gathered to develop an understanding of customer behavior, demographics, and lifecycle. Ability to process, organize, plan, analyze and prioritize logically. Exceptional communication, presentation & interpersonal skills with proficiency at grasping new concepts quickly and utilizing the same in a productive manner.

~ Validated business data and rules during testing and project deployment ~

~ Created the output files that are imported via a Java ETL team into the Enterprise Aptos CRM database ~

~ Implemented DB2 queries to extract ICOMS data to export to Excel Sheets analyzed by a team of analysts comparing information from previous researched information ~

~ Built new Data Structures, update Data Map documentation and Technical Support documentation ~

Skill Areas: Strategic & Operations Planning Quantitative Methods Advanced Data Mining Business Intelligence Data Structures Requirements Gathering Quality Assurance Research Data Management Process Improvement Strong Interpersonal Skills Analytical Skills Team Management Communications Critical Thinking Systems Analysis Problem Solving Time Management Attention to Detail Client Relationship Management Innovation Leadership Management Skills

PROFESSIONAL EXPERIENCE

CVS HEALTH(AETNA) (Feb 2022 –Oct 2022)

SQL DEVELOPER

Manage or create UDF(user defined functions)

Provide support to Plan Sponsor Profile IT team to include quality assurance, working with quality assurance analysts

Design, Develop and Process new or modied Stored Procedures

Develop Stored Procedures for Ad Hoc reports and analysis

Provide support in an Agile environment following Scrum Master guidelines and respond to Story requirements.

Provide daily updates to Scrum Master meetings

Wakefield and Associates (Aug 2021 – Dec 29, 2021)

Data Analyst

Managed functions pertaining to master data, including creation, updates, and deletion

Provided quality assurance of imported data, working with quality assurance analysts if necessary

Processed confidential data and information according to guidelines

Helped develop reports and analysis

Managed and designed the reporting environment, including data sources, security, and metadata

Supported the data warehouse in identifying and revising reporting requirements

Talution Group for SMBC Rails Service (Jun 2020 – Oct 2020)

SQL Developer, ETL Developer

Responsible for developing high-quality database solutions

Power BI visuals

Analyzed existing SQL queries for performance improvements and Built appropriate reporting deliverables

Tasked with providing several SSIS packages (ETL), and Stored Procedures

Created SSIS packages to extract source data and transform data for development testing before moving the SSIS package to production

Provided Stored procedures to perform T-SQL DML loading data into one or more destination Dimension tables or Fact tables

Managed the overall process in three phases: 1.) ETL (SSIS package extracts data from other DB’s and load development database tables), 2.) Stored Procedure performs ETL (transfer source data to Staging tables), 3.) Stored Procedure performs ETL (Transfer Staging data to Production DW Dimension/ Fact tables)

Kforce For Wells Fargo Advisors (Jun 2019 – Jan 2020)

Data Analyst/ Functional Analyst - Wealth Investment Management Technology Department

Pioneered the efforts across handling the entire gamut of functions pertaining to interpret business requirements, detailed functional requirements based on Business Requirements Documents and Functional System Documents

Tasked with providing for WIM’s shared core data repositories

Assessed tests and implemented new or upgraded software and assisted with strategic decisions on new systems

Generated reports from single or multiple systems

Troubleshoot the reporting database environment and reports

Evaluated changes and updated to source production systems

Pivotal Solutions, Inc. For Caleres, Inc. – Rewards Project (Jan 2019 – Feb 2019)

Functional Analyst/ SQL Developer

Gathered and managed requirements for three Marketing type projects herein referred to as Rewards Programs

Maintained data quality and oversaw database security

Analyzed, designed, and supported applications that interface with the database computer language SQL

Contributed to Credit Back Points Rewards program for in-store purchases of Famous Footwear products

Apex Systems for Charter Spectrum – Non-Bulk MDU (Sep 2017 – Apr 2018)

Technical Lead

Provided Data Analysis of Oracle data comprised of, “Multi-Dwelling Units” type information, which is exported to Excel files for further data analysis and manipulation

Implemented extensive Oracle- PL/SQL queries to extract current production data, which is exported to Excel spreadsheets for further comparison and analysis

Provided up-to-date information for Multi-Dwelling Unit properties at various locations throughout the USA for the Marketing and Sales Departments

Designed and developed S Access-VBA applications to enable the highest level of quality control

PRIOR EMPLOYMENT DETAILS

Adaptive Business Solutions – Washington University Mar 2017 – May 2017

Database Analyst-T-SQL

Syllogisteks For Stifel Nicolaus) Nov 2016 – Dec 2016

Database Developer-T-SQL Developer – (Short Term Contract)

Air Evac Lifeteam Ems O’ Fallon Apr 2015 – Oct 2016

Data Analyst-RDMS Programmer/ Analyst-Safety Management, FTE

Paynecrest Electric Feb 2014 – Jul 2014

Relational Database Programmer/Contractor

Barnes-Jewish Care Foundation/Bjc Oct 2013 – Dec 2013

Contractor

State Of Missouri Jul 2011 – Aug 2013

Professional Musician

Nike Whq Beaverton May 2011 – May 2011

Sr. Data Analyst/Consultant

Providence Health Care May 2010 – May 2010

Sr. Programmer Analyst/Consultant

Intel Hillsboro Jul 2009 – Aug 2009

Analyst/Consultant/Contractor

Pacificorp Portland Sep 2008 – Jul 2009

Transmission, Business Analyst/Report Developer/Consultant

Regence-Blue Cross Portland Oct 2007 – Aug 2008

Senior BSA/Report Analyst/Consultant/Contractor

Nike Whq Oct 2005 – Jan 2007

Sr. Programmer Analyst/Business Systems Analyst Report Developer/Contractor

PROFESSIONAL DEVELOPMENT & CREDENTIALS

Technical Skills:

Applications SSIS, SSRS, MS Office Suite, Visio, TOAD, Erwin

Reporting Power BI, MS Access (all versions), Cognos Reports-Impromptu v 7.4, Excel, Crystal Reports Ver.7.0

Languages/ Technology: VB.Net, Visual Basic 6.0, VBA-MS Access, VBA-Excel (VLookUP, Index-Match, SumIFs, Offset, SubTotal, etc.), SQL Server- DTS, ODBC, OLEDB, ADO, MS Access -SQL, Transact-SQL, basic Unix commands

Databases MS Access (All versions), SQL Server 2012, SQL Server 2014, 2016, AS400-DB2, Oracle

Operating Systems Windows 10

Contact this candidate