Resume

Sign in

Sql Server Customer Service

Location:
Madison, NJ, 07940
Posted:
March 20, 2018

Contact this candidate

Resume:

Name: PRATIBHA

Email: ac4vl1@r.postjobfree.com

Phone: 469-***-****

PROFESSIONAL SUMMARY:

.Net Developer with 6+ years of experience with Software Development Methodologies AGILE Scrum, TDD and Waterfall in all stages of SDLC and strong working experience in N-tier architecture, Architectural Patterns ASP.NET Web Forms\MVC and strong applicability of Design Patterns.

Experience in analysis, design, development of Web based and Client Server applications. Successfully executed and managed multiple web-based projects based on Microsoft technologies.

Expertise in application development with technologies such as .NET Framework 2.0/3.0/3.5/4.0/4.5/4.5.1/4.6, C#, ASP.NET, VB.NET, MVC, WEB API, ADO.NET, Win Forms, Web Forms.

Expertise in Creating User Controls, Support to Multilingual, Creating Deployment Setup, JavaScript, HTML, DHTML, CSS, XML, XSL, XSLT, AJAX, JQuery, AngularJS, Bootstrap, WSDL.

Expertise in Web Services, WCF, Restful Web API and ASP.NETMVC 4/5.

Design and Implement WCF services layer hosted on Windows Azure. This layer is the middle tier between SQL Azure and SharePoint online external content.

Good understanding of Serialization Techniques using Binary, SOAP and XML Serializes

Experience in working with Oracle and PL/SQL.

Thorough understanding of RDBMS concepts, Proficiency in using T-SQL, Stored procedures, Functions, Triggers, Views and Complex queries on MS SQL Server.

Experienced in Test Driven Development (TDD) and Behavior Driven Development (BDD).

Experience in creating ETL packages using SQL Server Integration Services (SSIS)

Experience in using the third-party controls like Telerik RAD ASP.NET, Kendo UI, DevExpress and MVC UI controls

Experience in Software Configuration Management (Daily Build, Release and Testing methodology) using tools like Team Foundation Server (TFS), Microsoft Visual Source Safe (VSS), Subversion, and GIT.

Experience with MS SQL database, SQL Integration Services, DBMS, stored procedure development, and transaction database design using SQL Server

Experience with Reporting Tools in writing and tuning with better design and much information in different layouts using SQL Server Reporting Services (SSRS), Crystal Reports.

Experienced in developing Web services using WSDL, UDDI and SOAP Protocol and .NET remoting.

Experienced in N-hibernate to communicate with Database and used String Query Builder, CRUD operations, Hand coding Mapping and Fluent hibernate mapping.

Experienced in Query Optimization and query tuning in SQL using SQL profiler.

Experienced in Version Control Systems such as Team Foundation Server 2010/2012/2013/2015 for active tracking of work progress and maintaining code repository and Experience in administering continuous integration(CI) in team city.

Experienced in writing factories and injecting them into controllers using DI and writing Custom Directives as an extension of view in AngularJS.

Experienced in utilizing the new integrated features of ASP.NET 4.5/3.5/3.0 versions like Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF).

Experience on OOPS Concepts, UML Design Patterns such as Singleton, Factory, Remoting

Expertise in implementation of optimized, secured WCF Service over SOAP or REST by using Service, Operation, Data, Fault and Message Contracts.

Expertise in implementing SOA architecture thru WCF services, which used to rapidly build service-oriented applications that communicate across the web and the enterprise with features Serialization, Versioning, Interoperability and hosting.

Extensively used LINQ (LINQ to Entities, LINQ to XML), ADO.NET, and ADO.NET Entity Framework in developing Data Access Layer.

Experience in Load Testing, Code review and implemented automated unit testing with NUnit, Visual Studio, Unit Tests and Test Driven Testing Tools.

Experience in working on Azure based cloud technologies

Worked on MVC, MVVM, Singleton, Factory, Facade Design patterns.

Good Interpersonal and Communication Skills with ability to handle multiple projects to meet deadlines.

Demonstrated technical ability and in depth knowledge of Software Development Process.

Ability to work independently with positive attitude and to carry out assignments under pressure and tight deadlines within parameters of instructions given and standard accepted practices.

EDUCATION

Masters in Computer Science, Bradley University, Peoria, IL, USA.

Bachelors in Computer Science, GITAM University, Visakhapatnam, INDIA

TECHNICAL SKILLS:

Programming Languages

C, C++, VB.Net, C#, T-SQL, PL/SQL.

Web Development Technologies & Tools

ASP, ASP.NET, Web Services, ASP.NET WEB API, MVC, SOAP, WCF, WPF, XML, XSL, XSLT, CSS3, Master Pages, JavaScript, VBScript, HTML5, DHTML, IIS, Photoshop, Dream Weaver 6.0,JQuery,AngularJS, Expression Web, Entity Framework, Unity, Hibernate, Linq, Bootstrap, AJAX

