SUMMARY:

• BI Analyst with 10 years of experience implementing Reporting and data analytics Applications
• Part of a BI implementation team with average of 1200 users per week
• Great with information representation, numbers, charts and trend recognition
• Advanced analytical, reverse engineering, conceptual and problem - solving skills.
• Innovative and willing to learn the best approach to meet the requirement

SKILL:

Business Intelligence Tools: Tableau, Oracle BI (OBIEE), Oracle Data Integrator, SSRS Microsoft Excel

Languages: R Programming, Python, JavaScript, XHTML, XML/XSD/XQUERY, PERL

Database Applications: ODI, Oracle SQL, MySQL, PL/SQL, TOAD, Teradata, Teradata

Operating Systems: Windows, Linux, Unix

Methodologies: Agile, Data Modeling Star/Snowflake, Schemas, ETL, OLAP

WORK EXPERIENCE:

Confidential, Irving, TX

Data Analyst

Responsibilities:

• Requirements gathering from internal teams to generate data views and automate loads
• Analyze and correct Data gaps, inconsistencies and discrepancies in Supplier Data.
• Spend Analytics reporting - Data extraction transformation process for Verizon overall monthly Spend
• Supplier sourcing process reporting, from multiple heterogeneous transaction sources
• Hadoop migration: convert existing Oracle scripts into Hive.
• A Technical point of contact when working with Oracle Support
• Ingestion of data from Supplier sources and automate Data Load for Supply Chain database.

Applications: Oracle Data Integrator, Tableau 10.1, Oracle BI, Oracle SQL, UNIX, JavaScript, Python.

Confidential, San Francisco, CA

Data Analyst

Responsibilities:

• Expand on the Customer attrition reporting on Tableau and Improve performance of existing tableau reporting by 15% using tableau best practices and industry standards.
• Customer credit card Data retrieval from Microsoft (SSRS) reporting tool.
• Tableau Reports for customer credit card adoption analysis Understanding the Reporting needs on Annual Identified KPI metrics and measures for Fed Response Failure Analysis dashboard

Confidential, San Ramon, CA

BI Analyst

Responsibilities:

• BI Solutions based on Tableau, OBIEE and Access projects.
• Tableau Reports for IMR team analyzing HP Quality Center Data for QA Manager’s bug closure analysis
• Understanding the Reporting needs on Annual Federal Capital Plan and Review (CapPR) Fed response
• Identified KPI metrics and measures for Fed Response Failure Analysis dashboard
• Responsible for gathering data from heterogeneous transaction source systems into enterprise DW
• Build complex SQL Queries to extract and aggregate balance amounts at Schedule level
• ETL tasks to load data from multiple heterogonous transaction sources for Reconciliation reports
• Loan amounts comparing it with Fed Reported amount to check for variance
• Ensure Data warehouse is matching with the source systems for critical reporting metrics
• Internal BI testing was thorough such that UAT release was bug free

Environment: Tableau 8.1, OBIEE 12C, OBIEE 11.1.7, Oracle 11g, Toad

Confidential, Sunnyvale, CA

BI Analyst

Responsibilities:

• Finance Team: BBsBr reporting (Booking/Billing/Shipment/Billing/Revenue)
• Tableau Reporting: identify revenue leakage though unlicensed Confidential Software (comparing Purchased Licenses vs Auto - Support (license usage) Data.
• Tableau Data Analysis/extraction using Python for generating email burst
• Install Base Data Reporting based on ASUP HBASE Big Data using Flume
• Product Hierarchy reporting and representing various Pricing & Discount Models.
• Weekly ETL workflow management for LSG team that monitors customer usage vs Purchased data
• Create/Discover “Tableau possible” reports that could help the business model analyze and get ahead.

Environment: Tableau 8.1, OBIEE 11.1.6,, Oracle 11g, Toad, Pentaho

Confidential, San Jose CA

OBIEE Analyst/Lead

Responsibilities:

• For KPI metrics, Collaborating with various business groups like Finance, Quarterly Business Review and Supply Chain.
• Bookings Dashboard reporting Forecast, linearity, Seasonality, Pipeline data at weekly, monthly and Quarterly level for the Finance Team
• Tableau reports development for Product Bookings and Sales Bookings dashboards
• Improved dashboard usage by 22% by remodeling existing Business Objects UI to OBIEE Reporting
• Go to person for resolving any Report development related issues
• Taking the extra effort for the best possible UI experience (Sparkline view).
• Internal BI testing was thorough such that UAT release was bug free
• Data Sources: HR (CMMC) Database, Excel Uploader Utility

Environment: Tableau, OBIEE 11.1.7, Business Objects, Teradata 13.0, Oracle 11g, Toad

Confidential, Sunnyvale, CA

BI Analyst

Responsibilities:

• 360 Degree View of a Serial Number and Install Base Profiling Dashboard
• Reporting based on big data based on weekly notification feeds from about 800,000 Storage Controllers
• Designing complex front end reports hence reducing backend data team’s effort by 3 weeks.
• Collaborating with Sales Rep Managers to understand their account/customer management needs and implement corresponding BI Reports.
• Engage with business for understanding report usage and train users on existing and new features.
• Create Excel Data Extracts for Business Users for Adhoc reporting.

Environment: Oracle BIEE 11.1.5,10.1.3, Oracle 10g, Toad, Datastage

Confidential, Sunnyvale, CA

OBIEE Lead

Responsibilities:

• Upgrade to BI Apps Version 7.9.6.1 tables W MCAL DAY D, W PARTY D/W CUSTOMER ACCOUNT D tables.
• Data Reconciliation process between OOTB RPD new tables and the backend Data warehouse.
• SIL and SDE workflow management and monitor/schedule loads using DAC
• Data Warehouse and source systems mapping analysis and A/B testing for reporting metrics

Environment: Oracle BI Apps 7.9.6.1, Informatica Power Center 8.6.1, Oracle E-Business Suite 11i, Toad