Sql Server Sales

REKHA GUVVALA

Summary:

**+ years of progressively responsible experience in Information technology with extensive experience in Designing and Developing Client/Server and Web applications.

Extensive experience in Software Engineering and Object Oriented Methodologies in Business Application Development and Business Re-engineering.

Expertise in Development of Web Applications using ASP.NET, ASP, VB.NET, C#.NET, JavaScript, Angular JS, JQuery, ADO.NET, ADO, Entity Framework, NHibernate.

Developed Web Services using SOAP, WCF and REST.

Extensively used the CRM tool SalesLogix 6.2 to make various Web and LAN Customizations and was involved with Sales Logix administration.

Extensively created various Windows Forms with rich user controls.

Extensive experience in Financial, Insurance, Human resource, Telecom, Retail and Product based industries.

Familiarity with various Tools and Technologies like HTML5, CSS3, XML, XSLT, SOAP, UDDI.

Experience in Integration of various data bases like MS SQL Server, Oracle, DB2 and MS Access.

Strong Report Designing experience with SSRS and Crystal Reports.

Experience with Development of Database Triggers, Views and Stored Procedures for optimizing the performance improvement.

Well Versed with UML diagrams.

Worked on SCRUM/Agile methodologies, addressing technical approach; estimates on project and testing, performing sprints and delivering release quality code for each iteration in my various projects.

Used various design patterns like singleton, facade, factory and repository patterns.

Experience in Configuration and Version Management using Visual Source Safe, IPM, CVS, Harvest and Dimensions.

Involved in the entire software development life cycle (SDLC).

Expertise in understanding the Business requirements and translating them into Detailed Design along with technical specifications.

Highly Adaptive to Team Environment having excellent analytical and presentation skills with ability to work on multiple projects/tasks simultaneously to meet dead lines.

Technical Skills:

Languages

C#, VB.NET, C++, C.

Technologies

.Net Frame Work 4.0/3.5/3.0/2.0, Web Services, LINQ, AJAX, WCF, Web API, REST,

Angular JS, JQuery.

Internet Tools

ASP.NET, ASP, ADO.NET, ADO, XML, DHTML, HTML, Adobe Photoshop.

Databases

MS SQL Server 2000/2005/2008, Oracle 7i/8i/9i, DB2, MS Access.

Reporting Tools

Crystal Reports, SSRS.

Data Modeling Tools

Erwin.

Operation Systems

Windows NT/2000/2003/XP.

Servers

IIS 6.0/5.0.

Scripting Languages

VBScript, JavaScript.

IDE and front end tools

Visualstudio.NET 2013/2012/2010/2008/2005/2003, Win Forms.

Configuration Tools

GitHub, TFS, Visual Source Safe, Harvest, CVS, IPM, Serena’s Dimensions, SVN.

Modelling Tools

UML.

CRM Tools

Sales Logix 6.2, 7.2

Education:

MS in Electrical Engineering, University of New Orleans, LA, US, May 2004.

B. Tech in Electronics and Communications Engineering, JNTU, Hyderabad, India

Professional Experience:

Capital One July 16- Current

Project: Loss Mitigation

Plano, TX.

Titan application is used by Capital One auto loan customer service representatives. It comprises of loan management and loan modification modules for loss mitigation.

Roles and Responsibilities:

Worked on various enhancements and automation of Loss mitigation processes like Hardship/BATA.

Involved with design development and testing phases of the project.

Used Model view controller pattern for development.

Used various front end technologies like AngularJS for the UI layer.

Worked with MS SQL server as the database.

Developed various stored procedures, views and triggers.

Created various ATDD scenarios for the enhancements using Ruby.

Created Restful services for Hardship/BATA eligibility and loan modification process.

Used GitHub for version control management.

Worked in 2week agile scrum sprint cycles.

Environment: Visual Studio.Net, MVC, .NET Framework, ASP.NET, C#, LINQ, Angular Js, AJAX, HTML5, MS SQL Server, Jenkins, Rubymine, IIS, GitHub.

Ace cash Express Aug 15 - June 16

Project: Loan Management System

Irving, TX.

Ace specializes in short term consumer loans including payday, title and installment loans. Loan Management system is used by the customer service representatives for managing and administration of these loans.

Roles and Responsibility:

Involved with the software development processes including requirements gathering analysis, functional design, technical design and program, coding, testing, implementation, and post implementation support.

Worked on various enhancements to Loan management portal.

Involved with development of Restful services for loan scoring and lending management.

Worked on a centralized configuration engine which would provide a systematic approach for configuration management at various levels in Ace stores.

Developed an Admin UI for handling the configuration management.

Used Model view controller pattern for development.

Used Angular JS for the UI layer

Developed the core layer used to host all the common objects and interfaces needed for communication between the layers.

Worked with MS SQL server as the database.

Developed various stored procedures, views and triggers.

Develop test plans and work with QA to establish test processes.

Assist team with documentation and preparation for implementation, training and support documents to the support team.

Involved with enhancements and bug fixing for the application.

Environment: Visual Studio.Net 2013, .Net Framework 4.5, MVC, Web API, REST services, C#.NET, ASP.NET, ADO.NET, Jason, MS SQL Server Management Studio, T-SQL, Angular JS, Java script, Razor, JQuery, AJAX, Internet Information Services, Windows.

Tyco March 15 – Aug 15

Project: Install Mobility

Senior Developer

Richardson, TX.

Install Mobility is an mobile application to allow installation technicians to complete daily workflow with more efficiency, and to enable install coordinators to schedule technicians and track overall job status. The application will provide increased automation,

productivity and tracking abilities in the installation life-cycle.

Roles and Responsibility:

Worked on MVC application operations Mobility used by support group to manage Jobs and users and various administration tasks.

Used frond end technologies like Razor, JQuery, AJAX, HTML5 for the front end.

Involved with development of WCF services that will enable creation and updating of Install Jobs.

Developed user interface for Install Mobility layer using xCode and Storyboards.

Used Xamarin studio to work on View Models which form the business layer hosting all the needed business logic by the screens.

Used MVVM for this IOS application.

Enhanced the Core layer used to host all the common objects and interfaces needed for communication between the layers.

Injected services into View Models using Autofac Dependency Injection.

Used entity framework as the ORM layer.

Worked with MS SQL server as the database.

Involved with enhancements and bug fixing for the application.

Environment: Visual Studio.Net 2012, MVC, .NET Framework 4.0, ASP.NET, C#, LINQ, WCF, Razor, JQuery, AJAX, HTML5, Entity Framework, MS SQL Server, IIS, Xamarin Studio, Xcode, SVN.

GameStop Aug 14 - March 15

Project: Ecommerce Team

Senior Developer

Grapevine, TX

Add on warranties enhancements to GameStop desktop, mobile and web-in-store ecommerce sites. This feature will enable GameStop customers to secure their purchase by adding warranties to their products.

Roles and Responsibility:

Involved with design development and testing phases of the project

Used Model view controller pattern for development.

Used various front end technologies like JQuery, AngularJS for the UI layer

Used structure map for dependency injection for improved testability and decoupling.

Created WCF services to perform warranty product association and CRUD operations.

Used Fluent Nhibernate as the ORM layer by mapping database table fields to strongly typed C# code class attributes.

Worked with SQL Server developing stored procedures, views and triggers.

Used GitHub for as the revision control and source code management functionality.

Worked with Omniture to enable marketing analyst gather page statistics.

Involved with integration and regression testing.

Worked in 3 week agile scrum sprint cycles.

Involved with sprint planning, grooming and estimation of stories.

Environment: Visual Studio.Net 2012, MVC, .Net Framework 4.0, ASP.NET, C#, LINQ, WCF, Fluent Nhibernate, MS SQL Server, IIS, Github, Jquery, AngularJS, HTML5, CSS.

GameStop Aug 13 - May 14

Project: Middleware / Warehouse Management

Senior Developer

Grapevine, TX

In the retail system environment Middleware engine manages day to day flow of files from stores to corp and corp to store.

Warehouse management system involves supply chain inventory management to the stores and online orders.

Roles and Responsibility:

Develop and supports IT retail systems and assume responsibility for administration, documentation, support and troubleshooting of these systems.

Software development processes include requirements gathering and analysis, functional design, technical design, coding, testing, implementation, and post implementation support.

Establish and enforce software development best practices by using agile methodology.

Develop and support existing and future applications using C#.NET.

Developed various WCF Web services.

Develop test plans and work with QA to establish test processes.

Assist team with documentation and preparation for implementation, training and support documents to the support team.

Involved in writing stored procedures, triggers in MS SQL Server and Pervasive database.

Used TFS for version controlling of the source code and worked on various build and release cycles.

Environment: Visual Studio.Net 2010, .Net Framework 4.0, ASP.NET, ADO.NET, C#, VB.NET, LINQ, WCF, MS SQL Server, IIS, TFS, pervasive database.

Epsilon Dec 12- June 13

Project: Shell Loyalty

Senior Developer

Irving, TX.

Shell offers loyalty rewards for its customers through various programs. Epsilon manages this reward management for shell. It communicates with all the Loyalty Programs and Stacks the rewards for Shell customers. It also provides a Loyalty Portal for Wholesalers and Dealers so that they can perform program activities like program enrollment, priority and stacking. It also provides settlement reports for managing settlement data for various programs.

Roles and Responsibility:

Responsible for the design, development, testing, maintenance and documentation.

Developed various WCF Web services to communicate with all the Loyalty Programs.

Created various C# classes for enhancing functionalities.

Developed Loyalty portal screens using MVC framework, C#.NET, AJAX and JQuery.

Used various JQuery Grid Controls for generating rich UI reports.

Implemented data retrieval using LINQ to XML.

Used PCATS standards for XML communications between various Programs.

Used Oracle prepared statements to execute SQL in database.

Created various Visual studio test suites for TDD test driven software development.

Used HPQC for defect tracking and release management for various bug fixing cycles.

Used TFS for version controlling of the source code and worked on various build and release cycles.

Environment: Visual Studio.Net 2010, .Net Framework 4.0, ASP.NET, MVC 3, C#, WSDL, SOAP, AJAX, WCF, LINQ, Oracle, JQuery, TFS, HPQC, PCATS, Agile methodology.

Alcatel Lucent June 12- Dec 12

Project: MMIG

Senior Developer

Plano, TX

The Alcatel-Lucent 8950 Microsoft Mediaroom Integration Gateway (MMIG) is a service layer that encapsulates Mediaroom business logic for ALU applications such as 5905 Communication Gateway and Remote DVR, as well as exposes integration points for customer billing or CRM systems. 8950 MMIG supports logical partitioning of the video systems into sites. This allows hosts (customer who has purchased and installed video middleware) to wholesale the service to other providers.

Roles and Responsibility:

Responsible for the design, development, testing, maintenance and documentation.

Developed various WCF Web services to encapsulate ALU business logic in VB.NET.

Developed Admin UI screens that provide a rich user Interface using C#. NET.

Used JavaScript for Client side and server side Validations.

Created various User controls for reusability throughout the application.

Used AJAX to make the WebPages more dynamic.

State management was achieved Server side using SQL server and Client Side using Query strings.

Developed C#.NET Class libraries for various enhancement functionalities.

Implemented data retrieval using LINQ.

Extensively worked with SQL Server developing stored procedures, views and triggers.

Involved in unit testing and Integration testing of the application.

Used HP Quality Center for defect tracking and bug fixing cycles.

Used SVN for version controlling of the source code and worked on various build and release cycles.

Environment: Visual Studio.Net 2010, .Net Framework 4.0, ASP.NET, MVC 3, ADO.NET, C#, VB.Net, WSDL, SOAP, UDDI, HTML, AJAX, WCF, LINQ,T-SQL, MS SQL Server, IIS, SVN.

Frontier Communications/Verizon Nov 09- June 12

Project: IT Work Bench

Senior Developer

Irving, TX

IT Workbench provides a complete user, application and web service registration process; and approval workflows for Verizon service providers and Verizon’s business partners. The ITW Framework consists of Runtime and Portal Environments supported by a Data Layer and a Reporting Layer. It provides the following features to Web services developers and users like Centralized Verizon Registry (UDDI), Security based on industry standards, Manage Web Service - Publishing, Discovery and Subscribing, SLA Management, Alerts and Notifications, Usage Statistics Reporting & Analytical Dashboard.

Roles and Responsibility:

Responsible for the life cycle support, including analysis, design, development, testing, maintenance and documentation.

Created various C# pages and added functionality to the existing system for various enhancements.

Created Multithreading applications to improve the performance.

Developed extensive client side scripts using JavaScript and server side Validations.

Developed Web services to perform Security authentications, logging data and heartbeat services.

Devised error handling mechanism by maintaining a Web service transaction log and generating emails to the team incase of failure.

Involved in developing web service with Server Oriented Architecture (SOA) to make data available within Intranet and Internet.

Generated an Advanced Search functionality which would search for web services using various criteria in VB.NET.

Performed Administration functions, and regular maintenance tasks for the IT Workbench Web portal.

Supported various applications for Installation of ITW agents on their servers and troubleshooting issues with authentication and logging.

Implemented data retrieval using LINQ.

Creating and managing SQL Server database schema objects such as tables, views, indexes, procedures, triggers and maintained Referential Integrity and defaults.

Created various reports using SSRS to display the transactions counts, subscriptions and various other statistical usages of data.

Converted the tasks in the existing stored procedures to web methods that will be consumed by these interfacing systems.

Involved in writing stored procedures, triggers and in MS SQL Server.

Version controlling using Visual source safe.

Wrote test cases for unit testing. Performed unit testing, system integration testing based on the test plan and documented test results.

Environment: Visual Studio.Net 2010/2008, .Net Framework 4.0/3.5, ASP.NET, ADO.NET, C#, VB.Net, WSDL, SOAP, UDDI, HTML, AJAX, WCF, LINQ,T-SQL, MS SQL Server, IIS, SSRS, Visual source safe.

Verizon, Silver spring, MD. Dec 07-Aug 09

Project: CBS/CNE

Senior Developer

Silver Spring, MD.

The CBS/CNE system is an essential operational support system CRM tool that directly contributes to Verizon's key business objectives to generate revenue, protect existing revenue, grow market share, reduce both presale and post sale cycle times and meet the regulatory requirements. It is a web-based application with Microsoft IIS servers on the front end and Microsoft SQL Server 2005 on the back end.

Roles and Responsibility:

Responsible for the life cycle support, including analysis, design, development, testing, maintenance and documentation.

Developed a Case Expiration Process and Extension Requested Process for various work groups to the existing CBS/CNE system.

Created various C#.NET pages and added functionality to the existing system to incorporate the case Expiration/ Extension Requested process.

Involved in developing GUI using WebForms.

Created Data Access Layer using C#.NET class modules to interact with the database.

Created Multithreading applications to improve the performance.

Developed extensive client side scripts and validation functions using JavaScript.

Used AJAX for Partial Updating of Web Pages and to prevent full post backs.

Determined Quote Expiration Date depending on the business requirements of the expiration dates process.

Routed the cases to various work groups in the system according to nature of the case and the case expiration / Extension Requested business requirements.

Maintained a Journal log for all the changes made in the Expiration/Extension Process.

Converted some of the existing ASP pages to ASP.NET.

Used VBScript, JavaScript, AJAX, HTML, and CSS for creating ASP pages.

Created various reports in the Query Wizard which would help the clients get case expiration work flow.

Developed C#.NET Class libraries for performing tasks like to validate the request XML and create the response Xml for various web methods.

Created various Webservices for CBS/CNE to interface with other web application like Symphony/CCP/Requestnet.

Created Web service client code to consume services from various systems interfacing CBS/CNE application.

Implemented various functionalities like the data transfer, creating lookups, reporting.

Creating and managing SQL Server database schema objects such as tables, views, indexes, procedures, triggers and maintained Referential Integrity and defaults.

Involved in writing stored procedures, triggers in MS SQL Server.

