PROFESSIONAL SUMMARY:

• Over 8+ Years of professional IT Experience in analysis, design, development, testing and implementation of Client/Server and Web - based N-tier architecture systems using Microsoft Technologies and Data Warehouse, RDBMS concepts as ETL/SQL Server database Developer and BI Developer.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, and Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SQL Server Reporting Services (SSRS).
• Designer/developer of Web and Windows applications using .Net 3.0/3.5/4.0/4.5 , C#, VB.NET, Win forms, ASP, ASP.NET, ASP.NET MVC, ADO.net, Web services, Web API, WCF, and XML in multitier architecture.
• Expertise in the development of Web, Windows using Visual Studio.NET 2005/2008/2010/2012.
• Expertise in working with ADO.NET, LINQ, LINQ to SQL, LINQ to Entities and Entity Framework
• Highly skilled in web building technologies like HTML, DHTML, JavaScript, JQuery, JSON, CSS, XML, XSL, XSLT, DTD/Schemas and AJAX.
• Experience in working with larger volume of database.
• Experience in Performance Tuning and Query Optimization Exposure to Windows Communication Foundation (WCF), Windows Workflow Foundation (WWF), Windows Presentation Foundation and LINQ.
• Experienced in SQL Server Analysis Services (SSAS) OLAP Cubes, Implemented Snow Flakes Schema and Star Schema and multidimensional databases.
• Proficient in Object Oriented Design/Development (OOD), Object Oriented Analysis and Design (OOAD), and Model View Control (MVC) design pattern.
• Experience with Visual Studio 2000/2005/2008 , SQL Server 2000/2005/2008 /2012, Oracle 9i/10g.
• Good working experience in performing Unit Testing in all .Net Applications developed.
• Strong understanding of agile software development methodology.
• Excellent communication skills both verbal and written and ability to work on own besides being a valuable and contributing team player.
• Knowledge on Tableau desktop application.
• Experience with all the phases of Software Development Life Cycle (SDLC) and Quality procedures while executing projects.
• Strong experience in design patterns like Model View Controller (MVC).
• Extensive experience in using SQL Management Studio, SQL Server Business Intelligence Solutions like SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Service Package).
• Experience in working with Ajax Control Toolkit with AJAX Extensions.
• Good experience in developing and consuming Web Services using SOAP.
• Good Understanding of XML, XML Schema, WSDL, UDDI and SOAP.
• Extensive experience in creating PL/SQL, TSQL Stored Procedures, Triggers, and Views.
• Good experience in developing Configured and Consumed Web Services using Windows Communication foundation (WCF) in C#/VB.NET.

TECHNICAL SKILLS:

Operating Systems: Windows XP, Windows Vista, Windows 2000/2003/2007

.Net Technologies: .Net Framework 1.0, 1.1, 2.0, 3.0, 3.5,4.0, 4.5 ASP.Net, C#, VB.Net, ADO.Net, Web Forms, Win Forms, Web Services.

BI and ETL tools: Microsoft SQL SERVER 2012/2008/2008/2005/2000 Business Intelligent Development Studio (BIDS), SQL server Data tools, Microsoft SQL SERVER 2005/2008/2012 Integration Services Toolkit (SSIS), Microsoft SQL SERVER 2005/2008/2012 Analysis Services (SSAS), Pervasive Data Integrator, Adept SQL diff, Oracle SQL developer, Microsoft Visual Studio2010/2012

Reporting Tools: Microsoft SQL SERVER 2005/2008/2012 Reporting Services (SSRS), Report Builder 2.0, Report Builder 3.0, Crystal reports 10, Tableau

Web Development: ASP.Net, IIS 5.0,6.0,7.0, JavaScript, VBScript, CSS, XML, XSL, XSLT, HTML, AJAX, LINQ to SQL, MVC, WCF, WPF, Net Advantage 2005/2007, Outlook Express.

Programming: C#.Net, VB.Net, ASP.Net, ADO.Net, C, C++.Core .NET Technologies, J2EE EJB 1.x/2.x

