Resume

Sign in

Senior BI Developer

Location:
Santa Monica, CA
Posted:
April 28, 2016

Contact this candidate

Resume:

PRITI AGRAWAL

**** **** ****** # *, ********* Beach, CA 90266

Email: acujzr@r.postjobfree.com

EXPERIENCE HIGHLIGHTS

OBIEE 10g,11g,Noetix Views,Noetix Analytics,Noetix Workbench,Discoverer 11g,Decision Expert, Oracle EBS 11i,R12,Exadata,Exalytics,Salesforce,E.piphany,Informatica,ETL,Tableau, Datawarehouse

Oracle 11, 10g, 9i, PL/SQL, SQL Plus, SQL-Loader, Oracle Forms 6i and Oracle Reports 6i, Toad, Erwin

SQL Sever 2000 – Transact SQL, Query Analyzer, SQL Server Agent, Admin Utilities.

Database Reporting and Debugging Tools like TOAD, SQL Navigator, Crystal Reports, MS Query, PL/SQL Debugger, etc.

Analytics consultant – managed analytics reporting for dozens of major clients HP, Microsoft, GAP, Yahoo Personals etc.

Database Migration consultant – migration projects from SQL Server 2000 to Oracle 9i for several Fortune 500 clients

Trained several team members on analytics and migration projects – worked both as a developer and mentor.

Developed several PL/SQL based systems for bay area start up EPOCRATES INC – awarded Engineering Excellence award.

Provided 24/7 production support for major clients and resolved critical production issues.

Excellent team player with superb inter-personal skills.

WORK STATUS US Citizen

TECHNICAL SKILLS

Well versed in creating OBIEE reports,OBIEE RPD development,Noetix Views development,Discoverer Reports,Developed custom queries on Oracle EBS 11i and R12 SCM and Finance modules.

Excellent in Oracle PL/SQL, SQL Plus, Oracle Forms, Oracle Reports as well as SQL Server 2000 Transact SQL – worked on several migration projects from SQL Server to Oracle 9i

Well versed in advanced PL/SQL features - loading xml files, blobs, clobs, query optimization, explain plan, built in packages - dbms_lob, image loading.

Well-versed in stored procedures, functions, triggers, views, dynamic PL/SQL

Well versed in Oracle 9i and SQL Server 2000 admin utilities - Enterprise Manager, SQL Worksheet, Data Manager, SQL Loader, SQL Server Agent, Query Analyzer etc.

Oracle Form Builder 6i, Oracle Reports 6i, SQL Plus, Golden and PLEdit32, Oracle Discoverer, Microsoft SQL SERVER 2000, SQL Worksheet, Enterprise Manager, Query Analyzer, Database Export and Import, Data warehousing, data mart and analytics, Star schema

Database Reporting and Debugging Tools like Crystal Reports, PL/SQL Debugger, TOAD, SQL Navigator etc.

Use of Data Dictionary and advanced reporting based on Oracle Data Dictionary tables

Data modeling and schema designing and ERD tools - such as ERWIN, Power Designer, Data Windows

Unix Environment Database operations - Writing shell scripts and implementing automation - setting cron jobs and auto-email of status reports to various departments

Power Builder 6.5, Cold Fusion 4.0, Visual Basic 6.0, Windows scheduler

Client/Server and web application development with interface to Oracle and SQL Server, MS Access databases, and HTML 4.0, Netscape composer 4.0, - well versed in use of frames, forms and images

Good experience in designing and coding for budgeting and billing systems, integrating with external payment systems like Verisign

Experienced in systems analysis and design including working with marketing and other departments finalizing requirements and project specs.

CERTIFICATIONS AND AWARDS AND TRAININGS

Received IT Prestige Award for Partner,Innovate,Deliver IT excellence accomplishments in Q4 2014 &Q1 2015.

Attended Individual Situational Leadership Training in Year 2015.

Participated in Oracle Open World as Activision Representative Year 2012.

Attended one week SalesForce Training at Sales Force office in San Mateo, CA Year 2009.

IT Penguin Award for excellence in performance and dedication Year 2009.

Oracle 9i SQL OCP Certification - June 2003.

Engineering Excellence award for DocAlert HTML Email Project at EPOCRATES INC- Year 2002.

Oracle 8i Advanced PL/SQL Training at Oracle University - Dec 2001.

School Captain for Basketball Team and School Prefect

EDUCATION

PHD Dr. H.S. Gour University, Sagar, India 1993

MS Dr. H.S. Gour University, Sagar, India, 1989, First Class

BS Dr. H.S. Gour University, Sagar, India, 1987, First Class

PROFESSIONAL EXPERIENCE

ACTIVISION BLIZZARD – SANTA MONICA, CA – JAN 2007 – PRESENT

