SUMMARY:

• Excellent SQL skills for RDBMS including AWS Redshift, SQL Server, MySQL, Netezza and PostgreSQL.
• Data visualization expertise for Enterprise Reporting Applications with Cognos, Looker, Tableau and SSRS.
• Understands and manages user data access security at various levels for Business Intelligence applications.
• Provides production support of ETL systems running on SSIS and Pentaho.
• Excellent understanding of business intelligence and data warehousing best practices such as star schema and snow flake schema, hierarchies and slowly changing dimensions.
• Experience creating Data Marts and database objects such as tables, views and stored procedures to power BI reporting.
• Highly skilled at data validations in relational databases ensuring data type integrity, referential integrity, join testing, nullability, primary key and foreign key relationships.
• Knowledgeable in AWS Services including EC2, S3, RDS, Redshift, Glue, Athena, IAM, QuickSight.
• Familiar with machine learning concepts and possess experience contributing to data science teams.
• Basic Python coding for data analysis using numpy and pandas and Big Data stacks such as pyspark.
• Comfortability working with start - up (open-source) technologies, and large enterprise software, and environments.
• Creates technical documentation of data driven processes from data warehouse level to the presentation layer where the data is consumed.
• Domain experience in manufacturing, healthcare, consulting, actuarial, internet companies, digital marketing, SaaS.
• Ethical handling of sensitive data under HIPPA and SOX for healthcare and finance industries respectively.
• Experience practicing SDLC in Agile and Scrum teams.

TECHNICAL SKILLS:

Database: AWS Redshift, PostgreSQL, SQL Server, MySQL

Scripting: SQL, MDX, Python, Shell

Frontend: Looker, Cognos, Tableau, SSRS, Power BI

ETL: SSIS, Pentaho, Alooma

PROFESSIONAL EXPERIENCE:

Confidential, Santa Monica, CA

Business Intelligence Engineer

Responsibilities:

• Engineered database transformations engine using Stored Procedures in SQL Server for the National Distribution delivery routes optimization process previously done using VBA.
• Development of BI data lake POCs using AWS Services including Athena, S3, Ec2, Glue and Quicksight.
• Optimization of data sources for route distribution analytics dashboard in Tableau reducing report runtime.

Confidential

Business Intelligence Engineer

Responsibilities:

• Developed SQL code in Redshift to build training and validation sets for several fortune 500 loyalty rewards customers.
• Optimized data processing by reducing the amount of blocking transformations, minimizing data duplication, and exploiting the features of redshift such as the use of distkeys, sortkeys, key references.
• Developed dashboard prototypes using Cloud Dashboard Tools Looker and AWS Quicksight managing all aspects of the technical development.
• Adapted functionality in S3 and Redshift to allow incremental loading by adding staging layer and scripting SQL code to integrate staged data with the delta files.
• Created documentation for development and testing process in adherence with the professional excellence standards of the organization.
• Monitoring system health over the AWS console during batch data processing.

Confidential, San Diego, CA

Business Intelligence Analyst

Responsibilities:

• Implemented best practices for management of Looker BI application to support sales, accounting, data science, and SEO.
• Validated data migration for the Allstate Lead Marketplace platform ensuring quality and integrity of historical data.
• Gathered business requirements from stakeholders, then converted them to technical specs and developed the solution.
• Developed new Pentaho Kettle jobs and transformations and merged code to production using Github.
• Created new shell scripts and added new crontab entries to schedule ETLs.
• Log on to Linux server via SSH to tail ETL logs during ETL failures and make updates on legacy scripts in Python.
• Scripted advanced SQL queries in Postgresql for Redshift and MySQL leveraging Common Table Expressions, sub-queries, correlated sub-queries, window functions and complex join logic to apply business rules.

Confidential, San Diego, CA

Business Systems Analyst

Responsibilities:

• Created new pipeline reports from SalesForce.com and JDE to compare actuals, forecasted, forecasted at-risk, upside and not forecasted opportunities against revenue targets.
• Developed interactive reports using relational and multi-dimensional packages adding interactive prompts such as checkboxes, tree prompts, radio buttons, cascading prompts and conditional blocks in the prompt page and inline.
• Created reports from multi-dimensional packages applying MDX expressions to extract data from the cube.
• Developed new interactive sales dashboard using Cognos Workspace to measure sales targets across all LOBs and all regions presented in front of the global finance leaders, sales directors and managers at the Finance Summit.
• Applied master-detail relationship queries for report bursting and also to implement visualizations in crosstabs.
• Improved user experience by restructuring the Cognos sales analytics homepage and folders, added links from the homepage to content folders reducing time spent finding reports and increasing overall Cognos utilization. 
• Maintained confidentiality of financial and sales data in compliance with insider-trading policies.
• Identified data issues and created requirements for ETL fixes in production following through deployment with DW team.
• Engineered new relational report to analyze Install Base Active, Sequencing Consumables Pull-through and MicroArray Consumables revenue at the lab account level by Fiscal Quarter.

Confidential, Mountlake Terrace, WA

Sr. BI QA Analyst

Responsibilities:

• Lead validation engineer on multiple projects including the benchmark implementation with third party vendor Blue Health Intelligence successfully achieving Level 4 actuarial certification by Milliman.
• Documented the highest number of bugs out of all contractors with accuracy leading to participation in projects of higher technical complexity and higher priority.
• Scripted SQL queries using WinSQL, Aginity for Netezza and SQL Server Management Studio leveraging set operators, inner/outer/cross joins and analytical functions to aggregate and transform data.
• Created test plans and test cases in Quality Center documenting business requirement to technical requirement test coverage with expected results, actual results and validation queries.
• Scripted and executed manual test cases using SQL queries opening critical bugs and followed through resolution.
• Tested ETL processes for new tables used for SSRS and Cognos Reports.
• Validated new Cognos and SSRS reports verifying data displayed matched the source data.
• Served as key point of contact for the Employer Reporting platform consisting of a web integrated SSRS reporting application with a SQL Server backend executing dynamic SQL stored procedures to create datasets for over 50 reports.
• Participated in customer product demonstrations as a data subject matter expert.
• Quality assured data warehouse migrations to conformed bus architecture structure.

Confidential, San Diego, CA

Data Analyst

Responsibilities:

• Led research effort to locate new sites through web research and collaboration with various city employees over 4 weeks period successfully adding over 10,000 records to the database.
• Gathered business requirements to build a database of wireless telecommunication facilities.
• Analyzed various sources of raw data like building permits and online databases extracting all valuable information.
• Developed methods to reduce the amount of time and labor spent from manual processing of raw data coming from disparate sources.