OBJECTIVE

• Creative, dynamic, results - oriented software professional with detailed understanding of various processes, analysis, architecture, design and develop applications using with Microsoft Technologies.

SUMMARY

• Over 17 years of experience in IT industry, involving software design, analysis, development integration and testing at client and server side(SDLC) in various domains as Product based, Insurance, Commercial, Finance, mortgage, Health and service.
• Extensive experience in Requirement Analysis, Design, Development & Implementation, Testing and Deployment of complete SDLC in field of Microsoft Windows, Web, SharePoint, MVC, BI(SSIS,SSRS) and Datalake(Big-Data) Technologies.
• Certified by Microsoft as MCP and Microsoft Certified Application Developer (MCAD).
• Web Services, Confidential, WPF, Web API, Silverlight 4.0/3.0, LINQ, Entity Framework, IIS, C#, Dotnet SOAP, XML, DOM, HTML, Java Script, Visual Studio 1.1 - 4.7, AJAX, ADO.Net, Rest APIs, Micro Services, ASMX Web Services, WCF Services.
• Experience in Azure for system Deploying, Operating and Maintaining compute, network and storage in the Microsoft Azure environment using Microsoft Technologies
• Created JSON based Azure Resource Manager (ARM) templates, Used them for deployments. Good understanding of storage concepts. Experience in designing and implementing Azure Storage. Experience in dealing with Windows Azure IaaS - Virtual Networks, Virtual Machines, Cloud Services,
• Strong Development and Design experience in .Net Web forms & Win forms with C# and VB, User Controls, AJAX, Web Services. Remoting, WCF, WPF, WWF, Sliver Light, IIS, Multi-Threading, Web Parts, SharePoint, WSS, LINQ, SOA, CAB, SCSF, MVC, MVP, Telerik Controls, Dev Express and Infragistics Controls.
• Extensive experience of developing applications using XML which constitutes DOM/SAX, Schema, XSLT and XPath.
• Experience in design, customization, administration and implementation of Microsoft CRM 2011.
• Strong analytical and conceptual skills in database design, development, normalization, de-normalization, performance tuning, Data modeling and Schema modeling using SQL Server 2000 - 2016, Oracle that encompasses Stored Procedures, Functions, Views and Triggers and Datalake sqoop jobs and spark jobs development using Spark, Python scripts and MapR framework.
• Experience of utilizing SQL Server DTS and BI Services including SSIS and SSRS (2008-2012).
• Experienced in Application Lifecycle Methodologies (SDLC) and Processes used for software development such as Waterfall, Iterative, Prototype and Agile etc. models at various stages/layers like Requirement, Analysis, Planning, Designing, Coding, Testing and maintenance.
• Highly skilled in OOAD (Object Oriented Analysis and Design), UML diagrams such as Object Model, Use Case, Class and Sequence Diagrams using Visio, Design Patterns, SOA Architecture, N-tier Architecture, Design patterns like MVC, MVP, MVVM and Singleton MVC and Microsoft Enterprise Application Library (Application Blocks).
• Professional level skills in implementing and designing applications using advanced Microsoft Technologies with version controls TFS, VSS, Clear Case, SVN, CI-CD process using Octopus, Team City
• Experience in Bug tracking using Version One, Quality Center and Jira.
• Team player with good interpersonal, Collaboration skills and the ability to work in the team.
• Played .Net Solution Architect, Technical/Team Lead, Sr developer, designer roles and Onsite focal role for onsite-offshore model projects.
• Ability to learn new technologies and having complex problem-solving skills and recent additions are Datalake(Big-Data)
• Strong verbal and written skills in order to effectively communicate with multiple levels of management.

TECHNICAL SKILLS

Operating Systems: Windows 95-2000, 2003 Server, XP, Server 2008R2, Windows 7 and Windows 10.

Computer languages: C, C++, Coré Java, C#.NET, VB, VB.NET, Spark and Python

Web Technologies: ASP.NET, IE 6/7/8, Java Script, XML, HTML, Dev Express JQuery, CSS, JSON, Bootstra and Rest API’s

Cloud: Microsoft Azure

