Sign in

.Net Sql Server

Glenview, Illinois, 60025, United States
September 24, 2018

Contact this candidate


Sumeira Zehra

.Net Developer


Around 5+ years of Professional IT experience in design, development, implementation, and optimization of custom web/software solutions catering to business requirements involving Web/ Application development and Primarily using Visual Studio, ASP.Net, C#, MVC, VB, SQL Server 2012/2014, SSRS, SSIS, TSQL, AJAX, HTML, JavaScript, CSS, IIS, TFS, Angular, SQL Reporting service 2012 R2 and Agile mainly in Responsive Wed Design.

• Technical expertise in Microsoft Technologies, such as .NET Framework (3.0/3.5/4.0/5.0), ASP.NET, MVC 2.0/3.0/4.0/5.0, C#, VB.NET, Web Services, WCF, IIS, HTML 5.0, Java Script, VB Script, Visual Studio.Net 2010/2008/2005, AJAX, ADO.Net, VB and ASP.

• Experienced with Microsoft Application building blocks for .Net projects (Data Access, Exception Handling, Reflection, Serialization, User Interface Process, Caching and Configuration Management Application Blocks).

• Expertise knowledge on Object Oriented Programming (OOPS) Concepts including Inheritance, Abstraction, Encapsulation and Polymorphism, good experience in Exception Handling, Debugging and tracing by which the whole picture of application runtime can be seen and analyzed more efficiently.

• Exclusively used ASP.NET Web Parts, Master Pages, User Controls, and Custom Controls to design the Rich User Interactive Webpages.

• Experience in reporting tools such as Crystal Reports, SSRS, and Microsoft Project and SSIS.

• Experience inASP.NET (2.0/3.0/3.5/4/4.5) which allow programmers to build dynamic web sites, web applications and web services, implemented .NET security features such as Authentication

& Authorization, Windows-based Authentication, Forms-based Authentication, Authorizing User sand Roles.

• Hands on knowledge of mobile web technologies like Responsive Web Design (RWD), Twitter Bootstrap and Media Queries.

• Experienced in utilizing the new integrated features of ASP.NET 3.5/3.0 versions like Windows Communication Foundation (WCF), Language Integrated Query (LINQ).

• Experience in working with tools like Share point, SSIS, SSRS.

• Experience in programming in AJAX using ASP.NETAJAX framework and control toolkit for client call back features.

• Experience in database related work primarily creating complex Stored procedure, Views, Triggers,(UDF)Functions, using PL/SQL,T-SQL and Performance Tuning in SQL Server / 2014/2012/2008.

• Experience working with testing tools like Firebug, Firebug Lite, Chrome, Safari Web Inspectors and IE Developer Toolbar for troubleshooting the existing code.

• Developed Computer system specification for proposed solution to information system problem according to SDLC for following project includes Project planning, feasibility study, Systems analysis.

• Experience of Agile software development process in large team with Scrum Model &Test driven development.

• Experienced SQL Server Reporting Services (SSRS) and Crystal Reports for report generation, integration into .NET applications.

• Involved in migrating the application to the cloud using Microsoft Azure.

• Experience in creating ETL packages using SQL Server Integration Services (SSIS)

• Experience using configuration Management Tools such as Team Foundation Server (TFS) and Visual Source Safe (VSS) for version control.

• Developed Build Scripts using TFS 2010,2012, 2013,2015 build for Automated Builds

• Excellent Communications skills, good team player and have good Analytical capabilities. Good organizational skills, ability to handle multiple tasks and work independently as well as in team. Technical Skills:

• Languages: C#,.Net, C, SQL, T-SQL, PL/SQL, XML, HTML, LINQ, UML

• .Net Framework: .Net Framework 4.5, 4.0, 3.5

• Databases: SQL Server 2008/2005/2000/2012/2014 (T-SQL), MS Access

• Enterprise Servers: IIS Server, Content Management Server

• Technologies: ASP.Net, HTML, HTML5, AJAX, JSON, CSS, CSS3, Win Forms, Web Forms, Silverlight.

