SUMMARY

• Over 8 years of IT experience with exceptional skills in analysis, design and development of highly scalable Multi - Tiered Web Applications, Distributed Applications and Web Services using Microsoft Technologies in Banking, Insurance and Healthcare domains.
• Extensive experience in developing n-tier applications, full life cycle development using Microsoft .Net technologies (C#, VB. NET, ASP.NET Frame work 3.0/3.5/4.0/4.5, Web Form, ADO.Net).
• Expert in Web Application design and development using ASP, HTML, AngularJS, JavaScript, JQuery, Ajax, HTML, XML and CSS.
• Strong experience with .Net technologies like Web API, Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF) and Language Integrated Query (LINQ).
• Extensive working experience indatabase design and development, for creating complex database queries, writing constraints, indexes, views, stored procedures and functions
• Worked on various architectures like MVC, SOA, Multi-Tier and REST architecture.
• Well versed with querying and manipulating data using Data Adapter, Data Reader and Dataset in ADO.NET.
• Experience in relational database design, data extraction, data transformation and loading from large and complex data sources using MS SQL Server 2014/2012/2008/2005.
• Created Entity classes, relationships between entity classes using LINQ (Language Integrated Query) to SQL, LINQ to objects and LINQ to XML to manage relational data as objects
• Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2005/2008/2012/2014 across various environments
• Considerable expertise in technical design documentations using UML modeling, OO design, analysis and design patterns (Singleton, Abstract Factory and Observer, MVC) to standardize the application architecture.
• Experience in Extracting, Transforming and Loading (ETL) data from MS Excel, flat file, Oracle to MS SQL Server by using SQL Server Integration Services (SSIS).
• Excellent at using APIs to retrieve data and load it into database after parsing and data cleaning
• Developed Data Access Layer (DAL), Business Logic layer (BLL) also in implementing Business Processes, Abstract factory as part of Service Oriented Architecture (SOA) using C#.
• Knowledge of high level design of SSIS packages using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Excellent knowledge on Exception Handling, Debugging and Tracing by which the whole application runtime can be seen and analyzed.
• Good knowledge in Delegates and Events, Generics, Serialization, Caching and Multithreading.
• Hands on experience in (SQL SERVER/Oracle) Database Design and Development, Writing Constraints, Indexes, Views, Stored Procedures, Cursors, Triggers, and User Defined Functions using T-SQL and PL/SQL.
• Experience in drawing Use Case, Sequence, and Class Diagrams using Microsoft Visio.
• Experienced in a fast paced Agile development environment including Extreme Programming, Test-Driven Development (TDD) and Scrum.

TECHNICAL SKILLS

Technologies/Frameworks: ASP .NET, MVC, LINQ, Entity, ADO.NET, Win Forms, Web forms, XML, Web API, WCF Services WPF, AJAX, IIS

Operating Systems: UNIX, Windows

Databases: MS SQL Server 2014/2012/2008/2005, Oracle 12c,11g/10g, MySQL

Tools/Utilities: SSIS, SSRS, Tableau, Power BI, Visual Studio

Languages: C#, AngularJS, T-SQL, HTML, CSS, PL/SQL, PHP, Shell scripting, JavaScript

Protocols: SOAP, SSL, FTP, TCP/IP, HTTP

PROFESSIONAL EXPERIENCE

Confidential, New York NY

.NET Developer

Responsibilities:

• Used AngularJS to perform custom client side validations on user controls and web forms
• Developed console application using C# to extract data from XML response obtained from API and store it in SQL Server Developed tabular reports, matrix reports, parameterized reports, linked reports and drill down reports
• Implemented C# programs to parse and import JSON data from third-party API into SQL Server database tables
• Utilized ADO.Net Entity framework extensively for data retrieving, querying, storage and manipulation using LINQ
• Created stored procedures used for generating report datasets
• Created data visualizations according to requirements using Power BI Desktop application
• Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#
• Developed the reusable framework for the application using the ASP.NET MVC Framework 3.0.
• Performed client side UI validations with Angular.JS, Bootstrap and JQuery.
• Used JavaScript to perform validations and catch the events on client’s browser.
• Involved in developing web Pages with rich UI, AJAX, and JQuery using ASP.NET.
• Worked with Web Services, Caching features, Configuring optimizations and securing the web application.
• Conducting detailed risk assessments by analyzing documents, statistics, reports and market trends.
• Developed module which deals with validating user, changing passwords and searching of information depending upon priority of user in site Using ASP.NET.
• Developed system services SOA application platform for use by all web applications utilizing Web API services.
• Used Data Contract as the standard mechanism in the WCF for serializing .NET object types into XML.
• Designed WCF Service Contract for validating the user input credit card type and its validation
• Developed Web Services and invoking them by using XML SOAP and WSDL for creating proxy classes.
• Effectively used JQuery a concise JavaScript Library for traversing HTML document, event handling and AJAX interactions.
• Used LINQ to SQL, LINQ to Objects for retrieving the data efficiently and Just in Time manner.
• Implemented Data Access Layer using Entity Framework and LINQ.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Created different chart reports helped in analyzing perform counters using SSRS 2014.
• Implemented Unit Testing using VSTS and also involved in Integration Testing and Regression Testing.
• Used Microsoft Team Foundation Server for the purpose of version Control and source code maintenance needs.

