Sql Server Project

RESUME

Email:

******.****@*****.***

Ramya Krishna G

Mobile: 897*******

[pic]

Career Objective:

I am looking for a good position in the field of Microsoft

Business Intelligence in a prestigious company where previous skills

and capabilities can be put to efficient use. I possess effective

organizational skills and the ability to work for a team and develop

the final output.

Summary of Skills:

. Having 3+ years of IT experience in the area of MSBI Tools like SQL

SERVER,SQL Server Integration Services (SSIS) and SQL Server Reporting

Service (SSRS).

. Having good knowledge in stored procedures, indexes, Sub Queries,

joins, views, functions, constraints.

. Extensive experience in data extraction, Transformation and loading

(ETL) from SQL Server, Excel and Flat Files using SSIS.

. Used Control Flow Tasks like For Loop Container, For Each Loop,

Sequential Container, Execute SQL Task, FTP Task and Data Flow Task in

Designing packages.

. Proven proficiency at Data Transformations like Lookup, Derived Column,

Conditional Split, sort, data Conversion, Union All, Merge Join, SCD.

. Experience in providing Error Logging and Error handling for SSIS

Packages.

. Having good knowledge on creation and scheduling of SQL server agent

jobs to run daily ETL's Working with Integration Services package

development and deployment.

. Creating report with components like tables, matrix, charts.

. Involved on Report Design, Development and Deployment using SSRS.

. Designed different Types of reports like Drill Down, Drill Through, Sub

Reports and Parameterized Reports.

IT Skills:

Operating systems : Windows XP, 7

Technologies : Microsoft Business Intelligence

Tools

Databases : SQL server 2005/2008R2

ETL Tool : SQL server Integration services

Reporting Tool : SQL server Reporting Services

Educational Qualification:

Bachelor of Electronic And Communications Engineering, JNTU

Ananthapur.

Organizational Experience:

Project 1:

Organization : UST Global

Project Name : Retail sales Analytics

Client : Trillion-Mind

Duration : June 2013 till now

Designation : SQL server and Report Developer

Project Description:

The company is a leading provider of personal finance

(Quicken), small business accounting (QuickBooks), and consumer tax

preparation (TurboTax) software for consumers, accountants, and small

businesses. Other software offerings include industry-specific

accounting and management applications for construction, real estate,

retail, and wholesale distribution organizations. It also provides

payroll services, financial supplies, and software for professional tax

preparation and information technology asset management. It Company is

going in for an enhancement and bug fixing of their Business processes

spanning across Financials, Manufacturing and Customer Relationship

Management.

Responsibilities:

. Expertise in providing T-SQL statements like stored procedures,

indexes, joins, views, functions, constraints.

. Extensively working in Data Extraction Transformation and loading from

source to target system using SQL Server 2005 Integration Services.

. Creating SSIS Packages by using different data Transformations like

Derived Column, Lookup, Data Conversion, Conditional Split, merge,

merge join, Union all and Execute SQL Task to load data into Database.

. Developed Tabular, Matrix and Chart Reports by using SQL Server 2008

Reporting Services.

. Creating users and assign roles for the deployed reports using report

manager.

. Created various Drill Down, Drill Through reports and Sub-Reports as

per project and business requirements.

. Written complex stored procedures and ad hoc queries in T-SQL, creating

report templates, performance tuning of the reports and administration

of the Report Manager.

. Generated the Reports Weekly and Monthly basis as per the Client

Requirements.

* * * * * * * * * * * * * * * * * * *

Project 2:

Organization : TCS.

Project Name : E-TMS.

Client : Northern Trust.

Duration : May 2012 to June 2013.

Designation : Software Engineer.

Project Description:

TMS stands for Transport management system. This is a tool

which primarily comprises of web based interaction for rostering,

enabling each individual to roster themselves. It also Helps the

transport team, in routing, tracking, billing and MIS.

Responsibilities:

. Creation of packages using SSIS to load data into Data ware house from

different sources.(Excel,sql server).

. Created transformations and mappings using data flow tasks.

. Development of mappings according to the ETL specifications for the

staging area data load & warehouse data load using Integration Services

& Sql Server 2008.

. Used transformations like Derived Column, Conditional Split, Aggregate,

Row Count, Lookup, sort, Data Conversion and Script Task to load data

into Data Warehouse.

. Creation and scheduling of ETL Packages Using SQL Server Management

Studio.

. Developed and maintained ETL processes & SSIS packages to consolidate

data from other business units and departments (Excel, SQL server).

. Creating and scheduling jobs for SSIS Packages.

* * * * * * * * * * * * * * * * * * * * * *

Project 3:

Organization : TCS.

Project Name : Bhoomi.

Client : GOK & NIC.

Duration : April 2011 till May 2012.

Designation : Software Engineer.

Project Description:

BHOOMI, the land records management systems is the

first e-Governance project

successfully implemented for the benefits of the common man,

jointly by the GOK & NIC,

Karnataka. It has been providing service to more than 70 lakh

farmers of Karnataka since

the last year. BHOOMI has become the model for replication in

many other States. It has

received wide spread recognition by public and also won

international award.

Responsibilities:

. Monitoring Database health, replication and backup.

. Managing transaction log and data file size growth and shrinking of the

databases.

. Trouble shooting database issues and User management.

. Installing Sql server 2005 and configuring the databases.

. Scheduling backup polices, taking the backups on weekly and monthly

basis, monitoring of backups.

. Participate in development plan, assess and estimate the database

development work.

. Analyze, rectify and giving the technical clarification to team.

. Participated in user testing of the new release of Bhoomi and other

related exes.

. Analyze the end users application problem and cross check with the

database according to the problem and giving solutions the user.

* * * * * * * * * * * * * * * * * * *

Contact this candidate