Lakshmi Janardhanan

adwyjq@r.postjobfree.com Cell: 408-***-****

Summary:

• Business Intelligence /Data/Systems Analyst with 10+ years of extensive and diversified experience in IT, Banking & Financial Services with specialization in BI, ETL and Data Warehousing applications

• Knowledge of Dashboard & Report creation and analytical concepts using OBIEE, Tableau, SAP BOBJ & POWER BI

• Possess excellent business acumen to understand the requirements & well-versed in communicating with the upper management level.

• Experienced in gathering user requirements, analyzing and preparing Project Deliverables such as Business Requirement Document (BRD) and Functional Specification Document (FSD) for proposed changes/ process improvement.

• Document meetings in Agendas, Meeting Minutes and action items.

• Excellent exposure in the BI/Data Warehouse environment with hands on exposure to a broad range of tools including OBIEE (11g & 12 c), Tableau.

• Proficient in CRM systems-Salesforce &Siebel

• Solid exposure to end-to-end project lifecycle business analysis especially Business Acceptance Testing (BAT) & User Acceptance Testing (UAT).

• Extensive experience in conducting Data Analyses and Reporting on KPI Metrics

• Designed and implemented SQL queries for testing and report/data validation using various SQL clients including TOAD, SQL server Management Studio.

• MS EXCEL –Highly proficient at spreadsheet modeling, Pivot Tables, Lookup Functions & Macros.

• Proficient in transforming business requirements into functional specifications, focusing on workflow analysis and design, business process reengineering, UI design and process flow modeling.

• Highly adept at working with users and stakeholders to elicit, analyze, communicate and validate requirements and Brainstorming sessions to identify Functional, Non-Functional, and Business Rules, and then subsequently model them.

• Excellent exposure to customer interfacing roles.

• Hands on experience with MS Visio to create Use Cases & Process Flow Diagrams.

• Demonstrated ability to work actively in different phases of Software Development Life Cycle (SDLC) using Waterfall and Agile methodologies (SCRUM), in multi-tier web-based architecture.

• Expertise in broad range of technologies, including business process tools such as Microsoft PowerPoint, MS Excel, MS Access & MS Visio.

• Developed SQL scripts to Insert, Update, Delete and Merge data in the database tables along with SQL Joins.

• Comprehensive experience in SWOT analysis and GAP analysis.

Education:

• M.B.A Finance Notre Dame De Namur University, CA 2009.

• Microsoft Certified Tableau Desktop Specialist

Professional Experience:

VMWARE Feb 2022- Present

Lead BI Analyst-SAAS Analytics

Description: Lead a team of data scientists & business intelligence analysts supporting key processes in Sales, Finance & Operations.

Responsibilities:

•Collaborate with end user, business partners and engineering team to identify and analyze BI information needs and opportunities for improved data management and delivery.

•Improve and streamline processes of data flow and data quality to improve data accuracy, viability and value.

•The streamline process has improved department efficiency by up to 70%.

•Design and develop analysis methodology to ensure data quality, reporting dashboard, and visualization via Tableau/SAP BOBJ to propose innovative ideas and eliminated hidden risk.

•Develop statistical models to data mining to best practices in data visualization, self-service BI and anomaly-detection, and presented story to assist upper management decision.

•Design and built visually rich applications and dashboards to measure, track, and display key business metric Designed and built tools and automations that scale critical business processes.

•Manage the ongoing development and operations of a business intelligence architecture that enables fact-based decision making and ad hoc analysis and insight generation by various tools i.e.

Environment: SQL Server, SFDC, Tableau, SAP BOBJ, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio

Fisec Global Jan 2020- Aug 2020

Sr. Reporting Analyst

Description: Lead the business/data analysis to support In house Sales Ops Team by developing key business insights with needed business data analysis

Responsibilities:

• Assist the users to generate Reports especially related to Sales Operations Subject Area

• Excellent exposure to CRM applications-SFDC&SIEBEL

