PROFESSIONAL EXPERIENCE

Confidential - FREEMONT, MI

Responsibilities:

• PM Office Business Analyst working 5 Insurance Industry Enterprise projects for Product, Reporting and Infrastructure enhancements; Waterfall method and maintenance of documentation of Scope, Requirements, Project Schedule, and other Artifacts for all projects
• Analyze Business needs for Product development, Cash Value updates, and Cognos reporting and provide mapping and business requirements for same
• Collaboration wif many business units on projects including Agency, Accounting, Contact Center, Marketing, Training and Development, Underwriting, Finance, and outside vendors as well
• Manage projects in Microsoft Teams including communication and common shared files and testing plans
• Web based and mobile marketing requirements development and mocks for use in Enterprise sites
• Status meetings and Team meetings for all projects; Team, Product, Marketing and Compliance Status updates weekly, bi-weekly and monthly
• Use of Mainframe environment for testing and program review of Insurance accounts and profiles
• Use of JIRA for project work as well as Smart Bear for ticketing and project assignments wif development

Confidential - GRAND RAPIDS, MI

Business Systems Analyst

Responsibilities:

• SAFe 5.0 Scaled Agile team member on Oracle Apex Upgrade Team
• Completed all business and systems analysis for over 100 Apex built applications to ensure smooth migration from Oracle 5.0 servers to Oracle 19c servers.
• Daily standup participant in JIRA based scrum meetings for all project work and completed all story cards in assigned sprints.
• Authored Apex upgrade strategy and process artifact to be maintained for next Apex system upgrade.
• Updated and maintained internal system WIKI documentation for all Apex applications.
• Collaborated wif DBA and QA for all migration testing through DEV, TEST and PROD environments and coordinated all UAT testing for business customers by maintaining and reusing consistent communication.
• Transitioned and mapped all Apex configuration items from Service Desk CMDB to Service Now CMDB during upgrade timeframe.

Confidential - WOBURN, MA

Senior Business Analyst

Responsibilities:

• Collaborated wif key business units, Accounting and Data Services, for NetSuite Integration project and Data Warehouse Architecture initiative.
• Worked directly wif Program Manager to deliver on immediate and long term goals, including requirements gathering, documentation, and project timeline updates. Collaborated wif Off-Shore development daily.
• Led team wif project planning in Azure DevOps sprint cycles to build a new Warehouse environment for processing acquisition data. Related and mapped acquisition raw file data at account and address level (KPI) to systems including: Salesforce CPQ, Total Recall, Apex, Basware and other systems in preparation for NetSuite integration.
• Participated in twice weekly standups for both Development Team and Data Services teams for current and future sprint planning. Integrated team work daily in Microsoft Teams and coordinated wif Global
• Completed SQL analysis and data validation of current to proposed solutions daily, and prepared functional requirements documentation and testing validation documentation for development team.

Confidential - ANDOVER, MA

Senior Business Analyst, Marketing

Responsibilities:

• In charge of business analysis, requirements gathering, documentation, UAT testing and overall project management efforts for the Marketing Team and their internal web portal development and its connections to an external Insurance Industry premium and billing platform.
• Daily and weekly JIRA SCRUM planning for benefit of Marketing team’s development prioritization wif the Product Owner. Worked directly wif Product Owner and Development team weekly and participated in all JIRA Scrum team retrospective and sprint backlog grooming.
• Project Team member for Company’s external customer facing mobile app development and requirements gathering and documenting. Team work also included following up on needed production changes to Company’s external website and internal web portal which connected customer-initiated changes to internal operational sites.
• Prepared quarterly and ad-hoc Tableau reports for all Marketing staff, including senior management staff for Board Meetings.
• Worked collaboratively wif external development vendor to enhance Tableau Reporting dashboard for Marketing and convert legacy reports into Tableau and validate the results for production ready use.
• Utilize software as a solution to establish a best practices SharePoint 2013 initiated requirements gathering wif various senior members of Compliance.
• Designed and documented a Compliance Product Manager solution for reoccurring compliance matters. Gathered requirements from Compliance Stakeholders to collaborate and reduce manual intervention and email loops in mandatory regulatory matters for the company.
• Worked wif Development Team, and designed solutions for Compliance initiatives including standardizing on SharePoint search sites for previously Shared Network, reoccurring content.
• Active JIRA SCRUM team member and daily KanBan standups. Agile planning, retrospective meetings and backlog grooming was accomplished through use of JIRA.

