OBJECTIVE:

• After 25 years of contracting, I have acquired a great amount of knowledge, as well as strong hands - on experience using SQL Server data technologies. My focus has centered on constantly improving my BI / Data Warehouse development skills specifically with the Microsoft SQL Server database and its BI Stack (SSIS, SSAS, SSRS, MDX, DAX, Power BI, Multidimensional, Tabular, Excel Power Pivot, Azure, C#, ASP.NET.) I am committed to continue specializing and being "the best" I can be in the product's vast technical areas so that I can provide the best solutions to business problems/opportunities for my clients.

TECHNICAL SKILLS:

SKILLS: SQL Server 2014 Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS) SQL Server 2008 Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS) SQL Server 2005 Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS) SQL Server 2000 Analysis Services, Data Transformation Services (DTS) Transact SQL ASP.NET, C#, MDX, DAX, PowerShell Azure Excel PowerPivot, PowerBI

PROFESSIONAL EXPERIENCE:

Pricing Systems Data Integrator (Contractor)

Confidential - Napa Valley, California

Responsibilities:

• Support and operations for custom built Access and SQL databases used for pricing integration between Vistaar Pricing System and JD Edwards while system creator was on leave.
• Fast Learn of a very complex of assorted servers and systems that were wired together.
• Understand and Execute the manual reporting systems
• Understand and Execute all the manual data flows between systems via many Ftp sites, programs and sets of templates, scripts, and programs.
• Role main purpose was to keep a complex pricing group of programs running so that pricing discrepancies, modifications, deletions and additions could quickly be implemented across all the systems on a daily basis.
• Support operations of a parallel development project that will replace significant functionality of the system.

BI / ETL Application Developer

Confidential - Dallas, Texas

Responsibilities:

• Full Migration of data from SQL 2005 to SQL 2014 to Azure VM as a Pilot Test.
• Worked on re-architecture of data warehouse from an ODS to a Kimball-based data warehouse, adding changing dimensions and consolidating subject groups.
• Working closely with subject matter expert and architect to identify, create and implement business and technical requirements.
• Highly involved in Azure evaluation, pricing, pilot testing, and implementation of system as a Cloud based solution.
• Creation of system documentation focused on setup and recoverability steps.
• On-going of internal BI personnel for eventual full turn-over of new system.

BI Application Developer

Confidential - Dallas, Texas

Responsibilities:

• Created SSRS Reporting System for analyzing 14 Cashier Register key presses which included some of the following Item Voids, Transaction Discounts, Aborts, Suspends, Drive-Offs, Coupons, Refunds, etc.
• Incorporated SSAS KPIs and custom MDX coding to support the 10 plus different SSRS views of the system
• Migration of SQL Server objects to PostgreSQL 8.3 (Green Plum Version) for the Sales Data Mart.
• Re-wired cube to work against PostgreSQL star schema tables/views.
• Introduced Cube partitioning to drastically reduce the time to create daily and weekly cube builds on large cubes.
• Created a subsystem for automatically building these partitions via an SSIS package and metadata stored in tables specific to the needs of the respective cube. Also, made the package to load balance and speed up the overall time of building the partitions by implementing the SSIS package to use parallel process up to four partitions at a time (that's all the processors we were allowed to use on the box for parallel processing.)
• Recommended and implemented Cube Partition Strategy where only incremental data loading and processing would be required on specific measure groups with reduced cube build times for one cube from (too big to process-estimated a week to process, crashed box) to only 4-5 hours once per week. By partitioning another cube, processing went from 12 to 3 hours, again using an incremental partition processing approach.
• Addressed measure group granularity level (was at seconds) for a cube and reduced its daily build time from 8 hours to 8 minutes, with the added benefit of improved querying performance.

SQL Server ETL Architect (Contractor) - SQL Server 20008 (SSIS)

Confidential - Orlando, Florida

Responsibilities:

• Logical Design Phase
• Identifying Report Data Requirements
• Identifying Data Sources
• Consulting with Data Architect on both OLTP and Star Schema Logical designs

SQL Server Subject Matter Expert

Confidential

Responsibilities:

• Member of Stability and Performance Group
• Create and implement Design and Coding Best Practices documents
• Administer Business Requirements Document (BRD) Reviews
• Administer High Level Design (HLD) Reviews
• Administer Low Level Design (LLD) Reviews
• Administer Code Level Reviews

SQL Architect / Developer

Confidential - Arlington, Texas

Responsibilities:

• Full database design and implementation for reporting Key Performance Indicators (KPI) and their respect three levels of targets over different periods (Month, Quarter, Half Year, Full Year and YTD.) Performance levels (background coloration) are assigned to each KPI value based on the KPI value's position relative to its targets. Dashboard consists of four different levels of detail for drilldown.
• Created a SSRS Dashboard as well as a suite of administrative and system monitoring reports. One report allows the user to change data on the report and save it directly back to the database through the report itself. All reports are setup on the SSRS server and then accessed via Sharepoint 2010.
• Designed and implemented an ETL solution using SSIS that populates the database via specifically designed Excel Templates for each KPI that can be submitted at any time by the user. The spreadsheet files are then processed via a SQL job that runs every half hour.
• Implemented email notifications embedded in the ETL alert users, system administrators, and operators when a problem occurred, when data was updated, or when data was late.

BI Application Developer

Confidential - Dallas, Texas

Responsibilities:

• Created SSRS Reporting System for analyzing Softline-Size distribution based on Sales and Reorder points to determine purchasing mixes. Create Cube, using a SCD Type 2 Customer dimension, to evaluate Customer Lifetime Value over 2 year period and 14 demographics (Age, Gender, Marital Status, Rank, etc.)
• Enhanced Food POS Cube to in corporate discounts and create reports in SSRS to track discounts to identify fraud, determined discount percentages outside norm for restaurant chains, and correlation of discounts to revenue generated. Create SSRS Report that for Millionth Snicker bar sold contest.
• Created all ETL in SSIS that ran against both SQL and Teradata data sources to supply data to the above applications.

Senior SQL Developer (Contractor) - SSIS2008, SS2008

Confidential - Fort Worth, Texas

Responsibilities:

• Built an ETL type posting system using SSIS 2008.
• All packages were created to automate the different functions required for selling past due debt loans to a third party collection company. Packages are written so that each event involved in the sale of a past due loan is recorded. A monthly cycle may incur up to 20 different activities using different business rules ranging from email alerts to closing out the account.
• Implemented Package recovery and restart ability to ensure data integrity.
• Implemented the ability for some packages to roll back all changes (including deletion of csv files) via package event.
• Designed a highly normalized metadata database specifically to support these packages’ automated functionality. This database also held the actual log and debt tables.

ETL Developer (Contractor) - SSIS, SS2005

Confidential - Fort Worth, TX

Responsibilities:

• Creation and modification of ETL processes and stored procedures to populate International Data Warehouse.
• Used Control-M scheduler for scheduling DTS packages.
• Added processes for product sales explosion and indirect customer sales based on specifications handed down by the Business Analyst and ETL Architect.

Business Intelligence Developer

Confidential - Dallas, Texas

Responsibilities:

• Full development and implementation to collect NETIQ data into a data warehouse via SSIS.
• Created new systems that allow Proactive Caching emulation via SSIS packages for better control over the Cube updates and automatic creation of new partitions without user intervention.
• Created dashboards via Performance Point 2007; as well as scorecard reports via ProClarity and published them into SharePoint Server 2007.
• On-going changes to existing SSIS packages for use with other systems.

ETL Architect/Developer (Contractor) - SSIS, SS2005

Confidential -Fort Worth, TX

Responsibilities:

• Used SSIS and SQL 2005 to build an ETL interface which imports enterprise human resource files from an outside vendor and disperses its contents to 15 different systems.
• Established standards and best practices that will be used in future SSIS projects.
• Configurations files were used extensively for all the packages; which not only made many package re-usable, but also allows for easy deployment between environments.
• Data quality auditing steps were created in the packages to ensure that data counts and changes fell within acceptable thresholds and if they did not, errors would be raised back to the job operators as to the problems. That would then trigger any notification and troubleshooting procedures needed to resolve the problem.
• Embedded Restart ability functionality into the control flow of the system.

Data Warehouse/OLAP Architect (Contractor) - SSAS, SSIS, SSRS, SS2005

Confidential - Dallas, TX

Responsibilities:

• Helped kick-off company's data warehouse initiative using cube technology and reporting services as the front end.
• Worked with VP of IT to set the plan, design, and architecture; as well as actual development of a cost-effective OLAP solution made up of Microsoft BI technologies (SSIS, SSRS, SSAS) that fits the way the company does business.
• The work accomplished provides a basic foundation from which the company can continue to build its enterprise OLAP solution in-house.
• Creation and use of MDX based calculated members for YTD totals across Year, Quarter, Period, Week, Day with comparisons against the same date range for prior year; as well as the variances and variance percentages that result from these comparisons.
• Additional calculated members include Rolling year on all Date Period segments, which allows for almost instant analysis of one year rolling windows across multiple selected date period segments on reports. All these calculated fields appear as additional fields in the SSRS report builder repository from which any power user can easily select from and add to information rich reports that can be dispersed to the enterprise through an internet browser in minutes.
• Created a restaurant based Comp dimension that emulates the company's logic in determining comparable data based on the individual restaurant's Open date and applying it to the fact tables.
• Performed ETL process and reconciliation of all sales data and transaction counts across three disparate POS systems in order to established a baseline from which daily imports (ETL) of data could begin.

Data Warehouse Architect - SSAS, SSIS, SS2005, Executive Viewer

Confidential - Dallas, Texas

Responsibilities:

• Responsible for Data Warehouse design and implementation using SSAS 2005 and SSIS 2005.
• Focus on moving Hospital Profitability system relational reporting system to Internet accessible SSAS system (cube) incorporating third party front end OLAP software (Executive Viewer.)
• Creation and implementation of technical requirements documents, time estimates, schedules, and deliverables.
• Created standards document that included naming conventions, storage layouts and star schema.
• Created SSIS packages with logging, recoverability checkpoints, and abstracted data sources.
• Created sophisticated calculated members using MDX techniques.

Data Warehouse Manager - AS2K, DTS, SS2K, SSRS

Confidential - Fort Worth, Texas

Responsibilities:

• Managed start-up data warehouse project for property and casualty insurance company with the main goal to enable actuary to identify trends in order to tweak rate factors for maximum profitability.
• Worked with DBA, developers and business stakeholders in determining requirements.
• Created requirements document, scheduling milestones, naming conventions, data quality standards, fact table granularity, dimensions, subject areas (Premiums, Claims, Losses, etc.), data modeling, demonstration/prototype/evaluation/purchase of OLAP software (Executive Viewer by TemTec) and slowly changing dimension strategy.
• Used SQL Server 2000, Analysis Services, DTS, Visio, Microsoft Project, and Executive Viewer.

SQL DBA (Contractor)

Confidential - Fort Lauderdale, Florida

Responsibilities:

• Performance Tuning
• Change control
• Code promotions
• Code reviews
• Transactional replication administration
• Weekly Code/Date Promotions

Data Warehouse Cube Developer (Contractor) - AS2K, DTS, SS2K, Teradata

Confidential - Delray Beach, Florida

Responsibilities:

• In charge of development of Retail Sales Cube using Microsoft Analysis Services.
• Duties included layout, design, optimization and job scheduling of cubes and their builds.
• Duties also included the creation, modification, and performance optimization of Sql for all views that called out to a Teradata relational database and against over 1 billion rows of transactional data. These views were the source for all dimensions and fact tables in the cubes. Separate views were created for two main slowly changing location and product dimensions. The specific view chosen for these slowly changing dimensions was dependent on whether a full cube build or incremental cube build was being performed on the given day. Sales, returns, exchange rates, transaction counts, and mail-in-rebates each had their own dedicated cube. These cubes were combined into one final virtual cube that represented the Retail Sales Cube. Other dimensions in the cubes included were fiscal time, date comparables by location, currency, country and cumulative periods-to-date.

Data Warehouse Manager (Contractor) - AS2K, DTS, SS2K, VB.Net

Confidential - Doral, Florida

Responsibilities:

• In charge of establishing first enterprise data warehouse that encompasses AR Aging, Inventory, and Sales history data from company’s 15 subsidiaries located throughout United States, Central and South America.
• Set up data extraction from these subsidiaries through FTP, Replication, and Email (Excel spreadsheets.) Each data extraction presents its own unique challenges in that each subsidiary is using one of five different ERP systems. AR Aging and Inventory data are being stored as end-of-month snapshots in the cube. Each end-of-month date extraction set is associated with an end-of-month date level. A dimension has been setup that incorporates the end-of-month date data level into a time dimension, allowing for month to month tracking comparisons via the OLAP front end.
• Created VB.Net application for the manual import of Extraction Excel/Text files (unfortunately this was the only way we could get the data from some of the subsidiaries.) This program manages the end-of-month date datasets; and calls and runs DTS packages from a stored procedure.
• Encompassed full transaction commit/rollback capabilities and error handling in the DTS package with strong use of DTS Global variables that are populated initially from the user interface and then passed through the stored procedure. These techniques were critical to make sure that each data set was completely free of errors before being appended to the fact table.
• Automated File archiving and registering of the import event and data files and then recorded in an import register table which enables full tracking of all data extractions by subsidiary, end-of-month date, and data category.

Data Warehouse Manager

Confidential

Responsibilities:

• Created company's first Data Warehouse and Internet OLAP system. Warehouse is created using SQL Server 2000 batches, scripts, stored procedures, and DTS. Cubes are generated from SQL Server 2000 Analysis Manager. The system is updated nightly with data from company's legacy accounting system and other legacy data stores. Additional tables in SQL Server were created and used for cross-referencing, adjustments, and security (over and above the Windows Integrated Security used for authentication.)
• The cubes entail hundreds of different calculated fields (variances, rolling 12s, YTD, monthly totals, yearly totals, etc. etc. etc.) across several dimensions (location, product, salesperson, brand manager, three year history, 12 months, etc.) The system tracks goals, shipments, open orders, warehouse inventories, purchase orders, etc. Also, created a highly functional user-friendly extranet user interface using HTML, DHTML, JavaScript, VBScript, ASP, ADO, ADOMD (to access cube data), IIS 5.0 (using Windows Integrated Security) and SQL Server 2000 and Analysis Manager. System is used by all departments in the enterprise (from clerks to executives; but especially for management, sales and operations.)
• Drill-down and drill-across functionality is provided against the data output using DHTML and JavaScript. Aggregated data (along dimension levels) is presented from totals of the entire company down to an individual order's line items with only a couple clicks of the mouse. Screen data is easily downloaded into Excel using a third party Excel COM object. This provides users with the raw data and/or presentation ready reports of the data (with built-in graphs) that they can save on their local computer and use for further use off-line.

Database Architect (Contractor) SS2K

Confidential - Miami, Florida

Responsibilities:

• Responsible for designing and modeling the database for an enterprise extranet system which managed the routing and tracking of work requests throughout the company's different departments based on predefined workflows and personnel assigned to the corresponding work request type.
• Oversaw and reviewed DBA's code to ensure it met with design requirements that I had modeled and documented.
• Helped to create application development standards for the Web Application Department.

Senior Programmer/Analyst

Confidential - Plantation, Florida

Responsibilities:

• Credit Card Authorization Packet Router - Created Real-time authorization routing server program which receives, via WinSocket, packets from Unix client system and places data into both FoxPro and SQL Server databases.
• Customer Service - Letters System - System used by customer service department for distribution of different types of letters to customers. Database performed OLE calls to Microsoft Word to produce letters through a mail-merge process, and where Word was controlled on back-end from the Visual FoxPro application.
• Telephone Profile Database Manager - Re-wrote entire front-end system for the maintenance of all phone numbers. Custom specifications are entered for each number then later downloaded to Voice Response Units (Unix Boxes) where the information downloaded determines how the call will be processed, what voice menus will be played, and how billing will be determined.

Programmer/Analyst (Contractor)

Confidential - Hollywood, Florida

Responsibilities:

• Take-over and full support of their background checking program and the accounting system that was fully integrated to it. System included allowing customer to run their own searches over Citrix-Winframe on the front-end and receiving generated reports via modem calls performed by the program on the back-end to different information sources.
• Re-write of Invoice/PO FoxPro Systems
• Installation of Accounting System Upgrades Module (AR, AP, GL, Payroll, Bank Reconciliation) and Report Modifications
• Designed and implemented Data Replication Strategies International for Data Access to South America
• Designed and implemented a Labeling/Tracking System that totally integrates with their Invoices/PO System and Airborne
• Programming of Bar-Code Scan Guns and respective software to import and integrate their scanned data into tracking database
• Virtual Invoice Faxing to Customers from Invoice/PO System Screens with no Customer Fax Information Lookup in Faxing Software; as well as Invoice Fax-Back capability via Interactive Telephone Response System
• Novell Administration, ArcServe Tape Backup Administration
• Fax and e-mail Server Administration
• Remote Warehouse hook-up with PC Anywhere

Programmer / Analyst

Confidential - Miami, Florida

Responsibilities:

• Bonus System - Team member in major modifications and enhancements to system
• Systems Analyst Modeling System - Full Development
• Labeling System - Full Development
• Bonus system - Support and enhancements
• Sales Reporting System - Support and enhancements