Mary Premila Immanuel Joseph Email & Phone Number

Zurich, Ch

Promoting the success of Google Cloud, through the development of ETL solutions/data pipelines and BI solutions for the Google Cloud Customer Success team, enabling them to optimize the post-sale customer journey of Google Cloud’s highest value customers and maximize their investments, by unlocking the full value of the cloud. The key benefits are consumption growth, opportunity identification, service expansion and increased customer loyalty.. Responsibilities include, analyzing requirements by working with stakeholders, development and maintenance of Plx workflows and scripts using F1, code maintenance on Google3 repository, code deployment to production, developing LookML models and dashboards using Looker and creation of dashboards using Google dashboards and Google DataStudio.

Roseville, Ca, Us

Engaged in the development of a reliable cloud-based data infrastructure, that serves as a foundation for crucial business decisions, to promote better financing solutions for the Residential Solar industry. Responsible for developing ETL pipelines based on Apache Spark, Databricks using Scala with data sources and Lambdas from the AWS platform. These ETLs are designed to ingest, validate and integrate data sourced from file based sources like AWS S3 or DynamoDB. Orchestration of these ETL jobs is accomplished with Databricks or Apache Airflow. Environment : Databrick Runtime Version 6.4, Scala 2.11, Apache Spark 2.4.5, AWS S3, DynamoDB, Airflow, DataGrip, Visual Studio Code, IntelliJ, Git

Rancho Cordova, Ca, Us

VSP Global, Rancho Cordova, CA(thru Ranstad Technologies Inc)April 2019 – Till dateConsumer Data Analysis : Responsible for a performing a comprehensive quantitative and qualitative analysis of VSP’s Consumer core data attributes across multiple factors to determine the current state of Consumer data and to establish a baseline for data quality initiatives. Also carrying out Consumer Trait Combination Analysis to improve VSP’s Consumer search experience, by identifying high confidence search combinations, for use across VSP applications. Other responsibilities include, working on Consumer Data Governance initiatives, partnering with Consumer team and business partners to identify data quality issues and corrective actions, performing ad hoc analysis and/or reports. Environment : IBM Netezza v7.2, IBM DB2 v10.5, Tableau, DbVisualizer, WinSQL & Git.

Mountain View, Ca, Us

Google Hardware Support Data Engineering & Analytics :Contributed to the elevation of the Google Hardware experience through radically better customer care, by developing a Training Analytics system for Google's Hardware Training group, that helps monitor the training progress of customer care partners around the world, their assessment results, QA scores, call center statistics to make informed decisions to enhance the quality of Google Customer Care.Solely responsible for requirements analysis, design, development and maintenance of database scripts and workflows for data pipelines, processes and dashboards for Training Analytics and for the maintenance of ETL processes that consolidate agent rosters across the world and feed new users into the LMS system.

Mountain View, Ca, Us

Google Payments Data warehouse Reporting : Development and maintenance of reports based on the Google Payments Data warehouse for the Google Finance team. Worked on migrating reports that were based on the invoice tables, that were migrated to the new Invoice data model. The Invoice data model was revamped for better performance and to provide for more real-time processing of payments by shifting to efficient technologies like F1 and clustering, de-normalizing tables to keep relevant data together for ease of access. Modified scripts that generated Payments-related documents, to cater to the new Payments regulations related to electronic billing that were defined by the new Mexican Federal Tax code. Environment : Google's F1, Dremel DB Engines, Plx, Colossus, Placer, Piper, Cider, Sphinx and Linux.

Mountain View, Ca, Us

I) "Google for Work" Data mart : Rhubarb is an App-Engine based visualization platform for business metrics that supports the needs of the Central Sales Operations team of Google for Work. Solely responsible for managing Rhubarb's datamart. Development and maintenance of scripts and tables. Carried out performance tuning of Workflows by redesigning and reducing their execution time to a fifth of their earlier average execution time. Improved the features of Rhubarb's datamart by adding more labels/suffixes to club related table partitions that are accessed together. Maintained the stability, availability and data quality of Rhubarb's datamart by troubleshooting several production failures of Rhubarb Workflows and scripts and configuring the environment as needed. Performed code reviews. Submitted and maintained code via Piper on Google3 code repository. Managed ACLs through Sphinx, LDAP, Ganpati and Google groups. Collaborated proactively with the EDW team that provides Rhubarb's source data and gained their co-operation and support in reducing the incidence of source data refresh failures. Provided technical support to Rhubarb data mart users.II) MDM - GeoMaster : Geo Master is a standardized, comprehensive dataset of geographic locations globally utilized for territory assignment, region-based reporting and operational activities. 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, Tableau 9.2, Google Dashboards, Piper, Cider, Sphinx, Unix utilities, Chromebox, Macbook Pro, Ubiquity instance running Ubuntu 14.04 LTS

