Murali Krishna Parimi Email & Phone Number

Naperville, Il, Us

Menlo Park, Ca, Us

Miami, Florida, Us

Helping OptumRx migrate on-premise warehouse built in Netezza to Azure cloud using ADLS and Azure synapse warehouse using Apache Spark and Azure data factory. Manage on-premise ETL cluster as a member of Center of Excellence for Data Engineering platform. Write IAAC using ansible and terraform. Debug performance issues with apache spark code, write adhoc spark code to process data.

Miami, Florida, Us

For Fedex:• Lead a team of 5 junior members to automate setting up ETL data infrastructure across many clusters that brought down the setup time from days to under 30 minutes no matter the size of the cluster.• Created a POC to compare google Big query and Azure synapse to create enterprise warehouse and eventually decided to use Azure synapse.

Miami, Florida, Us

For Central Garden & Pet:• Setup ETL data infrastructure on Azure with ansible, define code migration strategy and automation• Setup MSSql on Azure and manage multiple databases including access setup.• Extract data from salesforce and sap systems and load into Ms SQL server on azure.• Managed large group of offshore teams to successfully deliver the projects on-time to customer.

Miami, Florida, Us

For Ciox Healthcare Technologies:• Write complex Sql queries to understand the various data silos to arrive at an understanding of the relationship of various data sources/syncs.• Defined a data model (facts and dimensions) to integrate various data sources to ensure one true version of data is available.• Setup ETL software on AWS Linux VMs using Ansible.• Understand existing Java application to design new application to be written in proprietary ETL tools.• Written jobs that will load data from on-premises to S3 buckets and then to AWS redshift.• Automated code promotion from one environment to other environment with minimal manual intervention.

Miami, Florida, Us

Led an internal project to setup training environment using Mapr Hadoop cluster on Aws cloud.

Miami, Florida, Us

For TransUnion:• Compared performance of vendor specific ETL tools and Apache Pig to process large amounts of data.• Written ingestion frameworks to ingest data from variety of international acquisitions made by Transunion and create data lake and supported business user community to get them access to data (Apache hive, Spark and R were used by user community)• Compared performance of ORC and Parquet format and moved all the files written earlier in ORC to Parquet format.• Orchestrated jobs using Autosys.

Miami, Florida, Us

Led the efforts to start a company from the scratch, participated in recruiting/interviewing talent for data engineering projects and manage deliverables from India solution delivery center.

New York, Ny, Us

For Citi Bank:SMC will process various vendor market data feeds and integrate them into a central data repository to present a market view of securities.Various internal and external data feeds will be merging together to provide a single security record and create a golden source representation of the security indicatives forfixed income, equity and listed derivative products. There will be field level hierarchies used to determine the ultimate golden source for each data attribute.A variety of state of the art web interfaces for data browsing and maintenance will be available to view and manage the data.> Discuss with BA over the abinitio design> Understand the ETL mapping documents, prepare low level design document.> Develop Abinito plans which will be run with Autosys scheduler.> Responsible for the deliverables till they go live and provide level 3support> Understand the financial reference data industry> Helping and guiding colleagues in terms technical issues

Armonk, New York, Ny, Us

For TD bank, Canada:Lead an ETL effort to create a central repository to obtain metrics on key performance and risk items. The central repository will help each business owner with a dashboard reporting of key performance and risk indicators. Few metrics that were enabled Measure progress toward organizational goals  Identify risks and exposure of the group Provide decision intelligence directive towards positive (corrective) action Provide required oversight of key controls and activities Monitor the overall health of the businessDesigned the data model and worked with Business analysts to identify the key metrics. Managed a team of junior developers.

Troy, Michigan, Us

For Allstate Inc:Worked as a senior developer to redesign of existing Claims-Standard Layer in ADW from third normal form (3NF) to a dimensional model constitutes the purpose of optimizing reporting performance and decision support query performance in ADW, relative to a measurement or set of measurements.

Bangalore, Karnataka, In

For Capital One:Project1: Remediate the process of agent commission calculations and disbursements and to shelter the data on the agent commission systems for crystal reporting. The current process involves Web Focus which provides the agent data for reporting. As part of this project the Web Focus code is re-engineered using the Ab Initio ETL tool in the format required for crystal reporting.Project2:The project In store Instant Credit is about applications being filed for a new account at one of Capital One's partner store. The objective is to build the capability required to receive applicant information from a partner (in-store), make an instant credit decision, and communicate account information back to the partner to enable a first purchase.We shall load and store the partner identification information (Application ID, partner ID, partner region, etc.,) associated with all applications (approve and non-approved) in the analytical warehouse on a daily basis. We shall also load and store the customer's identity verification information (type of identification, ID number, Issuing state, etc.,) for only the real-time approved and soft-declined applications in the analytical warehouse on a daily basis.The solution shall provide the ability to link the customer identity verification and partner identification information to CASH (Centralized Application System History) database using Application ID.For Wachovia (now Wellsfargo):Project1: The ETL layer extracts the data from source systems and loads into the warehouse. This Project is to develop a data mart by integrating all applications of Wachovia. The data mart should be Basel II compliant. Basel II is a set of standards for banking sector in order to eliminate the risk to the bank. This new data mart should support to develop new applications that are aimed to reduce the risk. Reporting layer pulls data from the data warehouse and generates reports.