I am a full stack data scientist with extensive experience in statistical modeling, machine learning and big data analytics, who enjoys building data products
Global Insights Manager, Data Scientist @ Focused on helping Clorox drive an even deeper understanding of their consumers in the digital world From December 2014 to Present (1 year 1 month) San Francisco Bay AreaConsumer Analytics Intern : Data Science @ LeapFrog, Consumer Analytics Team
Role: Data Scientist Intern
Tools: R
• Worked on setting up the data platform for analytic through integrating data sources
• Built survival analysis models for analyzing consumer churn
• Segmented customers based on the survival rates and helped Leapfrog to understand behavior of customers under each segment
• Provided recommendations to reduce and avoid churn of high value customers
• Build dashboards using Shiny(R) to operationalize churn model From June 2014 to December 2014 (7 months) San Francisco Bay AreaGraduate Research Assistent: Data Analyst and Project Manager @ UConn, Center for Health, Intervention and Prevention (CHIP)
Role: Data Analyst and Project Manager for Bio-Statistics Research Projects
Tools: R, SAS, SPSS and STATA
• Led a team of undergraduates to build statistical models for Meta-Analysis using R which aids to explain bio-behavioral outcomes in the field of social and health science.
• Collected data from researchers across the globe and analyzed and integrated large datasets which aids the undergraduates to fine tune the statistical models and test them with real time data.
• Conducted weekly meeting for monitoring research work progress and performed SAS and R code review. From January 2014 to June 2014 (6 months) StorrsSoftware Engineer, Cognos BI consultant @ Clients: Health Care providers, MI & RI, USA
Role: Business intelligence consultant for Cognos
Tools: Excel 2013 & Cognos 10
• Closely worked with Chief Financial Officer of the company to understand current and future requirement.
• My role was to provide cognos consulting solutions to improve their current organization BI system which predominantly uses excel.
• Initially helped to create reports related to remittance advice and financial check verifications.
• Created business requirement document and technical specification documents.
• Mentored developers to understand the current BI system of the organizations and how Accenture is going to enhance it. From December 2012 to June 2013 (7 months) Chennai Area, IndiaSoftware Engineer, Metadata Modeler @ Client: Top Manufacturer of construction and mining equipment, IL, USA
Role: Cognos Metadata modeler & Business Analyst
Tools: Cognos 7 impromptu, Cogons 8 & 10 Framework Manager, Transformer & Power Play.
• Gathering requirements from client, create and maintain Meta data model in Cogons FM.
• Developing, unit testing and maintaining Cogons cubes using Cognos Transformer.
• Lead two-member team for Cogons 7 & 8 administration and enhancements. From February 2012 to December 2012 (11 months) Chennai Area, IndiaSoftware Engineer, ETL Developer @ Client: Top US Dental Care provider, NJ, USA
Role: ETL Developer & Business Analyst
Tools: SSIS 2005 & BO Universe
• Initial role is to develop ETL jobs using SSIS packages for populating the Enterprise Data Warehouse.
• Worked on a reusable code, this reduced development time to 60 – 70% for around 10 packages.
• Trained and Lead two-member team of ETL developers.
• Unit testing ETL job using SQL queries written against the ETL packages.
• Understood varies subject areas like member, claims and provider and there relationship in EDW.
• I have taken up the role of Business Analyst, while implementing summary load on top of EDW.
• Primary role to gather requirement from client and converting them into technical documents.
• Technical document includes database design and mapping documents from source to target.
• Developed an analytical data mart called ‘Cost Containment’ for summary load using SSIS.
• Have received due appreciation from client for providing end-to-end solution.
• Achieved ‘Zero UAT defects’ for Cost Containment module; this module has a code complexity of 3000 LOC. From January 2011 to February 2012 (1 year 2 months) Associate Software Engineer, Cognos Developer @ Client: Top US Health Care provider, MI, USA
Role: Cogons Developer
Tools: Cogons Report Studio & Query Studio.
• Primarily worked on developing Cogons 8 Reports.
• Learned every nuances of US health care business.
• Unit testing reports using SQL queries written against the reports.
• Performance tuning using SQL stored procedures to improve report response time. From June 2010 to January 2011 (8 months) Chennai Area, India
Master of Science (MS), Business Analytics and Project Management, 4/4 @ University of Connecticut From 2013 to 2014 Bachelor of Technology (B.Tech.), Information Technology @ Anna University From 2006 to 2010 Naveen Kolagatla is skilled in: Data Warehousing, Business Intelligence, Network Communications, SQL, ETL, Informatica, Data Modeling, C++, Teradata, Data Integration, cognos, Datastage, SAS, Cubes, Predictive Analytics