SUMMARY

• Microsoft .Net, SSRS/SSIS/SQL Developer with over 7 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.
• Worked in Water Fall and Agile Scrum methodology.
• Hands on experience in dealing with Relational Database Management Systems, including StoredProcedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors,Normalization.
• Highly Proficient in creating SQL Server Reports, handling sub - reports and writing queries to perform roll-up and drill down operations in SSRS.
• Strong experience in SQLDevelopment, ETL development using Microsoft SQL Server Integration Services (SSIS) and Reportingsolutions using Microsoft SQL Server Reporting Services (SSRS).
• Hands on experience in Architecting Web and Windows based applications using MVC Patterns.
• Experience in creating efficient windows and web applications using latest Microsoft technologies like WCF, SQL server Reports using SSRS.
• Hands on experience in installing, configuring, managing, monitoring and troubleshooting Windows, web based application, SQL Server Reports.
• Applied the best practices and followed coding standards during the course of application development.
• Experienced in consuming and developing ASP.NET, Web API, WCF Web Services using Simple Object Access Protocol, developing Service Oriented Architecture SOA based servicesand REST.
• Developed applications using .NETapplication building blocks (Data access, Exception Handling, State management)
• Working experience with JavaScript, JQuery, JSON, AJAX, HTML, HTML5, CSS, CSS3.
• Involved in Unit testing, Integration testing and Functional testing.
• Involved in estimating the efforts of different phase of the project.
• Expert knowledge in SQL Server Package Configuration technique to make Dynamic configurations for SSIS packages.
• Excellent understanding of T-SQL (DDL and DML) and good understanding on Execution plans.
• Working knowledge in configuration and version management using Visual Source Safe (VSS),Clear-Case, Subversion (SVN) and Team Foundation Server (TFS)
• Involved in Client Interaction meetings and in co-coordinating releases with multiple teams.
• Strong analytical and programming skills with proven track record in creating elegant, flexible and maintainable solutions as per Business Requirements.
• 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, SSIS, SSRS

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, San Diego, CA

SQL/.Net Developer

Responsibilities:

• Developed a 3- tier web application following Agile development methodology.
• Analyze functional and business requirements to design, develop, configure and deploypackages and components customized to meet specific needs and requirements.
• Worked on automating various manual processes using Microsoft latest technologies and Framework.
• Created and ExposedAPIs and SDKs for the other teams to use.
• Integrated the applications with the third party APIs and worked on N-Tier architecture.
• Extensively worked on Creating, Transmitting and ConsumingWCF and Web Services.
• Developed applications & services like Lockbox file generator, XML Image Transfer, Remit Import Unzip, XML Import using C#.net, WPF.
• Involved on fixing complex issues in order to run production environment smoothly.
• Worked on deploying and scheduling various windows services using windows task scheduler in order to have periodic updates.
• Created Parameterized reports and Linked reports using SSRS.
• Extensively worked on Data Flow transformations like Foreach Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Used Text Files/ SQL Server Logging for all SSIS packages.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked with various SSIS packages which involve Transactions, Restartability and roll back techniques.
• Involved in training internal users in SSIS, SSRS to support UAT.
• Helped QA in deploying and testing the applications on UAT and Production environment.

Environment: .NET Framework4.5/4.51, Visual Studio .Net, IIS, C#.NET, ASP.NET ADO.NET, LINQ, HTML 5,AngularJS,CSS 3,AJAX, JavaScript, jQuery, MVC 4.0/5.0, WCF, Entity Framework 6, Perl, PowerShell scripting, nUnit,WPF, Web Services, REST, WEB API, SQL Server 2012, SSIS, SSRS, XML, and SMTP.

Confidential, Harrisburg, PA