• Distributed Technologies: Web Services, WCF

• Reporting Tool: Crystal Reports, SQL Server Reporting Services (SSRS)

• Data Warehousing Tools: Business Objects Data Services, Decision Stream, Informatics Power Center 7.x/6.x

• Operating Systems: Windows XP, Vista, 7, Windows Server 2003/2008


• Software Engineering: Agile (Scrum), Waterfall

• Other Tools: Microsoft Visual Source Safe(VSS), Microsoft VISIO 2000, MS Visio 2007,MS office system, SSIS, SSRS, RDLC, Team Foundation Server (TFS) 2010, 2015. Work Experience

Cigna Health Insurance, Bloomfield, CT Feb

2018 – Present

Implementation Partner: CGI/Lafayette, LA

. Net Developer

Project Description: It is a specialty health care services organization. Working on SUW Market View application, Market view provides the most comprehensive view of market information available across the corporation with both internal and external information. It is a tool filled with comprehensive information about prospects, customers, producers, competitors, and vendors. Market View allows one to research prospect companies, retain an existing customer, view producer relationships, look up competitors’ customers, generate mailing lists, and much more. Some external source of information is provided by Duns & Bradstreet, Judy Diamond & Sales force automation. was developed to index documents that can be retrieved using the account number. Also, a web application was created that could be used by the customers to enable them to update a variance for specific projects, thereby updating the costs and other factors related to the project. This assisted in information processing, retrieval and generating reports. I have worked on .Net framework versions of 5.0 and 6.0. Responsibilities:

• Involved in Page life cycle including Analysis, Design, Development and Testing.

• Developed modules of application in ASP.NET and involved in writing C# classes.

• Involved in development of UI and server side code (behind file) using coding

• Worked on ASP.NET validation controls for validating the personal information provided by the Customer.

• Worked on Adhoc request by Customers.

• Worked on releasing the build.

• Worked on fixing an issues in SSIS packages.

• Worked on automating manual steps of SQL script creating SSIS Packages.

• Responsible for creating SQL queries and stored procedures using MS SQL Server 2008.

• Worked with ASP.NET Web Forms, Web Services, Web Services Components consumed for authenticating the user credentials and by using Visual basic 6 programming environment I used to develop User interfaces.

• I also worked on creating web base applications on VB6.

• Designed and Implemented application using ADO.NET objects like Dataset, Data Table and Data Adapter for manipulating, retrieving, storing and displaying data from SQL Server 2008.

• Used master page for look and feel for the site.

• Used ADO.NET strongly typed datasets to insert, update and retrieve data from a SQL Server database.

• Used ADO.NET and Data grid for data manipulation.

• Worked on a web site development project, in a small team environment (5-10 team members) Charles Schwab, Chicago, Illinois Oct 2016

– Jan 2018

.Net Developer

Project Description:

The objective of the project is to create and enhance application used by Services team. This constitutes multiple web applications that are used to address customer enquiries, customer feedback and provide case tracking. Another set of applications function on providing business leaders to capture data and view statistics within the organization. This was developed based on Responsive Web Design (RWD) approach with ASP.Net, MVC, C#,SQL Server 2014/2012, HTML5, CSS3, SaaS preprocessor and different JS libraries/frameworks such as AngularJS, Requires, AJAX and Knockouts etc.


• Responsible for designing the ASP.NET application authentication using .NET Framework, Model View Controller MVC and IIS security model.

• Used ASP.NET MVC Page Controller pattern to add functionality to individual pages such that to accept input from the page request, invoke the requested actions on the mode

• Involved in client side scripting using JAVA Script, jQuery.

• Developing applications leveraging ADO.NET, LINQ to SQL, Entity Framework 5.0

• Designed database triggers and Stored Procedures.

• Used SVN, GIT and Source Tree for Source Control management

• Involve in project documentation and demo presentation for each phases of the application.

• Created Rest full API’s using MVC5 Web API’s.

• Integrated External UDDI Web services with .Net applications to achieve seamless data processing.

