Post Job Free

Resume

Sign in

Customer Service Sql Server

Location:
Birmingham, AL
Posted:
March 06, 2017

Contact this candidate

Resume:

GANESHA SHETTIGARA

Phone: 404-***-****; Email ID: acy5bt@r.postjobfree.com

Professional Summary:

Around 10 Years (Industrial + Training) of software development experience in IT industry.

Hands on technology experience of designing and developing web applications with Microsoft .NET Framework 3.5/4.0/4.5 using C#, ASP.NET, MVC, Entity framework and ADO.Net.

Expert at developing interactive and intuitive web UI using HTML5, CSS3, JavaScripts, JQuery and Angular JS.

Experienced in Microsoft Technologies like C#, ASP.NET, MVC 2/4, ADO.NET, VB.NET, AJAX, WCF (REST), Web Services (SOAP), WPF, Entity Framework 5, LINQ and IIS.

Worked extensively with database SQL Server 2005, 2008, 2012 and Oracle.

Worked extensively on writing Stored Procedures, Triggers, Functions, Views and Database Design.

Efficient in developing applications using C/C++, C# on Windows or UNIX Platform.

Experience in implementing several Design Patterns viz Singleton, Factory, Builder, and Observer using C++.

Good hands-on experience in implementing multi-tier, client-server architecture.

Solid experience in DB design (SQL DDL & DML), procedural programming (stored procedures, triggers), Sql Server Performance Tuning, improvement, storage, index and configuration.

Deep knowledge of OOPs Concepts.

Very good knowledge in Capital market and retail Banking, Telecomm, insurance and Energy domain.

Experience in each phases of Software Development Life Cycle (SDLC), concept to full implementation, and software design life cycle management implementation with Water fall and Agile Methodologies.

Strong team player with demonstrated ability to find creative solutions to software problems.

Good analytical skills, commitment to co-operative teamwork and developing high quality software meeting requirements of the customer.

Good technical knowledge and combined creative problem-solving skills on both strategic and tactical areas.

Educational Qualification: -

Bachelor of Engineering in Computer Science from Bangalore University May 2005

Certifications: -

Holds ACAD certification in collaboration with Massachusetts Institute of Technology (MIT)

Completed level1 certification from NSE’s Certification in Financial Market.

TECHNICAL SUMMARY: -

.NET Technologies

ASP.NET MVC 2/4, ADO.NET, WCF, Entity Framework, LINQ, Lambda expressions, MVVM

Programming skills

C#, C++, Algorithms, Data structures, Shell scripting.

Design Methods

Design Patterns, UML, XML, COM, MFC, OOAD, XSD.

Web/UI technologies

HTML5, CSS3, XML, SOAP, XSLT, JavaScript, JQuery, AngularJS.

Web Servers

IIS 5.0/6.0/7.0

Databases

SQL Server 2005/08/12, Oracle PL/SQL.

Development Tools

Visual Studio 2008/10/12/13, 15, PVCS,

TFS, All fusion Harvest, Workshop, CVS, Accurev, Sunstudio.

Debugger Tools

Visual Studio, DBX, SunStudio.

Operating Systems

Windows Server 2003/2008, Windows XP/Vista/7/8/10, Unix Sun Solaris.

PROFESSIONAL EXPERIENCE: -

Client: Southern Company, Birmingham, AL July 15 – Till date

Project: IDMS Interface

Designation: - Senior Developer Lead

Project Description: - Integrated Distribution Management System encompasses three mission critical applications, DSCADA, Electronic Map Board (EMB) and Distribution Outage Evaluation System (DOES) with a single graphical user interface. The IDMS Interface connects trouble orders in IDMS with CSS and ARMS.

Responsibilities:

Created web forms using ASP.NET4.0, C#, ADO.NET with SQL server as backend.

Used LINQ to Entities, LINQ to SQL and LINQ to Objects for retrieving the data proficiently.

Created/Managed stored procedures, Views, Triggers and function, Type, Array from SQL Server 2008.

Extensively used ADO.NET, Entity Framework for interfacing this application with the SQL Server.

Understanding the requirement and conduct impact analysis on the system.

Interpret user requirements into design specifications and Participate in developing user interface strategy.

Review, prioritize, and research application change requests

Identify and recommend improvements in technical standards for products.

