RM

Ranjith Muttineni

Engineering Manager, Data Applications · OpenX Technologies


Work Experience

Engineering Manager, Data Applications

OpenX Technologies

2017 – Present

• Responsible for managing various highly scalable Data Analytics platforms including Snowflake, Vertica, Impala, Druid and two reporting platforms designed to meet the requirements of External and Internal users including the UI • Proven experience with leading team of 10+ Data Engineers, Software Engineers and DBA's • Managed and lead the development effort for various projects including providing reporting application in Japanese, reducing the timeouts in Reporting application. • Established and executed upon delivery methodologies, service level agreements, and underlying technology and processes to drive the team to find the right balance of agility, quality and consistency • Key contributor in designing the road map for the next generation Analytics Platform • Successfully managed completion of database migration from Vertica to Snowflake • Experience managing 1.5 petabyte size database, python and SQL based ETL's for Vertica and Snowflake, Spark, Kafka, Python and Java based pipelines using containers and Mesos for Druid • Partnered with HR to manage staffing levels, compensation, performance management reviews, and team member career development • Managed homegrown UI application powered by MicroStrategy, Vertica/Snowflake used by 10,000 users • Kickstarted Google cloud Migration of ETL and Reporting applications utilizing Docker and Kubernetes • Collaborated with Product and successfully delivered various end to end solutions in a fast paced environment

Sr Business Intelligence Engineer-Lead

Cox Automotive

2012 – 2017

• Managed and lead the development effort for various projects at KBB • Responsible for architecting the new data coming into the system and developing the reports, Documents and Dashboards • Implemented Auto Intender Engine project using Various AWS products like EMR, Data pipeline, Lambda, S3, SNS, Athena and Redshift • Implemented multiple AWS Data pipelines to ingest and process data programmatically using json, shell and python. These pipelines launch and shut down the clusters programmatically. • Developed Visualizations and Dashboards using Tableau • Developed Hive scripts to load data in EMR using S3 as storage • Developed Big Data Analytics project (Local ad Platform)using Platfora, Cloudera Hadoop • Performed multiple upgrades of MicroStrategy from 9.3.1 to 10.1.0 and 9.2.1m to 9.3.1 and 9.0.1 to 9.0.1m • Responsible for administration of the Microstrategy in Linux environment and Integrated D3 visualizations into MicroStrategy Visual Insight. Developed Dashboards for web and Mobile (Ipad). • Solid understanding of the Adobe Omniture and Google DFP data

Business Intelligence Architect

Resource America IT Inc

2011 – 2012

• Upgraded MicroStrategy environment from 9.0.1 to 9.0.1m • Provided valuable insights during purchasing new MicroStrategy licenses and Petco was able to save huge amount • Developed more than 25 enhancement projects using most of the available MicroStrategy features • Created the new 64 bit MicroStrategy environment and retired the 32 bit system • Led the team in the data center migration which included 5 MicroStrategy servers, metadata databases and Netezza database • Designed interactive and dynamic dashboards using multiple panel stacks, Widgets and Grid/Graph combinations

Database Analyst IV

Wells Fargo

2008 – 2010

• Lead Architect and Developer for Integration of GE Money Warranty Services into Wells Fargo Dealer Services Data Warehouse • Took initiative and redesigned around 25 narrowcast services to deliver the reports at higher level to save on licensing costs which ultimately saved around 400 Narrowcast user licenses • Improved performance of multiple reports that run at peak time by 50% using SQL hints, VLDB properties and materialized views. These changes made the system capable of handling the month end reporting • Responsible for managing the DEV, QA, DR and PROD environments including Upgrades, administration, Architecture and object migration

Sr. MicroStrategy Developer

Propelsys Technologies Inc

2006 – 2008

• Responsible for setting up the complete QA (Quality Analysis), DR (Disaster Recovery) and Production environments including all the repositories • Created Reporting Services Documents and Dashboards, Narrowcast services using personalization and Freeform SQL Reports to implement some complex user requirements • Implemented around 50 enhancements since the project go live most of which included only me from MicroStrategy team

Programmer Analyst

Synerzy Software Solutions

2005 – 2006

• Developed MicroStrategy Schema objects, Application objects and Delivery objects • Created logical data models, recognized source tables and columns, to build, Attributes, Facts, metrics, Freeform sql reports, Datamart reports, Report services Documents, Transformations, Custom Groups, Consolidations, logical tables Hierarchies and Relationships

Sr. Programmer

Tricad Info

2002 – 2003

• Extensively used Data Tables, Developed SQL, PL/SQL queries • Implemented data integrity, indexes, views, created PL/SQL stored procedures and triggers and developed reports using Crystal Reports from multiple tables using ADO

Education

Bachelor of Engineering in Computer Science

Bharathidasan University

1998 – 2002

Bachelor of Engineering in Computer Science

Linkoping University

2003 – 2005