Data Analysis Analyst

EXPERTISE / KNOWLEDGE

Business scope definition

Business requirements gathering

Technical specs documentation

Functional design

Data analysis & profiling

ETL

ERD

Legacy systems conversion

Complex data reports development

Relational databases

Dimensional modeling

(star & snowflake schemas)

BI (SSIS, SSAS & SSRS)

Complete SDLC

SQL & Oracle DB

SQL & PL/SQL

SQL* Loader

PC/FOCUS

FOXPRO

ASP.NET

Cold Fusion

MS Visio

KEY SKILLS AND COMPETENCIES

Strong analytical & critical thinking

Excellent organizational & interpersonal skills

High attention to details

Perform well in a pressurized time sensitive environment

An excellent problem solver

Effective written & oral communication

A self starter, a fast learner

ACADEMIC EDUCATION

Cal State University of Fullerton B.A. Degree in M.I.S.

AWARDS & RECOGNITIONS

Have received many Awards & Recognitions for outstanding performances on volunteered and assigned projects

PROFESSIONAL SUMMARY

Extensive experience in business scope definition, business requirements gathering, technical specs documentation, functional design, data analysis, data definition, data cleansing, data mapping, ETL, ERD, various types of reports development, project technical documentation, end-users training, support & trouble-shootings and applications maintenance.

Successfully worked with cross functional teams i.e. IT infrastructure group, management, peer Programmer Analysts, projects liaisons and key-end users to have successfully delivered many applications on or before time with exceptional quality and efficiency; as such, receiving many positive customers survey feedbacks, Awards and Recognitions for outstanding performances

Produced numerous reports and analysis per management’s request to support them in their vital business decision making

Expertise in getting directly involved with the development and upgrading of various RDBMS (Oracle, SQL, FOXPRO & PC/FOCUS)

WORK EXPERIENCE

O'Neil Digital Solutions, LLC - Sr. Business Systems Analyst

(12/19/2022 - 04/04/2023)

Worked closely with the Systems Engineering team of developers, composition department and business stakeholders to create the json structure implementing the business requirements logic to properly generate the master image for production printing. Was directly responsible for providing subject matter expertise, technical aptitude and guidance in developing innovative solutions.

Participated in meetings with clients to understand client business goals and suggested effective technical solutions

Conducted business requirement gathering for BRD creation

Performed extensive source data analysis to architect schema layout to IT developers

Performed gap analysis & data validation as needed

Learned current SQL DBs structure to create additional dimensions and tables as needed

Studied data dump relationship extensively in order to create effective .json structures

R4 SOLUTIONS - Sr. Data Analyst/BSA/Data Modeler

(01/22/2018 - 03/31/2020)

Worked in the Data Warehousing department as a Sr. Data Analyst on SQL Migration project consolidating numerous SQL versions & server applications (SQL2000, SQL 2005, SQL 2008, SQL 2012) to SQL 2016; Also worked on several other projects such as CRC (Coordinated Regional Care), Caradigm and RL6:

Participated in meetings with SMEs to understand source systems and how those systems should be mapped to end system data models (CRC, Caradigm, ODS, RL6)

Performed extensive data and data model analysis to understand their structures and functionalities

Identified key data connections, import and export files

Performed gap analysis & data validation as needed

Conducted business requirement gathering to understand business concepts and how they related to data, ERD and systems

Reverse-engineered about 20 SSRS reports from different servers and SQL versions to document all the technical specs related to them

Created the following documentations for the fore-mentioned projects:

Flowcharts

Data mappings

Data architecture diagrams

Technical Specifications

PowerPoint presentations

Worked on the Whole Child Model project as a Sr. BSA:

Conducted requirements gathering sessions with key end-users for the WCM Required Monthly Reporting Metrics report

Created data mappings & BRD documents

Performed data validation as needed

Worked on Encounter Response Automation Process:

Conducted requirements gathering sessions with business manager to gather business requirements

Created ERDR (Encounter Response Data Repository) flowchart

Created EETER (Encounter End to End Reconciliation) flowchart

Created EBTP (Encounter Batch Tracking Process) flowchart

Assisted developers in implementing Encounter Batch Tracking Process (understanding tables, data population and update) on how to track file from end to end (raw files to final data consumption)

Created the Encounter Dashboard Enhancement BRD

PERSONAL PROJECT - Data Analyst / SQL Developer

(01/2014 - 12/2015 / Personal Project)

Developing a web-based application website using ASP.net in the front end and SQL DB in the back-end:

Conducted business process definition and business requirements gathering

Performed data definition, data analysis, data population and ERD designs (conceptual, logical & physical)

Coded website data reports using SQL

MEDSEARCH - Reports Developer/Data Analyst

(09/2010 - 03/2011)

Analyzed & validated company’s existing clinical healthcare system’s ERD

Conducted business needs analysis, business requirements gathering & composed technical specs documentation

Performed clinical data definition, data analysis, data cleansing, data validation and data population (ETL)

Coded numerous healthcare data reports using PL/SQL & SQL

Worked closely with management in producing many customized reports per clients’ special requests by identifying key data requirements and integrating them from multiple data sources

BOEING - Programmer Analyst II

(01/1990 - 12/1993 & 07/1995 - 12/2006)

BPERS (Boeing Pride Employee Recognition System, a web-based relational application using ColdFusion and Oracle)

Participated in business scope definition, business requirements gathering & composed technical specs documentation

Performed thorough data analysis, data definition, data uploading & table (data) population

Designed ERD

Delivered end-users training and on-going system support

ECWRP (Estimating, Contracts and Web Reports Pricing System, an Oracle Reports module containing numerous complex query reports with multiple user-parameters implementation)

Facilitated end-users meeting sessions in defining business process scope and gathering business requirements

Performed data analysis & ETL

Extracting Documentum data necessary for custom reports creation

Successfully translated business needs to detailed development specifications

Incorporated numerous pre-scheduled & pre-run Oracle Reports (in .rdf format reports, using AutoSys & CRON jobs and ECWRP shell script file) and other required Adobe Acrobat .pdf files

Provided application training to supporting staff, post system maintenance, trouble-shooting and end-users support

SHEA (Safety, Health, Environment Affairs System, a web-based relational database application using ColdFusion and Oracle DB - 4D legacy system conversion)

Coordinated with the former 4-D DB owner, IT infrastructure personnel in determining its business requirements & composed technical specs documentation

Successfully designed ERD (conceptual, logical & physical models)

Performed data analysis, data mapping, ETL, data validation

EPS (Estimating and Pricing System - a database application written in PC/FOCUS)

Designed many mini-databases extracting data from EPS twisting system logic to produce numerous essential “horizontal data” custom reports

Coordinated with Estimating & Pricing liaison to determine new business requirements and incorporated those data into EPS

Released numerous EPS versions to reflect major accounting data updates and system logic changes

Updated data (rates and bid factors) using flat files on a frequent basis

Coded numerous canned, generated & distributed ad-hoc data reports in support of department’s needs and management’s special requests during proposal bidding process

Performed system testing, deployment, trouble shooting, proposal set-ups, supporting staff training and direct end-users support

CPS (Common Pricing System, RDBMS using Seagate Holos software):

Played a role as one of the key-personnel in deploying CPS for Long Beach division

Participated in meeting sessions with cross functions, managers and supporting staff identifying business needs, procedures & processes

Coordinated with Seattle and Long Beach IT infrastructure team in testing and implementing CPS in different Windows environments (i.e. Win95, Win2000 & WinNT)

Composed CPS integration process manual

Assisted end-users during installation process

Contact this candidate