Mary Premila Immanuel Joseph's Location
Rocklin, California, United States, United States
Mary Premila Immanuel Joseph's Contact Details
Mary Premila Immanuel Joseph work email
- Valid
- Valid
Mary Premila Immanuel Joseph personal email
- Valid
About Mary Premila Immanuel Joseph
OBJECTIVE To serve as a Data Engineer for Database / Data warehouse development or BI/Data Analysis and Reporting with opportunities for professional growth. SUMMARY* Around 14 years of experience in Requirement Analysis, Design, Development and Testing of applications and reports using Relational databases, Data warehousing and BI technologies, serving esteemed clients like Google, Apple, Cisco and others.* Proficient in developing solutions with AWS with Spark on Hive, Databricks, Oracle 11G/10G, IBM DB2, IBM Netezza, MySQL 5.5, MS SQL Server, Google’s Dremel & F1 database engines via Plx, Tableau, Google Dashboards, 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 and reports. * Experienced in ETL/Loading data using Spark with Scala, Databricks, SQL*Loader, Slurpee/Plx Import, 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 UK and Canada as well.* Self-starter with excellent communication, analytical, inter-personal and team work skills. TECHNICAL SKILLS :DATABASES Hive, DynamoDB, Oracle 11g/10g, IBM DB2, IBM Netezza, MySQL 5.5, MS SQL Server, Google's Dremel & F1 SQL EnginesLANGUAGESSQL, PL/SQL, UNIX Shell scripting, Scala, Python, Java, HTMLTOOLSIntellij, Datagrip, SQL*Plus, TOAD, Oracle SQL Developer 2.1.1, SQL*Loader, Oracle Forms & ReportsAnalytics/ETL Spark, Databricks, Tableau, BigQuery, Google's Plx , Looker, Google Dashboards, Data Studio, CognosOSUnix/Linux/Goobuntu, Google's Chrome OS, Mac OS X 10.11, WindowsSpecialties: Data warehouse / Datamart development, ETL, Database development, Business Intelligence, Data Analysis & Reporting, SQL & Oracle PL/SQL Development.
Mary Premila Immanuel Joseph's Current Company Details
Google(Thru Motivity Labs)
Data Warehousing Engineer at Google via Motivity Labs
Mary Premila Immanuel Joseph Work Experience Details
-
Data Warehouse EngineerGoogle(Thru Motivity Labs) May 2024 - Present
-
Data Warehousing EngineerGoogle Via Adecco Jul 2020 - Dec 2023Zurich, ChPromoting 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. -
Sr Data EngineerLoanpal Dec 2019 - Jul 2020Roseville, Ca, UsEngaged 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 -
Data AnalystVsp Global Apr 2019 - Dec 2019Rancho Cordova, Ca, UsVSP 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. -
Bi DeveloperGoogle(Thru Globallogic Inc) Aug 2018 - Jan 2019Mountain View, Ca, UsGoogle 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. -
Bi DeveloperGoogle(Thru Globe Consultants) Aug 2017 - Nov 2017Mountain View, Ca, UsGoogle 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.
-
Bi DeveloperGoogle Inc Thru Tech Mahindra/Techsol4U May 2015 - Apr 2017Mountain View, Ca, UsI) "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
-
Sql DeveloperGoogle Inc Thru Globe Consultants Sep 2013 - Feb 2015Mountain View, Ca, UsServed 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.
-
Oracle DeveloperEbay Inc Thru Prospance Inc Jun 2013 - Aug 2013San Jose, Ca, UsPIX 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. -
Sr. Oracle DeveloperCisco Systems Thru Etouch Dec 2011 - Jan 2013San Jose, Ca, UsCisco 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. -
Database DeveloperApple Inc. Thru Volt Aug 2010 - Jun 2011Cupertino, California, UsServed 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. -
Data/Reporting AnalystRainmaker Systems Aug 2008 - Jun 2009Rainmaker 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.
-
Software EngineerHcl Technologies Feb 2000 - Nov 2001Noida, Uttar Pradesh, InDeveloped 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 -
ConsultantHexaware Infosystems Limited Jun 1998 - Jan 2000Worked 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.
-
Jr. Systems ExecutiveComputer Resources India (P) Limited Nov 1996 - Jun 1998Involved 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.
-
ProgrammerVictus Infotech (P) Limited May 1996 - Jul 1996Hospital 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.
Mary Premila Immanuel Joseph Skills
Oracle
Requirements Analysis
Pl/sql
Business Intelligence
Databases
Data Warehousing
Sql
Unix
Data Modeling
Sql Tuning
Software Development
Unix Shell Scripting
Performance Tuning
Oracle Sql Developer
Testing
Shell Scripting
Java
Oracle Reports
Relational Databases
Sql Loader
Sql*plus
Etl
Cognos
Solaris
Toad
Oracle Forms
Crystal Reports
Olap
Database Design
Oracle Enterprise Manager
Visio
Aix
Oracle Applications
Plx
Big Query
Placer
Tableau
Colossus
Mysql
Google3 Via Piper
Dremel
Plx Import
Google Dashboards
Mary Premila Immanuel Joseph Education Details
-
Oracle CorporationOracle Client/Server / Gui -
National Institute Of Information TechnologyInformation Technology
-
University Of MadrasFinance/Commerce/Accounting
Frequently Asked Questions about Mary Premila Immanuel Joseph
What company does Mary Premila Immanuel Joseph work for?
Mary Premila Immanuel Joseph works for Google(Thru Motivity Labs)
What is Mary Premila Immanuel Joseph's role at the current company?
Mary Premila Immanuel Joseph's current role is Data Warehousing Engineer at Google via Motivity Labs.
What is Mary Premila Immanuel Joseph's email address?
Mary Premila Immanuel Joseph's email address is ma****@****ail.com
What schools did Mary Premila Immanuel Joseph attend?
Mary Premila Immanuel Joseph attended Oracle Corporation, National Institute Of Information Technology, University Of Madras.
What are some of Mary Premila Immanuel Joseph's interests?
Mary Premila Immanuel Joseph has interest in Gardening, Technology, Yoga, Reading, Music, Music And Painting, Painting, Nature.
What skills is Mary Premila Immanuel Joseph known for?
Mary Premila Immanuel Joseph has skills like Oracle, Requirements Analysis, Pl/sql, Business Intelligence, Databases, Data Warehousing, Sql, Unix, Data Modeling, Sql Tuning, Software Development, Unix Shell Scripting.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial