SUMMARY:

Sr. Business Systems / Data Analyst With over twenty years of progressive consulting and engineering experience, detail oriented, responsible professional with a strong technical background. Dedicated team leader with strong analytical, problem - solving, and conceptual skills, takes ownership of assigned projects with an always learning attitude and great people skills.

AREAS OF EXPERTISE INCLUDE:

• Systems Analysis, Requirements & Documentation
• Project Management of Technical Efforts, Agile and Traditional SDLCs
• Database Architecture, Business Process Modeling & Data Structures
• Data Warehouse & Business Intelligence Architecture
• Data Analytics, Data Mining, Visualization and Predictive Modeling
• Presenting Technical Materials and Creating Understanding
• Developing Customized Training

LANGUAGES & TECHNOLOGIES:

• Microsoft Office Suite, O365, Word, Excel, Access, Visio, Project, PowerPoint, SharePoint, TFS, Git, Azure DevOps, Jira, FogBugz
• SQL Server (All Versions), Azure SQL, SSAS, OLAP, SSIS, SSRS, SSDT, T-SQL, PL-SQL, ETL, UML, Query Analyzer, Report Builder, BIDS, XML
• C#, VB, Visual Studio, ASP.NET, ADO.NET, .NET Framework, Web Services, Web API, Entity Framework, WF, O/R Designer, JavaScript, Jscript, JSON, JQUERY, LINQ, WIF, AD, ADFS, HTML
• Microsoft Dynamics CRM 3, 4, 2011, 2013, 2015, 2016, D365, CRM SDK, xRM, Power BI, Power Apps, Team, Flow, Scribe, FetchXML

PROFESSIONAL EXPERIENCE:

Sr. Business Systems / Data Analyst Consultant

Confidential, Dover

Responsibilities:

• Consulting analyst supporting the State of Confidential Higher Education Offices Scholarship Application System. Services offered include supporting the integration and processing of federal student aid applications, changes to system rules, modifications to workflows, data transformations and performing updates to reporting services.

Sr. Business Systems / Data Analyst Consultant

Confidential, Columbia, Maryland

Responsibilities:

• Responsibilities included performing system and data analysis on Confidential 's Collateralized Debt Obligation ( Confidential ) reporting database and making recommendations to management for modernizations and enchantments.
• Validated all the nightly batch data imports from security rating agencies for integration into the Confidential system.
• Aided in modernizations and enchantments to database server objects and performed data transformations while insuring the integrity of existing data.

Sr. Business Systems / Data Analyst

Confidential, Dover, Confidential

Responsibilities:

• Interviewed solution providers and analyzed proposals in selecting an appropriate provider to create a department wide project in creating a central identity management portal for the departments 19k users.
• Created and documented all requirements while working closely with the selected vendor's development team.
• Communicated adjustments to constantly changing structures, processes and requirements to the department heads and director.
• Lead functional reviews, user acceptance testing, sign off sessions and assisted with data transformations.
• Lead analyst role in the development and implementation of a Dynamics CRM 2016 student relationship module for scholarship application and processing system for Confidential 's Higher Education Office.
• Automated the scholarship application process for students by providing self-service features such as account creation, enrollment registration and automated correspondence.
• Provided many features in this managed solution by creating custom entities, plug-ins and business process flows to automate scholarship processing based on student qualifications, award ranking, budgeting and reporting, thus significantly reducing the workload to process the thousands of scholarship applications annually.
• Performed data transformations from an old legacy system, and helped with data clean up.
• Lead the analysis and implementation of a web application that manages the departments reporting from all of the school districts to the federal government.
• Responsibilities included the orchestration and data integrity of the nearly 100 annual reports.
• The system organizes and automates all reporting specifications, email notifications for upcoming federal use dates, resulting in a compliance rate of over 99%.
• Maintained the data import automation and synchronization between external third party vendor systems and the departments data warehouse. Setup server nightly jobs to securely transport sensitive student data while staging, sanitizing and transforming data while preserving data integrity and providing accurate reporting data.
• Technical lead in producing the departments health dashboard. This overview report is maintained in real time for the Sectary of Education and provides a complete oversight of the health status of the Confidential . This dashboard report contained many performance analytics derived from many sources providing a complete performance overview of the department.
• Responsible for creating a secure standardized process when integrating all third party applications through the departments central identity portal. Worked with vendors to create authentication methods using advanced cryptography, role mappings and testing scenarios.

Sr. Dynamics CRM Analyst

Confidential, Baltimore, Maryland

Responsibilities:

• Managed the development and implementation of an customer relationship module created using the Dynamics CRM 4 platform.
• Gathered detailed requirements that defined the project, documented and created detailed models to validate business processes, ensuring development aligned with the original intentions. Lead all configuration and customization activities and communications of functional requirement reviews, approval, and sign-off sessions.
• Worked with stakeholders through user acceptance testing validating that the new platform performed as required.
• Lead in the development a new project tracking web application using C#, SQL Server and ASP.Net technologies.
• Application provided a centralized database of the 22k projects the department heads and project manager’s track for approval, status, and departmental sign-off.

C# Application Developer

Confidential, Annapolis, Maryland

Responsibilities:

• Developed scoring applications for Prometric testing and assessment services.
• Applications graded test results, reported results to user and administrator, encrypted and compressed data for secure transport to a database.
• Duties included analysis, design, and web services development.

Sr. Business Systems / Data Analyst

Confidential, Herndon, Virginia

Responsibilities:

• Performed system analysis providing a consistent user experience for FedTraveler.com. Lead all enhancement activities from gathering requirements, documentation, testing and implementation.
• Created models to validated business processes, designed and coded database server objects for consistency and data accuracy throughout the site.
• Lead the redesign and implementation of an integrated help system by implementing a vector based database structure providing ease of maintainability while reducing help desk calls by 50%.
• Worked with infrastructure team members to identify and eliminate vulnerabilities and security issues, enabling this system to obtain federal authority to operate (ATO).

Financial Database Analyst

Confidential, Baltimore, Maryland

Responsibilities:

• Modernized existing financial systems and performed seamless implementation for 135 users.
• This SQL Server database included ADO communication technologies, active directory services objects used to create a security schema that utilized windows authentication to provide encapsulation and reporting across divisional-departmental metrics for 500 accounts and budgets.
• Streamlined processes for critical workflows including statement processing, grants, expense reconciliation, and income projections.
• Initiated and implemented the development of a budget based project tracking system, which provided the end-users the ability to create, configure and track custom tasks without the need for additional software.
• Lead the re-architecture and financial system integration of a stand-alone proprietary payroll system.
• Enchantments provided a more efficient and cost effective payroll system.
• Created a service-bus model to interface with multiple systems to derive a secure data abstraction of 3,500 annual salary records while maintaining the upmost level of security.