CAREER OBJECTIVE

Develop data warehouse solutions and analytical applications on the cloud. Create high performance and scalable reports and dashboards that answer business questions and enhance the UX/UI user experience. Certified Microstrategy Engineer (CME) solves problems using ETL/BI tools, Oracle, SQL Server, Azure Data Factory (ADF) and Synapse Data Pipelines. Creates Dynatrace dashboards to enable applications observability and reliability on the cloud.

SKILLS

• Microstrategy • Azure DevOps

• SQL Server • Azure Data Factory

• Azure Synapse • Azure Pipelines

• SQL Stored Procs • Oracle PL/SQL

• HTML, JavaScript, JSON • Dynatrace, Python

• ETL, SQL, Data Profiling • UI/UX best practices

• Scrum/Agile Methodology • Linux Bash

EMPLOYMENT HISTORY

Sr Software Engineer at Vizient Inc, Irving, TX, March 2019 – Present

Created Drug Budget Forecast (DBF) Dashboard that allows users to overwrite their drug sales as well as the inflation percentage and dynamically recalculate their projected spend and total inflation impact for their yearly budget.

Created Oracle database objects, ETL programs, and Microstrategy schema and report objects for the Pharmacy project. Created stored proc to update facts in database table. Created transaction services report to call stored proc and recalculate dynamic totals in Drug Budget Forecast dashboard.

Created 3 user roles to provide 3 levels of access to the Pharmacy application. Viewer role for all users, Contract role for first paid subscription, and Price Benchmarking role to access all dashboards in the application. Created the user roles table, map the attributes to the project and use conditional logic to implement user access in the landing page and navigation menu in the Pharmacy project.

Created dossiers with KPI metrics to allow users perform ad-hoc analysis on Pharmacy Spend, Price Performance, Benchmark Spend, Peer Compare, Hazardous Drugs, COVID 19, Anesthesia Gases and Biosimilar Conversion. Enterprise Manager reports DBF and these dossiers as the top 10 dashboards used by members in the Pharmacy project.

Participated in the cloud migration of the Pharmacy data warehouse from Exadata into Azure SQL Server. Load historical data for facts and dimensions from the Qlik replication tool into the Horizon database using the Synapse pipeline. Maintain and support the newly created ETL in Azure SQL Server to eliminate all data issues after Azure live date. Troubleshoot data issues, logic issues, data type/syntax issues, performance issues and resolve differences between the on premise ETL and the cloud ETL process. Enhanced the Azure ETL process by refactoring facts and dimensions to resolve data integrity and performance issues in the Pharmacy Reports and Dashboards.

Participated in the replication of the Pharmacy data warehouse from Azure SQL Server into on premise SQL Server.

Duplicated the Microstrategy Pharmacy project metadata from Oracle to SQL Server. Created a metadata gap analysis between the Oracle data warehouse and the SQL Server data warehouse such as data types, tables naming conventions, platform dependent syntax.

Created a SQL Server database view layer based on the Oracle Warehouse Catalog to resolve metadata gap analysis. Resolve all metadata issues between Oracle and SQL Server database platforms.

