Kiranmayee Sharma

Summary

A detail-oriented business professional with a clear focus on people, process, and technology. Passionate to gain professional experience and build my career. I have spent last 5 years gaining administrative and business experience by showing curiosity and willingness to learn by participation and collaboration. My experience within Staffing and recruitment industry, Mortgage, PBM Industry and Banking doing business process documentation has helped me to excel in my jobs and gain appreciation from management and colleagues.

Experience Synopsis

●As part of Business process experience - created Business Process documents, Operations Analysis, Office Administration, Resume Search, Document Creation, created business requirement document, while working with the product owner/project manager, attended daily scrum meetings to plan and test on boarding software.

●Entered, reviewed, and documented data on both the claims processing system and the internal request tracking database with predetermined timelines.

●Cross functional experience

●US Wealth Management related projects Portfolio and Risk Management Dashboard update.

●Execution Assurance data reporting for internal projects.

●Risk reporting through Control and Exception reports.

Professional Experience

Employer Wipro Limited August 2022 to August 2023

Client Citi Bank, Tampa, FL Project Aug 2022 to May 31, 2023

Business/Data Analyst

●Updating requirement documentation and Standard Operating Procedure for various business processes

●Support End-to-End Data Mapping, Validation and Comparing the attributes of the deliverable documents

●Creating Pivot Tables, VLOOKUP and applying other functions in MS Excel

●Experience with development of reports, reconciliation, and validation of data elements through quality reviews

●Experience in navigating through large volumes of data for analysis, Compiling and Consolidation

●Provide support to Metrics Intelligence Teams (Citi FRSS) on liquidity Metrics reporting by Sourcing data from SharePoint

●Communicating with Stakeholders and Process Owners of various Treasury teams

●Creating Templates in Excel for Weekly and Monthly reporting inputs from various business groups

●Worked on Process Control Tool (PCT) for the Weekly inputs in SharePoint

●Ran Macros in Excel for creating Templates and Reports

●Consolidating and publishing the weekly and Monthly Timeliness Dashboard which includes KPI reporting to Senior Management to take better decisions on Liquidity Reporting

●Using Celonis a Process Mining tool for Liquidity reporting and Compensatory calculations file for monthly reporting

●Experience in documenting requirements, testing, and providing support

●Compiled data on DTA BI Headcount Dashboards and Heatmaps as required

Employer On Demand Group July 2021 to January 2022

Client RBC Wealth Management, Minneapolis, MN

Data Analyst

●Accessing various sources (PlanView on-prem project management tool, MIS/ODIN – financial management tool, others) for information and then inputting these into the new PlanView SaaS tool.

●Information gathering – clear communications and reach out via phone to the needed PMs and PMAs to gather the missing information.

●Worked on EDS workflow tool to update PlanView SaaS.

●Adding PARs to PlanView SaaS and managing and updating the data using PlanView as a source of data to update.

●Pulled reports from Tableau for enterprise reporting.

●Gathered data from T&O operations team and Head of enterprise reporting teams.

●Used SQL to query data from relational databases to support business intelligence and analytics initiatives.

●Developed and implemented SQL queries to extract and analyze large datasets to identify trends and patterns.

●Automated tasks and improved the efficiency of business processes using SQL.

●Worked with cross-functional teams to deliver data-driven solutions to business problems.

Minneapolis Public Housing, Minneapolis, March 2021 to June 2021

Administrative Assistant

●General Office Administration

●Customer Care - communicating with stakeholders, participants, teams, eligibility technicians and inspectors

●Master data management through Yardi, visual homes, voyager

●Handle project and program coordination

●Work with upper management to prepare MIS reports

●Create and document process where needed conversion from paper process to system driven (SharePoint)

Prime Therapeutics, Eagan, MN January 2020 to December 2020

Clinical Review Technician

●Entered, reviewed, and documented requests on both the claims processing system and the internal request tracking database with predetermined timelines

●Responsible for handling pharmacy, physician, member calls related to the clinical review process