• Manage all Bookings/Billings/Revenue related Reporting and assist with data reconciliations.

• Develop reports/dashboards using Tableau

• Analyze and interpret data to identify trends or patterns, and solutions, including transcripts of focus groups and surveys.

• Perform long-term ethnographic research in business office environments to study product or service viability in the workplace.

Environment: SQL Server, SFDC, Tableau, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio

Cisco Systems, Santa Clara, CA May 2019-Dec 2019

Sr. Business Data Analyst-BI

Description: Lead the business/data analysis to support Cisco Services Team by developing key business insights with needed business data analysis

Responsibilities:

• Function as a liaison with cross-functional teams like IT & Sales Operations business units to perform business and system analysis

• Involved in analysis of Sales Renewal & Retention KPI Metrics.

• Assist the users to generate Reports especially related to Sales Operations Subject Area

• Development & Analysis of documentation, BI dash boards and reports of key metrics to measure Sales GTM progress; namely, Renewals, Bookings etc.

• Gather requirements for new Reports as well as enhancements to existing Reports. Identify metrics, develop & generate reporting processes to track key business indicators and metrics for Business Process Design efforts.

• Analyzing, designing SQL for reporting structure and funds reconciled data validations in databases Oracle, SQL Server.

• Identify and provide analysis around resource or process gaps, business indicators and metrics

•

Environment: SQL Server, SFDC, Tableau, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio)

Datastax, Santa Clara, CA Aug 2018-Oct 2018

Sr. Tableau Consultant/BI Analyst

Description: At Datastax BI Team to build a comprehensive Go-To-Market Dashboard using Tableau and SFDC Data.

Responsibilities:

• Develop Tableau reports that provide clear visualizations of various industry specific KPIs.

• Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.

• Develop prioritized reports/dashboards using Tableau

• Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.

• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, joins, data blending, and dashboard actions.

Equinix, Sunnyvale, CA Aug 2017– July 2018

Sr. BI Business System Analyst

Description: Assist Equinix Business Intelligence Team with a Comprehensive Dashboard development for multiple Global Businesses and Functions. This role is for especially supporting the Sales Operations & Corp FP&A Teams conducting data analysis & assisting with needed business analysis.

Responsibilities:

• Function as a liaison with cross-functional teams like IT & Sales Operations business units to perform business and system analysis

• Involved in analysis of Worldwide Partner Compensation Reporting & Monthly Revenue Reconciliation

• Assist the users to generate Reports especially related to Sales Operations Subject Area

• Excellent exposure to CRM applications-SFDC&SIEBEL

• Manage all Bookings/Billings/Revenue related Reporting and assist with data reconciliations.

• Provide business analytical support with OBIEE, Tableau and data warehousing solutions

• Identify the data requirement list and analyze the data to be extracted or added from the data warehouse in an OBIEE environment

• Administer and analyze the reporting and analysis development, implementation and changes according to the enterprise objectives

• Oversee the project performance, status and administrative process throughout the life cycle of the project.

• Directly interact with the client to conduct meetings, presentations and status report projection

• Work in collaboration with IT, administrative, development teams and other business stakeholders to maintain cooperative relation and translate plans into action

• Available to resolve analytical problems and reporting needs of OBIEE and data warehouse applications.

• Specialize in developing SQL queries with hands on experience in writing complex queries for staging clean data sets to front end web applications.

• Develop and maintain documentation, BI dash boards and reports

• Train new joinees, other business analysts or data warehouse and development teams

• Work closely with development team to triage any existing data discrepancies

• Report on KPI package with key metrics from all departments to executive team to support strategic decisions.

• Involved in writing SQL queries for Data Analysis & Validation.

• Conduct data validations to ensure data accuracy between source systems.

• Gather requirements for new Reports as well as enhancements to existing Reports.

• Maintain OBIEE data level security for all the Regions.

• Involve in assisting building detailed project schedule, gathering the requirement, complete the proof of concept in translating functional requirements into technical requirements

