Financial Analyst Business Intelligence

Asim M. Baig

732-***-**** *********@*******.*** linkedin.com/in/asim-baig-63b2572b

Technical Skills

Statistical data analysis and programming: SAS (enterprise guide), SQL, MS Office (Excel, VBA, Access, Word), Reinsurance Systems: TAI, LynchVal (Defined Benefit Valuation Software), APL, TRITON ETL Tools: Informatica PowerCenter 9.1, Power Exchange 9.0, SQL Server 2008. Business Intelligence Tools: COGNOS, Business Objects Experience

Director Operations: May 2024 to present

S4Speech LLC, Morrisville, PA

● Acquired pre-authorization from various insurance companies to provide Speech Therapy to clients.

● Submitted Speech therapy claims to various insurance companies.

● Follow up on rejected claims, provide additional information to insurance companies, successfully change claim status from rejected to approved for payment.

Financial Analyst II, Government Program Dept Aug 2017 – April 2024 Horizon Blue Cross and Blue Shield of NJ. Hopewell, NJ

● Extracted membership activity data from MMR reports using SAS EG, presenting findings to upper management, leading to a 15% increase in operational efficiency.

● Analyzed third-party invoices for MLTSS payments with SAS EG, approving or rejecting over 20 million claims per month, saving the company $2 million annually.

● Developed claims pricing models for Outpatient and Skilled Nursing Facility Claims using SAS EG.

● Created the Liability Lag triangle and generated month-end reports using SAS EG and Excel. Senior ETL Developer/Data Analyst Oct. 2016 – Aug. 2017 Logistics Execution Systems Philadelphia, PA

● Collaborated with analysts across 100 hospitals to transform business requirements into precise technical user specifications, including data, process, and interface specifications.

● Utilized SAS for complex statistical analysis, SQL for efficient database querying, and VBA within Microsoft Excel to automate tasks and enhance data analysis and reporting capabilities.

● Facilitated effective communication and collaboration with various stakeholders to gather and interpret requirements accurately.

Senior Actuarial Consultant, Medicare Advantage Part C Feb 2015 – Oct 2016 AETNA Life and Health Insurance Company. Blue Bell, PA

● Managed data updates and extractions using SQL or SAS (Enterprise Guide), improving data retrieval over Microsoft Access database.

● Updated various Data Repositories in Access Databases for Medicare Advantage BID pricing process.

● Supported Medicare Advantage Bid filing for Center for Medicare and Medicaid Services (CMS) with other Actuarial Departments.

● Provided data support for Medicare Advantage (MA) Bids, for exhibit 1, and collaborated with Auditors on CMS-audited plans.

Lead Technical Analyst/Informatica Developer Jan 2013 – Dec 2014 X-Techno Consulting Inc. Parsippany, NJ

● Comdata: Collaborated with business departments to design, develop, and support ETL processes, successfully migrating data to the centralized data warehouse, benefiting from a 20% processing efficiency improvement.

● CatamaranRx: Led technical analysis efforts, translating business requirements into technical specifications for client migration, developed comprehensive technical documents, and conducted data analysis using Aginiti.

● Geisinger Health Plan: Spearheaded Informatica development, creating reusable transformations and Mapplets, and utilized debugger tools to ensure data integrity and optimal performance. Finance Manager Jan 2011 – Dec 2012

AB & Co. Newtown, PA

● Managed operational expenses, including pricing new products and overseeing account payables, leading to a 10% reduction in overall costs.

● Oversaw imports, ensuring efficient management and compliance, leveraging SQL expertise for data analysis.

● Played a key role in financial decision-making processes, contributing to the company’s overall financial health. Actuarial Consultant II, Dental Pricing Group July 2007 – Oct 2010 Metropolitan Life Insurance Company. Bridgewater, NJ

● Spearheaded pricing support to the Proposal Unit during peak season, participated in cross-training, and assisted Dental Underwriters in quoting new and renewal cases.

● Generated Procedure Class Distribution and Area Factor Study annually for the Dental Book of Business to study utilization, and communicated updated Premium rates to underwriters.

● Proactively updated Trend Analysis for Book of Business and conducted customer-level experience studies to monitor utilization.

● Managed the filing of the Annual Report for Dental for various States Rate Filings using SERFF for current products, and provided information for various RFPs for Dental. Senior Actuarial Analyst, Reinsurance and Life Product Department June 2004 – April 2007 ING – US Financial Services West Chester, PA

● Prepared quarterly and annual financial reinsurance settlements, with accuracy and ensuring compliance with regulatory requirements. Collaborated with Accounting and Treasury departments to ensure smooth quarterly settlements, monitored various reinsurance treaties, and certified the reinsurance pool players’ share of the risk.

● Reconciled various items between policy administration and reinsurance administration systems, and resolved problems found in the administration of policies for various life products. Senior Actuarial Analyst, Corporate Actuarial Department Oct 1997 – June 2004 MONY Life Insurance Company New York, NY

● Managed Actuarial Development Group Student, overseeing student development.

● Calculated FASB 106, FASB 87, Non-Qualified and Qualified Retired SSIB, and Non-Qualified FICA reserves for employees and Field Underwriters of MONY Life Insurance Company.

● Led reconciliation efforts for FASB 106 and FASB 87 data, ensuring accuracy in Life/Medical and Pension Reserves, and coordinated Separate Account Certification with cross-functional teams and asset custodians.

● Collaborated with the tax department on Asset Charge Distribution for Separate Accounts, ensuring regulatory compliance and financial transparency.

Education: University of Iowa. Iowa City, IA. Bachelor of Science in Actuarial Sciences Certifications/ Exams: Financial Mathematics, Probability, Interest Theory, Time Series, and VEE’s

Contact this candidate