Windows Technologies: Dot Net WinForms, Dev Express tools

Web Server: IIS (Internet Information Server).

Database: SQL Server 7.0/2000/2005/2008/2012 , Oracle.

Framework: DotNET Framework, MapR, Microsoft CRM

Middleware Technologies: Web Services (SOAP, WSDL, UDDI), SOA, COM, DCOM, COM+, Remoting, MSMQ.

Configuration Tools: Visual Source Safe, MS-TFS, Rational Clear Case, GIT, Tortoise SVN, CI-CD process using Octopus and Team City.

Software Tools: Rational Clear Quest, MS-Visio, MS-Product, Crystal Report, Actuate Reports, Photoshop, MS-TFS (Team Foundation Server), Winscp. Putty, Drill

Methodologies: Waterfall, Iterative, Prototype and Agile.

Additional Skills: WCF, WPF, WWF, SharePoint 2003 and 2007 (MOSS), WSS, LINQ, SSIS, SSRS, Active Directory, Sliver Light, Multithreading, LINQ, ASP, ASP.Net AJAX, AJAX Control Tool kit, SQL Server Clustering, Encryption and Hashing, CAB, SCSF, MVC(2,3 and 4), Infragistics, Telerik, Dev Express and KingsWay Tools

PROFESSIONAL EXPERIENCE

Confidential, Fort Mill, SC

Data Services Lead Architect / Lead .Net developer

Responsibilities:

• As an Technical Lead I am responsible to understand business and analyze requirements, understand all source and destination systems and plan integration. Also need to understand existing development methodologies and reuse components and frameworks wherever is it possible. Responsibility to includes project related deliverables, requirement analysis, risk analysis, design and develop reusable frameworks, leveraging various emerging technologies/tools.
• Create use cases for each story am going to work on, define interfaces, analyze in-house libraries and third parties am going to use in my application. Design micro-service-based applications, design SQL Server, Oracle, MS Access DB objects, Schema’s. Design JSON, XML formats for communication and storage. Build Class, interface asynchronous communication channel and design and create application security. Create Restful API’s and integrate external services.
• Working closely with team members within and across the organization in developing solutions that improves the quality, efficiency, and performance. Implemented solutions using technologies like .Net, Java, Spark Python, Oracle, SQL Server and NoSQL databases.
• Interpret architecture and design, conduct code reviews, mentor, guide and monitor programmers, ensuring adherence to programming and documentation policies; develop, test, and release software. Update and maintain computer programs or software packages to handle specific jobs such as tracking inventory, storing or retrieving data, or controlling other equipment; and consult with managerial, engineering, and technical personnel to clarify program intent, identify problems, and suggest changes.
• Lead the scrum meetings as a delivery lead and update the team progress and any impediments. Assign work to team members, monitor progress, manage risks and update the overall progress to the leadership team.Work with Product Managers, BSA’s to get requirements and signoff.
• Expertise in Azure Infrastructure Management (Azure web role, Worker role, SQL Azure, Azure Storage).
• Involved in developing the Azure Solution and Services like PaaS and IaaS.
• Experienced in creation and configuring of Storage Accounts and also Configuration of blobs, tables etc.
• Deploying Web Apps and Creating Web-Jobs, Experience in configuring Cloud Platform (Azure SQL, Service Bus and Cloud Services).
• Developed Application in C# using entity Framework and LINQ.
• Involved in developing Complex queries, views and Store Procedures using SQL and T-SQL in relational databases such as Microsoft SQL server.
• Developed an N-Tier Application Involved in developing and Migrating AngularJS and MVC applications (CSHTML) in Web based and trigger based jobs.
• Experience most of the modern development methodologies such as Agile and CI/CD with Octopus and Team City. etc.
• Expertise with Version Control Systems like TFS-2015, VSTS and GIT.
• Involved in development of application on azure server by creating packages through Visual Studio, Power shell and Azure Portal.
• Involved in Integration test, Load test by various target environments (Integration, QA and Production).
• Ability to prioritize and multi-task while working as part of a team.

