Sql Server Management

Sony Pandi

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

Service Release Manager, Business Analyst,

Application Analyst. Phone: +1-408-***-****

Experience: 5.5 Years

Education

Bachelor of Technology, 2005

Areas of Expertise Industry Sectors

Energy & Utilities (Gas

Customer / Client Management

Distribution)

Release Management

Microsoft Service

Entire Software Life Cycle: Gathering requirements, Solution Design, Coding,

Transition Management.

Test Management, Implementation, Handover, Maintenance and Support

Release Planning & Implementation in Business Intelligence Portfolio.

Business Analysis, Comprehensive Problem Solving

Response (Bid) Management, Excellent Presentation and Documentation skills.

Team Management

Work Summary

Wipro Technologies (Jul’2005 – Feb’2011)

Project Management Tools Technology & Tools Third Party Products

Highly creative presentations Process Modelling Tools: InfoPath, MS Visio Maconomy – mostly

using PowerPoint used product in Utilities

Development/Productivity Tools: Unix Shell

Industry.

Estimations using WBS and scripts, VBA, Visual Basic and Microsoft

Function Point Visual Studio.NET, ASP. ITSM – IT Service

Management.

Thorough Documentation Databases: SQL server 2000, SQL server

using Microsoft Word 2005, SQL Server 2008.

Data Warehousing: Business Objects

Reporting Tools: Crystal Reports, DTS, SSIS

and SSRS.

Selected Achievements

Have won more than one million USD worth projects for Wipro Technologies

Sony Pandi +1-408-***-****

Outstanding Performer and Received customer awards from Microsoft (associated with Microsoft) and Fulcrum

(previous customer) Microsoft IT star and Fulcrum Star awards respectively.

Received number of Wipro internal awards.

Received many commendations from Customers as well as WIPRO Management for brilliant contribution as part of

various projects.

Professional Experience

Release Manager

Last Assignment: for BI and HR Release Management – Microsoft, Hyderabad

Organisation: Wipro Technologies; Duration: 7 Months; Team: 19; Location: Hyderabad, A.P., India

About the Programme: Service Transition BI & HR Release Management is one of the main Microsoft Business

units. Responsible for Implementing & managing the releases of about 70 applications in BI and HRE Portfolio.

My Contributions: Key responsibility lies in Managing & leading the team to successfully deliver each and every

release.

Facilitate successful Release of code from Engineering to Production by Proactively & Re actively working

with Development, QA and Operations.

Management of the release pipeline, scheduling and prioritizing release.

Negotiate Release issues and schedules with internal customers and report status to Business

Stakeholders.

Lead cross functional teams to support the project, including risk management and mitigation strategies.

Coordination of issues across Projects, ensuring work achieves outcome specified by the Business.

Maintaining/Tracking all the release related activities in IT service management (ITSM).

Monthly/Yearly Releases Plan & Report delivery to Business.

Implementation Manager/Consultant

for BI Release Management Microsoft, Hyderabad

Organisation: Wipro Technologies; Duration: 18 months; Team: 19; Location: Hyderabad, A.P., India

About the Programme: Service Transition BI Release Management is one of the main Microsoft Business units.

Implementation team is mainly responsible for Implementing the releases of about 40 applications in BI Portfolio in

UAT and Production.

My Contributions:

Sony Pandi +1-408-***-****

Negotiated and resolved Release issues between different internal organizations as well as managed Release

of code from Engineering to Production.

Introduced the standard process for Release Implementations to minimize the customer impact.

Facilitated customer focused solutions between Support and Engineering

Became main trouble shooting resource for IIS and MS SQL Server based application running on .NET.

Supported and worked on core IIS and MS SQL Server based applications that included integrations with

Reporting tools.

Lead Multiple projects to run on Virtual Servers

SQL Migrations from SQL 2000 to SQL 2008.

Managed Technical Projects to completion as well as communicated status to management.

Created internal Knowledge Base and provided technical training to employees

Business Analyst for New Business Model Monitor for Fulcrum, UK

Organisation: Wipro Technologies; Duration: 8 months; Team: 7; Location: Coventry, UK

About the Programme: “The NBM Monitor Programme – expanding the way we do business”. As per Fulcrum

Business Model, all the Quotations (who will request for domestic/non domestic Gas connection) will be raised in

Maconomy (third party product) Portal. Though this system was able to capture each status. But to facilitate the

users with minute statuses and to make more users friendly, NBM Monitor Programme was developed. Basically

Tracks everything for every single quotation till closure.

My Contributions:

During short stint in Fulcrum New Business Model programme, I became productive by understanding the

business requirements and provided significant support during the design phase.

