Project Sql Server
Resume:
Bhargavi.v.s.cHilakalapudi
SENIOR SYSTEMS ENGINEER WITH OVER 5 YEARS OF WORK EXPERIENCE ON SQL SERVER
& MSBI. EXCELLENT COMMUNICATION WITH EXCEPTIONAL ANALYTICAL SKILLS AND
PROGRAMMING ABILITY.
. Over 5 years of IT Experience specializing in SQL Server and MSBI
applications
. Good Knowledge of T-SQL and MSBI(SSIS,SSRS)
. Experience with Development, Maintenance, and Production Support
Applications
. Complete Knowledge of CMM Level 5 Processes and Software Development Life
Cycle
. Worked with Banking and Consulting Firm related Applications
. Effectively Training and Mentoring the Project Teams (KM Anchor for the
account)
. Configuration Controller for the account(Quality Processes)
. DP(Defect Prevention) anchor for the project
. Exceptional ability to quickly master new concepts and capable of working
in-group as well as independently with excellent communication skills
. Completed Level-1 certification in German Language.
Education
. B.Tech (Bachelor of Technology) in Electronics & Communications from JNT
University, in May 2005.
Work Experience
. Working with Infosys Technologies Ltd., Hyderabad since September 2005.
Currently working as a Senior Systems Engineer.
Skill Set
Programming Languages T-SQL, SSIS, SSRS, C#, ASP.NET
Databases SQL Server 2000, SQL Server 2005
Version Control Tools VSS 6.0
Project Management Tools Microsoft Project
Documentation Tools MS Office, MS Visio
Professional Experience
1. Project: CONNECT Extended Business Support(COE)
Client: Telstra
Role: Business Analyst
Duration: April 2010 till date
Description:
Connect Business administration team, extending support to Telstra Business
processes.
Responsibilities:
. Design of the web applications on regular basis as per the requests from
the user.
. Development (Includes creation of web applications, Databases, Stored
Procedures, Functions, Views, Packages and Reports)
. Testing (Includes preparation of Unit test cases, Unit test reports)
. Regular Business Communication, being a part of CONNECT Business Admin
team.
. Quality Planning & Practice(Conducting CM Audits on a regular basis,
updating IPM+ with
request & defects on a regular basis, conducting Defect Prevention
sessions on a monthly basis and creating DP Causal Analysis documents)
. Project Planning and Organization (Preparation of MPP for the project,
Regular updating of
CM deviation plan as per the changes in the project execution, Weekly
status report to onsite).
. Received Gold medal as a token of appreciation for
the work done in this project.
Environment:
Operating System: Windows XP Professional
Languages: C#, ASP.NET, PL/SQL
Software: Visual Studio 2008, Oracle 10g
Tools: VSS 6.0
2. Project: RAD Files & Annual Reports Automation
(BASEL)
Client: Shinsei Bank of Japan
Role: Module Lead
Duration: February 2008 to March 2009
Description:
Automation of 6 RAD files and 51 Annual reports is done under BASEL - Step
IVa. This includes the automation of various input files, thus eliminating
the manual generation of files.
Responsibilities:
. Design (Preparation of design document including design of 4 data bases)
. Development (51 stored procedures for the generation of 51 Annual
reports and 11 Stored
Procedures for the automation of 6 RAD files)
. SQL jobs to execute the Stored procedures, JP1 jobs for scheduling
. Customized functions for RAD files
. Packages created using SSIS to execute Stored Procedures and reports
formatted and
generated using SSRS
. Testing (Includes preparation of Unit test cases, Unit test reports)
. Business Communication
. Quality Planning & Practice(Conducting CM Audits on a regular basis,
updating IPM+ with
request & defects on a regular basis, conducting Defect Prevention
sessions on a monthly basis and creating DP Causal Analysis documents)
. Mentoring Team
. Project Planning and Organization (Regular updating of CM deviation plan
as per the changes
in the project execution, Weekly status report to onsite)
. Project Estimation (Estimates for the change requests and new
requirements)
Environment:
Operating System: Windows XP Professional
Languages: T-SQL, MSBI (SSIS, SSRS)
Software: Visual Studio (2005, 2008), SQL Server 2005
Tools: VSS 6.0
3. Project: Lead for Step IIc Production Support
Activity Team
Client: Shinsei Bank of Japan
Role: Lead for Step IIc Production Support Activity Team
Duration: March 2007 to December 2007
Description:
Basel II is the second of the Basel Accords, which are recommendations on
banking laws and regulations issued by the Basel Committee on Banking
Supervision. The purpose of Basel II is to create an international standard
that banking regulators can use when creating regulations about how much
capital banks need to put aside to guard against the types of financial and
operational risks banks face.
Responsibilities:
. Business Communication (Involves communicating effectively with the
client and providing support)
. Production Support Activities
. Quality Planning & Practice (Responsible for all the Quality control and
Quality Assurance activities in the project)
. Mentoring Team
Environment:
Operating System: Windows XP Professional
Languages: T-SQL, MSBI (SSIS, SSRS)
Software: Visual Studio 2005, SQL Server 2005
Tools: VSS 6.0
4. Project: EMS(Exposure Monitoring System)
Client: Shinsei Bank of Japan
Role: Developer
Duration: From April 2006 to January 2007
Description:
EMS is a support system to provide data for the presentation layer
requirements. Data comes in as feed from various sources called Product
Processors. This data is then used calculate various balances (present and
future balances) for products of each different processor. It is reconciled
with the GL system and then made available to the presentation layer for
use. The purpose of EMS is to unify all Exposure Monitoring screens.
Responsibilities:
. Requirements study & specification documentation
. Project Estimation
. Design (Preparation of design document including design of data bases)
. Development (35 Stored procedures to fetch data from different systems
and manipulate the data
as per the requirement)
. SQL jobs to execute the stored procedures
. JP1 jobs for scheduling
. Customized functions
. Packages created using SSIS to execute Stored Procedures and reports
formatted and generated
using SSRS)
. Business Communication (Regular interaction with the client)
. Testing (Includes preparation of Unit test cases, Unit test reports)
. Quality Planning & Practice (Responsible for all the Quality control and
Quality Assurance
activities in the project)
. Production Support Activities (Single point of contact for production
support)
Environment:
Operating System: Windows XP Professional
Languages: T-SQL, MSBI (SSIS, SSRS)
Software: Visual Studio 2005, SQL Server (2000,2005)
Tools: VSS 6.0
5. Project: Credit Card Reconciliation
Client: Dunn & Bradstreet
Role: Developer
Duration: From October 2005 to March 2006
Description:
This project is to enhance the existing D&B systems to produce a monthly
reconciliation summary report of the sales transactions on credit card
which is reported to GL via BOLT, and the DFR report from the Payment Tech.
Thus, eliminating the manual monthly reconciliation process.
Responsibilities:
. Requirements study & specification documentation
. Analysis & Preparation of design document
. Development (Coding of 4 COBOL programs and their corresponding JCL's,
writing SQL queries to fetch the data and generate the report in the
required format and location)
. Testing (Includes preparation of Unit test cases,
Unit test reports and Integration testing)
Production Support (Includes providing support to
the client on the reports generated and resolving
issues)
Environment:
Operating System: OS 390, Windows XP Professional
Languages: T-SQL, COBOL, JCL
Software: Toad, Cygwin
Tools: Microsoft Project 2003
Contact Details:
E-mail: *******@*****.***
Phone: 91-800*******/040-********
[pic][pic]
Contact this candidate