Sql Server Project

Ganga Rao ****.*******@*****.***

SSRS Developer Phone # 609-***-****

Professional Summary

Over 8 years' experience in all SDLC phases including User Interaction,

Analysis, Design, Development, Testing, Deployment, Maintenance and

Enhancements of Web and Windows applications in Microsoft .Net and related

technologies.

. 3 years of experience in Designing, Developing, Scheduling, Deploying,

Configuring and Managing SSRS reports.

. Experience in developing various types of reports like Drill down,

Drill through, Parameterized, Sub Reports, Table, Matrix, Dashboard

and Charts.

. Expert in automating SSRS report deployment process.

. Highly proficient in SQL joins, stored procedures, functions, views

and Triggers in SQL server.

. Experienced in .Net Framework4.0/3.5/1.1,Microsoft visual studio

2010/2008/2005.

. Rich usage experience in C#, ASP.NET, ADO.NET, Windows Services, Web

Services, SQL Server 2008 R2, SQL Server Reporting Services (SSRS),

HTML, CSS, JavaScript, MVC 3.0 and JQuery.

. Good experience in MVC 3.0 architecture pattern and JQuery.

. Developed Views and Partial Views, using Razor view engine and JQuery.

. Experience in development and deployment of windows services.

. Expertise in debugging and troubleshooting existing code.

. Good at impact analysis and reengineering/upgrading of .Net

applications.

. Strong skills in planning and execution of application in MVC and n-

tier architecture.

. Extensive experience in working with Enterprise Application blocks

such as Data Access Application Block, Caching Application Block and

Logging Application Block.

. Extensive experience in Windows Services and in consumption of Web &

WCF services.

. Expertise on ADO.Net components such as Datasets, Data Adapter, Data

Reader, Data View, Data Table and expertise in Web Forms.

. Excellent experience in developing user interfaces using Web forms and

Window forms.

. Good knowledge on IIS 7.0.

. Carried production rollout of SSRS Reports and windows application at

client location.

. Excellent work ethics, Self-Motivated and Quick Learner, willing to

learn new technologies.

Technical Skills

.NET .Net 1.1/4.0, C#, VB.Net, ASP.Net, ADO.Net, Web Forms, Win Forms,

Technologies Windows Services, Web Services, WCF, MVC framework and Enterprise

Library 5.0

RDBMS/Database MS SQL Server 2008 R2, Oracle 11g

Architecture MVC 3.0, N-Tier architecture.

Pattern

Web HTML, CSS, XML, JQuery, JavaScript, Ajax and IIS 7.0,

Technologies

Reporting SSRS (SQL Server Reporting Services)

Operating Win XP, Windows Server 2008 R2, Windows 7

System

Other Tools Visual Studio 2005/2008/2010, Business Intelligence Development

Studio, SQL Server Management Studio, Visual Source Safe, Team

Foundation Server, Toad and Beyond Compare.

Education:

Bachelor of Technology from JNTU, India.

Work Experience

Client: Southern California Edison, Rancho Cucamonga, CA Dec 2012 to Till Date

Project: CMS Reporting

Role: Senior Developer

CMS Reporting: Consolidated Mobile Solutions (CMS) is an asset and work

management system. CMS application works both in connected and disconnected

mode. It has more than 70 screen variants and a separate web portal for

administration purpose. Application has various administration reports and

transaction print reports. The project involved development and deployment

of SSRS reports. Some of the admin reports were scheduled in the SSRS

server in order to automatically generate and email to administrators for

business analysis.

Responsibilities:

. Actively participated in interactions with Business Team, End Users

and third-party vendor to fully understand the requirement of reports.

. Gathered user requirements, draft specs and developed SQL queries and

SSRS Reports.

. Designed and developed Drill-down, Drill through, Summary, Transaction

Print and Sub Reports using SSRS.

. Created an automated deployment package to automatically deploy

reports on 700 tough books which saved time and money.

. Scheduled reports to automatically generate bi-weekly report for

Administrators of CMS Application.

. Generated multi parameterized cascade reports, providing the ability

