Kennesaw State University - College of Science and Mathematics

Kennesaw State University

Business Intelligence

Birmingham, Alabama Area

McLeod Software

Internal Business Intelligence Director

REZDESK

Business Intelligence Manager

Researched and analyzed various Reporting tools and ETL tools.  Designed and developed real time XML shredding architectures to meet the business requirements for a property and casualty Insurance software system. Coordinated with external BI tool vendors.  Determined requirements for client reporting and implemented in Looker.  Created models, views, explores using LookML code within Looker. Created jobs within Talend. Created EC2 instances within AWS.  Used Amazon Web Services Data Migration Tool to replicate data from Aurora to Redshift. Created several Lambdas within AWS.   Developed JAVA based code used in the Lambda to call Talend job.   Created a dimensional model based on business data.  Interview and hire BI developers. Lead two teams of developers. Utilized JIRA to track team tasks and Epics.

ISCS

Business Intelligence Reporting Architect

Maintain and update SSAS Tabular model several ETL packages using SSIS and reports using SSRS for a pharmacy group purchasing organization.  Complex analyses using TSQL and Excel.  Gather reporting and analysis requirements from users throughout the company.  Implement business requirements using SSAS Tabular model, Excel, SSIS and SSRS.

APCI

Business Intelligence Specialist

Designed BI reporting solution for a Healthcare recover agency.  Used the Kimball methodology to architect, design and implement an enterprise data warehouse(EDW).  Developed Dimensions and Fact tables based on data from various systems and business requirements.  Created SSAS cube from enterprise data warehouse.  Analyzed both client and internal data.  Gathered reporting requirements from users throughout the company. Responsible for the overall architecture of the BI systems.  Architected a portal for our clients to view reporting using SSRS and performance point in SharePoint 2013. Provided support for multiple legacy BI systems.  Determine BI policies and procedures.  Implant security and user levels within reporting.  Interview, hire and train developers reporting to myself. Managed 3 direct reports plus additional resource from other departments. Mentored junior developers. Assigned support and development tasks to resources. Managed schedule and timeline of projects using MSProject.

Adreima

Manager of Business Intelligence

Key projects:•	Healthcare recovery agency - Conducted an extensive analysis of client's current information systems, including two enterprise business systems, back-office infrastructure, accounting and employee time-tracking systems.  After analyzing and prioritizing business intelligence needs,  used an Agile approach to construct a business intelligence (BI) roadmap for the client which included architecture to allow future data marts, growth and change.  Integrated data from both enterprise systems into a single Microsoft SQL database using SQL Server Integration Services (SSIS) during the initial phase. Helped client's managers define key performance indicators (KPIs) and other metrics and established preliminary definitions for a “single version of the truth” for the data. Determined metrics necessary for Benchmarking against similar companies. Once the vision and architecture were in place, worked to implement a data cube built on SQL Server Analysis Services (SSAS). This data cube gives managers the ability to create customizable reports and add dynamic, sliceable data to existing static reports.  Used drill through data from the cube created standardized report. Educated VP level users on using PowerPivot  to solve additional business Intelligence needs Directed Team Shore resources in completing business intelligence tasks. •	Supply Chain - Created data mining model which predicts future sales based on Client Store's sales history.   Integrated predicted sales and customer order system used by Client's customers for restocking.  Created SSAS cube and multiple SSRS reports displaying sales information.  Used SSIS to populate staging tables necessary for SSAS cube and data mining model.•	Multiple smaller projects - Created SSAS, utilized the cube in order to create KPIs, scorecard and graphs within PerformancePoint and/or SSRS.

NWN Corporation

Sr. Engineer

Implemented modifications to an existing e-commerce website, using C#, ASP. NET 3.0, TFS and Microsoft SQL Server 2005.  Used SSIS packages for the import of data into MSSQL Server 2005.  Wrote technical specifications, and communicated with various departments in order to clarify requirements. Utilized HTML, CSS, JavaScript, ProtoType and XML in developing of the front-end UI of the website.

Benchmark Brands, Inc

Net Developer

Two short term contracts. Using C# on ASP .NET and Microsoft SQL Server 2005.  Project 1 - Integrated the development of a new section to an existing website, under the supervision of Summit Marketing's lead developer.  In this contract I developed in C# with a MSSQL database.  Implemented LINQ in C# to manipulate data before or after  a using  stored procedure to transfer the data to the database. Utilized HTML, CSS, JavaScript, JQuery and XML in developing of the front-end UI of the website.Project 2 - Designed and developed a WCF service using C# to provided various front end websites access to business logic and third party shipping information.

Summit Marketing

Software Engineer

Responsible for design, development, implementation and maintenance of concurrent multiple web based enterprise projects, using object oriented designs and well know design patterns in an Agile environment. Projects were N-tier web applications using the MVC pattern,  written in C# with a MSSQL server backend database. ASP .NET, along with MSSQL server. Wrote stored procedures and Architected MSSQL database designs including normalized table structures, indexes, and queries optimized for performance.   Utilized HTML, CSS, AJAX, JavaScript and XML in developing of the front-end UI of the web-sites. Key projects:•	A system of e-commerce sites owned by one client.  Maintained existing websites & applications. Designed, integrated & implemented new database architecture and development with a common backend database. Implemented security permissions. Developed supporting applications which consumed external SOAP based web services.  Obtained business requirements from the client, provided time estimates, provided an overview of the software design requirements for new development to other developers, assisted other developers in the development, and monitored system error notifications.    •	An enterprise system providing brokers a web-based platform to property information. Responsible for the integration design, development & implementation of sub-projects & ongoing upgrades to the Website, web service & supporting systems.  Participated in & conducted JAD sessions with the client, other developers and IT departments.  Calculated estimates for completing development. Integrated a custom web frontend for SSRS with the site's existing reporting area. Migrated & updated the existing queries utilized for reporting. Determined implementation time-lines & sub-projects' priority.  Provided an overview of the software design requirements to other developers. Assisted other developers with development questions & code; reviewed developers’. Maintained database replication.

Northridge

Sr. Software Engineer

Responsible for interpreting Clients needs by gathering requirements, Developing Web sites using HTML and PHP, designing graphics, Creating Macromedia Flash Splash screens, creating, using and integrating MySQL databases, time estimation, invoicing and other needs required to manage a business.  Customized Goldmine to use in the auction industry, implemented customized software, wrote technical documentation on customization and lead learning sessions for end users on use of customized software.

Clay

Alyson Posey

Alyson Posey