Worked closely with Business users to support new BI Platform based on Noetix Views to gain significant efficiencies and process/compliance improvement in

Sales,SupplyChain and Finance for Operational and Analytics Reporting to drive our department goals in relevant areas.

Participated in stabilizing and resolving major issues after new BI Platform go live in 2015 by working closely with SCM/Finance Business users.

Developed and implemented Supply Chain Inventory Obsoloscence,Venlo reports, etc in subsequent quarterly release.

Devleoped Inventory Aging Report in OBIEE from Noetix Analytics subject area.

Participated in roadmap and strategy for Monthly Release discussions for BI reports.

Mentored and worked closely with offshore team on Noetix Views admin support by conducting weekly meetings.

Lead Revstream Project by working closely with FCS consultants and team members to develop and create R4 Revstream

subject area in OBIEE. Worked closely with Business to facilitate Revstream testing and resolve any issues. Implemented and deployed new Deferred Revenue Rollforward folder in OBIEE.

Developed Hyperion GL,AP,AR drill thru views in Noetix Views. Participated in roadmap and strategy for Monthly Release discussions for BI reports.

Participated in Noetix Analytics validation of folders in Inventory and OM subject areas.

Developed and implemented Inventory Aging report from Noetix Analytics Inventory subject area.

Developed and implemented Supply Chain Inventory Obsoloscence,Venlo reports, etc significant to business during quarterly release.

Consistently provided support to reduce downtime by 30% by working closely with DBA team,Infrastructure team,Offshore team,etc. and working late hours,weekends as per the need.

Consistently monitored BI systems to keep system up and running. Participated in Network segmentation enhancement and patches by testing and supporting BI applications during weekends.

Worked closely with Business to support new BI platform based on Noetix views and resolve any issues after R12 project Go live in May,2015.

Participated in Noetix Views/BI As is Reports Finance/Supply Chain user training. Mentored and trained team members on,Noetix Views/BI System,RevStream and processes.

Mentored and worked closely with Offshore team so there is no BI application downtime in production.

Provided Noetix Views/BI training to Business users and worked closely with them in resolving any issues.

Worked closely with Business users,Functional/Technical Teams,Offshore Team to Deliver Quarterly Release projects on time by planning migrations/testing deployments

Lead Revstream Project by working closely with FCS consultants and team members to develop and create R4 Revstream subject area in OBIEE.

Worked closely with Business to facilitate Revstream testing and resolve any issues.

Implemented and deployed new Deferred Revenue Rollforward folder in OBIEE. Worked closely with Business users,Functional/Technical Teams,Offshore Team to Deliver Quarterly Release projects on time by planning

migrations/testing deployments.

ACXIOM - SAN MATEO, CA - CONSULTANT – FEB 2006 – JAN 2007

Analytics Workstation Consultant

Developed comprehensive SQL scripts for development of Exports, Reports for various Fortune 500 clients.

Using utilities segment explorer, dimension, reports, export explorer,report explorer etc.

Customization of Cube,Cube Analysis and Enterprise Reporting for several major clients

Data Management Services

Data Scrubbing, Data cleansing,Match Back processing, Loading of various data using SQL Loader.

Used Sales Force,CRM OnDemand and Quick Arrow for logging and tracking project assignment

INFORMATION SCIENCES INSTITUTE, University of Southern California - MARINA DEL REY – FEB 2005 – NOV 2005

Invoicing and Payment Processing

Redesign of the existing vendor payment, check processing, shipping and invoicing and University financial systems reconciliation project. The project is based on Oracle Forms 6i and Oracle Reports 6i as the front end and Oracle 8i and later 10g as the back end databases. The system involves catering to various payment plans including partial payment and advance payment features. Set of common utilities developed in backend oracle system are referenced appropriately from front-end forms and reports from UI. The system is web-enabled. Though most of the processing is online, SQL-Loader and ETL are employed for bulk data import-export.

INVESTORS BUSINESS DAILY – MARINA DEL REY – JAN 2005 – FEB 2005

Analytics Project

Development of internal analytics project on SQL Server 2000 platform using DTS packages, stored procedures, triggers etc.

Product Configurator based selling solution

Performed requirement gathering, analysis and initial design of a Product Configurator based selling solution to enable selective pricing, discounting and other promotions to customers based on the combination of packages –like subscription to newspaper, subscription to seminars, subscription to online edition, subscription to training sessions etc. The proposed solution was to be based on implementing a rule engine based on Boolean algebra.

DIGITAL IMPACT- SANTA MONICA and SAN MATEO, CA - CONSULTANT – OCTOBER 2003 – NOVEMBER 2004

Analytics workstation project

Setting up analytics work station for start-up clients for email marketing and reporting. Handled analytics reporting for several Fortune 500 clients like SAMSUNG, ELI LILLY, HSBC, MICROSOFT, HP, YAHOO, SONY, COMCAST, KAISER PERMANENTE etc.