to narrow down the selection criteria before executing reports, thus

making them user friendly.

. Provided MS SSRS 2008 training to the business and maintenance teams

in order to develop their own ad-hoc reports.

. Deployed reports on Production SSRS Server.

. Installed CMS-Phase-II R1 application on production devices during

production cutover.

. Extended support in CMS Integration Testing.

Environment: SQL Server Reporting Services (SSRS), Business Intelligence

Development Studio (BIDS), SQL Server 2008 R2, SQL Server Management

Studio, WPF and silver light Applications, Windows Server 2008 R2, IIS,

VSS.

Client: Sempra Energy, Monterey Park, CA Oct 2011 to Nov 2012

Project: Energy Management System

Role: Senior Developer

Energy Management System: EMS project involved development, deployment and

integration of reports into web application. The system has various reports

on demand, supply and forecasting areas. Monthly Usage reports were

scheduled to generate on monthly basis and send it to administrators for

analysis. A landing page was created from where user can access and

generate the reports.

Responsibilities:

. Gathered requirements from business users and developed SQL stored

procedures and SSRS Reports.

. Created several SSRS reports like drill down, drill through and sub

reports.

. Managed very large reports that return a large volume of records and

optimized their performance using techniques like cascading parameters

and filters.

. Deployed SSRS reports to the reporting server and assisted in

troubleshooting deployment problems as well as managed the

subscription of the reports.

. Optimized reports by optimizing the embedded queries, Views, or stored

procedures that generate them.

. Converted excel based reports to MS SSRS 2008 reports.

. Involved in full life cycle of Reporting starting from the Authoring

phase, the Management phase all the way to the Delivery phase.

. Successfully installed MS SQL 2008R2 and configured SSRS reporting

server.

. Responsible to support the issues with reports on the enterprise

environments (Development, UAT, Test and Production).

Environment: SQL Server Reporting Services (SSRS), Business Intelligence

Development Studio (BIDS), SQL Server 2008 R2, SQL Server Management

Studio, Asp.Net, C#, Html, Windows Server 2008 R2, IIS, VSS.

Client: AGL Resources, Atlanta, Georgia Jul 2010 to Sep 2011

Project: Service Contractor Portal

Role: Technology Analyst

Service Contractor Portal: Service Contractor Portal is web application

that standardized 3-Year Meter Inspection Process and platform for all

regions within client territory. This system has two SSIS packages that

extract data from Meter history (for 3 Year meter inspections) and CMA (for

meter less risers) databases and creates the records in SCP repository. The

administrator would assign the orders to employees/contractors to perform

and complete the inspection. The SCP application allows Contractors to

download orders in excel format. Once contractors complete the work, they

fill completion details and upload the excel work sheet using Order Upload

screen. The completed information is then sent to various systems viz.,

Mobility/MAD/MH/Click/Repository system to track compliance. Whereas Orders

assigned to employees are sent to Mobility system from where employees

would perform the task. The SCP system has 4 windows services that would

send orders to Mobility/MAD/MH/Click and Repository system. The system also

has various admin reports that connect various data sources and generate

reports.

Responsibilities:

. Prepared BRD document based on MOM received from onsite coordinator.

. Created various admin reports using SSRS that fetch the data from

various data sources and display a summary report.

. Enhanced existing SSRS reports in Meter History system.

. Built prototype of SCP application using WPF for demo and client

approval.

. Built SCP application using MVC 3.0 frame work.

. Designed views using Razor view engine.

. Coding, Unit testing and Integration testing of SCP application.

. Applied JQuery UI themes for all the controls.

. Applied custom sorting/pagination features for the grid view as it had

to deal with millions of records.

. Created 4 windows services for batch processing of various tasks at

the backend.

. Responsible for development of tables, views, stored procedures and

functions in SQL Server 2008 database.

. Remotely installed windows services on production servers.

. Worked with Team Foundation Server as a Centralized Repository.

. Extended support during production implementation.

. Coordination with onsite team.

Environment: ASP.Net MVC 3.0, JQuery, Html, CSS, C#, Windows Services,

