Data Analyst Manager

Anand Kumar Chaudhary

Add: HN **First Floor E-mail:adhx1u@r.postjobfree.com

Aya Nagar Arjan Garh New Mob no: +91 965-***-****-995-***-****

Delhi-110047

Key Skills & Experience

• BI / analysis –Business planning, Data cleaning, Automation, Management reporting (MSBI (SSRS/SSIS and SSAS ), MS Office Advanced)

• Application (SSIS, SSRS, SSAS, SQL Server 2005, 2008, 2008R2,2012,2014 MS Access and Ms Excel, Power BI and Python(data analytics, data cleansing and web scraping using python libraries like Pandas, NumPy, Matplotlib, requests, bs4, Beautiful soup, turtle, SciPy, Scikit – Learn, Seaborn, TensorFlow. ))

OBJECTIVE

Seeking assignments in the Business Intelligence & BI Automation with a reputed and leading corporate organization having hi-tech environment, which will help me to implement my skills to the fullest and utilize my capabilities to my potential.

PROFESSIONAL SUMMARY - BI DEVELOPEMEMT

7+ years of (Vodafone India, Samsung India Electronics Pvt.Ltd, E-commerce AskMeBazaar.com & Home Credit India) industry experience in Business Intelligence Development, Data Analytics, Data Analysis and Data Cleansing etc.

5+ years of experience in MSBI (SSRS, SSIS and SSAS).

Involved in Huge data migrations, transfers using utilities like Data Transformation Experience in BI Development and Deployment of SSIS packages from MS-Access, Excel and Flat file

Experienced in programming tasks-Stored Procedures, Indexed Views, Triggers and user defined Functions using SQL Server 2008/2012 with T-SQL

Expertise in generating reports using SQL Server Reporting Services, Reports, and MS Excel spread sheets

Proficient in MSBI (SSRS, SSIS and SSAS), SQL server (TSQL) MS Excel, Advance Excel & MS Access.

Currently working with (Web Help India Pvt.Ltd. UK Based MNC) (Dec-17 to till Date) Designation :-( BI Developer) (Role Data Science) UK Client EasyJet Airline: -

●Develop SSIS Package and automated them that run on daily basis and upload the data in SQL server.

●To check the data Quality of the raw files and then design the architecture accordingly.

●Develop report in Excel and Power BI as per client requirement.

● To check daily jobs and identify the issue and resolve them and then rerun the jobs.

●Upload (Text, CSV and Excel) files in SQL server Database by using SSIS Package.

●Worked closely with client and project manager to understand the business requirement and develop new things such as like SSIS Package and Power BI dashboard.

