SUMMARY:

• A dynamic professional with 9+ years of rich experience IT Industry.
• Having 4+ years of experience as a Lead Developer, net Lead Mentor & Project lead activities in the various assignments.
• Experience in Health Care Domain, Banking services domain, Insurance & Utility Domains
• Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services.
• Experience in using to facilitate efficient data manipulation and data consistency as well as to support recursive CTEs, CTE, temp tables and effective DDL/DML Triggers the existing applications.
• Expertise in writing T - SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility
• Have a good Understanding on Insurance products like Accenture DuckCreek.
• Excellent understanding of OOP (Object Oriented Programming), ASP.NET, SQL Server and Web services (SOAP, WSDL, XPATH, XHTML, XSL and XSLT.) & RESTFUL Services, Web APIs, Microsoft Azure development.
• Having good experience on architecture design using Tiered architecture, design patterns (Factory pattern, Façade, DI & IoC, Structure Map & Automapper, Etc.)
• Involved in delivering technical design document using UML (Use cases, Class diagrams, Activity diagrams etc).
• Development mainly in Web APIs, C#, VB.net HTML5, CSS3, Ajax, JQuery, Angular, Json, JavaScript, Web Services, WCF.
• Having good knowledge on new technologies like WCF, Entity framework 4.0 & MLIF Frameworks, REST APIs.
• Having knowledge of SOA using WCF services (Security, transaction etc).
• Built complex reports using Crystal Reports, SQL Server Reporting Services (SSRS).
• Experience in designing and developing n-tier architectures implementations.
• Well acquainted with Software Development Life Cycle Concepts and Methodologies like Unit Testing, Integration Testing and Performance Testing.
• Experience in Unit testing and working in Test Driven Development (TDD).

CORE COMPETENCE:

.Net Technologies: Classic ASP, ASP.net (2.0, 3.5, 4.0), ADO.net, VB.net, C#, WCF Services, web services (WSDL, XML, SOAP), ANGULAR JS, MVC Implementation, RESTFUL Services, Cloud Computing, Microsoft windows Azure.

WEB Technology: CSS, CSS3, HTML, HTML5, JavaScript, JQuery, XML, XHTML. DHTML, VBScript, JSON. Angular

Database: Oracle 9i, Oracle 10g, SQL Server (2005, 2008, 2012), TSQL, PL/ SQL, IBM Data Studio (DB2).

Frameworks: .Net Framework (2.0, 3.5, 4.0, 4.5), Entity Framework, MLIF Frameworks, Bootstrap, Domain Layered Architecture, DI framework, MOQ Unite testing Frameworks.

Tools: Visual Studio(2005, 2008, 2010,2013, 2015), Visual Source Safe (VSS), Team Foundation Server (TFS 2013 & 2015), MLIF Framework Tools, Sub Versioning (SVN), Araxis Merger Tool, Autosys Tool, web performance & loading testing tools for Microsoft platforms, FxCop, Style Cop, Sonar CQ tool, RESHARPER, POSTMAN.

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS)

Messaging Servers: DAC (Data Access Components) messaging queue, MSMQ & Rabbit MQ frameworks.

