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.