Version controlling using CVS and IPM.

Wrote test cases for unit testing. Performed unit testing, system integration testing based on the test plan and documented test results.

Environment: Visual Studio.Net 2008/2003, .Net Framework 3.5/2.0, ASP.NET, ASP, ADO.NET, C#, VB.Net, WSDL, SOAP, UDDI, HTML, VB Script, AJAX, WCF, LINQ,T-SQL, MS SQL Server 2005, IIS, Crystal Reports, CVS, IPM.

Insurance Service Office, Jersey city, NJ Aug 06-Nov 07

Project: ISO-ITS

Senior Developer

Jersey city, NJ.

Developed a customer portal for ISO-ITS (https://support.iso-its.com) customizing the out of box CRM Sales Logix customer portal and using ASPX pages. The ITS customers use this customer portal to add edit and update tickets. These ticket are opened by the ITS customers when they face any problems with the wide range of ITS products. Created LAN Customization in the existing CRM Sales Logix Client setup to include the ISO-ITS enhancements. The CRM Sales Logix LAN Client customizations and Web Customer Portal are designed and developed to work in synchronous with each other and are properly integrated with the existing system.

Roles and Responsibility:

Involved in requirement gathering, analysis, design, and development and testing phases.

Developed various ASP.Net pages using C#. NET.

Experience with modeling Visio UML diagrams.

Used ADO.Net for accessing Data Adapter, Dataset, and Data Reader in C#. NET Web pages.

Involved in Sales Logix administration tasks creating accounts, user groups and setting up accessibility levels.

Worked with sales logix Architect, Web Manager, Sales logix administrator, sales logix bundler.

Customized the CRM Sales Logix out of box Customer Portal for the customers to add new tickets, edit the existing tickets and Close and Reopen tickets.

Used JavaScript, HTML, CSS, XML for the CRM Sales Logix Web Customizations.

Used AJAX to make the WebPages more dynamic.

Created various Web Templates using HTML tags and custom Sales Logix tags to show live data for the web client.

Created Webservices to expose Sales logix high priority Opportunities and also the data in Opportunities custom tables, which have a one to one relationship with Opportunities table.

Webservice is consumed by various financial applications.

Customized various plug-ins in Architect according to the needs of the customers.

Used VB Script to do the CRM Sales Logix Client side customizations for the customer support.

Created Data rules for field and record security and also user connection.

Used Active X Data Objects to access Sales Logix data directly.

New Lookups are provided to help customers search tickets based on certain ticket details criteria both in the client and the portal.

The existing CRM Sales Logix Client Ticket View is customized to include the ISO ITS tickets with the functionalities to add tickets, edit tickets, change the ticket status and Email the entire ticket details.

Various Tabs were created in the CRM Sales Logix Client to hold the ISO-ITS Ticket Details, to add and edit Ticket comments both internal and customer facing, to maintain the audit trail of the changes made to the tickets and to add ticket attachments.

Created ISO-ITS custom Ticket tables which have one to one relation with the ticket tables in sales logix database.

Enabled field level security after creation of the table using database manager.

Created Sales logix bundles for migration of code from one environment to another.

Created various reports which would help customer support in their daily workflow using Crystal Reports 8.5.

Involved in creating tables, indexes, views, triggers, stored procedures and DTS Packages in SQL Server.

Involved in unit, system integration and regression testing.

Version controlling using VSS.

Environment: Sales Logix, .Net framework 2.0, Visual Studio.Net 2003, ASP.NET, ADO.NET, ADO, C#.Net, HTML, Java Script, VB, COM/DCOM, Active Directory, VB Script, T-SQL, AJAX, SQL Server, Crystal Reports, IIS, Windows XP, VSS.

Wachovia, Charlotte, NC Oct 05- July 06

Project: SOLD Phase-2 GUI

Senior Developer

Charlotte, NC.

Sales Opportunities and Lead Development is a combination of three main applications SK (Sales Results), SQ (Prospecting) and V5 (Book of Business). The purpose of this project is to create a web presentation layer for Phase 2 data in SQ and V5. This web presentation layer will eventually replace existing read-only query screens involved in transactions. The application will need to support up to 20,000 users accessing the web site within a two-hour period over 2,500 financial centers that are distributed over the entire Wachovia footprint.

Roles and Responsibility:

Developed various ASPX pages using Visual Studio.NET.

Designed UML diagrams to depict the flow.

Used C# to write the code behind for ASPX pages.

Designed and Developed Web Forms with various controls to incorporate the User Interface in ASP .NET.

Used ADO.NET for accessing Data Adapter, Dataset, and Data Reader.

Designed ASP.Net/HTML pages for GUI/Presentation layer.

Used JavaScript for building pop-up window.

A login screen is used by the user to log into Phase 2 using2 his/her corporate User ID.

The EPass Security implementation is used to authenticate the User ID and password against the ePass LDAP directory.

The SOLD data exists in the DB2 database which resides on the mainframes.

DB2 Connect is used as the gateway for the database access.

Built internal stored procedures in DB2 to access data. The application will not use direct SQL.

Involved in knowledge transfer to offshore during the course of the project.

Used CVS as central repository.

Environment: Visual Studio.Net 2003, ASP.NET, ADO.NET, C#, UML, IBM DB2, DB2, Connect, Mainframes, HTML, Java Script, IIS, Windows XP.

Compucredit, Atlanta, GA Aug 04-Oct 05

Project: Purpose Card.

Senior Developer

Atlanta, GA.

Purpose Card is an opportunity for customers to have a re-loadable prepaid debit card that is secure, low risk and easy to use. To enroll for a Purpose Card, there is no credit check or extensive paperwork. The Purpose Card is convenient, giving cardholders the ability to load funds at any Purpose Center and withdraw funds from participating ATMs (CIRRUS and NYCE) or where MasterCard debit cards are accepted. The cardholder can make purchases at millions of locations worldwide. Best of all, the cost is comparable to that of other debit card programs.

Roles and Responsibility:

Involved in designing and coding the forms using C#.

Involved in writing XML files (XML serialization) to set/get the communication port settings and also XML files used to store the image data.

Created class library for RS232 serial communication listener, which acts as a communication channel between CPU and T7Plus interface.

RS232 Listener sends the request to T7Plus and gets the response from T7Plus in XML format.

The transaction web service sends the transaction message (XML message) to and gets the response message from MSMQ for processing by Purpose-Switch.

Involved in writing stored procedures, views and DTS Packages in MS SQL Server 2000.

Generated Daily, weekly and monthly customer transaction reports using Crystal Reports.

Used Visual Source Safe (VSS) as central repository.

Environment: C#, VB.NET, ASP. Net, ADO.Net, WSDL, Web Services, XML, XML Schemas, XML Serialization, T-SQL, SQL Server 2000, Windows 2000.

Washington Mutual, Memphis, TN Nov 03-Aug04

Project:PrivateBankingInternet .

Developer

Memphis,TN

This project has been designed to support the Private Banking area by providing the registration and maintenance of customers requesting access, secured login capability to the customer, user profile Information and Trust Account information to the customer, over the internet. PBI Project expands viewing capability by allowing the Private banking customers access to view their accounts.

Roles and Responsibility:

Involved in designing the WebPages and providing the functionality for the Internet.

Designed the Database, created tables Views, Triggers, and Stored Procedures.

Developed various ASPX pages using Visual Studio.NET.

Used VB. NET and C# to write the code behind for ASPX pages.

Designed and Developed Web Forms with various controls to incorporate the User Interface in ASP .NET.

ASP.NET user Controls are used to implement the common functionality.

Implemented code behind architecture to implement the middle layer.

Used ADO.NET for accessing Data Adapter, Dataset, and Data Reader.

Designed ASP. NET /HTML pages for GUI/Presentation layer.

Generated the reports based on the user requirements and formats using Crystal Reports.

Environment: Visual Studio.Net, ASP.NET, ADO.NET, C#, VB.Net, Oracle 8i, HTML, Crystal Reports, Windows XP, Visual Source Safe.

Contact this candidate