SUMMARY:

A Microsoft Certified Professional with 20 years of application development and business intelligence experience. Track record of delivering innovative solutions that receive commendations from clients.

TECHNICAL SKILLS:

Reporting Tools: Crystal Reports, Business Objects, SSAS, SSRS, SSIS, Excel, BI360, BIOVue

Databases: SQL Server, Oracle 10g, MS Access

Applications: Dynamics CRM, Dynamics GP, Visual Studio, Team Foundation Server (TFS), JIRA

Content Mgmt: Sharepoint, HIPPO CMS

Programming: VBA, XML Schemas, JavaScript, HTML, CSS

PROFESSIONAL EXPERIENCE:

Confidential

Scrum Master/Senior Software Engineer

• Update data warehouse to hold business data, including financial, investigation data available to cubes, reports, and a web service used by other agency applications.
• Develop reports and cubes for custom web - application using HIPPO CMS and Pentaho.
• Implemented Agile/Scrum practices to increase team building and improve burndown/velocity. Serve as liaison to business users/product owner to ensure business requirements are understood and translated into acceptable reporting solutions. Created requirements documents to review with business users, developers, and QA to verify end product.
• Maintained technical documents, including data dictionary and data model in ERWin.

Confidential

Technical Lead

• Developed reports using SQL Reporting Services, SQL Studio BIDS, Excel, and BI360 for COTS products (Microsoft Dynamics GP and Dynamics CRM)
• Developed dashboards for executives. Designed/built/support built data warehouse consolidating ERP, CRM, and other data sources to give the company a 360 degree view of financial performance, future work, backlogs, and consultant availability to provide KPIs for business decisions. Developed ETLs to load data across different platforms.
• Automated business processes to increase productivity and decrease operating costs, including using SSIS to automate email reminders for people to submit timesheets, automatically delivering files identifying data mismatches between systems so sales people/accountants could address, and delivering award notices when sales were closed.
• Created SQL scripts, stored procedures, and views for data integration/reporting. Troubleshoot technical issues related to Microsoft SQL, Dynamics GP/CRM, and other 3rd party products..
• Maintained technical documents for each project with either Visio or Power Point, including a data model of any tables/views used, SSIS packages created, and triggers to allow for easy maintenance

Confidential

Data Architect/Technical Lead

• As data architect on DHS Avant project, consolidated multiple business groups and legacy systems supporting the E-Verify and SAVE programs with a single Dynamics CRM application. As Agile lead, worked with M&C group to update application to capture required information, interactions with other business groups to share information. Clearance: BI with DHS 2012
• As data architect on USDA/APHIS project, developed a data model to use with the migration to Dynamics CRM and include new data related to the business processes to improve response.
• Customized internal application to assist with developing new proposals for business development. Maintained internal database servers, ensuring automated jobs integrated data and handled tasks to improve efficiency.
• Worked with end users to explain agile, review user stories, and develop acceptance criteria.

Confidential

Configuration/Database Administrator

• Monitored performance of database servers. Improved queries, indexing, and automation of processes that had previous been done by individuals. Automated email notices of General Ledger postings outside of acceptable ranges through SSIS/SMTP.
• Developed a data warehouse to consolidate multiple databases, including our Dynamics GP which had over 80 company databases.
• Implemented new BI tools, including SSAS, SSRS, SSIS, Power Pivot, and Crystal Reports, providing a variety of user-friendly, but powerful ad-hoc method for users.

Confidential

Reporting Analyst

• Developed reports (Crystal Reports, SSRS, and Excel) on Confidential databases for Confidential legal cases, RECA and Childhood Vaccine claims.
• Supported/maintained specialized databases used by clients for business group-specific data.
• Replaced time-consuming manual processes with Crystal Reports using parameters running off complex SQL statements, decreasing the delivery time of reports.

Confidential

Reporting and Quality Assurance (QA) Manager

• created/supported reports and QA of all databases/jobs. Developed cross-platform reports and created data extraction, transformation, and loading (ETL) process to import from other non-profit environmental agencies.

Confidential

Consultant

• provided various support for a variety of clients. Provided database/reporting support for clients needing new/updated reports. Project Management training to information technology professionals, with emphasis on risks inherent on an IT project and tools to help manage the project.

Confidential

Database Administrator/Report Developer

• managed a SQL database to support a custom web application to manage proposal/contract management. Developed Crystal Reports for the web application.

Confidential

IT Specialist

• provided a wide-range of IT services to a small, fast-growing online bank. Deployed BusinessObjects and created standardized reports for accounting. Handled network, telecommunications, and application support for all departments in the bank.

Confidential

IT Specialist

• provided a wide-range of IT support to a company that staffed physicians to emergency rooms. Developed a Goldmine database to track physician information with the goal of improving scheduling efficiency and reducing data duplication between regional offices.