Creating aggregate layer of data for supply KPIs using Apache Spark and Scala for multiple analytics teams. Configuring Presto for Analytics teams and tableau connector for presto. Performance tuning of spark jobs. Creating spark data pipelines. Experience with multiple Hadoop file formats parquet, textfile and sequence files. Creating incremental jobs to offload data from Oracle Exadata to S3. Creating data pipelines to send recommendations/deals for Customer Interests using customer search events, purchase and omniture (web) data. Created automated suite to detect data anomalies for various KPIs in primary ETL pipeline. Successfully used D3.js, Crossfilter and Pivot.js with Node.js supported by Mongo DB to create BI dashboards deployed on AWS EC2. Creating data loads for search and purchase attribution for various marketing channels and retail BEX data. Assisting Data science team to provide data for adhoc analysis and querying. Designed hive external and managed tables to store data into hdfs and tuning the files for optimum number of splits while reading the data.

Creation of new Market Basket solution for Dunkin Brands to understand affinity across products for the Dunkin and Baskin Robbins’ brands and Data warehouse for sales for all Franchisees. Data modelling designing unified star schema to ingest data from multiple POS feeds, defining hierarchies, maintaining data domains, standards. Dimensional modelling, defining SCD attributes and load strategy. Mapping attributes from POS feeds. Troubleshooting and providing solutions on day to day issues related to Dimensions, Facts, Aggregate design. Design and implement ETL module for loading sales transaction data from various POS systems into EDW, Designing the ETL framework, validating design for CDC, error processing and aggregate load strategy Migrate/ Build Franchisee Users Reports from SSAS Cube to Oracle Exadata. Modeling OBIEE RPD and creating new Subject Areas.Impact analysis on RPD. Planning for RPD merge, release, setting up MUD. Configuring OID for authentication. Developing security framework for new Franchisees. Impact analysis on RPD. Planning for RPD merge, release, setting up MUD.

Implementation of ADW Analytics Data Warehouse to provide standardized analytics reporting to the management of all organizations under EPM. Oracle EBS is used for supporting all business applications like Accounts Receivable, Accounts Payable, General Ledger, Manufacturing, Order Management, Inventory, Procurement etc. across EPM and it captures all the transactional data and serves as the source for the Data Warehouse Implementation of ADW Analytics Data Warehouse to provide standardized analytics reporting to the management of all organizations under EPM. Interacting and helping Business analysts to create the convert functional requirments into tech specs. Performance tunning of long running reports removing bottlenecks, pushing report run time calculations to ETL and storing the results for faster report run times. Closely working with DBAs to tune the overall throughput of loads and troubleshooting performance issues. Getting the highly fragmented tables re-orged. Developing new star schema and its ETL load for monthly load of Inventory Item exhibits, International Trade Compliance of different operating units in Emerson. ETL operations performance analytics created agents using Obiee delivers to send emails in case of ETL load failures and for long running jobs, for status of ETL loads, failures, load throughput, run time etc.. Modeled Obiee RPD to use Informatica Repository tables to generate reports for ETL loads . Mentoring junior developers and distributing tasks.

MIS Development – Development of reporting solution for new Data warehouse for UK Corporate Banking. The solution required 7 new Subject Areas based on the lifecycle of Credit Lending process. The SAs provide the reporting information for Credit Application Approval, Credit Documentation, Credit Monitoring, Excess management, Default Warning Indicators, Problem Management and Specialized Lending and Customer Financial Analysis. Developed ETL processes (mappings, worklets, workflows) using Informatica 8.6. Creating one time loads, historic patches. Reviewing and tuning the existing code for performance improvement. Implemented authentication, data level security according to Relationship Managers’ org level and Unit and object level access to dashboards and reports. Creating Implementation plan to production and supporting business checkout. Creation of a new data adjustment batch to be run after data checkout by Business team to correct the data values in the facts and dimensions. OBIEE Administration, RPD and web catalog deployment to ST, UAT and production . Configuring OBIEE scheduler and BI delivers to deliver reports through iBots. Constant interactions with the DBA and Infrastructure support teams to maintain dev/test environments space requirements and access issues Performance tuning of daily ETL batch, reduced run time of daily batch by 45% Developed high-visibility and high-priority Interactive Reporting dashboards for online reporting, RPD development and modelling, Implementing security.Enabling and mentoring business users to use BI delivers, BI office, Publisher and implementing OBIEE best practices. Configuring IBots to deliver reports based on conditions.

Design and Implementation of Integrated Data Mart for Enterprise car rentals. The aim of the project was to provide a streamlined reporting infrastructure and a dashboard environment to provide categorized delivery of information. Study and analyze new enhancements to the existing application as required by the Business Partners and produce a Technical design document. Develop ETL processes using Informatica 7 and validating data and code per specifications. Code migration between different environments. Analyzing and resolving production job failures reported by the application support team. Performance tuning of Informatica code for weekly and monthly batches. Modifying the entire batch load jobs in Autosys for Daily and Weekly jobs and testing comprehensively. Performance Optimization of existing Informatica code, implementing partitioning, persistent cache, optimizing lookups, source and targets, configuring workflows to run in parallel.