Saumya Balasubramanian
About
Saumya Balasubramanian is from San Francisco Bay Area. Saumya works in the following industries: "Computer Software", "Internet", "Insurance", "Computer Games", "Entertainment", and "Information Technology & Services". Saumya is currently Director of Data Engineering at Twitter, located in San Francisco Bay Area. In Saumya's previous role as a Engineering Manager - BI at Disney Interactive, Saumya worked in Palo Alto until Jan 2013. Prior to joining Disney Interactive, Saumya was a Senior Data Analytics Engineer at Zynga and held the position of Senior Data Analytics Engineer. Prior to that, Saumya was a Datawarehouse Architect/Manager at Esurance Data Warehouse from Jun 2005 to Jun 2010. Saumya started working as System Analyst at William Sonoma Inc in Mar 2003. From Jan 1998 to Jun 2005, Saumya was Programmer Analyst at Infosys. Prior to that, Saumya was a Analyst at Newyork Life Insurance from Sep 1999 to Mar 2003.
You can find Saumya Balasubramanian's email at finalscout.com. FinalScout is a professional database with business professional profiles and company profiles.
Saumya Balasubramanian's current jobs
People Analytics Data Engineering - Business Intelligence - Enterprise Integrations - Data Visualization
Saumya Balasubramanian's past jobs
Big Data @ Disney Responsibility: Hire and build the data warehouse team across multiple geographic locations. Manage migration to new data center (involving significant amounts of design and coding efforts along with co-ordination across multiple locations) Next generation database size and cluster estimation Determine technology choices to aid data growth and make data available for ad-hoc access. Database pruning strategies Work with Product managers by analyzing large sets of data – set up experiments and monitor metrics across variants for improving results. Work with Product managers in the mobile space to take into consideration changing requirements from iOS and Android platforms and architect a scalable and workable solution. ETL development work pulling data from disparate sources and make data available on Vertica DW. Technical responsibility/accomplishments: Identified data sets for data retention Redesign tables for optimized projections and space Data modeling for effective aggregation and analysis Staggered retention models across Vertica, Hadoop and archived spaces Unification of business metrics across different business units so as to standardize data model Optimization of mobile data pipeline to ensure near real-time data availability by optimizing across the data pipeline Hired, mentored and brought team up to speed
Project responsibility Set up the World’s largest clusters on Vertica (230 node cluster) – Production and mirror databases. Regularly work with Vertica on large scale product problems – diagnosing network layer issues, spread communication issues etc. Next generation database size and cluster estimation Work with Product managers by analyzing large sets of data – set up experiments and monitor metrics across variants for improving results. Migrate the existing database to the latest version of Vertica. Set up the data warehouse from scratch at new data center facility. Set up nagios alerting across different clusters of servers (approximately 1000 machines) to alert for hardware, memory and user defined thresholds Set up munin for monitoring machines Database administration for all vertica database implementations in Zynga (5 production databases with large cluster sizes) ETL development using Pentaho Kettle pulling data from disparate sources(external, Ztrack, MySQL databases) and make data available on Vertica DW.
Software : SQL Server 2005, Analysis Services (SSAS), SSIS, Cognos Responsibilities: Designed 40 cubes using SSAS 2005 using Star schema Migrated from Cognos to SSAS 2005 in a span of 3 months(40 cubes, 40 flat reports) Architected the new reporting portal after evaluating multiple solutions with the following components - dashboard, KPIs, cubes, flat reports Designed corporate dashboards and Key Performance Indicators for Senior Management Lead role in architecting policy data mart & claims data mart in Esurance data warehouse Database architect for the policy management source system (source system of 200 tables) Co-ordinated multiple projects in the data warehouse catering to a variety of business groups (Billing, Service center, Actuarial, Finance and Insurance Operations) Developed ETL for company financials such as Earned and Written Premium, Retention SQL server stored procedures and cleansing scripts Mentor and train team members to achieve the project goals
Software : Oracle 8.x, UNIX, Retek Data Warehouse Responsibilities: Application Support Lead for the Retek Data Warehouse at the back-end using Oracle Develop and execute Conversion plan (ETL) in a span of less than 3 months per brand Star Schema Modeling design Customization of Retek's ETL code for specific requirements (Ex: Reject Processing) Interact with different Business Teams for requirements from Data warehouse Co-ordinate with Retek (now Oracle) (RMS/RCOM/ReSA changes) Guide offshore test team with requirements and designs Report generation for Data Validation by the business
: Solution Modeler - Module Leader Technology : Oracle 8i, PL/SQL, AMARTA, Oracle App Server, HTML, UNIX, Solaris; Data Modeling Design for Insurance application - ERWin Interacted with the development partner Sherwood, and was part of their design team Team rolled out new system in 8 months in India (designed and developed from scratch) User Interface and menu design Design and Testing of the Back End subsystems Gave presentations to the Client on the system developed and design aspects of the back-end Technical design mapping the business requirement to the system using workflow methodology for Product Management, New Business and Policy Services Played a key-role for the rollout in Philippines Worked on approaches to support global rollouts with minimal deployment time from a technical and domain perspective Resume_Saumya Page 1 of 2