Sql Server .Net

Priya Premkumar

Experience Summary:

* ***** ** ********** ** .Net, SQL Server on Transportation, Education,Finance,Healthcare and Framework Development.

Involved in all phases of the SDLC ranging from Analysis, Design, Development, and Implementation of application using .Net Technologies on Windows platforms.

Technical strengths include Design patterns, .Net and SQL.

Expertise in Object Oriented Analysis and Design (OOAD) and Agile methodology.

Expertise in designing and developing web based enterprise applications using ASP.Net, MVC, DOM, and XML.

Experience in writing PL/SQL stored procedures.

Experience in Network based technologies like RESTful Services and WCF.

Expertise in SOA and Web Services using Visual Studio 2005, 2008, 2010, Business Objects

Have exposure in writing client side validations using Java Script.

Experience in developing applications using IDEs like Visual Studio 2008, 2010.

Strong experience in databases using SQL Server 2005, 2008, 2012, Oracle, Teradata.

Motivated team player with ability to work under minimal supervision, possessing excellent communicational, interpersonal, analytical and problem solving skills.

Certifications:

Certified in Business English Communications (BEC by Cambridge University).

Technical Skills:

Languages

C,C++ C#, VB.Net, XML, SQL, PL/SQL,PHP

Operating Systems

Windows 2000 Professional, Windows XP, Windows Vista

Web Technologies

ASP.Net, MVC,CSS, JavaScript, Web Service, XML, XSL, XSLT, BootStrap

.Net Skills

.Net Framework 4.5,.Net Framework 3.5, .Net Framework 3.0, XML Web Service, Windows Communication Foundation(WCF), Windows Presentation Foundation(WPF), Unit Testing

IDEs & Tools

Visual Studio, AHP, Fidler

Applications

Visual Studio 2005/2008/2010/2012

Reporting Tools

SSRS, SAP-Business Objects, Tableau(beginner knowledge)

Databases

SQL Server, Oracle, Teradata, Microsoft Access

Scripting Languages

Java Script,CSS, AJAX, AngularJs, HTML

Testing Tools/Type

Selenium IDE, TypeMock Unit Testing, MOQ Unit Testing

Other Tools

MATLAB

PROFESSIONAL EXPERIENCE:

Blue Cross Blue Shield of Texas

Role: Sr .Net Developer June’15-Dec'16

Performance Guarantee Monitoring and Tracking (PGMT)

PGMT is an internal web application that puts Medical Management Performance Guarantee at fingertips. The application allows you the capability to view details of PGs, results and settlement information. With this tool you are able to view PGs for accounts, approved future PGs, current tracking results, settlement reports, view exhibits. There are two levels of users-Admin and User.

Responsibilities:

Design, develop and implement PGMT application, which has a responsive UI, made using AngularJS and MVC Framework on the server side.

Design and developed database schema, triggers and stored procedures in MS SQL 2012 server to serve the PGMT application on the backend.

Coordinate with business analysts to determine a plan and prioritize functionalities/enhancements to be implemented accordingly.

Data Import activities using Report Viewer.

Evaluated database structures and data movement.

Created and maintained a web application in AngularJS to interface with HPSM.

Formulated existing processes and scripts.

Develop and document design, source base and architecture.

Run tests, Code Review and bug fixes

Run administrative tasks on Business Objects

Generate monthly reports from Teradata

Run Adhoc & custom reports for clients

Analyze data and modify queries to meet client targets

Environment: Visual Studio 2012, Net Framework 4.5, ASP.net, MVC 4, Entity Frameworks, PL/SQL, SQL Server2008R2, SQL 2012, Angular Js,Windows7, Report Viewer, Tortoise SVN, Teradata, Business Objects, Tableau, Microsoft Access, TDD, Agile Methodology.

Ally Bank & Chrysler

Role: .Net Developer/Support Nov’14 – June’15

Ally Bank: NetQuote

Ally Bank is a unit of Ally Financial, headquartered in Detroit, Michigan, which became a bank holding company in December 2008. The project features Real-time payment quotes for current Smartlease and Retail incentives.

Customers can lease a car for a period of time and at the end of the lease they can buy the car. The lease calculation application is made available to dealers by the Ally bank.

Chrysler: Credit Card Incentive

Chrysler Group is an American automobile manufacturer headquartered in Auburn Hills, Michigan. The project is processing payment for the Credit Card Incentive program. The program is supported by the First National Bank of Omaha. Dealers try to sign up their customers for credit cards and every week an incentive is paid depending on the type of program and the number of cards sold. There are mainly three programs: regular program, bonus program and manager program (managers get paid if certain number of their dealers signs up the customers for the credit card).

Responsibilities:

Upgrade project(NetQuote) from classic asp to ASP.Net MVC 4 framework.

Creating Custom UI for data access using AngularJS .

Using AngularJS controllers to maintain views.

Fetching data to the upgraded web application using entity framework on the server side.

Create and maintain ASP.net Web API service for the newly upgraded project

Coordinate with architects and business analysts to determine a migration plan and prioritize functionalities/enhancements to be implemented accordingly.

Design, develop and implement solutions to users’ needs and requirements.

Reverse Engineer and normalize the database schema using Visio.

Data Import activities.

