Sql Server Data

Name: Poojitha Reddy

Contact: 443-***-****

Email:. *******.*************@*****.***

Contact Employer:

Name: Vinod

Contact: 203-***-**** ext 214

Email: *****@********.***

Summary:

Around 8 years of IT experience in all phases of SoftwareDevelopment Life Cycle(SDLC) such as Planning, Analysis, Design, Implementation, Testing and Maintenance of Web Based, Client-Server and N-tier Architectures in domains like Finance,HealthCare, Logistics, IT.

Extensive experience of designing and developing software applications with the C#(4.0/3.5/3.0/2.0)/VB.NET(9,8,7),.NET Framework (3.5/4.0/4.5), ASP.NET(4.0/3.5/3.0/2.0), MVC,ADO .NET, Entity Framework, AJAX, LINQ, CSS, Web Services, SOAP.

Hands on experience in design using Object Oriented Programming Principles like Encapsulation, Inheritance, Polymorphism and Abstraction.

Responsible for designing Presentation Layer (web pages) using the concepts such as Master Pages, User Controls, Custom Controls, Themes, Skins, HTML, XML, CSS, Java Script, JQuery, AngularJS.

Experience in using Language-Integrated Query (LINQ) query and retrieve data from different data sources (LINQ to Objects, LINQ to XML, and LINQ to SQL).

Experience in using ASP.NET AJAX /JQueryAJAX framework for quickly creating efficient and interactive Web applications that work across all popular browsers.

Experienced with Microsoft Application building blocks for .Net projects (Data Access, Exception Handling, Caching and Configuration Management).

Experience on Photoshop, XML/JSON, Team Foundation Server

Worked extensively with ADO .NET objects such as Data Adapter, Dataset, and Data Reader and ORM concepts like Entity Framework and LINQ to SQLto interact with databases like SQL Server 2008/2005/2000 & Oracle 10g/9i,FACETS.

Experience with both C#, VB.NET as the server side programming languages

Experience in database related work primarily creating complex stored procedure, Views, Triggers, Functions using PL/SQL, T-SQL.

Experienced in Configuration Management, setting up company Version policies, build schedule using Team Foundation Server 2010/2008, Visual Source Safe (VSS), SVN.

Extensive working experience in unit testing framework – NUNIT, MS Unit Tests.

TECHNICAL SKILLS

Programming Languages

C++, C# .NET(3.5/4.0/4.5),VB .NET(10.0/9.0/8.0), HTML, T-SQL, PL/SQL

Web Technologies

ASP.NET 4.0/3.5/3.0/2.0, ASP.NET, Share point2012, MVC 4.0/3.0, ASP.NET, Ajax 3.0/2.0, Javascript, Jquery,VB Script

Xml Technologies

XML, XDOCUMENT, XSLT, XPATH, XSL

UI Technologies

WinForms,WPF

IDE Tools

Visual Studio 2013/2012/2010/2008/2005, SQL Server Management Studio, SQL Server BI studio

.Net Frameworks

.Net Framework 4.0/3.5/3.0/2.0

Databases

MS SQL SERVER 2014/2012/2008/2005/2000, MSAccess 2010/2007/2003, Oracle 11g/10g/9i/8i

Reporting Tools

SQL Server Reporting Services (SSRS 2008/2005), Crystal Reports (2010/9/8.5/8)

ETL Tools

Modeling Tools

SQL Server Integration Services (SSIS 2012/2008/2005)

UML,MS Visio 2010/2007

Version Control Tools

Visual SourceSafe(2005), SubVersion(SVN), Team Foundation Server(2008)

Middleware

WCF, ADO.NET 4.0/3.5/3.0/2.0, Web Services, Enterprise Library 5.0/4.0/3.1

Servers

Windows Server 2008/2003/NT, Microsoft IIS(7.0/6.0/5.0/4.0)

Other Utilities

Ildasm, Nant, Gacutil, Sn.exe, Ant, FxCop, Resharper(5.1.3), StyleCop.

PROFESSIONAL EXPERIENCE

Client: CareSource, DAYTON,OH

Domain: Health care

Title: Sr. .Net Developer

Duration: March 2015 – Till Date.