Environment: Oracle, Sql Server 2012-2016, Datalake, MapR, Spark, Python, Drill, Winscp, Putty, Oracle, Windows 7/10. CI/CD Pipeline, Cloud, SSIS, SSRS, Git, IIS, N-Unit, JSON, SQL Server 2014, Entity Framework, LINQ, TFS, Agile Methodology, Dot Net Framework Version 4.7, Visual Studio 2015, 2017, ASP.NET MVC, Web API(RESTFULL services ), AngularJS, CSS3, Bootstrap, HTML 5, Visual Studio 2017, Microsoft Azure 2.7 & 2.9, TFS, GIT, C#, XML, XSLT, HTML, Web services, WCF

Confidential, Charlotte, NC

Sr. Dotnet Database Lead Developer, Designer, Analyst and Architect.

Responsibilities:

• Analyze, estimate client requirements. Involved in creation/review of new functional requirements specification.
• As a senior resource my responsibility is to take all integrated and main workflow related tasks.
• Created workflow system using with Breadcrumbs and different styles of telerick controls.
• My participation in this project is in Workflow design development, Attributes, Node Details, final results Module Product Script Grouping, Audit Module and Application Configuration.
• Designing and develop various database objects like Tables, Stored Procedures, Indexes, Views etc.
• Creating Migration scripts to move old MAC Tool data to new servers for new MAC Tool.
• Performing Query optimization and performance tuning of long running queries.
• Support existing MAC Tool.
• Preparing Analysis, Test, Deployment and other documents and involved in Unit Testing, Integration Test and User Acceptance Test(UAT)
• Work with BSA’s to get requirement signoff.
• Move development work from environment to next environment to get SIT and UAT sign off.

Environment: Dot Net Framework Version 4.6, Visual Studio 2013, 2015, WPF, PRISM, MVVM, C#, XML, XSLT, HTML, SHTML, Web services, WCF, WPF, PRISM, Light Switch, Telerick, LINQ, SVN, SSIS, Sql Server 2008 R2 and Windows 7.

Confidential, Charlotte, NC

Database Analyst and Architect.

Responsibilities:

• Involved in Analysis, data modeling, creating Entities and mapping based on the business requirements.
• Designing the various database objects like Tables, Stored Procedures, Indexes, Views, and functions as per the requirement to processing the complex business logic to implement Delta process.
• Worked on loading of data from sources to Staging using SQL Server 2012 and SSIS through KingsWay. And provided object to BizTalk integration.
• Performing Query optimization and performance tuning of long running queries.
• Creating and Maintaining the AutoSys jobs for processing files for the integration process.
• Preparing Analysis, Test, Deployment and other documents and involved in Unit Testing, Integration Test and User Acceptance Test(UAT)
• Work with BSA’s to get requirement signoff.
• Move development work from environment to next environment to get SIT and UAT sign off.

Environment: Data Tools with SQL-Server 2012, SSIS, KingsWay, Microsoft CRM, Visual Studio 2012, Web Service, TFS and Windows 7

Confidential, Charlotte, NC

Lead Front End and Back End developer, designer.

Responsibilities:

• Analyze, estimate client requirements. Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Design, customize, administrate and implement given tasks for Special Loans portal and LMAI’s Application.
• Plan each iteration and tasks development based on priority along with managers.
• Work with LOB’s, BA’s, requirement signoff.
• Co-ordinate with team in documenting all existing MS Access special loans DB’s, analyze, create POC and present to the business.
• Design application, creating tables, views, stored procedures, functions for needed AIT tasks in sql server.
• Move development work from environment to next environment to get SIT and UAT sign off.
• Lead development activities for supporting applications to onboard users.
• Document postmortem report for each task where our team is responsible.
• Production support for Recast database.
• Develop/Architect new dotnet framework for Special Loans LMAI’s.
• Co-ordinate and participate in daily scrum meetings for status updates and address blocking issues and tasks.

Environment: Dot NET Framework Version 4.5, Visual Studio 2013, WPF, MVVM, C#, XML, XSLT, HTML,DHTML, Web Service, WCF, SSIS, SSRS, Ajax, LINQ, TFS, Sql Server, AS400, MS Access, Windows 7