Defines technical requirements to support defined business requirements, participates in detailed design and code reviews.

Review system performance and consumption issues, reviews test plans, and provide technical guidance and support to the other application and test team members.

Worked on Agile software development methodologies for delivery of the product.

Environment: C#, ASP.Net, MVC4, WCF, LINQ, JQuery, Entity Framework 6.0, Angular JS, TFS, Agile.

Client: Southern Company, Birmingham, AL Nov 14 – June 15

Project: S&Toc Audit Report system

Designation: - Senior Developer

Project Description: - Switching and Transfer of control Audit Report (STAR) is a web application which helps the distribution field engineers or Auditors to audit the Switching Orders.

Responsibilities:

Prototyping and UI design

Creating and presenting screen mock-ups to project stake holders.

High Level and Detailed technical design documentation for UI module.

Integrating jQuery and HTML5 in the UI design to enable creation of customizable dashboard.

Interpret user requirements into design specifications and Participate in developing user interface strategy.

Identify and recommend improvements in technical standards for products.

Analysis and effort estimation.

Environment: C#, ASP.Net, MVC, JQuery, ADO.net, Angular JS, TFS.

Company: Symphony Teleca Corp. Sep 10 – Oct 14

Client: Misys

Project: Summit

Designation: - Technical Lead

Project Description: - Summit provides integrated Trading, Operations, and Risk Management software products to banks, financial institutions, and capital markets participants worldwide. Summit has developed business-specific solutions on a common infrastructure, for Fixed Income, Treasury, Derivatives, and Commercial Lending. It is deployed by global banks to handle highly complex and structured trades across their front to back office functions. It speeds-up innovation, improves management of liquidity, reduces operational risk and improves STP (Straight through Processing).

Responsibilities:

Worked on Summit Front to Back End code flows in both Summit FT and classic.

Worked on Infragistics controls and win forms that are used for UI development of the application.

Worked on WPF to create UI modules using MVVM patterns.

Knowledge on various trade life cycles.

Worked with many different design patterns to design, enhance and extend the functionalities of the application.

Worked on application modules of summit like SWAP, BONDS, Portfolio Monitor, and etc. Gained extensive knowledge on these areas.

Worked on many Summit reporting applications like profit and loss report (pnl), rtrep. In both FT version and classic version of Summit.

Having good knowledge Summit core functionalities like sGenAssetEvent, sValueTrade, and other functions present in ft_applcations.

Worked on Summit STP servers, created a STP server to extract the trade XML from Summit

Worked Gateway adapters and Loader services to the client POCs.

Knows about front end calls through Http and creation of XML and adding new and updating FT applications.

Porting Summit code base to support Solaris 64 bit in X64 architecture

Bug fixing in various modules in Summit like report, Trades, extension tool etc.

Worked on the development and enhancement of V5.5 and V5.6 release.

Having good knowledge on Summit Environment setup.

Worked in all the versions of Summit from V3.5 classic to V5.6 FT in both Windows and Solaris platforms.

Help team members on any technical and functional issues they might have.

Contribute to and foster knowledge sharing to build technical and functional knowledge across teams.

Environment: C#, .Net, C++ with Windows, CORBA, Shell scripting, MVVM.

Company: Accenture services Feb 09 – Aug 10

Client: First Data Corp

Project: CNP

Designation: - Senior Software Engineer

Project Description: - CNP is a banking transaction system which is built on both windows and solaris platform. This application allows Customer/Merchants to submit their transaction data for Authorization or settlement of requests. CNP is handling many interfaces to the external systems, it receives the online/batch transaction data from the merchants, these data will converted to desired format inside the CNP and then it will be transferred to respective interfaces.

Responsibilities:

Attend the requirement signoff meeting; understand the technical and functional requirement and overall business strategy of the business customer.

Interpret the user requirement into design specifications and participate in developing user interface strategy.

Good understanding of multithreading – POSIX threads. Worked on threads synchronization, thread management, thread terminations.

Worked on Webforms for customizing/enhancing the existing UI screens.

Worked on C++ for the backend calculation of

Contribution in the code reviews, analysis and test-plans.

Contribution in the creation of high level design documents, traceability matrices, assembly test specification, product test specification etc.

Identify and recommend areas of improvements in terms of code and design. Involved in code refactoring and re-architecting the product.

