Ranjith Muttineni
Engineering Manager, Data Applications · OpenX Technologies
Work Experience
Engineering Manager, Data Applications
OpenX Technologies2017 – 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 Automotive2012 – 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 Inc2011 – 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 Fargo2008 – 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 Inc2006 – 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 Solutions2005 – 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 Info2002 – 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 University1998 – 2002
Bachelor of Engineering in Computer Science
Linkoping University
2003 – 2005