Client/Server Development tools

Visual Studio .Net, Win forms, Window Services, VB, MS Visio, Subversion, GIT HUB and TFS

Third Party Control

DevExpress, Kendo UI, Telerik Rad Controls for ASP.NET AJAX,

Design Patterns

Model-View-Controller (MVC5), MVVM, SOA, Agile Methodology, Facade Design Tool, Singleton, Micro Services

Databases

MS SQL Server 2005\2008\2012\2016, MS Access, Oracle 12 g, 11g.

Testing Technologies

NUnit, MOQ 4.X, Jasmine, Selenium, SOAP UI

Operating Systems

Windows 98, NT, 2000/XP/2003/2008/2012.

Middleware Technologies

Web Services (SOAP, WSDL).

Cloud Technology

Microsoft Azure

Methodologies

Agile and Test Driven Development Methods.

PROFESSIONAL EXPERIENCE:

Merck & Co, Madison, NJ Oct 2015 - Present

Sr.Net Developer

Merck Animal Health is a research-driven company that develops, manufactures and markets a broad range of veterinary medicines

And services Offers one of the industry’s most innovative portfolios, spanning products for the prevention, treatment and control of

Disease in all major farm and companion animal species

Role & Responsibilities:

Designed and developed web pages using C#, ASP.NET MVC 5, WCF, Web API, Entity Framework, HTML5, JavaScript, jQuery, AngularJS and SQL Server.

Created coding and deployed XML Web Services (WCF) using ASP.net and C#, used them to generate the proxy class files based on the web services and consumed in web application.

Developed and consumed enterprise level Web APIs and experienced in handling security features for both WCF and Web API Services.

Developed SQL Server Integration Services Packages (SSIS) to import data from the Flat files to Database.

Experienced in following guidelines for writing code and involved in Code review of other team members to ensure standards and practices are being followed.

Extensive experience in creating and using AngularJS controllers, directives, custom directives and performed client-side validations using Angular 2.

Used ng-bootstrap UI components in angular 2

Hands on experience in developing Single Page Applications (SPA) using AngularJS and responsive web designs (RWD) using Bootstrap technologies.

Designed and implemented the UI with extensive use of JavaScript, JQuery and Ajax.

Developed ASP.NET Web API services to return JSON and XML Format.

Developed Web API’s Consuming third party Web Services and REST, WPF, WCF Services.

Used Swagger for Running Web API’s over Global Enterprise Level at the Client Location.

Involved in design and development of back end DB using SQL Server

Involved in the creating and development of database, tables, complex stored procedures, triggers and Views.

Performed querying to database using LINQ to SQL and querying to XML files using LINQ to XML

The presentation layer was implemented in ASP.NET using Web forms, User Controls, Web Controls, HTML and Cascading Style Sheets.

Implementing WCF Services and better logging exception management support to help in the premature detection of new problems.

Used Cascading Style Sheets (CSS3) with HTML5 to attain uniformity of all web pages

Used Entity Framework Model as the Data Access Layer (Database First) and implemented data objects, Mapping and executed stored procedures

Written several unit test cases to verify correct working of classes and more code coverage. Used Moq and NUnit framework

Responsible for testing, fixing the bugs and troubleshooting the technical problems

Used Telerik Asp.net MVC Ajax UI Controls for UI layer

Designed the application as N-tier architecture with extensive use of Object Oriented programming techniques.

Used TFS as source control explorer and created work items which is used to track different kind of tasks associated with project.

Used Microsoft Visual Studio, Re-sharper and Test Driven Testing Tool for Integration and Unit Testing.

Used JQuery UI API for the animation and for retrieving data

Used technologies provided by the .NET framework including ASP.NET, ADO.NET, Web Services using SOAP and data manipulation using XML.

Created VSTS build definitions and Release definitions in support of Continuous Integration/Continuous Deployment (CI/CD) pipeline

Responsible for mapping data into Azure tables to publish monitoring data to check on board

Configure Azure cloud service for end point deployment

Also created Win forms and WPF applications that are required for the project internal testing purposes

Used Web APIs for interaction between SQL Server and flushing the data to front end using AngularJS.

WCF Services are secured using MLS (Message Level Security) via username token policy (WS-Security).

Worked extensively with Kendo UI Components like Grid, Cascade Dropdown List, Date Picker, Tab Strip, Tool Tip, Combo Box etc.

Used Agile practices and Test Driven Development (TDD) and Behavior Driven Development (BDD) techniques to provide reliable, working software early and often

Worked in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SQL Server Integration Services (SSIS)

Working SSRS reporting tool to generate Dashboard reports, drilldown reports and other simple to complex reports.

