We provide IT Staff Augmentation Services!

Bi Analytics Program Manager/senior Data Analyst Resume

Santa Clara, CA

SUMMARY:

  • BI Analytics Program Manager cum Senior Data Analyst with 11 years of overall IT experience which includes around 8.5 years of experience in data analytics for marketing, global customer support, sales operations and Prof Srvices Revenue.
  • Experienced working in SAP HANA, MSSQL, MYSQL, Business Object Data Services, Mulesoft platform, PL/SQL, Core Java, Hadoop.
  • Experience working as a scrum master. Good knowledge on Agile methodology..
  • Drive quarterly roadmap & resource planning activities and deliverables. Experience managing multiple concurrent major projects
  • Lead planning, execution, and delivery of large cross - functional initiatives.
  • Lead efforts to resolve key project conflicts and establish appropriate resolution paths
  • Excellent Knowledge of Software Development Life cycle (SDLC) and ability to work as a liaison between business users and developers.
  • Strong in analytical and problem solving skills, excellent planning and multi-tasking abilities with proven experience in utilizing people and process knowledge to help enterprise make critical decisions.
  • Experience working with data coming from Salesforce, JIRA, Clarizen, Cornerstone, Omniture etc. Experience working with huge volume of data.
  • Trained on Hadoop Big Data platform. Experience working with Hive, Impala, Kudu database.
  • Experience in design and creation of database and database schema.
  • Experience in Data Modeling techniques employing Data warehousing concepts like star/snowflake schema and Extended Star.
  • Intensive experience in data modeling using SAP HANA.
  • Extensive experience importing and exporting data dump from heterogeneous source and destination.
  • Extensive experience in writing SQL/PL SQL Queries for Data Validation, data modelling and Data Integration.
  • Extensive experience with Data Analysis on Data warehouse system for various reporting systems within an organization.

TECHNICAL SKILLS:

Skills Details: SAP HANA, Business Object Data Services, Mulesoft Integration Platform, SSRS reporting MS Office Suite (Word, Excel, Outlook, PowerPoint, OneNote, MS Office Project, Visio) Statistical skill set Forecasting models, Linear Regression, Statistical Quality control, SWOT analysis, SPSS

MSWindows (2000/XP/NT/Vista): MS SharePoint

Core Java: SAP Netweaver PI

Microsoft Access, MYSQL, SQL Server: HTML, HTTP, XML (XMLSpy)

Salesforce: Salesforce CRM Domain knowledge, Reports and Dashboards Iterative Development and Process Design, Re-engineering, Agile, Kanban Jira, Confluence, Github

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara, CA

BI Analytics Program Manager/Senior Data Analyst

Responsibilities:

  • Run Scrum team as a scrum master. Drive quarterly roadmap & resource planning activities and deliverables.
  • To gather Global Customer Support, Investor Relationship, and Product management business requirement, analyze them and convert them to technical documents. Perform gap analysis, feasibility analysis on a business requirement.
  • Experience working on predictive analytics use cases.
  • Manage multiple concurrent major projects. Lead planning, execution, and delivery of large cross-functional initiatives.
  • Prepare and present program and project status to key business stakeholders at regular intervals.
  • Lead efforts to resolve key project conflicts and establish appropriate resolution paths
  • Design and architect data modeling requirements and act as a liaison to the development team to prepare statistical and analytical reports.
  • Responsible for End to End delivery of projects. Ensure process while deploying projects into production by creating change request in ServiceNow.
  • Supervise development team and review code to quality delivery.
  • Work with Offshore development team and provide business requirement.
  • Involve in Hadoop big data platform initiative which includes technical design solution meetings.
  • To create reports in SAP Business Object Web Intelligence tool and Tableau.
  • Develop data models in SAP HANA platform.
  • Work in the ETL (Extract, Transform and Load) of data into SAP HANA data warehouse and HDFS system using SAP Business Object DataServices, Sqoop and Mulesoft technologies.
  • Working knowledge in Hive, Impala, Kudu database, Python.

Confidential, Santa Clara, CA

Senior BI Analyst

