PAVANI DUDUKU

Sql Server SSIS, SSRS, SSAS Developer

903-***-****

acr7ss@r.postjobfree.com

PROFESSIONAL SUMMARY

* ***** ** ** ********** in database design, development and administration in the Microsoft SQL Server Suite of Products on various business domains like Sales, Financial and Banking.

Good experience in Information Technology field as a SQL server Developer with strong expertise in SQL server development, designing Stored Procedures/Transact-SQL coding.

Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2012/2008 R2/2008/2005.

Excellent Experience in creating complex Stored Procedures, User Defined Functions, SQL Joins and effective Triggers to facilitate efficient data manipulation and data integrity.

Expert in working with the Business Intelligence Development Studio (BIDS), which includes SSIS, SSAS and SSRS.

Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.

Experience in strategically implementing the indexes such as Clustered index, Non-clustered index appropriately on data structure to achieve faster data retrieval.

Excellent in High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, Oracle, Teradata, flat file) by using multiple transformations provided by SSIS like Data Conversion, Conditional Split, Bulk Insert, merge, union all.

Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.

Hands on Experience in Migrating SSIS Packages from SQL Server 2005 to SQL Server 2008/2012.

Proficient in OLTP, OLAP and Data warehousing Design concepts.

Experience in developing SSAS projects using MDX in MSSQL Server.

Extensive experience in writing MDX Scripting and MDX Queries.

Experience in creating SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Experience in creating partitions for large measure groups in SSAS and rebuilding the Dimensions and Cubes in Analysis Services (SSAS).

Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform drill down operations in SSRS 2008/ SSRS 2008 R2/2012.

Experience with Adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.

Experience in Database Administration operations like Backup, Recovery, Replication and excellent knowledge of DDL and DML in T-SQL.

Experience in Performance Tuning, Monitoring and Optimization of T-SQL blocks in both Development and Production environment for SQL server database.

Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

EDUCATION

Masters of Computer Science, Texas A & M University, 2008

Bachelor of Engineering in Computer Science from JNTU, 2006

TECHNICAL SKILL SET

Programming Languages

C, C++, PL/SQL, TSQL

RDBMS

MS-SQL Server 2005/2008/2008 R2/2012, Oracle 9i/10g, Microsoft Access, Teradata

ETL Tools

SQL Server Integration Services (SSIS) 2005/2008 R2/2012, Informatica

OLAP Tools

SQL Server Analysis Services (SSAS) 2005/2008 R2/2012

Reporting Tools

SQL Server Reporting Services (SSRS) 2005/2008 R2/2012, Crystal Reports, Tableau

Database Tools

SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Query Analyzer, BCP

Markup Languages

XML, HTML, DHTML

Data Modeling

ERWIN, MS Visio

Operating Systems

Windows 2000/2003/NT/XP/Vista, Windows 7 Ultimate, Linux, Unix

Version Controlling Tools

Visual Source Safe, TFS

PROFESSIONAL EXPERIENCE

The Home Depot, Atlanta, GA Aug 2014 - Till Date

Sr. SQL Server BI Developer 2012(SSIS, SSRS, SSAS)

The Home Depot developed strategic product alliances directly with industry-leading manufacturers to deliver the most exclusive assortments to customers. The company sets the standard for innovative merchandise for the do-it-yourselfer and the professional contractor. The project direct fulfillment that I deal is on all the orders and shipments.

Responsibilities:

Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.

Worked on creating SSIS packages to upgrade from SQL Server 2008 to SQL Server 2012.

Developed SSIS packages to extract, transform and load the data from multiple flat files, excel files and used Execute Script task / Pivot /Unpivot/Conditional spilt transformations.

Troubleshooting ODBC and OLEDB connection issues in SSIS packages.

Created and scheduled jobs with SQL Server Agent in Development Environment and worked closely with DBA team to promote changes to Production.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Designed cube with star schema using SQL Server Analysis Services (SSAS).

Did Production support for SQL Server Business Intelligence on Agile Methodology.

Worked on migrating Teradata jobs to SQL Server using SSIS and worked on Incremental Loads and Delta loads.

Deployed SSAS Cubes to the production server.

Involved in SSAS storage and partitions and aggregations, calculation of queries with MDX, data mining models; developed reports using MDX and SQL.

Migrated SSRS reports from SQL 2005 to SQL 2012.

Created Sub reports, Parameterized Reports using SSRS with multi value parameters for users based on the requirements.

Worked on deploying reports to Report Manager and troubleshooting and bug fixes.

Environment: Microsoft SQL Server 2012, Windows 7, SSIS, SSRS, SSAS 2005/2012 TSQL, Teradata 14.10, Microsoft Visual Studio 2010, Query Analyzer, SQL Query Manager, Query Optimizer, Agile Methodology, Pivotal Trackers

M&T, Buffalo, NY Feb 2014 – Aug 2014

Sr. SQL Server BI Developer 2012(SSIS, SSRS)

M&T Bank Corporation is a bank holding company headquartered in Buffalo, New York, which had assets of more than 88 billion in March 2014. Major subsidiaries of M&T Bank Corporation include: M&T Insurance Agency, Inc. M&T Real Estate Trust, M&T Realty Capital Corporation. M&T supplies millions of dollars in funding every year to a wide range of community-based organizations.

Responsibilities:

Developed tables, stored procedures, views and indexes for the design specifications

Used tasks and transformations like Execute SQL Task, Conditional split, Script Component, Merge and Lookup on SSIS.

Developed the Functional specification documentation for the modules to be developed.