Mountain View, Ca, Us

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 development, performing code reviews and creation of technical documents. Environment : Google's Tenzing DB Engine, Plx Interface and Colossus File System, Rivermine & MySQL 5.5 on Ubuntu 12.04.4 LTS running on Dell PowerEdge R410 servers, MySQL Workbench 6.1 and Eclipse 4.4.

San Jose, Ca, Us

PIX application is the engine based 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.

San Jose, Ca, Us

Cisco Commerce Workspace (CCW) 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 on Red Hat Linux running on Cisco's UCS blade servers, TOAD 10.5 and Windows 7.

Cupertino, California, Us

Served the iTunes Store’s Content Data Engineering team. Responsibilities include development and maintenance of Datamarts, PL/SQL procedures, reports, Unix scripts, scheduling cronjobs 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.

Rainmaker Systems is a leading outsource provider of sales and marketing services for companies striving to drive more sales. Responsibilities include interacting with the clients/end users to gather the requirements. Data & Requirements Analysis, Data loading, Development of SQL and PL/SQL scripts and procedures. 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/SCO 5.32, SQL Loader 9.2, Toad 7.5 and Crystal Reports XI for Peoplesoft and Crystal Enterprise Server.

Noida, Uttar Pradesh, In

Developed multiple data warehouses and BI reporting for those data warehouses, for the clients of Candle Corp, El Segundo, CA, for the Application résponse time analysis of their clients. 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 the databases using Star Schema design and automated refreshes using Cronjobs. Responsibilities include development and maintenance of Data warehouses and BI reporting. This involves development and maintenance of PL/SQL packages, procedures, functions, shell scripts, job scheduling, tablespace management and SQL tuning. Creation of Business Intelligence reports which includes, creation of catalogs, queries, models and cubes in Cognos.Environment : Cognos and Oracle 8.0.5 on AIX ver.4.3.2

Worked onsite for Cognos Inc, Montreal, Canada for a Business Intelligence Project on Sales Campaigns. Worked onsite for ISYS Plc, London, UK for a project for Print Information Management system based on Oracle Forms & Reports. Also trained a colleague on Oracle Forms & Reports, to work for the same project. Responsibilities include development, testing and maintenance of Oracle PL/SQL packages, procedures, functions, Oracle Forms, Oracle reports and training. Environment: Oracle Forms, Oracle Reports, Oracle 8 on HP9000 with UNIX B.10.20 and Cognos.

Involved in the development of an application that maintains the Inventory, Stock receipts and Transfers, Sales and Order processing of Shopko, a retail chain in Greenbay, Wisconsin, USA. Batch programs transfer data from the Mainframe to Oracle databases. Also involved in the design, development, testing and maintenance of an application named, IFMICS that was intended to assist the Maintenance Department of SINGAPORE AIRPORT TERMINAL to monitor and control its workshop and technical stores activities. FMS(Fleet Maintenance System) captures the historical data for all Ground Support Equipment/Vehicles, Costing/Billing, Third Party Clients and Contractors Works, schedules Preventive Maintenance, Staff Productivity Monitoring, Workshop Job Control etc. The average complexity on a scale of 10 is 8.5.Responsibilites include design, development and testing of the application, including development of prototypes, process specifications, Forms, Reports, PL/SQL packages, procedures and functions using Oracle database and Oracle Forms & Reports.Environment : Oracle 7.3 on Server - RS/6000 with AIX ver. 3.2.5, Oracle Forms and Oracle Reports.

Hospital Inventory Management System manages the inventory of a prestigious hospital.Responsibilities include development of Forms, Reports, PL/SQL procedures and functions using Oracle database and Oracle Forms & Reports. Environment : Oracle 7.3, Oracle Forms and Oracle Reports.

Developer 2000, Oracle Client/Server / Gui

Gniit(With A Specialization In Software Exports), Information Technology

B.Com, Finance/Commerce/Accounting