Nishant Bhardwaj

Nishant Bhardwaj New Delhi - 110037 Email:- Phone: (M) - Seeking a challenging role in the field of Data Analytics, Business Intelligence and Reporting to contribute towards organizational success and to reach Senior Management Level SYNOPSIS Meticulous and highly accomplished professional with about 2 years of experience as Business Analyst/ Data Analyst; Result-oriented decisive leader to maintain high quality standards to meet challenges of this fast paced, high turn industry. Possessing valuable insights, keen analysis and team approach to implement best practices to achieve business excellence. Adept at working in high pressure environments with strict deadlines and multiple deliverables Strong leadership, problem-solving, planning, team-building and project management skills CORE COMPETENCIES CAREER HIGHLIGHTS/SUMMARY Experience in handling large databases. Possess good knowledge of Advanced Excel and SQL with a comprehensive understanding and application of its procedures. Good Excel Skills using Functions/Formulas, Pivot Tables, HLook-up & VLook-up, Multiple keyboard shortcuts, etc. Creating Dashboards & Reports with decent graphics and publishing using Tableau Report. EDUCATION Bachelor of Technology(IT) from MDU (scored 72%), Gurgaon in 2014 12th from CBSE Board(scored 61%), Delhi in 2010 10th from CBSE Board(scored 72%), Delhi in 2008 SOFTWARE PROFICIENCY SQL PL/SQL VBA MS Office(Powerpoint, Word, Outlook, Advanced Excel) ACHIEVEMENTS Key Contributor (KC) consistently for achieving high quality. Point of Contact(POC) which includes handling all the data & team responsibilities in the absence of Team Lead. PROFESSIONAL EXPERIENCE Accenture Solutions (Associate Analyst) Supports various functions which includes Data Management, MIS reporting, Campaigning, Trend Analysis. Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase by analyzing the raw data. Carried out data extraction and data manipulation using PROC SORT to create preferred customer list as per business requirements. Extensively used SAS procedures such as PRINT, SORT, MEANS and TRANSPOSE for producing ad-hoc and customized reports and external files Creating Dashboards for Client presentation and analytics Generate reports in Excel according to client specifications. Using Excel Skills like Functions/Formulas, Pivot Tables, Creating Graphs, HLook-up, VLook-up, Multiple keyboard shortcuts, etc. on daily basis. GlobalLogic Technologies (Jun’16 – Jan’18) Associate Data Analyst (Reporting & Analytics) Key Responsibilities: Interacting extensively with onshore counterparts on requirement gathering, analysis and documentation. Analyzing raw data, drawing conclusions & developing recommendations. Co-coordinating with other support teams QA, Leads, etc. Perform validation on derived data by following the standard operating procedures during the validation process to check data accuracy. Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase by analyzing the raw data. Perform SQL queries to fetch data using SELECT, INSERT, UPDATE, WHERE, JOINS, etc. Using Excel Skills like Functions/Formulas, Pivot Tables, Creating Graphs, HLook-up & VLook-up, Multiple keyboard shortcuts, etc. on daily basis. Reviewing productivity data reports, monthly and weekly status reports using Tableau. Delivering reports to clients using Shared Drive. Working on the project titled Google Shopping for the client Google using the tools MS Office. Project deals with understanding and extracting data from the data warehouse using SQL and the reports were produced for, Campaign Effectiveness, Online Shopping. INTERSHIP Maruti Suzuki India Limited Information Technology Intern 2W Engine Full Repair/Damage Repair System Categorizing, filtering the data by using Oracle PL/SQL. Generate reports in Oracle Reports Developer. PERSONAL DETAILS Date of Birth : - Gender : Male Marital Status : Unmarried Languages : English, Hindi (Nishant Bhardwaj)