SUMMARY

• A results - driven, experienced, and analytical IT professional with strong background in diverse facets of .NET development, SQL Server, encompassing analysis, design, development and execution of business applications.
• .NET Development: Primary focus is developing and architecting scalable web and enterprise solutions for the Microsoft .Net platform including C#, VB.NET, MVC, WCF/Web API, LINQ, Silverlight, MVVM, HTML5, JQuery, AngularJS, Bootstrap, and VSS/TFS/Subversion.
• Business Intelligence: Microsoft certified professional in T-SQL with extensive experience in data analysis and Business Intelligence application with expertise in data modeling for data warehouse/ data mart development, SQL, data analysis for online transaction processing (OLTP) and data warehousing (OLAP) and business intelligence (BI) applications. Experience in BI Visualization tool like Power BI and Tableau. Experience in key components of SQL Server (SSIS, SSAS, and SSRS).
• Project Management: PMP certified Project management professional. Familiarity in Waterfall and Agile methodologies of Software Development. Has good experience in project management -project planning, project estimation and execution and team Building.

TECHNICAL SKILLS

Technologies: ASP.NET 2.0 / 3.5 / 4.0/4.5 , VB.NET, C#, AJAX, Web API, MVC, Silverlight

Programming Language: C#, VB, R, T-SQL, COBOL

Scripting Language: Java Script, JQuery, AngularJs

RDBMS: SQL Server 7.0/2000/2005/2008/104/2016 , Oracle

Development Tools: Visual Studio 2005/2008/2010 , Visual Studio, Power Builder, Seagate Crystal Reports 6.0/7.0Design Tools Visio soft Modeling tool

Configuration Tools: Visual Source Safe 6.0, Sub Version

ETL Tool: SSIS, Data Junction

Reporting Tools: SSRS, Tableau, Power Pivot, Power BI and Crystal Report

Project Management: MS-Project

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Architect / Lead Developer

Responsibilities:

• Business Intelligence: Designed and implemented KPI and metrics for the business. Designed, developed and administered automated processes to populate customer-specific data marts and operational data stores. Created partition tables to store large volume of historic data. Created multiple indexed tables/views/stored Procedures based on the business requirements. Worked on optimizing performance of the queries and procedures for the large volume of data. Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages. Designed and Developed SSAS Tabular Modelsto create PowerPivot reports. Automated multiple SSIS ETL using .Net components.Analyzed and worked on visualization of large volume of data. Wrote complex Queries/views and optimized performance of those queries.
• .Net Development: Designed, developed and implemented frond end and back end system for various data research and analysis modules using ASP.NET MVC 5.0, HTML 5, CSS3, and AngularJS and C #, Wrote Restful Web API as well as WCF to perform data related operations. Designed, developed and implemented interactive graphic Silverlight ASP.Net pages for sales funnel analysis using MVVM architecture. Generated automated notification module for sales deals that require attention.

Environment: ASP.NET 4.6/C#, MVC 5.0, LINQ, Silverlight, Telerik controls, AngularJS, Bootstrap, SQL Server 2014, SSIS, SSAS Tabular, Power Pivot, Power BI

Confidential, Alpharetta, GA

Architect / Lead Developer

Responsibilities:

• Designed, created and implemented several new product bundle modules and implemented business rules in the existing application using C# code behind and SQL Server stored procedure.
• Used Subversion for version control.
• Worked on multiple SSRS reports for reflecting changes in the business rule and new features.
• Wrote and modified numerous complex stored procedures and functions to reflect business rule changes in SQL Server database.
• Created and implemented SSIS package to transfer summary data to other application.

Environment: ASP.NET 3.5/4, C#, AJAX, SSRS, Subversion, SQL Server 2008

Confidential, Atlanta, GA

Architect / Lead Developer

Responsibilities:

• Developed multiple custom ASPX pages to host reports.
• Configured MOSS 2007 and designed SharePoint Interface using SharePoint designer.
• Handled data analysis and report generation using SSRS and Tableau.
• Designed and developed multi-tier web based CRM application including database design and n tier application architecture.
• Developed multiple complex AJAX-capable web form.
• Generate automatic Follow-up email system using windows service.
• Designed and developed multiple SOAP Web service and WCF services for UPS and SCS historical data research capability module.
• Generated dynamic PDF reports programmatically using SQL Reporting services.
• Generated numerous complex SSRS reports including writing complex expressions and calculations for SSRS reports for very large dataset.
• Extensively worked on DTS and SSIS Packages for transporting, filtering and cleaning the data.
• Created Legal documentation application to automate Word Mail merge from ASP.NET application and Converted in PDF. Used third party tool ASPOSE to generate PDF and Word.
• Created Version control system for the documents in the application.
• Created generic complex stored procedure for generating the list of documents to be generated for that customer.
• Reengineered, redesigned and migrated the old .net application built using .NET 1.1 Framework into new object oriented n-tier architecture using .Net 2.0 Framework.
• Designed and developed SQL server 2005 based database model for multiple application.
• Prepared architecture design specification documents.
• Worked as SharePoint Administrator. Provided Custom solution to multiple groups as per their requirement and performed various user training in Share point.

