OBJECTIVE:

Senior level, quality data architect and agile solutions development position with focus on requirements, analysis, design and delivery of BI reporting solutions. Serve as a technical resource with direct engagement to internal and external business users to create, customize, enhance, integrate and maintain Reports, ETL and data solutions for new and existing business. Using SSRS, SSIS, SQL Server, BIDS, SSDT, POWER - BI and the latest Microsoft stack or EPIC Reporting and development solutions to integrate and leverage new and existing data models to deliver tomorrows information today.

PROFESSIONAL SUMMARY:

• Eighteen years of engagement and development initiatives within data analysis, reporting, ETL, client, server and web-based applications.
• Using Microsoft technologies in a variety of small to midsize, fast paced, rapidly expanding companies and industries.
• My expertise and certifications include REPORTING, ETL, data models, web and application development, Business Intelligence design and development as well as integration and reporting on transactional and OLAP data structures.
• Vast understanding of a variety of ERP systems as well as SharePoint, Intranet, Internet and portal technologies.
• Recently certified in EPIC. Analytic decision maker with focus on cross organizational goals that conform to business needs affecting bottom line.
• Recognized for my ability to quickly learn changing technologies, applications, roles and my influential and passionate team orientation and mentoring among team members, senior managers, vendor’s contractors and customers worldwide.
• Awards, real world experience and certified in all aspects of the development and business life cycle.
• I have the drive and passion to leverage tomorrow’s data to make key decisions today

EXPERIENCE:

Data Analyst / Consultant

Confidential

Responsibilities:

• As a consultant and passionate team player to the Data Platform team I aided clients with a variety of tasks including SSIS package development of flat file data transformations for tribal health care.
• I created parameterized stored procedures for T-SQL data transformations to be used as code to be passed through an application interface.
• I documented 30+ DTS to SSIS converted packages that were using SQL and Oracle.
• Over the holidays I had the opportunity to do an SSRS conversion project using FetchXML to gather data from Dynamics CRM 365 in the cloud.
• I was able to clone the T-SQL quries in XML and rebuild the SSRS reports including sub reports then move them to OnPrem and QA instances in the cloud.
• I am also educating myself in Power-BI to become certified to use the power of data to surface predictive, valuable insights for client business.

Senior ETL Developer

Confidential

Responsibilities:

• As a member of the EDW (enterprise data warehouse) team and using Microsoft technologies as well as Health Catalyst data warehousing source mart designer (SMD and SAMD) I’ve developed processes using data management and profiling to create data structures that move data from enterprise systems such as EPIC and outside vendor information systems into EDW (enterprise data warehouse).
• Working with other contractors, vendors and business analyst I’ve been included on many ETL projects to bring data into the warehouse for reporting needs within Confidential ’s Healthcare.
• A couple examples include writing of an SSIS package to bring data in from one of our vendors that have an online signup to alert parents of their child’s upcoming surgeries. By simply providing an MRN and birth date in a file from an external FTP, we bring the data into a source mart and join it to our data warehouse to get the patient, provider, doctor and surgery information. The package then sends out a secure file that gets imported back to the vendor system so the patient can be alerted via email or text messages of their upcoming surgeries.
• I was quickly able to quickly learn the Health Catalyst development tools to bring in data from such vendors as Confidential Corp into new tables and schemas of the EDW warehouse.
• Using SQL queries and ETL process to read from flat .csv files to transform and cleanse data to be ready for the reporting analysts to measure how well Confidential performed via patient evaluations provided by 3rd party.

Data Analyst/Report Writer

Confidential

Responsibilities:

• Report writer and data analyst using Confidential, Microsoft SQL Server and Crystal reporting.
• Contract included becoming certified to implement crystal integrated reporting in the ADT and Cadence modules.
• Created new and modified existing reports for admission, discharge and transferring of patients within the hospital.
• Responsible for hospital billing, financial data, insurance claims and scheduling, Initiated centralized reporting by using SQL stored procedures and functions.
• Advised in the implementation of security for the data warehouse.
• Initiated rollout of the EPIC created data cubes for hospital and professional billing transaction activities.

Senior Financial Analyst and Report Writer Consultant / Contractor

Confidential, Milwaukee, WI

Responsibilities:

• Demonstrated the capability of querying the report server to gather subscription details for fiscal year end close.
• Updated complex subscription data such as subscription processing of the second or third business day of the month from within the SharePoint integrated environment using advanced T-SQL.
• Aided in a minimum of 1 to 2 tier 3 support calls from attorneys and staff on a daily basis for financial reporting.
• Set new standards for creating reports using T-SQL synonyms, functions and stored procedures to modularize code from the numerous reports, subscriptions and data sources for the finance department.
• Worked with the DBA to grant security rights to the report server for the report writers in finance as well as advised on the use of active directory groups for granting users security to their reports reducing maintenance within the financial reporting team.
• Guided the direction and vision of self-service reporting for the analysts, staff and attorneys within the firm.
• Demonstrated the ability of reporting from a thousand-foot view, drilling down to detail level reporting of millions of records very rapidly within the legal practice.
• Taught report writers how to use cascading, multi select parameters and sub reports to drill down and filter detailed legal data.
• Aided in recoding of functions, stored procedures and triggers used in the ETL process bringing in Data from Elite ERP to the data repository on a monthly basis.
• Worked daily in a very dynamic first-class business professional environment often directly with the CFO and financial analysts.

MS Dynamics Great Plains and Confidential SSRS Report Writing Consultant

Confidential, Milwaukee, WI

Responsibilities:

• Using Microsoft Dynamics AX, SSRS, SQL Server, BIDS extending data and report processing in custom applications and existing data to create custom Not In Stock reporting for purchasing and ad hoc Customer Aging reports for Beyond Vision.
• Using SSRS, SQL Server, BIDS, and the latest Microsoft stack of reporting and development solutions leveraging Microsoft Dynamics Great Plains and Confidential data models to create and customize reports for Prism Electric. Directed the completion of top projects to include labor, invoicing and work order reporting.
• Served as a lead consultant directing report creation and customization of GP, Confidential and Custom reporting.
• 2 year remote position as a technical lead and hands on development of custom report creation integrating into GP, Confidential and Prism ERP modules.
• Served as a mentor and trained on boarding internal staff to use and develop system wide reporting.
• Consultare to At a Glance Financials providing the backend data concept and design to the web development team using SQL Server to integrate custom process into their exclusive Warthog financial application.

MS Dexterity Signature Developer and Report Writer

Confidential, New Berlin, WI

Responsibilities:

• As a dynamic and passionate member of the Signature team and Confidential product line I was able to step into the role of a Microsoft Great Plains Dexterity development engineer and create new windows and modules for refrigerant tracking that is tightly integrated within Confidential Service and Job Cost as well as a 3rd party application to Dynamics Great Plains.
• This priority feature to the Signature product line is due to be showcased in Florida during Synergy 2012 and is a huge success for the organization, partners and customers.
• I was also able to re-design, develop and create a whole new set of complex accounting and financial SSRS reports for deferred revenue and cost reconciliation reporting against Dynamics Great Plains and Confidential data models. This re-design corrected a flaw in credit account balance and improved performance by two-hundred percent.
• The project extended ROI to the customer base and gave our consultants a competitive edge by leveraging my unique design and the interactive capabilities incorporated to the report GUI.

Business Intelligence Analyst

Confidential, Beloit, WI

Responsibilities:

• An integral member of the business intelligence team within ICT, Confidential, Americas Region.
• Using Excel Services Technologies and SQL Server Reporting Services Technologies, developed, deployed and maintained reporting for a variety of business units within the SharePoint Portal Environment.
• The business portals are part of the 1Kerry Global Consolidation and encompass one or more of Americas Regions Top Projects for the year 2010 such as Customer Service integration.
• Administrator of all OLAP security roles, ProClarity users Excel Services users and OLAP cube role applications.
• Streamlined role setup and reduced request latency to same day turnaround.
• Supported many BI project deliverables using reporting technologies such as SSRS, Excel Services and IBI.
• Created and integrated into SharePoint reports for Business unit’s including Call Center reporting, Sales Force reporting, Customer Service reporting, LIMS reporting and MCM reporting.
• Initiated and developed monthly End Use Market reporting for the Dairy and Culinary business within the organization. Worked with all members of the team to build an inventory reporting system from the OLAP inventory cube surfacing data as an excel services portal page for the business.
• Other reports and tasks include open orders reporting, report modeling for Sales Force and other alerts, LIMS reporting, SSRS subscription maintenance, resolving date issues on canned financial reports and integrating changes in OLAP security roles for Mexico/LATAM.

Business Intelligence Liaison

Confidential, New Berlin, WI

Responsibilities:

• A dynamic member of the IT group integrating directly across the organization with accounting, logistics, human resources, marketing and sales for Business Intelligence initiatives.
• An active TDWI member who developed reporting for the Microsoft VARassist program as a Strategic Business Intelligence Liaison using integrated SQL tools as well as third party applications and coordinating with outside consultants to move forward bringing online MS Dynamics Navision and our unique concept of visual e-Enterprise analytical reporting.
• Originated .NET development of front-end/back-end applications to import vendor data and gave the ability to sales staff to rapidly search MS Dynamics Great Plains of over two-million products driving sales relations to a new standard.