Description: CareSource has been meeting the needs of health care consumers for more than 25 years and it has a mission of making difference in the lives of underserved people by improving their health care is one they take to heart. It permeates the work we do each day, and it is a cornerstone that supports our corporate culture.

The main goal of SAP-FSCD project is to get member data from FACETS in 4 different files and feed into SAP system from where data is used for billing and invoicing.

Responsibilities:

Involved in gathering requirements for Financial System Collections and Disbursement project (FSCD), worked closely with business users.

Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.

Created Database Objects like Tables, Stored Procedures, Views and Triggers using FACETS 5.01 in SQL server 2014.

Created complex queries involving CTE’s, Sub-queries and Joins.

Implemented OOD patterns like Singleton and Dependency Injection

Created Indexes for fast retrieval of the data. Involved in Performance tuning and Query Optimization using execution plan.

Worked on the UI views using Angular JSand followed MVVM pattern.

Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports.

Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server.

Implemented business logic using C#.NET, VB.NET

Designed presentation layer for dynamic web forms using ASP.Net 4.5 Framework, MVC 4.0, DHTML and Visual Studio tools.

Used JavaScript and Validation Controls for validating the controls.

Used C# to write all the middle business layer logic and web services.

Created XML database of all different frequency levels.

Used Cascading Style Sheet (CSS) to attain uniformity through all the pages.

Implement agile scrum methodology in application development.

Performed unit testing on every new feature before sending it for User Acceptance Test (UAT)

Responsible for deployment of the Application in production and resolving any post-deployment issues every month.

Responsible for maintaining versions of source code using SVN.

Environment: Visual Studio 2013/2012,C# ASP.NET 4.0/4.5,MVC 4.0, WCF, Entity Frame Work 4.0, Java Script, JQuery, SVN, WEB API, WCF, IIS 7.0,Agile, AJAX, ADO.NET, LINQ, XML,Angular JS,Adobephotoshop,Microsoft Enterprise Library,NUnit, ETL, SSIS, SQL Server 2014,SQL Server 2012,Windows XP, UML,SOAP,Windows Server 2008 R2/2008,FACETS.

Client: CareSource, Dayton, OH

Domain: Health care.

Title: Sr. .Net Developer

Duration: April 2014 – Feb 2015.

Description: CareSource has been meeting the needs of health care consumers for more than 25 years and it has a mission of making difference in the lives of underserved people by improving their health care is one they take to heart. It permeates the work we do each day, and it is a cornerstone that supports our corporate culture.

Responsibilities:

Involved in analysis, design and code different modules using C# which deals with the grievance and appealsfor both Medicaid and MyCare, updating the corresponding data in database.

Designed and Developed Grievance and Appeal Portal to integrate with SQL Reports using ASP.NET 4.0, C#, WCF, XML, SQL Server 2008 R2.

Used ADO.Net, LINQ in connecting to Data Access management with SQL Server.

Created Business Logic Layer & Data Access Layers to implement the MVC architectureusing Razor view engine and web API.

Worked with Visual Studio 2010/2012 .net Framework 3.5/4.0 to implement Business Logic.

Developed Views, controllers and business logic models using C#.

Developed WCF services for both Desktop and mobile applications.

Used WCF Services for communicating with other application and component.

Implemented Dependency Injection(DI) and Inversion of Control Principle (IOC) while developing the libraries.

Used JavaScript andJavaScript libraries likeAngular.JS and Bootstraptemplates in developing the front end applications and increased the efficiency of the webpage.

Implemented Cascading Style Sheet (CSS) to improve look and feel of the ASP.NET web page.

Written Stored Procedures in SQL Server 2008 R2 and used ADO .NET with Grid View, Data List,Dataset Classes for data manipulation.

Utilized Agile Methodology, Continuous Integration, MVC 5.0, Entity Framework 6.0, Telerik Kendo Framework, C#, .NET 4.5, SQL Server 2014, Git, JavaScript and Visual Studio 2013 Pro.

Experience in working with JavaScript frameworks like Bootstrap and AngularJS.

Created the Linked servers to pull the data from FACETS Server and used them in the stored procedure which will be executing on the scheduled basis through SQL agent.

Worked with QA in testing and entering data in FACETS4.7, 4.8 and 5.0 applications.