Designing and Modeling: OOAD Using UML, Design Patterns (Singleton, Factory, MVC, Façade Pattern, Dependency Injection & Inversion of control, Auto mapper, Structure Map.

Reporting: Crystal Reports & Microsoft Rdlc report viewer, SSRS.

Service Interfaces: SOAP, WSDL, RESTFUL APIs

Version Control: VSS, TFS(2010,2012,2013 & 20151),SVN

Operating System: Windows 2008, windows 10

PROFESSIONAL EXPERIENCE:

Confidential

Technical .net Lead & Mentor

Responsibilities:

• Involved in Requirement gathering and also constructed the Business Requirement document for the REST APIs.
• Implementation on C#, .NET programming practices, Enterprise Application Design patterns, and programming web services /web APIs.
• Co-ordinate with Offshore team on Production support & Handle the ad-hoc deliverables for the client.
• Design Reviews - consult to teams on planned solutions before development
• Ad-hoc Support - provide assistance through pair programming and/or unstructured mentoring support
• Perform SME Code Reviews for all our Projects.
• Responsible for Refactoring Support - decrease technical debt and increase code quality.
• Provide Code Quality Support - communicate the importance of the overall code quality program
• Work with developers on improving their code as related to readability, code coverage, class complexity, industry practices.
• Design, develop and test HTML5, CSS3, Bootstrap, JavaScript, jQuery and React.JS that meets accessibility and web browser standards for website.
• Designed CSS templates for use in all pages on the website working with CSS Background, positioning, text, border, margin, padding, and table.
• Applied optimization techniques to reduce page size and load times to enhance user experience using sprites.
• Developed user interface by using the React JS, Flux for SPA development.
• Implemented react JS code to handle cross browser compatibility issues in Mozella, IE 7, 8, 9, Safari and FF.
• Used React-Router to turn application into Single Page Application
• Worked in using React JS components, Forms, Events, Keys, Router, Animations and Flux concept.
• Working on Web API and RESTFUL Service API using WCF 4.0 which return XML and JSON data using WCF attributes.
• Involved in Unit and integration testing using NUnit testing framework.
• Designing and Developing the responsive User interfaces using Razor views using HTML, JQuery, Ajax and CSS in the Application where the users try to interact with the applications
• Developing and maintaining systems and reports that track developer progress
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
• Prepared the complete data mapping and Report Definitions for the project which involved around 33 reports.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and

Tools: Used: TFS (2012, 2013, 2015) SQL Server 2012, Visual Studio 2013 & 2015, IIS Express, Microsoft Windows Azure.

Technology: ASP.net 4.0, C#, Web APIs & RESTFUL Services, CI/CD tool chain on TFS.

Web Technologies: CSS, CSS3, HTML, HTML5, JavaScript, JQuery, XML, XHTML. DHTML, JSON, Angular JS.

Version Control: TFS 2013 & 2015

Frameworks: - .net Framework4.0, 4.5.

Reporting: Microsoft Report Services, SSRS.

Confidential

.Net Lead Mentor

Responsibilities:

• Involved in Requirement gathering and also constructed the Business Requirement document for the REST APIs.
• Assisted as a Project lead mentor activities for the Billing Modernization project.
• Using Scrum as agile methodology and Test-driven development for software development process of a project.
• Working as .net Lead Mentor activities include providing solutions to the requirements and coordinating reviews with offshore for implementing these requirements.
• Worked in Code Quality team to analyze the issues reported by SONAR qube.
• Responsible for supporting the mentoring program which has been developed and designed to help developers to Learn .net Technologies on various Level Assignments.
• Implementation of .NET development technologies and best practices.
• Actively participates in the Sprint Planning & retrospective meetings to go over all the User stories/ tasks from Development Side.
• Implementation of Angular Js in Billing Portal Application.
• Involve in development via structured mentoring modules, coding exercises, classroom sessions, assessments and code reviews.
• Design Reviews - consult to teams on planned solutions before development
• Ad-hoc Support - provide assistance through pair programming and/or unstructured mentoring support.
• Perform SME Code Reviews for all Billing Modernization Projects.
• Responsible for Refactoring Support - decrease technical debt and increase code quality.
• Provide Code Quality Support - communicate the importance of the overall code quality program
• Work with developers on improving their code as related to readability, code coverage, class complexity, industry practices.
• Working on Web API and RESTFUL Service API using WCF 4.0 which return XML and JSON data using WCF attributes.
• Involved in Unit and integration testing using MOQ testing framework.
• Implementation of RabbitMq messaging for file processing Implementation.
• Designing and Developing the REST APIs, File processing for Processing Batch files &to external vendors.
• Implementation of File Management API to retrieve & upload the Files to Azure BLOB Storage.
• Implementation of the project on CI/CD & SaaS.
• Analyzed business problems and reviewed business processes.
• Prepared functional specifications and formulated design specifications.
• Evaluated system applications and managed change requests.
• Designed test scripts and created test scenarios.
• Documented analytical workflows and results from clients.
• Developing and maintaining systems and reports that track developer progress.
• Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
• Responsible for installation and Configuration of SQL Server 2005 and 2008 database and configuration of Report manager.
• Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008/2005.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems. Developed, deployed, and monitored SSIS Packages.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server. Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Created reports with Analysis Services Cube as the data source using SSRS.

Tools: Used: TFS (2012, 2013, 2015) SQL Server 2012, Visual Studio 2013 & 2015, IIS Express, Microsoft Windows Azure.

Technology: ASP.net 4.0, C#, Web APIs & RESTFUL Services, Rabbit MQ, MSMQ & PaaS Deployments.

Web Technologies: CSS, CSS3, HTML, HTML5, JavaScript, JQuery, XML, XHTML. DHTML, JSON, Angular JS.

Version Control: TFS 2013 & 2015

Frameworks: - .net Framework4.0, 4.5.

Reporting: Microsoft Report Services, SSRS.

Confidential

Responsibilities:

• Involved in Requirement gathering and also constructed the Business Requirement document for the web Applications.
• Using Scrum as Agile methodology and Test driven development for software development process of a project.
• Working as Sr C# .Net Developer. Activities include providing solutions to the requirements and coordinating with offshore for implementing these requirements.
• Integrated SAP BSP’s (Third Party services) through WCF RESTFUL services to get the information from SAP backend.
• Creating services to call the stored procedures.
• Created services to be consumed by two platforms (Web, Mobile(Android and IOS))
• Presenting demo’s for the features developed to the stakeholders and incorporating the feedbacks to the product.
• Managing ClearCase builds and TFS builds
• Development mainly in ASP.Net, C#, HTML, CSS, Ajax, JQuery, JavaScript, Web Services.
• Worked on SQL Server Database, Creating and modifying triggers, stored procedures
• Involved in the Configuration management & deploying the products on web & app Servers.
• Having good experience on architecture design using N-Tiered architecture & MVC Implementation.
• Using Update panel and Ajax controls of Ajax control toolkit on server controls to avoid page post back and page flickering.
• Implemented NLog for Integrating Logging mechanisms in both UI & Services Products.
• Have a good knowledge on SQL Server Reporting services (SSRS).
• Refactoring Support - decrease technical debt and increase code quality.
• Code Quality Support - communicate the importance of the overall code quality program

Tools: Used: TFS (2012, 2013) SQL Server 2008, Visual Studio 2012,2013, IIS 7.0, IIS7.5.

Technology: ASP.net, ASP.net 4.0, C#, WCF services (using SOAP, WSDL, and XML).

Web Technologies: CSS, CSS3, HTML, HTML5, JavaScript, JQuery, XML, XHTML. DHTML, JSON.

Version Control: TFS

Web Technologies: CSS, HTML, JavaScript, JQuery, XML, AJAX.

Frameworks: - .net Framework4.0, 4.5.

Reporting: Microsoft Report Services, SSRS.

Confidential

Lead Developer

Responsibilities:

• Involved in Requirement gathering and also constructed the Business Requirement document for the web Application.
• Involved as a Team Leader for a Team of 6 Associates & I am working here till date as a leading the team & working at client side taking the responsibility of all the deliverables for total 7 different applications
• Involved in Designing the Architecture for the web Applications & also constructed the High-level & Low Level Design Documents like SOA, MVC & n-tier Architecture Implementation.
• Implementation of Design Patterns like Factory, Singleton, Façade, etc.
• Involved in Designing the Product Profiles for Both UI & Services Products.
• Development mainly in ASP.Net, C#, HTML5, CSS3, Ajax, JQuery, JSON, JavaScript, Web Services.
• Involved in Designing the Security Role Based Application Entitlements.
• Involved in application and server monitoring.
• Having a Strong understanding of C#.NET and Object Oriented Programming Concepts.
• Have a good knowledge on DB2, Toad & SQL Server 2008.
• Expertise in Web Services and other technologies like SOAP, XPATH, XHTML, XSL and XSLT.
• Involved in the release management activities & having a knowledge on Microsoft ALM tools which is a successful build-measure-learn cycle that increases the value delivered to customers.
• Involved in preparing Test Cases & Defect tracker closure sheet.
• Experience in using DTS packages, Reporting Tools such as Microsoft Reporting Services.
• Worked on SQL Server Database, Creating and modifying triggers, stored procedures.
• Have a good experience in Migration projects from Classic ASP to ASP.net MVC applications.
• Worked on SQL Server Database, Creating and modifying triggers, stored procedures
• Having a good experience on Agile Methodologies using SCRUM.
• Involved in the Configuration management & deploying the products on web & app Servers.
• Worked as a Software Testing Engineer to perform Smoke testing and Regression testing on new & modified products.

Tools: Used: Team Foundation server (TFS), Microsoft ALM tools, SQL S Visual Studio 2010, IBM DB2 Data Studio & Araxes Merger Tool, Oracle PL/SQL, BizTalk, IIS 7.0, Autosys tool, Microsoft ALM tools.

Technology: ASP.net (4.0), VB.net, C#, WCF Services, web services (WSDL, XML, SOAP), MVC Implementation

Version Control: TFS, SVN.

Web Technologies: CSS, CSS3, HTML, HTML5, JavaScript, JQuery, XML, XHTML. DHTML, VBScript, JSON.

Frameworks: - .net Framework3.0, 4.0 and MLIF Frameworks, Entity Framework.

Reporting: Microsoft Report Services.