SQL/.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.
• Used WCFServices for executing the packages/Interfaces.
• Involved in creating various SQLQueries, SQLscripts, relationaldatabases,DTSpackages, triggers, StoredProcedures and Triggers with SQL Server 2012.
• Involved in Requirementgathering, Design, Development and Testing of Web Forms.
• Involved in managing the client meetings, documenting the functional and businessrequirements.
• Developed RESTFULWebservices, APIs, and other back end components.
• Used MVC 4.0/5.0 Pattern to design the Test driven UI Layer.
• Followed SOA (Service Oriented Architecture) and developed Data Transfer Objects (DTOs) and Mappers.
• JQuery andKnockoutJSexperience in implementing UI features.
• Responsible for setting up the security and bindingsforWCFservices
• Used XML to create Web-based tools for transactions on SQL and Oracledatabases.
• Extensively worked on SSIS Package Development and used all types of transformations.
• Modified existing SSISpackages to meet current business needs
• 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.

Environment: .netFramework 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, WinForms, XML, MVC 3.5/4.0, Web services, WCF, RESTFUL services, Knockout JS, LINQ, MS SQL Server 2012/14, TFS 2012 andAgile Methodology.

Confidential, Dallas, TX

SQL/.Net Developer

Responsibilities:

• Interacted with Business team to collect data for the conceptual design of the system.
• Interacted with Development Teams and Managers to analyze business needs and developed technical specifications like Dataflowdiagrams, detailedspecification do.
• Participated in to Development of various modules. Successfully met challenges of handling programs dealing with very highvolume of data.
• Wrote complex T-SQLqueries, storedprocedures, triggers, cursors and userdefinedfunctions (UDF's).
• Imported XML data file and put into the desired database using C# programming language.
• Involved in Design, Development and Testing of Web Forms and Web Services usingIIS 6.0, ASP.NET, XML, and ADO.NET.
• Used ADO.Net, LINQ in connecting to Data Access management with SQL Server.
• Used JavaScript/JQuery and .NET Validation Controls for performing client-side validations.
• Used WCF, REST, RESTFUL, Web Services, APIs fordesigning back end components.
• Created the SSRS Reports which can be used in the reports module using report viewer
• Created SSIS Packages for integrating data.
• Used Nlog and other errorlogginglibraries to handle the exceptions and bug fixes
• 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, Knockout JS,CSS, CSS3, AJAX, COM+, WPF, WinForms, JavaScript, jQuery, WCF, Web Services, REST, WEB API, PL/SQL,XML, and SMTP.

Confidential, DE

SQL/.Net Developer

Responsibilities:

• Involved in interacting with business analysts, other developers and management to develop the application.
• Followed Agile Methodology for the development of the project
• Worked in ASP.NET MVC3.0/4.0 Design pattern to create web applications.
• Used AJAX to do the asynchronous calls to the server.
• Creating new pages and fixing bugs on existing pages
• UsedASP.NET as the UI layer to support the existing applications on .NET 2.0
• Optimizing, debugging and creating T-SQL stored procedures in SQL 2008 R2.
• Worked on SQL queries to retrieve data from SQL Server 2008 Database.
• Used C#.NET as the programming language
• Resolved issues in other applications that are used C#.NET.
• Built and consumed WCF Services to transfer the data within the network and outside the network.
• Developed RESTFUL/WCF Web services, APIs, and other back end components.
• Implemented OOD patterns like Singleton and Dependency Injection.
• Used Entity Framework in the data access layer.
• Used LINQ to Entities data provider for interacting with the data in the Entity Framework.
• Performing and participating in code reviews
• Used JavaScript and JQuery for client side scripting.
• Followed Service Oriented Architecture (SOA) to develop loosely coupled layers.
• Responsible for doing AJAX calls to the server using JQueryandJSON
• Writing test plans and assisting with Requirements documents
• WrittenUnit Tests for the modules developed
• WroteSQL queries with Joins on multiple tables
• WroteStored Procedures, Functions, Triggers, and Indexes on SQL Server 2008.
• Designed web pages usingASP.net server controls, HTML, AJAX, CSS, CSS3,HTML5and JavaScript.
• Worked on Performance Tuning of the Queries.
• Written packages to transfer the data between the different data sources using SQL Server Integration Services
• Performed Data transformations using SSIS (SQL Server Integration Services) via the Implemented enhancements for better performance.
• Helped on Data sources for SSRS reports and integrated them in the ASP.NET applications
• Performed several testing to fix the bugs and ensure the application error-free.
• Written Use cases for the solution built
• Extensively Used TFS (Team Foundation Server) for the maintenance and status of the developers for development of application

Environment: .NET 2.0/3.5/4.0, ASP.NET, C#, ADO.NET, Visual Studio.NET 2005/2008/2010 , MVC 2.0/3.0, T- SQL, HTML, AJAX, CSS, CSS3, WPF, AngularJS, PowerBuilder, HTML5,XML, SQL Server 2008, JavaScript, Oracle11g, JQuery, JSON, WCF, Entity Framework, LINQ, IIS

Confidential, Los Angeles, CA

SQL/.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 thedesign and analysis of the project.
• Created the mockup pages inMicrosoft Visio 2008to show to the end clients and require approval.
• Attended meetings of the design logic and required components for the project.
• CreatedMaster Pagesto display required information on every page of application
• Developed several.aspxpages usingC#as per the client’s requirements.
• Developed user interface usingASP.NET,JavaScript, CSS, CSS3and HTML5.
• Developed PL/SQL queries to fetch data as per the business requirements with proper tuning techniques.
• Used .NET AJAX controlsto dynamically render the content on web pages developedusing C#.
• UsedGrid views,Validation controlsextensively during development.
• Experience in migration of legacy applications written in ASPandPowerBuilder.
• DevelopedUser Controlsto provide search functionality on documents.
• DevelopedWCFService 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 usingOracle 10g.
• Involved in integration of applications and maintained versions usingVSS(Visual Source Safe).
• Worked with Oracle 10g and integrated with the .NET applications using the API.
• Developed and provided the team with the data layer functions usingADO.NETand LINQ to connect to database and fetch data.
• Debugged the production issues
• Created the.CSSstyle sheets for designing the layout of the GUI screens.
• Version control maintained through Visual Source Safe.

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

Confidential, Wayne, NJ

SQL/.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.NETand its components Data Reader, Dataset, Connection and Data Adapter to access the SQL database.
• Used extensively Java Script and ASP.NETAJAX 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.
• JQuery andKnockoutJSexperience in implementing UI features.
• Created and consumed WCF web services in the application
• Used ASP.NETclient side and server side state management to preserve data
• Used ASP.Netcaching 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.NET2008, .NETFramework 3.5, C#.NET, ADO.NET, ASP.NET, AJAX, TelerikRadcontrols, TFS 2008, SVN (Subversion), Knockout JS, SQL SERVER 2005/2008, WCF.

Confidential, KS

.NET Developer

Responsibilities:

• Involved in maintenance and ongoing enhancements to application developed in .netFramework 4.0/3.5, ASP.net, VB.net, C#, Web services, WCF Service, JavaScript, XML, HTML, T-SQL.
• Developed day to day documents for reporting and developing the application.
• Designed & developed web user interface using HTML, HTML5, CSS, CSS3, JavaScript, ASP.NET, and developed custom Web controls.
• Maintained ClassicASP applications in the existing system
• Extensively involved in developing components for Business and Data tier using C#, VB.net, ASP.net, andADO.net.
• Worked on windows services, which are used to read and store data from XML files in to the database.
• Extensively worked with Java script, hidden controls, Dropdown controls, masking, unmasking
• Maintained state of the Webpages by using View State and Session Memory objects.
• Created Stored Procedures, Triggers, and Functions to access and manipulate data from SQL Server.
• Worked on exposing web services using WCFarchitecture for the client to communicate and exchange data and involved design of WCF based Service.
• Involved in debugging, analyzing critical application issues by looking at the logs and other connectivity.
• Hosted applications in IIS 5.0.
• Used Tortoise Subversion for version control.
• Worked in Agile development environment and participated in meetings and discussions with department heads, project managers, architects and co - developers.

Environment: Visual Studio 2010, ASP.net4.0/3.5, C#, VB.net, XML, XSLT, HTML, CSS, CSS3, Subversion, T-SQL, ADO.net, MSMQ, WCF, IIS, Classic ASP, SQL Server

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.
• 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 IBMClear case 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