SQL developer

POLAKONDA RAO

216-***-**** **********@*****.***

Professional Summary:

> 7.5 years of strong experience in Information technology industry

covering all stages of development life cycle including business

process analysis, requirements gathering and analysis, high level

design, detailed design, development, testing, QA and post

implementation support.

> Excellent experience in design, development, implementation and

administration of database systems using MS-SQL Server 2008/2005/2000

for both OLTP & Data Warehousing Systems applications in Financial,

Wireless and Health industries.

> Extensively experienced in database activities like Maintenance and

Performance Monitoring and Tuning using tools such as Index Tuning

Wizard, SQL Profiler, Troubleshooting and Replication.

> Extensive knowledge in design of logical and physical data modeling

using Erwin tool and consistency check using DBCC utilities.

> Adept in RDBMS concepts and constructs along with Objects creation

such as Database, Table, Normalization, UDF, User Defined Data Type,

Indexes, Stored Procedures, Views, Cursors and Triggers.

> Extensive experience in Data Extraction and Transforming and Loading

(ETL) using DTS package in MS SQL Server 2000 and SQL Server

Integration Services (SSIS) in MS SQL Server 2008/2005 with .NET,

Import/Export data, Bulk insert and BCP.

> Expert in SSIS script transformations using C# Script and scheduling

complex SSIS Packages for transferring data automatically from

multiple data sources to SQL server.

> Expert in Database Normalization, Optimization and Tuning,

Backup/Restore, Data Import/Export, Troubleshooting, and Database

Objects authorization.

> Strong experience in creating various reports like Drill through,

Drill down and Ad-hoc according to the user requirement using SQL

Server Reporting Services (SSRS).

> Experienced in report generation using Crystal Reports, XML, MS Access

and Excel spreadsheet.

> 2 years of extensive Tableau Experience in Enterprise Environment, in

Tableau 6.0, 7.0, 8.0 and 8.1 as a Developer and Analyst.

> Extensive Tableau Experience in Enterprise Environment and Tableau

Administration.

> Strong knowledge of Data Warehousing methodologies and concepts,

including star schemas, snowflakes, ETL processes, dimensional

modeling and reporting tools.

> Experienced with aggregation using OLAP analysis services cube.

> Proficient in implementing surrogate key generation strategy in the

Data warehouse.

> Experienced in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS

packages.

> Organized professional with excellent oral and written communication

skills, excellent presentation, interpersonal skills, problem solving

skills, fast learner and also adept quickly new technology with

ability to take new roles in minimum time and little training.

Education and Certification:

Master's in Computer Sciences, Cleveland State University, OH

Business/Technical Skill:

MS SQL Server 2014/2012/2008/2005/2000, T-SQL, SQL Server Management

Studio, Business Intelligence Development Studio (BIDS), SQL Agent, Data

Transformation Services (DTS), SQL Server Integration Services (SSIS), SQL

Server Reporting Services (SSRS), SQL Server Analysis Services(SSAS), Erwin

Data Modeler, MS Visio, SQL Profiler, Bulk Insert, BCP, Visual Source Safe

Code management tools 6.0., C#, VB.Net, PL/SQL, Oracle 10g/9i/8i, HTML,

XML, UNIX, Windows Server 2008/2003, Crystal Reports XI/X/9.0, MS

Access,PowerPivot,ASP.Net,C#.

Projects Summary:

Grange Insurance, Columbus OH

June14-Present

Grange Mutual Casualty Company, commonly known as Grange Insurance, is an

American insurance company based in Columbus, Ohio. Grange markets its

products exclusively through a network of about 3,600 independent agents to

offer home, auto, life, and business insurance protection to policyholders

Responsibilities:

> Creating SSIS Package configurations for executing in different

environments in SQL Server 2014 using Package Deployment Model.

> Creating ETL SSIS Packages on SQL Server 2014 for Data Warehouse using

Type 4 Slowly Changing Dimension Model

> Fine-tuned SSIS Packages using pipeline processing techniques and

memory buffers.

> Data Cleansing of different data from landing areas to Staging before

performing SCD transformation for loading into FACT and DIMENSION

tables.

> Worked on the development of Dashboard reports for the Key Performance

Indicators for the top management.

> Preparing Dashboards using calculations, parameters in Tableau and

SSRS

AXCIOM Corporation, Conway, AR

Feb 12 - June 14

SQL Server developer (SSIS/SSRS/T-SQL)

Acxiom is an enterprise data, analytics and software as a service company.

