vinay gupta

Improved service sales. Was responsible for all national/commercial accounts and ensuring that payments were received on time. Service sales increased by 50% and overall store profit by 25%. Selected, defined and promoted standards for technology across the entire retailing store, consisting of multiple business entities. Maintaining the payroll for the store.

* Over seeing the Insert Process data and ensure that the all data provided to the upper management is accurate. * Solving any data warehousing issue for any given inserts. * Writing SQL queries to pull data which can be utilized by the end user. * Providing training materials on how to use Cognos reporting tools. * Analyzed and planned business projects. * Created quantitative and statistical business models by using MS Excels data analysis program, solver function, statistical and financial functions. * These models include budgeting, customer buying frequency, and scheduling. * Project Six Sigma – Analyzed and developed solutions to decrease turnover. * Supported upper management in various business operations. * Involved heavily in creating a marketing strategy and conducting extensive research in order to find new contractual business ventures. * Lead the Local Marketing team in enhancing the Tool Kit Website for the stores. * Helping the Insert Performance team in modifying how the data housing is performed, using Microsoft SQL Server and Teradata.

* Creating SSRS reports using Visual Studio 2012/2013 and Report Builder 3.0 * Setting up SQL Servers with Windows Clustering and High Availabilities * Monitoring servers, including Deadlocks on production systems * Created and implemented operational dashboards. * Responsible for database server performance analysis, monitoring, and patching * Data modeling, query design and optimization, stored procedures * Create stored procedures, ETL processes for Reporting databases * Knowledge of SQL Server 2012/2014

* Data modeling, query design and optimization, stored procedures * Developed all the required stored procedures, user defined functions, triggers using T-SQL. * Creating reports using SSRS (Report Builder 3.0 and Visual Studio 2010) and PowerPivot (MS Excel 2013) * Build Tabular model using Visual Studio 2010 for the Distribution Services, Inc. (DSI) * Responsible to process data mining activities to gather data and compile it to make a thorough analysis * Worked extensively with client gathering requirements to generate customized SQL reports. * Analyzed and planned business projects * Created data warehouse models to pull data for analysis

Mutual of America has specialized in providing retirement products and related services to organizations and their employees, as well as individuals, for over 70 years. As a mutual company, we do not have stockholders and are not publicly traded. We operate solely for the benefit of our customers, managing the Company for their long-term interest, rather than for the short-term demands of stockholders.Since 1945, Mutual of America has remained committed to offering plan sponsors, plan participants, and individuals carefully selected, quality products and services at a competitive price and the personal attention they need to help build and preserve assets for a financially secure future. Integrity, prudence, and reliability are the values that have guided us since our inception and that continue to serve us well. For more information, please visit us at mutualofamerica.com.