We provide IT Staff Augmentation Services!

Business Analyst Resume

San Jose, CA

EXPERIENCE SUMMARY:

  • An Engineering Graduate with around 15.5 years of experience in performing business analysis including Scope Definition, documenting business requirements & Functional Specifications, building Use Case Specification, documenting Reporting Specification for large data warehouse and business intelligence projects.
  • Excellent analytical abilities backed by sound functional knowledge, highly skilled and experienced in directly working with business users in understanding, analyzing, supporting their reporting requirements and verifying the solutions meeting requirements.
  • Communicate effectively with both business and technical staff to convey complex ideas both verbally and in written form, demonstrated success in leading a team with both functional and technical resources to address cross - functional issues
  • Highly experienced in working across cross functional teams in prioritizing the requirements, helping define acceptance criteria for completion of the solution and managing client expectations through careful & proactive communications regarding requirements changes.
  • Extensively worked on generating Adhoc reports, performing Gap analysis, Identify and communicate project risks, provide operations support for Compliance Reports for the State and Federal Governments and sales forecast reports for partners and internal functional managers & executives.
  • Strong data warehouse experience in all the stages of Software Development Life Cycle including Data Profiling, Gap Analysis, ETL Analysis, Design, Development, Implementation, Validation, Testing and Reconciliation.
  • Experienced in working with internal compliance auditors - Understanding their audit observations and providing the data reasons by doing extensive research & analysis. Designed and implemented System monitoring solution for tracing the data issues/leaks across various data processing stages.
  • Expertise in doing Source System Analysis, Data Profiling and Data Quality Readiness (For sources like SAP/Oracle ERP, SFDC, Data Files from external/internal systems and custom applications).

TECHNICAL SKILLS:

Reporting: OBIEE, SAP Business Object, Qlikview, Tableau, Angular

Operational/Source Systems: Oracle E-Business Suite, Sales Force (SFDC), Oracle CRM, SAP CRM

Databases: Oracle, Teradata, Hana, Hadoop

Languages: SQL and PL/SQL

Operating Systems: Windows XP/2000, Unix & Linux

ETL Tools: Informatica & Golden Gate

Software Development: Agile Scrum, Waterfall

Methodology Training: Google Cloud Platform

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Environment: Oracle, Teradata, Hadoop, SAP Business Objects, SAP Hana, Angular4

Business Analyst

Responsibilities:

  • Gather business requirements and translate the business requirements to Business Rule Document and User stories
  • Document As is process & to be process flowcharts
  • Perform hypothesis analysis between the current process and to be process and review with the stakeholders
  • Review the User stories with stake holders get their sign-off
  • Document and review test cases.
  • Review the technical design for reports
  • Review the QA and Integration test results
  • Verify solution meeting the requirements
  • User guide documentation and user training
  • Work with end users for UAT testing
  • Bug fix verification and tracking
  • Production verification and support normalization after deployment

Confidential, South San Francisco, CA

Environment: Oracle 11g, Informatica & Business Objects

BI Analyst - Data Compliance

Responsibilities:

  • Designed, developed, implemented & tested System monitoring process for source systems like SAPBW,CRO, Aprimo, SFDC which helps in identifying the data leaks though the various stages of data process. Because the system is used for legal compliance, the System Monitoring application will ensure that any defects in data transformation and loading can be detected rapidly, and fixed in advance of any government reporting
  • Worked on the data analysis and validation of multiple work streams in the design and development of the Sunshine track which is a web application part of Aggregate Spend solution and was built to provide Confidential access to view and dispute their Confidential payments prior to filing with the FDA (Food & Drug Administration).
  • Worked extensively in the data quality readiness validation for the CMS reporting (Centers for Medicare & Medicaid Services). Analyzed and found the root cause of the issues which were captured as part of System Monitoring process, issues logged in by users.
  • Worked on production tickets logged in by the users, performed root cause analysis to identify issues by referring ETL codes and transformation rules.
  • Performed the source system analysis in the Clinical Trial Management system to identify the Primary investigator for the research payments in SAPBW & CRO source systems.Generated adhoc reports, performed Gap Analysis, and reported the risks to the Compliance users before implementation.
  • Performed data profiling for raw iHCP XML data extracts from Basel.Designed & implemented validation rules for the source files before loading into Aggs system and captured data errors. Conducted end to end data reconciliation from source XML files, Emgt system, Aprimo system, Aggs staging, Aggs Datamart and Aggs reporting.
  • Support the internal compliance auditors by answering their questions/observations for various source systems like Clinical Research Organizations, International Health care Professionals, SAPBW & FGSR for the 2012 Aggregate spend data by performing extensive research & analysis and providing supporting reconciliation data information.
  • This report is used for tracking the MDM Stewardship status for the unprocessed transactions
  • Implemented and validated the MDM Gold address for the Recipients.
  • Worked on production tickets logged in by the users, performed root cause analysis to identify issues by referring ETL codes and transformation rules.
  • Work with commercial compliance business users, to understand the adhoc reporting needs, analyze and provide adhoc reports from Aggregate spend datamart.
  • Work with SAP SMEs in getting the vendor master extracts, analyze it and send the corresponding organizations & individual files to DNB & AMS for fixing the industrial code.
  • The Un steward Spend Report which is primarily used to track the MDM stewardship process and certify reconciliation.
  • Performed data analysis & validation support.
  • Performed data quality check for the various vendor files, data validation for the database, Detail & Aggregate reports for the free goods provided to the Health care professionals and the Exception report for the transactions that were not processed.

Confidential, Sunnyvale, CA

Environment: Oracle 10g, PL/SQL, Golden Gate & OBIEE

BI Functional Analyst

Confidential, San Jose, CA

Environment: Informatica 8.6, Oracle 10g, Oracle Warehouse Builder, Teradata and Business Objects.

BI Functional Analyst

Confidential, San Jose, CA

Environment: Informatica 8.6, Oracle 10g, PL/SQL, Teradata and OBIEE.

BI Functional Analyst

Hire Now