Office and Other Tools: Microsoft WORD 2007/2010, Microsoft EXCEL 2007/2010, Microsoft POWER POINT 2007/2010, Microsoft Visio

PROFESSIONAL WALKTHROUGH:

Confidential, Los Angeles, CA

Dot Net Developer

Responsibilities:

• Coordinate with Business Team to map changing business requirement towards project goals. 
• Using Windows Presentation Foundation (WPF) for data validation.
• Developed T-SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Used Web forms to develop some web pages to generate the reports and made them visible in the form grids.
• Design and developed business logic using C# WinForms.
• Extensive use of REST Services to pass the JSON objects.
• Used Web API in MVC to build HTTP services.
• Involved in Meetings/Discussions with the site teams on a regular basis as part of the requirement gathering. 
• Source code management was done using Team Foundation Server (TFS). 
• Responsible for setting up the security and bindings for WCF services using NodeJS. 
• Created the User interfaces (UI) using HTML Helper, Razor, JavaScript and CSS. 
• Designed views and partial view using Razor and Ajax. 
• Used Entity Framework and LINQ queries to save and retrieve data from database. 
• Used Microsoft Share point to communicate within the Enterprise.
• Mainly involved in the Production support.
• Added new features to the existing system.
• Performed Unit Testing.
• As this is a kind of single page application, AngularJS was used.
• Used entity framework as LDAP, ORM tool and Implemented LINQ Queries. 
• Involved in deployment of application on Azure server by creating packages.
• Design and Implement WCF services layer hosted on Windows Azure.
• Validation of data to maintain consistency between the FRS and the vendors using SSIS.
• Responsible for the testing, get the bugs fixed and troubleshooting the technical problems.  

Environment: ASP.net MVC 5, WinForms, .Net Framework 4.5, C#, REST Services, IIS 8, SQL Server 2008, CSS3, HTML5, Visual Studio 2013, Core .NET Technologies, J2EE EJB 1.x/2.x, JavaScript, JQuery, JSON, AngularJS, Agile.

Confidential, Paramus, NJ

Sr. .Net Developer/ SQL developer

Responsibilities:

• Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Developed various drill down, parameterized reports. using SSRS 2008/2012
• Proficient in Importing/Exporting Data from various data sources like Excel, Oracle and Flat file using SSIS utility
• SSIS Package Deployment to Production Server as well as Job Scheduling for Package In Daily bases
• Scheduled jobs and alerts using SQL Server Agent.
• Worked extensively with debugging, defect tracking and troubleshooting issues.
• Used Event Handlers for Exception Handling in SSRS packages
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different Accela DB
• Involved in some of the key discussions with vendors and client business meetings.
• Responsible for Developing, Monitoring and Deploying SSRS packages.
• Involved in all phases of Development life cycle and responsible for creating the Entity-Relationship diagrams, Class diagrams, Sequence diagrams and Flow diagrams and documenting the project architecture.
• Involved in Design and Developing components of the applications using ASP.NET, MVC, C# .NET, JavaScript, JQuery, AngularJS, and XML.
• Deployed Packages from Development to UAT, Production and BCP Servers using TFS.
• Created materialized views, dimensions and stored outlines for optimal performance.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Developed SQL queries to display the client reports in .net framework (4) web based application.
• Monitored the database to identify and resolve the performance issues using SQL Server Profiler.
• Created database tracking alerts, sanity checks and a data purge process to control the database changes over a time period.
• Designed a problem tracking system using Excel, VBA, and Access 97 to resolve, itemize, and prioritize opens issues and bugs.
• Worked with MVC 3.0/4.0 architecture application using Razor view engine and web API.
• Developed Views, controllers and business logic models using C#.
• Worked in the environment using agile methodology.
• Worked with the QA teams during the process of pushing out the QA build and testing process and fixing the raised defects.
• Involved in Coordinating with off-shore team and giving Non-prod support for 24hrs at on call schedules.
• Written T-SQL Queries, Stored Procedures for the SQL Server backend.
• Worked on Query Optimization of the SQL Server T-SQL queries and also optimized the applications
• Involved in Testing, Debugging and code review of the Applications.
• Involved in the Production Support activities along with the development work Used TFS for the purpose of version Control and source code maintenance needs.
• Responsible for writing Unit Tests for the code developed.
• Used LINQ to SQL as the data provider for communicating with the SQL Server Database.
• Developed packages by using SSIS and developed various reports by using SSRS.
• Worked on existing system on VB.NET with any ODBC compliant database
• Integrated SSRS reports into the web application using Report Viewer Controls.
• Involved in Implementing Service Oriented Architecture (SOA) and used WCF to expose business logic as services and consumed those services. Defined service contracts, implemented service contracts etc.
• Extensively worked on Consuming, Calling, Transmitting and Processing WCF Services.
• Developed RESTFUL/WCF Web services, APIs, and other back end components.
• Involved in preparing the Database design and Product requirements document for a conversion project.
• Performed check for coding standards and code review for the application code.
• Maintained Application state using Cookies, Application object and Caching.

