Lokesh S

Lokesh S

Lead Analytics Consultant (AVP)
India

نبذة عني

Professional experience over 11+ years of progressive and diversified experience in Data Analytics, Business Intelligence, Tableau, Reporting, Visualization, Dashboards, Automation, SQL, SSIS, Agile Scrum & Kanban, GitHu…

الخبرة

Lead Analytics Consultant

Wells Fargo Pvt LTd
May 2019 - حتى الآن · 7 سنوات 2 أشهر

Lead BI and Tableau Architect projects as expert
in delivering high quality analysis, reports, and
insights. Provide influence and leadership in the
identification of new tools and methods to analyze
data
o Responsible for development, productionalization
and maintenance of Tableau Dashboards & Reports
in various BI platforms Tableau, SSIS and
implement business requirements that cover
version control of the processes and business
development activities
o Work on multiple projects and ensures that the
work products and processes of the project teams
meet the defined standards. Pro-actively deliver
end users expectations and establish priorities.
o Skilled in understanding of both the business and
the technical aspects of BI. Drive the completion of
projects within the established scope, while
simultaneously planning for and managing
unknown future BI requirements in a dynamic
environment.
o Develop new Tableau dashboards with
appropriate visualizations, actionable insights, SSIS
sql reports, excel VBA macro reports, ad hoc reports
analyses to make recommendations as BI solution.
Ensures adherence to data management and data
governance regulations and policies.
o Executing and modifying Python Jupyter notebook
packages, creating SSIS packages for optimizing
and joining multiple tables into one data structure
for the advanced tableau reports.
o Worked on several POCs as BI architect with end
to end of the Project, many of them accepted and
migrated to BAU as monthly and quarterly reports
o Executing on the full lifecycle of projects including
creating requirements with business partners,
managing the project, data acquisition, problemsolving
skills, utilizing appropriate analytical
approaches, build along with presentation to
business partners.
o Collaborate and consult with experienced
managers, compliance, and technology to resolve
production issues, modelling, forecasting and
achieve analytic and reporting goals
o Provide information and business intelligence
strategies across all line of business and translate
into structured analysis and providing business
insights
o Research, Performance tuning and development
of various projects with a demonstrated track
record of successful problem solving across all Line
of Business

Lead Analytics Consultant (AVP)

Wells Fargo India Solutions Pvt. Ltd.
Jan 2019 - Jan 2024 · 5 سنوات

Lead BI and Tableau Architect projects as expert in delivering high quality analysis, reports, and insights.
Provide influence and leadership in the identification of new tools and methods to analyze data.
Responsible for development, productionalization and maintenance of Tableau Dashboards & Reports in various BI platforms Tableau, SSIS and implement business requirements that cover version control of the processes and business development activities.
Work on multiple projects and ensures that the work products and processes of the project teams meet the defined standards.
Pro-actively deliver end users expectations and establish priorities.
Skilled in understanding of both the business and the technical aspects of BI.
Drive the completion of projects within the established scope, while simultaneously planning for and managing unknown future BI requirements in a dynamic environment.
Develop new Tableau dashboards with appropriate visualizations, actionable insights, SSIS sql reports, excel VBA macro reports, ad hoc reports analyses to make recommendations as BI solution.
Ensures adherence to data management and data governance regulations and policies.
Executing and modifying Python Jupyter notebook packages, creating SSIS packages for optimizing and joining multiple tables into one data structure for the advanced tableau reports.
Worked on several POCs as BI architect with end to end of the Project, many of them accepted and migrated to BAU as monthly and quarterly reports.
Executing on the full lifecycle of projects including creating requirements with business partners, managing the project, data acquisition, problem-solving skills, utilizing appropriate analytical approaches, build along with presentation to business partners.
Collaborate and consult with experienced managers, compliance, and technology to resolve production issues, modelling, forecasting and achieve analytic and reporting goals.
Provide information and business intelligence strategies across all line of business and translate into structured analysis and providing business insights.
Research, Performance tuning and development of various projects with a demonstrated track record of successful problem solving across all Line of Business.

Business Intelligence Analyst

Applied Materials Contract Based from Adecco
Jan 2018 - Jan 2019 · 1 سنة