• Designed and developed several SQL Server Stored Procedures, User defined Functions, Triggers and Views for all the DML functionality of the application in T-SQL and PL/SQL

• Actively involved in all aspects of Application lifecycle management following Agile-Scrum Methodology to produce high Quality Application.

• Developed the UI with extensive use of JavaScript, JSON and Ajax.

• Designed user interface web forms and implemented application logic using ASP.NET, C#.

• Extensively used/modified JQUERY to perform AJAX calls for creating interactive web pages on JSON response.

• Worked on creating responsive website for smart devices using Responsive design and media queries.

• Developed/modified Win forms for various modules using C#.Net.

• Designed data structures and stored procedures, and tune existing stored procedures on SQL Server 2014/2012

• Implemented XML parsing and JSON parsing for data handling on different application.

• Developed and modified the production software (multi-tiered web applications) using C# 4.0 / 5.0, VB.NET, ADO.NET, ASP.NET, AJAX, XML, .Net 1.1 - .Net 3.5 Framework, HTML, JavaScript, CSS3, (Web Forms) technologies, MVC 4.0 / 5.0.

Environment: ASP.NET, C#.NET 5.0, ADO.NET 4.5, SQL Server 2012/2014, Web Services, Visual Studio 2012 / 2013, IIS, CVS Silverlight 4.0/3.0., XSL/XSLT, SSIS, SSRS, Bootstrap, TFS 2010,2014 SSRS, Crystal Reports, HTML5, JavaScript, AJAX, Angular js, WCF Web Services, WPF, Web API, GIT, CSS3, SOAP, Stored Procedures, MVC 3.0, 4.0 / 5.0/ 2013, jQuery, RBDM. Eostar

Jan’ 2016 – Sep’ 2016

Rutherford & Associate – Grand Rapid, Michigan

.Net Developer

In 2001, Rutherford began development on Eostar, a comprehensive ERP route accounting software solution that leverages .Net and SQL Server technology from Microsoft and fully integrates key pieces of functionality such as Warehouse Management, Voice Picking, Purchase Forecasting, Surveys, Web Order Entry, and Mobile Sales and Delivery applications into a single database. The end result is crystal clear visibility into a modern beverage distribution organization’s KPIs and, ultimately, better efficiency throughout the organization. Rutherford’s Eostar Software is utilized by some of the most successful modern beverage distribution organizations across North America, including Monarch Beverage Company, Alliance Beverage Distributing, Andrews Distributing, Coastal Beverage Company, and Summit Beverage Eostar Software Implementation and working in Data migration.

• Gathering Business requirement from Clients ( Discovery)

• Involving Data migration from current DB to Eostar DB ( Migration)

• Conducting Webinar To the Client and showing them their data in different field and how it works in Eostar.

• Used TFS (Team Foundation Server) for source code control, project related document sharing and team collaboration.

• Conducting regular On Shore- Off Shore meetings to ensure all the Tasks are running on time

• Created and deployed Web Services using ASP.NET and C#.Net, and generated the proxy class files based on the web services to consume in web application.

• Extensively used ADO.NET objects like Sql Data Access, Sql Data Reader, COBOL, and DB2 SQL.

• Developing reports on SSRS on SQL Server (2000/2005/2008), and excellent in SSIS packages for integrating data.

• Working closely with the client and ensuring all business and process requirements are met and project is on schedule and milestone are achieved.

• Working closely with the On shore and Off Shore Team/

• Projects include Love Bottling (OK), Burke Dist. (MA), Washington Bottling (NC), Viking Domo Inc, American Fork, Utah Feb

2015 – Dec 2016

.Net Developer

Project Description:

Domo Dashboard offers a broad range of business intelligence and service to corporate, institutional and government clients around the world. This project was focused on developing various data connectors and their configuration module. Application also had dashboard to monitor the working of connectors in real time. User can generate various reports. UI components were developed to be used in custom dashboard to display data. Data could be displayed in grid, chart, or custom template defined by user.


