SUMMARY:

• 10 years of IT experience in Application Development using Microsoft .Net technologies.
• Worked in the role of a Senior Application Developer and Technical Lead.
• Expertise in Application development using C#.Net, VB.Net, ASP.Net and Azure
• Experience in MVC, Entity Framework, LINQ, JQuery, HTML, CSS, XML, VBScript, and AJAX
• Extensively worked on SOA - Developed Web services, WCF services and MQ Services using C#.Net, WCF, XSLT.
• Experienced in building MVC pattern based Restful web services using ASP.Net MVC, MVC frameworks and exposure to client-side frameworks like AngularJS 2.0 and React.Js.
• Experience in Windows Applications, Web Applications and Web Services.
• Strong knowledge on .Net Environment, infrastructure, Architecture, Applications and Tools.
• Proficient in writing SQL Queries, Stored Procedures, Views, Functions, and Triggers Using Microsoft SQL Server
• Experience in SQL Server DTS and SSIS (Integration Service) package design, SSRS (Reporting Services) design and deployment.
• Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Worked on all SDLC phases of projects with proven record through inception-to-completion. Involved in Analysis, Estimation, Design, Development, Testing, Documentation, Deployment and Maintenance of applications in diversified IT domains like Banking and Financial Services, Healthcare, Telecom and Pharmaceutical.
• Extensive Experience in Healthcare industry as Facets Application Architect / Senior Developer .
• Designed and developed various Inbound/outbound Interfaces and Extensions in Facets, Pervasive.
• Experience in interacting with stakeholders, understanding High Level Business Requirement, analysing and preparing Project Documentations. Working with collaboratively with cross-functional global teams to attain project goals.
• Experience in Hadoop Architecture and various components such as HDFS, Resource Manager, Node Manager, Containers, Name Node, Data Node, Standby Name node, and Map Reduce concepts.
• Experience in NoSQL databases like HBase, Cassandra.
• Experience in analyzing data using HiveQL, PIG Latin, Python and Map Reduce programs in Java.
• Experience in Release Management, Change Management, Configuration management tools (Version Controllers) like SVN, TFS, VSS etc.
• Well versed with Agile, Waterfall Development Process.

TECHNICAL SKILLS:

Programming Languages and Tools: C#.NET, VB.NET, ASP.NET, MVC, XML, XSLT, HTML, TSQL,WCF,VB Script, AJAX, HTML, CSS, LINQ, Linux, Angular JS and JQueryMicrosoft Visual Studio 2013/2015/2010/2008/2005, SQL Server Management Studio, NunitBusiness Domain: Hadoop, MapReduce, Hive, Pig, Sqoop, YARN, Java, Oozie, HBase, Kafka, NoSQL, Spark, Scala, Eclipse, Linux

Software Tools: Banking and Financial ServicesHealthcare products on Trizetto Facets, Pervasive

Process Areas: Change Management, Cost Management, Risk Management, Conflict resolution, Gap analysis

Documentation and Data analysis: MS Office Suite, MS Visio, SharePoint (2003/2007)

Modelling: UML, MS Visio

Project Management: Clarity (PMO - SDLC Support Tool)

Incident Tracking: Service-Now

Version control: SVN, TFS and VSS Tidal, Toad, SFT, MFT and Control-M

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Tech Lead

Responsibilities:

• Involved in gathering system specification requirements for the project.
• Created complex T-SQL queries, stored procedures, indexes, functions and, views to support efficient data storage and manipulation
• Created several views, stored procedures, and UDF's which are used by the front-end development team.
• Managed ETL strategies to extract, clean, and deliver data to OLAP environments; ensuring accuracy, consistency, and integrity of the data.
• Created and deployed SSIS packages for data cleansing utilizing various transformations such as fuzzy lookup, fuzzy grouping, aggregate, and derived column transformations.
• Designed and developed SSIS Package templates to ensure similar development practices are followed by all SSIS developers for logging, configurations, and error handling.
• Developed tabular reports, drilldown, drill through, sub reports, charts etc.
• Developed complex reports such as drill down, drill through, sub-reports, parameterized reports and cross tab with multiple breaks in SSRS .
• Designed Interactive Dashboard using Power BI .
• Able to design, build, maintain & deploy complex reports in Tableau.
• Expertise in Tableau Data Visualization including effective communication, appropriate chart types, and best practices.
• Managed large reports which return large volumes of records; optimized their performance using techniques such as cascading parameters and filters.
• Worked on implementing custom Hive and Pig UDF's to transform large amounts of data.
• Implemented Oozie workflow engine to manage inter-dependent Hadoop jobs and to automate Hadoop jobs such as Hive, Sqoop and system-specific jobs.
• Utilized TFS for source control, change management of BI solutions, and bug tracking.
• Extracted, loaded, and analyzed data to and from SQL database with Python.
• Development of n- Tier application using ASP.NET MVC 5 (Model-View Controller) and Web API.
• Created the Controllers and Controller Actions, Action Results, Views, View Models, Routing using ASP.NET MVC.