Design and Developing Tableau Dashboards with appropriate data sources, by using Actions, Quick filters, Parameters, SQLs, calculation fields.
Worked on several data analytical projects, Purchase Price Variance, Tail Spend Management, Payment term Analysis, Vendor Rationalization, PO Consolidation, Invoice Consolidation analyses, Compliance reports, DPO days analysis, Cash flow, P&L analysis and ad-hoc requirements.
Use BI tools such as Tableau, SQL, Impala(Hadoop)-type tools, Excel/Access, etc. and develop business cases, and complete root cause analyses.
Performance Monitoring, fine-tuning and optimization of Tableau dashboards.
Utilize big data (Hadoop) analytics and advanced data science techniques to identify trends, patterns, and discrepancies in data.
Determine additional data needed to support insights.
Expertise in migrating Tableau dashboards from Dev to QA, QA to Prod environments, worked on Proof of concepts (POC???s) of new projects.
Worked as Individual contributor for the business and delivered analytical analysis reports and ad-hoc business reports with dashboard in very short time and awarded by stakeholders.

Analytics Advisory Analyst Business Intelligence

Accenture
Jan 2015 - Jan 2018 · 3 سنوات

Primarily data gathering, analysis reporting, selecting features, building and optimizing dashboards, reports using analytical skills.
Gather reporting requirements from various stakeholders within the company, architect the solution/report and deliver the analytical reports in timely manner.
Creating different Visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles Charts etc. based on business requirement.
Take up Projects, creating Spend Analysis, data Profile, show-case the analysis to identify the opportunity, Reporting, visualization dashboards with different Insights and views.
Creating Tableau Dashboards using appropriate Visualizations, Advanced Navigation techniques, customizing dimensions using calculations / other functions and Level of Detail expressions.
Created multiple data analysis on Excel dashboards with quick automation for adhoc requirements by stakeholders.
Identify the opportunities in Procurement and operations by initiating Descriptive Analytics, Spend Analytics, PPV, Predictive Analytics & Designing to deliver in high performance.
Identify Automation for the process, creating MS-Excel VBA automation for the required reports & creating various dashboards (PPT and Excel) to reduce the cost of the process.

Supply Chain Inventory (Analytics Officer)

Tesco HSC
Jan 2013 - Jan 2015 · 2 سنوات

Data analysis, data profiling, data classification create management dashboard with opportunity analysis.
Provide Insights on PO Spend, Invoices Spend, Contracts, Scorecards, Automations, Concur Reports, Spend Analysis, Contracts Analysis.
Understanding of Business parameters and drivers and the ability to articulate technology issues in Business terms and vice-versa.
Identify relevant industry trends, market conditions, and gather knowledge of market leaders.
Advise key client on supply market trends (key competitor activity, effect of technology in accelerating globalization, collaboration, risks, and new service offerings).
Works with others in the development of data warehouses and other data sources to support managerial and business intelligence reporting needs.
Automate standard and ad-hoc reports with business analysis dashboard.

Practitioner Procurement & Supply Chain (Contract Based).

IBM
Jan 2012 - Jan 2013 · 1 سنة

Create Monthly analysis reports with (Category and Vendor specification) based on client requirement.
Show-case the various views to identify the shrinkage of spend.
Automating the SLA reports, Monthly reports by using MS-Excel VBA coding, formulas and designing excel and PPT dashboards.
Work on MDM for supplier maintenance and defining the active vendors and rationalizing the in-active and duplicate vendors from the database.
Handling Compliance and Benefits report with the analysis, show-case dashboards with the visualization graphs and charts.

المهارات

التحليلات تحليلات الأعمال بايثون (لغة برمجة) لغة الاستعلامات الهيكلية (SQL) لوحات المعلومات تنقية البيانات إكسل VBA التصور البياني للبيانات تابلو SQL DBA VBA Excel Data Analytics Business Intelligence Visualization Reporting Jupyter Notebook Agile Scrum Methodology SSIS ETL Advanced Excel Dashboard Development Spend Analytics Supply Chain Management Procurement Headcount Reporting Projects Management Savings Analytics SAP Oracle Workday Salesforce MDM Data Governance GitHub Kanban Reporting Automation Data Mining Presentation Skills Data Modeling Data Warehousing Performance Tuning Optimization Hadoop Impala Excel Access Power BI
الإبلاغ عن هذا الملف الشخصي؟