Anu Ram Email & Phone Number

Sacramento, California Area

Use SQL *Loader to populate tables for Data refresh based on Renewal opportunity, Last Date of service, Uncovered service, Attach rate for service. Use cursors ,bulking techniques, parallelism, Indexes to maximize performance.Work on analyzing and providing the correct requirements for Dimensional hierarchies, Aggregate tables for Drill-down and aggregate navigations . Work with the ETL team to make sure that all ETL jobs are run on time so that refreshed data is available for OBIEE reporting.Scheduled Mapreduce jobs for Ib Reconciliation (Oracle Ib Recon engine migrated to hadoop) processing in the Hadoop clustered environment. Develop PLSQL Packages(processes for fixing IB data) for Install Base Reconciliation project.

Oakland

Install Hadoop ecosystems components which includes Apache Hadoop(HDFS and Mapreduce), Hbase, Hive, Pig and Flume. Monitor Hadoop cluster environment using Ganglia.Set up Linux users and test HDFS, Hive, Pig and Map Reduce access for the new users.Perform hadoop cluster capacity planning, manage and review data backups. Works with the Systems Engineering team to plan and deploy Hadoop hardware and software environments .Manage and Review Hadoop Log files . Works with the application team to install Hadoop updates, patches, version upgrades as required.

Greater Los Angeles Area

Built the Physical Layer, Business Model and Mapping Layer, Presentation Layer of a Repository by using Star Schemas.Worked with System Engineering team to design - Facts & Dimensions for Repository.Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.Created charts for OBI reports and BMM Design documents for all the Business models. Created interfaces, procedures, packages, scenarios and scheduled the scenarios in Oracle Data Integrator.Wrote PL/SQL Stored Procedures, triggers and created Indexes for maximum performance.Documented routine tasks like ETL process flow diagrams, mapping specs, source-target matrix and unit test documentation.

Mumbai Area, India

Preparation of Test documents such as Test Scripts in TD and their corresponding Test Results documents.Development of program to inactivate a year old vacant positions. Tools Used- Application Engine, Component Interface and Application Designer.Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer. Extensively worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter, Sequence Generator, etc.

Mumbai Area, India