Data Python

ANALIZA ASUNCION

Phone: 512-***-**** Email: analizaasuncion@gmailcom

LinkedIn: https://bitly/3lDlzF5 Github: https://bitly/3pvrRZU Round Rock, TX 78665

SUMMAR

Y:

• Business Intelligence role responsible for creating mission critical data science products 9+ years in data wrangling and cleansing large amount of enterprise data for efficient and effective analysis and insights

• Adept at working independently and collaborating with teams across multiple functions

• Effectively communicate and break down analytics concepts in layman terms to diverse audiences

• Multidisciplinary data expert with good business intuition and curiosity to dive deep and understand relations from presented data

• Completed Boot Camp Certification in Data Analytics and Visualization from UT Austin

• Completed BS, Computer Information Systems from San Francisco State University

• 9 year work experience from Planview ERP Business Intelligence reporting products

• Expertise in SSRS, PBIRS, SSAS and SSIS, Power BI Desktop, Power BI reports and dashboards, Tabular Models and OLAP cubes (KPI grids, heatmaps and treemaps)

• Extensive experience in large multisource datasets such as Oracle, MSSQL, JSON, CVS, and Excel, Transactional and aggregated databases

• Well versed in Tableau, Alteryx, ETL, Python, R, JSON, Beautiful Soup, JSON API, Google API, Geomap API, Odata API

TECHNI

CAL SK

ILLS:

• Programming: Python, R, JavaScript, VBA, Pandas, HTML5/CSS

• Data Analytics and Dashboards: Power BI, Tableau, Alteryx, MS Excel Pivot tables

• Data sources: JSON, CSV, Excel, MS Tabular Model and OLAP cubes, Data Mart, Transactional databases

• Microsoft stack: PBIRS, SSRS, SSAS, SSIS, Sharepoint Foundation 2010, SAP Business Objects

• SQL: Oracle (Toad), MSSQL, Postgres, Mongo, SQLite, DAX and OLAP queries

• Utilities: Datadog, Sumo, Fiddler, MS SQL Profile Tracer, Beyond Compare, Git/GitHub, JIRA

• API and Others: Olap, JSON, Google API, SOUP, Geomap, Beautiful Soup, Webscrape, Bootstrap, Jupyter Notebook, Google Collaborator, BI Visual Studio, Google Collaborator, Visual Code, MS Excel Pivot

• Amazon Web Services – S3, RDS, EC2, Quicksight

RELEVA

NT EXP

ERIENC

E:

Business Intelligence CC Consultant 4/2011 – 4/2020 Planview, Austin, TX

• Subject Matter Expert (SME) in Business Intelligence to resolve and lead critical issues for challenging customer environments

• Achieved the highest contributor award in building a knowledge base for BI topics

• Recognized as a valued employee and awarded stock options

• Known as a driven, motivated and a quick leaner who is self-taught in technical infrastructure and applications

• Provides Analytics software support to customers from various industries such as insurance, health companies, retail companies and pharmaceuticals

• Install and configure Power BI Report Server for testing and 2017 MS Database/Analysis Server

• Deploy and test Tabular Models and OLAP cubes, Datamart and SAP Business Objects in test environments

• Troubleshoots analytical reports in Report Builder, SAP Business Jobs, ETL, SQL and Analysis Server

• Troubleshoots Business Objects Universes and Objects, Web and Desktop Intelligence and Infoview

• Provide root cause analysis to any data jobs failure

• Modifies and re-compiles stored procedures, views, materialized views, functions in Toad for Oracle and Microsoft SQL Server Management Studio in determining compiling and execution errors

• Tests and recreates issues in Tabular Models in MS Excel Pivot tables and ODATA feed

• Analyze and resolve issues using server logs, webconfig and server configurations

• Migrates Report Builder reports (rdl) and datasets (rds) to different server destination

• Migrates SAP Business Object Universes, groups, users, reports, etc to a different server destination

• Migrates Datamart databases from one server to another during upgrades PROJEC

TS:

Education Analysis: State Per State Per Pupil Expenditures and State Graduation Rates for 2016 Github Link: https://githubcom/bpollockATX/the_dream_team

• Identify key findings such as forecasts, outliers and relationships between expenditures and success rate

• Task to data wrangle and data cleanse prior to the Postgres database imports

• Task to code in Python using libraries such as Pandas, Matplotlib, Numpy in Jupyter Notebook EDUCAT

ION:

Bootcamp Certificate in Data Analytics and Visualizations: UT Austin McCombs Austin, TX A 24-week intensive program focused on gaining technical programming skills in Excel, VBA, Python, R, JavaScript, SQL Databases, Tableau, Big Data, Beautiful Soup, Alteryx and Machine Learning BS, Computer Information Systems: San Francisco State University SF, CA

Contact this candidate