SUMMARY:

• Over 11 years of experience in Requirement & Data Analysis, Design, Development and Testing of applications and reports using Relational databases, Data warehousing and BI technologies.
• Proficient in application and reports development using Oracle 11g/10g MySQL 5.5, Google's Dremel and Tenzing DB Engines via Plx, Cognos, Unix and Oracle Forms & Reports.
• Strong SQL and PL/SQL background. Extensively worked with large databases and data warehouses to create complex PL/SQL packages, procedures, functions, queries and reports.
• Experienced in ETL/Loading data using DB management tools like Google’s Slurpees/Plx Imports, SQL*Loader, Dynamic SQL, SQL Performance Tuning and Software Quality Testing
• Experienced in UNIX Shell scripting and job scheduling .
• Proficient in dimensional data modeling, development of data warehouses and OLAP reporting.
• Independently worked on projects(on - site) successfully in the United Kingdom and Canada as well.
• Self-starter and individual contributor with excellent communication, analytical, inter-personal and team work skills.

TECHNICAL SKILLS:

Databases: Dremel & Tenzing on Plx(Google's Big Data Analysis & Visualization Platform), Oracle 11g/10g/9i, MySQL 5.5

Languages: SQL, PL/SQL, UNIX Shell scripting, Java, HTML

Tools: SQL*Plus, TOAD, SQL*Loader, Oracle Forms and Oracle Reports, Oracle SQL Developer 2.1.1, Crystal Reports XI, MySQL Workbench

Analytics/ETL: Google's Plx, Google Dashboards, BigQuery, Tableau, Cognos, Informatica

Operating Systems: Unix(AIX/SCO), Goobuntu, Mac OS X 10.11, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Mountain View, California

BI Developer

Responsibilities:

• Solely responsible for managing the data mart.
• Other responsibilities include development and maintenance of the Confidential datamart, monitoring of production pipelines processing daily snapshots, aggregates and historical data, troubleshooting production failures, performance tuning, collaborating with teams to resolve source system failures, servicing ad-hoc data requests, submission of code to Google3 code repository, performing code reviews, creation of dashboards, ACL management through Sphinx and Groups and providing technical support to data mart users.
• Responsible for the creation and management of the Geo Master data mart that involves, importing and cleansing raw data for several countries using Unix utilities, loading into Plx and building a comprehensive dataset.

Environment: Plx, Dremel, Colossus, Placer, BigQuery, Google Dashboards, Tableau 9.2, Unix utilities, Piper, Cider, Sphinx, Chromebox, Macbook Pro, Ubiquity instances running Ubuntu 14.04 LTS

Confidential, Mountain View & Sunnyvale, California

SQL Developer

Responsibilities:

• Served the Bizapps team for its Vendor and Expense Management System(on Rivermine) for Google's expenses on resources like Network bandwidth, data center space, power etc.
• It has rich functionality for managing contracts and its associated circuit inventory as well as automated vendor invoice auditing to ensure accurate payments to vendors.
• Responsibilities include development, testing and maintenance of database scripts for data maintenance and reporting, Datamart development in Plx/Tenzing, Purchase Order Refresh, Rivermine Health Check Dashboard, procedures, SQL performance tuning, Java beanshells and classes, performing code reviews and creation of technical documents.

Environment: Google's Tenzing DB Engine, Plx Interface and Colossus File System, Rivermine ERP & MySQL 5.5 on Ubuntu 12.04.4 LTS running on Dell PowerEdge R410 servers, MySQL Workbench 6.1 and Eclipse 4.4.

Confidential, San Jose, California

Oracle Developer

Responsibilities:

• PIX application is the engine behind eBay’s HR application, MyHR.
• This is integrated in real time with other applications like SAP, Brassring and other third party applications using Webmethods.
• University Recruitment is a new requirement in the Hiring Talent module of PIX, to enable recruitment of university candidates.
• Responsibilities include development, testing and maintenance of Oracle PL/SQL packages, procedures, function, database environment validation, deployment, SQL performance tuning, interacting with cross-functional teams to clarify requirements and creation of technical documents.

Environment: Oracle 11g on Solaris, TOAD 10.5 and Windows 7.

Confidential, Milpitas, California

Sr. Oracle Developer

Responsibilities:

• Provides an integrated commerce experience that allows Partners to register deals, configure and price products, software and related services, and submit orders from a single Workspace.
• It is a cross functional platform that is integrated with Cisco's several applications like Salesforce, promotions, configuration, pricing, orders etc.
• Responsibilities include development, testing and maintenance of Oracle PL/SQL packages, procedures, functions, database jobs, data migration/replication, SQL performance tuning, interacting with cross-functional teams to clarify requirements and creation of technical documents.

Environment: Oracle 10g/11g on Red Hat Linux running on Cisco's UCS blade servers, TOAD 10.5 and Windows 7.

Confidential, Cupertino, California

Database Developer

Responsibilities:

• Responsibilities include development and maintenance of Datamarts, PL/SQL procedures, reports,
• Unix scripts, scheduling cronjobs, development of scripts that generate SQL Scripts dynamically and iTunes content data management.

Environment: Oracle 11g and 10g on Solaris 10 running on Sparc servers, Oracle SQL Developer 2.1.1, SQL*Plus, Macbook running Mac OS X 10.6.

Confidential, Campbell, California

Data/Reporting Analyst

Responsibilities:

• Responsibilities include interacting with the clients/end users to gather the requirements.
• Data and Requirement Analysis, Data loading, Development of SQL and PL/SQL procedures and Unix Shell scripts.
• Design and development of reports for use by external clients and management.
• Providing proactive feedback to management through data and report analysis.
• Tieback data processing and Marketing list generation for Contract Sales Renewal.

Environment: Oracle 9.2/10g on Sun Solaris 5.9 with SCO 5.32, SQL Loader 9.2, Toad 7.5, Excel, Crystal Reports XI for Peoplesoft & Crystal Enterprise Server.

Confidential

Software Engineer

Responsibilities:

• Data is collected on a Unix server, cleansed using shell scripts and loaded into a staging area in Oracle, where the data is scrubbed and transferred to the Fact table.
• Multi-dimensional cubes are built from the Fact table and published on the web for analysis.
• Developed and automated the data warehouses using Cronjobs for 30 data warehouses. Star schema design.
• Development and maintenance of PL/SQL packages, procedures, functions, shell scripts, job scheduling, tablespace management and SQL tuning.
• Creation of catalogs, queries, models and cubes in Cognos.

Environment: Cognos and Oracle 8.0.5 on AIX ver.4.3.2

Confidential

Software Consultant

Responsibilities:

• This application extracts, transforms and loads the data from the existing application into the database of the Peoplesoft application.
• Development of PL/SQL packages used by the transaction modules of Constellar.

Environment: Constellar and Oracle 8.