• Identify metrics, develop & generate reporting processes to track key business indicators and metrics for Business Process Design efforts

• Update Clarizen to manage project deliverables in a timely manner

• Train the users on how to use the Respective Subject Areas & Dashboards and the artifacts to modify the canned Reports as well as new ad hoc Reports.

Environment: SQL Server, Siebel CRM, SFDC, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio)

VERITAS, Mountain view, CA Aug 2016– Jan 2017

Sr. BI/Business Analyst

Description:

Assist Veritas Business Intelligence Team with a Comprehensive Dashboard development for multiple Global Businesses and Functions. This role is for especially supporting the Corporate FP&A conducting data analysis & assisting with needed business analysis.

Responsibilities:

• Function as a liaison with cross-functional teams like IT & Finance Transformation business units to perform business and system analysis

• Assist the users to generate Reports especially related to Finance Subject Areas-GL/AP/AR/FA

• Manage all Bookings/Billings/Revenue related Reporting and assist with data reconciliations.

• Provide business analytical support with OBIEE and data warehousing solutions

• Identify the data requirement list and analyze the data to be extracted or added from the data warehouse in an OBIEE environment

• Administer and analyze the reporting and analysis development, implementation and changes according to the enterprise objectives

• Oversee the project performance, status and administrative process throughout the life cycle of the project.

• Directly interact with the client to conduct meetings, presentations and status report projection

• Work in collaboration with IT, administrative, development teams and other business stakeholders to maintain cooperative relation and translate plans into action

• Available to resolve analytical problems and reporting needs of OBIEE and data warehouse applications.

• Develop and maintain documentation, BI dash boards and reports

• Train new joiners, other business analysts or data warehouse and development teams

• Work closely with development team to triage any existing data discrepancies

• Report on KPI package with key metrics from all departments to executive team to support strategic decisions

• Conduct data validations to ensure data accuracy between source systems.

• Gather requirements for new Reports as well as enhancements to existing Reports.

• Maintain OBIEE data level security for the entire Finance Team.

• Perform Business Acceptance Testing (BAT) to verify requirements and business solution and supported User Acceptance Testing (UAT)

• Create Answers, Dashboards, and ad-hoc Reports using the Oracle Business Intelligence Analytics (OBIEE) platform as well as Hyperion as per user requirement.

• Create SQL queries to pull out data and metrics from the database

• Solid exposure to various aspects of OBIEE tool OBIEE Answers/Analysis, OBIEE Dashboards, and Scheduling Agents in requirements analysis.

• Involve in assisting building detailed project schedule, gathering the requirement, complete the proof of concept in translating functional requirements into technical requirements

• Identify metrics, develop & generate reporting processes to track key business indicators and metrics for Business Process Design efforts

• WIKI Doc Maintenance to manage project deliverables in a timely manner

• Train the users on how to use the Respective Subject Areas & Dashboards and the artifacts to modify the canned Reports as well as new ad hoc Reports.

Environment: SQL Server, Oracle E Business Suite, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), Hyperion, OBIEE, Workday

SYNAPTICS, San Jose, CA Feb 2016-July 2016

Sr. BI/Data Analyst

Description:

Assist Synaptics Data Management Team with a Comprehensive Dashboard development for multiple Global Businesses and Functions. This role is for supporting the Group Data Manager in conducting data analysis & assisting with needed business analysis for Finance& Sales Operations Teams.

Responsibilities:

• Function as a liaison with cross-functional teams like Sales, Finance& Business Operations business units to perform business and system analysis

• Manage all Billings/Revenue related Reporting and assist with data reconciliations.

• Work closely with development team to triage any existing data discrepancies

• Report on KPI package with key metrics from all departments to executive team to support strategic decisions

• Conduct data validations to ensure data accuracy between source systems.

• Gather requirements for new Reports as well as enhancements to existing Reports.

• Maintain data level security for the entire Finance Team.

