Akash Chaubey
Business Data Analayst
adiabm@r.postjobfree.com
EXPERIENCE SUMMARY
Having 7 years of professional IT experience across various verticals like Healthcare, Treasury, Banking, Capital Marketing, Finance, Supply Chain Marketing etc, focusing on Business Analytic tools, Data warehousing, Data Virtualization, Oracle and SQL.
Expertise in Business Analytic tools such as Tableau and Power BI
Deep understanding of Data warehousing, Data Modelling, SDLC, Oracle and SQL
Hands-on involvement in business requirement gathering, data analysis, process mapping, solution design, deployment process and maintenance support.
Good at analysing data and reporting issues and finding workarounds and providing timely required solutions to the issues.
Ability to work in a complex, cross-functional issues and deadline-oriented environment and under minimal supervision.
Good knowledge of quality related processes and project management activities.
Excellent communication skills, adapt in client interaction and understanding business applications.
Pro-actively identify areas of opportunity and work to finding solutions that meet the business needs of the customer.
Absolutely capable of working in a fast paced, dynamic, team-oriented environment with 24x7 support.
HIGHLIGHTS
Expertise in executing end to end BI reporting solution from feasibility study to post production support.
Worked in BI Implementation using Tableau and Power BI.
Analyse the data and prepare interactive dashboards/visualization using Tableau and Power BI
Conducting essential meetings with the Clients to incorporate the
Performing RC analysis of product failures in testing.
Manage scrum as a Scrum Master for other teams
Managing and mentoring the team of 8 members
Efficient in writing complex SQL queries to improve performance
Knowledgeable about QC, JIRA and Jile for project life cycle WORK EXPERIENCE
Business Data Analyst/Scrum Master
June 2019 till date
Project: Executive Services Group, TCS Ltd
The project is mainly focused on the applications that cater to the Executive Services Group (CXOs of the companies). The major applications include o Perspectives – This app features articles from TCS Perspectives, the thought leadership management journal which include articles on management and trending technologies along with infographics and videos, available on Alexa, iOS and Android platform.
o BoardApp – an application supported on iOS platform used by Board members for accessing their data and also during the Board meetings on their iPads.
o AGM application – a digital application used to conduct the Annual General Meeting of our clients.
Roles and Responsibilities
Collaborated closely with design, development and project management teams to ensure proper requirement has been gathered and analysed for reports development.
Interacted with Strategic Development Team, Business analyst and Managers to analyse business needs and developed technical specifications
Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
Communicated with clients and stakeholders to test for client requirements correctly.
analysed results and documented findings for presentation at project team meetings.
Recommended changes to make data tables for improving performance of the reports.
Approached applications from a client and end-user perspective.
To create attractive dashboards as per business requirement
To schedule reports and validation
To do QA and PROD move and prepare release docs
Managing BI developer team and Scrum team for various releases Tools Used:
Jile, Jira, QC/ALM, PostgreSQL(Database), Tableau, Power BI Technologies
PostgreSQL, Oracle, Power BI(DAX), Tableau
Business Data Analyst
Oct 2016 to May 2019
Project: General Electric Core Accounting Receivables System The Project deals with providing the account receivables features across all the verticals of GE Businesses, it is a web application providing functionalities for Collection, Cash application, Dunning, Statements, Customers, invoice etc.
Roles and Responsibilities
To improve report performance and create a virtual layer for Tableau
To do a data analysis & designing robust data model for effective exposure management reporting.
To create multiple data sources and prepare base view and derived view from multiple data sources and design a complete data model and Star Schema in Database
To create report wise data elements, Calculated Columns and Measure
To do QA and PROD and prepare release docs
Fix report issues raised by the end user & solve UAT Issues for new Reports
Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support
Developed cross table, Bar chart, Tree map and complex reports which involved creating calculated fields
Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Restricted data for particular users using Row level security and User filters.
Developed Tableau visualizations and dashboards using Tableau Desktop.
Developed Tableau workbooks from multiple data sources using Data Blending.
Create calculated fields, dashboards, and use of filters, parameters, LODs and actions with Tableau
Tools Used:
Jira, QC/ALM, PL/SQL(Database), Tableau, Confluence, Smartsheet Technologies
Tableau,SQL,db2,PL/SQL,Datawarehousing
Business Analyst/SQL Developer
Jan 2014 to Sep 2016
Project: General Electric
The Project deals with providing testing support to various verticals of GE Business like Healthcare, Aviation, Oil & Gas. Vast exposure to multiple domains like BFS, CRM, CM etc. Roles and Responsibilities
Quick and Adaptive in understanding various businesses and domains across GE Business
Work with various development team across various technology
Led data migration & aggregation of over 5M records from 5 different sources into Oracle General Ledger
Work with SQL and SAS for developing and implementing the data collection
Developed SQL procedures for improving migration processes which reduced processing time to 40%
Developed monthly visualization dashboards and reports for progress tracking and led the presentation of key findings to senior leadership for future improvements
Developed Six Sigma aligned process improvements leading to budget savings of over
$100,000 annually
Work on automated reporting processes for normal and on-demand reports using standard database reporting tools
Tools Used:
Prime, MSSQL and other DB
Technologies
SQL,PL/SQL, HTML, Java Script
Graduate Trainee
Jul 2013 to Dec 2013
Project: ILP(Initial Learning Program) TCS
Roles and Responsibilities
Developing J2EE application
Managing DB
Tools Used:
Netbeans IDE, MSSQL
Technologies
J2EE, SQL
Academic Background:
LIST OF CAREER AWARDS:
Customer Satisfaction Award for outstanding contribution on various GECARS Integration/Migration and Monetization expertise.
On the Spot Award for excellent work for the organization.
Account Pride of the Month
Certificate of Excellence Award
TRAINING / CERTIFICATIONS
Professional Scrum Master (PSM 1) certified
Tableau A-Z Hands on Certification
Power BI Complete Introduction Certification
Power BI A-Z Hands on Certification
Six sigma Green Belt certified
Inspire to lead certified
Agile Way of Working
ITIL and Service Lifecycle
Course / Qualification Board / University Year of passing MCA Delhi University/IGNOU June 2017
B.Sc. (I.T) Mumbai University March 2013
PERSONAL BACKGROUND:
Name Akash Rakesh Chaubey
Date Of Birth 09th January 1992
Marital Status Single
Language Known Hindi, English, Marathi
Hobbies Playing Table tennis, Carrom, Reading Novels etc I, HEREBY DECLARE THAT ALL THE INFORMATION IS TRUE TO THE BEST OF MY KNOWLEDGE AND BELIEF.
Akash Chaubey