Clearly understood the Business need by closely working with them & provided this solution to Business. It

had won more than one million USD worth Project for Wipro Technologies.

Requirements Analysis, Design, Development, Testing & Implementation.

Technical Documentation along with pseudo code.

Usage of DTS, SSIS Reporting tools and worked on .NET and SQL 2005 Technologies.

Business Analyst/Project Lead for Xplora Fulcrum, UK

Organisation: Wipro Technologies; Duration: 7 months; Team: 6; Location: Coventry, UK

About the Project: Fulcrum was formerly an integrated part of National Grid UK, which also works in execution of

the Gas Quotations. Upon separation from National Grid, Fulcrum started processing the jobs from their end. Since

these quotations were already raised in National Grid quotation system, some reference has to be associated with

them to identify, (as there will be many number of service provider contract Quotations) and to process them in the

Fulcrum Systems. To assign the unique reference and processing the quotation, this application was developed and

vastly used by Fulcrum/Non Fulcrum users. It involves assigning the Meter Point Reference, Processing the

Quotation generation of letters that will be sent to the Customers.

My Contributions: My key responsibilities included

Sony Pandi +1-408-***-****

Managing multiple workshops with clients during the course of Requirements & Design.

Requirements Analysis, Design, Development, Testing & Implementation

Tactical Design till implementation before actual GO LIVE

Development & Technical documentation along with pseudo code.

Implementation of Data Migration from Oracle to SQL Server – Made the Plan and executed successfully.

Conducted workshops and provided Training to Business.

Support/Business Analyst for Fulcrum Application Support for Fulcrum, UK

Organisation: Wipro Technologies; Duration: 24 months; Team: 25; Location: Coventry, UK and Hyderabad,

A.P., India.

About the Project: Fulcrum was formerly an integrated part of National Grid, but separated on 1 July, 2001. Wipro

was chosen to assist Fulcrum in its separation from NG. This involved areas like IS Strategy, Package selection,

Requirement Analysis, Planning and Implementation covering almost the entire Software Development lifecycle.

The present project scope includes First line support for all 3rd Party Applications and end to end support for

bespoke applications and Interfaces. Also includes the Regression Analysis, Testing and Implementation of

changes to Fulcrum systems. Provide project support for C3 developments like CSOS4, Blackwater and other

activities in the Fulcrum roadmap. Manage the implementation of patches and based application solutions to

Fulcrum production systems. Facilitate the Rapid Application Development (RAD) facility either by using the existing

resources or by deploying the additional requirements based on the efforts and timelines required.

My Contributions:

Performing regular maintenance activities, Remote resolution of business user issues.

Customized and Supported 3rd party applications according to Fulcrum Business Model.

Automation to many daily health check & error details reports

System impact analysis to plentiful small scale and large scale change requests

Provided proactive proposals to benefit the customer.

Analyse and create DTS and SSIS Packages according to the requirements in SQL Server.

Migrations – From SQL 2000 to SQL 2005, From DTS to SSIS.

Requirements Analysis, Design, Development, Testing & Implementation for Adhoc/Bespoke applications.

Data Migration from NG Quotations to Fulcrum Quotations.

Worked on Technologies .NET, SQL Server 2000, SQL Server 2005, Visual Basic.

liaising with Business, Vendors, IS

Offshore Coordination – Explain the requirement to Off shore, Offshore Delivery Review, Test Management,

Post Implementation Support.

Creation of Contingency environments. Failover and Fail back Plan and activities

Developer for Network Billing Solution for Fulcrum, UK

Organisation: Wipro Technologies; Duration: 5 months; Team: 25; Location: Coventry, UK and Hyderabad

Sony Pandi +1-408-***-****

About the Project: Fulcrum (was formerly an integrated part of National Grid) undertakes the work on behalf of the

Networks to be done for the end customers. Fulcrum needs to bill the Networks at the end of the month (or invoice

period as defined) for the work they have done. Network Billing System provides a process to generate the invoice

and accruals. They are generated and stored in a configurable location. The finance user(s) have to will send same

to the corresponding Network Owners. This system would also give the feasibility to invoice the legacy jobs as well.

This system would allow this data to be imported into the system and generate the invoice along with the Fulcrum

(Maconomy) jobs.

My Contributions:

Requirements gathering and analysis phase. Technical documentation along with Pseudo code.

Developed batch programmes Stored Procedures and cursors in SQL Server200/SQL 2005.

Carried out Unit Testing and System Testing.

Development for web modules – ASP and ASP.NET.

Personal Details

Name Sony Pandi

Date of Birth 8thth August 1984

Sony Pandi +1-408-***-****

Sony Pandi +1-408-***-****

Contact this candidate