Written Queries using T-SQL Statements, Views, User Defined Functions, Stored Procedures, Triggers in SQL Server 2008 R2 for inserting/Updating/Deleting the data into the relational tables.

Worked Extensively with Query Optimization Techniques to fetch data with better Performance Tuning.

Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.

Created user level security in reports to allow restricted viewing to users of different levels and implemented data driven subscriptions using SSRS.

Imported previous existing Report definitions (.rdl) to the new reporting system

Designed web pages using ASP.net server controls, HTML, AJAX, CSS, and JavaScript.

Implemented client side scripting using JavaScript/JQuery and server side coding using built in ASP.net controls and C#.

Worked with Extract, Transform and Loading of the data using the ETL packages.

Handled Run Time Errors & Design Time Errors by implementing appropriate Error handlers in C#.Net.

Implement agile scrum methodology in application development.

Performed unit testing on every new feature before sending it for User Acceptance Test (UAT)

Responsible for deployment of the Application in production and resolving any post-deployment issues every month.

Responsible for maintaining versions of source code usingTFS.

Environment: Visual Studio 2012,C# ASP.NET 4.0,MVC 3.0,WEB API, WCF, Entity Frame Work 4.0, Java Script, JQuery, TFS, WCF, IIS 7.0, AJAX, ADO.NET, LINQ,Adobe photoshop,Angular JS, XML, Microsoft Enterprise Library,NUnit, SQL Server 2008 R2, SSIS, Windows XP, UML, Windows Server 2008 R2/2008,FACETS, ETL.

Client: J. P. Morgan Chase Bank, Dallas, TX

Domain: Finance.

Title: Sr. .Net Developer

Duration: May 2012 –March 2014.

Description: Chase is a leading global financial services firm with more than 5500 bank branches and 19500 ATM’S with assets of $2.3 trillion and operations in more than 60 countries.

Involved in a Project to be compliant with Chase’s policies and to ensure safety as well as privacy of Customers’ identity, DLSS Application Development team needs to develop a .Net solution using which they can mask Chase Customers’ Personal Info (PI) data residing in non-production databases and make it unrecognizable. This ASP.Net MVC Web app will provide an interface to submit and track requests to mask PI data at Database, Table & Column level. Users can also modify and add new PI columns to app’s metadata.

Responsibilities:

Worked closely with analysts and architects to understand the framework of the application.

Designed presentation layer for dynamic web forms using ASP.Net 4.0 Framework, MVC 3.0, DHTML and Visual Studio tools.

UtilizedAnkh SVN for the source code control, data collection and management in a multi-developer environment.

Worked with the frameworks Enterprise library, for exception logging, and Data access using DB Helper classes.

Rendered XML document to an HTML using XSL and XSLT Transformations.

Followed the industrial standards, Coding guidelines, Accessibility guidelines, DB guidelines, .Net best practices and Macros.

Writing Use Cases for the changes that are included as part of requirements.

Developed the various forms using Validation and Rich Controls, AJAX Extended Controllers.

Developed the Expert advice Web User Interface using AJAX technology to enhance the visual appearance to avoid the flickering effects across server post backs.

Used N-tier architecture to separate the layers and the functionality of different modules.

Used Custom Controls, User controls, and Server controls to design the screens.

Used JavaScript to validate the user processes on the client side.

Used SOAP to implement Web Services and consumed and published XML web services in the application.

Used Page and Data Caching concepts to increase the throughput of the ASP.NET Pages.

Worked with Data grids to pagination and sorting of the data columns.

Created cross browser compatibility templates using Cascading Style Sheets (CSS) to format the data.

Used Entity Framework extensively for retrieving, querying, storage, and data manipulation.

Used Dependency Injection for Working closely with Front office Traders, Portfolio Managers to understand and analyse their requirements and designing technical solutions.

Responsible for deciding the requirements, writing the Stored Procedures, Views, triggers, database design, Virtual Tables and some of the project management tasks.

Used SQL Profiler to trace and store the results in tables to analyze query performance.

Worked with different environments according to the requirement.

Used Agile (Scrum) Methodology for rapid and more disciplined development during implementation.

