Resume

Sign in

Data Sql Server .Net c# vb.net

Location:
Stamford, Connecticut, United States
Posted:
August 13, 2018

Contact this candidate

Resume:

GAGAN SHARMA

Email: ac6nr4@r.postjobfree.com

Phone: 203-***-****

Linkedin: www.linkedin.com/in/gagansharma7

SUMMARY

** ***** ** ********** ** full life cycle of software project development in various areas like Web Applications, Client-Server Architecture, Database and System Specifications.

8 years of experience on Microsoft Technologies: Visual Studio 2010/2013, .NET, MS SQL Server, SQL Server Reporting Services, Integration Services JavaScript, XML, HTML.

Proficient in MS Office/Office365 (Word, Excel, Access, PowerPoint, Visio, OneNote, Outlook).

Rich experience in using Reporting Tools like Pentaho, Dundas, Crystal, Tee Chart and Web Trends.

Knowledge about DevExpress, Syncfusion, BI tools like Microsoft Power BI and Tableau.

Working experience in various domains like Healthcare, Beverages, Banking etc.

EDUCATION

Master of Computer Applications from HBTI Kanpur, India

BS (Honors) in Electronics from University of Delhi

CERTIFICATIONS

-Brainbench ASP.NET Fundamentals certificate (Transcript ID No. 6003437)

-SQL Server Reporting Services and training from Learning Tree International, NYC.

-SQL Server Integration Services training from Learning Tree International, NYC.

-Developing InfoPath Forms for SharePoint(R) training from Learning Tree International, NYC.

TECHNICAL GROUP MEMBERSHIP: Fairfield/Westchester .net and SQL Server users group

PROFESSIONAL EXPERIENCE

Child First Inc., Trumbull CT May 2016 - Present

www.childfirst.org

Role: Technology and Reporting Manager

Responsibilities:

Create applications for various Funders and Donors for their monthly/quarterly data needs.

Design, Create, Publish and Configure custom reports reflecting data housed in the Child First Client Electronic Record System using Pentaho® Reports to measure Benchmark, Oversight/Documentation Compliance, Client/Census Management, Staff Productivity, Client Demographics, Clients Served, Process Measures etc.

Extracting various data dumps from the database needed about presentations and meetings to funders etc.

Work with Vendors regarding data updates, imports, refresh and additional requests related to data accuracy and integrity.

Coordinate other electronic data needs for the Child First National Program Office and its affiliates across CT, FL and NC. Provide ongoing IT/technology support to the Child First affiliates.

Working in collaboration with Data, Clinical and Training Teams on daily basis for Monthly Metrics, Assessment Data Collection and Analysis.

Working as a 2nd level support liaison for various teams and troubleshooting any data or software issues.

Installing, configuring and testing latest software tools and IT applications that are used in the Organization. Configuring and modifying user access permissions, creating new users etc.

Create and maintain various documentation (User Requirements Document, Testing Document, Inventory Document) related to data and reports.

Manage data protection processes to ensure the safety and security of all HIPAA-protected data.

Environment: Oracle 12.6, PL/SQL, Pentaho 6.1 Report Designer, JDBC, CareLogic, Team Support, Windows 10, Office 365(MS Word, MS Excel, MS PowerPoint, Outlook), HTML, Dropbox, SharePoint, TeamSupport, Python.

Gartner, Stamford CT Sept 2014 – May 2016

Senior Software Developer

Responsibilities:

Development of C#.Net application that includes data import from CSV and xml format to SQL Server database. It used various XML classes to parse and read the xml data. SQL Stored Procedures were written and used to send data to tables.

Worked with SQL Server and Excel technologies in Windows and Citrix environments. Development, maintenance and deployment of SSIS packages, SSAS Cubes, Stored Procedures. The SSIS packages processed data from different databases and provided it to Cubes.

Worked in validating the Oracle data that is sent to customer facing gartner.com website. Coordinating with the QA team to test data sanitation by verifying the UI data. Used Toad to connect to Oracle.

Maintenance and support of in-house windows and excel based applications for end users. Supporting the Research Analysts by providing them accurate and timely data. Creating Customized Excel Pivots for various business requirements.

Ticket creation for QA and Production releases, coordinating with service desk and DBA team for releases. Coordinating with end users about verification of data publication and expected quality outcome. Participating in quarterly releases of different business deliverables and participating in the Quality Check process by validating data summary in database and Pivots and doing spot checks. Ensuring that the customer experience is foremost by responding to their tickets pro-actively.

Environment: Microsoft Visual Studio 2012/2013, .NET Framework 4.0/4.5, ASP.Net Controls, C#.NET, SQL Server 2008/2012, Oracle 12.6, Toad, Subversion, Team Foundation Server, Excel, Alfresco, Citrix desktop client

Nestle Waters North America, Stamford CT Sept 2011 – Sept. 2014

Solutions Programmer Analyst

1.Project - Leave of Absence: Development of a web application for Human Resources department which tracks the short-term and long-term Employee Leaves into the system. This tool enables the field HR representative to document their actions and conversations with Employees and facilitates custom reports.

2.Project – Online Talent Review (Website and Reporting): I developed this web application for Human Resources department which lets Employees enter their own Assessment details for Biography, Mobility, Development Actions, Performance (Strengths and Opportunities) and enables the HR department to look at various reports.

Responsibilities:

Gathered business requirements and translated them to IS solutions. Organized meetings with stakeholders in the requirements gathering process. Created the Functional Specifications Document and Technical Specifications Document for the Project.