Environment: Visual Studio.NET 2015, C#, ASP.NET MVC, .NET FRAMEWORK 4.5, AJAX, JSON, Java script, HTML5, Angular JS, XML, CSS,SSRS 2014, TFS, jQuery, RAZOR, SQL Server 2012, T-SQL.

Confidential

BI Developer Analyst

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyse data from heterogeneous information sources (Flat files, Excel, Oracle, and SQL Server)
• Used CDC to feed data from an OLTP database to an operational data store (ODS) in order to keep the data in sync
• Worked as a team followingAgile/SCRUM methodology for iterative and incremental development.
• Worked as a developer in creating complex Stored Procedures, tables, and views and other SQL joins and statements for applications
• Worked in developing, implementing and extracting, transform and load (ETL) processes from raw file, flat file, Excel, and OLE DB sources.
• Involved in data transformation like lookup, fuzzy lookup, multicast, merge, join, derived column.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting includingSharePointintegration
• Interacting with client for requirements, discussing the feasibility of requirements, designing the layout of web pages, Architecture and participating in the development.
• Involved in designing, trading and documentation of application flows and developed functional diagrams using Visio, worked on presentation layer for developing GUI and developed various Web forms using ASP.Net.
• Designed large numbers of Windows Presentation Foundation (WPF) Forms, Custom Controls and User Controls using XAML language for UI and Dynamic Web Parts for personalized content which allows Change, Edit, Move the content on pages as per users' own choice.
• Used WPF built-in set of data controls to bind and manipulate data within applications.
• Developed ASP.Net Custom controls and User Controls.
• Involved in Developing Master Pages using Style Sheet and for providing uniformity among the pages using ASP.NET (3.5).
• Designed Model View controller using MVVM.
• Worked on Service Oriented Architecture (SOA) for developing application.
• Worked with ASP.NET Web Forms, Web Services, and State Management, Caching features, configuring optimizations and securing the web application.
• Developed Web Services and invoking them by using XML SOAP and WSDL tool for creating proxy classes.
• Used Web Services (SOAP, WSDL) for communicating with other application and components.
• Worked on AJAX frame work for interactive web application and used Enterprise Application Library functions to enhance the application performance.
• Used MicrosoftADO.NET to access data from database in a web application.
• Extensively used the LINQ feature in .NET 3.5 for querying collections and integrating with SQL.
• Used SQL server 2008 for writing Stored Procedures, Views and Triggers.
• Developed web pages with data bound controls like Data Grid, Data List and Data Repeater using the methods Data Binding and Data Templating.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Client and server side validations using JavaScript and Validation Controls and performing the tasks related Database issues.
• Experienced in Software Configuration Management, setting up company Version policies utilizing Team Foundation Server (TFS).

Environment: Microsoft SQL Server 2012, SSRS,, SSIS, Windows Server, Power BI, MS Access, Microsoft Visual C#, MS Excel, SharePoint, MS Visio, Microsoft Visual Studio 2013, Reports Builder, ASP, ASP.Net, ADO.Net, Microsoft IIS V.6, CSS, AJAX Controls, WCF, Web services, XML.

Confidential

SQL Server/BI Developer

Responsibilities:

• Designed and developed database solutions based on functional requirements
• Designed and developedSSIS(ETL) packages to Validate, Extract, Transform and Load data from OLTP system to the Data warehouse
• Developed Stored Procedures to de-identify sensitive patient information contained in tables in order to comply with HIPAA regulations
• Created Stored Procedures, User-Defined Functions, Views and T-SQL scripts for complex business logic
• Created procedures to encrypt sensitive personal health information (PHI) in production environment
• Created Stored Procedures which generated the necessary fact and dimension tables and functions that allowed performing necessary calculations depending upon the requirements
• Designed and implementedSSISpackages for data integration
• Involved in Design and Code Construction with OOPs Implementation in MVC Architecture.
• Involved in Maintenance / Enhancements of the application which includes developing the new reports.
• Leading the developer team for the new application development in Visual C#, ASP.NET 3.5 / Microsoft Enterprise Patterns and Practices Framework/ SQL Database, LINQ, WCF.
• Responsible for Database design, and creating of Stored Procedures, triggers to perform the Data retrieval from multiple tables using SQL Database.
• Works closely with Technical Lead to ensure understanding of the specifications and communicate updates on development milestones in project plan.
• Developed project using agile model.
• Developed web pages using Asp.Net, JavaScript for Client side Validation.
• Developed GUI using MS Visual Studio, ASP.NET Web Forms with Ajax controls.
• Deployed applications into test and production environments by using web server (IIS).
• Implemented Core Business logic and error handling
• Developed Reports Using SQL server Reporting services.
• Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, for Consistent access to SQL data source.
• Developed Web User Controls and Custom User Controls to minimize code redundancy.
• Extensively used ASP.NET GridView, Repeater, DetailsView, TreeView, DataList and Repeater controls for displaying the data in a clear format.
• Worked with ASP.NET Web Forms, State Management, Caching features, configuring optimizations and securing the web application.
• To persist and transfer data between pages Session State, View State, Cookies and Query Strings were used.
• All the commonly used functions are written in a class file and calling those functions using inheritance.