Reviewed the SSIS packages and created high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Design, Coding Standards.

Worked with DBA team to Create SQL agent jobs to execute SSIS package and also Run Trace and capture Details to debug Complex stored procedures.

Created Matrix, Sub reports, Parameterized Reports using SSRS with multi value parameters for users based on the requirements.

Worked on deploying reports to Report Manager and Troubleshooting for any error occurring during execution.

Environment: Microsoft SQL Server 2012, Windows XP, Transact SQL, SSIS, SSRS, TSQL, Microsoft Visual Studio 2010, C#, Query Analyzer, Agile Methodology, Management studio, Database Engine Tuning Advisor.

Wells Fargo Financial Services, St Paul, MN Mar 2012 – Dec 2013

Sr. SQL Server BI Developer 2008 R2 (SSIS, SSRS)

Wells Fargo & Company is a diversified financial services company providing banking, insurance, investments, mortgage, and consumer and commercial finance. Tuition Payment Plan Project is providing loans for Tuitions and planning accordingly how the payments should be made to wells Fargo in particular periods based on the schools semesters.

Responsibilities:

Database design including optimizing the database schema and coding database procedures/queries.

Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.

Developed tables, stored procedures, triggers, cursors, views and indexes for the design specifications

Implemented Common Table Expressions (CTE).

Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.

Performance monitoring and performance tuning by implementing efficient schemas, Optimizing queries, Tuning indexes and Database Consistency Checks using DBCC Utilities.

Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.

Worked on Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2008 and Reports using Tableau.

Environment: Microsoft SQL Server 2008 R2, Windows XP, Transact SQL, SSIS, SSRS, Tableau, SQL Server 2008 R2 Management Studio, Query Analyzer, SQL Query Manager, Query Optimizer

Electrolux, Charlotte, NC Sep 2011 – Mar 2012

Sr. SQL Server BI Developer 2008 R2 (SSIS, SSAS)

The purpose of this project is to facilitate for the user to check back the values for evaluating the measure values of the business in different areas like Actuals, Actual-Adjustments and Forecast. This application provides users info to configure information about Electrolux sales managers (employees) in order to calculate their commissions also the profit and loss values.

Responsibilities:

Developed SSIS packages to extract, transform and load the data from multiple flat files, excel files

Extensively used SSIS for Transformations, Aggregations, derived column, Sorting and Lookups.

Created Logical and physical data modeling for development database using Erwin Tool.

Created Dimensions, Data source views, deployed and processed SSAS objects, created SSAS storage, partitions and aggregations.

Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs and created partitions for large measure groups in SSAS.

Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services (SSAS).

Involved in the OLAP deployment configurations and developed MDX expressions for Actions and KPI’s.

Designed slowly changing dimension transformations (SCD) and customized the existing mappings.

Environment: Microsoft SQL Server 2008 R2, Windows XP, Transact SQL, SSIS, SSAS, MDX, SQL Server 2008 R2 Management Studio, Query Analyzer, SQL Query Manager, Query Optimizer

Wells Fargo Home Mortgage, Eagan, MN May 2010 – Sep 2011

Sr. SQL Server BI Developer 2008 (SSIS, SSRS)

Wells Fargo & Company is a nationwide, diversified, community-based financial services company with $1.2 trillion in assets. TCM Compliance Project is Bringing Information Services and Technology Enterprise Services into Compliance with the Technology Change Management (TCM) Policy.

Responsibilities:

Installed and configured SQL Server 2008, SQL Server Integration Services and SQL Server Reporting Services.

Developed packages to generate reports into Excel or text file formats from OLTP database using of SQL Server Integration Services (SSIS).

Designed dynamic SSIS packages to transfer data crossing different platforms, validate data and data cleansing during transferring, and archived data files for different Databases.

Migrated data between different heterogeneous sources such as flat file, Excel and SQL Server using SSIS, BCP and Bulk Insert.

Developed complex stored procedures using T-SQL to load the data and generate reports using SSRS.

Modified the existing stored procedures to optimize the performance of the queries by using the execution plan.

Writing complex MDX queries in order to extract data from cubes been developed through SSAS services.

Designed and developed Parameterized reports, Sub-reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using Report Designer and Report Builder in SSRS.

Used Visual Source Safe as version controlling tool to maintain the latest version of the code.

Experienced in configuring and deploying SSRS reports into Microsoft Office SharePoint Server.

Environment: Microsoft SQL Server 2008, Windows XP, Transact SQL, SSIS, SSAS, SSRS, Cognos, SharePoint, VB.net, SQL Server 2008 Management Studio, Visual Source Safe.

SVK Systems, Atlanta, GA Dec 2008 – May 2010

Jr. SQL/Oracle Developer

Responsibilities:

Normalized and De-normalized the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys

Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.

Configured SQL Server 2005 Environment.

Involved in database design, development of database Tables, Roles, Users and Views in SQL Server.

Designed E-R Diagrams, logical and physical data modelling.

Performed installations of Oracle 8i and SQL server databases.

Developed Database Triggers and Stored Procedures for populating and updating data into different tables on ORACLE 8i Database Management Systems.

Used FTP and SCP for keeping important files safe and secure.

Worked with database export & import scripts to backup database

Scheduling Jobs and Alerting using SQL Server Agent

Developed custom reports using Microsoft reporting Services.

Writing Oracle scripts for the SQL and PL/SQL requirements for various applications.

Optimization of the SQL queries to meet the performance requirements.

Environment: Windows, SQL server, Oracle, T-SQL, Query Analyzer, Data Transformation Service

Contact this candidate