Environment: MOSS 2007, ASP.NET 4.0/C#, SQL Server 2008 R2, SSRS, Tableau, ASP.NET 2.0/3.5, WCF/XML Web Service, SQL Server 2005/2008, JQuery, AJAX, ASPOSE.

Confidential, Atlanta, GA

Architect / Lead Developer

Responsibilities:

• Was individually responsible for business requirement gathering and preparing requirement document using Use case.
• Designed the complete application architecture including Database schema, Data access layer, business layer and presentation layer.
• Worked extensively on Data access application block.
• Wrote the reusable class module to implement office automation and mail merge functionality.
• Generated MIS reports and compliance metrics report for the application.
• Migrated data from existing Share point database to Audit compliance tracking system.
• Migrated Share point documents to Audit compliance tracking system.
• Created a function to read the content from share point documents and store as word document.
• Wrote various stored procedure for the application.

Environment: SharePoint 2003, ASP.NET 2.0, C#, SSRS

Confidential

Tech Project Manager / Lead Developer

Responsibilities:

• Was individually responsible for the system architecture, managing the development team and technical leadership in addition to the development effort. Involved in defining coding standards. Handled project management activities like task allocation, and tracking.
• Designed the whole share point sites for framing rule and customization using FP 2003.Designed security policy for Share Point Portal. Designed and developed custom web parts in .NET to implement Reporting features. Created Web Part for uploading data from excel file to SharePoint custom lists web parts. Created Web Part that would provide a list of users along with their access rights on different web parts. This also gives the facility to set the access permission on Custom web parts .Extensively worked on SharePoint databases and created stored procedures for custom web parts.
• Designed/Redesigned conversion Map, lookup transformation and process for ETL Process. Involved in support and bug fixing of the conversion maps and processes. Data extraction, transformation and loading from ASCII flat files, Binary files, decimal and excel files to SQL Server. Involved in data analysis and verification against the business rules. Involved in writing standard T-SQL batch queries to perform data certification. Involved in modifying conversion map for version changes in the process. Involved in the performance tuning, optimizing and error handling of SQL stored procedure and data junction script.
• Designed and co-developed a common master/detail template form in ASP.NET using Data Grid in Unbound mode (using Custom Collections). Wrote Complex Stored Procedures to encapsulate business logic for various processes and design interface in ASP.NET. Developed generic cursors, which helps to create Insert, Update and Delete stored procedures for data manipulation on SQL. Performance tuning database indexes, stored procedures, user-defined functions, and views. Implemented role based security and customizable workflows based on a user's role.

Environment: SharePoint Portal Server 2003, Web Parts, Visual Studio .NET 2003, ASP.NET/VB.NET, JavaScript, IIS, SQL Server 2000.

Confidential

Systems executive

Responsibilities:

• Was involved in preparing the system requirement specifications, technical and architectural design of the Bilingual system.
• Involved in developing database schema. Wrote Complex Stored Procedures to encapsulate business logic for various processes and design interface in ASP .Net to develop Front and Thin clients. Developed generic DLL’s for data manipulation on SQL Server. Migrated legacy database systems (Access 2000) to SQL Server 2000 using Data Transformation Services (DTS) and T-SQL scripts. Migrated legacy database systems (Access 2000) to SQL Server 2000 using Data Transformation Services (DTS) and T-SQL scripts.
• Project Scheduling and Resource Planning.

Environment: Visual Basic 6.0, SQL Server 2000, ADO, ActiveX, MTS, True DB Grid, Seagate Crystal Reports 7.0, Win2k.

Confidential

Systems executive

Responsibilities:

• Implemented Multi-streaming, recovery/Restart and error handling in the core lending module of the project.
• Involved in analysis of existing codes and preparing the list of changes needs to be incorporated within the program for customization.
• Coding and rework of the existing code of business and data access objects.
• Made changes in all the layers (VB, COBOL, C and Oracle) for conversion into 24 hours banking.

Environment: UNIX, Windows 3.11 and NT, Oracle, C, COBOL and Visual Basic

Confidential

Systems executive

Responsibilities:

• Designed and developed web pages using ASP
• Created Active X component for file uploading.

Environment: WinNT 4.0, Visual InterDev, SQL Server, ASP, ADO, JavaScript, VBScript, IIS 4.0

Confidential

Sr. Programmer/Analyst

Responsibilities:

• Created GUI screens and DLL components for implementing server side data validation and transaction.
• Created database triggers and procedures.
• Created ActiveX DLL for implementing the Business Logic.