For more than 40 years, Acxiom has been a leader in harnessing the powerful

potential of data to strengthen connections between people, businesses and

their partners.

Responsibilities:

> Extensive use of Import/Export wizard to convert T- SQL Queries, Data

and Reports from different forms like XML file, MS Excel file, TTF

file, PDF file and other formats to SQL data type and Vice versa.

> Creation/Modified complex stored procedures which are used for various

reports.

> Used DDL and DML to writing Triggers, Stored procedures to check the

Data Integrity and payment verification at early stages before calling

them.

> Created/Maintained clustered/non clustered Indexes for fast and

efficient reporting process.

> Enhancing and deploying the SSIS Packages from development server to

production server.

> Extensively involved in designing the SSIS packages to export data of

flat file source to SQL Server database.

> Documented the Stored Procedures and User Defined Functions (UDF) for

future references and maintenance.

> Database Objects like Tables, Stored Procedures, Views, Triggers,

Rules, Defaults, user defined data types and functions for this

project.

> Worked with developers to tune the SQL queries using SQL Profiler.

> Used PowerPivot server components to load the data, process queries,

perform scheduled data refresh, and track server and workbook usage.

> End to end experience in designing and deploying data visualizations

using Tableau

> Extensive knowledge in various reporting objects like Facts,

Attributes, Hierarchies, Transformations, filters, prompts, Calculated

fields, Sets, Groups, Parameters etc., in Tableau.

Environment: SQL Server 2008/2005, SSRS, SSIS, Oracle, MS Accesses 2003, MS

Excel 2003, MS Visual Studio 2008/2005,Performance Point Server,

PowerPivot, ASP.NET,IIS

CVS Caremark, Solon, OH

Jan 11 - Jan 12

BI developer (SSIS/SSRS/T-SQL)

Universal American (NYSE: UAM), through our family of healthcare companies,

provides health benefits to people with Medicare. We are dedicated to a

Healthy Collaboration, working together with healthcare professionals in

order to improve the health and well-being of our members. Involving in

maintaining the customer database of customer details and drugs details.

Worked closely with various departments like Collections, Risk and Research

& Analysis for HIPAA Compliance and EDI processing and Data mining

According to Business Requirements and did Sequence Analysis, Deviation

analysis, Regression and Forecasting

.

Responsibilities:

> Creation/Modified complex stored procedures which are used for various

reports.

> Used DDL and DML to writing Triggers, Stored procedures to check the

Data Integrity and payment verification at early stages before calling

them.

> Created/Maintained clustered/non clustered Indexes for fast and

efficient reporting process.

> Enhancing and deploying the SSIS Packages from development server to

production server.

> Extensively involved in designing the SSIS packages to export data of

flat file source to SQL Server database.

> Documented the Stored Procedures and User Defined Functions (UDF) for

future references and maintenance.

> Database Objects like Tables, Stored Procedures, Views, Triggers,

Rules, Defaults, user defined data types and functions for this

project.

> Worked with developers to tune the SQL queries using SQL Profiler.

> Used PowerPivot server components to load the data, process queries,

perform scheduled data refresh, and track server and workbook usage

Environment: SQL Server 2008/2005, SSRS, SSIS, Oracle, MS Accesses 2003, MS

Excel 2003, MS Visual Studio 2008/2005, Windows 2000 Server, DTS Wizards,

Share-point, Dashboard, Performance Point Server,PowerPivot,ASP.NET,IIS

Barclays Capital, Wilmington, DE

Mar 10 - Dec 10

SQL Server BI Developer

Barclays Capital is a global British investment bank. It is the investment

banking division of Barclays plc which has a balance sheet of over 1.2

trillion (2008 BARCAP figures). Barclays Capital provides financing and

risk management services to large companies, institutions and government

clients. It is a primary dealer in U.S. Treasury securities and various

European Government bonds.

Responsibilities:

> Involved in all the phases of SDLC.

> Filtered bad data from legacy system using complex T-SQL statements,

and implemented various types of constraints and Triggers for Data

Consistency.

> Used Stored Procedures for updating Servers.

> Created and Deployed Custom Components in C#.NET .

> Developed, deployed and monitored SSIS Packages including upgrading

DTS to SSIS.

> Used SQL Server Integration Services (SSIS) and its tools to Extract,

Transform and Load data into Data Ware House and for OLTP side.

> Creating and running SSIS Packages for Importing Data from CSV, Pipe

Delimited and Fixed Length Files.

> Responsible for creating log files for SSIS packages, Package