Help the team members in any technical or product knowledge and ensuing in smooth delivery of the product.

Delivered many critical feature to client application which was in much

demand from the End user with quality of work.

Involved in base design and develop these features. Based on the quality of

work company got many more development work.

Involved in bug fixing phase of the project, pinpointed and solved several of our most widespread crashing bugs. Also involved in helping the support team by directing them to right areas of the issues.

As a senior member he was responsible for all the development related activity.

Review system performance and consumption issues, reviews test plans, and provide technical guidance and support to the other application and test team members.

Environment: C#.net, C++, Sun Solaris, WebAPIs, XML, XSLT, Visualstudio

Company: Accenture services Dec 06 – Jan 09

Client: AT &T Telecom Services

Project: Regional Negotiation System

Designation: - Senior Software Developer

Project Description: - Regional Negotiation System (RNS) is a customer sales and service application used by BellSouth & AT&T Consumer Operations. Customer Service Associates (CSAs) use RNS to provide residential customers with new service or changes to existing service.

The permanent record of the service a customer receives is the Customer Service Record (CSR). RNS is essentially the user-interface application that enables Customer Service Associates to create, modify, and issue service orders.

RNS works with a number of other applications or databases to accomplish its tasks. RNS does not store any data in and of itself, but it uses and modifies the data from other systems; it is thus fundamentally linked to and dependent on those other systems.

Responsibilities:

Understanding the business and functional requirements and overall business strategy of the business customer.

Ensure business requirements are supported by the technical architecture.

Worked on C#.Net (from 2.0 to 4.0 version), WPF for Front end development of the application. Thorough understanding of C# framework and MVC.

Worked on SQL server 2005, 2008 and SQL Server Performance Tuning, improvement, storage, index and configuration.

Worked on C++, Data structure and STLs for the Business logic layer of the application.

Conduct impact analyses of business requirements on the system.

Interpret user requirements into design specifications and Participate in developing user interface strategy.

Good understanding of Design models –OOAD, UMLs etc.

Contribute to the development conceptual systems designs as appropriate.

Define test plans and criteria for acceptance for the technical components of an application, Provide inputs to test planning - develop and execute test scripts.

Conduct structured walk-through or inspections for technical areas

Review, prioritize, and research application change requests

Anticipate report and proactively resolve issues both within a team and across application teams.

Identify and recommend improvements in technical standards for products.

Contribute to and foster knowledge sharing to build technical and functional knowledge across teams.

Defines technical requirements to support defined business requirements, participates in detailed design and code reviews.

Review system performance and consumption issues, reviews test plans, and provide technical guidance and support to the other application and test team members.

Help team members on any technical and functional issues they might have.

Defect Coordination with the Onsite Client Team. Prioritization of Production defects and Reporting

Creation of RBA (Resource Budget Allocation), Allocating budget to the resource. Manage the resource to work with production defects

Environment: C, C++, C#.Net, WPF, WIN32 API, Sun Solaris, Sunstudio, DBX, VS, CORBA, shell scripting, Inter Process Communication.

ACCENTURE Jul 05 – Nov 06

Client: Northwestern Mutual

Project: NIS

Designation: - Software Engineer

Project Description: - Northwestern Mutual is an insurance major in USA. Potential customers who want to take life insurance policies approach NWM. The clients wanted to create an application that can be used by their field agents to illustrate ledger values. The application named Network Illustration System can be used to demonstrate different plans available with NWM and what dividends and net insurance amounts the customers can expect in the years to come for these plans. NWM releases different plans and life insurance products periodically. We had to create this application that will incorporate all these products.

Responsibilities:

Processes and code in order to implement clients' requests for new or modified functionalities.

Involved in requirement gathering, change request, preparation of design documents.

Involve in requirement specification signoff, HLD signoff meeting for the clear understanding of the technical requirement.

Define test plans and criteria for acceptance for the technical components of an application, Provide inputs to test planning - develop and execute test scripts.

Involved in almost all phases of SDLC like design, build, unit test and assembly test phases.

Worked on both C#.Net front and calculation (C++) modules of the application.

Fixing product testing defects reported.

Contribute to the development conceptual systems designs as appropriate.

Used .NET controls for client and server side validations.

Environment: C#.net, C++, WPF, Visual studio 2005, 2008.



Contact this candidate