Tallapally

312-***-****

acpaum@r.postjobfree.com

[pic]

SUMMARY:

. 7+ years of MS SQL Server Development experience with expertise in MS SQL

Server 2012/2008R2/2008/2005/2000 and Microsoft's suite of products like

SSIS and SSRS.

. Highly experienced in Creating, Configuring and Fine-tuning ETL workflows

designed between Homogenous and Heterogeneous Systems using SSIS of MS

SQL Server 2008R2, MS SQL Server 2008 and MS SQL Server 2005

respectively.

. Experienced in creating complex SSIS and DTS packages for ETL purposes.

Implemented complicated transformations to be used in SSIS packages.

. Expertise in Data Conversion, Normalization and Data Modeling, Multi-

Dimensional Modeling and involved in creation of Fact Tables, Dimension

Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.

. Proficient in creating On-demand and Scheduled reports, handling sub

reports and defining query for generating drill down reports using MS SQL

Server Reporting Services 2008R2/2008/2005 (SSRS).

. Experienced with client server application where XML feeds were consumed

and Store Procedures were called using ADO.NET

. Experienced in writing Parameterized Queries for generating Tabular

reports and Sub reports using Global variables, Expressions, and

Functions, Sorting the data, Defining Data sources and Subtotals for the

reports using SSRS 2008R2/2008/2005.

. Strong experience in Stored Procedure, Formulated Stored Procedure/TSQL

/MySQL coding, Performance Tuning and Query Optimization.

. Highly proficient in the use of T-SQL for developing complex Stored

Procedures, Triggers, Tables, User Defined Functions, views, indexes,

user profiles, Relational Database models, Data integrity, query writing

and SQL joins.

. Expert in using tools such as Bulk Copy (BCP).

. Extensive knowledge in developing and implementing Disaster Recovery

Model, and Replication Models.

. Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows

Performance for monitoring and tuning SQL Server performance.

. Excellent communication and inter-personal skills with ability to develop

creative solutions for challenging client needs using agile

methodologies.

. Ability to handle multiple tasks and responsibilities independently as

well as a proactive team member.

Education: Bachelor's Degree from Osmania University, India.

TECHNICAL SKILLS:

MS SQL Server MS Access, Transact-SQL (T-SQL), MySQL, PL/SQL, XML, MS SQL

Tech: Server Integration

Service (SSIS), MS SQL Server Reporting Service (SSRS),

SQL Profiler, SQL Query Analyzer, Visual Studio 2008/2005/2012,

DTS SQL Developer, ERWIN, Windows Server- 2008/2003/NT/XP/2000,

Windows vista.

Operating System: Windows XP/Vista/2000/Server 2003/2008/ Unix

Database: Microsoft SQL Server 2000/2005/2008 R2/2012, Oracle

11g/10g/9i/8i, MS Access

Microsoft Tech: C#.NET, VB.NET, Visual Basic

Internet: ASP.NET 3.0/2.0/1.1, XSLT, XML, HTML, DHTML, CAML

Reporting Tools: Crystal Reports 9/10, SSRS, SSIS, SSAS

ETL Tools: DTS, MS SSIS (SQL Server Integration Services)

MS Servers: IIS 5.0/6.0/7.0

Tools and IDEs: Microsoft InfoPath 2003/2007, Visual studio 2003/2005/

2008/2012, CSS, AJAX, UML, Windows PowerShell.

Frameworks: .NET Framework 3.5, 2.0 and 1.1

Version Control VSS 6.0, VS, Team Foundation Server

tools:

Scripting JavaScript, VBScript, CSS

Languages:

PROFESSIONAL EXPERIENCE:

Client: Frontier Communications, Dallas, TX

Aug 2014 - Till Date.

SQL BI Developer (SSIS/SSRS)

Project: At Frontier Communications I am part of 3rd tier support group and

involved in the development of packages in SSIS. The main objective of the

project was to receive package scans from MQ server and collect data from

various database sources to perform analysis and then integrate them with

the existing systems with SSIS and create reports using SSRS.

Responsibilities:

. Worked with business stakeholders, application developers,

production teams and across functional units to identify business needs

and discuss solution options.

. Agile methodology was used throughout the project, Performed pivotal role

in planning and developing as well as aligning with the assigned sprints.

. Developed and deployed SSIS packages for ETL from OLTP and various

sources to staging and staging to Data warehouse using For Each Loop

Container, Execute Package task, Execute SQL Task, Sent Mail

task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly

Changing Dimension and more. Performed ETL mappings using MS SQL Server

Integration Services.

. Supported Production Environment with schedule the packages and make the

package dynamic with SQL Server Package Configuration.

. Designed high level ETL/SSIS architecture for overall data transfer from

the OLTP to Data warehouse with SSIS and also prepared ETL/SSIS mapping

processes and maintained the mapping documents.

. Integrated data from SQL Server Parallel Data Warehouse (PDW) with data

from Hadoop

. Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract,

transform and load data into database using Lookup, Fuzzy Lookup, Derived

Column, Conditional Split, Slowly Changing Dimension (SCD) to perform

Data Scrubbing, including data validation checks during Staging, before

loading the data into the Data warehouse

. Wrote complex SQL/MySQL queries using joins, sub queries and correlated

sub queries to retrieve data from the database.

. Created/Updated database objects like tables, views, stored

procedures, function, packages.

. Designed Change data capture to capture insert, update, and delete

activity applied to SQL Server tables, and to make the details of the

changes available in an easily

. Rigorously tested and debugged the Stored Procedures and used Triggers to

test the validity of the data after the insert, update or delete.

. Deployed reports on Report Server and SharePoint Server also scheduled

reports using SSRS to generate all daily, weekly, monthly and quarterly

reports including current status.

. Developed and delivered dynamic reporting solutions using MS SQL Server

2008 Reporting Services (SSRS).

. Migrated and recreated existing Dimensions and Cubes using Star schema on

2005 Server to achieve the efficiency of SQL Server Analysis (SSAS)

. Involved in monitoring and tuning report performance by analyzing the

execution plan of the report.

. Generated Drill down, Drill through, Matrix Reports, parameterized

reports, cascading parameterized Reports using SSRS.

. Designed and developed monthly, quarterly and yearly reports at branch

and company level.

. Involved in table and for index partitioning performance and

Manageability.

. Identified, tested, and resolved database performance issues (monitoring

and tuning) to ensure database optimization.

. Designed and developed OLAP Cubes and Dimensions using SQL Server

Analysis Services (SSAS).

. Monitored the overall performance of the database to recommend and

initiate actions to improve/optimize Performance.

. Used SQL Server Profiler to trace the slow running queries and the server

activity.

Environment: SQL Server 2012/2008R2, SSAS, Server Integration Services

2012, SQL server Reporting Service 2012, Microsoft Visual Studio, SQL

Server Management Studio, IIS, MS Excel, T-SQL,ERWIN 7.2, C#

Aon Benfield: Bloomington, MN

Mar 2013 - July 2014

SQL BI Developer (SSIS/SSRS)

Project:

As a result of the merger between Aon and Benfield, Aon moved to

standardize all of their reinsurance business to use their customized

reinsurance application worldwide. Aon Benfield wanted a re-usable,

repeatable process to migrate data from a wide variety of source systems

directly into this application. The main objective of the project was to

load data into the main OLTP database from any legacy systems.

Responsibilities:

Involved in interacting with the user's for new/change requirements, for

designing, developing, and testing solutions to meet these requirements.

. Created Star schema dimensional modeling for the data mart using Visio

and created dimension and fact tables based on the business requirement.

. Gathered report requirements and determined the best solution to provide

the results in either a Reporting Services report or an Excel pivot table

. Designed SSIS packages to Extract data from different sources like SQL

server 2012/2008R2,MS Excel, MS Access, transform and then load

into Dimension and Fact tables in Data Warehouse using SSIS .

. Migrated data from Development to UAT servers and deployed packages to

different servers.

. Designed and developed SSIS ETL/SSIS packages to validate, extract,