WCF, SQL Server 2008 R2, SSIS, SSRS, IIS 7.0, Visual Studio 2010, TFS.

Client: AGL Resources, Atlanta, Georgia May 2009 to Jun 2010

Project: Logica Upgrade

Role: Senior Systems Engineer

Logica Upgrade: The project involves the migration of 'Gas Request' and

'Contractor Portal' web applications to .NET framework 4.0 along with

impact analysis changes for the latest LOGICA product upgrade. The 'Gas

Request' and 'Contractor Portal' web applications are customized .NET

applications built over the LOGICA product as per the AGL business

requirements.

The Gas Request application is used by the AGL business users to carry

out routine business activities. The Contractor Portal application is

intended to provide a separate web interface for AGL contractors to enable

them to work on the assigned work requests, schedule the WR to their crew

members and upload the as built information in to the system.

Responsibilities:

. Analyzed the impact of code migration on the existing environment.

. Upgraded 2 web applications to.NET framework 4.0.

. Reengineered and upgraded a windows service to .Net framework 4.0.

. Migrated Enterprise Library from 1.1 to 5.0

. Replaced obsolete classes with the latest one.

. Upgraded custom and helper dlls to .Net 4.0 framework.

. Coding, Unit testing and Integration testing.

. Coordination with onsite team.

. Implementation support.

Environment: Oracle 11g database, C#, ASP.Net, ADO.NET, Web forms,

JavaScript, Html, CSS, MSMQ, IIS, Windows Services, Visual Studio 2010,

VSS, TOAD.

Client: AGL Resources, Atlanta, Georgia Jan 2007 to Apr

2009

Project: WMIS application Support and Maintenance

Role: Systems Engineer

WMIS application Support and Maintenance: The project involved the

enhancement and maintenance of the Work Management System (WMS).WMS uses

the Asset and Resource Management (ARM) product which is a suite of

integrated applications that help to manage work. The various applications

of this product help in initiating, scheduling and tracking the status of

the work. The system provides the features such as Scheduling tools for

better crew management and job status monitoring, mobile application for

field level data validation, etc. The system also has two wrapper web

applications which interact with the ARM product.

This enhancement and support project involves customization of the

product according to the changing business needs. It also involves

enhancing the features of the web applications which need requirement

gathering, impact analysis, design, build, testing, implementation and

support.

Responsibilities:

. Analyzing and fixing the production defects.

. Involved in modifying and troubleshooting the database tables, SQL

Queries, Views, Packages and Triggers.

. Coding, Unit testing, code review of application.

. Fix and test the defects in SSRS reports.

. Followed 3-Tier Application Architecture to ensure flexible and

reusability of the code.

. Created ASP.NET validation controls and JavaScript validations to

enforce validations.

. Used SQL Server Reporting Services (SSRS) to generate reports.

. Testing various modules of the application and fixing the bugs.

. Coordination with onsite team.

Environment: Oracle database, C#, ASP.Net, ADO.NET, Web Forms, Windows

Services, MSMQ, IIS, Visual Studio 2005, CSS, JavaScript, VSS, SSRS, TOAD.

Client: Florida Power Light, Juno Beach, FL Aug 2005 to Dec

2006

Project: DSRP Maintenance

Role: Systems Engineer

DSRP Maintenance: The DSRP application is aimed at improvement in

performance in distribution, billing and service architecture of our

client. DSRP application is built using 7-Tier architecture. This project

takes care of maintenance, enhancement and tuning of the application. This

enhancement and maintenance project involves customization of the

application according to the changing business needs.

Responsibilities:

. Analysis of production work requests.

. Designing, Coding, Code Review and Unit testing.

. Involved in customizing, testing, debugging and troubleshooting

application.

. Regression testing with RFT tool.

. Coordination with onsite team.

. Preparation of weekly status report for the project.

. Defect Prevention and Configuration Controller activities.

Environment: VB.NET, ADO.NET, Win Forms, Web Services, Oracle, VSS, Visual

Studio 2005, RFT, TOAD, Nant, VITRIA/SAP-PI.

Contact this candidate