Resume

Sign in

Sql Server .Net

Location:
United States
Posted:
December 04, 2017

Contact this candidate

UMA SHANKAR

Sr .NET Developer

Summary:

** ***** ** ** ********** 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.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 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 inAnalysis, 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.

Skills Summary

Programming Languages and Tools

Business Domain

Software Tools

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 Trizetto Facets, Pervasive

Telecom-NORTEL

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

Education and Credentials

Master of Information Science, Birla Institute of Technology Mesra, Ranchi, India

Bachelor of Science in Botany, Ranchi University, India

Career Progression

Cuna Mutual Fund Group, Chicago, IL May’17 to date

Company: Syntel Inc

Sr. Tech Lead (.NET/SSIS/SSRS/SSAS)

CUNA Mutual Group is a mutual insurance company that provides financial services to cooperatives, credit unions, their members, and other customers worldwide. CUNA Mutual Group sells commercial and consumer insurance and protection products. it also provides retirement plan services to small businesses and credit union employees.

Tasks on day to day basis include:

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.

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.

Developed custom shell scripts for backing up metadata of Name node.

Experience in analysing data using hive queries, pig scripts and MapReduce programs.

Implemented Oozie workflow engine to manage inter-dependent Hadoop jobs and to automate Hadoop jobs such as Hive, Sqoop and system-specific jobs.

Exported the business required information to RDBMS using Sqoop to make the data available for BI team to generate reports based on data.

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.

Parsed various file formats including XML and JSON and loaded into SQL database with Python.

Environment and Tools: Microsoft Visual Studio, C#.Net, SQL Server, SSIS, SSRS, SSDT, TFS, Linux, Java, Map Reduce, HDFS, Hive, Hbase, Pig, Sqoop, Python and Cloudera manager.

American Express Global Business Travel, Phoenix, AZ Sep’15 to Apr’17

Company: Syntel Inc

Technical Lead(.NET)

American Express Global Business travel (AEGBT) is a travel program tailored to achieve specific goals. Which allow users to build and implement strategies that can help streamline operations, improve the business traveller experience, reduce risk and increase savings with wide-range of solutions for business travel and extensive travel data and fine-tuned methodologies.

Tasks on day to day basis include:

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.

Resolving the issues raised by stakeholders through ServiceNow.

Working with Release Management team for co-ordinating the Production Rollout.

Mentoring junior developers and assisting them in resolving technical problems.

Project: Service Fee, Hotel Voucher, DER Tool

Service fee and Hotel voucher application uses web service to pull the traveller data into the application. Traveller data is processed with different business rules and finally Invoices are sent to traveller. Invoices are issued according to regulation set by Government.DER application again uses web service to pull meetings & events data into the application and business validations are done with SSIS package and finally reports are published on using SSRS.

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, XML Web Services and ASP.Net, C# provider model.

Designed ASP.Net Web Forms, C#, User Interface with HTML and Cascading Style Sheets (CSS) Designed page and AJAX and JQuery.

Developed single page responsive Web UI using HTML5, Bootstrap, CSS, jQuery.

Used patterns – Singleton, MVC, 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.

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.

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.

Achievements:

Developed entity 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: Microsoft Visual Studio, 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, Scala, Pig, Cassandra, Python and Oozie.

Hospital Corporation of America, Nashville, TN Jan’15 – Aug’15

Company: Syntel Pvt Ltd, Pune, India

Technical Lead(SQL)

HCA has developed a number of best demonstrated business practices that leverage our collective experience, scale and expertise in a way that is unprecedented in the healthcare industry. Parallon Business Solutions provide revenue cycle and other business processes, workforce management solutions, supply chain services and the purchasing power of HealthTrust Purchasing Group, one of the nation’s leading group purchasing organizations.

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

American Express, Phoenix, AZ Nov’13 to Dec’14

Company: Syntel Pvt Ltd, Pune, India

Technical Lead(.NET)

BUSA (Business Unit Security Administration) is responsible for maintaining all types of IDs the user will need once they begin working at Amex. Working in department he may need access of CAS (Credit Authorization System) and CC90s (Credit Collections of the 90s) CSP (Customer Service Platform). BUSA will generate user ID and password of this system. Every year approximately 10,000 request of add, modify and delete of user ID and password is processed by BUSA. Ocelot is an application developed for BUSA (Business Unit Security Administration) group. Data Processing in Ocelot is fast. Forms are user friendly. Automation Process of Ocelot is a huge benefit for BUSA. Maintaining information is relatively easy than Louts Notes application.

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, Winforms.

Project Rollout and Data Migration.

Post implementation support and defect fixing.

Achievements:

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

Trizetto, Denver, CO Jun’11 to Oct’13

Company: Syntel Pvt Ltd, Pune, India

Technical Lead (.NET, SQL)

Facetsis Trizetto solution to assist payer organizations in staying ahead of trends in the employer benefits market. Facets encompass sophisticated technology that automates work processes, reduce costs, and simplifies the process of navigating through a health care delivery system. Base Facets modules include: security, accounting, application support, customer service, medical and hospital Claim processing, provider agreements, provider, and subscriber/member. The Facets system provides a comprehensive solution that can help us effectively manage our business, clinical and IT systems in today’s challenging environment.

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

Achievements:

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

Morgan Stanley, New York, NY Dec’09 to Jun’11

Company: Capgemini, Pune, India

Consultant(SQL)

Morgan Stanley is a global financial services provider headquartered in New York City, New York, United States. It serves a diversified group of corporations, governments, financial institutions, and individuals. Morgan Stanley also operates in 36 countries around the world, with over 600 offices and a workforce of over 60,000 through its subsidiaries and affiliates, provides its products and services to customers, including corporations, governments, financial institutions and individuals. The company operates in three business segments: Institutional Securities, Global Wealth Management Group, and Asset Management

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.

Achievements:

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

Nortel, Ottawa, CA Apr’07 to Dec’09

Company: CSC, Hyderabad, India

Software Developer

Nortel is a multinational telecommunications equipment manufacturer headquartered in Toronto, Canada. Nortel makes telecommunications network equipment including optical transmission equipment, wireless, voice, multimedia, and packet networking and associated services.

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

Eli Lilly, Indianapolis, IN Apr’06 to Oct’06

Company: TCS, Noida, India

Software Developer

Eli Lilly and Company is an American global pharmaceutical company with headquarters located in Indianapolis, Indiana, in the United States. Lilly was the first company to mass-produce penicillin, the Salk polio vaccine, and insulin, including one of the first pharmaceutical companies to produce human insulin using recombinant DNA. Lilly is also the world's largest manufacturer and distributor of psychiatric medications

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



Contact this candidate