Environment: and Tools: .NET Framework 4.5, ASP.NET MVC5, C#.Net, SQL Server, SSIS, SSRS, SSDT, TFS, Linux, Java, Map Reduce, HDFS, Hive, Hbase, Pig, Sqoop, Power BI, Python and Cloudera manager.

Technical Lead.NET

Responsibilities:

• Onsite-Offshore co-ordination.
• Interacting with business to gather Requirements and converting them into clear design document and code deliverables.
• Meeting with client to provide project status update.
• Taking regular Status update from team members on projects and providing consolidated status update to client.
• Involved in Production Support ( L2 & L3 ) activities using ServiceNow .
• Working with Release Management team for co-ordinating the Production Rollout .
• Mentoring junior developers and assisting them in resolving technical problems.
• To understand and analyse client requirements and create Design documents for development.
• Worked with business users in finding the issues related to data. Performance improvement initiatives.
• Co-ordinate with business and offshore/onshore team for the project development activities.
• Developed system services SOA application platform for use by all applications utilizing WCF services and SOAP, XML Web Services and ASP.Net, C# provider model .
• Designed ASP.Net Web/Windows Forms, C#, User Interface with HTML and Cascading Style Sheets (CSS) Designed page and AJAX and JQuery.
• Utilized modular structure within the Angular JS application in which different functionalities within the application were divided into different module.
• Creating custom, general use modules and components which extend the elements and modules of core Angular 2.
• Developed single page responsive Web UI using HTML5, Bootstrap, CSS, jQuery.
• Used patterns - Singleton, MVC4, MVVM, Abstract factory.
• Handled UI with Angular JS (MVC framework) to control the page layout.
• Application based on three tier architecture, and LINQ is used to query the generic collection objects.
• Managing file transfer from to MFT using ftp/sftp/ftps/https/Connect Direct protocols.
• Creation of user with Seeburger BIS File exchange IDM.
• Execution of automated jobs using Unix Shell Scripts.
• Created Hive queries and tables that helped line of business identify trends by applying strategies on historical data before promoting them to production.
• Experienced in loading and transforming of large sets of structured, semi structured and unstructured data.
• Performed transformations cleaning and filtering on imported data using Hive .
• Involved in converting Hive/SQL queries into Spark transformations using Spark data frames, Scala and Python .
• Performed data analysis with Cassandra using Hive External tables.
• Experienced in using Kafka for streaming of data.
• Knowledge of best practices and experience optimizing Tableau for performance.
• Experience performing basic administration tasks in Tableau Server for a production environment.
• Experience reverse engineering and revising Tableau Workbooks created by other developers.
• Developed PIG Latin scripts to extract the data from the web server output files and to load into HDFS.
• Scheduled Oozie workflow engine to run multiple Hive and Pig jobs, which independently run on data availability.

Environment: and Tools: .NET Framework 4.0, ASP.NET MVC4, C#.Net, SQL Server, SSIS, SSRS, ASMX Web Services, WCF, XSLT, XML, SOAP, Clarity- Management Tool, Quality Centre, MS Office Suite, SharePoint 2007, SVN, Hadoop, HDFS, Hive, Spark, Cloudera, Yarn, Shell Scripting, Impala, Kafka, Scala, Pig, Cassandra, Python and Oozie.

Technical Lead SQL

Responsibilities:

• Play a key role in the end to end Development of Projects covering all phases of Software Development Life Cycle including Requirement Analysis, Designing, Build/Construction, Unit/Assembly Testing and Deployment.
• Understand, analyze and see through the requirements and propose effective method of changes that are efficient, performance oriented and technologically possible.
• Developed Patient EMR (Electronic Medical Record) application using ASP.Net Web/Windows, C#, WCF, Generics, SQL Server.
• Used patterns, Singleton, MVC, MVVM.
• Prepared technical documentation such as system architecture, functional, design documents.
• Providing online support to the application running in production to prevent possible outages.
• Monitor and support of the issue / incidents ticket and provide the resolution.
• Enhancement of existing Data integration process in Pervasive.
• Designing of new process flow in Pervasive for the new LOBs.
• ETL implementation using SQL Server Integration Services ( SSIS ).
• Created Various Triggers, Dependency Properties, Attached properties, Commands in the application
• Facets System implementation, Claims and Benefits configuration set-up testing, Inbound/Outbound Interfaces.
• Implemented automated COB processing of Medicare claims into Facets
• Provided daily support, troubleshooting, monitoring of jobs running on SQL Server .

Environment: and Tools: Microsoft Visual Studio, ASP.Net, WCF, MVC, C#.Net, VB.Net, SQL Server, Facets, Pervassive

Technical Lead.NET

Responsibilities:

• To understand and analyze client requirements and create Design documents for development.
• As an Agile process had daily Interaction with client, understand requirements, plan, project activities, software requirements and timelines of project deliveries.
• Preparation of Deployment Package
• Migrated VB.NET windows application to Azure environments like E1, E2 and E3.
• Designed and developed VB.NET / ADO.Net repositories accessing the Azure hosted stored procedures/views.
• Developed applications with client server architecture in WPF, WCF, ASP.Net Web/Windows.
• Project Rollout and Data Migration.
• Post implementation support and defect fixing.