Involved in Documentation, Unit, Integration, and Regression Testing to make sure changes implemented do not impact on other parts of the application.

Environment: Visual Studio 2010,ASP.NET,MVC, C#, .NET FRAMEWORK 4.0, Entity Framework, AJAX,JSON, Javascript, HTML, XML, CSS, jQuery, Web services, WSDL, SOAP, SQL Server, T-SQL, ETL, SSIS, TFS, Nunit,Agile.

Client: WellPoint, Cincinnati, OH

Domain: Health care.

Title: Sr. .Net Developer

Duration: May 2011 – Apr 2012.

Description: WellPoint maintains its membership database across a large array of applications to manage different functionalities. Almost all of its other systems need to communicate with Facets in order to send/receive data on its members and claims. Various projects were handled simultaneously to design and develop/enhance custom interfaces & extensions with Facets to communicate with various other internal systems.

Responsibilities:

Developed solutions for diverse programming scenarios in C# employing Object Oriented Programming (OOP) concepts such as: encapsulation, inheritance, polymorphism, and abstraction.

Created WCF, REST Services and also used different bindings to make it available to different level of users.

Leveraged WCF mechanisms like sessioning, Instance management, concurrency to make our services more robust and scalable.

Utilized ADO.Net technology extensively for data retrieving, querying, storage and manipulation using LINQ.

Designed the web UIASP.NET, HTML, DHTML, XSL/XSLT, JavaScript, CSS and AJAX controls.

Created User Controls, Custom controls, Data Access Layer, Business Logic Layer Classes using C# and .Net 4.0 for web pages.

Responsible for designing the ASP.NET application authentication using .NET Framework, Model View Controller MVC and IIS security model.

Worked on Powershellscripts to automate the data transformation process.

Used ASP.NET MVC framework to support the use of Dependency Injection to inject objects into a class, instead of relying on the class to create the object itself.

Extensively used User interface controls which use JQuery to ensure client side validation.

Implemented Entity Framework with Database First EDMX and used Linq to Entities to massage the Data and optimized the Query Expressions.

Proven expertise in implementing IOC (Dependency Injection) and AOP features in various aspects of Spring Framework (Core, Web, JDBC, MVC and DAO).

Written Stored Procedures in SQL Server 2008 and used ADO .NET with Grid View, Data List, Details view, Repeaters, Dataset Classes for data manipulation.

Used data from FACETS server in the stored procedure, which were executed on the scheduled basis through SQL agent.

Helped QA with tasks of developing and executing manual test plans to support FACETS4.5 applications

Created and maintained database objects like complex Stored Procedures, Triggers, Cursors, and Tables, Views and SQL Joins.

Created the Linked servers to pull the data from different data sources and used them in the stored procedure which will be executing on the scheduled basis through SQL agent.

Written Queries using T-SQL Statements, Views, User Defined Functions, Stored Procedures, Triggers in SQL Server 2008 for inserting/Updating/Deleting the data into the relational tables.

Worked Extensively with Query Optimization Techniques to fetch data with better Performance Tuning.

Created Cross-Tab, Drill-down and Sub-Reports using SSRS.

Responsible for applying the Corporation’s Software Configuration Management processes to projects, setting up and maintaining TFS/GIT/GITHub infrastructure and supporting a continuous delivery model by automating software build and package migration processes.

Created user level security in reports to allow restricted viewing to users of different levels and implemented data driven subscriptions using SSRS.

Used Enterprise library for Database Connection and writing exception manager component, which creates a log file in event viewer.

Working with an Agile, Scrum methodology to ensure delivery of high quality work with every monthly iteration.

ImplementedUnit Testing, Integration Testing and System Testing using NUnit.

Responsible for maintaining versions of source code using Team Foundation Server 2010.

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

Environment: Visual Studio 2010, C#, ASP.NET WCF, Entity Frame Work 4.0,Agile, GIT/GITHub, Java Script, JQuery, TFS 2010, WCF, IIS 7.0, AJAX, ADO.NET,Power shell, LINQ, XML,VB.NET, Microsoft Enterprise Library,NUnit, SQL Server 2008 R2,FACETS, Windows XP, UML, Windows Server 2008 R2/2008.

