Summary
Overview
Work History
Education
Skills
Certification
Projects
Timeline
Generic

Sneha Pariawala

Cary

Summary

Results-driven Security Analytics Senior Specialist at MetLife with expertise in data modeling and process automation. Achieved over 50% efficiency improvement through automation using PowerShell and Python. Proven analytical problem-solving skills, delivering impactful Power BI metrics and enhancing reporting processes. Recognized for contributions to financial reporting and team collaboration.

Overview

16
16
years of professional experience
1
1
Certification

Work History

Security Analytics Senior Specialist

MetLife
Cary
04.2022 - Current
  • Created key Power BI Metrics for tracking security posture, tool coverage, and vulnerabilities.
  • Automated more than fifty data extraction with PowerShell and Python scripts using various APIs protocols, which increased process efficiency by more than 50%.
  • Developed complex data models by integrating and normalizing data from multiple sources.
  • Set up Scheduling server and Script Migration: Set up a new scheduling server with Maestro, including PowerShell and Python modules. Secured CyberArk access to connect using a functional account. Migrated and scheduled 110 scripts from the old server to the new one via Maestro.
  • Java Remediation: Built Power BI visual to track and view open Java; saving 400 hours of manual effort.
  • Data Extraction using API & automation via PowerShell: Huge process improvement, increased efficiency by more than 25%, total 70 Reports automated via API. Working with DBA to load data from Tools to SQL DB to centralize all data in single source.

Financial Consultant

MetLife
Bridgewater
01.2014 - 03.2022
  • Accountable for the review and maintenance and updates for more than 150 controller financial reports: Adjusted Earnings, Balance Sheet, Earning by Source, Net Investment Income, Metrics, Total Adjusted Capital, GAAP vs STAT Walk, Latam Constant Rate Reports, Trend Report, QFS Supports, Schedule E, GAAP & STAT Analytics, Ledger- sub-ledger Reconciliation for Audit and Ad-hoc Reporting as per request.
  • Process Improvement and Automation: Standardized & automated dated reporting processes using technical (Power BI, Excel VBA macro, Access, Power Query) & analytical skills.
  • Automated Refresh and Rollover process using Excel VBA macro.
  • Reduced run time by 50%, increased in productivity and efficiency.
  • Single data source using Advance Excel, Power Query & Power BI Reports: Gathered data from multiple sources - Actuals (GAAP- HFM and STAT - Essbase), Plan and Projection for each segment and LEs) and created single clean data source using Power Query and DAX functions, which is an excellent master database for trend, YOY and Sequential, Actuals vs Projection and Actuals vs plan analysis.
  • Developed and built Relational Data Modelling in Power Pivot and Power BI and designed interactive drill though Reports using slicer and Metrix.
  • MS Access and SQL Queries: Aggregate data from different admin systems to provide cash reconciliation among admin systems and ledger, requested by NYQ Auditor.
  • Built Master database using SQL Query (Append, Full Outer JOIN) and created reconciliation Queries (LEFT JOIN eGL vs Sub-Ledgers) for Audit.
  • Constructed Command Button that run a query using criteria entered in a form field, by source code and period.
  • RBC Certification process: RBC Certification is MS Access database, which soured data from difference files found on drive, prepare PDF, and send that PDF to respective certifier to approve before deadline. I helped this team to solve technical issue when queries stopped working due to technical upgrade and change in source file mapping and helped to identify windows authorization issue and since then, assigned as technical contact for this database.
  • Knowledge of wide ranges of Insurance products for Group Life, Group Health, Retail, Retirement Income Solutions & P&C Segments.
  • Constant Currency Reports- Build & refresh Constant Rate Report for Latin America controller which converts all Local Currency into USD at Constant rate and help to analyze actual variance without FX impact.
  • Technical supports: Assist customer and other reporting team member with macro or query help.
  • Leadership: Successfully transitioned automated refresh process to Junior Analyst & GOSC (India team) and review & guide them if any issue or questions.
  • Actively involved in CFO APP Process (Projection process) and Project First which aim towards single source for all data (Actuals, projection, and plan).
  • MetLife Re-Segmentation Project: Prepared estimated financial for new company (Bright house Financial) and MetLife Legacy for QA testing before it goes live in production.
  • Customer Centric Approach: Proactively collaborate with Controller and CFO for new requests, review and discuss mapping with customer and build new report as per specification provided by controller and continuously improves current process based on feedback.
  • Training: Certified RPA Developer, Completed RPA training and started automating process using Robot (Virtual Machine), Power Pivot and Power Query, LEAN training.
  • Achievements: Won MetLife Award twice for process improvement and performance.

