SUMMARY:

• Business/Data Analyst with over 7 years of experience with an understanding of Business Process Flows, Business Process Improvement and Business Analysis in Marketing, Ecommerce, Telecom and Banking Domain.
• Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information using Confidential Dashboards and Tableau.
• Expertise in SQL Queries
• In - depth analysis and use of standardized business analysis techniques such as Coverage matrix, traceability matrix and GAP analysis
• Experienced in designing UI prototypes (Mock Ups, Wireframes) that were presented to the business.
• Proficient in MS Office Excel/LibreOffice Calc / Confidential Sheets (pivot tables, vlookups, hlookups, macro), Access, PowerPoint, Visio.
• Comprehensive knowledge of business processes, with hands on experience on Software Development Life Cycle (SDLC) and various methodologies like Waterfall and AGILE SCRUM
• Experienced in Project management tools like MS project, MS excel
• Project management experience involves delegating responsibilities, budgeting, designing time schedules and work breakdown structures (WBS), preparing weekly status reports for management, communicating and presenting the reports, and resolving issues and conflicts.
• Experience in writing test plans, test cases, generate test scripts and maintain reports for defect tracking
• Excellent in verbal and written communication, organizational skills combined with the ability to work in a fast-paced environment as an individual and/or as a team member

TECHNICAL SKILLS:

Business Skills: Business Requirement Definition, Business Process Analysis, Use Case Modelling & Analysis, GAP Analysis

Business Modelling Tools: Rational Rose, Microsoft Visio, MS Project, UML, Office 365

Confidential specific tools and DB: G Suite, Confidential Docs, Confidential sheets, Confidential Slides, Confidential, CNS, Dremel, F1

Relational Databases: GoogleSQL, Dremel, SQL Server, Oracle

Methodologies: Waterfall, Agile

Microsoft Tools: MS Word, MS Excel, MS PowerPoint, MS Project

BI/Reporting Tools: Business Objects, SSIS, LibreOffice, Tableau

Testing Tools: HP Quality Center

Web Authoring: HTML, XML, Balsamiq

ITSM Tools: BMC Remedy, ServiceNow

Defect Tracking Tools: Jira, Rally, Bugzilla

Languages: C++, Javascript, Unix

PROFESSIONAL EXPERIENCE:

Confidential

Sales Insights Analyst

Responsibilities:

• Identified, analyzed and built large data pipelines for 15+ dashboards used by 6000+ Confidential Sales users to measure their compensation and performance.
• Analyzed, identified and recommended improvement strategies in the Buganizer tool which drastically reduced the number of bugs by 27% monthly.
• Assisted PSA Insights in operationalizing pipelines through check in and environmentalization.
• Presented these dashboards to higher management.
• Achieved functionality and reliability parity between Taskmaster team details dashboard and Smart Home Page.
• Created a Points Analysis Dashboard which enabled users to measure their compensation worth $4.9 million for over 2000+ Sellers from America, EMEA and APAC.
• Created Smart Home Page cards in collaboration with cross-functional engineering teams for Confidential Sales team which enabled them to see all the important metrics on one page instead of opening multiple dashboards.

Confidential

Product Analyst

Responsibilities:

• Migrated 50 million Adwords data records from Confidential 's Contract Management System based in BMC Remedy to Confidential Cloud using CNS and Confidential which enabled in saving 400 hours of Confidential 's Legal Team.
• Accountable for analyzing the complex and large data-sets and thereby creating reports in Microsoft Excel (using vlookups, functions), LibreOffice and Confidential Sheets.
• Created a visually impactful dashboard for Confidential Payments group which was based on Confidential Play Apps, Confidential Wallet and Android Pay and provided data on Top iOS /Android apps based on downloads/ active users using the data downloaded from App Annie
• Created a time series chart which displayed numerous KPI's to find Android pay / Confidential wallet crash rates.
• Performed ad-hoc analysis on a variety of data-sets, using variety of tools, such as SQL, Confidential, Dremel,F1,CNS.

Confidential

Business Analyst

Responsibilities:

• Retrieved, analyzed and reported necessary data for supply chain metrics in identification of root cause for continuous performance improvement.
• Proposed and implemented new data collection system which increased efficiency in collecting valid information by 80%.
• Assessed the quality of the data using SQL queries and Excel.
• Analyzed 700GB of weekly logistics data using Time Series Analysis to predict product future demand which improved Inventory Turnover Ratio by 25%.
• Perform ad-hoc analysis and create excel models to support business decisions and evaluation of new opportunities.

Confidential

Systems Analyst

Responsibilities:

• Worked with and shared insights among various functions, including Product, Engineering and Executive teams.
• Worked with DBA to create Best-Fit Physical Data Model from the Logical Data Model.
• Performed data analysis of existing database to understand the data flow and business rules applied to Different databases using SQL.
• Developed, managed and validated existing data models including logical and physical models of the data warehouse and source systems utilizing a 3NFmodel.
• Performed data analysis and data-profiling using complex SQL on various sources systems including Oracle, SQL Server
• Project planned, supported, and achieved migration of Foundation data
• Involved in planning and execution of cleaning almost 30 million of data and recommend actionable root causes
• Collaborate with Client Service Operations team to build dashboards to track team performance.
• Established Key Performance Indicators (KPIs) to analyze Service Desk performance, activities, and documented resolutions, identify problem areas to proactively prevent future problems.

Confidential

Product Analyst

Responsibilities:

• Proposed solutions to improve system efficiencies and reduce total expenses by removing manual tools that were unnecessary.
• Laid the foundation for developing project plans and roadmap for strategic plan implementation.
• Developed scope of work, and managed end to end project work plans in alignment with the strategic goals.
• Conducted meetings with all project managers to assess and report progress to all stakeholders in executive leadership.
• Created RACI (Responsible, Accountable, Consulted and Informed) matrices which helped in implementation & correct functioning of the operational processes.
• Understanding clients' information needs, business objectives, and market sectors and implementing appropriate data analysis strategies.
• Coordinated with DBA on database build and table normalizations and de-normalizations.

Business Analyst

Responsibilities:

• Gathered business, system, and functional requirements by conducting detailed interviews with business users, stakeholders, cross functional teams and Subject Matter Experts (SME’s).
• Communicated product vision and strategy to internal and external stakeholders.
• Created high-level process flows for as-is and to-be processes and performed Gap Analysis.
• Coordinated with Business Analyst and designed logical and physical data models as per the requirements.
• Analyzed, identified, and documented project risks, issues, and constraints for business functional requests by internal clients on system design and capabilities.
• Documented logical, physical, relational and dimensional data models. Designed the Data Marts in dimensional data modeling using star and snowflake schemas.
• Used SQL queries to do data analysis and thereby generate reports.
• Assisted the project manager in preparing the project plan, project schedule, resolving issues, milestone tracking and resource allocation using MS Project.
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.