Environment: .NET Framework 4.5, Visual Studio 2008/2012, SOA architecture, C#, ASP.Net, MVC 3.0/4.0, AJAX, WCF, JSON/RESTful Services, IIS Web Server, LINQ, CSS 3, SQL Server 2008 R2/2012, JavaScript, AngularJS, VBA, JQuery, HTML 5, Agile, SCRUM, SSRS.

Confidential, LA, CA

Sr. .Net Developer

Responsibilities:

• Designed and developed Web Pages using ASP.NET, VB.Net, C#.NET, HTML, JavaScript, CSS and server controls.
• Security features were provided using Cookies and Session ID so that unauthorized access could be denied.
• Used various server controls like Multi View and Grid View with extensive data binding to display, page and sort multiple records.
• Developed Web Forms for User Interfaces using ASP.NET and VB.NET using Server Controls, HTML Controls and User Controls.
• Used J2EE EJB 1.x for the java application.
• Created and deployed XML Web Services (WCF) using ASP.NET and C#, used them to generate the proxy class files based on the web services and consumed in web application.
• Used Cascading Style Sheets (CSS) to maintain design consistency across all web forms
• Developed WCF Services, defining Endpoints, Data Contracts, Message Contracts, Bindings, and Transaction management in service layer and Hosting WCF services
• Used SOAPUI & SOA Cleaner Express tool for testing WCF Services
• Established communication between different applications running on same/different platforms using WCF.
• Developed, modified, and optimized Stored Procedures, Tables, Views, and other statements to handle complex business rules.
• Scheduled Daily, Weekly and Monthly jobs using SQL server agent to load the data into the tables as per their market requirements.
• Developed the SQL Server Reporting Services (SSRS) packages to load data from Oracle database to SQL database.
• Created SSIS package to load data from XML Files, Excel, CSV file, Ftp server and SQL Server to SQL Server 2012 by using Derived Columns, Condition Split, Data Conversion, Ole DB Command, Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Script Component Task.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Deployed Packages from Development to Production Server.
• Used SQL server reporting services (SSRS) to create and customize various on-demand reports, ad-hoc reports and sub reports. Published the reports on the web server to be accessed by the case managers.
• Managing Reports using Security, standard and data driven subscriptions in Report Server using SSRS.
• Extensively used J2EE EJB 1.x for the application while enhancement
• Populate reports into SharePoint portal site from SSRS.
• Designed index, statistics, and optimized queries by using execution plan for performance tuning of the database.
• Used SSIS to process the text file data into Database and clean up the file system folders for next day's processing.
• Created SSIS Packages that Transfers Databases from One SQL Server instance to Another Instance
• Developed SQL Queries to fetch complex data from different tables using joins, database links and formatted the results into reports and kept logs.
• Identified the Data Source and defined them to build the Data Source Views.
• Loaded the data into excel files and developed excel pivots from the data loaded in that excel files.
• Involved in testing, bug fixing and documentation for the project.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.

