SUMMARY

• 10 years of ITexperience in Application Development using Microsoft .Net technologies.
• Worked in the role of a Senior Application Developer and Technical Lead.
• Expertise in Application development usingC#.Net, VB.Net, ASP.Netand 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 UsingMicrosoftSQL 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 phasesof projects with proven record through inception-to-completion. Involved inAnalysis, Estimation, Design, Development, Testing, Documentation, Deployment and Maintenance of applicationsin diversified IT domains like Banking and Financial Services, Healthcare, Telecom and Pharmaceutical.
• Extensive Experience in Healthcare industry as Facets Application Architect / Senior Developer.
• 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

• C#.NET
• VB.NET
• ASP.NET
• MVC
• XML
• XSLT
• HTML
• TSQL
• WCF
• VB Script
• AJAX
• HTML
• CSS
• LINQ
• Linux
• Angular JS and JQuery
• Microsoft Visual Studio 2013/2015/2010/2008/2005
• SQL Server Management Studio
• Nunit
• Hadoop
• MapReduce
• Hive
• Pig
• Sqoop
• YARN
• Java
• Oozie
• HBase
• Kafka
• NoSQL
• Spark
• Scala
• Eclipse
• Linux
• Banking and Financial Services
• Healthcare products on TrizettoFacets
• Pervasive
• Telecom- Confidential
• 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 (.NET/SSIS/SSRS/SSAS)

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.

Confidential, Phoenix, AZ

Technical Lead(.NET)

Responsibilities:

• Onsite-Offshore co-ordination.
• Interacting with business to gatherRequirements and converting them into clear design documentand 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 usingServiceNow.
• Working with Release Management team for co-ordinating the Production Rollout.
• Mentoring junior developers and assisting them in resolving technical problems.

Confidential

Responsibilities:

• 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, XMLWeb 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 Hivequeries 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 Sparkdataframes, 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.
• Developedentity group, file low activity from mailbox to mailbox or connect direct, SFTP Push
• Managed and mentored a team of 6 people - Planning, monitoring and tracking day to day project tasks for team.
• Worked from conceptualization-to-completion.
• Developed reusable architectural components apart from the application/web service development.
• Involved in Project cost and budget planning, monitoring and control. Financial tracking, billing and charge-outs in alignment with project forecasted amounts.
• Co-ordination with the geographically distributed, System/Application project teams for various workflows throughout the project lifecycle to ensure proper handoff and focussed on-time project execution.

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.

Confidential, Nashville, TN

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

Confidential, Phoenix, AZ

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.
• Worked in all phases: Analysis, Design, Development, Unit Test, Package preparation, Rollout and Warranty Support.
• The repositories are designed using generic access methods to centralize all of the core critical database operations.
• Work on all the phases of enhancement.
• Performed the testing of code after migration on Azure.
• Documented each UAT support and production launch activities.
• Monitor and support of the artifacts logged by client in each sprint planning meeting.
• Implementation and design of new web services, Web API, SQL procedures, DLLs on target cloud platforms.
• Implemented the hybrid cloud scenario POC using Windows Azure Pack

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

Confidential, Denver, CO

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 Confidential 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
• Work on all the phases of enhancement.
• Performed the successful implementation of new Inbound/outbound Interfaces.
• Maintained proper version control of each interfaces in PVCS.
• All the UI code, Database components are stored on central repository.

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

Confidential, Newyork, NY

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.Configfile 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.
• Worked in all phases: Analysis, Design, Development, Unit Test, Package preparation, Rollout and Warranty Support.
• The repositories are designed using generic access methods to centralize all of the core critical database operations.
• Work on all the phases of enhancement.
• Documented each UAT support and production launch activities.

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

Confidential, Ottawa, CA

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 definedFunctions, 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

Confidential, Indianapolis, IN

Software Developer

Responsibilities:

• Involved in development of web graphics and graphical (UI) Pages using the HTML, Master Pages & ASP.NET Controls
• Developed differentUser controlswhich 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