Business Intelligence professional with 3+ years of hands on experience using multiple reporting and BI tools. Strong experience building advanced queries to perform data analysis and build interactive reports. Excellent experience working in tandem with business professionals and management to build solutions using a variety of technologies. Hands on experience to cutting edge technologies through school projects at Johns Hopkins University
[Programming language] specialist
Advanced problem solving skills
Master of Science: Computer ScienceCurrentThe Johns Hopkins University-
Bachelor of Science: MarketingCSU, Sacramento-
School Projects (Johns Hopkins)
Clue-less board game using Python
E-commerce web application with Java and MySQL (based on MVC framework)
Big Data assignments
Data Science assignments
Business Intelligence Specialist10/2013
to 07/2014 CapRelo/JK Moving – Sterling,
Converted repository of operational and strategic reports from a legacy system (Visual Fox Pro) to SSRS using the MS BIstack
Wrote advanced queries in T-SQL (nested queries, CTE's, stored procedures) to power SSRS reports and satisfy ad-hoc requests
Updated existing stored procedures based on changing business requirements
Served as the administrator for all reports, user groups, users, permissions on the report server through existing user groupsin Active Directory
Created and maintained documentation of changes to reports and stored procedures
Created SSIS packages that brought over data from the legacy system (OLTP) to SQL Server (OLAP) for historical reporting (Salesperson performance, Customer Satisfaction)
Created and maintained reports in the DW.
Worked with end users to understand requirements and simplify existing queries to improve run time performance of reports.
Business Intelligence Consultant04/2013
to Current Kaiser Permanente – Rockville,
Build reports using the advanced features of Excel (VBA, Pivot tables, formulas, macros) that help senior level.
management understand trends and highlight problems in processes.
Automate existing business processes through VBA scripts to make routine reports easier to manage and more efficient.
Use MS Access as an intermediary destination to logically organize source data.
Train staff when requested to help them better utilize the key features of Excel (Pivot tables, basic formulas, shortcut.
Work as a part of a team on all projects through an agile approach.
Continue to iterate until project goals are realized.
Business Analyst/BI Analyst09/2012
to 04/2013 Southern California Edison SCE SmartConnect Operations Center – Irvine,
Build 24-7 near real time data visualizations (views, dashboards) that project the network performance of SCE's 5 millionplus meter network
Troubleshoot all data connectivity and performance related issues on Tableau Client/Server
Work with Tableau consultants and Tableau support on all upgrades, new releases and technical issues
Write SQL queries to extract data from Oracle and MS SQL Server databases
Generate Ad-hoc reports in Tableau, Excel, and ArcGISBuilt training documentation for other Tableau users
Serve as the administrator for Tableau Server.
IT Business Analyst09/2011
to 09/2012 City of Long Beach – Long Beach,
Build financial reports using Crystal Reports to identify cost savings and revenue opportunities.
Write SQL queries to extract data from Oracle 11g databaseWork with ETL developers to build reports.
Collaborate regularly with upper management to report application problems and offer technical solutions
Create end user documentation and provide end user training.
Full Time Grad Student09/2010
to 09/2011 California State University – Long Beach,
Probability and Statistics for Engineering
Programming in C++
Real Estate Broker/Owner01/2004
to 09/2010 AM EQUITY, INC – Sacramento,
Purchased a under-performing real estate brokerage and transformed it into a highly professional and agile business.Attracted and retained the highest caliber agents through a strong dedication to customer service and a rewardingcompensation structure.Increased total sales revenue by 200% in year 2006 and 300% in year 2007 while increasing expenses by only 20%during the same period.Trained and motivated sales team through strategy sessions, mentoring, shadowing, and performance targets.
Sales Executive/Owner01/2003to 12/2004 Source One Wireless, LLC – Sacramento,
Constantly prospected for new clients through cold calling, email campaigns, technology conferences
Maintained excellent client relationships by under promising and over delivering and offering product guarantees.
Sourced inventory through strong vendor relationships.