Confidential - MANCHESTER, NH

Senior Business Analyst

Responsibilities:

• Delivered on process development for all Business Analysts at the company. Completed assignment to develop consistent, reusable project documentation, and developed a SharePoint site for all project content, templates and PMO guidelines.
• Provided Sr. BA resource for the company’s Operations Work Stream - Data Management Initiative and delivered on process flow diagrams, business and functional specifications, and documentation of integrated data elements across many of the Company’s business needs to improve the data architecture and operational data store.
• Active SCRUM team member and weekly PMO meeting updates provided. Worked on several projects in tandem for both the PMO and smaller initiatives for business reporting.
• Collaborated wif a developer to enable TFS to be used as agile planning project tool to manage smaller projects opened through the company’s issue tracking system. Developer and I collaborated on an end of day script process to feed TFS from the issue tracking system to automate on agreed upon attributes, the setup of smaller projects in TFS for better planning and transparency.
• Utilize SQL analysis daily for source to target documentation and analysis of Oracle schemas for purpose of delivery of targeted marketing data in the TELCO/Insurance business segment currently.
• Integrate development releases, QA testing and for several internal built systems and reporting needs across various enterprise tools.
• Project collaboration wif other teams throughout the company, both in the United States and offshore, for complete end to end implementation of client development needs.
• Combined use of TOAD, Oracle SQL Developer, Microsoft Developer Studio, and Share Point for project work. Collaborated wif Off-Shore Development daily.
• Daily and weekly SCRUM meetings wif Project Team using Microsoft TFS and SharePoint for Agile framework.

Confidential - BOSTON, MA

Senior Business Systems Analyst

Responsibilities:

• CRD: Both front end and database back end analysis of CRD was ongoing project to assist the database developer wif updates to ETL processes for the enterprise, ACH, pricing, Bloomberg, data loading and many mid-office processes.
• Several PACE Initiatives: Requirements gathering and documentation of functional specs in support of the enterprise’s implementation of the Eagle PACE ODS. Analyzed security master, position, lot level, pricing and lot level data daily for hand off to developers of ETL processes.
• Integrated trade data meanings and governance steps through field level analysis of trade /security data from outside sources (State Street, Mellon, Bloomberg, JJ Kenny, and others ). 
• Callidus Software Integration: Project /BA lead for compensation system project dat migrated company from Excel driven approach to software solution in under 6 months. Company still using today. Organized and documented requirements from stakeholders across the enterprise in initiation phase of a project to automate the enterprise’s spreadsheet driven compensation system. Analysis was complex and involved both percentage calculations for enterprise sales and salaries of non-sales employees. Sales based compensation analysis on all mutual funds, separately managed accounts, and other sales. Worked wif an assigned developer throughout the project, which completed successfully wif install of recommended (through RFP process) software solution.
• SharePoint Projects: Developed a Microsoft Share Point WIKI site for operational support of all overnight scheduled processes. Coordinated same wif the enterprise’s western U.S. affiliate operations group, their developers and trading desks in Seattle at Parametric. Built, maintained and provided documentation for SharePoint site used by Overnight IT Shift Operations team in running overnight triage process for all scheduler jobs and Operational, Network and Server related monitoring needs.
• Remedy and CA Scheduler and Asset Management: Coordinated SDLC work through Remedy implementation and its upgrades, including adding on to the Asset Management configuration wif asset tagging electronically. BA SME and Lead resource for all project work involving CA scheduler and interfaces wif ETL platform. Championed the approved, company- wide standard scheduler job naming convention, including priority coding, for best overnight support response.

TECHNICAL SKILLS

• TABLEAU
• AZURE DEVOPS
• JIRA Scrum
• SAFe SCALED AGILE
• TFS
• APEX
• SHAREPOINT
• SQL
• EXCEL
• WORD
• VISIO
• DRAWIO
• ETL
• CA SCHEDULER
• CLARITY
• SALESFORCE CPQ USER
• GUIDEWIRE
• BMC REMEDY
• SERVICE NOW