Sql Server Management

SHAYON SANYAL

*** ******** ***, **********, ** **144 (412) 961 – 2854 ******.******@*****.*** https://www.linkedin.com/in/shayonsanyal

EDUCATION

Carnegie Mellon University, Pittsburgh, PA Aug 2013 – Dec 2014

Master of Information Systems Management GPA: 3.59

Teaching Assistant: 70-455 Modern Data Management (Tepper School of Business)

Relevant Coursework: Database Management (Oracle 11G), Data Warehousing, Art and Science of Business Analytics (SPSS), Business Intelligence and Data Mining (SAS), Programming R for Analytics, IT Service Management

University of Pune, Pune, India Aug 2005 – Jun 2009

Bachelor of Engineering, Information Technology First Class

PROFESSIONAL EXPERIENCE

The Boston Consulting Group (BCG), Boston, MA Apr 2015 – Present

Senior Data Analyst

Optimized the ETL process by 80% with SSIS to drive strategic value in retail pricing for a pet product retailer backed by a private equity firm

Revamped the compliance functional tool of a German bank to fulfill requirements from settlement agreements with US regulators

Optimized the data analysis for a PMO transformation related project by 30% for a diversified North American specialty metals manufacturer

Automated (VBA) competitive intelligence on cost drivers and operational efficiency in package delivery for a US postal services operator

Conducted a pricing diagnostic and developed a new pricing strategy for the corporate banking business of a US regional bank

Developed value concept comprising in its core a new pricing strategy and architecture to drive a stronger "value" perception across the menu board for a fast food restaurant chain

Nomura Holdings, Inc., New York, NY Jun 2014 – Aug 2014 and Feb 2015 – Mar 2015

Technology Analyst Intern

Worked in Agile environment to gather and document functional user requirements in the front office Credit team (Global Markets IT division)

Built, tested and deployed low-latency, high performance web applications to production using Java, JSP, servlets, AJAX and JQuery

Developed an analytical testing tool for bond parameter comparison using Java to reduce overhead time from 6 min to under 1 min

Automated analytical bond calculations by web service calls to analytic APIs in Java/Spring MVC which reduced manual intervention by 95%

Developed an intuitive user interface for bond-to-curve mapper algorithm using CSS3/HTML5 for seamless user experience

Infosys Limited, India (client site) Total Experience: 3 years 4 months

Business Data Analyst – Service Operations Nov 2009 – Mar 2013

Primary SME for GSX (a CRM-based CIO Top 10 App), GSX Data Services and GSX Online (Microsoft Dynamics CRM Online reporting tool)

Troubleshot, analyzed and resolved application related T-SQL issues for 55 servers and improved application performance by 30% on average

Improved SQL Server query performance by 40% on average using SQL Server Profiler/Database Engine Tuning Advisor

Created SSIS packages for ETL tasks and tuned SSIS dataflow tasks to optimize the extraction, transformation and load performance by 30%

Managed bug triages with Engineering, Operations and vendors to stack rank and prioritize bugs in the operations post major releases

Identified and troubleshot issues with backup jobs, stored procedures, deadlocks, blockings, I/O, memory, disk space, database connectivity and security thus ensured 99% application uptime

ACADEMIC PROJECTS

Social Media Data Mining – Student Consultant (A.T Kearney Student Lab, Tableau/SPSS/LightSide) Dec 2014

Developed a POC to identify factors that best drive purchase decisions for a given product predicted by social media data mining

Used SPSS, Tableau and LightSide to identify trends related to consumer sentiment and helped generate 8% growth in net sales/revenue

Market Basket Analysis and Predictive Modeling (SAS Enterprise Miner) Dec 2014

Performed cluster segmentation, derived association rules and built decision trees to develop a predictive model for a financial institution

Developed recommendations and targeted advertising campaigns using regression to find out customer adoption rates in specific regions

Multichannel Advertising Data Analysis (MS SQL, SSIS, SSAS) Oct 2014

Designed the ETL roadmap, strategy and architecture for impact analysis on unstructured data for a social media enterprise warehouse

Generated OLAP cubes using operational data store, MS SSIS and SSAS in Excel to implement data analytic services for business users

Rental Car Database Management (Oracle 11G) Oct 2014

Consulted stakeholders to design the data model, schema, ER diagrams with consideration of data redundancy and data consistency

Designed advanced SQL queries and functions for data and metadata retrieval and maintained data integrity constraints

TECHNICAL SKILLS

BI Tools: SSIS, SSAS, Tableau (Basic), SAS Enterprise Miner (Basic), Alteryx, RStudio

Reporting Tools: Microsoft Excel, PowerPivot

Programming Languages: Java, VBA, R (Basic), JavaScript, HTML, CSS, SQL/T-SQL, UNIX

Other Tools: SSMS (SQL Profiler), Microsoft Office Suite 2013, Microsoft Visual Studio 2012, Visio, TFS, ERWin

Databases/RDBMS: Microsoft SQL Server 2008R2/2012, Oracle 11g

EXTRA CURRICULAR ACHIEVEMENTS

ITIL v3 Foundation, Microsoft SQL Server Database Development and Microsoft SQL Server Implementation and Maintenance certified

Heinz College Admission Ambassador, Heinz College Consulting Club (Vice President) – Carnegie Mellon University

Contact this candidate