Senior Technical Consultant/business Analyst Resume
Edison, NJ
SUMMARY:
- An Impactful Business Analyst with Extensive Experience Working with a Wide Variety of Platforms, Software Solutions and Clients in Varied Environments.
- A Business Analyst with a strong career of successful solution - driven projects delivered through multifaceted efforts and achieving innovative operational results. Experienced with challenging initiatives, leading cross-functional teams, well versed in documentation, development, and design, delivering business solutions through the use of Agile and other methodologies. of business goals through thorough evaluation and analysis, critical path solutioning, user-centered design and development, team coordination, review of requirements, both functional and non-functional, and user acceptance testing to implement and transform company platforms or systems into leading edge, cost-effective, and efficient solutions.
- An exceptional change-agent using focused business analysis, effective sprint planning, analysis of process & procedures, evaluation of roles, and time management to achieve cost efficiencies and higher team productivity. Extensive experience in implementation and integration of information systems, systems transformation, data migration, and solution development. A proven ability to manage, train and develop staff, act as product owner by a detailed understanding of project goals.
- Implemented and chaired Business Process & Operational Improvement Teams; post mortem reviews.
- Supervised multiple platform implementations, upgrades, and system and software integrations of claims, financial, T&E, legal time & billing, HR and reporting systems GAAP and Statutory. Effective rollouts of the software packages, premium and income tax processing applications, ledger and budget reporting, resulting in reductions in annual expenses through the use of Agile, waterfall & hybrid methodologies.
- Strong knowledge of Statutory Principles, regulatory compliance, reporting and ACORD Standards.
- Extensive experience in finance & accounting operations, reporting and compliance.
- Strong use of reporting tools; FRx, Cognos, Hyperion, MS Reporting & SSRS among others.
- Effective interrelationship, communication, and management of offshore teams.
- Implemented more effective data gathering and reporting procedures, improving the visibility of loss ratios.
- Implementation of policies and procedures; hiring and of staff.
- Creation of executive& management reports and executive dashboard analytics utilizing data warehouse, cubes, and business intelligence gathering platforms and processes and report distribution by use of SharePoint.
- Selection/implementation of insurance accounting & reporting systems.
- Creation of or harmonization of general ledger charts of accounts across entities.
- Calculation procedures of Risk-Based Capital to resolve RBC deficiencies to comply with DOI/OIR.
- Strategic planning & modeling, merger & acquisition; due diligence for M&A, IPO’s and divestitures.
- Movement from third-party SEC & Statutory reporting to in-house operations for control/cost reduction.
- Creation of new premium and claims, salvage and subro, FNOL, IBNR monitoring process and procedures along with new recording & reporting processes and practices for claims reinsurance bordereaux.
- Facilitated reduction in the monthly and quarter-end close from 22+ days to 2.5 days, including budget analysis as a result of collaboration with finance, I.T., actuary, claims, claim legal, internal audit, compliance, subrogation/salvage, human resources and underwriting through integration & enhancement of systems.
- Obtained primary underwriting capital; negotiated repayment contract terms for P&C underwriters.
- Member of Sarbanes-Oxley Steering Committee; CoBIT and COSO.
TECHNICAL SKILLS:
Technology and Tools: Stone River Pro Financial QuickBooks Pro & Enterprise MAS90/SAGE 100/FAS Lawson Financial Software SunGard Financial Suite EagleTM (Statutory Reporting) FRx& GP/MS Reporting Team Room Agile SW PremiumPro (Premium Tax) IBM - AS/400, CSC/PMSC MS Office Suite Premium The Complete Package/TCP (Statutory Reporting) Cognos Reporting/Planning SharePoint Oracle Siebel CRM Power BI XL & XML Reporting MS SQL Server/Database HP Quality Assurance Guidewire OneShield SEC Edgar Filing Software Jira Hyperion
PROFESSIONAL EXPERIENCE:
Confidential, Edison, NJ
Senior Technical Consultant/Business Analyst
Responsibilities:
- Interfaced with client staff and stakeholders to develop and design a new solution, scrum sessions, to user stories, design and evaluate product wireframe and POC version. Teamed with developers, client, and UAT to design and develop a new solution in an Agile atmosphere for implementation/integration into the current platform.
- Coordinate with client offshore, ACORD offshore, technical architecture, and Standards teams. Utilizing ACORD P&C and L&A Standards as a source point. Creation of BRD, FRD, review of US & UK BA staff documentation. Worked with junior permanent BA staff through oversight of their projects assist with the development of procedures, best practices, effective analysis approach, writing use cases, user stories, epics, and designing better flow-charts, use of power-point, and use of Jira. Reviewed with Standards Group the next evolution of ACORD Standards prior to release since they were utilized for the Benefitfocus project.
Confidential, San Antonio, TX
Responsibilities:
- Systems involved, Dynamics AX w/SharePoint, Lawson, EDI, and other integrated industry systems.
Confidential, Reston, VA & Oak Ridge, TN
Business Analyst, Finance Operations Integration Project
Responsibilities:
- Analysis of current state to develop future state of systems: finance/accounting, reporting process, and procedures including integration of systems and personnel resource allocation and additions/reductions. Creation of documentation, gathering of information to assist I.T./I.S. project planning, and facilitate mergers future finance/accounting & operational structure post-merger.
Confidential, Ft. Lauderdale, FL
Business & Financial Operations Analyst
Responsibilities:
- In cooperation with each cost-center owner to analyze budget & forecast by month/quarter/annual for corporate directors & senior management. Create, update accruals for each cost-center; assets, headcount travel, and expenses. Analysis of FTE’s, consulting, external support, outside services verifying, calculating expenses or proposed changes and projects in preparation for the review of year-end, and GoToMeeting divestiture.
- Use of SAP, Ariba, Hyperion, Aptivo to collect data, analyze budget to actual for changes.
Confidential, Tampa, FL & New York, NY
Business Analyst/Reporting Consultan t
Responsibilities:
- Design/redesign of each countries data schema, transforming from local to US Statutory requirements.
- Use of macros through VBA to enhance routine function for analytics and analysis.
- Creation of analytics model for each entity/country for transfer to distribution and review via SharePoint.
- Authoring & Chart Creation via Cognos; Data Mining & Analysis through the corporate data warehouse.
- Data extraction for bordereau reporting to reinsurance partners.
Confidential, Boca Raton, FL
Financial Business Analyst
Responsibilities:
- Provide data for Receiver, external auditors for prior year accounting, audit, and tax.
- Provided claims status and surplus review.
- Creation of Macros to assist staff with routine tasks for future data analytic analysis and reporting.
Confidential, Washington, DC
Business & Data Analyst - P&C: personal and commercial
Responsibilities:
- Designed new and redesign of existing financial reports and harmonization layout of the general ledger.
- Perform Business Analyst activities for process and procedures; creation of reports into Excel by SQL data pulls and through VBA to automate tasks.
- Prepared documentation to assist the transition of an external data warehouse development team.
Confidential, Jacksonville, FL
Interim Vice President of Operations & Project Management
Responsibilities:
- Startup consulting organization dedicated to the EHR/EMR space to deliver seamless end-to-end Electronic Health Record (EHR) or Electronic Medical Record (EMR) implementation and support services. The PremEHR Solutions process results in confident EHR software selection, configuration,, and support. PremEHR serves medical, health and wellness practices from sole practitioner to multi-specialty/multi-physician to hospitals, nationwide. Designed and deployed customized, comprehensive solutions providing a painless, worry-free transition to EMR/EHR environments.
Confidential, Jacksonville, FL
Senior Business Analyst - P&C: personal & commercial lines
Responsibilities:
- Conducted interviews and JAD/Agile sessions with stakeholders to understand and collect requirements.
- Documented requirements for upload to Team Room for tracking and cross verification.
- Worked as a liaison between business and IT teams to convey expectations and provide clarifications on what is needed and what can be achieved from the technology perspective.
- Analyze UAT plan to clarify acceptance criteria for QA leads, and inform developers of expected end results.
- Used Quality Center for defect reporting and tracking as needed. Ensure the defects are retested and accurately reported for rework.
- Worked with Business Process Operations Group to realign the organization, primary focus on underwriting, claims, and finance/accounting infrastructure and policy administration systems.
Confidential, Miami, FL
Senior Business Analyst - Healthcare
Responsibilities:
- Underwriting transformation analysis with the Integrated Service Teams to support the BUPA-LA Customer Journey project to enhance customer service process from initial contact with potential insureds to underwriting leading to recommended road-map of metrics and best practices ensuring the quality of service utilizing the SCRUM methodology. The overall analysis includes intake underwriting, medical evaluations, policy issuance & changes, claims, complaints, appeals, and systematic enhancements.
Confidential, Richmond, VA
Business Analyst - Subject Matter Expert - P&C: personal, commercial, niche, specialties
Responsibilities:
- A property/causality (P&C) insurer specializing in excess and surplus insurance lines (E&S) insurance coverage for higher-risk individuals and businesses with niche personal and commercial products lines.
- Development of project goals through the use of IBM tools and Agile methodology; monitoring through HP Quality Assurance to the transformation of various data sources into a data warehouse to be utilized by the new Lawson platform.
Confidential, Davie, FL
Interim Chief Financial Officer - P&C: commercial
Responsibilities:
- Obtained primary underwriting capital, negotiated repayment terms, securing of Authority.
- Implementation of the general ledger, cash management, and claims.
- Participation in negotiation, monitoring, and analysis of reinsurance treaties.
- Creation of general ledger chart of accounts and reporting procedures.
Confidential, Hollywood, FL
Interim Chief Financial Officer - P&C: personal, commercial, specialties
Responsibilities:
- Resolved deficient Risk-Based Capital and the third party claims administration billings issues.
- Resolved claims billing inefficiencies, errors from a third-party administrator.
- Created new premium evaluation, forecasting and reporting processes, and practices.
- Implemented the full suite of SunGard for general ledger, cash management, and claims.
- Negotiated, monitored and analyzed re-insurance treaties.
Confidential, Doral, FL
Interim Controller - P&C: personal
Responsibilities:
- Selection and implementation of new accounting & reporting systems; creation of chart of accounts.
- Managed movement from third-party claims vendor to in-house claims operations.
- Integration of take-out policies to subsidiary database and ledger.
- Implementation of SunGard general ledger, policy administration, cash management, and reporting.
- Creation and Implementation of policies and procedures for an eventual IPO.
Confidential, Doral, FL
Financial/Business Analyst - Consumer Electronics
Responsibilities:
- Performed analysis of supply chain/in-transit/on-the-water inventory & financial review of each shipment from port to port for LATAM division. Developed as is/to be plan, adjust process & procedures, develop and manage the project plan for new ERP software implementation for LATAM office.
Confidential, Miami, FL
Chief Financial Officer - Private Equity Syndicate
Responsibilities:
- Improved operating income from $400K to $1.1M through improved FP&A processes.
Confidential, Davie, FL
Director - Finance & Accounting Operations - P&C: personal & commercial
Responsibilities:
- Implemented and chaired the Business Process Improvement Team.
- Supervised platform upgrade of financial systems, financial reporting software, both GAAP and Statutory, and rollout of a new financial planning and analysis reporting package, premium and income tax process and applications resulting in a reduction of annual expenses by $380K.
- Identified under-reserving of potential claim loss of 8% through in-depth analysis of historical data, mitigating the potential negative impact on surplus and rate making through the use of data warehouse mining.
- Owned, and acted as SQL DBA for the finance, accounting, reinsurance, and treasury group.
- Reduced month- and quarter-end close from 22+ days to 2.5 days, including budget analysis as a result of collaboration with I.T./I.S., claims, underwriting, claims legal and salvage & subrogation through integration and enhancement of systems.
- Brought SEC EDGAR reporting & filings in-house, resulting in a savings of $100K per year.
- Resolved $10M accounts payable aging reconciliation error identified by the external auditor by data analysis.
- Reduced epartmental expenses by 12% through automation.
- Extracted of formulated data to re-create 4 yrs for 443 FTEs for two class-action lawsuits in excess of $35M.
- Implemented automated software enhancements for routine data processes, resulting in increased efficiencies across underwriting, finance, actuary, legal and claims reducing expenses by $3M per annum.
- Reduction of T&E reimbursement pays cycle by 24 days through the implementation of Concur software.
Confidential, Naples, FL/Boston, MA
Assistant Vice President Operations & Sr. Project Manager - Consumer Electronics
Responsibilities:
- Facilitated integration of sales, manufacturing and finance operations in the U.S., Europe and Japan for the newly acquired company. Led the implementation and integration of new financial systems. SEC financial reporting, budget applications, forecasting and MRP process & procedures including sales-use tax reporting. Performed business process analysis and UAT; developed project plans, end-user workflow, and diagrams. Directed EDI implementation with trading partners, reducing expense and increasing sales revenue. Acted as SQL DBA.
Confidential, San Francisco, CA/Minneapolis, MN/New York, NY
Business Analyst, Finance Project Manager
Responsibilities:
- Provided professional consulting services to insurance clients for finance, underwriting, claims, operations, reporting to include SEC/IFRS/Statutory. Implementation, data migration, enhancement, integration of systems;g re-engineering and upgrades of current systems varying from start-ups to large corporations. Implementation of data warehouses for single source data reporting.
- Client areas: insurance-P&C, L&A, Health, individual, commercial and niche, annuity, indemnity, investment.
Confidential, Minneapolis, MN
Team Leader
Responsibilities:
- Provided leadership for an investment transaction team recording and reconciling institutional client transactions.