● Using python for data analytics, data cleansing and web scraping (python libraries like Pandas, NumPy, Matplotlib, requests, bs4, Beautiful soup, turtle, SciPy, Scikit – Learn, Seaborn, TensorFlow.

●Discuss with project manager regarding new development project along with their deadlines in weekly scrum meeting on every Monday.

●To Build SQL Queries and store procedure for Creating an aggregate data table on Mart Server

●Download files from SMTP Server and move them on staging server then upload the data in SQL Server then go to on extract server create a new SSIS Package and move data from extract server to warehouse server.

Home Credit Finance India Pvt.Ltd. (Jul -16 to Dec-17)

Designation:-(Analyst) Role (SQL Developer & BI Analyst)- Responsibilities: -

●Effective and efficient Implementation of the overall business strategy for Early Field Collections Team.

●Monitor & manage the Process Metrics including Conversions, flows, recovery, repossession, process management, customer complaint etc., highlight key risks and provide inputs for Mitigation Plan to achieve overall business goals.

●Prioritization and allocation of contracts into internal field collections team and external agencies in order to maximise recovery rates.

●Manpower planning and budgeting as per the business volume and ensure adequate staffing levels at all times. Ensure effective manpower alignment to drive bucket efficiencies.

●Target setting and monitoring performance through daily, weekly reviews to ensure target achievement.

●Upload (Text file, CSV and HTML) data files into SQL Server using SSIS

●Develop and support a team delivering verify cautions standards.

Responsible for providing leadership, support and guidance to the CPU AND FLV team.

●Using Python for Data Analytics and Data Analysis with (Pandas, NumPy, Matplotlib, seaborn etc)

ASKME BAZAAR.COM Designation (Senior Executive) Role (BI Development) (Aug’15-July-16)

●Extract data from (SQL) as per company demands.

●Extract data from (SQL) provide data to various departments as per requirement.

●Tracking shipping company wise courier TAT using (BI Tools SSRS)

●Prepare review data on weekly & Monthly basis for (Logistic, Finance, Sales, Operation, and Marketing) team from (SQL )

●Automate city and SO name wise seller report in SSRS BI.

●Tracking order history TAT for every order in SQL.

●Support and enhance business operations (including sales of products)

●Analysis the revenue achievement of various contests (Like Daily Jackpot, etc.)

●Define data in various categories for review purpose.(Like Orders received, Dispatched,Cancelled, Transaction-Confirmed, Delivered)

●Automate courier wise delivery report sends on daily basis to pan India.

Manpower Group (Client- Samsung India Electronics Pvt. Ltd.) Designation (SALES COORDINATIOR) (Oct’ 2014 – Aug’15) Role (Data Analyst) & Responsibilities

●Experience in Data compilation & various types of analyses then present it to management.

●Preparing assorted types of charts and report with good analyses and presents it to management.

●Handling all ad-hoc requirement from the management and resolve it as soon as possible.

●Daily Branch wise sell-out Vs. sell thru Dashboard build in (Excel)

●Brand shop Dashboard, Direct dealer Dashboard Automate in (VBA)

●Sub dealers sell-out dashboard Build in (SQL Server)

●Branch, Ditsy, SPP & Non SPP Dashboard extract report from SQL.

●RSO wise sell-out, uploading,and regularity report

● Prepare sub dealers and ditsy incentive as per company guidelines.

●Writing SQL Queries for Ad-Hoc report requirement

●Understanding the data

●Establishment of new report and dashboard as per company requirement.

●Research/analysis skills, Quick learner, Adaptable and Process-Oriented.

●Product wise Report build in (SQL) Only for (Consumers Electronics)

●Sell-out capture report send automatically to North India

Adecco India and Apex Service Pvt Ltd. (Client Vodafone Digilink Pvt. Ltd. Designation (Retail Associate) (Feb’ 2013 – Sep’14) Role (Data Analyst) & Responsibilities

●Deal with individual / Corporate Customer.

●Maintained Data regarding Payroll, Incentive.

●Weekly Key Business indicators (KBI’s) report.

●Vodafone Prepaid related report build in (SQL)

●Various type of business activity Prepaid Vodafone vs. Post-paid Vodafone s SQL.

●Day wise Coupon Recharges/ Etop recharges Report data extract from SQL Server.

●Create Master Distributor, Associates Distributor ID on server.

●Prepaid all recharges analysis and show the Presentation. Other Task which has been performed

●All kind of Reports and Data analysis Decided Function with the Head.

●Prepared scorecard, KBI, KPI, Presentation,Dashboard, Circle Daily reports, Circle P&L Report, Daily Retail Churn Reports, Daily -Monthly Prepaid and Postpaid, Daily Dashboard,Daily corporate report, monthly Corporate report, Monthly Corporate P& L, Project Scorecard, Dronacharya scorecard, circle combat reports, Daily SMS reports, Zonal Manager, function head Reports.

Axis Cogent Global Pvt.Ltd (Client-Tata Docomo) (Feb-12- Jan-13)

Roles (MIS Executive) & Responsibilities:-

●Working with Software team, to automate MIS process (Report Generation and presentation) of company using Microsoft Technology.

●Working with MIS team, responsible for Creating VBA programs to automatically update Excel workbooks and external data queries

●Data Analysing and highlighting the issues of operation

●Responsible for compiling and quality check of reports

●Developing the ad-hoc reports as per the client and management requirement

●Worked for the MIS Automation software

●Coordinating client, management and operations

ACADEMIC QUALIFICATIONS

●M.A from CCS University Meerut.

●B.A from CCS University Meerut.

●12th From UP Board.

●10th From UP Board.

Personnel Details:

S/O Mr. Shiv Prasad Chaudhary

Date of Birth 02-07-1986

Sex Male

Nationality Indian

Marital Status Unmarried

Anand Kumar Chaudhary

Contact this candidate