Environment: ASP.NET, C#, Linux, Winforms,ADO.NET, Visual Studio, Agile Model, MVC Architecture, TFS, Web Services, SOAP, JavaScript, Ajax, HTML, XML, IIS, SQL Server2008, SQL Server reporting Service, Windows

Confidential, Austin, TX

MS SQL Server/BI/ETL developer

Responsibilities:

• Had an experience with Angular JS for Client side data binding.
• Worked on Angular JS for single page application for some of the modules of the project.
• Used Bootstrap, AngularJS for developing modules on front end.
• Involved in software Development Life Cycle (SDLC) Process included Analysis, Design, Programming, Testing and Documentation
• Implemented service oriented component(SOA) Layer using C# and WCF to decouple the UI with Business layer
• Developed proof of concepts during application migration using MVC5, Entity framework
• Used WCF for communicating with services created for asynchronous document processing using Multithreading.
• Hands on experience working with the Bootstrap for developing modules on frontend.
• Designed Class diagrams and Sequence diagrams using UML. Prepared Technical design documentation for User Interface and Business layers using VISIO
• Developed core functionality with the .NET Framework using C#, ASP.NET, ADO.NET, N-Hibernate JavaScript and SQLServer2012
• Developed ASP.NET pages using AJAX controls tool kit (ex: Auto Complete, Accordion, Calendar Controls, Update Panels, etc.)
• Developed User Interface using HTML, Master Pages, ASP.NET server controls, JavaScript
• Involved in developing second and third level menu items for the site and was also involved in updating few menus based on periodic changes in site map
• Used Visual Studio 2010, .NET 4.0 for implementing UI designs using C#
• Created and consumed WCF Services using WSDL
• Used Validation Controls for user input validations for login page
• Used Data grid control to display the data
• Consumed Web Services from ASP.NET web applications.
• Created Test Methods and tested the application using NUNIT
• Have written many stored procedures, cursors and used them in WCF services
• Developed core functionality with the .NET Framework using VB.NET, ASP.NET, ADO.NET.
• Used Team Foundation Server(TFS) for managing the code
• Worked in an aggressive team environment where Agile SCRUM was followed for developing subsequent releases
• Periodically coordinated with Business Analysts, Design and Data teams and QA team

Environment: ASP.NET MVC5, C#, VB.Net, MSSQL, Oracle, Visual Studio.NET 2010, HTML,CSS, XML, XSL, XSLT, AJAX, Java Script, Angular JS, Bootstrap, TFS 2010, SQLServer2012, PL/SQL, IIS 5.0/6.0, XML Web Services, WCF,.NET Framework 4.0.

Confidential

SQL Server/BI Developer

Responsibilities:

• Worked with Project Manager and Business Analyst to understand business requirements and involved in planning, defining and designing code based on business requirements.
• Responsible for gathering business requirements from business users and designed prototypes as per requirements.
• Used various ASP.NET web server controls that included Site Map Path, Menu, Tree View, Grid View to develop web forms
• Created event driven Web Forms using ASP.NET and implemented form validation.
• Designed User Interface with CSS, and HTML. Used Master pages to give a consistent layout to all pages.
• JavaScript and AJAX was written for Client side validations and also used new validation controls in VS 2005.
• Created and deployed Web Services using C#, XML to login to the application.
• Developed Stored Procedures and Triggers in SQL Server 2005.
• Performed User Acceptance testing (UAT) and System Integrated testing (SIT) to handle deployments in test and production stages
• Implemented version controlling using Microsoft Team Foundation Server.

Environment: ASP.NET 2.0, C#. Net, ADO.NET, XML, Web services, HTML, JavaScript, IIS 6.0, CSS, Ajax Toolkit, TFS, Visual Studio 2005, SQL Server 2005