Post Job Free

Resume

Sign in

Power BI Analyst

Location:
Chandni Chowk Area, Delhi, India
Posted:
December 20, 2020

Contact this candidate

Resume:

Aniket Kaushik

B-**/B Gali Number – *, Arjun Mohalla, Maujpur • Delhi, 110053, India

adiudi@r.postjobfree.com • +91-730*******/+1-724-***-**** https://www.linkedin.com/in/aniket-kaushik/

SUMMARY

Experienced Information Technology and Business Analyst with a knowledge base of Business Intelligence, Financial Analysis & Business Administration.

Designed, developed and implemented Power BI Dashboards, Scorecards & KPI Reports.

Experienced Oracle Documaker Consultant with more than 5 years of experience with fortune 500 clients.

Extensive experience in creation of Dashboards, Reports and Data Modelling which helps in better understanding of the Business trends.

A smart worker with 27% Analytical, 21% Conceptual, 26% Structural and 26% Social skills.

Excellent communication, analytical, interpersonal, and presentation skills; expert at managing multiple projects simultaneously.

Guardian Protector (ISFJ), ENTJ - Extravert (72%) iNtuitive (22%) Thinking (3%) Judging (22%) EDUCATION

UNIVERSITY OF COLORADO DENVER, SCHOOL OF BUSINESS Denver, CO Master of Business Administration, Business Intelligence & Finance July 2018 MAHARISHI DAYANAND UNIVERSITY Haryana, India

Bachelor of Engineering, Computer Science & Engineering June 2010 Overall GPA: 4.00/4.00

PROFESSIONAL EXPERIENCE

PYRAMID CONSULTING INC. – Dover, New Hampshire, USA August 2018 – September 2019 IT Business Analyst (Commercial Insurance Document Solution)

Insurance document Analysis, Analytic support to the product owner. Understand gaps identified by the Business analysts in the product & the customer requirements.

Created Power BI visualization of Dashboards & Scorecards (KPI) for Finance Department.

Designed and implemented a Monthly Resource Allocations system using Excel Power Query & Power Pivots to be included in dashboard reporting.

Conducted several Requirement Gathering Sessions (RGS) for gaining detailed requirements, Translated Business requirements to functional and technical language with the help of Use cases.

Responsible for efficient design and usage of various attribute dimensions like Customer, Product, Payment, Geographic and Time dimensions, and integrating them into reports displaying forecasting metrics.

Responsible for designing and executing Application objects and Schema objects using Power BI Desktop.

Developed complex calculated measures using Data Analysis Expression Language (DAX) to satisfy business needs.

Well versed with the Power BI product suite namely Power BI Desktop, BI Report Services & Power BI Dashboards.

Scorecard ADHOC development of SQL to Excel dashboards, charts, graphs, and Pivot tables.

Created Special technically directed documents for better acceptance of the reports. ACCENTURE SERVICES PVT. LTD. - Gurgaon, Haryana, India Senior System Analyst (Oracle Documaker) April 2013 – July 2016

As a part of Group Correspondence Release 2 - Designing and creation of policy forms as a Developer in the team.

Working on Paragraphs and Paragraph lists. Creation of DALs and scripts, and CPLs (Customer Specific Provision Language).

As a part of Maintenance Release - Working on Change Requests, Defects and Interview Screens. Knowledge Transfer sessions to new joiners.

Received Avanade Orange Award for the Delivery excellence individual. System Analyst (SharePoint 2010) April 2011 – April 2013

Responsible for providing production support, and user support in line with the Service Level Agreement (SLA). Communicate with the Business Users in an appropriate and constructive manner and keeping them informed of progress on call resolution.

Integrated application with Google map, Live stock price, Site Accelerator and CDN Network. Developed custom master pages, page layouts, web parts and user controls.

Received Outperform award for contribution in SharePoint 2010 application support. SKILLS

Technical

SharePoint Server 2010, SharePoint 2010, ASP.Net 3.5, SharePoint 2010 Search configuration,

Python (libraries - NumPy, SciPy, Matplotlib, Pandas),

Microsoft SQL Server, SQL Server, SQL Server Integration Services (SSIS), MySQL, DAX,

Oracle Documaker 11.5, Oracle Documaker 12.0,

JMP Pro 13, SPSS, Tableau, Megastat, MicroStrategy Desktop, Power BI, Excel - Power Pivot & Power Query, Data Models, BPMN

Microsoft Excel proficient (Pivot tables, V-Look Ups, etc.), Word, and other MS Office applications.

Financial

Strong understanding of accounting and finance theory, GAAP, IFRS.

Exceptional understanding of financial market and the full investment process.

Highly skilled in building complex financial models, valuation modeling and financial statement analysis.

Basic understanding of Banking, Financial principals, and Capital Markets.

DCF Valuation, Mergers & Acquisitions, Bloomberg, Market Research and Analysis, Investment Banking, Credit Analysis, Financial Projection, Leveraged Buyout (LBO) Modeling.

CORE COMPETENCIES

Financial valuation modeling

Corporate Finance

Effective Communication

Relationship Management

Interpersonal and communication skills

Financial Accounting

Risk Management

Quantitative analysis

ADDITIONAL INFORMATION

Ethical Leadership Certified – NASBA Center for the Public Trust.

Successfully completed Capstone project for Strategic management.

Winner of the ACG (Association for Corporate Growth) cup 2017 – Midwest Region (United States of America) – The Denver Chapter.

Organized Avanade Sahyog club event with Hope foundation for Mumbai location.



Contact this candidate