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

Residing in Fort Worth, TX 76134 - No Relocations

Preferred Contact: - E-Mail: adaz7u@r.postjobfree.com

817-***-**** ( Employment voice mail, please leave a message & follow up with an email.)

Linked In: https://www.linkedin.com/in/gene-mccormick-2594852/

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

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

Position sought in which this applicant can most effectively apply acquired training, skills, knowledge, and experience in a mutually beneficial arrangement with an employer. Once employed, this applicant’s value to the employer will be enhanced by the applicant gaining additional on-the-job knowledge and experience. Applicant is willing to participate in employer prepaid training and certifications. The applicant’s hope is that after perusing this resume, the employer will agree that this applicant will be an above average employable resource and asset.

Job Responsibility Overview: Workflow process starts with the elicitation and interactive analysis of the requested deliverables. Process continues on to the conceptual, functional, & technical steps, including data sourcing & 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 & scheduled reports, etc.

Job Goals Overview: Applies business quantitative & qualitative analyses and uses 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. – Busn. Admin. / 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, functions, import/export features and program code scripts. Advanced user of T-SQL with DDL, DML, DCL & TCL.

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, MS-ETL, 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.

Actionable analyses provided in areas of healthcare, pharmaceutical, retail, manufacturing, and petroleum as Project Lead or Team Member

Experienced with Electronic Medical Record systems. Passed all sections of the EPIC pre-qualification exams.

Proficient with relational databases (OLTP), data warehouse structures (OLAP), and transitioning to Data Lake.

Experienced with proprietary applications & commercial applications, such as, QNXT, DST’s PowerStepp / InfoStepp, ERP/MRP Vantage system.

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

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

EMPLOYMENT HISTORY: ( for the last 10 + years )

Employer: Molina Health Care – Las Colinas, TX

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

Employed: 10/2018 to 08/2019 - Job Title: Senior Data Analyst

Perform MS-SQL /T-SQL programming & analysis

Design SQL database objects such as, stored procedures, functions, and program code scripts

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

Basic knowledge of developing MS-SSIS packages

Develop dashboards, imports, and exports

Business and Data analysis

Elicit and document user requirements and the business, technical, and functional specifications

Use & update JIRA ticketing system tool

Database analysis & data mapping

Report documentation & user training

Seeking opportunities for full-time employment

From 08/2018 to 10/2018

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

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

Employed: 01/2012 to 07/2018 - Job Title: Sr. Applications Systems Analyst - BI Report Developer

Perform MS-SQL /T-SQL programming & analysis

Design SQL database objects such as, stored procedures, functions, and program code scripts

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

Develop MS-ETL packages

Basic knowledge of developing MS-SSIS packages

Develop dashboards, imports, and exports

Business and Data analysis

Elicit and document user requirements and the business, technical, and functional specifications

Generate Peer test cases & User test cases ( UAT )

Use & update SharePoint team collaboration tool

Use & update Zen Desk ticketing system tool

Use & update Liquid Planner Project management tool

Database analysis & data mapping

Report documentation & user training

Employer: TekSystems, Inc. - Fort Worth, TX. – Contracting Agency for several clients

Employed: 07/2007 to 01/2012 - Job Title: Business Analyst - Crystal Report Developer

1. ALCON Labs / Novartis – Fort Worth, TX –

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

3. Technical Chemical Company – Cleburne, TX

4. DISD – Dallas, TX

Epicor Manufacturing ERP/MRP System

Epicor Business Activity Query & Report tools

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

Worked both on-site and remote

Develop R & R Report Writer reports

Data & database analysis, and data mapping

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

Management, user, client, & vendor interaction

EDUCATION ACHIEVMENTS:

B.S. – 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

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