SUMMARY

• As a result, driven strategic Microsoft Business Intelligence reports developer, I have been successful in bringing people together for business discovery through storytelling, capturing business requirements, assisting in the development of business planning around process improvement with documentation and reporting services balanced with compliance monitoring.
• As a creative and innovative outside the box thinker, I would be delighted to assist with your report development projects, data lineage analysis, technical writing (documentation, process flows, procedures), data modeling, data governance, and identifying process improvement and controls.
• Along with providing reporting and monitoring of business processes, systems, portfolios, supply chain, workflow streams, I can extend it to cost analysis, risk and root cause analysis, process/system deficiency reviews, volatility/trend to loss analysis with operational and compliance risk management/oversight.

TECHNICAL SKILLS

• Microsoft BI Analytics
• SQL Server Management Studio
• Teradata, DB2
• Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables
• BI Tools: SSIS/ SSRS/ SSAS
• Microsoft PowerBI
• DAX/MDX/ UX Design
• Microsoft Power Apps
• Microsoft Excel/ PowerPoint/ Sharepoint
• Tableau/ SAS/Visio
• Waterfall/AgileScrum
• Sharepoint/ ITIL/
• JIRA/ ServiceNow
• HTML/Java/Python
• Microsoft Azure

PROFESSIONAL EXPERIENCE

Consultant /SQL Server Migration & PowerBI/ PowerApps Developer

Confidential

Responsibilities:

• Gathered business requirements, designed, and implemented a PowerBI dev, test, and production workspace along with version control.
• Create a test environment to test database migration and transformations prior to production implementation.
• Initiated the setup of the creation of Active Directory User Groups to compliment workspaces and row level security as needed.
• Utilized SSAS to create cubes using data from data marts/data warehouse.
• Initiated the installation of an on premise data gateway for the appropriate server.
• Initiated the setup of PowerBI subscriptions and cloud service.
• Provided end user mentoring in regards to PowerBI Desktop and PowerBI Service.
• Developed SSAS cubes to store data for analysis
• Involved in deployment activities of SSIS packages.
• Designed several parameterized reports, linked reports, sub reports, drill through reports using SSRS.
• Created SSIS packages to lookup data from Client files and the database tables and update the changes accordingly in the database.
• Created Data driven Tabular, Drill-down, Charts, Parameterized, Linked, Aggregate reports using SSRS Report Builder.

Consultant /Microsoft BI Reports Developer

Confidential

Responsibilities:

• Gathered business requirements, designed, and implemented process improvement for reports and department dashboards.
• Aided with the creation of technical (BRD/FSD/PSD/SRS) and end user documentation
• Responsible for creating reports to monitor risk and controls for reverse mortgage operations around operational process improvement.
• Provided Troubleshooting, debugging and and refactoring of programming code
• Created reverse mortgage dashboards and reports with Microsoft Excel, Microsoft Power BI, Microsoft PowerApps, Microsoft PowerPoint, SSRS, and Microsoft SharePoint.
• Captured 6 months of daily snapshots inside a MS Access database to track movement of accounts and rate of volatility.
• Created a MS Access tool to assist with updating records to Sharepoint that controlled the mapping of all updates and applicable tables.
• Created a report that assisted with a data refresh and VBA to assist with document search on a specific network directory capturing the file name and root location.
• Created an excel tool that allowed the end user to supply inputs that would be utilized as an array for a sql statement to create a temp table. The temp table was utilized to finish the sql search of the specific array. Designed for end users to implement their own independent searches.
• Created an anomalies report to assist with targeted initiatives around meeting timelines and process improvement.
• Updated and refactored SQL Server reporting and stored procedures.

Compliance Auditor/Microsoft BI Reports Developer

Confidential

Responsibilities:

• Gathered business requirements, designed, and implemented compliance monitoring reports.
• Responsible for creating reports to monitor risk and controls for servicing operations around regulatory, investor requirements, and operational risk points.
• Provided assistance with the creation of technical (BRD/FSD/PSD/SRS) and end user documentation
• Updated and refactored SQL Server reporting and stored procedures.
• Provided Troubleshooting, debugging and and refactoring of programming code
• Worked with IT, Legal, Finance, Compliance, Operational, Investor Relations and third-party resources as required.
• Carried out comprehensive business analysis to identify system requirements and improvements.
• Developed testing procedures, processed rebuttals, identified missing controls to build out automated processes. Compliance revolved around RegAB, RegX, and CFPB requirements. Experience with FHA, VA, FHLMC, FNMA, GNMA, HUD and MHA servicing requirements and guidelines.
• Created default performance reports and dashboards via Microsoft Excel, Microsoft Power BI, Microsoft PowerApps, Tableau, Microsoft PowerPoint, SSRS, and Microsoft SharePoint.
• Improved the auditing code for default reporting and provide visibility of root cause analysis to monitor specific risks.
• Built out an auditing tool for default reporting and investor reporting to double check reconciliations.

Business Operations/ Microsoft BI Reports Developer

Confidential

Responsibilities:

• Built and automated daily, weekly, and monthly reports for multiple management teams. Data sources came from a variety of SQL Server databases, MS Access databases, & 3rd Party websites. Reports revolved around performance and trends full of tables, charts, pivot tables and dashboards.
• Aided with the creation of technical (BRD/FSD/PSD/SRS) and end user documentation
• Provided Troubleshooting, debugging and and refactoring of programming code
• Updated and refactored SQL Server reporting and stored procedures.
• Worked with IT, Legal, Finance, Compliance, Operational, and third-party resources as required.
• Executed Systems and Business Analysis of various Applications.
• Gathered business requirements, designed, and implemented business process.
• Developed solutions to support business objectives and forecasting.
• Evaluated technology solutions and presented recommendations for improved system operations.
• Experienced in residential mortgage servicing in the following areas: Call Center, Loss Mitigation workouts (HAMP), Short sales /Deed in Lieu, Bankruptcy, and Foreclosures for all investor types. Executed MHA program reporting to the US Dept. of Treasury. Supported the Collateral department with mortgage compliance monitoring, auditing and examination.
• Created a variety of performance reports and dashboards via Microsoft Excel, Microsoft Power BI, Microsoft PowerApps, Microsoft PowerPoint, SSRS and Microsoft SharePoint.
• Generated reporting for Loss Mitigation, Default and Investor Reporting
• Created a MS Access tool to capture rebuttals, recommended controls, and corrective action for internal findings regarding letter generation process.
• Created an excel spreadsheet that automated the generation of 40 letters by executing VBA to run scripts and linking the data back to the excel sheet with a data connection and then executed the letter generation with a button to execute the opening a Microsoft Word letter template and programmed to pull from a specific excel sheet and then converting the mail merge automatically and storing into a designated folder. The data utilized for letter generation was linked to a MS Access database and assist with updating a legacy system with outgoing letter codes and dates and description details.