Sql Server Information Technology

Piyush Sonawane

Mobile: +1-681-***-****

E-Mail: ****************@*****.***

Summary of Qualifications

* *****’ experience in SQL SERVER Database Design and Development, Writing Constraints, Indexes, Views, Stored Procedures, Cursors, Triggers, and User Defined Functions using T-SQL.

Experience in SQL & PL/SQL programming, writing Stored Procedures, Functions, Packages using SQL Server Management studio, PLSQL Developer.

Experience in development and implementation of high end applications with Microsoft .Net Framework 2.0/3.5/4.0/4.5, Visual Studio 2012/2010/2008/2005.

Developed custom crystal reports to analyze financial, operating, and billing processes.

Engineered on IBM Watson conversation tool as well as developed IBM Watson Analytics reports.

Specialized skills using SAS, Tableau and SQL in data collection, data analysis and reporting to procure data from database to reports and on client requests to provide solutions in a timely manner.

Hands on experience in reports development using SQL Server Reporting Service (SSRS) and Crystal Reports and experience in developing integration packages using SQL Server Integration Service (SSIS).

Development and Implementation of Web Applications and Windows Applications using ASP.NET, ASP.NET MVC, WCF and Web Services, Web API and Ajax in multitier architecture.

Development and Implementation of Excel-Macros Automated forms for proven background translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs for finance industry.

Specialized skill set in web building technologies like HTML 5, JavaScript, JQuery, JSON,

CSS 3, XML.

Excellent analytical, communication, interpersonal and decision making skills, self- motivated to rapidly acquire new skills on the job.

Development and deployment of Cloud CPE website with design specs and analyzing the trends.

Technical Skills Summary

Technologies

.NET Framework 4.5/4.0/3.5/2.0 ASP.NET MVC, LINQ, SOAP/Restful Web Services, ASP.NET, ADO.NET, WCF.

Languages

Programming Languages: - C#.net, C, VBA.

Scripting Languages: - JavaScript, jQuery and VB script.

Web Development

ASP.NET, ASP, HTML, DHTML, CSS, Web Services, IIS, ADO.Net, ODBC, OLEDB, XML JavaScript, JQuery, Ajax.

Web Servers

Internet Information Services (IIS) 7.5/7.0.

Databases

MS SQL Server 2000/2005/2008/2012, MS Access 2000, Oracle.

Design and Development Tools

Visual Studio.NET 2008/2005/2003, Microsoft Visio.

Version Control

Visual Source Safe (VSS),Team Foundation Server 2005/2008/2010/2012

Reporting Tools

ETL: Informatica 8.6.1/8.1.1, Crystal Reports, Crystal Reports .NET, SQL server Reporting services (SSRS), IBM Cognos Tool, JasperSoft, Sisense.

Operating Systems

Windows 7/2000 / XP, Windows Server 2003, Windows Server 2008.

Education:

Marshall University, Huntington, WV, USA

M.S in Information Systems Graduated - May 2016

University of Mumbai, India

B.S. in Information Technology Graduated – May 2013

Employment History

Role

Organization Name

Date/Period

BI Analyst

Toyo Engineering India

7th May 2013 – 9th May 2014

Software Engineer

Tech Mahindra Americas

August 2016 – Till Present

Professional Experience

Projects

Tech Mahindra Americas

August 2016 - Till Present

Software Engineer

Responsibilities:

\

Considerable experience managing and heading Cloud CPE website team for development and deployment of the website.

Prepared website design specs and coordinated with team to ensure quality work and analyzed website trends and held regular staff meetings to discuss trends.

Engineered on IBM Watson Cognitive tool to create an automated machine learning response according to the entry by the user.

Client: Verizon:

Assisted with automation of Verizon’s STQ-(Solutions to Quote) team manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.

Part of the Federal STQ team in creating the quotation for the Enterprise/Networks design given by the customer for different telecom services like VOIP, PIP, IDS as per the customer need.

Interacting with the customer when required ensuring all parties have full clarity and understanding of the quote request for services and Verizon products.

Generated detailed weekly reports and cost-resource prediction analysis using IBM Watson Analytics.

Contribution:

Cloud CPE website showcased at MWC (Mobile world Conference 2017) in Barcelona.

Watson Analytics reports displayed to the senior management of Verizon.

Environment: IBM Watson Conversation tool, IBM Watson Analytics, VBA, HTML 5, Macros, Visual Studio IDE for .NET ADO.NET, VB script CSS, XML, JSON, ProQuest, Premysis, Cisco estimator, CAMEO, One View, Business Management Application (BMA).

Toyo Engineering India Limited Jan 2014 - May 2014

BI Analyst

Responsibilities:

Generated MIS reports for the company’s IT manager.

Interacted with Human resource team and procured requirements for Employee Billing reports.

Developed on-demand sub reports and linked sub reports and complex reports like cross-tab, drill down and hierarchical reports.

Used Jasper reports and crystal reports to extract data from the databases and represent that raw data in crystal report or jasper report.

Designed multi table relational database with proper enforcement of relational constraints using MS SQL.

Developed reports using SSRS which are sent though messages and E-mails.

Hands on experience in writing stored procedures (PL/SQL) to extract data from database.

Developed bar charts & pie-charts using chart expert and customized them according to users’ requirements.

Involved in user interface design using ASP.Net, and C#.Net.

Environment: Crystal Reports, Jasper reports, C#.Net, ASP.NET, Visual Studio IDE for .NET ADO.NET, VB script, Oracle 10g, HTML, CSS, XML, MS SQL.

Project Title: Web Speak Navigation. (Graduate Project).

Description: The system is suitable for people with speech impediments or non-native English speakers who cannot use standard voice recognition. The system is designed to control a browser through user speech recognize (voice command) and to minimize the number of required characters to uniquely select any element, and to separate the typing interface from the selection system. This allowed the user to navigate the web using any input device that was capable of producing alphanumeric characters.

Business benefits: Moreover having a condone view over business benefits the project was directed towards social aid to the mass number of people who are handicapped to control simple working of a browser.

Project Title: Developed a Country Club, Employee Management System website, having a database connection

Description: Ridgeway Country club website is a website of a Country Club having a database for employees as well as members and inventory database. Order entry forms are created for employees as well as for members depending upon the log in credentials to insert data into the database using PHP. Crystal reports are used in the website as data retrieval in 3d pie charts and other bar chart diagrams. System analysis, System design, Database processing and BI tools knowledge were adapted in this project.

Business benefits: Generating a complete system implementation involving the front-end as well as the back-end technologies and a full-fledged working website for a country club.

Education, Training & Certifications

Institute

Course Title

Year of Achievement

Grades achieved

Marshall University, Huntington, WV

M.S in Information Systems

May 2016

CGPA- 3.90/ 4.0

= 94 - 96%

University of Mumbai, India

B.S. in Information Technology

May 2013

53%

Contact this candidate