Environment: Microsoft Visual Studio 2015, C#.NET3.5/4.0, .Net Framwork3.5/4.0, SQL Server 2012/2014, CSS3, HTML5, XML,

XSL, XSLT, Microsoft Test, Team Foundation Server, SSIS, SSRS, Kendo UI, JQuery, JavaScript, AngularJS/Angular 2, LINQ,

NUnit 3.x, Moq 4.x, Telerik,TFS, REST/SOAP, ASP.Net MVC 5.0, WCF, WPF

CVS Health, Minneapolis, MN Dec 2014 - Sep 2015

.Net Developer

CVS Health (formerly CVS Caremark Corporation) is an American retailer and health care company. CVS Health operates over

7,800 CVS Pharmacy, Longs Drugs and Navarro Discount Pharmacies stores, a pharmacy benefit manager, mail order and specialty

Pharmacies, a retail-based health clinic subsidiary, Minute Clinic and an online pharmacy, CVS.com

Responsibilities:

Involved in all the phases of SDLC from Software Requirements Analysis Phase to Design, Development, Testing, Integration, Implementation and Maintenance.

Implementation of client side validations using JQuery and ASP.NET MVC 5 Validation implemented at Controller level.

Developed and Modified Web Forms using C# under .Net framework 4.0/4.5 depending upon the Clients Requirement.

Developed ASP.NET Web API services to return JSON and XML Format Data to Support Mobile Application.

Provide rich user interface design using HTML5 to get consistence look and feel in the application.

Build Data Sync job on Windows Azure Cloud Services to synchronize data from SQL databases to SQL Azure.

Developed Win Forms using C# under .Net framework 4.0/4.5 with Dev Express Tool.

Implemented service oriented component (SOA) Layer using C#.Net and WCF to decouple the UI with BL.

Extensive experience working with data providers and datasets connecting to an Oracle database using VB.NET and other Oracle packages, as well as other systems including SAP enterprise software.

Created WCF Services responsible for communicating and providing real time data from integrated server to Client Application.

Created Consistent Layout for across the views using Razor views Layout and partial views

Used JQuery to make changes to the Web application and also written new functionality to meet the Client Requirements.

Used WCF for inter communication between the applications using MS MQ for providing secure, reliable transport messaging queue.

Extensively used XML to transport data between the front end and middle tier.

Used Grid views, Combo boxes, and Validation controls extensively during development.

Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#, the middle tier contained all the business logic

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Created Custom Lookup Classes that would Map the data, enabling less database hits.

Developed Web.xml files for Web Deployment Project and made the Web Application Builds.

Worked extensively on Business Object Model (BOM) to publish the Vocabulary to BOM.

Written a large set of unit tests using Moq and NUnit to effectively test the business logic written

Building REST Full and SOAP based WCF services to abstract and centralize common functionality.

Worked extensively to create WPF Project by Converting existing Dev Express Win Forms Project to WPF and Prism Framework.

Worked in Agile Methodology (Scrum) to meet timelines with quality deliverables.

Worked on WPF Relative Source Binding, Multi Binding and Logical Tree, Visual Tree hierarchy.

Implemented SOA by building and consuming Web Services for easy sharing of data. Developed a new WCF service to get the information from the database and consumed new services to communicate with some third part services.

Developed the independent WCF (Windows Communication Foundation) services and defined Service Contracts for specific functionality in search module.

Implemented the WCF Data Contracts versioning by using Knowntypes and IExtensibleDataObject, Ordering and enforcing required data when contracts consumed by clients.

Experienced in creating Angular services and factories to interact with Web API

Experience in using third party tools like Telerik, DevExpress and kendo Controls

Used Entity Framework and LINQ for retrieval of data from the SQL Server Database using connected/disconnected architectures

Developed webpages using HTML5, Bootstrap and AngularJS

Used Microsoft Team foundation Server (TFS) and SVN for version Control.

Created complicated reports like parameter based reports, sub reports, well formatted reports, matrix reports, chart and tabular using SSRS reporting.

Used Microsoft Visual Studio, Re-sharper and Test Driven Testing Tool for Integration and Unit Testing.

Involved in application release and responsible for defect free migration in different environments

Interact with clients, Project managers and Business Analyst to resolve any issue in timely manner and keep everyone informed on the status of the project.

Environment: ASP.NET, C#, SQL Server 2008/2012, WCF, WPF, IIS 7.0, JQuery, Entity Framework, ASP.NET MVC 4/5, Web API,

JavaScript, AngularJS, XML, XSLT, REST/SOAP, Visual Studio 2008/2010/2012/2013, Telerik, Kendo UI, DevExpress, Team

Foundation Server (TFS), NUnit 3.x, Moq 4.x, IBM WEB Sphere ILOG, SSIS, SSRS.

CME Group, Chicago, IL Jan 2014 - Nov 2014

