We provide IT Staff Augmentation Services!

Sr.sql/.net Developer Resume

Fort Washington, PA

SUMMARY:

  • .NET consultant with 8 years of experience in IT with expertise & exposure to all the stages in software development life cycle including requirements gathering, software design, development and testing/support using Microsoft Technologies.
  • Extensive experience with Microsoft.Net Technologies ( .NET Frame work, MS Visual Studio .NET, ASP.NET, ADO .NET, C#
  • .NET, Windows Services, LINQ, Web Services/WCF), Entity Framework and various object relational databases (SQL Server, Oracle).
  • Experienced in Object Oriented Programming and OO Design Patterns .
  • Worked in Water Fall and Agile Scrum methodology.
  • Involved in Client Interaction meetings and in co - coordinating releases with multiple teams.
  • Developed GUI using Web based ( Web Forms, ASP.NET ) application development using C#.
  • Worked on Web applications using MVC 4.0/5.0 .
  • Experienced in consuming and developing ASP.NET, WCF Web Services using Simple Object Access Protocol , developing Service Oriented Architecture SOA based services and REST .
  • Developed services using Windows Communication Foundation ( WCF ), WEB API
  • Developed applications using .NET application building blocks (Data access, Exception Handling, State management)
  • Working experience with JavaScript, JQuery, JSON, AJAX, HTML, HTML5, CSS, CSS3
  • Strong analytical and programming skills with proven track record in creating elegant, flexible and maintainable solutions as per Business Requirements.
  • Involved in Unit testing, Integration testing and Functional testing.
  • Working knowledge in configuration and version management using Visual Source Safe ( VSS ), Clear-Case , Subversion ( SVN ) and Team Foundation Server (TFS 2010)
  • Extensively used Data Reader and Datasets in ADO.Net to retrieve, display, edit and update data in the database.
  • Experienced with LINQ and Entity Framework
  • Well-versed knowledge in SQL , T-SQL , stored procedures, functions, cursors, triggers, views, joins using SQL Server 2005/2008/2012.
  • Handle escalated support tickets till closure for MS Azure IaaS platform
  • Working experience with SSRS and SSIS.
  • Experience in building ecommerce platforms.
  • Good Knowledge in designing Use-Case diagrams, Class diagrams, Interaction diagrams (Sequence diagrams, Activity diagrams and Collaboration diagrams) using Designer tools like MS Visio.
  • Good understanding of technology with focus on delivering business solutions.
  • Comprehensive problem solving abilities, excellent verbal and written communication skills, Interpersonal Skills and Leadership Qualities.

TECHNICAL SKILLS:

Languages: C#, VB.Net, JavaScript, JQuery

.Net Technologies: ADO.Net, ASP.Net 2.0/3.0/3.5/4.0, ASP.NET, MVC 4.0/5.0, .Net Framework 1.1/ 2.0/3.0/3.5/4.0, WCF Web Services, WPF, LINQ, Entity Framework

Web Technologies: XML, HTML 5, DHTML, XHTML, WSDL, UDDI, CSS3, XSL, XSLT, JavaScript, JQuery, JSON, AJAX

Databases: MS-SQL Server 2000/2005/2008, Oracle 10g/11g, MS Access 97/2000, TSQL, PL/SQL

Other tools: Visual Studio .NET 2005/2008/2010, Microsoft Visio, Dreamweaver

Web Servers: IIS 5.0/6.0/7.0

Versioning Tools: Visual SourceSafe(VSS), Subversion(SVN) and Team Foundation Server (TFS)

Source Code Control: TFS, Subversion(SVN), IBM Clear Case, Visual Source Safe (VSS)

Operating Systems: Windows Win7/Vista/XP/NT/Server 2000/2003/2008

PROFESSIONAL EXPERIENCE:

Confidential, Fort Washington, PA

SR.SQL/.Net Developer

Responsibilities:

  • Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
  • Requirements and design goals of data warehouse.
  • Created SSIS packages to populate data from various data sources.
  • Developed incremental and full load jobs to pull the data from OMS/CMS and process it to Responses.
  • Developed SSIS packages to consume feeds like opt-outs, complaints from Responses.
  • Automated the data archival process.
  • Conducted data import and export operations using the DTS wizard.
  • Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
  • Developed SSIS packages to generate various feeds like prospectus list, product list and send it to Responses.
  • Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
  • Linked business processes to organizational objectives and implementing customer deduplication using MS SQL Server 2014 Database and Match IT tool.
  • Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.
  • Provide consulting and cloud architecture for premier customers and internal projects running on MS Azure platform for high-availability of services, low operational costs.
  • Expert in writing SQL scripts, shell scripts.
  • 24 X 7 Production Database on Call Support.
  • Configuring and troubleshooting IIS and XML.

Environment: MS SQL Server 2014, PostgreSQL 9.0/9.1, T-SQL, SSRS, SSIS Packages 2014,ETL, ODBC, ASP.Net 3.0, Ado.Net 3.0, C#.Net, Excel, Business, Business Objects Data Integrator 6.5, C#.NET,, PowerShell scripting, WPF, Web Services, REST, WEB API,ASP.NET ADO.NET, LINQ, XML, and SMTP. Windows 2003 Server, IIS 6.0.

Confidential, Sandiego, CA

.Net Developer

Responsibilities:

  • Developed a 3- tier web application following agile development methodology.
  • Analyze functional and business requirements to design, develop, configure and deploy packages and components customized to meet specific needs and requirements.
  • Involved in Design, Development and Testing of Web Forms and Web Services.
  • Used ADO.Net Entity Framework for developing C# components for implementing business logic which is used to do the transactions on database.
  • Used LINQ in connecting to Data Access management with SQL Server.
  • C#.NET is used to program business logic including Code-behind files and Classes in the middle tier.
  • Experience in developing application using WPF and Silverlight with Prism framework
  • Integrated the ecommerce platforms with the payment gateways and accounting system.
  • Designed presentation layer for dynamic web forms using ASP.Net MVC,.NET Framework 3.5/4.0, Visual Studio
  • Extensive experience in implementing and upgrading ERP solutions
  • Created SSIS Packages for integrating data from one system to Main System.
  • Integrate multiple systems using secure protocol and maintain high performance
  • Used JavaScript/JQuery and .NET Validation Controls for performing client-side validations.
  • Used WCF, REST, RESTFUL, Web Services, APIs, Angular JS for designing back end components.
  • Designed a Master Page and used CSS for to provide a consistent look and feel of inherited web pages.
  • State Management Techniques are used to maintain state at control level using View State and at application level using Sessions.
  • Used Perl, Power Shell scripting.
  • Created and Exposed APIs and SDKs for the other teams to use.
  • Integrated the applications with the third party APIs and worked on N-Tier architecture
  • Worked with existing web apps features using ASP.NET Login Controls, Personalization, Membership, Authentication and Authorization.
  • Extensively worked on Creating, Transmitting and Consuming WCF and Web Services.
  • Performed database operations on SQL Server by creating SQL queries, stored procedures, functions, indexes and views.
  • Perform unit and system testing using nun it. Monitor everyday activities of system and provide required support
  • Used Microsoft Git Hub and Subversion (SVN) for version control and file sharing.

Environment: .NET Framework4.5/4.51, Visual Studio, .Net, IIS, C#.NET, ASP.NET ADO.NET,LINQ, HTML 5, Angular JS, CSS 3, AJAX, JavaScript, Jquery, MVC 4.0/5.0, WCF, ecommerce, Entity Framework 6, n Unit, WPF, Web Services, REST, WEB API, SQL Server 2012, SSIS, SSRS, XML, and SMTP.

Confidential, Harrisburg, PA

.Net Developer

Responsibilities:

  • Participated in Daily Status and Weekly Status meetings with the functional team and developed interfaces based on the specifications.
  • Followed Agile and Scrum Methodology to give high Quality Interfaces.
  • To implement Business Logic, used with Visual Studio 2013 / .net Framework 4.5/4.5.1 .
  • Created WCF Services to expose business logic as services and consumed those services.
  • Used WCF Services for executing the packages/Interfaces.
  • Involved in creating various SQL Queries , SQL scripts , relational databases , DTS packages , triggers, Stored Procedures and Triggers with SQL Server 2012 .
  • Involved in Requirement gathering, Design, Development and Testing of Web Forms.
  • Involved in managing the client meetings, documenting the functional and business requirements.
  • Followed N-Tier Architecture and developed multiple layers in the ecommerce Platform.
  • Developed HTML prototype of the web pages using CSS 3, according to client specifications
  • Developed RESTFUL Web services, APIs , and other back end components.
  • Developed Classic ASP pages to maintain the existing applications.
  • Used MVC 4.0/5.0 Pattern to design the Test driven UI Layer
  • Created and Consumed WCF Services within the network
  • Followed SOA (Service Oriented Architecture) and developed Data Transfer Objects (DTOs) and Mappers.
  • Responsible for developing Portfolios views using Microsoft WPF Prism Framework/MVVM model and Mef Extensions frameworks
  • Responsible for setting up the security and bindings for WCF services
  • Used XML to create Web-based tools for transactions on SQL and Oracle databases.
  • Extensively worked on SSIS Package Development and used all types of transformations.
  • Developed custom C# Code in script component transformation of SSIS.
  • Implemented MS-Unit Testing , Integration Testing for the testing the Interfaces.
  • Experience in handling the exceptions and debugging the application.
  • Used TFS for version control, for updating the status of the development.
  • Used AngularJs, JavaScript and JQuery for client side scripting to create highly responsive interfaces for users
  • Created new design and styles for the web pages using AJAX controls in the Ajax Control Toolkit to enhance the aesthetic value of the web pages.
  • Used JQuery and JavaScript to implement AJAX calls and other type of client side logic.
  • Implemented server caching techniques.

Environment: .net Framework 4.5/4.5.1, C#, Visual studio 2013, ASPX/Razor view engine, ADO.net, C#, Oracle 11g Java Script, JSON, Rest, Web API, Ajax & JQuery, SSIS, WPF, Win forms, ecommerce, XML,MVC 3.5/4.0, Web services, WCF, RESTFUL services, LINQ, MS SQL Server 2012/14, TFS 2012 and Agile Methodology.

Confidential, Dallas, TX

.Net Developer

Responsibilities:

  • Developed a 3- tier web application following agile development methodology.
  • Involved in Design, Development and Testing of Web Forms and Web Services using IIS 6.0, ASP.NET, XML, and ADO.NET.
  • Used ADO.Net Entity Framework for developing C# components for implementing business logic which is used to do the transactions on database.
  • Used ADO.Net, LINQ in connecting to Data Access management with SQL Server.
  • C#.NET is used to program business logic including Code-behind files and Classes in the middle tier.
  • Developed Admin Module web pages to enter new policies, edit privileges, and to edit improper user approvals. Developed Customers Module web forms to access PBS services.
  • GUI of both modules is developed using HTML, HTML5, CSS, CSS3, .NET Controls and C#.
  • Created the SSRS Reports which can be used in the reports module using report viewer
  • Designed presentation layer for dynamic web forms using ASP.Net MVC 5.0 Framework, HTML5, CSS3, JSON, Angular JS and Visual Studio 2012/2010
  • Created SSIS Packages for Integrating data from one system to Main System
  • Used JavaScript/JQuery and .NET Validation Controls for performing client-side validations.
  • Used WCF, REST, RESTFUL, Web Services, APIs for designing back end components.
  • Designed a Master Page and used CSS for to provide a consistent look and feel of inherited web pages.
  • State Management Techniques are used to maintain state at control level using View State and at application level using Sessions.
  • Created APIs and SDKs for the other teams to use
  • Integrated the applications with the third party APIs and worked on N-Tier architecture
  • Worked with existing web apps features using ASP.NET Login Controls, Personalization, Membership, Authentication and Authorization.
  • Worked with MVC 3.0/4.0 architecture application using Razor view engine and web API.
  • Used Nlog and other error logging libraries to handle the exceptions and bug fixes
  • Extensively worked on Creating, Transmitting and Consuming WCF and Web Services.
  • Performed database operations on SQL Server 2012 by creating SQL queries, stored procedures, functions, indexes and views.
  • Used Microsoft Team Foundation Server for version control and file sharing.

Environment: .NET Framework 3.5/4.5, Visual Studio .Net 2012/2008, IIS 7.0, C#.NET 3.0, ASP.NET 3.0, ADO.NET,LINQ, HTML, HTML5,AngularJS, CSS, CSS3, AJAX, COM+, WPF, ecommerce, Win forms, JavaScript, Jquery, WCF, Web Services, REST, WEB API, QL Server 2008, SSIS, SSRS, XML, and SMTP.

Confidential, Los Angeles, CA

.Net Developer

Responsibilities:

  • Involved in gathering requirements from the end clients.
  • Collected the contract, deal summary and agreement documents to go over the details required for the project.
  • Involved in the design and analysis of the project.
  • Created the mockup pages in Microsoft Visio 2008 to show to the end clients and require approval.
  • Attended meetings of the design logic and required components for the project.
  • Created Master Pages to display required information on every page of application
  • Developed several .aspx pages using C# as per the client’s requirements.
  • Developed user interface using ASP.NET, JavaScript, CSS, CSS3 and HTML5.
  • Used .NET AJAX controls to dynamically render the content on web pages developed using C#.
  • Used Grid views, Validation controls extensively during development.
  • Developed User Controls to provide search functionality on documents.
  • Developed WCF Service to get the Customer Details to be reported in the month end reports.
  • Involved in creating the database schema and table structures in various cycles using Oracle 10g.
  • Involved in integration of applications and maintained versions using VSS (Visual Source Safe).
  • Created tables, sequences and triggers using SQL Server 2008.
  • Worked with Oracle 10g and integrated with the .NET applications using the API.
  • Developed and provided the team with the data layer functions using ADO.NET and LINQ to connect to database and fetch data.
  • Debugged the production issues
  • Created the .CSS style sheets for designing the layout of the GUI screens.
  • Version control maintained through Visual Source Safe.

Environment: Visual Studio 2008,Telerik Controls, ASP.NET, ADO.NET, C#,PL/SQL, JavaScript, CSS, CSS3, HTML5, SQL 2008, Oracle 10g, Visual Source Safe, Microsoft Visio 2008.

Confidential, Wayne, NJ

.NET Developer

Responsibilities:

  • Involved in all phases of SDLC which Involves Project Planning, Analysis, Design, Documentation, Development, implementation and support of software applications based on N-tier architecture.
  • Involved in the process of designing and developing web based UI Layout using ASP.NET .
  • Worked with Telerik Rad Controls to develop rich interactive engaging User Interfaces
  • Developed the Business Logic Layer using C# .NET.
  • Used ADO.NET and its components Data Reader, Dataset, Connection and Data Adapter to access the SQL database.
  • Used extensively Java Script and ASP.NET AJAX for front end and Ajax framework.
  • Implemented client side logic using Java Script .
  • Used Ajax (Asynchronous JavaScript and XML ) for calling server-side code from the client side to avoid post-backs, making the process faster.
  • Created and consumed WCF web services in the application
  • Used ASP.NET client side and server side state management to preserve data
  • Used ASP.Net caching to improve the performance of the pages
  • Responsible for writing stored procedures in T-SQL for backend communication.
  • Created triggers, functions, cursors and joins on database tables in SQL Server database
  • Designed & developed web user interface using HTML, HTML5, CSS, JavaScript, ASP.NET , and developed custom Web controls .
  • Involved in Unit testing, bug fixing and User acceptance testing.
  • Used TFS (Team Foundation Server) for source control.

Environment: Visual Studio.NET 2008, .NET Framework 3.5, C#.NET, ADO.NET, ASP.NET, AJAX, and Telerik Rad controls, TFS 2008, SVN (Subversion), SQL SERVER 2005/2008, WCF.

Confidential

.Net Developer

Responsibilities:

  • Developed the Web pages in ASP.NET, C# and VB.NET.
  • Designed BL and DAL using C#, ADO.NET and Sql Server.
  • Implemented membership and role based providers for authentication and authorization.
  • Implemented agile methodology and SCRUM framework for rapid development. Acted as Scrum Master.
  • Used ASP.NET Web Forms, server controls extensively, setting up an inheritance chain of Forms following Object Oriented Programming Principles.
  • Exposed Business functionality by Creating Web Services.
  • Created procedures, functions, triggers using T-SQL
  • Used IBM Clearcase for logging, tracking defects in development and QA release phases.

Environment: C#. NET, ASP.NET, ADO .NET, MS Visual Studio. NET, Web Services, XML, XSLT, UML, JavaScript, SQL Server 2005.

Confidential

Programmer Analyst

Responsibilities:

  • Developed basic windows based application using c#.net for various desktop applications used in the company.
  • Developed Web forms for registration, to update the policy installment pages and application logic in ASP.Net, C# utilizing the power of Microsoft .NET Framework.
  • Used ADO.Net in connecting to Data Access management with SQL Server.
  • Design and development of user interface using ASP.NET, VB.Net, HTML, JavaScript
  • Used User Controls for a group of common controls.
  • Implemented Win Forms to provide GUI components using .NET Framework.
  • Creation of stored procedures, views, functions, triggers and DTS in MS SQL server2000
  • Generated the required reports with the help of data grid, data list.

Environment: .NET Framework 1.1, C#.NET, win-forms, ASP.NET, ADO.NET, SQL Server 2005, IIS 5.0, Windows 2000, HTML, XML, Visual Studio.NET 2003, Classic ASP, JavaScript.

Hire Now