transform and load data from OLTP system to the Data warehouse and Report-

Data mart.

. Applied various data transformations like Slowly Changing Dimension,

Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and

Derived column etc.

. Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived

Columns, Conditional Split, Aggregate, Execute SQL Task, Data Flow Task,

and Execute Package Task etc. to generate underlying data for the reports

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

and CSV files to data warehouse.

. Wrote complex SQL/MySQL queries using joins, sub queries

. Designed cubes with star schema using SQL Server Analysis Services

(SSAS).

. Understanding the OLAP processing for changing and maintaining the

Warehousing Optimizing Dimensions, Hierarchies and adding the

Aggregations to the Cube.

. Experience in SQL Server Analysis Services (SSAS) for data mining to

identify rules and patterns in the data.

. Developed SSIS packages using for each loop in Control Flow to process

all excel files within folder, File System Task to move file into Archive

after processing and Execute SQL task to insert transaction log data into

the SQL table

. Produced operational reports in SSRS 2012/2008R2 i.e. drills-down, drill-

through, dash board and matrix reports.

. Developed OLAP cubes using SSAS (SQL Server Analysis Services) and

calculate the metrics that were revealed in the functional analysis

. 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

. Converted manual reports pasted together into parameter driven stored

procedures to be used with Microsoft Reporting Services 2012/2008R2

. Attained legacy data to use as a source to develop new reports previously

compiled and maintained manually

. Translated XML Input file data to another XML from consumed by UI.

. Developed functional and technical documentation to assist in the design,

development and/or maintenance of deliverables

. Responsible for managing BI environment, which includes Business model,

Data Model, Data sources, ETL/SSIS tools, target data warehouse, Data

marts, and Reporting tools.

. Created SSRS Data Model projects using Microsoft Visual Studio 2010/2008

and using Report Builder for report server to create reports

. Configured the report server and generated the report models for user

interactions

. Responded to ad hoc requests and special projects that require immediate

attention while at the same time maintaining deadlines on existing

requests.

. Developed and maintained system documentation, diagrams and flowcharts.

. Worked with project manager and technical leads for resolution of

technical issues.

Environment: MS SQL Server 2012/2008R2, SQL server Reporting Services

2012/2008R2, SQL Integration Services 2012/2008R2, SSAS, SSRS Microsoft

Visual Studio 2010/2008, IIS, SQL Server Management Studio, Java Script,

MS Excel, T-SQL.

Client: Caterpillar Financial, Nashville TN

Oct 2011 - Feb 2013

SSIS/SSRS Developer

Project:

Caterpillar Financial Services Corporation is the financial arm of

Caterpillar Inc., a technology leader and the world's largest manufacturer

of construction and mining equipment, natural gas and diesel engines, and

industrial gas turbines. The project Involved in planning & administration

of the entire migration and system performance also worked on tuning the

system to achieve optimization of system resources

Responsibilities:

. Worked on the complete life cycle of the project from design to

implementation

. Translated user requirements into functional and technical requirements

in coordination with the Sr. Business Analyst

. Executed Store Procedures using ADO.NET framework.

. Analyzed the business requirement and functional specifications provided

by the data specialist

. Worked on SSIS for transferring data from Heterogeneous Data format to

SQL Server.

. Developed SSIS packages using Change Data Capture (CDC) functionality

using complex stored procedures, Execute SQL Task and Data FLOW Task in

Control Flow and OLE DB Source, Script Component Transformation and OLE

DB Destination in Data Flow.

. Migrated few Oracle sources to SQL server development environment.

. Developed SSIS Packages using Lookup Values & implementing rules provided

by Business in the mapping document.

. Developed SSIS packages using Fuzzy Lookup and Fuzzy Grouping for data

cleansing purpose.

. Used SSIS Variables for storing the values which are used in various

components of Data Flow Task.

. Developed Unit Test Plans for SSIS packages for checking the

functionality of each component.

. Modified the existing SSIS packages to meet the changes specified by the

users.

. Scheduled Jobs for executing the stored SSIS packages which were

