Data Sql Server
Resume:
GAGAN SHARMA
Location: Stamford, CT
Email: ************@*****.***
Phone: 203-***-****
SUMMARY
** ***** ** ********** ** full life cycle of software system design, analysis and development in various areas like Web/Windows Applications, Client-Server Architecture, Databases, Intranet, 3rd party Vendors.
Proficient in Microsoft Technologies: Visual Studio 2013/2017, .NET, C#, VB.NET, Visual Basic, SQL Server, SQL Server Reporting Services and 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.
Well-rounded experience as Systems Analyst, Software Developer, Support and Enhancement.
Excellent Analytical, Innovative and Problem-Solving skills.
Knowledge about Syncfusion, BI tools like Microsoft Power BI and Tableau.
Working experience in various domains like Healthcare, Beverages, Banking, Municipal etc. using Waterfall/Agile methodologies.
EDUCATION
Master of Computer Applications from HBTI Kanpur, India
BS (Honors) in Electronics from University of Delhi
CERTIFICATIONS
-SQL Server Reporting Services and training from Learning Tree International, NYC.
-SQL Server Integration Services training from Learning Tree International, NYC.
TECHNICAL GROUP MEMBERSHIP: Fairfield/Westchester .NET and SQL Server users group
PROFESSIONAL EXPERIENCE
Organization: City of Norwalk, Norwalk CT Jan 2019–Present
Role: Data Admin/Programmer
Responsibilities:
Development and Support of Web applications using MS Visual Studio 2017 and MS SQL Server 2012.
Analyzing user requirements, documenting the software solution design and processes.
Writing SQL queries, stored procedures, configuring the IIS web server for the web applications.
Web Applications migration from framework 2.0 to 4.0/ Visual Studio 2008 to Visual Studio 2017/ Windows Server 2008 to Windows Server 2012 R2/ Crystal Reports v10 to Crystal Reports v13.
Supporting end users from various departments like: Health, Police, Tax, Personnel, Finance, Parking etc.
Creating Data backup plan, schedule SQL Jobs for databases.
Handling various Vendor support cases related to Data refresh, configuration changes, linked servers, off-site hosting of SaaS requests.
Development of SSIS packages to export data to a remote SFTP site using a scheduled SQL job.
Creating SharePoint Custom Lists for tracking in-house tickets.
Installation and Configuration of On-premises Data Gateway for PowerBI on Windows Server 2012 R2.
Participation in team meetings and discussing the current tasks and upcoming requirements.
Environment: Microsoft Visual Studio 2017, Team Foundation Server, .NET Framework 4.0, ASP.NET Controls, C#.NET, SQL Server 2008/2012, IIS, Crystal Reports, Windows 10, Windows Server 2012 R2, SSRS, SSIS, Power BI, SharePoint Designer 2013, Office365.
Organization: NewVision Systems, New Canaan CT Sept 2018–Dec 2018
Role: .Net Developer
Responsibilities:
Development and Modification of C#.Net applications using MS Visual Studio and MS SQL Server.
Analyzing user requirements, documenting the software solution design and processes.
Writing SQL queries, stored procedures, configuring the IIS web server for the web applications.
Creating reports for the Marriage License application using SSRS (SQL Server Reporting Services).
ClickOnce Deployment using MageUI.exe(Manifest Generation and Editing Tool) and Thawte certificate.
Data Import from flat files to SQL Server using SSIS (SQL Server Integration Services).
Participation in weekly meeting and discussing the current tasks and upcoming requirements.
Environment: Microsoft Visual Studio 2012/2013, .NET Framework 4.0/4.5, ASP.NET Controls, C#.NET, SQL Server 2008/2012.
Organization: Child First Inc., Trumbull CT May 2016–Aug 2018
Role: Technology and Reporting Manager
Responsibilities:
Create applications for various Funders and Donors for their monthly/quarterly data needs.
System Analysis, Design, Creation, Publishing and Configuration of custom projects reflecting data housed in the Child First Client Electronic Record System using Pentaho® to measure Benchmarks, 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 and Inventory Document) related to data and applications.
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, Zoom, HTML, Dropbox, Python.
Organization: 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.
Organization: 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.
Worked as Systems Analyst, Developer, Maintenance, Cross-team collaborator.
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 import 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.
Data Import/Export between different database systems and applications.
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, VB.NET, ADO.NET, Ajax, Bootstrap, JavaScript, jQuery, HTML, CSS, SAP, Visual Source Safe, IIS 7.0, SQL Server 2008, SSRS, SSIS.
Organization: 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 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.
Organization: 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 SQL 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 websites from Development to Uat and Production environment.
Contact this candidate