Working on database admin utilities for both Oracle 9i and SQL Server 2000, for data migration, monitoring, trouble shooting. Extensive debugging experience through Database and Application server log files.

Cube Analysis and Enterprise Reporting for several major clients.

Migration Project

Migrated several clients from SQL Server 2000 platform to Oracle 9i platform. Extensive Oracle 9i PL/SQL as well as SQL SERVER 2000 Transact SQL coding and data export and import database server utilities.

Integration of Appwork Scheduling utility with Analytics for migration from SQL Server based Architect Impact 5.2 to Oracle 9i based Impact 6.0 analytics software.

Developed comprehensive SQL scripts for migrating several software utilities – segment explorer, dimension, reports, export explorer etc.

Mentoring Team Members

Mentored several team members both within US as well as across the continent on Analytics and Migration projects.

24/7 Production support

Provided 24/7 product support on on-call rotation basis for several Fortune 500 live clients and resolved critical issues working across multiple functional teams.

PLATFORM: WINDOWS XP, WINDOWS 2000

SOFTWARE: Oracle 9i, PL/SQL, SQL PLUS, SQLSERVER 2000, ANALYTICS WORKSTATION, ANALYTICS ARCHITECTS, WINDOWS SCHEDULER

EPOCRATES INC, SAN MATEO, CA - DATABASE ENGINEER - MARCH 2000 - AUGUST 2003

QID Project

Design and development of Infectious Diseases data schema and writing PL/SQL packages to validate and populate the data and also to generate various reports.

Express Doc Alert Project

Writing PL/SQL validation packages to ensure migration of undelivered doc alerts to active campaign assigned users.

eCommerce Project - Billing and Credit card encryption

Design and development of schema and PL/SQL loading and reporting packages to store Gift certificates, and discount coupons - tracking their redemption and expiry. Writing PL/SQL functions to encrypt and decrypt credit card information before storing in the database tables.

Data warehousing Data mart and Analytics

Redesign of star schema for data warehouse and performance tuning of query scripts - running explain plan, introducing indexes, redesigning of queries to reduce cost.

Data Load using SQL Loader and Database Export Import

Loading of various data sent by formularies, pharmacies and marketing teams using various SQL Loader. Writing comprehensive validation procedures before loading data.

Data Dictionary Project

Creation of data dictionary for the RX Online schema based on specifications from First Data Bank

Shell scripts and Automation

Writing shell scripts and implementing automation - setting cron jobs and auto-email of status reports to various departments

Use of built-in Oracle packages - Loading of Blobs, Clobs, Images and XML data

Writing PL/SQL using built in DBMS_LOB packages for storing and retrieving blobs, clobs, images and XML

Enhancement of existing schema and its maintenance using Triggers

Creating triggers on big segment schema for automation population of certain fields and run time updating of data in related tables.

PLATFORM: SOLARIS, LINUX and WINDOWS

SOFTWARE: Oracle 9i, PL/SQL, SQL PLUS, SQL LOADER, SHELL SCRIPTING, CRON JOBS

FACE TIME COMMUNICATIONS, FOSTER CITY, CA - PROGRAMMER AND SYSTEMS ANALYST - JAN 2000 FEB 2000

Revenue and Time analysis of client matrix of the Application Service Provider

This project involved analysis of the web server data generated by the ASP FaceTime for login time, user code, number of pages requested etc for all its customers. The project involved loading the data into SQL Server and then designing and writing complex queries to present to management the various usage and revenue profiles.

PLATFORM: COMPAQ PCs

SOFTWARE: SQL Server, SQL, ENTERPRISE MANAGER, QUERY ANALYSER

LEGACY SOLUTIONS, ROSEVILLE, CA – PROGRAMMER – AUGUST 1999 – Dec 1999

State of Georgia Budget System

This project is for developing of budget system and creating several reports for the State of Georgia. Assisted in the development of requirements and design of a new budget system for the Budget Office. The system is used by agencies to develop their budget requests and the Budget Office to analyze agency budget requests.

Creating various forms and reports using Oracle as database and PowerBuilder as front-end.

PLATFORM: HP PCs

SOFTWARE: ORACLE, POWERBUILDER, GOLDEN PL/EDIT, SQL PLUS, PL/SQL

Department of Human Health Services, State of California

Conversion of Oracle database to SQL Server. Loading the data in Oracle using SQL * Loader and converting into SQL Server. Developing new financial systems using SQL Server 7.0. Developing various data entry, analysis and reporting modules.

PLATFORM: HP PCs

SOFTWARE: ORACLE 7.0, SQL SERVER 7, SQL * LOADER, CRYSTAL REPORTS

REFERENCES

Available on Request

---Submitted in strict confidence ---



Contact this candidate