Created enterprise wide automated reporting system for managing distribution, inventory, purchasing, sales, accounting and key performance indicators used in 46 international stores located in 5 countries.Automated daily merchandise distribution reports for a 40,000 SKU, $4 million dollar inventory, saving 75 hours a week for store personnel.Implemented Tableau dashboard to forecast restaurant sales and lower food preparation waste, as well as, Cost Percentage of Sales analysis. Currently, working on a sales analysis project to be implemented with Tableau in conjunction with a data warehouse on AWS Redshift.Assisted with data warehouse environment on AWS Redshift for use with Tableau.Performed bilingual requirements gathering, analysis, design, development, testing, implementation and support in English and Spanish.Designed and automated reports, dashboards and other processes using PowerBI, SSRS, SSIS, DTS, Crystal Reports, Excel & Access over SQL Server and Excel with a Firebird database.Scripted reports and processes in Microsoft Data Transformation Services using ActiveX with VB Script.Leveraged SQL Server Integration Services to create data files for external use, to automate system maintenance and generate automatic e-mail advisories when critical situations arise.Maintained and updated Google Data Studio reports with data hosted on Amazon Web Services.Developed and enhanced SQL Server objects to customize company wide Intelisis Enterprise Resource Planning software to limit data entry errors and support loss prevention policies.Created database tables for custom data and added indices to improve query performance.Developed SQL processes to create dynamic automated reports that overcame limitations in the database version for enhances SSRS capabilities.Collaborated with teammates to perform three enterprise-wide ERP system upgrades.Mentored coworkers on functionality of the ERPs and attended to escalated support calls.

Implemented Medsyte(TM), health maintenance organization analytic application, for external clients.Extracted, transformed and loaded data (ETL) from SQL Server and NCR Teradata data sources, using SQL Server Data Transformation Services (DTS) and proprietary ETL tool, into a SQL Server destination for processing in SQL Server Analysis Services.Performed requirements analysis, technical specifications, data transformation, proprietary analytic processinig and SSAS cube updates.Collaborated with inter-departmental team on implementation of a 4 million member Medicaid program.Represented implementation team interests in client meetings.Created and modified project plans to meet aggressive timelines.Worked with star schema, parent-child data relationships, referential integrity & data warehousing.Performed requirements gathering, specification documenting, project plan adjusting and worked around product limitations in order to meet client timelines.

Customized and implemented homegrown health insurance claims systems for Health Maintenance Organizations and Third Party Administrators.Developed customized reports using Cognos Impromptu.Interpreted client databases, created technical specifications, data mapped and loaded data into the claims system.

Returned to my role as Programmer Analyst II on a contract.

Contracted to work on-site at Memorial Sisters of Charity Health Plans in Houston, TXPerformed data conversion into the AMISYS claims management system.Implemented MACESS, a document imaging system, and developed an interface for the AMISYS claims management system.

Worked closely with the Claims Department to gather business requirements to create reports and modify claims edit system.Provided daily support for the electronic claims system that received claims electronically from local health care facilities.Provided daily support for the claims modules of the medical claims system, including data analysis on Oracle.Created a dynamic correspondence generator implemented company wide.Participated in the on-call team for late night systems issues.Started as a student intern and progressed to a Programmer Analyst II in two years.