developed to update the database on Daily basis

. Worked with Inbuilt Transformations in SSIS ETL/SSIS like Persistent

Lookups to enhance performance for lookups and more utilization of I/O

resources.

. Documented the complete data warehouse environment, including all

dimension and fact tables, the relationship between SSIS packages and the

target tables, which packages were valid and in use, the relationship

between the jobs and SSIS packages.

. Designed and maintained a wide variety of daily, weekly, and monthly

financial and analytical reports used by different departments within the

company.

. Accountable for making sure reports are scheduled and delivered in a

timely manner.

. Designed reports using proper text formatting, report headers and

footers, and page size to allow for printable reports.

. Created ad Hoc and parameterized various reports using SQL server 2008R2

reporting Services with data from SQL Server and MS Access as data

sources

. Created ad hoc SSRS reports in the test environment for data validation

. Produced dynamic Reports from the cube using SSRS 2008R2, and stored

procedures.

. Troubleshoot the deployment of reports in the test and production

environment using SSRS.

. Cleaned the data and created fact and dimension tables, performed

calculations required for the reports using SQL Server 2008R2 environment

and accomplished data modeling.

Environment: MS SQL Server 2008R2, SQL server Reporting Services 2008R2,

SQL Integration Services 2008R2, SQL Analysis Services 2008R2, Microsoft

Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

Health Net, Woodland Hills - Los Angeles, CA

Jan 2009 - Sep 2011

SQL BI Developer

Project:

Health Net, Inc. is among the USA's largest publicly traded managed health

care companies. The company's HMO, POS, insured PPO and government

contracts subsidiaries provide health benefits to approximately 6.6 million

individuals in all 50 states and the District of Columbia through group,

individual, Medicare, Medicaid, Tricare and Veterans Affairs programs.

Health Net's behavioral health services subsidiary, MHN, provides

behavioral health, substance abuse and employee assistance programs (EAPs)

to approximately 7.3 million individuals in various states, including the

company's own health plan members. The company's subsidiaries also offer

managed health care products related to prescription drugs, and offer

managed health care product coordination for multi-region employers and

administrative services for medical groups and self-funded benefits

programs.

Responsibilities:

. Worked closely with business unit(s) to understand key business drivers

and then identify the individual business metrics and key measures that

support them

. Designed and configured, including parameters, settings, metrics, data

elements and objectives

. Worked with management to develop strategies to support company needs

. Resolved data conflicts and inappropriate use of data

. Wrote complex SQL queries using joins, stored procedures, user defined

functions to verify the data from the database to generate reports based

on the business requirement.

. Wrote SQL Stored Procedure for checking Insert and Update on particular

tables and created Transactions and Error Handling in it.

. Utilized SSRS reports from different source formats and satisfying

clients by representing reports and presentations

. Generated matrix reports, tabular, drill-down, drill-through, sub

reports, chart reports, multi parameterized reports

. Created ad Hoc and parameterized various reports using SQL server 2008

reporting Services

. Implemented multiple grouping into several reports using visibility and

toggle options

. Administrated and scheduled mailing subscriptions on SSRS reporting

server

. Developed dependent, dynamic menu objects to allow end-users selection

and data filtering capabilities

. Structured conditional formatting logic to control components behavior

and appearance

. Produced parameter driven, matrix, sub-reports and integrated report

hyperlink functionality to access external applications.

. Customized SQL queries to create RDL Datasets and create SQL reports.

. Created Tabular and Matrix Reports with all aggregate functions and

expressions

. Produced dashboard SSRS reports under report server projects and

publishing SSRS reports to the reports server.

. Developed functional and technical documentation to assist in the design,

development and/or maintenance of deliverables

. Created SSRS Data Model projects using Microsoft Visual Studio 2008 and

using Report Builder for report server to facilitate Ad-hoc reporting by

the business users

Environment: SQL Server 2008, SSRS, T-SQL, SSMS, BIDS, Visio, Excel 2003,

SharePoint

Java Script, XML, PERL, SSRS, SQL Server 2005.

Contact this candidate