Build Report and Datasets using SSRS

Evaluated database structures and data movement.

Formulated existing processes and scripts.

Develop and document design, source base and architecture.

Maintain and manage existing source code bases using SVN.

Run tests, Code Review and bug fixes

Upload the data and run SSIS packages to generate the report.

Generate a customer email report for the marketing team for email campaigns.

Automation of Email transfers from production database to Mail Chimp application for Chrysler Email Campaigns(window services).

Schedule jobs for database maintenance.

Environment: Visual Studio 2008,2012, Forticlient SSLVPN, Open VPN, GUI, DUO Mobile, Net Framework, C#, PL/SQL, MVC 4,Angular Js, SQL Server2008R2, Windows7, Tortoise Tortoise subversion, Microsoft Excel, SSRS,SSIS, MOQ Unit Testing, BootStrap, Sitefinity (beginner knowledge), Agile Methodology.

Transport Information and Management System Oct ‘13–Nov’14

Wal-Mart, Arkansas

Role: System Analyst

Wal-Mart Stores is the world’s #1 retail force that has yet to meet any immovable objects. Bigger than Europe's Carrefour, Metro AG, and Tesco combined, it's the world's #1 retailer with more than 2.1 million employees. Wal-Mart Stores, Inc. (Walmart), incorporated in October 1969, operates retail stores. The Company operates in three business segments: Walmart U.S., Walmart International and Sam’s Club.

Walmart Transport Management System(WTMS) was designed and developed to manage the fleet of trailers consumed by Wal-Mart in order to satisfy customer needs and demands. WTMS is a Retail multi-threaded Application designed .Net Framework and J2EE technologies and MS SQL database as backend.

Responsibilities:

Develop UI Screens using .Net and Infragistics controls .

Develop UI Screens/MockUps using Microsoft Visio.

Develop/enhance application in terms of Speed, Error Logging/tracking and Exception handling.

Implement Code Reuse according to Object oriented design and reuse Service Oriented Components for deployment.

Effectively prioritize development tasks. Anticipate and proactively identify problems.

Perform Pre-Production testing using HP MQC and verify fixes of defects as well as run regression tests after the fixes.

Responsible for gathering business requirements.

Logging and tracking defects in the application by utilizing HP MQC.

Environment: .Net Framework, C#, Code Collaborator, WCF, WPF, Restful Services, PL/SQL, Ajax, XML, XSLT, DB2 Database, WebAPI, HP MQC, WindowsXP, SubVersion, Agile Methodology, TDD, TFS.

Resource Management System Jul’10 - Aug'13

Metadata Technologies, India

Role: Software Developer

This desktop/winform project is a complete solution to maintain raw material and finished products stock for the Mechanical manufacturing company. All raw materials inventory will be maintained in stores, production details, materials consumed for a product will be maintained in production department and the Production Department keep track of the Outgoing material for a particular process. The winform component for each of these sections/modules contains interfaces developed on .Net platform as the front end and SQL server on the backend.

Responsibilities:

Involved in preparing Business Requirement Specification Documents.

Developed and maintained the desktop based portal along with a team of developers.

Reviewed development and testing activities to manage it effectively.

Developed a windows application using .Net framework and C # language with MS SQL backend. The application stores and retrieves information from the database based on certain criteria.

Made modifications to the existing design to suite user needs.

Involved in creating and writing PL/SQL procedures in the application.

Involved in post production support

Environment:

.Net Framework 3.5, .Net Winforms, SQL 2005, Windows XP, SQL Server.

Common Business Application Jul’08 – Jun’10

Focuz Infotech, India

Role: .Net Developer

The is a client server application which serves as a one point stop for many business purposes such as consumer survey details, customer information, communications pending/sent/received to various client parties including timely email notifications and very robust interface which is both effective and user friendly.

Responsibilities:

Responsible for understanding user requirements, designing, developing and testing the application.

Involved in the development and testing of Presentation Logic for ASP.NET pages.

Developed modules and projects of the application in ASP.NET along with writing C# classes.

Used Web services to communicate with the business layer objects.

Used ADO.NET to interact with SQL Server Database.

Used Asp.net validations Controls and regular expressions for client side validations.

Involved in creation of stored procedures for business applications in MS SQL Server 2008

Environment:

.Net 3.0, Oracle, XML, ADO.Net, Selenium IDE, JavaScript, CSS,Windows XP, UML, XML, HTML,TFS.

Education:

Bachelor of Technology in Computer Science. Mahatma Gandhi University-Kerala, India.

Conference and Publications:

Presented and published a paper (Survey on Retrieval of Relevant Images) in International Conference in Language Development and Computing Methods (ICLDCM).

Paper (Accessing Relevant Images: Fuzzy K-Means) accepted in International Conference on Network and Computer Science (ICNCS) at Kanyakumari, India and published in IEEE Explore.

Published a paper (A Better Approach to Attain Appropriate Images from a Collection of Images Using Fuzzy C-Means) in CIIT-International Journal of Digital Image Processing.

Other Activities:

Participated in International Workshop on Internet Services and Evolving Web Trends.

Participated in a workshop on MATLAB programming and Image Processing.

Participated on a 7 Day workshop on analytical and designing skills by WIPRO.

Contact this candidate