Confidential, Charlotte, NC

Senior Analyst, Lead, developer, designer.

Responsibilities:

• Analyze, estimate client requirements. Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Design, customize, administrate and implement given tasks for Inventory Master Application.
• Plan each iteration and tasks development based on priority along with managers.
• Work with BSA’s, business users to get requirement signoff.
• Co-ordinate with team in creating tables, views, stored procedures, functions and designing layout in Winforms.
• Move development work from environment to next environment to get SIT and UAT sign off.
• Lead development activities for supporting applications to onboard users and train in Dev Express tools.
• Document postmortem report for each task where our team is responsible.
• Production support for Inventory Master and Volker and Mastiff Applications
• Develop/Architect winforms, WCF services which can be used across secure master group.
• Co-ordinate and participate in daily scrum meetings for status updates and address blocking issues and tasks.

Environment: Dot NET Framework Version 4.5, Visual Studio 2012, 2013, Winforms, Dev Express, C#, XML, XSLT, HTML,DHTML, LINQ, SVN, Oracle DB, Sybase DB, Aqua Studio, Windows 7

Confidential

Database Analyst, Lead .net developer, designer.

Responsibilities:

• Extracted data from various sources like SQL Server 2008 R2/2012, Oracle, .CSV, Excel, tab and Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Created Data-driven Packages in SSIS 2008 R2 as part of the automating the process for the Data Load Process.
• The packages created included a variety of transformations, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2008 R2 Business Intelligence Development Studio.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved in performing Audits and recovery operations of SSAS objects.
• Assess the risks and recommend/ install service packs or hot fixes when needed.
• Work with BSA’s and users to get requirement signoff.
• Co-ordinate with team in creating tables, views, stored procedures, functions and designing
• Move development work from environment to next environment to get SIT and UAT sign off.
• Develop/Architect custom web pages, WCF services which can be used across the organization.
• Using jQuery/JSON for UI pages like Members, Claims, fetch reports etc.
• Co-ordinate and participate in daily scrum meetings for status updates and address blocking issues and tasks.

Environment: BI(Business Intelligence) with SQL-Server 2008 R2, 2012, .NET Framework Version 4.0/ 4.5, Visual Studio 2010, 2012, MVC4, jQuery, C#, XML, XSLT, Java Script, CSS, HTML,DHTML, Web Service, WCF, SSIS, Ajax, LINQ, VSS, Windows 7

Confidential, Charlotte, NC

Database Analyst, Technical Lead, Sr. developer, designer.

Responsibilities:

• Analyze, estimate CRM and report tasks in story jam meetings
• Design, customize, administrate and implement complex CRM application.
• Plan each iteration and tasks development based on priority along with managers.
• Work with BSA’s to get requirement signoff.
• Co-ordinate with team in creating tables, views, stored procedures, functions and designing report layout in SSRS
• Move development work from environment to next environment to get SIT and UAT sign off.
• Create/Design required SSRS reports MS CRM entities, forms, workflows, plugins, ribbons and web resources.
• Develop/Architect framework to develop custom web pages to be integrated with CRM.
• Using jQuery/JSON for dynamic and interactive UI pages like Relationship, Opportunity, BU’s, Call reports etc.
• Oops, Ajax, Selectors, Chaining, date pickers etc. are very handy for us to do lot of scripting in customized pages.
• Even applying CSS classes for different fields dynamically helps us to improve look and feel of our pages
• We are doing validations using jQuery to reduce too much coding of JavaScript which our team using previously
• Lead development activities for supporting applications to onboard users, customers and opportunities into CRM.
• Co-ordinate and participate in daily scrum meetings for status updates and address blocking issues and tasks.
• Document postmortem report for each task where our team is responsible.

Environment: BI(Business Intelligence) with SQL-Server 2008, 2012, Microsoft CRM 2011, NET Framework Version 4.0/ 4.5, Visual Studio 2010, 2012, MVC4, jQuery, C#, XML, XSLT, Java Script, CSS, HTML,DHTML, Web Service, WCF, SSRS, Ajax, IIS 7.0, LINQ, TFS, Windows 7