configurations for executing in different environments and Enabled

Check points in SSIS package.

> Created break points in order to view the status of data, variables

and over all status of SSIS package

> Standardized company reports by implementing SQL Server Reporting

Services (SSRS).

> Created various dynamic reports using SSRS.

> Designed and developed parameterized reports, linked reports, matrix

and tabular reports with drill down, drill through and drop down menu

option using SSRS.

> Developed and Deployed different types of Reports like List, Matrix,

and Chart and Sub Reports etc.

> Creation/Modified complex stored procedures which are used for various

reports.

> Used DDL and DML to writing Triggers, Stored procedures to check the

Data Integrity and payment verification at early stages before calling

them.

> Created/Maintained clustered/non clustered Indexes for fast and

efficient reporting process.

> Enhancing and deploying the SSIS Packages from development server to

production server.

> Documented the Stored Procedures and User Defined Functions (UDF) for

future references and maintenance.

Environment: SQL Server 2008/2005, SSRS, SSIS, Oracle, MS Accesses 2003, MS

Excel 2003, MS Visual Studio 2008/2005, Windows 2000 Server, DTS

Wizards,C#.NET

Foresight Financial, Bridgewater NJ

Feb 09 - Feb 10

SQL Server Developer (SSIS/SSRS)

Foresight Financial is a financial services firm specializing in retirement

savings and providing other services like Life/Business Insurance.

Foresight Financial is a leading international insurance organization of

commercial and industrial insurance in the US. The purpose of our project

was to build data warehouse for Life Insurance.

Responsibilities:

. Worked as a database developer on databases like MS SQL Server

2008/2005 using T-SQL, stored procedures and views to get data from

Data warehouse to Data marts.

. Created SSIS Packages using Lookup, Merge, Sort, Derived Columns,

Condition Split, Aggregate, Execute SQL Task, and Data Flow Task,

Execute Package Task etc to generate underlying data for the reports

and to export cleaned data from Excel, Text file and MS Access to

different data Marts.

. Performed Incremental load with several Dataflow tasks and Control

Flow Tasks using SSIS.

. Configured Connection Manager Files and CMD files for SSIS packages to

dynamically execute on QA Server and Production server

. Migrated SSIS 2005 packages to SSIS 2008 packages.

. Developed Master Child package using variables and Execute package

task in SSIS.

. Deployed, Tested and Scheduled SSIS packages using SQL Agent.

. Designed and deployed reports with Drill Down, Drill Through and Drop

down menu option and Parameterized and Linked reports.

. Developed, deployed and monitored SSIS Packages including upgrading

DTS to SSIS.

. Used SQL Server Integration Services (SSIS) and its tools to Extract,

Transform and Load data into Data Ware House and for OLTP side.

. Deploying and scheduling Reports using SSRS to generate all daily,

weekly, monthly and quarterly Reports including current status.

. Created report models for ad hoc reports and deployed on report

server.

. Generated test data and tested database to meet the functionalities

deliverables in the project documentation and specifications

. Developed incremental loading using MERGE statement in SQL server

2008.

. Improved Performance by creating Clustered and Non clustered Indexes

and by Optimizing the T-SQL statements using SQL profiler

. Used Execution Plan and Database Engine Tuning Advisor to optimize

queries and enhance the performance of databases

. Successfully tested all task in staging and stored all versions of

data using team foundation server (TFS).

Motorola Inc, Chicago IL

July 07 - Dec 08

SQL Server BI Developer

Motorola, Inc. (NYSE: MOT) has been at the forefront of communication

inventions and innovations for nearly 80 years. Motorola develops a

portfolio of technologies, solutions and services - including wireless

handsets, wireless accessories, digital entertainment devices, wireless

access systems, voice and data communications systems, and enterprise

mobility solutions

Responsibilities:

. Actively participated in interacted with users, team lead, DBAs

and technical manager to fully understand the requirements of the

system.

. Worked on the Reports module of the project as a developer on MS

SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and

views).

. Generated Monthly and quarterly Reports as bar charts for the

management using different techniques like data filtering, adding

interactivity, deploying reports to report server using SSRS.

. Created UDM for cubes in SSAS.

. Generated pivot tables using the cube data in SSAS and delivered

reports using SSRS by using the connection string as SSAS.

. Created reports from OLAP, sub reports, bar charts and matrix

reports using SSRS.

. Deployed the reports in to the report server.

. Involved in creating Data mappings in SSIS and created data models

using ERWIN tool.

