Sql Server Management

Aayush Kumar

http://www.linkedin.com/in/aayushkr/

**** ******* **** ****** *** 364 Bryan, TX 77801 979-***-**** *.******@*****.***

Analyst with three and a half years’ experience in technology consulting & software development lifecycle; business and system

analysis, application development

EDUCATION

Texas A&M University, Mays Business School, College Station TX Spring 2013

Master of Science in Management Information Systems, GPA 3.7, GRE 1440, TOEFL 111

Fr. C.R.I.T, Mumbai University, Mumbai, India 2007

Bachelor of Engineering in Mechanical, GPA 3.5

PROFESSIONAL EXPERIENCE

Texas A&M University College Station TX 2011 - 2012

Consolidated Data Warehouse for Dominicks Finer Foods – Retail Store

Answered key strategic business questions by analyzing the OLTP data (10GB, 10 years), designing and implementing an

Enterprise Data Warehouse and developing business intelligence reports using SSIS, SSAS and SSRS

Developed SSIS packages to extract data to the staging area from different sources while performing cleaning and transformation

Designed SSRS reports, SSAS cubes, MDX queries to slice and dice and Business Intelligence reports

SharePoint Development for International Student Services

Gathered requirements, planned & implemented SharePoint to manage several approval based documents improving stakeholder

experience and reducing processing time while providing real time monitoring of KPIs

Customized approval workflow, task processes & lists using SharePoint Designer

Designed InfoPath Forms, set rules, actions and developed application page using Visual Studio 2010

Technology Consulting & Mapping service development - Maps & GIS Library

Planned, designed and implemented an interactive web-based mapping service that simulates the evolution of the school campus

through time

Developed a custom application using ArcGIS Viewer for Flex for the final presentation

Other Projects

Runner up in the Mays Business School CMIS Case Competition – Fall 2012

Won the college level SAP ERP Simulation competition and represented Texas A&M on an international level

Designed and configured SAP ECC for a computer hardware manufacturing company - FICO, MM, SD, PP module

Finalist of ‘Idea Challenge 2012’– A university-level entrepreneurial competition. Presented a technology based business model

of the educational platform – value proposition, resource & process requirements, implementation strategy and profit formula

Rolta India Ltd., Mumbai, India (Listed – India, UK) 2007 - 2011

Technology Consulting & Implementation

Technology Solutions - Engineering Design & Operation

Provided technology consulting, technology implementation and solution development for Engineering/Procurement/Construction

companies to increase margins, operational efficiencies, integrate & improve quality of core business processes and deliverables

Analyzed and implemented information management systems, that integrate and manage large datasets from multiple sources to

achieve concurrent engineering and accurate enterprise level reporting using Intergraph SmartPlant Suite

Designed and developed extraction, transformation, loading and tracking systems using C#.Net, Crystal Reports & SQL Server

2008 for Energy companies such as GE-Energy USA leading to zero defects and an operational efficiency gain of over 10% while

providing monitoring capability of KPIs

Reduced repetitive software development time by 70% Reduced costs, improved quality and security of solutions provided to

clients by design and implementation of business specific application blocks

Offered expertise towards the planning and development of a new business vertical that leverages on Rolta’s IT infrastructure to

provide Software-as-a-Service to customers using Citrix XenApp

Delivered presentations & prepared white papers to showcase relevant solutions that improves and transforms their business

Invested 22-25 hours a month in training junior members of our team and at Rolta’s training academy

Technology Solution - Geospatial Services for Public Administration Bodies

Implemented and re-engineered a GIS based Asset and Workflow Management System for Nasik Municipal Corporation within

the SLA and with CMMi level 5 quality to integrate operations, improve operational efficiency an d provide real-time monitoring

and accounting using ASP.Net, Oracle 9i, Intergraph GeoMedia WebMap, Crystal Report

Stationed on-site as a single point of contact for client. Interfaced with end -users, clients, business and technical teams to

successfully steer the project

Performed system analysis and design. Developed high & low level design documents, feasibility, estimation, requirements

specification, gap analysis, risk analysis, functional and technical documents

Designed and developed an Emergency Vehicle Dispatch and Monitoring system using C#.Net, OpenMap/Google Map & GPS

tracking device for the central control unit of Chandigarh Police Service

SKILLS

MS Excel, MS Word, MS PowerPoint, MS Access, MS Outlook, MS Visio, MS InfoPath

Microsoft Office

Languages/Technologies SharePoint, SAS, R, C#.Net (.Net 2.0 – 4.0), ASP, ASP.Net, SQL, VB6, XML

Warehousing/Database MS SQL Server 2010, SSRS, SSIS, SSAS, Oracle 9i, 10g, MS Access, PostgreSQL

ERP SAP R/3 (FICO, MM, SD, PP), SAP GUI, Visual Composer

Other MVC Framework, Entity Framework, ADO.Net, Application Blocks

Visual Studio 2008-12, SQL Server Management Studio, SQL Server BIDS, Oracle Developer, Toad for

IDE

Oracle

Business Database System, Data Warehousing, ERP, SAS & R, System Analysis & Design, Financial

Relevant Courses

Management, Accounting Procedure & Control, Manufacturing Process

SmartPlant Suite - SPF, SPPID, SP3D, PDS, SPEL, SPR

Engineering Tools

LEADERSHIP & COMMUNITY SERVICE

Toastmasters International – Committed to continual improvement of leadership and communication skills

International Students Association – As V.P. Advocacy and V.P Information, organized events, in collaboration with student and

governing bodies to foster cooperation and understanding among all students and the local community

V Hikerz, India – Served as a scout and event coordinator for the 500 member strong hiking group

National Association for the Blind, India – Developed and managed Public Relations and set up eye-camps

Authorized to work in the U.S. through Optional Practical Training (OPT)

Contact this candidate