Environment: SQL Server 2008R2/2008, SQL Server Management Studio(SSMS),T-SQL, Business Intelligence development Studio(BIDS), SSAS, SSRS J2EE EJB 1.x, Windows 2007,C#.Net, VB.Net, .NET Framework 4.5, ADO.Net, Win Forms, WCF, MVC, Web Services,

Confidential, Albany, NY

.Net Developer/ SSRS&SSIS developer

Responsibilities:

• Created the application from the scratch by using C#.Net, Asp.net 4.0
• Involved in daily meeting to gather requirements.
• Generated multiple reports by using SSRS and linked to the web application.
• Unit testing, debugging and deploying it to Dev & production environments
• Monitoring the application for any issues and fixing it
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Transaction and Data Ware House.
• Converted DTS Package to SSIS package for synchronizes existing process (DTS migrations).
• Used Team Foundation Server to retain Project code during deployment process.
• Part of Code review during Production deployment and QA deployment.
• Designed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data in to the Data Ware House.
• Designed Console application to generate Single .CSV and text file from Different relational Database table using SSIS and C#.
• Created Process for Error Details in Application system, Control-M Job, SQL agent Job to easily identify Issue for Support and Solution.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Created reports to retrieve data using function, views, cube and Stored Procedures using parameters.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Interacting with users to grab the requirement and finishing the tasks on time
• Assigning permissions for the users in the SQL DB and HMS to access the application

Environment: ASP.NET 4.0, MS Visual Studio, .NET Framework 4.0, C#.Net, SQL DB 2012, Access DB, SSRS,SSIS

Confidential, Tampa, FL

.Net Developer/ SSRS&SSIS developer

Responsibilities:

• Full life cycle object oriented software development. Used Use-Case analysis to clarify requirements. Modeled designs using Rational Rose to create UML class and sequence diagrams.
• Designed and developed five different websites for five types of users.
• Interacted with the client in person to analyze their requirements and demonstrate the developed application.
• Involved in AGILE software development methodology.
• Developed Web Applications using HTML, CSS, AJAX, IIS, C#, ASP.NET, JavaScript, XML, SOAP, and Visual Studio.net.
• Designed the user interface screens and implemented application logic under the Microsoft .NET framework using C# to use .NET features powered with CLR.
• Designed and Implemented Business logic layer using C#.
• Developed reusable user controls using C#, ASP.NET.
• Created Class Libraries and used them extensively throughout the project.
• Developing screens using ASP.Net server controls & doing form field validations server side validations using C# and ASP.Net validation controls.
• Used Custom Validation and User Validation to give access to registered users.
• Designed and developed UI using ASP. NET/MVC, CSS3, JQuery.
• Developed Master pages to build consistent and maintainable user interface.
• Extensively worked with C#, Web Services in creating various integration projects.
• Programmed ADO.NET for communication between application and database, used extensively Data Set, Data Table, Data Views and Data Readers.
• Created services using WCF (Windows Communication Foundation), Web Services for data exchange.
• Designed the project to follow the MVC3 (Model-View Controller) architecture.
• Developed Tables, Stored Procedures, Triggers and Functions.
• Developed Windows Forms (Win Forms).
• Worked with Entity Frame Work for the module development.
• Developed ETL data transformation tools using SSIS packages via the Business Integration development environment in Visual Studio.Net.
• Effectively created reports using SSRS 2008 R2.
• Developed different kinds of SSRS reports like Parameterized, Linked and Drill down Reports.
• Implemented page- level error handling and Custom Error pages.
• Used Visual Source Safe 6.0 for Version Control.
• Involved in deployment and Post Production support for the application.
• Designed data access layer using C#, LINQ, ADO.NET datasets & data adapters.
• The application uses jQuery for dynamic and interactive UX, data retrieval and posting.
• Created and Used Batch Files to complete the interface between various databases and to keep them real time.
• Designed web pages using WPS for rich control and development visual effects.
• Designed & developed web user interface using C#, ASP.NET, HTML, JavaScript, server controls such as Data Grid, Data List, Validation controls.
• Developed JavaScript for dynamic user interface and browser compatibility tests.
• Built the Tables, Views, queries, stored procedures and triggers for the System using TSQL SQL Server.
• Generated various reports using SQL Reporting Services.
• Involved in testing and debugging and performed thorough unit testing.
• Used Visual Source Safe for Project management.

