Vinay Shankar T S

Vinay Shankar T S 945 10th Main 13th Cross-Bangalore 560064Ph. No:- Experience Summary Have total of 9.3 years of experience in the MSBI Tools and 2.8 years of .Net(C#)technologies with overall 11.11 years of experinece Prime area of expertise is design, development and testing of Data Warehousing and Business Intelligence Applications. Have also has good exposure in development Windows based Applications using .NET Frameworks. Good hands-on experience in C#,ASP,XML,XSL,Info Path, SQL, SSIS, SSAS, SSRS. Sound Knowledge in DW design principles & best practices Has worked for Microsoft Corporation as a part of his assignments at Onsite in US (Seattle) and worked on Offshore – Onsite Model NTT Data global delivery solution Internal PMP certified. Currently working with Mindtree. Technical Skills Operating Systems Microsoft Windows (98, 2000, XP, Vista & 7) Databases MS SQL Server 2005 / 2008/2012 ETL & BI Tools SQL Server 2008 BI Components (SSIS,SSAS, SSRS) and Office Excel Languages T-SQL, PL-SQL, C#, XML,XSL , ASP.NET Version Control Systems Team Foundation Server, SharePoint 2010,Product Studio, Source Depot  Script Languages Other Tools Java Script, Word ML, Action Script, HTML,Macros InfoPath, SharePoint & Visio,Mpp PROJECT NAME Avis and Budget Group -ABG Client Aella-ABG Duration October 2018- till date Role Technical Lead (team of 5) Project Specific Skills SQL Server 2012 , SSIS,SSRS Project Description : As part of the Scandinavian acquisition ABEL is keen to migrate the AELLA Fines and Etolls from Telecomputing environment to ABG EMEA controlled environment. Fines and eTolls together is a single web application. Fines is used by all the Scandinavian countries. Whereas, eToll is specific to Norway. For Fines the customer is liable for any traffic penalties incurred during the hire period, or while awaiting collection and eToll application is used to generate the detailed information of tolls that the customer needs to pay. Roles and Responsibility Analysis and assessment of existing systems/applications Requirements Understanding, Feasibility Study, System Analysis, Design, Developmentand Testing. Development/Migration and Peer review Interact with the Business users to review the system requirements. Liaise with Teams to execute different modules. Interact with the onsite team to review the system requirements and provide gap Analysis Providing support for Project management activities Perform high level business analysis and co-ordination with customers to prepare functional/technical specifications. Maintain and Disseminate Project Weekly /Monthly Status Develop, Analyse and Manage Project Issues and Risks  PROJECT NAME First American Client First American Duration January 2018- October 2018 Role Technical Lead (team of 7) Project Specific Skills SQL Server 2012, Map to Code,Duck Creek CLIENT DESCRIPTION First American Financial Corporation is a United States financial services company and is a leading provider of title insurance and settlement services to the real estate and mortgage industries.First American Family of Companies’ core business lines include title insurance and closing/settlement services; title plant management services; title and other real property records and images; valuation products and services; home warranty products; property and casualty insurance; and banking, trust and investment advisory services PROJECT DESCRIPTION Implement data PAS First American existing application with usage of map to code designed and developed by Duck creek. Lead program management, Project governance, Scope and issue management for the data integration components of the SIS with DCT Components Roles and Responsibility Interact with the Business users to review the system requirements. Liaise with Teams to execute different modules. Interact with the onsite team to review the system requirements and provide gap Analysis Query performance tuning (SQL) and enhancements Configuration and Customization SQL for loading Policy, Billing and Claims data. Design, customize and deploy the work, with aim of optimizing operational efficiency. Defect Fix and Deployment support of Policy, Claims and Billing Data Develop, Analyze and Manage Project Issues Providing support for Project management activities Perform high level business analysis and co-ordination with customers to prepare functional/technical specifications. PROJECT NAME Tennessee farmers life insurance company Client Tennessee farmers Duration May 2015- Aug 2017 Role Tech Project Manager –Lead (team of 9) Project Specific Skills SQL Server 2012, SSIS, SSAS,SSRS, Excel (with VBA) C# CLIENT DESCRIPTION The Tennessee Farm Bureau is the nation's largest state Farm Bureau organization, with more than 650,000 member families. The success of the insurance operations in Tennessee helps drive that figure. Farm Bureau Insurance covers one in four people in Tennessee. PROJECT DESCRIPTION Tennessee Farmers Life Insurance Company (TFLIC) seeks to implement the ALIS Policy Administration System provided by Sapiens in order to lower total cost of ownership and take advantage of modern technology trends for its life and annuity products. In order to support TFLIC’s Project goals, NTT DATA will:  Solution and implement the data integration of ALIS PAS with Tennessee Farmers’ existing application ecosystem Lead program management, Project governance, Scope and issue management for the data integration components of the Polaris implementation  NTT DATA shall conduct the Project leveraging NTT DATA’s Data Management Framework for Insurance (DMFI).  Implementation of the framework includes requirements gathering, solution architecture, high level and detailed design, development and unit testing, integration and system testing, support for user acceptance testing, and implementation.  Roles and Responsibility Analysis and assessment of existing systems/applications Requirements Understanding, Feasibility Study, System Analysis, Design, Developmentand Testing. Reconciliation, Responses to user queries/ data requests Query performance tuning(SQL) and enhancements and Peer review . Assists Program Manager with developing Project  Management Plan Direct and Manage Data Integration and Conversion Project Activities Plan Resource Acquisition and Optimization.Participate in External Audit .Maintain and Disseminate Project Status Develop, Analyse and Manage Project Issues .Identify, Analyse and Manage Project Risks  Assist with Track Budget & Resource Allocation .Creates detailed design documents, and reviews documents produced by team.Identifies reusable code components across Project PROJECT NAME MSFT Project Unity Client Microsoft Corporation Duration December 2011- April-2015 Role BI Lead Project Specific Skills SQL Server 2008, SSIS, SSAS, SharePoint, TFS, Excel (with VBA) C# CLIENT DESCRIPTION Microsoft Corporation is the world's largest software maker measured by revenues headquartered in Redmond, Washington, United States that develops, manufactures, licenses and supports a wide range of products and services related to computing. PROJECT DESCRIPTION Microsoft Enterprise Services is re-architecting its business intelligence (BI) environment to support its needs for providing more integrated reporting and analytic support for the Enterprise Services organization. It is anticipated that this environment will provide consistent, accurate, timely and relevant information to support Enterprise Services decision-making processes. This project aims at providing accurate and highly refined data by bringing all existing disparate data platforms/sources under one roof by the name of Project Unity at the same time proving Self-Service BI capabilities to the user. Roles and Responsibility Analysis and assessment of existing systems/applications Requirements Understanding, Feasibility Study, System Analysis, Design,Developmentand Testing. Microsoft Enterprise Services is also providing additional features like Geo based and Role based security, inclusion of additional source systems, new metrics and logic change for the existing Scorecard system on the Unity Platform. Named calculation ,NamedQueires. Data Profiling, Data Analysis,Reconciliation, Responses to user queries/ data requests Challenges: Design & Development of complex multi-source dimensions with varying structure/hierarchies/data Development & testing of Data Structure, ETL Packages, OLAP Cubes & Excel Reports. ETL Design and Development using SSIS 2005/2008. Query performance tuning(SQL) and enhancements PROJECT NAME Microsoft Enterprise Services Maintenance – ES Scorecard Client MicrosoftCorporation Duration January 2011 – November 2011 Role BI Developer Project Specific Skills SQL Server 2008/2005,SSIS,SSRS,SQL,SSAS (SSAS, SSRS) Performance Point Monitoring Server PROJECT DESCRIPTION Enterprise Services is in the midst of an evolution towards a more intentional sales strategy, focusing sales and delivery efforts on creating and incubating new markets while increasing support of partners for mature technologies. This shift requires a new focus and new investments, at the same time as balancing aggressive revenue and margin goals. To effectively strike this balance, we need a new dialogue around performance, one that takes a more holistic approach to all of our goals and helps us discuss and manage the trade-offs. Roles and Responsibiliy Obtaining and clarifying the business requirement in discussion with Onsite coordinators. Providing estimations Development of ETL stored procedures.Creation and maintenance of Excel based reports Testing & validating the reports for data accuracy.Preparing automation tools for data validation using Excel.Analyzing root causes of data discrepancies & identifying resolutions.Review of work items Manage the onsite-offshore communication on a daily basis PROJECT NAME Microsoft LSG Client Microsoft Corporation Duration Dec 2008 – Dec 2010 Role .Net Developer Project Specific Skills Visual Studio,JavaScript, C#, XML, XSL,CSS,WordML,InfoPath,Windows Service, Action Script, SharePoint administration CLIENT DESCRIPTION Microsoft Learning (MSL) .They builds innovative learning products that enable users to make the most of their investment in Microsoft technology. They offer a diverse range of products including classroom training, e-learning, certification, Microsoft Press books, skills assessments and more to serve the needs of customers and partners worldwide. PROJECT DESCRIPTION Learning Services Group Sustained Engineering (LSGSE) provides essential support, maintenance services and development work for released LSG systems and tools enabling the Learning Services Group to focus on future projects and development needs. Aim of this project is to provide support might be in technical, or knowledge sharing which is user Support Services . Roles and Responsibility Interaction with clients and onsite team lead.Involved in requirement analysis and design of the features.Internal discussion and organizing Team Meetings and KT with off-shore team members Design & Development of team site using SharePoint Design and development of the application and Designing InfoPath forms as a user entry mechanism Providing technical support to user and knowledge sharing of applications and guiding the users on functionality side PROJECT NAME Microsoft LCDS Print Client Microsoft Corporation Duration June 2008 – Dec 2008 Role .Net Developer Project Specific Skills Visual Studio,JavaScript, C#, XML, XSL,CSS,Word ML PROJECT DESCRIPTION Learning Content Development System is a forms-based tool for creating-learning content. LCDS is designed for authors and trainers who need quick and easy way to compose content. The scope of the project was to convert the following Author Content from xml to Word Document: Text and Picture.Introduction Lab Scenario andAnimation, Demonstration ,True False and Click table templates Roles and Responsibility Requirement gathering via discussions with clients Requirement analysis.Design and effort estimation. Implementation of authoring template for Interactive Job Aid Development and code review for other team members  Implementation of Converting Author Content of LCDS to Word Document PROJECT NAME ILT(instructor Led training) 5.0 Client Microsoft Corporation Duration November 2007 – May 2008 Role .Net Developer Project Specific Skills Visual Studio,JavaScript, C#, XML, XSL,CSS,Word ML PROJECT DESCRIPTION Microsoft’s Courseware Authoring Tool is designed and developed for the Instructor Led Training (ILT) group members and vendors to have a new unified Course Authoring Tool using Word Add-Ins. The ILT courses created by the tool can be distributed to students and instructors in different formats like Printed Word manuals, PPT, OneNote packages, CDs.  The tool is a VSTO add-in created for Word through which the following features are provided to the users: Create module form and add new sections for content.Add content to the forms and apply formatting as required.Publish the authored content to various output types.The tool is also designed to import content from other applications and create Word documents out of it. Roles and Responsibility Requirement gathering via discussions with clients Requirement analysis.Design and effort estimation.Development and unit test cases Bug Fixes and Documenting the types and structure of the business data