Responsibilities:

  • To gather, analyze, and interpret marketing operation and Product Management data to prepare statistical and analytical reports.
  • To analyze and document all data-related functions to successfully meet business needs, and ensure reliable data is available to create reports.
  • To prepare various Reports for Cross Functional groups using PL SQL, reporting tools like SSRS, MS Access and MS Excel.
  • To perform data conversion, data cleaning, transform and data extract from various legacy systems using both data quality and data integrator part of SAP Business Object Data Services.
  • Develop data models in SAP HANA platform. Create attributes, analytical and calculated graphical/script views.
  • Develop Stored Procedures, functions, writing PL SQL queries.
  • Performed query optimization and database tuning.
  • Worked in the ETL (Extract, Transform and Load) of data into a data warehouse/data mart and Business Intelligence (BI) using SAP Business Object DataServices.
  • Created Data source, Info Object, Data store object, and info cubes in SAP Net Weaver Business Warehouse.
  • To create reports in SAP Business Object Web Intelligence tool and Tableau.
  • To perform data validation and massaging to ensure accuracy and quality of data with the purpose of understanding or making conclusions for final decision.
  • Design and develop relational databases for collecting data and distributing to front end reporting. Wrote Data Definition Language or Data Manipulation Language SQL commands.

Confidential, Fremont, CA

Data Analyst

Responsibilities:

  • To perform business requirements analysis and documentation, work with business to document all data-related functions to successfully meet business needs, and ensure reliable data is available to create reports.
  • To prepare various Reports for Cross Functional groups using PL SQL, reporting tools like SSRS, MS Access and MS Excel.
  • To extract data from SAP and non-SAP systems and load in SAP Net Weaver Business Warehouse by creating Data source, Info Object, Data store object, and info cubes.
  • To perform data validation and massaging to ensure accuracy and quality of data with the purpose of understanding or making conclusions for final decision.
  • To create charts, graphs, tables, design and develop relational databases for collecting data.
  • Involve in analyzing and resolving database related Production support issues.
  • Worked in data migration from Netsuite ERP to SAP ERP.

Confidential, Alameda, CA

Marketing Data Analyst

Responsibilities:

  • To work with data and seek out a variety of information sources to help the business to better understand the big picture.
  • To perform statistical analysis of marketing data extracted from google analytics, google adwords and create reports dashboards out of it.
  • To conduct research and data manipulation, select correct methods for retrieving and analyzing data, develop reports and presentations.
  • To work with external clients to document all data-related functions to successfully meet business needs, and ensure reliable data is available to create reports.
  • To analyze data gathered, develop information and consider available solutions or alternate methods of proceeding.
  • To prepare various Reports for Cross Functional groups using MYSQL, MS SQL, MS Access and MS Excel.
  • To present data in charts, graphs, tables, design and develop relational databases for collecting data.

Confidential

Data Analyst

Responsibilities:

  • Interacted with the executives and development team to liaison the business requirements to ensure that the proposed upgraded application complies with the business requirements.
  • Dedicated Business Intelligent resource for re-architecting existing production databases
  • Extensively used ETL methodology for supporting data extraction, transformations and loading process, in a corporate-wide-ETL Solutions
  • Stored manual and automated tests and their result in Mercury Quality Center.
  • Utilized a variety of reporting tools such as SQL for querying underlying database tables and resolve data issues.
  • Built templates and dashboards for customized views of the data specific to each group and line of business

Environment: Quality center, Quick Test Professional 8.2, SQL Server, SAP BI 7.0, BEx Analyzer, SAP Query Designer, MS Project, HTML

Confidential

Data Analyst/ Business Analyst

Responsibilities:

  • Interacted with the End users and was involved in requirement gathering.
  • Involved in various stages of Software Development Life Cycle including analysis, integration and testing, deployment and maintenance.
  • Prepared Functional Design Documents for a SAP process integration interface so that different business units can collaborate with each other.
  • Developed and created data mapping document and implemented in SAP Netweaver PI transformation rule.
  • Developed custom functions with SAP Netweaver PI creating script in core Java.
  • Worked on Technical Documents version control.
  • Conducted JAD sessions with SME including business owners, sponsors and analysts.
  • Involved in User Acceptance Test and user training.
  • Worked as liaison between end users from Italy, Technical Team from India.

Environment: SAP net-weaver middleware, IBM Clearquest, IBM Clearcase, Excel, MS Visio

Confidential

Data Analyst

Responsibilities:

  • Wrote SQL queries and stored procedures to extract data. Analyze data and make reports for different end users like Citrix, Avaya.
  • Validated the requirements gathered for effectiveness and usability and ensured if they are convertible into business and functional requirements
  • Involved in deployment of courses in production environment.
  • Prepared weekly Scorecard reports in Excel.
  • Used pivot tables in Excel in order to analyze and provide meaningful information to the client.
  • Built templates and dashboards for customized views of the data specific to each group and line of business
  • Prepared custom reports and performed SQL query, data analysis.

Environment: Windows XP/2000, SQL Server 2002, MS Excel, V Model SDLC, Accenture Confidential, Helpdesk, MS Word.

Hire Now