Environment: ASP.NET 3.5, MS Visual Studio, .NET Framework 3.0, C#, ADO.NET, SQL, UML, XML, VSS, JavaScript, CSS, AJAX, TSQL SQL Server, Windows PL/SQL, SQL Reporting Services, MVC, SQL Server 2012 R2, SSRS, SSIS, Web Services, WCF, WPS, AJAX, JavaScript, HTML5, CSS3, TFS, IIS, Crystal Reports.

Confidential, Palo Alto, CA

Sr .Net Developer/ SQL developer

Responsibilities:

• Involved in full software development life cycle for analysis, design, development, documentation, testing, delivering projects on Time.
• Developed modules of the application in ASP.NET and involved in writing C#.NET classes.
• Designed of large scale business applications and systems in a web-based multi-user environment.
• Involved in development of web graphics and graphical (UI) Pages using the HTML, Cascading Style Sheets (CSS) Master Pages & ASP.NET Controls and UML / Modeling Tool.
• Used Ajax on server controls to avoid page post back and page flickering.
• Developed Win-Forms Application to calculate the monthly billings.
• Developed application as N-tier application with UI in the presentation layer using ASP.NET, business logic in the middle layer using C#.NET and data service activities in the backend using SQL Server 2008.
• Optimized queries and tuned performance using SQL Server tools including SQL Profiler, SQL Performance Monitor and Execution Plan.
• Generated SQL Server Database objects including Tables, Views and Indexes.
• Created and modified stored procedures, triggers and queries for automating various interface tasks using T-SQL.
• Analyze and Created SSAS cube and set up role based security in the cube.
• Defined Testing strategies and designed Test Plans to test each system Interface output and validated output data from each Interface based on respective Test Plans.
• Ensured the quality of the output for each system Interface by conducting Meetings with the respective vendors to review the output and obtain continuous feedback.
• Identified and defined Key Performance indicators (KPIs) for vendor reporting.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008R2.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008R2.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008R2.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Created Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Supports the development, implementation and daily administration of SQL Server databases, performs database design, modeling and implementation of new database structures, as required.

Environment: Visual Studio 2010, .NET Framework 4.0, ASP.NET, C#.NET, TFS, SQL Server 2008R2, T-SQL, IIS, AJAX, XML, Identity Manager, XSD, XSLT, Win forms, Web Services, Java Script, CSS, HTML.

Confidential

Dot Net Developer

Responsibilities:

• Involved in designing and coding for web forms of the application with ASP.NET 1.1.
• Ability to design options for cloud application development, cloud application deployment, private versus public cloud options, virtualization, containerization.
• Experience analyzing, reverse-engineering, and documenting the design of existing cloud solution.
• Involved in developing UI, Business Layer and Data Access Layer and used C#.NET as code behind to implement the business logic of the web forms.
• SQL Server 2000 is used as the back-end database which stores all the data used in entire application and implemented Stored Procedures, Database Triggers, Views, and Indexes with SQL programming.
• Used ADO.NET to implement the data layer to help communicate with data base
• Used Visual Source Safe for version control and Participated in unit testing of the application to ensure quality.
• Responsible for creating complex SSRS Reports based on client specifications.
• Involved in building flexible UI, more user interactive and user-friendly web pages, reusable classes, functions using ASP.NET, C#, AJAX and JavaScript for client side validation.

Environment: Visual Studio.NET 2003, C#.Net, ASP.NET 1.1, ADO.NET, IIS, Web Services, HTML, DHTML, SQL Server 2000, Windows XP.