• Perform Business Acceptance Testing (BAT) to verify requirements and business solution and supported User Acceptance Testing (UAT)

• Create Answers, Dashboards, and ad-hoc Reports using the Oracle Business Intelligence Analytics (OBIEE) platform as well as Business Objects as per user requirement.

• Generate BO Web Intelligence as per user requirements

• Create SQL queries to pull out data and metrics from the database

• Solid exposure to various aspects of OBIEE tool OBIEE Answers, OBIEE Dashboards, in requirements analysis.

• Involve in assisting building detailed project schedule, gathering the requirement, complete the proof of concept in translating functional requirements into technical requirements

• Identify metrics, develop & generate reporting processes to track key business indicators and metrics for Business Process Design efforts

• WIKI Doc Maintenance to manage project deliverables in a timely manner

• Conduct weekly calls to address Reporting queries & concerns for the various program Segment Leads.

• Train the users on how to use the Dashboards and Answers and modify the stored reports in Answers

Environment: SQL Server, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), Hyperion, OBIEE

Cisco Systems, San Jose, CA Sept 2013– Aug 2014

Sr. Business Data Analyst

Description:

Responsible for driving the business data analysis for Supply Chain/Service Compliance for the Entitlement Services Enablement team. Key contributor for the Business Intelligence team providing metrics for the Services Entitlement team overall.

Responsibilities:

• Function as a BI analyst Team Lead/Program Manager to create complex reports, charts, pivot tables and visually appealing dashboards.

• Create SQL queries to pull out data and metrics from the database

• Create Current and Future state diagrams and process flows, BRD for business and supporting technology teams.

• Perform Business Acceptance Testing (BAT) to verify requirements and business solution and supported User Acceptance Testing (UAT)

• Possess very good understanding of the RMA and TAC business processes and systems

• Conduct extensive RMA & TAC Exceptions Data analysis

• Create Answers, Dashboards, and ad-hoc Reports using the Oracle Business Intelligence Analytics (OBIEE) platform as well as Business Objects as per user requirement.

• Generate BO Web Intelligence & Crystal Reports as per user requirements

• Solid exposure to various aspects of OBIEE tool including OBIEE Answers, OBIEE Dashboards, in requirements analysis.

• Involve in assisting building detailed project schedule, gathering the requirement, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts.

• Possess Good knowledge in developing Scorecards and KPI's.

• Work closely with various Theater Point of Contacts including Americas, Public Sector & EMEA to support their reporting needs.

• Conduct weekly calls to address Compliance Reporting queries & concerns for the various program Segment Leads.

• Train the users on how to use the Dashboards and Answers and modify the stored reports in Answers

• WebEx Social Site & Cisco Doc Maintenance to manage project deliverables in a timely manner

• Work closely with Sales, Marketing business units as well as on the Partner Space to perform business and system analysis

Environment: SQL Server, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), Business Objects, OBIEE

Cisco Systems, San Jose, CA Apr 2012– Aug 2013

Sr. Business Data Analyst

Description:

Lead the business/data analysis for Service Delivery project to enhance existing TAC services portfolio to offer differentiation for new SMART business offers like SmartNet Total Care (SNTC) and Partner Support Services (PSS). Primarily responsible for designing the Entitlement Requirements Engineering for the project for general availability phase.

Responsibilities:

• Maintain Weekly reports, Change Management documentation, project plans, and project minutes of meeting.

• Analyze Survey Results and conduct trend analysis

• Develop parameters of and maintain standard dashboard for KPI measurement on a weekly reporting cycle.

• Create Current and Future state diagrams and process flows, BRD, FSD for business and supporting technology teams.

• Act as SME (Subject Matter Expert) and liaison, supplying business knowledge and functional recommendations and evaluation input to technology development teams.

• Responsible for customer onboarding/contract Management process analysis through CSCC

• Possess knowledge & familiarity with Cisco RMA process & service compliance

• Use expert knowledge to understand customer business requirements, translate them into technical requirements and map these to differentiated value proposition.