Client: Chrysler Group LLC, Auburn Hills, MI

Domain: Automobiles

Title: .Net Developer

Duration: Feb 2010 – Apr 2011.

Project: Owner Connect Portal

Description: Chrysler Group LLC is a big organization where Mopar is the service provider for Chrysler, Jeep, Dodge, Ram, and Fiat. They are planning for maintaining a single source where all the documents and operations can be performed. Every brand has a separate website where from the user is presented with all car models and price list. All the images and documents are placed in a central location and are accessed with list and libraries of SharePoint. My role was to develop individual websites.

Responsibilities:

Involved in designing the layout of User interface using Visio and class diagrams using UML.

Implemented Data access layer using ADO.NET to connect and retrieve or manipulate database information.

Established communication between different applications running on same/different platforms using WCF.

Used Grid View, Data List and Repeater controls with Paging and Sorting for displaying various data on to the page

Programmed ADO.NET for communication between application and database, used extensively Data Grid, Data Set, Data Table, Data Views, Data Adapter and Data Readers to render reports.

Developed Stored Procedures, Triggers, and Views in SQL Server 2005 for accessing the database.

Developed PL/SQL queries to fetch data as per the business requirements with proper tuning techniques.

Implemented and extensively used the Object Oriented programming concepts in C# and ASP. Net 3.0.

Used XML intensively to bind the data to the web controls, data manipulation and to store data and sent as parameter to the stored procedures.

Implemented Serialization and Deserialization of objects.

Developed Custom Controls which provides flexibility, reusability better deign time experience.

Developed partial post back validations to manipulate data on web pages using AJAX.

Used Visual Source Safe for version control of the source code along with the maintenance of the builds and the relevant documents of the same.

Designed and coded application components in an Agile environment utilizing a test driven development approach.

Involved in unit testing,integration testing and deployment of the application.

Environment: Visual Studio 2008, ASP.Net 3.0, ADO .NET, XML, HTML, JavaScript, IIS 6.0, NUnit, Visual Source Safe, SOAP, WCF, .NET Framework 3.0, Web services, SQL Server 2005, SSIS, T-SQL, DHTML, Windows Server 2003

Client: Quad one Technology, Hyderabad, India

Title: .Net Developer.

Duration: June 2007– Jan 2010

Project: BOSS (Brokerage Operations Support system).

Description: To support the Brokerage Operations, Hartford insurance developed an Application named BOSS (Brokerage Operations Support system). Each country will use BOSS and develop applications, reports and business rules as per the local specifications.

Responsibilities:

Designed and developed web forms in ASP.NET 2.0&C# .NET using .NET Framework 2.0

Developed the application Framework in ASP.NET 2.0 primarily usingC#.NETwith the business logic implemented using .Net Assemblies

Extensively used C#.NET to develop server side event handling and components to handle business process.

Extensively worked with ASP.NETWeb Site Administration Tool (WAT) to create Roles, Login Controls, Authentication and Authorization for Site Security.

Developed GUI using ASP.NET 2.0Server Controls, User Controls and Custom Controls and MasterPages, Cascading Style Sheets (CSS) for consistent look.

Used the ASP.NET State Management techniques like Session State, View State to retain the values between the pages transactions, where Session is managed in out Proc mode.

Used the ADO.NET data binding controls line Grid View in order to bind the data to the control and display the retrieved data.

Written JavaScript code for validating the simple control instead of sending them to the server side which was degrading the performance of the web pages.

Extensive use of Web Services, SOAP, XML, XSL to expose the reports to facilitate information sharing.

Created Data tables and applied the Web Service Enhancements to the Web Service so that the reliability increases.

Created Data tables and have written Stored Procedures for all the transactions in and out of the database using SQL server 2000.

Created a Data Access Layer using C# to execute stored procedures into a Data Set, Data Table and Data Reader.

Performed NUnit Testing according to the business requirements.

Used Microsoft Visual Source Safe (VSS) for the purpose of version control.

Environment: .NET Framework 2.0, ASP.NET, C#, ADO.NET, XML, Web services,VB.NET, HTML, SQL Server 2000, IIS 6.0, Windows 2000 Server, VSS, NUnit, Visual Studio 2005.

Contact this candidate