SUMMARY:

• Over 12+ years of software development experience in design, development, integration and implementation of web/Win Forms applications using Microsoft .Net Technologies.
• Experience Designing Classes, Interfaces, data structures and algorithms that are elegant, efficient, modular, reusable, testable and maintainable and follow good software design practices and principles.
• Mentor junior members of the team, provide guidance on architecture, design principles and best programming practices that will help the project and enrichment of the team.
• Have a thorough understanding of the languages, tools and libraries on the company technology stacks for server - side web service development.
• Experience as Lead Developer to design the software in detail, working with other lead developers and product owner and other stake holders on a product team.
• 12+ years of experience with strong knowledge of software development in the following technologies areas:
• Experience with XML features, procedures, T-SQL, complex SQL queries, DML, DDL. Familiar with Toad for SQL
• Experience in OOP design and development in Visual Studio 2015 using C# and VB.NET.
• WPF, WebAPI, OData, WCF, multi-threading, Task library, MVVM design pattern integration with WPF
• WPF MVVM pattern, grid, editors, etc. control libraries.
• Experience with testing, IOC, DI.
• Strong experience in development using .NET 3.0/4.0, WPF, C#, Prism/Unity/MEF
• .Net Framework 3.0 and Higher.
• Strong Knowledge of C# and VB.Net.
• Excellent Knowledge of ASP.NET, Web Services and Service Oriented Architecture (SOA).
• ASP.NET framework - Core 1.x and MVC 5 and above.
• Strong knowledge of using Entity framework for DAL design.
• Good knowledge of using MS Sql Server for web Applications.
• Good knowledge of third party controls - Far Spread, Infragistics and Telerik.
• Good familiarity with Agile tools TFS.
• Working Knowledge of Microsoft VS testing framework for unit testing.
• Experience in using source code Management tools like TFS and SVN.
• Expertise in VB6.0 Classic ASP, VBA,VSTO
• Expertise in ETL Tool SSIS/ Data Lever 4.0/6.0
• Expertise in Business Intelligence (SSIS, SSRS), Crystal Reports.
• Very strong in Object Oriented Analysis and Designing (OOA and OOD), Object Oriented Programming (OOP) including in depth knowledge of .NET Remoting and Memory Management
• Experienced in customizing and adopting Microsoft provided APPLICATION BLOCKS (Validation, Logging, Exception, Data, and Security)
• Experience in designing and developing enterprise applications using MVC (Model View Controller) Architecture.
• Good experience in LINQ and ADO.NET Entity Data Model Framework
• Experience in using Enterprise Library and Log4Net.
• Extensive experience in writing complex Database Queries, Stored Procedures, views, indexes, triggers and cursors
• Extensive knowledge on Agile methodologies as software development approach throughout my career for project management services
• Excellent exposure to migration projects from VB6 to VB.Net.
• Excellent exposure to migration projects from Classic ASP 2.0 to ASP.Net.
• Excellent exposure to Office Tools migration projects from VBA to VSTO.(Using .Net 4.0 Framework)
• Excellent exposure to migration of complex business Excel reports into SSRS.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008/2014 and Flat files.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) •
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments Development and Production.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS
• Involved in designing Parameterized Reports and Report Models for generating Ad Hoc reports as per the client requirements.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Environment: VB.NET,WPF,ASP.NET, MVC 3.0, C#, WCF,WEB API, Entity Framework,HTML, DHTML, Linq, CSS, AJAX, Visual Studio.NET, SQL Server 2008 R2, Windows 7, SSRS,SSIS

Responsibilities:

• Participated in a fully scalable WPF based client/server application using C#, WCF, Entity Framework and SQL Server.
• Wrote complex Database Queries, Stored Procedures, views, indexes, triggers and cursors T-SQL scripts for management and maintenance of application Databases.
• Worked with business stakeholders for the application and provided technical insight to business analysts to complete the application functional specification.
• Used Entity Framework / Linq for data access layer to communicate with the SQL Server database.
• Actively involved in project meetings with business people to gather requirements.
• Developing reports on SSRS on SQL Server (2008).
• ETL implementation using SQL Server Integration Services (SSIS).
• Using SSRS creating well-formed reports and web based reports for financial applications and transactions.
• Unit tested the application.
• Involved in deployment and post production support for the application.

Confidential, Houston, TX

SQL Developer/BI Developer

Environment: MS SQL Server 2008/2012, SSIS, SSRS, XML, ASP.net, ADO.net, VB.net, VB Script, IIS 5.0.

Responsibilities:

• Created ad-hoc reports using SQL server 2005 Reporting Services (SSRS).
• Uploaded SQL Server 2005 Reporting Services (SSRS) RDL files to SQL Server 2005.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Played a major role in production support of SSAS cube and SSIS jobs.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Extracted data from Oracle and migrated into SQL Server 2005 using SSIS.
• Design various E-R diagrams for different modules by using Erwin and Visio.
• Before doing any migration, by using the various functions of log shipping backup, copy and restore the database to different kind of servers.
• Migration is also done using Bulk Insert and dynamically created queries in the job steps.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Designed and implemented Dimensions and Measures according to business requirement.
• Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
• Presentation layer (GUI) application has been created using web forms, ASP.NET 3.0, MS Visual studio 2005, HTML.
• Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table. Generated ASP.net objects from tables and presented these DOM objects which are capable for easy communication, to the Business applications.
• Used ADO.NET objects to access data from SQL Server 2000 database by using Stored procedures and queries in T-SQL.
• Created Linked Server using the dedicated LAN for load balancing and increased the performance of the Data Warehouse.
• Utilized documentation prepared by Business Analyst to complete projects.
• Used business Analytics to prioritize reports.
• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Scheduled and maintained routine jobs, tasks, and alerts. For instance an alert would be sent to the manager of Sales department, if the entire field were not entered by the data entry person regarding screening using SQL Server Agent.
• Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes.

Confidential, Houston, TX

Environment: VB.Net,WPF,ASP 2.0, VB6.0, VBA, Telrik, HTML, DHTML, Linq, CSS, AJAX, Visual Studio.NET, Oracle 11g, Windows 7

Responsibilities:

• Project Documentation.
• Data Layer Implementation.
• L2 and L3 Support and enhancements of the existing legacy system.
• Performance tuning of the existing sql query and writing complex stored procedure using Oracle 11g.

Confidential, NH

Responsibilities:

• Converting Complex Views into Stored Procedures.
• Converting Complex Excel Reports into SSRS.
• Convert VBA code into .Net C#,VB
• Performance improvement of the existing sql query after converting them into stored procedures.

Confidential

Environment: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS, SharePoint.

Responsibilities:

• Created ETL mappings using Data Lever 4.0 to extract the data from multiple sources like Flat files, Oracle, csv, Delimited files transformed based on business requirements and loaded to Data Warehouse.
• Worked with mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Unconnected / Connected Lookups and Aggregators, Stored Procedure.
• Slowly changing Dimensions process flows.
• Coordinating with on-site team.
• Performed Unit Testing and SIT Testing.
• Preparation of Unit Test and SIT Test Cases
• Analyzing the existing system.
• Engage in peer reviews during design, coding and testing.
• Ensure adherence to quality processes

Confidential

Responsibilities:

• Implemented Web Controls, Custom Controls, User Controls, HTML, DHTML and Style Sheets for the Front-end development using ASP.NET using C#.Net
• Developed User Interface pages using ASP.NET Web Forms, Web Server controls and custom user controls, HTML, DHTML, XML, XAML, XSL, CSS, JavaScript, JQuery, C#
• Used Model-View-Control (MVC) software architecture in web applications to view the html.
• Developed Windows Communication Foundation (WCF) Service Layer for Service Oriented Architecture (SOA).
• Exclusively Used the AJAX Password Strength Control tool for implementing and maintaining the login controls in web application.
• Used ASP.NET Page lifecycle Techniques and handle a control's initialization, instantiating controls, restoring and maintaining state, running event handler code, and rendering
• Implemented features of ASP.Net AJAX such as Calendar Controls, Repeater Control, and Validation controls, Dataset.
• Developed the data layer class, Business layer class using C# which is reusable for data transactions of entire project.
• Implemented DataGrid, Dataset, Data Reader and Data Adaptors for Data manipulation.
• Implemented Queries using LINQ for effective access with database and easy handle of file operations and XML.
• Used ASP.Net web application in LINQ to SQL for database connectivity.
• Scheduled jobs for executing the stored SSIS packages which were developed to update the database
• Created complex Stored Procedures, Views, Triggers, Functions and Indexes for database for fast retrieval of data in SQL Server using T-SQL.
• Created complex stored procedures and SQL Statements for generating Ad-hoc Reports.
• SQL Server 2008 RDBMS database development using TSQL, programming, queries, stored procedures, views.
• SQL Server 2008 OLAP database development working with slow changing dimensions.
• Developing reports on SSRS on SQL Server (2008).
• ETL implementation using SQL Server Integration Services (SSIS).
• Using SSRS creating well-formed reports and web based reports for financial applications and transactions.

