YOGESH KUMAR | MSCA – Power BI Certified
Delhi, India – Mobile: +91 – 9910106288
Email : yogesh.k@hotmail.com , Linkedin
20+ years of experience in Data Analytics, Data Visualizations, Business Analysis, Business Intelligence.
Technical Expertise (Skillset):
RDBMS : Microsoft Azure, SQL Server, MS Access, MySQL
Programming Languages : Visual Basic 6, Visual Basic.net, C-Sharp, VBA Macro
DBMS : Excel
CRM Application : Microsoft Dynamics 365, Microsoft Dynamics 365 For Talent
Reporting Tool : Power BI, Microsoft Excel, QlikView, Microsoft Tools
Web Analytic Tool : Omniture SiteCatalyst, Discover, Report Builder, ClickMap,
Omniture Data-Ware House
Social Media Tool : Tumblr, Facebook Insights, Twitter Counters, YT Analytics
Debugging Tool : HttpWatch, Omni Bug, fiddler, WASP
Career Summary
Wunderman International Pvt. Ltd, Oct’2008 – till present
Current Position held: Manager – Data & Digital Analytics
Perform multiple roles and duties around Business Intelligence, Business insights, marketing analytics, Statistical Techniques,
Predictive Analytics, Data warehousing including Big data analytics, Real-time analytics architectures, and reporting solutions.
This also includes Digital Transformation, Business Process Optimization by leveraging Big Data Analytics and Artificial Intelligence technology landscape.
Key Responsibilities:
• Define best practice and thought leadership around business insights and analytics.
• Identify the immediate needs of the Analytical and BI infrastructure on Microsoft Analytics Cloud Platform (SQL Server, SSIS, Data Lake and Data Bricks), with a focus on setting up the ecosystem end to end.
• Build out our Analytics and reporting engine on Power BI, Tableau, MS Excel from its infancy, eliminating redundancy and inefficiency to make our system more dynamic, intelligent, and predictive.
• Content and Sentiment analytics using Artificial Intelligence techniques.
• Apply knowledge and expertise in quantitative analysis, predictive modelling, and data mining to see beyond the numbers and understand how our users interact with our products.
• Partner with functional teams to design, run, and analyze A/B and multivariate hypothesis tests aimed at optimizing customer experience, business KPIs and product funnels.
• Analyze organization data with statistical rigor. Ensure accurate interpretation by combining business acumen with detailed data knowledge and statistical expertise.
• Work closely with leadership to drive product and business decisions.
• Covering various business areas such as Sales Analytics, Supply Chain Analytics, Finance Analytics and Factory Production Analytics, E-Commerce Store Analytics etc.
• Migration of complete data and analytics eco-system to Microsoft Azure Cloud Platform.
Additional Projects Delivered: –
▪ Microsoft Dynamics 365 for Talent Implementations for multiple subsidiaries.
▪ Forecasting Management Tool
▪ Tags Management Tool for Nokia.
▪ Internal dashboard to check pending task / Utilizations by day, month, teams etc.
▪ Kudos Management Tool for team. ▪ Online Ticketing system for managing assets (IT/Admin/HR).
▪ Web Crawling tool. Which can crawl n numbers of web links in website working or not working. It has given name as IceBurg.
Euro RSCG India Pvt Ltd, Gurgaon, May 2007 – Nov 2008
Position held: Database Manager
Key Clients: – KLG Systel, Volvo, Good-year Tyre and Voltas, Max New York Life Insurance Ltd
Key Responsibilities: –
• Defining process flow for new activity received for data entry, cleaning, and printing.
• Producing / supervising / coordinating production of the software required for all database operations. • Responding to Account Manager Queries for database marketing purposes. • Creating and maintaining a common structure for all databases.
• Updating the database with the information in the news regarding deaths / career shifts of well-known people.
• Ensuring cost reduction / quality improvement & analyzing the areas and make recommendations where cost can be reduced and quality improved.
• Scheduling the weekly schedule with the supervisors, assigning additional responsibility if the load requires it.
• Keeping abreast with new technology for data entry / cleaning / printing, cost versus return analysis.
• Identifying training needs and co-ordinate with training dept regarding the same.
• Identifying growth potential in team members in conjunction with supervisors and make recommendations.
• Scheduling & monitoring activity & designing the MIS reports for each activity.
Data Analysis & Trends reporting
• Preparation and presentation of complicated financial and operational analysis; Develop spreadsheets and analysis to help understand key business drivers.
• Analyze and interpret monthly variances and trends between budgets, actual and prior results in developing projections and forecast.
• Assist in developing standard tools and processes for collating information from various sources for performing financial reporting and analysis.
• Building dashboards for better decision making by top management; Ad hoc analyses
• Managing the information aspect and providing the real time analytics support to the business.
Intelenet Global Service Limited (Spanco Tele system Ltd), April 2006 – May 2007
Position held: Database Manager
Handled Database Management & MIS of Sparsh BPO’s for the following Process: -BSNL, Citi Bank – All Process, GE-SBI, Tata-Aig, AirTel – Inbound/Outbound, ICS – Nikko, ICS – INEX, PNB (Punjab National Bank), Pizza-Hut, LG – Inbound/Outbound & HCL
Key Responsibilities: –
Data collation in the required formats from other departments.
Preparing Daily, Weekly & Monthly working schedule for Tele-Callers.
Providing necessary training to MIS Executives and Validation of Reports
Maintaining productivity level of Tele-Callers for incentives.
Database Maintenance.
Database procuring.
MIS Reports Generations (Internal & External).
Time Planning.
Serco (Info-Vision Solutions), Nov 2001 – April 2006
Position held: Supervisor – Database Operations and Programmer
Handled Database for Loyalty based programs for clients HTA (Wills), Whirlpool of India Ltd., Honda, EIH (East India Hotels),
Shoppers’ Stop Ltd., Microsoft Seagram (100 Pipers/Royal Stag), Lintas (Indian Army), GE Capital, GE Countrywide, Barista & AVIVA.
Key Responsibilities: –
• Handled the BIIM and data processing team and training.
• Preparing Daily, Weekly & Monthly working schedule for BIIM Resources.
• Making process for Database Management, Data Entry, Printing, de-duping, Stock printing & Costing
• Data Cleaning, Inventory and Processing.
• Maintaining productivity level of Operators for incentives and MIS Reports Generations.
• Time Planning.
FoxPro (backend DBF/XLS)
• Make Data Entry Screen for KP1-KP2, Matching program for double data entry.
• Operator Error & Accuracy tracking programs. Through this we maintain the good quality data.
• Used help masters to get more quality work.
• Make programs for all above accounts.
Visual Basic (backend MDB/XLS/SQL)
• Making all type MIS. (Database & other Dept.)
• Preparation program Face to Face Interviews for HR.
• Preparation Online queries from client program for AVIVA/Airtel Call Centers.
