Cruz Beltran

**** ****** **., ******* *****, IL *0516

630-***-**** (cell)

adjgag@r.postjobfree.com

https://www.linkedin.com/in/cruz-beltran-55a70113/

Professional Summary

Over 9 years of experience as a Data Analyst

More than 4 years of professional experience within the Healthcare Insurance Industry

Solid Tableau skills that include created new reports, security, and checked data

Excellent communication skills both written and oral.

Technical Skills Years

Data Analysis Experience 6

Excel Experience 5

Healthcare Industry Experience 3

SQL Experience 5

ETL Python .5

Additional Technical Skills:

8 years of experience with Informatica PowerCenter ETL, 4 years with SSIS ETL, 5 years with Sql, 8 years working on a Data Warehouse, and 3 years with Tableau desktop.

SQL Server 2008 & 2012 with TSQL, DB2 V7, Oracle 10G

using Toad & Sybase; ETL (Informatica PowerCenter V5.0, V7.1, V8.1, V8.6, & V9.1); Visual Studio 2008 & 2012 for SSIS and SSAS. Cognos Impromptu V6.0 & V7.1, Cognos Powerplay V6.0 & V7.3 .

Powerplay Transformer V6.0 & V7.3; CONNX 11.5 SP1 ; Mainframe PL/1, COBOL, Natural/Adabas.

Professional Experience

Waubonsee Community College Mar 2020 – to Oct 2020

Data Warehouse Analyst/SQL Developer Consultant Sugar Grove, IL

Comprehensive two-year college offering more than 130 degrees and certificates in today's most desirable fields.

Resolved SQL server Database Log file issues on the TOPdesk and SARs server.

Implemented SQL Server Database and Log file back ups on the TOPdesk, Questica, and SARs server.

Resolved connection issues and bad data issues on the Advance Data Warehouse.

TMP Worldwide Jul 2018 – to Oct 2019

Data Analyst/ SQL Developer Chicago, IL

Global leader in talent acquistion technologies, committed to finding new ways to leverage software, strategy and creative to enhance our clients employer brands - across every connection point.

Wrote new BI Tableau Dashboard reports to check different vendor source data like Indeed, Glassdoor, and AdWords.

Resolved issues with bad costs in T-sql store procedures which were called by Tableau reports on the Metrics GateWay system..

Corrected problems with BI Application Python ETL jobs failing due to bad data or bugs in the Python ETL.

Robert Half Feb 2018 – to April 2018

Consultant on bench Oakbrook, IL

Robert Half recruiting firm which pioneered specialized staffing services in 1948 and today is the industry leader worldwide.

Completed C# Scratch course and Sql Server Transactional Replication Fundamentals course on PluralSight Webportal.

Pekin Insurance Oct 2015 – to Sept 2017

Data Specialist/ SQL Developer Consultant Pekin, IL

One of the nation's most successful insurance providers, with combined assets of over $2 billion, more than 800 employees, 1,250 agencies, and 7,500 independent agents.

Successfully added new DBOP columns to Excel with Pivot tables reports and changed source connections.

Created new Dev & QA Environments to test/resolve issues with Commercial Agency & Personal lines SSAS cubes.

Completed Sql Server Integration Services LexisNexis project which involved extracts of auto policies & driver/vehicle info from the Data Warehouse to the client LexisNexis. Used mmultiple sql left outer joins to pull data from Data Warehouse tables.

Cruz Beltran

7116 Powell St., Downers Grove, IL 60516

630-***-**** (cell))

adjgag@r.postjobfree.com

https://www.linkedin.com/in/cruz-beltran-55a70113/

Baxter Credit Union Nov 2013 – to June 2015

Data Analyst/ Sql Developer Vernon Hills IL

One of the nation’s top 100 credit unions with over two billion dollars in total assets which was started in 1981.

Designed new BI Tableau Dashboard reports for branch managers showing different type of loan dollars.

Resolved a data warehouse 20 million dollars checking account out of balance issue which occurred after running the month end balancing. Wrote extensive sql to find transactions that added to 20 million dollars.

Implemented Sql Server Integration Services packages and stored procedures concerning new Target members on the BCU data warehouse. Added new member points calculations to the BCU Data Warehouse Loan Portfolio SSAS cube using MDX logic.

UnitedHealth Group Inc Aug 2011 – to Oct 2013

Senior IT Data Analyst Lisle IL

UnitedHealth Group Inc is a diversified managed health care company in Minnetonka, Minnesota, US.

Worked with Informatica administrator to resolve time out issue occurring when uploading customer cases to SalesForce.com.

SME for Member Conversion Process which utilizes Informatica ETL and a DB2 database.

University Health System Consortium March 2011 – to June 2011

Informatica ETL Developer/Consultant Oakbrook IL

An alliance of 113 academic medical centers and 253 of their affiliated hospitals, representing nearly 90% of the nation's nonprofit AMCs.

Designed, coded and tested ETL mappings for loading Clinical Resource Manager Mart inpatient data.

Modified & tested ETL mappings for database changes dealing with UHC Service Line.

Abbott Labs July 2010 – Jan 2011

Informatica ETL Developer/Consultant North Chicago IL

Global broad-based health care company with over 72,000 employees. Some of the health care products are Ibuprofen, Simalic, and Pedialyte.

Designed new ETL mappings dealing with Global location numbers using PowerCenter 8.6 with Oracle version 10g database.

Redesigned and tested Abbott Enterprise System mappings which are used to feed the Customer Master.

United Stationers Nov 2009 – May 2010

Informatica ETL Analyst/Consultant Deerfield, IL

A leading North American wholesale distributer of technology products, office product, office furniture, janitorial and break room supplies. Net Sales of $5 billion for year 2008.

Designed, coded, & tested new ETL mappings for the Applied Business Cost system using Informatica PowerCenter 8.5 with SQL Server 2005 and Oracle version 10G database.

Wrote SQL queries using Oracle Sql Developer which were used to determine missing Vendor Rebate dollars.

J.C. Whitney June 2000 – May 2009

Lead ETL Analyst & Cognos Administrator Chicago, IL

Top 120 Cross-Channel Internet retailer and reseller of digital content and electronic data in the automotive parts industry.

Successfully system tested 35 ETL Workflows under new release of informatica Powercenter version 8.1 on MARS system.

Improved performance of slow running Cognos Impromptu Catalog reports by adding new indexes to SQL Server database tables thereby reducing run-time from 5 minutes to 30 seconds.

Worked with Merchandising senior managers to develop new Ship Sales Powerplay cube which contained measures such as ship dollars, ship units, returns dollars & return units.

EDUCATION

University of Illinois at Chicago, IL

Bachelor of Science Degree - Mathematics and Computer Science, Deans List

Contact this candidate