. Use DTS/SSIS and T-SQL stored procedures to transfer data from OLTP

databases to staging area and finally transfer into data marts and

performed action in XML.

. Involved in building of OLAP cubes with SSAS and in adding

calculations using MDX.

. Preparation of documents and class diagrams using VISIO.

. Developed, deployed and monitored SSIS Packages including upgrading

DTS to SSIS.

. Involved in Creating SSIS Packages for Importing Data from CSV,

Pipe Delimited and Fixed Length Files.

. Creating and running SSIS Packages for Import and Export of

Heterogeneous Data.

. Worked on DTS/SSIS for transferring data from Heterogeneous

Database (Access database and xml format data) to SQL Server.

. Used SQL Server Integration Services (SSIS) and its tools to

Extract, Transform and Load data into Data Ware House and for OLTP

side.

. Responsible for creating log files for SSIS packages.

. Involved in creating SSIS Package configurations for executing in

different environments.

. Enabled Check points in SSIS package.

. Created break points in order to view the status of data, variables

and over all status of SSIS package.

. Wrote custom T-SQL stored procedures and triggers to improve

performance, preserve referential integrity, and provide additional

application functionality.

Environment: SQL Server 2005, SSIS, SSRS, SSAS, XML, Windows 2003/2000

Server, Visual Studio 2005

Vertex Pharmaceuticals Inc, Coralville, MA

May 06-June 07

SQL Server Developer/SSIS/ SSRS

Vertex is a research-based global pharmaceutical company. vertex discovers,

develops, manufactures and markets leading prescription medicines for

humans and animals, as well as many of the world's best-known over the

counter medicines and consumer health products

Responsibilites:

. Developed complex T SQL code for the application.

. Modified the existing database by adding the tables and maintained

relationships between the tables.

. Used complex query statements like sub queries, correlated queries,

derived tables, CASE functions to insert the data depending on the

criteria into the tables of hub.

. Enhanced the business logic using User Defined Functions to

retrieve information on the services like billing, customer, and

requests from the residential, business and large business

databases.

. Created SSIS Dynamic Packages using variables and deployed the SSIS

packages.

. Implemented Incremental loads using different kind of tasks using

SSIS.

. Used Event Handlers for Exception Handling in SSIS packages.

. Generated periodic reports based on the statistical analysis of the

data using SQL Server Reporting Services (SSRS).

. Created, Managed and Support existing reports using SSRS.

. Involved in creating, deploying and configuring reports according

to the requirements using SSRS.

. Developed different types of Tabular Reports, Matrix Reports, Drill-

Down, Cross Tab Reports, Ad hoc reports and distributed reports in

multiple formats using SQL Server Reporting Services (SSRS) in

Business intelligence development studio (BIDS).

. Developed cubes using SSAS involving multidimensional data.

. Supported various sectors like Development, testing, Production,

Maintenance and Application teams.

. Conducted performance tuning by using SQL Profiler, Data Engine

Tuning Advisor and index tuning wizard.

. Executed Test cases manually Using Quality Center.

. Maintained the client relationship by communicating the daily

statuses and weekly statuses of the project.

. Managed requests that came from the development team.

Environment: MS SQL Server 2005, ASP.Net, Management Studio, BIDS, Visual

Studio 2005, MOSS, Integration Services, SSRS, SSAS, T-SQL, DTS, ETL, XML,

SQL Profiler, Windows 2003.

State Bank shares Corp, India.

Jun 04 - Apr 06

Database Developer

State Bank shares Corp. is the holding company for State Bank of India, the

second-largest banking institution in India head quartered in Mumbai. With

$6.36 billion in assets, it has 248 branches in south India, Uttar Pradesh,

and Maharashtra etc.

Responsibilities:

. Implemented a well-planned backup and restore strategy that

protects databases against data loss

. Responsible for design, development and implementation of

mappings/transformations based in source-to-target specifications,

defining ETL(extract transform, load)

. Developed complex SQL queries, stored procedures, and DTS packages

. Involved in complete SDLC, which includes requirement gathering,

analysis, design, development, Implementation.

. Involved in designing and writing Stored Procedures, functions and

packages using T-SQL for SQL Server 2000

. Used DBCC utilities to fix data corruption in application databases

. Development of Business rules implemented as Constraints, Triggers

and or Stored Procedures

. Developed reports using Crystal reports.

Environment:

SQL Server 2000 Enterprise, Windows Enterprise Server 2003, Erwin,

Microsoft Visio, DTS, SQL Profiler, Query Analyzer

Contact this candidate