Environment: and tools: Visual Studio .NET, VB.Net, C#.Net, ASP.Net, TSQL, Azure, SVN and Microsoft SQL Server

Technical Lead .NET, SQL

Responsibilities:

• Analysing the system requirement and creating software requirement specification document.
• Involved in design and development of a User-friendly GUI Web and Windows Framework Applications using .Net 3.5, C#, WPF, WCF, ASP.Net and Visual Studio 2010.
• Used patterns - Singleton, MVC, MVVM
• Understood the technical business needs of the project through Business Requirement Document ( BRD ), Functional Specification Document ( BSD ) and Technical Specification Document ( TSD )
• Developed various Facets inbound and outbound custom interfaces for several clients.
• Interfaces designed on different modules like Member, Subscriber, Provider, Billing, Claim etc
• Supported 140 interfaces with their enhancements, break fix and other extension related activities.
• Created customer specific docs like DD, FD, AO11 and Mock up maps.
• Implemented automated COB processing of Medicare claims into Facets.
• Experience with Trizetto Facets System implementation, Claims and Benefits configuration set-up testing, Inbound/Outbound Interfaces and Extensions, Load and extraction programs involving HIPAA 837 and proprietary format files and Reports development.
• Backend change involved creation and modification of SSIS package, Stored Procedure, Views, Functions etc
• Script code change was involved with VB Script and Perl Script .
• All the Hosting Batch Architecture files were created in XML .
• UI code change was designed in VB.NET.
• Monitor and support of the issue / incidents ticket and provide the resolution.
• Scheduling Jobs of various applications.
• ETL implementation using SQL Server Integration Services ( SSIS ).
• Used PVCS, as source control (Configuration Management).
• Optimized Complex queries using Indexes and execution plan.
• Involved in performance tuning and optimization of stored procedures and queries

Environment: and tools: C#.NET, SQL Server, SSIS, VB Script, Perl Script, Facets, XML, HBA Architecture and Tidal

Consultant SQL

Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Designed the functional and technical documents, report templates and reporting standards.
• Involved in creating Named calculations and named queries.
• Developed web based application for using ASP.NET, VB.NET, ASP, VBScript, JavaScript, Visual Basic 6.0, COM, XML, and XSLT.
• Implemented input validation using the ASP.NET Input Validation Controls.
• Implemented Forms-based Authentication in ASP.NET to authenticate the users.
• Configured Web.Config file for the configuration of the entire Web Application.
• Developed ASP and VB pages to meet the business requirements and also involved in replace VB pages with redesigned VB.NET pages.
• Created stored procedures in SQL Server 2005, wrote the SQL statements using T-SQL, executed and tested stored procedures on SQL Server 2005.
• Developed Interfaces for data exchange using SQL Server, Visual Basic and XML.
• Developed Web UI Development using AJAX approaches in the product.
• Designed, Developed Business Logic, Data Access COM Components in Visual Basic and deploying in COM+ application.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Wrote stored procedures and SQL statements to access data from SQL Server 2005 Database.
• Involved in the design of the Database and Developed Stored Procedures using SQL for all the interaction with the database.

Environment: and tools: Visual Studio .NET, VB.Net, C#.Net, ASP.Net, TSQL, SQL Server, SSRS

Software Developer

Responsibilities:

• Developed web based application for using ASP.NET, VB.NET, Visual Basic 6.0
• Developed ASP and VB pages to meet the business requirements and also involved in replace VB pages with redesigned VB.NET pages.
• Created stored procedures in SQL Server 2005, wrote the SQL statements using T-SQL, executed and tested stored procedures on SQL Server 2005.
• Developed Interfaces for data exchange using SQL Server, Visual Basic and XML.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Wrote stored procedures and SQL statements to access data from SQL Server 2005 Database.
• Involved in the design of the Database and Developed Stored Procedures using SQL for all the interaction with the database.
• Handled some application build on MS Access using VBA
• Created User defined Functions, Stored Procedures and Triggers using DML and DDL.
• Used Data Transformation Services (DTS) to import and export data from one server to other server.
• Involved in performance tuning of T-SQL queries.

Environment: and tools: Visual Studio .NET, VB.Net, ASP.Net, VB 6.0, VBA, SQL Server, MS Access

Software Developer

Responsibilities:

• Involved in development of web graphics and graphical (UI) Pages using the HTML, Master Pages & ASP.NET Controls
• Developed different User controls which inputs the data and display the data for the web applications using ASP.NET.
• Coding and implementation of the web application includes new forms and fields.
• Designed Database, Developed Stored Procedures and Wrote triggers for sending Emails to clients after any kind of transaction has been made.
• Provided Production support
• Handled production issues and Resolved various critical issues during maintenance
• Responsible for handling L2and L3 production issues and to develop processes for handling issues in the future
• Experience in Classic ASP for developing the web application.
• Experience in migrating Classic ASP to ASP.NET

Environment: and tools: Classic ASP, ASP.NET, ADO.NET, VS 2003/2005, VSS, SQL Server