PROFESSIONAL SUMMARY:

• Self - Motivated and Self Starter
• Confident, articulate, and professional speaker to a variety of audiences
• Diligent and enthusiastic with a proven track record of working successfully across functional areas within teh enterprise
• Have led efforts for requirements gathering in all phases of teh SDLC
• Led Business Intelligence end to end solutions development through management
• MicroStrategy systems analysis, solutions analysis, architecture, development and management while in teh retail industry
• ETL design, architecture, development, integration and deployment of SaaS solutions
• Data Architect of a cloud based, SaaS web service consolidating 98 + existing services, cleansing, harmonizing teh data, and delivering syndicated outputs
• SAS software integration, administration and programming in teh healthcare and financial sectors
• Project lead from conceptualization, through design, integration, and implementation of a 3.4 million-dollar SAS software system built and utilized by teh State of Alaska, Division of Medicaid for consolidating multiple data sources, performing advanced analytics, flagging fraud, anomalrns for further investigation
• Worked in multiple large-scale data migration and integration in multiple environments
• SQL analysis and development in many sectors including Healthcare, Financial, Insurance, Natural Resources (Oil and Gas) and Retail
• C level report creation and automation on teh state of Alaska Medicaid in relation to many Federal and State of Alaska initiatives (examples: LTC facilities MDS calculation automation, Dental Encounter Settlement calculation automation, Behavioral Health, and other ICD-9-10, CPT, and HCPCS code sets).
• Healthcare Affordability Act preliminary implementation testing through ‘go live’ Jan 3, 2012
• MMIS (Medicare Medicaid Management Information System) administration and systems analysis
• Extensive use of teh Microsoft Suite (Word, Excel, PowerPoint, SharePoint, Visio, Project) in multiple industries.
• Have worked with an array of BI tools (MicroStrategy, Tableau, Power BI, OBIEE etc.) as part of teh data gathering and analytic/data discovery phase of any project

TECHNICAL SKILLS:

Languages: SAS, R, T-SQL, PL-SQL, ECL, Unix Shell, PowerShell, CAML, DAX, MDX

Environments: HPCC, Windows, Unix, OS X, IBM iSeries, web hosted & local distributed environments, NoSQL data stores, Oracle 11c and 12g, MS SQL Server 2008 through 2017

Software: MicroStrategy, Elasticsearch (Kibana, Logstash), OBIEE, Oracle 12g, Visual Studio (SSIS, SSRS, SSAS) SAS (Base with multiple business specific modules), R, MBS, Essbase, SAP, Pentaho, Talend, Microsoft Products, Toad for Oracle. (others upon request)

Databases: Vertica, Netezza, DB2, MS SQL Server, MySQL, Oracle, Sybase, FoxBASE, NoSQL environments and other distributed environments.

PROFESSIONAL EXPERIENCE:

Confidential, Dothan, A L

Senior Developer

Responsibilities:

• Redesigned and implemented a new Enterprise Data Warehouse (EDW)
• Re-wrote SQL driven EDW with more dynamic, faster running SQL
• Built teh new EDW to contain Error Handling on All Executables so if anything failed, me knew detailed information about teh failure so me could address it.
• Wrote all ETL (Extract, Transform, Load) procedures to keep dis EDW updated, accurate and reliable
• Was responsible for maintenance of teh servers me used for, Development, Test and Production environment
• Utilized SolarWinds to monitor, and make adjustments to queries and tables to increase speed
• Performed Integration of MicroStrategy to dis new Enterprise Data Warehouse
• Wrote SQL in a way to increase speed of queries upwards of 300%.
• Indexed all tables very strategically with teh halp of DynPerf
• Worked across teh Enterprise on Database issues.
• Was teh impromptu DBA on a team dat did not have an established DBA
• Worked with Web team to support making a plan to integrate teh Website to use teh new Enterprise Data Warehouse

Confidential, Birmingham, AL

Senior ETL Developer

Responsibilities:

• Developed an Error Handling method for SQL Server using SSIS
• Developed a method of going between Incremental Data Loads and Historical data loads to teh Enterprise Data Warehouse
• Perform teh ETL teh get data to teh Enterprise Data Warehouse bringing in new data elements

Confidential, Birmingham, AL

Senior Data Engineer

Responsibilities:

• Load data from various source systems to an Enterprise Data Warehouse
• Optimize SQL queries when needed for performance
• Use multiple tools to create teh ETL to load teh EDW
• Write SQL queries to pull data into teh EDW
• Tune and Optimize Oracle and Vertica SQL Queries
• Worked on a large-scale cloud migration of an Enterprise Data Warehouse. Moved an on premise EDW to teh cloud
• Managed Data Migration using Informatica Cloud iPaas (integration platform as a service)
• Used Kimball Data Warehousing methodology to create and load data into structures

Confidential, Birmingham, AL

Programmer Analyst III, Enterprise Business Intelligence

Responsibilities:

• Gatheird requirements on large scope projects dat would be built to support teh Enterprise
• Worked heavily in Visual Studio developing solutions (SSIS, SSRS, SSAS)
• Worked with Oracle 12g in all regards via Toad
• Was second in command (backup) for Regions Financial Corporations SAS data operations
• Programmed, troubleshot, introduced SAS code into a SAS user base of 400+ users
• Programmed in Windows PowerShell extensively when applicable
• Worked with SharePoint Designer on certain solutions
• Directed projects with C level executives on custom programmatic solutions.
• Designed workflows and solutions to meet needs dat couldn’t be met with out of teh box solutions
• Developed SQL queries which would enhance teh environment as well as populate SSRS reports
• Worked heavily in Microsoft’s Power BI application both on premise servers and their cloud service offering
• Integrated R into a few projects through Visual Studio’s new interface to R
• Integration, MDM and ETL performed with Informatica MDM Suite

Confidential . Birmingham, AL

Senior Business Intelligence Solutions Analyst

Responsibilities:

• Defined data requirements and designed report (metrics & other objects) layouts for teh business to review and utilize.
• Worked with development team to define and migrate data from multiple sources to operational data stores and data warehouse for multiple uses me.e. reporting, analysis etc.
• Created testing plans and scripts for new project additions based on business and technical requirements.
• Created and delivered documentation and solutions to various business teams to quantify key projects and their business impact
• Oversaw integration projects into a common BI environment, MicroStrategy
• Managed relationships with key business stakeholders through teh process lifecycle

Confidential

ETL Developer

Responsibilities:

• ETL, utilizing ECL (Enterprise Control Language) Development
• Create support and persist multiple products through ECL development on a HPCC platform
• Utilize multiple platforms in concert for product development
• Work with multiple teams to ensure smooth transitioning through teh SDLC
• Worked across platforms bringing data to a Linux platform for ETL and ELT

Confidential

Senior Consultant

Responsibilities:

• Worked across multiple platforms in an enterprise data migration
• Member of HPCC Development team (proprietary open source ‘big data’ platform, HPCC), developing reportable data marts from MS SQL Server to a distributed environment
• Systems including, but not limited to, Siebel, Eloqua, Essbase, MBS, Google Analytics, HPCC
• Data was transformed and cubed for reporting using OBIEE, Tableau dasboarding etc.
• Worked across platforms bringing data to a Linux platform for ETL and ELT

Confidential

Business Intelligence Analyst

Responsibilities:

• Analyzed, reconciled, validated, updated, and made changes to data from over fifty physical/virtual servers located throughout teh U.S. and Canada.
• Worked with Business Analysts to validate UAT environments to ensure all clients’ needs were being met prior to moving to production
• Analyze, modify, change and create stored procedures and reports as needed using MS BI Stack
• Interpreted various data sources and structures and advised senior management on data governance as well as Business Intelligence best practices.
• Generated and executed Test scripts in and plans for new Energy Efficiency related programs.
• Generated updates, transactions and other transformation scripts to align data from disparate sources.
• Maintained scripts during all phases of teh SDLC.

Confidential

Big Data Analyst | Data Scientist

Responsibilities:

• Worked on teh data science team analyzing large amounts of data
• Performed all SAS Analytics for teh enterprise.
• Administered a SAS server (V-9.3) in all regards.
• Analyzed and modeled financial data showing patterns in fraud and trends determining default
• Worked with executive management on company initiative development, integration and implementation

Confidential

Data Architect | MDM

Responsibilities:

• On teh development team of teh “Scientific Workflow Management Solution Harmonization” project, combined and cleansed data across 98 legacy systems and developed a SaaS solution utilizing many current software development techniques/methodologies in an Agile/ SCRUM development environment.
• Assisted Liaison’s SOI (Service Oriented Infrastructure) and Contivo (Liaison’s proprietary mapping utility) developers in teh configuration, scalability, testing and standing up of teh environment for dis project.
• Performed Master Data Management and data architecture in teh build of a SaaS solution
• ETL in teh integration of multiple data sources
• Utilized were web services, SOAP calls (Extraction), XSD construction using a proprietary mapping solution (Contivo), PL-SQL, PL-SQL Developer, Oracle (10g,11g), MS SQL Server, and finally served up cleansed data marts to an SFTP.

Confidential

ETL Developer | Architect | PM

Responsibilities:

• Project lead in teh full lifecycle (RAD) development of specialized applications to implement new state or federal regulations and policy changes | incentives quickly
• Modeled data, ETL processes and performed analysis of these specialized applications, in parallel to ensure policy was integrated correctly
• Analysis, reporting of State of Alaska, Division of Medicaid policy and programs to ensure consistency, detect fraud and abuse, efficiency and compliance
• Conceptualized, designed and implemented a 3.4 million-dollar SAS software system allowing teh state to consolidate multiple data sources (ETL) and established processes and procedures to analyze 20-25 million dollars in weekly Medicaid claims
• Provided a SAS analytic environment allowing 60 + Medicaid program managers tools needed to make informed, quantifiable reasoning to support program changes
• Implemented an analytic solution used in reporting to key stakeholders in teh state and federal government, fiscal agents, and business partners
• Developed Centers of Excellence (COE) related to project & program models, development and deployment ensuring effective deployment of personnel, processes and technology and documentation
• Defined teh concept, data model, ETL, and macros to automate an acuity-based measure of payment for specific Medicaid programs and generate reports for state and federal officials
• Digest, interpret and implement policy, ensuring compliance and determining impact
• Served as teh point of contact on many federal/state initiatives in healthcare
• Created requirements documents and liaised on enterprise software and hardware implementation
• Identified related risks, constraints and needed action on BI project transformations, technical and functional analysis, product selection and change management