Manager Of Reporting & Analytics - (business Intelligence) Resume
Meriden, CT
SUMMARY:
- Experienced Business Analyst , Manager and certified SharePoint develop er . Helping companies realize the value of their data through analytics.
- Creative and resourceful troubleshooter with strong attention to detail.
- Self - directed professional who effectively prioritizes and executes tasks in high-pressure, fast-paced environment while providing exceptional customer service.
- Utilize analytical skills to perform complex business analysis .
- Stays abreast of new ideas and technologies.
- Develops and maintains strong relationships and communicates to cross-functional business units, skill sets and cultures to accomplish organizational goals.
- Certified in Microsoft SharePoint Server 2013 Core Solutions and Google Analytics.
- Over 20 years of experience in IT & Project Management combined.
- Extensive IT Background.
- Familiar with Waterfall & Agile methodologies.
- High degree of technical aptitude .
- Rock solid results driven work ethic.
SKILL:
SharePoint, Office 365, Visual Basic, SQL, MS SQL Server, InfoPath, Nintex, SSRS, Power BI, GIT, Visual Studio Team Services (VSTS), ETL, MSP, JIRA, Windows 10, MS Project, SAP, BPCS, Access, Visio, HTML
PROFESSIONAL EXPERIENCE:
Confidential, Meriden, CT
Manager of Reporting & Analytics - (Business Intelligence)
Responsibilities:
- Established and Managed a team of SQL Reporting Analysts. Business Intelligence Development. SSRS & Power BI.
- Facilitated status meetings with the business stakeholders on IS Request progress and report prioritizations.
- Lead development of all reports & dashboards including development of subservicing reporting for clients.
- Responsible for NMLS and state regulatory reporting deadlines and state/investor audit requests.
- QA all reports and request deployment to production, SharePoint admin, created all sites for Project Management.
- Met with Subservicing clients/investors to understand their individual reporting needs.
- Engage in quarterly strategic meetings to focus on future goals and objectives. Implemented and reported on SLA’s.
Confidential, Meriden, CT
Business Systems Analyst
Responsibilities:
- Liaison between internal business partners & IT Department. Created data mapping from MSP to SIME system.
- Lead team of off shore developers. Requested new servers and FTP requests be configured and deployed.
- Integrated Five9 phone systems with borrower data. Created ETL data feeds.
- Managed multiple projects and assignments with high degree of complexity and short deadlines.
- SharePoint admin, created all sites for Project Management. Developed Ad-Hoc reporting and trained business.
- Ensured all systems, processes and reports were performing as expected and tuned for optimal performance.
Confidential, Sandy Hook, CT
SharePoint Developer / Business Analyst
Responsibilities:
- Met with clients to collect scope of work and create Statement of Work (SOW) with itemized project costs.
- Microsoft Office 365 administration including creating user accounts, purchasing licenses & SharePoint admin center.
- Installed & Configure SharePoint Server 2013 On Premise on Windows Server 2012 R2.
- Managed MetaVis for SharePoint to scheduled site backups, perform site development, reporting and restores.
- Created custom workflows via SharePoint Designer, Nintex and Visio.
- Created custom InfoPath forms (advanced) and apps. Managed Client Servers.
- Researched apps and 3’rd party software to fit client needs. Assisted clients via Team Viewer remote desktop.
Confidential, Stratford, CT
Business Analyst / SharePoint Developer
Responsibilities:
- Developed International Trade Compliance and Export Control Reform SharePoint sites and workflows.
- Improved site functionality and developed reporting modules for departmental use and executive reporting.
- Integrated MS InfoPath forms and custom lists into SharePoint sites.
- Defined and improved data content management processes and workflows.
Confidential, North Haven, CT
Project Management Office - Resource Specialist / Business Analyst
Responsibilities:
- Developed and maintained Office of Project Management departmental and public SharePoint sites.
- Implemented PMO SharePoint site master template for all new project teams to utilize.
- Created a vast knowledge base of SOPs, lessons learned and structured standardization in all existing project sites.
- Developed PMO Project Scorecards for core team member ratings, enabling management to hold core team members accountable for their actions and associate work habits with employee reviews.
- Improved new product development time to market, predictability and profitability by effectively managing staffing models.
Confidential, Norwalk, CT
Business Systems Analyst / SharePoint Developer
Responsibilities:
- Developed and designed SharePoint sites
- Designed and administered public portal and private sites servicing approximately 34,000 end users.
- Central point of contact for SharePoint site development.
- Met with various departments to establish and translate software requirements into IS business solutions.
- Trained users on updating and managing SharePoint sites to conform to best business practice.
- Created and maintained 100+ SharePoint private team sites and 20+ SharePoint public sites.
- Developed and modified SQL Scripts, Korn Shells, and Oracle code.
- Monitored, built, and modified relational databases, schemas, and data views.
- Fixed scheduled SQL batch jobs and provided 24/7 support.
- Collaborated closely with Sales Operations and Senior Management to understand sales force needs, providing them with custom SFA applications such as Saratoga CRM that increased cost savings and improved overall efficiencies.
- Extracted data from Cognos and created custom Apresta Reports, providing senior management with product sales dollars and forecasts of global sales trends. Attended national sales meetings, trained sales force with the latest tools.
- Create custom SharePoint security groups and assign appropriate site permissions.
Confidential, Norwalk, CT
Helpdesk Supervisor
Responsibilities:
- Served as Core Team Member of Operational Excellence Helpdesk Standardization team - Six Sigma Tyco Initiative, standardizing work orders and improving on overall associated costs.
- Ensured all users were upgraded to a standardized Microsoft operating system and SFA tools by assisting in the OS upgrade of more than 500 laptops in a 6 week project span. Perform computer audits.
- Delegated IP addresses. Analyzed and reported on call metrics reports. Approved hardware and software requests.