• Developed the web site using .NET Framework 5.0, C#, ASP.Net MVC 4.0, Visual Studio 2012 and SQL Server 2012/2010.

• Actively involved in all aspects of Application lifecycle management following Agile-Scrum Methodology to produce high Quality Application.

• Employed Session State, View State, Cookies and Query Strings to persist and transfer data between pages.

• Extensively used web-Services& worked on WCF to enable applications to communicate with each other.

• Setup AGILE iteration, product life cycle and had daily scrum meetings.

• Used AJAX and JSON to make asynchronous calls to the project server to fetch data on the fly.

• Implemented Action Filters to handle errors, Validation & Authorization.

• Responsible for checking cross browser compatibility, Responsive Web Design (RWD) and hence worked on different browsers like Firefox, Google Chrome and Internet Explorer.

• Used Grid View and Form View with extensive data binding to display page and sort multiple records.

• Developed Data Models by Model First approach using Entity Framework 4.0 to enable strongly- typed LINQ queries.

• Designed, developed and implemented Single Page Application (SPA) in AngularJS by consuming JSON from a Spring MVC, using Spring Security to secure the application.

• Enabled Client and server cache using ASP.Net Cache API in MVC application.

• Front End Designing using jQuery, and JavaScript, CSS3.

• Developing applications leveraging ADO.NET, LINQ to SQL, Entity Framework 4.0

• Created and modified Stored Procedures, Functions, Views, and Triggers.

• Involved in Automated Testing.

• Used Master pages, CSS, HTML, jQuery, and ASP.NET Server Controls on web form.

• Developed Reports using SSRS and used SSIS for integrating the developed applications. Hertz, NJ Oct 2013 – Jan


Jr.Net Developer

Project Name: Rental Management System

Project Description: Hertz Corporation is the largest car rental company in the world and in addition it also provides services for Heavy equipment rental and claims management. The content for associated websites is served by a common Java Enterprise application engine. The web application is maintained by several onsite and offshore teams that work with the Business Analysts and Business Users to continually enhance and enrich end user experience. Responsibilities:

• Designed and developed Web Pages using ASP.NET, C#.NET, HTML, JavaScript, AJAX, jQuery CSS and server controls.

• Developed secure login interfaces with ASP.NET Server controls.

• Used various server controls like Multi View and Grid View with extensive data binding to display, page and sort multiple records.

• Used Validation Controls for corresponding validations required for business logic in Web Forms.

• Implemented Tables, Indexes, Relations, T-SQL Ad-hoc Queries, Views, User Defined Functions

(UDF) and Stored Procedures in SQL Server 2010.

• Designed and developed user interfaces using VB.NET and ASP.NET.

• Coding the presentation layer using WPF and service layer using Windows Communication foundation technology.

• Extensively used MVC for the designing on multiple devices.

• Developed Custom Controls and User controls for reusable part of the web pages using C# with ASP.NET.

• Created Rest full API’s using MVC4 Web API’s.

• Written the business logic in classes using VB.NET / C#.Net language and used in Web Forms.

• Developed test-driven development (TDD) strategy guiding use of the Nun it unit testing framework.

• Developed dynamic work flow process using ASP.NET 1.1, VB.NET and SQL Server 2008/2012.

• Used AJAX and JSON to make asynchronous calls to the project server to fetch data on the fly.

• Utilized C# generics, delegates, events, extension methods, anonymous types, and lambda expressions.

• Developed Server side and Client side code using ASP.Net, jQuery and JavaScript.

• Created Views by applying complex queries on multiple tables to create the virtual tables and implemented Cursors in Stored Procedures using SQL Server 2008 R2, Implemented Joins in Stored Procedures to get the desired data by joining multiple tables.

• Involved in full life cycle of the project from requirements gathering, analyzing, designing, and developing the application using Iterative AGILE Methodology.

• Developed parameterized SQL queries and stored procedures to query database tables in T-SQL.

• Designed and developed applications using ASP.NET with ADO.NET, and SQL 2012.

Contact this candidate