Monika Srivastava

MONIKA SRIVASTAVA Mobile:-, E Mail: -- ABRIDGEMENT Worked with Teleperformance as Quality & Testing Analyst 18th Dec18 to 17th Nov 23   Expertise and working knowledge of using Advance Excel ,Power BI, Tableau, SQL,SAS An efficient multi-tasker with an ability to shoulder important responsibilities and carrying them out to the hilt. ACADEMIC/ PROFESSIONAL QUALIFICATION    Graduate from Rohilakhand University Technical Diploma from Azad institute, Lucknow X and XII from UP Board HANDS-ON SOFTWARE EXPERIENCE   MS Office, Advanced MS Excel, SQL Python(Base) , Power BI , Tableau, Snowflake,CRM PROFESSIONAL EXPOSURE Worked with Teleperformance from 18th Dec 18 to 17th Nov23 Promoted as Quality & Testing Analyst from Jan’20 Responsibilities       Quality analyst for Refund and ADM team. Publish MBR Report for Refund and ADM LOB with the help of Power BI. Audit & Refresher Training ( Monthly), Calibration report ( Fortnightly) Quality Huddle (Monthly 2) & SOP update. Internal and External Defect Analysis (Twice in a month) and works on many reports related to quality and operations using MySQL tool and Power BI. Managing second level task, which includes client interaction, Assigning workload and managing floor. Reporting Responsibilities: Familiar with MIS.  Day-to-Day Analysis of MIS Reports, follow up and coordination with cross-functional teams to ensure timely flow of MIS.  Proficient with Data Management and Data Analytics.  Generates SAS Reports as per Business requirements.  Comprehensively prepared reports using SAS report generating procedures like PROC PRINT,PROC FREQ, PROC MEANS, and, PROC SQL.  Well versed with using and designing data _null_, SAS formats informants and functions, data manipulation & report.             A working knowledge of advanced Excel functions and ability to read, write, and debug advanced Excel formulas is required. Using Excel Functions, Table, PivotTable, Data Tools, Charts, Lookup, Sort and Filter .Analysing data and creating final Report. Hands on Good Experience in Ms-Excel. Using advance functions. . Daily, Weekly, Monthly MIS Reports, Dashboards generation and automation using Excel. Provide support to reports and Power BI applications. Expert on Power BI and Tableau dashboard creation. Generated tables, listing and graphs in statistical analysis of data. Extensive use of PROC SQL to perform queries, join tables. Expert knowledge of analytical tool such as SQL. Expert proficiency in Tableau and other Analytical and Reporting tools Develop and deploying visualizations and dashboards using Tableau. Understanding system data structure and extraction requirements. Knowledge on connecting to multiple data sources through Power BI and Tableau. Previous Work Experience Carlson Wagonlit Travel 09 Nov16 -17 Dec 18 Designation: ADM Agent (Travel)     Worked on airline debit memo .I need to research on debit memos and do the root cause analysis if valid or invalid. Managing second level task, which includes client interaction over the call and email, Assigning workload, and managing floor. Share the Debit Memo report with operations Manager with the help of MySQL. Worked on Oracle CRM to connect and analyze the client Data. Intelenet global services 27Nov15 -24 Aug16 Designation: Refund Executive (Travel)  Process the Refund in GDS & Send e- mail to passengers and airline   Follow up with airline and chat with travel agent of US base Handling fraud/chargeback refunds as per the authorization from airline. TCS 12Aug14-15 Oct15 Designation: Executive GDS.    Amadeus Create a revenue for Lufthansa airline. To check the fares and taxes and bill to other airline and vice n versa Read the rules and agreement between airlines and apply it. Key Skills and Competencies:     Proficiency at grasping new concepts quickly & utilizing it in a productive manner. Confident and able to take the initiative. Building and maintaining positive working relationships with key decision makers. Articulate, personable and willing to work as part of a team. Technical Proficiency:         SAS SQL Advance Excel Alteryx Snowflake CRM Power BI and Tableau Python(Base) Monika Srivastava