• Help drive business process design efforts through requirements analysis and information gathering

• Take ownership of key deliverables to help facilitate the transformation of Service Delivery best practices

• Assist with cost/effort estimates in collaboration with IT and Business Partners

• Quantifying the value of business case and Service Delivery opportunities Acquired a solid understanding of business/financial modeling and business case development

• Maintain & improve Customer Support Engineer Workflow in MyWorkZone which is maintained in SFDC.

• Perform Business Acceptance Testing (BAT) to verify requirements and business solution and supported User Acceptance Testing (UAT)

• Support Change Management team to develop impacts on Customer & Partner Experience

• WebEx Social Site & Cisco Doc Maintenance to manage project deliverables in a timely manner

Environment: UML, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), BRE (Business Rules Engine), Business Objects, Pentaho, CSOne, Salesforce

Telenav, CA May 2010– Aug 2010

Business Data Analyst

Description:

Telenav provides various financial products and services to consumers, small businesses, and commercial clients. The Project consisted of designing and implementing an integrated CRM solution for Telenav to have an improved Field Productivity, manage Real time Forecast and improved quoting functions – configuration, pricing, approvals, proposal generation, offline capability, channel enablement and online storefronts. Also tightened company security model using SFDC and client specific data

Responsibilities:

• Gathered requirements from stakeholders and product team that gave a clear idea of the requirements to the development team

• Participated in the identification, understanding, and documentation of business requirements, keeping in mind the need for the application based on the project scope and SDLC methodology

• Documented and supported the requirements to develop the platform which enables the user to monitor his/her accounts, provides at-a-glance balances and positions, order status, account reporting, grouping accounts

• Documented and supported the requirements to develop the platform which enables the user to monitor his/her accounts, provides at-a-glance balances and positions, order status, account reporting, grouping accounts

• Extensively used SQL for querying underlying database tables and resolving data issues.

• Conducted data modeling and data mapping for reporting data elements

• Instituted best practices for content management.

• Generated Requirements Traceability Matrix.

• Reviewed Project Charter, BRD and FSD to ensure all business requirements were documented.

• Interacted with executive sponsors to identify business requirements, project objectives and implement scope changes.

• Reviewed final user interface.

• Managed and scheduled project responsibilities through MS Project.

• Involved in the documentation of Use and Test Cases to test specific functionalities of the application.

• Facilitated discussions to anticipate future needs, requirements and opportunities.

• Assisted the Project Manager in preparing final presentation and training materials.

Environment: Apex, Visual Force (Pages, Component & Controllers), Pages, Data Loader, HTML, XML, Java Script, CSS, Workflow & Approvals, Reports, Custom Objects, Email Services, Security Controls, Sandbox data loading, Eclipse IDE Plug-in

Stanford University, CA Aug 2009– Dec 2009

Business Analyst Intern

Description:

Worked as a Business Analyst for the Business and Finance Applications team. In this role, worked along-side operations and technical clinical management to implement, administer and support systems and jointly lead projects and provided ongoing support.

Responsibilities:

• Experienced working both independently and in a team-oriented, collaborative environment

• Worked with upper management to hash out issues

• Conducted user interviews, gathered, analyzed and documented business requirements.

• Documented Project Charter, BRD and FSD.

• Developed GAP Analysis in Microsoft Visio to identify the AS-IS and TO-BE situation.

• Created Communication Matrix and participated in Risk Analysis meetings.

• Established Work Breakdown Structure and tracked progress of major milestones in MS Project.

• Participated in JAD sessions with management, users, developers and other stakeholders.

• Created Use Cases and UML models using VISIO.

• Performed User Acceptance Testing (UAT).

• Assisted the Project Manager in setting realistic project goals and expectations.

• Conducted weekly status meetings.

• Managed release calendar to prioritize the completion of major milestones.

Environment: HTML, XML, MS Visio, MS SharePoint, Windows XP, Agile Environment

Contact this candidate