Developed the wire frame screens of the application as per agreed upon specifications. Scheduled weekly meetings to review project progress, recorded meeting notes, sent communication across stakeholders.

Developed the various web screens of the application in VB.NET to Create LOA Request, Update LOA Request, Delete LOA Request, Reporting and Administration tabs.

Created tables and stored procedures in SQL Server to display data on the webpage and to save data to the database table from the webpage. Created SSIS package to read daily updated data from HR database and scheduled an SQL Job to run it daily.

Developed various SSRS Reports showing LOA requests with various stages like Employees with Pending Request, Employees on Leave with no Request made, Requests with no matching data in SAP etc.

Configured the IIS web server to setup the virtual directories of the application. Deployed the application using Web Deployment in Visual Studio across different migration paths of Development, Test and Production environments.

Created and maintained issues log and update issue status. Organized user testing, feedback, bug fixing. Acted as liaison to business partners and provided 24X7 support to ensure day to day operations.

3. Project – Data Quality Tool (SQL Server, SSIS, SAP, SQL Jobs): This application comprised of various SSIS packages, scheduled SQL Jobs and SQL Server Stored Procedures. I managed and enhanced this complex application that provides Customer, Vendor and Material related information to Business and Higher Management for analysis and further steps for enhancing the productivity of organization.

Responsibilities:

Monitored the process (SQL Jobs that executes SSIS packages) of daily pull data load into SQL Server from SAP and work on new enhancement requests of modifying the data fields by adding new information.

Deployed the changes across the different migrations paths: Development, Pre-Production and Production.

Collaborated with the Data Governance team to ensure the quality of data and processes as the data from this tool was widely used by various teams in many applications like Knowledge Performance Indicator (KPI) Dashboards, Reporting, Factory Warehouse application etc.

References to SAP system to cross check data fields, field structure, validations and newly added fields. This was needed to modify the ETL process from time to time.

4. Project – Project TV (Website, SQL Server, SSRS, SSIS and SQL Jobs): Managed and enhanced this web application for Information Services department which captures Employee weekly working hours in different categories like Projects, Break-fix, Meetings, Trainings etc. and created custom reports.

5. Project – Retail Fuel Card (Website, SQL Server, SSIS, SQL Jobs): Project Managed and developed this web application for Retail Sales department to automate the manual process of creation, update and termination of Fuel Cards. This improved the accuracy, eliminated delays and added efficiency for the organization.

6. Sharepoint: To create Team Rooms for maintaining the Application Portfolio of the various applications where I was the Primary Support. The portfolio contains essential details of the application like: Summary, Links, Softwares used, Servers, and Business Contacts etc.

7. Nestle Compliance Standards: Worked as the main point of contact for distributing the Compliance Standards for .net and SQL Server across various teams and recording the status of compliance. It involved various meetings, clarification of doubts, coaching about using the Compliance Checker tool.

8. Peer Review Process: Worked as contact person for the Chief Architect to establish the Peer Review Process by evaluating the coding standards of applications within team.

Environment: Microsoft Visual Studio 2012/2013, .NET Framework 4.5,, ASP.Net Controls, VB.NET, ADO.NET, Ajax, Bootstrap, JavaScript, jQuery, HTML, CSS, SAP, Visual Source Safe, IIS 7.0, SQL Server 2008, SSRS, SSIS.

UBS AG, Stamford, CT Aug 2009 – July 2011

Software Engineer

Project 1 – WAY (Where Are You): It is an Employee tracking and absence planner web application. It is used by more than 20,000 users globally.

Responsibilities:

Created web services using C# that interacts with external application to provide functionality related to employee absence. It uses security token before providing any data to the calling program. Created test plans to facilitate bug free application before release to Uat.

Added new Traveling global locations in the web Created scripts in SQL Server. Automation of adding Global Public Holidays into the application by creating automated scripts in SQL Server.

Ensured that Uat changes are accepted satisfactorily by Product owner and stakeholders. Provided efficient and customer satisfactory third level support of Production issues, bugs, enhancements, incidents using a Ticket logging system.

Maintained the issue logs in Sharepoint/Jira to facilitate easy tracking of issues.

Project 2 - Lab Management Tool: It is a web application that manages and reserves servers in Global Labs.

Responsibilities:

Created new web forms using C# to provide data entry screens and created tables, views, stored procedures in SQL Server. Involved in providing solution for different bugs and giving access rights to different users.

Nu Info systems Inc. Nov. 2006 - Aug. 2009

Client: UBS AG

C#. Net Developer (IS Consultant) Sept. 2007 – Aug. 2009

Investment Bank Storage Reporting website and Dashboard: It provides the top management with the reporting of NAS, SAN and DAS storage in the Bank. It has the drill down and graphical capabilities.

Responsibilities:

Web Form design and coding using ASP.NET Controls, Master Pages, Server controls, Cascading Style sheet, JavaScript, html.

Wrote classes to implement display format in gridview, Export to Excel, Export to Zip. Used dataset, data reader, data view to read data using ADO.Net objects in C# from database stored procedures.

Used gridview to display data with sorting, paging, Export to excel, zip, bookmark a link, static headers.

Created a Storage Dashboard with Dundas Charts that shows detailed drilldown data on graph click.

Created different Monthly and Yearly Bar, Column, Stacked, Line Charts to visualize Capacity using Dundas Chart and TeeChart. Added interactive features in Charts like animation, zoom, print, drilldown, save as image/pdf, data export to excel.

Wrote T-SQL queries in creating views and stored procedures in SQL Server. Used joins, unions to get data from different tables and databases.

Responsible for deployment of the web site from Development to Uat and Production environment.



Contact this candidate