Financial Analyst (FP&A)

MetLife
Bridgewater
06.2013 - 12.2013
  • Supported 2014 Budgeting Process, Accrual, Expense Reclassification, Forecasting, Variance Analysis and Executive Reporting, Headcount & Production Report, Expense Trend Analysis and Other ad-hoc Reporting.
  • Operated Sales Commission Access databases and updated query for changes in criteria for Sales commission and product codes.

Pricing Analyst (FP&A)

Client-Accenture (CFM)
Florham Park
11.2010 - 04.2012
  • Ran pricing models for new opportunities with different scenarios.
  • Monthly analytics (Actuals vs Projection & Actual vs Plan) for current contracts.
  • Enhanced and automated the pricing process via creating global pricing template using MS Excel for consulting and outsourcing deal.
  • Executed analysis on client contracts, including impact of foreign exchange and cross border tax implications.
  • Phased the projected revenue over the life of the deal and recognize the revenue for As Earned contracts as per GAAP principle.
  • Performed risk analysis by building and generating forecasting models and comparing with earlier trends and pre-close analysis.
  • Accounted for feeding forecasting data into integrated forecasting system for Global Geography.
  • Prepared monthly financial reports and month/quarter end closings for more than a $40 million deal, which crossed internal control thresholds.
  • Joined offshore team on daily basis to manage the daily tasks and provided guidance as needed.
  • Responsible for migrating and implementing new forecasting system and engagement tool.
  • Partnered with IT team for system enhancements, process improvement, finding and escalating defects.
  • Modernized necessary documents and approvals on the SharePoint for SOX compliance.

Financial Analyst

A1 Property Management
Jersey City
05.2009 - 10.2010
  • Month end closing, Quarterly Expense Allocation, Accrual, General Ledger Adjustments.
  • Reconciled, executed, and supported the daily monitoring of cash balances.
  • Prepared & Analyzed Variance Analysis (Actuals versus Projection & Plan) and Trend Analysis.

Education

MS - Financial Engineering

Stevens Institute of Technology
USA

MBA - Finance

DBIM
India

BS - Engineering

Skills

  • Analytical skills
  • Data modeling
  • Data visualization
  • Handling large datasets
  • Reporting
  • Financial modeling
  • Planning
  • Projection
  • Trend analysis
  • Financial reporting
  • Process automation
  • VBA macro
  • Power Query
  • PowerShell
  • Python
  • Power BI REST API
  • API protocols
  • Power BI reporting
  • Dataflow
  • Creating key metrics
  • Automating data
  • REST API
  • Analytical problem-solving
  • Statistical finance concepts
  • Collaborating with onsite and offshore teams
  • DAX
  • Postman
  • Curl
  • MS Excel (Advanced Functions)
  • Access
  • Power Pivot
  • Maestro
  • Task Scheduler
  • Blue Prism RPA
  • SAP Finance
  • Hyperion (HFM, HP, SmartView)
  • Essbase
  • Cubus
  • PeopleSoft
  • BI Publisher
  • Forecasting tools
  • GPS (Pricing Tool)

Certification

  • P3 Foundations Certified
  • Blue Prism Developer

Projects

MyPath Project, Automating file transfer for Statutory & Reg Requirements, Built PowerShell code to automate file transfer process every month.

Timeline

Security Analytics Senior Specialist

MetLife
04.2022 - Current

Financial Consultant

MetLife
01.2014 - 03.2022

Financial Analyst (FP&A)

MetLife
06.2013 - 12.2013

Pricing Analyst (FP&A)

Client-Accenture (CFM)
11.2010 - 04.2012

Financial Analyst

A1 Property Management
05.2009 - 10.2010

MS - Financial Engineering

Stevens Institute of Technology

MBA - Finance

DBIM

BS - Engineering

Similar Profiles

CREATE PROFILE
Sneha Pariawala