Expert in R, SQL and advanced excel

Priyanka Yadav, (Permanent Resident)

**** ********* ****

Apt # 1530

Rockville MD 20852

Email: *****.******@*****.***

Mobile: 301-***-****

Summery:

R programming, SQL and advanced Microsoft excel expert with success in data maintaining, manipulation, exploring and its visualization and cleaning. Demonstrated ability to use critical and strategic thinking to resolve discrepancies, fill gaps, and sustain quality control benchmarks.

Technical skills:

R programming:

Data exploring, visualization, manipulation and its cleaning by Tidyr, dplyr. Graph customization and graphics with ggplot2. Web Scrapping and perform scripting and coding task-using R.

MS-XL (have Advanced Microsoft Excels Skills functions such as VLOOKUP formula development, Scenario Manager, Pivot Tables reporting and Tableau.

SQL (expert in sql scripting for data analysis)

MySQL

Python

ASP.NET

Educational Qualification:

R Programming October 2017

DexLab Gurgaon India

Master of Science (M.Sc.) in Information Technology August 2009

Graphics Era Institute of Technology Dehradun, India.

Bachelor of Science (B.Sc.) in Biology June 2007

Meerut University Meerut. India

Experiences:

Knowledge Advisor (Part time) Feb 1, 2018- onwards

Microcenter, Rockville MD.

Demonstrating effective time management and multi-tasking skills to complete daily projects.

Sharing expert product knowledge and made professional recommendations to help customer throughout the buying process.

Effectively initiating and utilizing team oriented strategies to provide the highest level of service to customer. Executing sales by adhering to company implemented selling format.

Exhibiting the ability to handle a wide variety of customer complaints and delicate situation.

Resolve customer concerns promptly, politely and professionally which resulted in a win - win situation for both sides.

Data Analyst Nov 2017- onwards Brandlift Marketing Pvt Ltd, New Delhi, India.

Accumulating and generating spreadsheets, capturing key data related to company’s dynamic contracts.

Managing spreadsheets and maintaining data currency to ensure accurate data availability for managers, board members and for decision & policy-makers.

Exploration, update and validating data underlying spreadsheet production, strategically to fill gaps.

Formatting spreadsheets and workbooks for print, document reproduction and presentations.

Generating Pivot table and charts using worksheet data and external resources. Pivot reporting and modifying spreadsheets to achieve analytical goals, sorted items and group data.

Developing and executing standard operating procedures to bridge data gaps and resolve related issues.

Data importing and exporting from text files or from saved queries and from databases.

Managing data load requests, entering data, resolved data conflicts, and created data extracts and reports.

Performed data manipulation, transformation and cleansing.

Conducting full life cycle analysis to include requirement activities and design.

Collecting data from sales figures, market research, logistic, transportation costs and use it to help companies make better business decisions.

Built and maintained SQL scripts, indexes, and queries for data analysis and extraction for projects.

Prepared a claim data for risk adjustment by extracting, cleaning, and merging from different tables using SQL.

Develop sales strategies with marketing department. Evaluate prices and marketing outlets.

Access client’s promotional needs and analyze competitors.

Develop group and solicit customer feedback.

Complete concept testing for new products.

Determine brand perceptions and reputations.

Internship Jan 27, 2009 – June 13, 2009

HCL Infosystem Ltd, Noida. India

On the project entitled “Service Manager and Descriptor”. The project was designed in ASP.NET and on back end, we use SQL server 2000. In this project we made software named project service automation. This software deals to automate the service provider organizations. It deals to maintain job card, customer’s problem and make report according to the requirement. The major part of the project to deal with product and provide satisfaction to customer. At the time of product Purchase Company provide product Id that is work like a primary key and at the time of service we make transactions on this key. Module of the project is to keep the track record of engineer through engineer Id and record everyday cases done by engineer. The project is to automate any product service center, which provides its customer with facilities for the products owned by them.

I hereby declare that the above given information is true to best of my knowledge and belief.

Place: Rockville (Priyanka Yadav)

Contact this candidate