Environment: ASP.NET using C#, ADO.NET, LINQ, AJAX, CSS, Web Services, Visual Studio 2008, .Net Framework 3.0/3.5, SQL Server 2005/2008, Agile Methodologies, XML, IIS 7.0, JavaScript, SSIS, SSRS, Crystal Reports, MVC, WCF, Telerik RAD controls, Team Foundation server.

Confidential

Responsibilities:

• Involved in the analysis, design & development and testing of the system
• Responsible for the implementation of Web Controls, Custom Controls, User Controls, HTML, DHTML and Style Sheets for the Front-end development using ASP.NET and C#.Net
• Used MVC as software architecture of the project.
• Involved in writing business logic using C#.NET, by MVC Architecture
• Involved in writing business logic using C#.NET in 3-Tier Architecture for code security and performance
• Implemented Client-side validation using JavaScript, AJAX, and JQuery to send http request to the server in response to the requirement.
• Designed different components using C#.NET language with extensive use of Object Oriented Programming Techniques (OOPS) like Abstract Classes, polymorphism, Interfaces etc.
• Implemented DataGrid, Dataset, GridViews, DataReader and DataAdaptors for Data manipulation
• Involved in design and development of middle tier web services which encapsulate the business logic in its methods and wrote data access classes using ADO.NET and C#
• Created complex Stored Procedures, Triggers, Functions and Indexes for database for automating the tasks and for generating reports using SSRS.
• Created different SSRS parameterized and non-parameterized reports for analysis of high level management.
• Was also involved in deploying SQL server Reporting services SSRS reports on a Reporting server at client place.
• Developed Business Logic Component using Web Service, WSDL. Implemented SOAP (Simple Object Access Protocol) for communication of application.
• Involved in writing Test plans and Test cases.
• Developed profiling tool and test scripts specific to the tool and Unit testing using NUNIT.
• Involved with team members and solved deployment issues during the production server
• Extensively used Visual Source Safe for back up and controlling the source code.

Environment: .NET 3.5 Framework, Visual Studio 2008, SQL Server 2008, SSIS, SSRS, ASP.NET, AJAX, IIS 7.0, Windows Communication Foundation(WCF),MVC, Web Services, Win Forms, C#, XML, HTML, java script, CSS, Visual Source Safe.

Confidential

Responsibilities:

• Designed and developed the user interfaces of the application using ASP.NET, HTML Controls, XHTML, AJAX, Java Script and CSS, Win Forms using C#.
• Extensive development of ASP.NET UI pages using Master pages, AJAX, client, server and custom controls for manipulating and displaying data on the WebPages
• Implemented Messaging Application for Automatic Processing of email messages to the sales representatives automatically using WCF
• Developed web form and window forms for clients in C# using (WPF) Windows Presentation Foundation, XAML and XML
• Implemented OOP’s concepts in various utility classes which are used across whole project using ASP.NET 2.0, C#, ADO.NET.
• Handled Errors using error handling exceptions, tracing and debugging
• Implemented Client-side validation using JavaScript and AJAX.
• Created Secure logins, Roles and connection the database by implementing in Web.Config files
• Utilized ADO.NET technology extensively for data retrieving, querying, storage and manipulation.
• Participated in designing database and created complex stored procedures, triggers and views using SQL Server 2005.
• Involved in optimization of database queries, made extensive use of query execution plan, SQL server profiler, index tuning wizard tools in SQL server 2005
• Involved in writing complex queries, Stored Procedures and generating reports using SSRS.
• Prepared test plans and did unit testing of the programs developed
• Worked on documentation of the project and provided technical support for the clients

Environment: C#, ASP.Net, ADO.Net, AJAX, JavaScript, CSS, XHTML, HTML, XML, XAML, XSL, SSRS, WCF, WPF, WWF Win Forms, SQL Server 2005, Visual Studio 2008, Visual Source Safe.

Confidential, Blackstone, New York

Responsibilities:

• Involved in the analysis, design & development and testing of the entire system
• Migrated from VBA to VSTO using .Net framework 4.0.
• Technical & Management discussion with partner
• Design and Development for new requirement using C#.

Environment: VB.Net, ADO.NET, Visual Studio 2010,SQL Server 2008,.NET Framework 4.0, Agile Methodology, TFS.

Confidential, Blackstone, New York

Responsibilities:

• Involved in the analysis, design & development and testing of the entire system
• Technical & Management discussion with partner
• Design and Development for new requirement using C#.