.Net Developer

CME Group Inc. is the world's leading and most diverse derivatives marketplace, handling 3 billion contracts worth approximately $1

Quadrillion annually (on average) The company provides a marketplace for buyers and sellers, bringing together individuals,

Companies and institutions that need to manage risk or that want to profit by accepting risk. CME Group is American Futures

Company and one of the largest options and futures exchanges

Responsibilities:

Developed new modules to an existing system using C#, VB.NET, ADO.NET, SQL SERVER 2008.

Extensively worked with Web Forms and Server (Web/HTML), Data Binding.

Created WCF Services responsible for communicating and providing real time data from integrated server to Client Application.

Developed application using Web Forms, Designed the web UI using JavaScript, CSS3, J-Query and Ajax controls.

Implemented Windows Authentication in WCF to consume the Service as application is used in intranet

Designed few WPF Forms, Custom Controls and User Controls for UI and Dynamic Web Parts for personalized content which allows Change, Edit, Move the content on pages as per users' own choice

Worked on Multithreading techniques for creating high performance applications.

Used web forms using Infragistics web grid and data binding.

Created classes in C# for implementing business layer.

Created controllers and Razor views using ASP.NET MVC

Worked extensively with data bound controls like Data Grid and Data List.

Extensively used User interface controls, which use J-Query to validate client-side validation.

Java Scripts are developed as a client side scripting language.

Used XML for data interaction and developed XSLT templates.

Extensively used SQL Data provider to perform database operations in C#.

Developed and deployed Web components on IIS Server.

Strong skills in Debugging Techniques and Object Oriented Programming Concepts.

Developed Client Requested Reports using SSRS.

Worked on SQL by creating database Stored Procedures.

Modified the existing Queries, Triggers, Views and User defined functions.

Followed AGILE Software development methodology to develop the projects.

Worked Extensively with Query Optimization Techniques to Fetch Data with better Performance Tuning.

Used Subversion to version and store the source code.

Generated Various Reports Based on Clients Requirement.

Supported Operations team during the deployment and troubleshooting the production issues during deployment and on regular basis.

Environment: C#, VB.NET, ADO.Net, ASP, ASP.Net, SQL Server 2008, Web forms, AJAX, CSS, SSRS, XML, XSL, XSLT, JavaScript, HTML, WCF, IIS 6.0, Razor views, Subversion.

Cybage, Hyderabad, India Jan 2011 – May 2013

.Net Developer

Customer Service Delivery (CSD)

Customer Service Delivery (CSD) is a web based Customer Relationship Management based (CRM) project. The main purpose of

CSD Application is to arrange meetings between clients and prospects. The application consists various modules such as dashboards,

target list module, sales order module, campaign, meeting module. Also, sales order will be created for each client for a set of

meetings

Responsibilities:

Developed new modules to an existing system using C#, VB.NET, ADO.NET, SQL SERVER 2008.

Extensively worked with Web Forms and Server (Web/HTML), Data Binding.

Created WCF Services responsible for communicating and providing real time data from integrated server to Client Application.

Implemented Windows Authentication in WCF to consume the Service as application is used in intranet

Designed few WPF Forms, Custom Controls and User Controls for UI and Dynamic Web Parts for personalized content which allows Change, Edit, Move the content on pages as per users' own choice

Involved working on database scripts, Stored Procedures, Views, Indexes and Functions in SQL server and used ADO.NET for communication between the web services and Databases. Developed ASP pages to communicate with COM+ components as middle tier and MS SQL Server as database tier.

Database design, preparing entity relations diagrams, UML case diagrams using Visio tool.

Involved in creating the modules for Card Expenses Allocation, Maintaining of Account Codes, and Department Codes using Windows forms.

Implemented the Middle tier and Business logic using VB.NET, ODP.NET.

Created Custom Controls using ASP.NET.

Worked on Multithreading techniques for creating high performance applications.

Used web forms using Infragistics web grid and data binding.

Created classes in C# for implementing business layer.

Worked extensively with data bound controls like Data Grid and Data List.

Java Scripts are developed as a client side scripting language.

Used XML for data interaction and developed XSLT templates.

Extensively used SQL Data provider to perform database operations in C#.

Developed and deployed Web components on IIS Server.

Strong skills in Debugging Techniques and Object Oriented Programming Concepts.

Developed Client Requested Reports using SSRS.

Worked on SQL by creating database Stored Procedures.

Modified the existing Queries, Triggers, Views and User defined functions.

Used Subversion to version and store the source code.

Environment: C#, VB.NET, ADO.Net, ASP, ASP.Net, SQL Server 2008, Web forms, AJAX, CSS, SSRS, XML, XSL, XSLT,

JavaScript, HTML, WCF, IIS 6.0, Subversion.



Contact this candidate