Sr. Business Analyst / Sr. Data Analyst / Sr. Systems Analyst

Gene A. McCormick – Resume – Page # * of *

Residing in Fort Worth, TX 76134

Due to my Mobility Issues: 100 % Remote Positions Only - NO On-Site - NO Travel - NO Relocations

Preferred Contact: - E-Mail: ********-*****************@***.***

817-***-**** - Please leave a message AND then email the Job Description to me – Thank you.

I’m usually available to receive phone calls from 2 pm (Central) to 6 pm – 7 days a week

LinkedIn Profile: https://www.linkedin.com/in/gene-mccormick-2594852/

Indeed Profile – the Skills and the Assessments sections: https://my.indeed.com/p/genem-f5zmn1u

EMPLOYMENT OBJECTIVES - JOB RESPONSIBILITIES - JOB GOALS - EDUCATIONAL OVERVIEW:

Sr. Business Analyst / Sr. Data Analyst / Sr. Systems Analyst / BI Report Developer

Seeking a position in which I can most effectively apply my training, skills, knowledge, and experience in a mutually beneficial arrangement with an employer. Once employed, my value to the employer will be enhanced by gaining additional on-the-job knowledge and experience. I’m willing to participate in employer prepaid training & certifications. After perusing this resume,

I hope the employer will agree that I could be considered an above average employable resource and a corporate asset.

Job Responsibility Overview: The workflow process starts with the elicitation and interactive analysis of the requested deliverables. The process continues on to the conceptual, functional, and technical steps, including data sourcing and conversions. Next are the documentation, development, testing, and deployment stages. The final processes are providing the deliverables in various appropriate outputs, such as: exports, dashboards, ad-hoc and scheduled reports, etc.

Job Goals Overview: I apply business quantitative & qualitative analyses and uses my design experience to provide the required deliverables, individually and/or as a team member, to support one or more of these three broad business goals:

1. Produce the regularly scheduled, ad hoc, and ongoing inputs & outputs, processes, and/or operational deliverables.

2. Provide the historical, current, and/or projected trend information to the decision makers.

3. Identify issues that may: expose fraud, waste, & abuse; reduce expenses; increase revenues; expose the need for process improvements; increase data security; reduce / mitigate risk; and/or expose regulatory compliance issues.

Education Achievements Overview:

B.S. – Business Administration & MANAGEMENT of INFORMATION SYSTEMS ( M.I.S. ) – Minor: Communications

A.A. – ACCOUNTING & A.A. – COMPUTER PROGRAMMING

SKILLS SUMMARY:

Communication skills used to translate business needs from stakeholders to technical staff and back to stakeholders, from concept through completion and documentation with on-time delivery, within budget, and utilizing best practices.

MS-SQL (T-SQL) code design, development, performance, & workflow improvement using stored procedures, user functions, import/export features and program code scripts, indexing, database & table C.R.U.D. functions.

Adept with reports, dashboards, data import & export, data analysis & database tools including, but not limited to

MS-SSRS BI, Crystal Reports, R&R Report Writer, MS-SQL / T-SQL & SSMS, MS-Excel ( including pivot tables, V & H-lookups, Index & Match lookups, formulas), MS-ETL Data Transformation Services, basic knowledge of developing MS-SSIS packages, Tibco SpotFire data visualization (similar to Tableau).

Provided analyses in A/R, A/P, BOM, CRM, CTMS, EDI, EHR/EMR, ERP, G/L, P/O, P/R, POS, inventory control, warehouse management, order management, and sales & marketing.

MS-Power BI user, NOT developer, to provide data for periodic analysis and reports.

ETL data cleansing, conversion, and integration creating Data Transformation Services packages (MS-DTS).

Basic knowledge of creating, and limited experience with, MS-SSIS ETL packages. (2 or 3 simple packages created.)

Warehouse and Data Mart modeling and analysis ( Star & Snowflake )

Actionable analyses provided in the healthcare, pharmaceutical, retail, manufacturing, and petroleum sectors, as a project co-ordinator, or as a team member, or as an individual contributor.

Experienced with EHR/EMR data and systems. Passed all sections of the EPIC pre-qualification exams.

Proficient with relational databases ( OLTP ) and data warehouse structures ( OLAP – Star & Snowflake ).

Experienced with proprietary applications & commercial applications, such as, QNXT at Molina, DST’s PowerStepp / InfoStepp at Cook Children’s (Big Data), and ERP/MRP Vantage system at various clients.

Experienced with various analysis methodologies, processes, and tools such as SDLC; Waterfall; Hybrid; Agile; Sprints; Short-Cycle Iterations; and Daily “Stand-Up” Meetings

Involved in all phases of Testing: unit, peer, regression, user acceptance (UAT), and Q/A (QAT).

Gene A. McCormick – Resume – Page # 2 of 2

EMPLOYMENT HISTORY: ( for the last 12 + years )

