Data Analyst Sas

MADHURI GANTI

CELL: 425-***-**** EMAIL: *******.*********@*****.***

Data Analyst with 3 years of experience implementing Information Technology Solutions for Fortune 500 companies in Business Operations, Financial and Insurance sectors. Managed a full software development lifecycle program from $500,000 to $2 Billion in budget including a team size of 5-15 people. Skilled in recording, interpreting, and analyzing data using SAS, SQL and Statistical tools and techniques. Experienced in preparing detailed documents and reports using Power BI. Analytical and process-oriented with knowledge of research methodologies, big data capture, data manipulation and visualization using Descriptive and Inferential Statistics, Azure ML, Python and R. Seeking a position to leverage my data visualization and data modeling skills. Educational credentials include Masters in Statistics and Data Science Certification from John Hopkins University.

EXPERIENCE

Capgemini

Role: Operations Data Analyst Jul 2020 to Present

Client: Microsoft C+E (Commerce & Enablement) Eng Ops

• Support the Microsoft commercial cloud programs (MS Azure, MS office 365, MS Dynamics 365, LinkedIn) to enable the capability for customers to transact on the products.

• Manage day-to-day operational aspects of project, coordinating activities across a wide group of internal, external, and business teams.

• Track progress of the product launches towards key Milestones and report on the statuses to Project Management and Functional Teams.

• Assist senior leadership with development strategies to manage department workflow.

• Work on adhoc tasks for the Azure and product data.

• Run SQL code to assess, validate and analyze large datasets of Volume Licensing to support the project needs. Capgemini

Role: Trade Data Analyst Apr 2019 to Jul 2020

• Acquire and consolidate Partner data from the Global Trade Systems - SAP, Dow Jones, Bloomberg, and LexisNexis

• Analyze and screen the data for compliance with MS trade and Sanctions guidelines and process the cases.

• Process on average around 150 cases/day.

• Drive and execute on the high priority Adhoc Trade Screening requests with the offshore team and adhere to SLAs.

• Act as a liaison for internal and offshore teams for Trade Shutdown actions.

• Develop and maintain SQL jobs and Productivity Reports leveraging SAP, SQL Server and Power BI

• Training and aiding onshore and offshore team on case management and domain and system ramp up. Symetra Financial Jan 2018 to Feb 2019

Policy Data Analyst, Benefits Division.

• Monitoring and maintaining Contract Administration and Premium submission mailboxes.

• Assign the tracking tool work items and validations to the implementation Specialists/Managers.

• Reviewing and screening requests for policy holders, calculating new premiums, issuing new policies and associated documentation.

• Analyze high volume enrollment data requests leveraging MS Excel reporting and manage the workflow by cooperating with the team of 4 members.

• Collaborate with Managers to determine and address data and reporting needs for various insurance products.

• Accurately process member enrollments including adding, terminating, and updating complying with the contract guidelines and policy rules.

• Extract, load, model, and reconcile large amounts of Benefits, Premium, Contract Administration and member data across multiple system platforms and sources.

• Develop reports and deliverables for management. Model data using MS Excel. SAS Programmer, Bank of America Mar 2016 to Dec 2016

• Develop and maintain client profiles including analysis of present position and creation of balance sheet and net worth statement. Ensure risk profiles, goals, objectives, and asset allocations are appropriate.

• Collect and organize data in order to track, report and monitor results and action plans

• Implement and automate reporting solutions to address business requirements using SAS

• Developed & automated weekly reporting with SAS, SAS/BI & shell scripts

• Automation of data import from Excel and CSV into SAS. EDUCATION/CERTIFICATIONS

Data Science Specialization 2015

Johns Hopkins University / Coursera

Business Analyst Certificate 2013

Requirements, Inc.

SAS Base Programmer 2012

Certification completed in June'12 from SAS institute Master of Science, Statistics 2004

Work Authorization: United States Citizen.

SKILLS

• R Statistical Software, Ggplot2, Knitr & R Markdown for automated PDF &HTML Reporting

• SAS, SQL

• Python, Jupyter Notebook

• Power BI

• Descriptive and Inferential Statistics

• Azure ML, Machine learning

• Linear & Multiple regression modeling

Contact this candidate