●Prescription benefit management

●HIPAA trained

●Handled formulary, quantity exceptions and brand override processes for delegated utilization management products and services

●Provided all relevant clinical information specific to a utilization management request to the clinical review pharmacist and the physicians

●Responded to all requests via written communication to the member’s physician and the member

●Responsible for entering approval records at the drug-specific level to ensure the appropriate claims will get adjudicated

●Worked on RX claims

Wells Fargo, Eagan, MN October 2019 to December 2019

Mortgage Document Remediation

●Learned about Mortgage Documentation

●Used Kofax Capture Tool to Verify and process mortgage documents

●Data Entry where needed

TAJ Technologies, Inc., Bloomington, MN March 2019 to September 2019

Administrative Assistant to HR and Delivery

●Data Entry, Customer Care

●Company Healthcare Business LinkedIn portfolio Creation and Management.

●Candidate Reference check

●Resume Match – IT and Operations

●Resume search in Monster

●Created and edited forms for the ease of use on mobile applications

●Updated RFP Responses for Future and Shared Use

●Created BRD for onboarding software while coordinating with offshore developers and product owner

●Wrote UAT scripts

●System testing and UAT recording results

●Managed documentation through SharePoint

TAJ Technologies, Inc., Bloomington, MN November 2018 to March 2019

Administrative Assistant to CEO

●Data Entry, Customer Care

●Maintained Office Supplies

●Front Desk Management, Arranging Travel for CEO

●Updated ACT – CRM Tool with Client and Consultant Information

●Supplier Diversity Applications for various new Business Development

●Credit Card statement Reconciliation

●Updated and edited past performance information for RFP preparation

●Researched New Business Information

Education

Osmania University, Hyderabad, Andhra Pradesh June 2002

Bachelor of Commerce

●Degree in English Medium.

●Second Language: Hindi

●Main Subjects: Business Economics, Accountancy – I, Industrial Organization Management., India History Culture, Accountancy - II, Business Statistics, Banking Theory & Practice, India Science & Civilization, Accountancy - III, Mercantile & Ind. Law, Auditing

●Electives: Cost Accountancy, Management Accountancy, Income Tax

●Jun 1999

S V S College for Women, Hyderabad, Andhra Pradesh June 1999

High School Diploma

●Education in English Medium.

●Subjects: English, Hindi, Economics, Commerce, Civics

MANAC Infotech (P) Limited, Hyderabad, Andhra Pradesh October 2016

MS-OFFICE Course September 2016

●Topics: Windows, MS-Word, MS-Excel, MS-PowerPoint, MS-Access

●Student Code: MST-3416, Batch Code: 60/15-16/160058, Certificate No:

ELT/201-***-****

Russell's Institute of Spoken English Pvt. Ltd., Hyderabad October 2016

Course in "Language Skills for Professionals"

●Scored Excellent Grade. Course consists of workshops and presentations.

Certified Course in Advanced Excel September 2016

New Generation Computers February 2021

Regd. by Govt of Telangana, Regd. No.2150/14, Hyderabad, India

Certified Course in Advanced Excel September 2016

Zarantech LLC December 2020 to February 2021

Certificate in Agile Business Analysis in Healthcare

Scrum Alliance - Certified ScrumMaster® (CSM®) February 2021

Certification in Data Science with SQL and Tableau, Cornell University July 2022

Certification in Business Analytics, Cornell University November 2022

Skills

●Worked on Salesforce CRM Tool

●PCT (Process Control Tool), Celonis (Process Mining Tool), DTA Dashboard (Power BI Tool), Salesforce

●ERP tools - Workforce and SAP Fieldglass, Kofax, IQ Navigator, SharePoint

●Confluence, Microsoft Teams, Jira, Visio, PVSaaS on prem and cloud, Tableau

●TAJ internal tool cTrack - recruitment, timesheet, and onboarding

●Resume search - Monster, Indeed, Dice

●MS Office, PDF Editor, Excel - VLOOKUP and Pivot Tables

Contact this candidate