Employer: Molina Health Care – Las Colinas, TX

Employed: 10/2018 to 08/2019 - Job Title: Senior Data Analyst ( on-site & remote )

Healthcare / Health Plan Administration - Medicare, Medicaid, Marketplace, CHIP, STAR, STAR-Plus – PHI / HIPAA

Perform MS-SQL /T-SQL programming & analysis

SQL (QNTX) developer to create database objects such as, stored procedures, user functions, views, indices, and program code scripts – Also: SQL table & record level C.R.U.D. functions, execution plan analysis, SQL embedded in Excel workbooks, etc.

Develop MS-SSRS BI reports (standard reports, sub-reports, matrix/pivot reports, etc.)

Develop ETL – MS-DTS-Data Transformation Services

Basic knowledge of MS-SSIS ETL packages

MS-Power BI user, NOT developer, for analysis & reports

Develop dashboards, imports, and exports

Excel - matrix/pivot reports, V & H and M & I Lookups, etc.

Business analysis, Data analysis, System analysis, etc.

Database analysis, modeling, data mapping & ERD’s

Warehouse and Data Mart analysis ( Star & Snowflake )

Elicit and document user requirements

Create business, technical, & functional specifications

Testing - unit, peer, regression, UAT, QA, etc.

Use & update Jira project management tool

Use & update Jira ticketing tool

Develop QNXT SQL to create SQL objects, SSRS reports, Vendor exports, Excel workbooks, and other deliverables

Report documentation & user training

Seeking opportunities for full-time employment

From 08/2018 to 10/2018

Employer: Cook Children's Health Care Systems - Fort Worth, TX

Employed: 01/2012 to 07/2018 - Job Title: Sr. Applications Systems Analyst - BI Report Developer ( on-site & remote )

Healthcare - Texas State Health Plan Administration - CMS, CHIP, STAR, StarKids – PHI / HIPAA compliant

Perform MS-SQL /T-SQL programming & analysis

Develop SQL to create database objects such as, stored procedures, user functions, views, indices, and program code scripts – Also: SQL table & record level C.R.U.D. functions, execution plan analysis, SQL embedded in Excel workbooks, etc.

Develop MS-SSRS BI reports and Crystal Reports (standard reports, sub-reports, matrix/pivot reports, etc.)

Develop MS-ETL – Data Transformation Services

Basic knowledge of MS-SSIS ETL packages

Develop dashboards, imports, and exports

Excel - matrix/pivot reports, V & H and M & I Lookups, etc.

Business and Data analysis

Database analysis, modeling, & data mapping

Warehouse & Data Mart analysis ( Star & Snowflake )

Elicit and document user requirements

Create business, technical, & functional specifications

Testing - unit, peer, regression, UAT, QA, etc.

Use & update SharePoint team collaboration tool

Use & update Liquid Planner project management tool

Use & update ZenDesk ticketing tool

Use & update CCHCS database, tables, etc.

Report documentation & user training

Employer: TekSystems, Inc. - Fort Worth, TX

Employed: 07/2007 to 01/2012 - Job Title: Business Analyst - Crystal Report Developer ( on-site & remote )

Contracting Agency for several clients:

1. ALCON Labs / Novartis – Fort Worth, TX

2. 2W-Tech – Chicago, IL ( remote )

3. Technical Chemical Company – Cleburne, TX

4. Dallas Independent School District – Dallas, TX

Epicor Manufacturing ERP / MRP System-, BAQ’s & Tools

Develop SQL to create SQL objects, Crystal reports, etc.

A/R, A/P, G/L, P/O, inventory, warehouse, sales, financial, manufacturing, BOMs, sales & marketing, CTMS, etc.

Excel – formulas, matrix/pivot reports, V & H Lookups, etc.

Develop R & R Report Writer reports

Database analysis, modeling, & data mapping

Develop Crystal Reports (standard reports, sub-reports, matrix/pivot reports, charts, graphs, etc.)

Management, user, client, & vendor interaction

EDUCATION ACHIEVEMENTS:

B.S. – Busn. Admin. and

Management of Information Systems ( M.I.S.)

Minor: Communications

San Jose State University ( CSU ) – San Jose, CA

Graduated with Great Distinction – GPA: 3.67 / 4.00

Nominated and inducted into two national honor societies

A.A. – ACCOUNTING

Foothill College – Los Altos Hills, CA

Graduated with High Honors – GPA: 3.74 / 4.00

A.A. – COMPUTER PROGRAMMING

West Los Angeles College – Culver City, CA

Graduated with Great Distinction – GPA: 3.66 / 4.00

OTHER INFORMATION:

U.S. Citizen

Veteran – U.S. Navy – Honorable Discharge

Secret Clearance, Lapsed

Phi Kappa Phi National Honor Society

Beta Gamma Sigma National Honor Society

Time Magazine's Person-of-the-Year for 2006

Contact this candidate