SUMMARY:

• Over four years of experience in Database Analysis with expert knowledge in writing SQL queries over Oracle, SQL Server, MS Access.
• Experience in developing database applications using .NET, Tableau to report, analyze and present data.
• Self - starter with excellent analytical, organizational and problem solving skills.
• Known for excellent attention to detail and the ability to communicate effectively with all levels in the organization.

TECHNICAL SKILLS:

RDBMS: Oracle, Netezza, MS SQL Server, MS Access.

Reporting Tools: Hyperion System 9, Tableau, OBIEE.

DB Tools: SQL Developer, TOAD.

ETL: Oracle Data Integrator (ODI).

Languages: SQL, PL/SQL, C, Java, HTML.

MS Technologies: VB.NET, ADO.NET.

ERP: SAP.

Applications: MS Excel, MS Word, MS PowerPoint.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Product Analyst

Responsibilities:

• Developed requirements for Analytics module offered as part of IPTV middleware software.
• Worked with customers, product managers to define reports and metrics.
• Built mockup reports using SQL and Excel, which served as guide for developers to build on a homegrown tool.
• Involved in the support and maintenance of analytics module and helped to resolve customer escalations for database related issues.

Confidential, Downey, CA

Data Quality Co-ordinator

Responsibilities:

• Created reports to support legal requirements of MediCal, Medicaid, Cal-Optima.
• Built processes to ensure data integrity and transparency for various ETL processes using Excel.
• Maintained extract, transfer and load processes of multiple datasets from various sources.

Confidential, Cupertino, CA

Data Analyst

Responsibilities:

• Assisted in developing WW and regional metrics dashboard for Apple fulfillment operations.
• Worked on developing metrics for RMA and Ship to Delivery Customer Experience.
• Performed numerous ad-hoc analyses to support projects initiated by Apple Online Store.
• Validated the metrics published on online dashboard by comparing it with backend tables.

Confidential, San Francisco, CA

Data Analyst

Responsibilities:

• Developed business requirements for Business Objects universe to achieve Advertiser reporting on key metrics for internal business clients.
• Support Customer Ad reporting initiative by identifying data issues and resolving them by working with internal and external clients.
• Performed ad hoc and root cause analysis by writing complex SQL queries.

Confidential ., Alviso, CA

Reporting/Data Analyst

Responsibilities:

• Involved in creating and administering the Physical, Business Model & Mapping, Presentation Layer using Oracle Admin tool.
• Created interactive dashboards with multi-level prompts and filters in OBIEE.
• Developed interfaces to extract data from source systems and load it into target systems including Oracle DW, flat files using Oracle Data Integrator (ODI).
• Participated in design meetings to create a sustainable star schema model to cater to TiVo reporting needs using OBIEE.
• Developed ad-hoc queries in OBIEE Answers to meet business needs.
• Designed back-end tables and corresponding mappings in ODI to generate automated customer email lists for marketing email campaigns.
• Built a dashboard to illustrate number of POP numbers available to TiVo customers geographically using Tableau and MS SQL Server.
• Worked on a Hyperion dashboard which reported various metrics like activations, broadband logins etc for the entire customer base of International TiVo customers.
• Automated Month-end TiVo Sweepstakes winner process using VB.NET and ADO.NET.
• Designed the queries using Hyperion to generate randomized survey lists for User Research.
• Wrote numerous queries to generate targeted email lists for promotional emails, newsletters sent by Marketing and TiVo's partners like Amazon, Netflix, and Blockbuster
• Participated in numerous requirement gathering sessions for reports requested by business users.
• Optimized and migrated existing reports to a new Hyperion 9.3 Workspace Server.
• Created ad-hoc temporary reports for Sales, Marketing, Product development and Finance departments.
• End user training for Hyperion and OBIEE reports.
• Supported production issues by finding the root cause and fixing it.
• Maintenance and delivery of Month-end, weekly and daily reports.

Confidential, Brisbane, CA

Data Analyst

Responsibilities:

• Created SQL query and developed process to report “Black Hole Packages” for UPS and FedEx carrier services on a daily and weekly basis using Excel.
• Designed and developed various reports to identify packages which missed the “Estimated Delivery Date (EDD)” and created pivot charts to make such packages actionable; resulting in On-Time Delivery of ~99%.
• Developed a data tracking model for “Lost in Transit” packages into usable business support tools for Customer Advocacy team using Access and Tableau.
• Analyzed, reported and developed recommendations on data related to various operational metrics like Package Trackability rate, On-Time Delivery, and Carrier Code Mismatches.
• Leveraged the existing process to achieve ~100% package Trackability rate.
• Developed Access database to synchronize the shipping dimensions of various items in distributor’s catalog with Confidential .
• Wrote numerous ad hoc SQL queries to develop and analyze operational performance based on key indicators and provide insight on performance deviations and anomalies.
• Driven meetings with the order fulfillment team and various distributors of Confidential to bring about resolutions.
• Documented and trained users with various processes that are currently being used.