Data Warehouse Business Intelligence

Ammi Blankrot

San Jose, CA

Email: **********@*****.*** Phone: 408-***-****

LinkedIn Profile: www.linkedin.com/in/ammi-blankrot Tableau Public: https://public.tableau.com/app/profile/ammi.blankrot/vizzes BI Professional

Database Programming Tableau

Data Warehouse Data Analytics

Database Administration Business Intelligence

Degrees: BS, Information Technology, UOPX (3.98) (2016) AS, Programming CIS, SJCC (4.00) (2004)

Languages: English, Hebrew

Industries: BI, Databases, Data Warehouse, IT, Finance TECHNOLOGIES

Transact-SQL Tableau SSIS C#

MS Office MS Access VB / VBA Google Sheets

WORK HISTORY

Business Intelligence Developer, Nintendo (via Tek Systems) (2022–2024)

● Working with the CS BI Team to support and administer the Data Warehouse and reporting using SQL Server and Tableau.

● Design tables, views, stored procedures, functions in SQL Server and designing Tableau reports to upload to the Tableau server.

● Helping the team monitor the health of our servers, systems, and reports to the business and troubleshooting code in stored procedures & functions when problems arise.

● Documenting some of our processes and some of the terminology utilized.

● Working with over 30 databases with hundreds of stored procedures, views, and other objects as well as hundreds of Tableau reports on the Tableau server. Technical Lead / Data Analyst, Google (via HCL America) (2021–2022)

● Working in the Sales Operation team to provide reporting for cloud operations and other items for Management.

● Utilizing SQL to build queries to help with the reporting process as well as provide answers for ad-hoc inquiries as well as troubleshoot anomalies and exceptions

● Trained a group of 20 employees with recording on a number of difficult tasks to provide redundancy for important recurring tasks

DBA / Programmer Analyst II, Maxim Integrated, San Jose, CA (2014-2020)

● Worked with the members of the EDW team to develop the company’s data warehouse that provided BI capabilities to hundreds of employees.

● Designed and programmed tables, views, stored procedures, triggers etc. using T-SQL

● Developed subscriptions to over 100 other employees for specific data needs.

● Developed many SSIS packages to migrate data from transactional systems into the data warehouse.

● Administered SQL Server security for hundreds of employees using row level security with roles that helped ensure that people have access to only what they are entitled to.

● Transferred the implementation of the company-wide pricelist database system utilized in the sales of over $2 Billion a year from the legacy Focus system into SQL Server.

● Administered the Exception Report system that synchronized over 50 data sources and improved data integrity by restoring one version of truth. Senior, Finance Systems Analyst, Maxim Integrated, San Jose, CA (2000-2014)

● Saved the company over $200,000 by replacing an expensive consultant in migrating legacy Hyperion Essbase Financial data into the new SAP / BPC system.

● Designed and administered the company’s world-wide pricelist database system that supported the yearly sales of over 1 Billion dollars annually between 2003 and 2014.

● Changed a 96K loss because of an error into savings of millions by adding programmatic validations and checks that prevented this error and other potential errors in the future. ADDITIONAL EXPERIENCE

Certifications

MS MTA: Database Fundamentals (98-364), Microsoft (94%) (2022) 37 licenses and certificates on LinkedIn (2021-2024) Various CIS Programming Certificates, SJCC (2002)

MS Certified Professional, Design Applications with VB6, Microsoft (2001)

Awards

Graduated with Honors, UOPX (2016)

Dean’s Scholar, SJSU (2012)

Conway Math Grant for Excellence in Math, SJCC (2009) President’s Honor List, SJCC (2009)

International Honor Society, Phi Theta Kappa, SJCC (2006) President’s Honor List, SJCC (2001)

Volunteering

Branch Coordinator, The Way International, New Knoxville, OH (2010-2021)

● Leading and teaching bible to a congregation of 75 people in the Bay area.

Contact this candidate