Participated in the conversion of the Pharmacy application from the on-premise SQL Server solution to the Azure solution (Angular, C# and Power BI).

Participated in the design sessions to reproduce the Pharmacy security model, user roles, Power BI data model and all the application features from Microstrategy into the Azure architecture.

Extracted the reporting logic from Microstrategy reports and dashboards to create the Power BI data model. Use reports SQL to create the Power BI logical tables and partitions using Tabular Editor. Work on gap analysis between Microstrategy and Power BI. Resolve differences between Microstrategy and Power BI at the database level, reporting level as well as create reporting enhancements as requested by the users.

Improve performance of Power BI data model refresh by removing extra logic and calculations in the reports and pushing them to the ETL process.

Work on the X Project, an angular/rest API conversion of a Microstrategy project to resolve performance of landing page and detail pages. Refactor Microstrategy reports and SQL queries to enhance application rendering time down to 2-3 sec.

Created Dynatrace Dashboard for the Pharmacy Analytics project to track availability and performance of the application servers, services and databases on premise and the cloud.

Meet with stakeholders, executives and power users to elicit new requirements for the Pharmacy application. Created proof of concepts, spikes and conducted demos to the business to get user sign-off on new features, solutions and bug fixes.

Work with Scrum Master and Business Analyst to create user stories and estimates of work and track progress using Agile and Scrum methodology. Convert the technical details of estimates of work into business terms for the user stories acceptance criteria.

Worked on new features for the new Pharmacy application on the cloud. Worked on converting Angular static site pages modals into Material UI (Vizient standards).

Worked on the new export feature in Angular to resolve the 300K Power BI export limitation. Refactored dashboards export logic into a compiled view, call view and write results into a temp table and export results from the table to the Azure BLOB storage.

Used Azure Dev Ops to clone project repositories and create new branches and develop and test changes and push them to higher environments.

BI Developer at Bank of America, Plano, TX, March 2017 - Dec 2019

Conversion and enhancement of multiple modules of Risk and Compliance Reporting from Spotfire into Microstrategy. Creating schema objects, facts and dimensions, database views layer to support conversion as well as reports and dashboards.

Develop Microstrategy analytical applications to analyze and measure Enterprise Independent Testing (EIT) project for Risk and Compliance. Create schema objects and reporting objects to implement new reporting functionality for new releases of the Enterprise Independent Testing modules. Create and update new reports, documents and dashboards to resolve BI stories for new releases in biweekly scrums using the agile framework.

Partner with the Scrum Master to procure User Acceptance Test (UAT) and Post- Production Validation (PPV) for new releases of the EIT product using Scrum as the Agile Methodology. Conduct demos to the business to elicit business sign-off for the completion of releases’ stories in UAT and Production.

BI Developer (Contractor at Red River Systems, Addison, TX) Jul 2016 – Jan 2017

Develop a sales trend and analysis POC mobile application for a major retail chain company in the convenience store industry. Extract historical sales data from the Data Warehouse and create a stand-alone data model with a sales daypart fact and a sales daypart monthly summary table using Microsoft SQL Server 2016. Install and configure a Microstrategy Server and Microstrategy Mobile in a demo server to host the mobile application. Replicate stand-alone dimension tables to support Geo Sales, Grid Sales, Trend Sales, DayPart Sales at different levels in the role and time hierarchies. Create all attributes, facts, metrics, filters, prompts and report objects needed in Microstrategy Architect. Create all reports, report service documents and cubes needed to support the mobile application using Microstrategy Desktop and Microstrategy Web. Customize two versions, a customer specific and a white label version of the mobile application. Create a portrait and landscape layout for each screen of the mobile application to allow for automatic display based on the iphone orientation.

BI Developer at Denovo Group, Addison, TX Jun 2015 – Jun 2016

Dedicated Technical Support for the BI production environment of a motion picture health plans company in Los Angeles, CA. Restore administrator access to the Microstrategy environment. Restore administrator access to the Narrowcast Server environment. Reverse engineer data load process and sequence of jobs loading the DataWarehouse catalog running in SQL Server and scheduled in the Microstrategy server. Troubleshoot data issues and report issues with production reports, dashboards, cubes, and scheduled reports in Narrowcast server. Support users and analysts ad-hoc reporting using the Microstrategy environment. Update and enhance existing reports, documents and dashboards. Resolve data integrity issues, resolve SQL job issues. Promote new reports and dashboards from Test to Production environments using Object Manager. Develop an analytical application for a major retail company in San Antonio, TX. Develop facts and dimension tables, attributes and facts, reports and dashboards in a Microstrategy project and Teradata datawarehouse.

Sr. Consultant at Microstrategy Inc, Jan 2010 – Jun 2015

Tax and Revenue Consulting Organization (Auditing industry).

Created a Microstrategy project for a Tax Analysis and Reporting System

Created a logical model and define table design documents for facts, dimensions and relationship tables for the DataMart using the yED graph editor tool

Created mockups for reports and dashboards using the mockup tool Balsamiq and get a user sign-off

Work with the graphical designer to produce a pixel-perfect dashboard look and feel based on mockup

Created schema objects, report objects, filters and prompts, reports and dashboards for the project

Support the DBA in the creation of lookup tables and relationship tables. Group Purchasing Organization (Health Care industry) Upgrade a Microstrategy Project, identify schema, report and application issues, find a resolution for the issues including updating schema objects, report objects, requesting a patch or hot fixes from Technology

Use Object Manager to identify object dependencies and migrate updated objects to Test and Prod environments

Create new Microstrategy Projects for a HealthCare organization corporate users and executives

Created a Price Management Module of Reports and Dashboards to track the Price Index of contracts, product categories and segments by business units and portfolio executives

Created subscriptions to send Price Index metrics to the business units directors and portfolio executives to monitor their contrats performance

Created a Price Index Forecast tool using the Microstrategy Office Plugin to track product best prices and perform case if scenarios to forecast the Price Index for contracts

Created a Cross Reference module of Reports and Dashboards to integrate the classification of company products into UNSPC standards and company defined naming conventions

Created a Sales and Revenue module of Reports and Dashboards to report member's sales and revenues based on the Purchase and Revenue System

Create a Current Utilization Reporting module of Reports and Dashboards to identify missing contract opportunities for members with similar needs not using our contracts (Chasing Zero analysis)

Created a Supply Network Analytics module of reports and dashboards to report and analyze studies and company initiatives and analyze their impact on members

Created a Supplier Market Share module of reports and dashboards to replace and automate the old legacy and manual process of reporting Suppliers products and their market share in our member sales

Created the Business Review module of reports and dashboards to be deployed using the Microstrategy Office Plugin

Work on table design documents for fact tables and dimension tables for all projects

Work on data discovery, data profiling, prototyping for all the internal applications.

Database Developer at US Renal Care, Addison, TX May 2009 - Dec 2010

Create data integration packages to interface between HL7 and non-HL7 healthcare applications

Design SSIS packages to read flat files and convert them to HL7 format and feed internal and external HIPAA compliant applications

Automate data interfaces using Windows Scheduler, WinSCP, SFTP, SQL Server 2008 Integration Services, Report Services, Analysis Services and Visual Studio 2008

Create operational and analytical reports for the Clinical and the Billing department on patients, clinics, flowsheets, treatments, lab tests, claims credits and adjustments and insurance policies using Crystal Reports, T-SQL, Oracle SQL, SSRS and SSAS

Support healthcare legacy and client server database and applications running in VM, Windows Server, Progress, SQL Server, Oracle and hierarchical databases.

Database Developer at Travel Company, Irving, TX Oct 2008 - Feb 2009

Perform the duties of a Database Developer to assess the database schema and logical model of a decision support system in the travel industry

Provide recommendations on how to improve the performance and efficiency of the database schema

Create a matrix with application screens and reporting business metrics to identify candidate summary tables

Use query factory, temporary tables and materialized views to resolve ad-hoc report requirements

Create a local database environment to test the current ETL process

Document current system functionality as part of the new process modeling and system redesign.

BI Developer at The Container Store, Coppell, TX Jul 2006 – Sep 2008

Performed the duties of a Microstrategy Developer and an ETL Developer for the corporate datawarehouse

Create Microstrategy projects for the Accounting, Financial, Merchandise, and Marketing departments

Create ETL processes using Oracle PL/SQL, UNIX and JCS to automate the extraction and load of corporate facts and dimensions

Create Microstrategy logical models, schema objects and report objects for end-users using Microstrategy Desktop, Architect, Office and Web

Create dynamic dashboards to summarize and present business intelligence information for data analysis and decision making

Support the Oracle Datawarehouse data integrity, ETL processes, and JCS scheduled jobs

Support the Microstrategy reporting environment, a four-tier Microstrategy configuration with Office, Desktop, and Web clients; a test and a production Intelligent Server and a test and a production Web server

Administer the Microstrategy test and production environment, such as projects, users/groups, privileges, software installs and upgrades

Support ad-hoc reporting and data analysis for special projects outside of Microstrategy, including MS Excel, MS Access, TOAD, SQL and UNIX Scripts. Business Intelligence Developer, 12/2004 - 6/2006

BI Developer at The Pinnacle Corporation, Arlington, TX Dec 2004 - Jun 2006

Create a new generation of Enterprise Performance Management (EPM) system for the c-store using SQL Server 2000 and Microstrategy 8. Design a logical model and physical schema for the datawarehouse based on POS transactional data and store information. Create an ETL process to load transaction level data into an operational data store using SQL Server 2000 T-SQL, DTS packages and SQL Agent Jobs. Gather requirements for EPM interface systems, database schema, data types, data format/export, reports and data loads.

Design Microstrategy schema and public objects, create reports templates, layout and server configuration objects for Microstrategy Desktop and Microstrategy Web. Deploy the new EPM product in three different customers. Support and resolve customer data issues and perform required customizations for the ETL process and EPM analytical reports.

Resolve new customer and product issues tracked through our internal web tracking system

Upgrade customer EPM metadata to release new report objects and functionality using Microstrategy Administrator. Document and train professional services and end-users on the Datawarehouse, EPM and the ETL process.

Data Systems Analyst at Blockbuster, Dallas, TX, Feb 2004 – Dec 2004

Develop SQL scripts to extract and summarize product and merchandising data from OLTP production databases into an operational data source and a datamart

Create two-tier Microstrategy projects from multiple data sources to perform ad-hoc reporting and data analysis on product allocation, inventory and merchandising corporate data

Automate production of standard and ad-hoc reports on the four business lines Retail, Rental, Trade and Previously Rented products in 2 tier Microstrategy projects

Run production and ad-hoc reports jobs from the IBM Mainframe, AS/400 using TSO and ISPF/PDF

Automate the production of daily, weekly and monthly operational reports by using MS Excel, MS Access to extract and format Oracle data into MS Excel report templates

Develop SQL queries and scripts to extract, load and analyze product, merchandising, sales and marketing and financial data on an ad-hoc basis

Investigate and resolve data integrity issues between different systems and data sources such as the Merchandise system, Mainframe, TM1 and the Datawarehouse.

BI Developer (Contractor at Princeton Information, Irving, TX) Oct 2003 – Jan 2004

Develop a logical model for the Price and Order Microstrategy projects

Create materialized views to integrate CX Pricing and CX Orders data in the staging area

Develop PL/SQL programs to load and integrate Private Line offerings and orders from Staging into the Price and Orders Datamarts. Create physical facts and dimensions tables in the Datamart schema

Create table constraints, indexes and summary tables to improve query performance

Map logical facts and dimensions to physical tables

Create schema objects such as facts, attributes and hierarchies using Microstrategy Architect

Create report objects such as metrics, filters, prompts, templates, users, user groups, user hierarchies, search objects, report templates for the Price and Order Projects

Duplicate, package and deploy the Microstrategy project metadata from development into a test environment for Unit Accepting Testing (UAT) and move it to production.

BI Developer (Contractor at KForce, Fort Worth, TX) Aug 2003 – Sep 2003

Reconcile regional financial statements (Americas) against SAID, the corporate DataWarehouse (Mexico HQ). Develop an MS Excel financial model and an MS Access from Oracle Ledger to build regional income statements and consolidate them into a corporate income statement

Analyze and resolve variances between regional and corporate P&L against SAID using Hyperion Essbase Excel Add-In and Excel pivot tables

Facilitate the resolution of accounting differences between Mexico and the Americas by updating the structure of accounts and recalculating the Essbase outline

Propose the integration of regional P&L by developing Oracle stored procedures to load non-Oracle feeds from stores POS systems records into the Oracle General Ledger (OGL)

Create tables, views and an Access database to cross reference regional versus corporate accounting and enforce corporate accounting rules and procedures.

Database Developer at Sabre Holdings, Southlake, TX Jan 2001 – Jul 2003

Support and maintain the Sabre AirServ Datamart - a financial and inventory datamart to manage Food and Beverage and Dining and Cabin airline functions

The AirServ Datamart was hosted in Oracle 8i (UNIX) and MicroStrategy 7i (Windows NT)

Update and maintain the Microstrategy logical model, hierarchy of dimensions and metadata

Create new facts and dimension tables, create new Microstrategy schema objects and report objects

Support the Financial and Inventory Management departments with ad-hoc reporting and financial reporting using Oracle SQL, PL/SQL, TOAD, Microstrategy, Crystal Report/Info Seagate, MS Office

Create and maintain database objects to support ad-hoc reporting on the AirServ product

Support the Dining and Cabin Services reporting environment (Crystal Reports/Info Seagate server)

Create and maintain corporate reports using Crystal Reports and publish them in the InfoSeagate server

Support business analysts by resolving data integrity issues and special projects on Food and Beverage and Dining and Cabin data outside of Microstrategy and Crystal Reports

Upgrade the financial and inventory Airserv Datamart from Microstrategy 6 to Microstrategy 7i

Create the Airserv Datamart training guide for users.

Associate Consultant (Internship) at US Analytics, Dallas, TX, Apr - Dec 2000

Technical Training in Hyperion Essbase, Hyperion Analyzer and Alphablox Suite.

Participated in the creation of analytical web applications as POC, presales demos, and prototypes using Hyperion Essbase, Essbase Analyzer, Excel Add-In and Alphablox. Load financial database into Essbase and recalculate the outline. Create hierarchy of accounts for financial model and calculate rollups and summary level reporting.

Create web reports using Alphablox Analysis Server and Hyperion Esssbase.

Associate Consultant at Keane Inc, Irving, TX Feb 1998 – Aug 1999

Project Administrator for in-house projects in an international chemical corporation.

Update and maintain a Customer Relationship Management (CRM) database and communicate progress status reports on user requests, project status, and Service Level Agreement (SLA) on a Data Warehouse project, a Cognos BI Reporting project and a Lotus Notes development project.

EDUCATION

MBA Information Technology (GPA 3.75), Dec 2000 University of Dallas, Irving, Texas

BS Business Administration (GPA 3.5) May 1998 Ambassador University, Big Sandy, TX

TRAINING / CERTIFICATIONS

Attended the virtual Multi-Cloud and DevOps Bootmcamp led by Jean Rodriguez. https://www.linkedin.com/school/the-cloud-bootcamp/

Virtual Nov 28 - Dec 2, 2023

Microstrategy Certified Engineer (MCE) - Microstrategy 10.0, Microstrategy University

Dallas, TX Jun 2015

Microstrategy Certified Engineer (MCE) - Microstrategy 9.0, Microstrategy University

Tysons Corner, VA Mar 2013

Tableau Desktop Qualified Associate Certificate, Edureka Training, March 2019

Informatica PowerCenter Developer, Edureka Training, Jan 2019

IBM PureData System for Analytics Technical Mastery Exam, Feb 2016, Dallas, TX

Microstrategy Certified Engineer v9, Jan 2012, Microstrategy University, Tysons Corner, VA

Alphablox Suite: Alphablox Analysis Server, May 2001, Computer Training Center, New York, NY

Hyperion Essbase: Fundamentals, April 2001 Hyperion Training Center, Addison, TX

Contact this candidate