Prannoy Kongalla

872-***-****

ac4ymh@r.postjobfree.com

Sr. MSBI Developer

Professional Summary

Over 7.5 years of IT experience in the use and development, design, support and migration of Microsoft SQL Server database. Development using Microsoft SQL Server MS SQL Server, and products SSIS, SSRS, and SSAS in various domains like Health Care and Insurance as SQL Developer and MSBI Developer.

Hands-on experience using MS SQL Server (2005/2008/2012/2014/2016), T-SQL and Microsoft Business Intelligence Suite (SSIS, SSRS, SSAS).

Good Knowledge of RDBMS and Data Warehouse Concepts, OLTP, OLAP.

Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.

Expertise in creating, modifying, using and debugging Stored Procedures, Views, User Defined Functions.

Highly proficient in the use of T-SQL for developing Triggers, Views, Functions, Data Cleansing, Relational Database models and Data integrity, and SQL joins.

Expertise in Performance Tuning, Optimization, Data integrity, and Statistics by using SQL Profiler

Strong Knowledge of Normalization/De-Normalization and Data Modeling.

Very Proficient in SQL Tuning and Optimization of Queries.

Good understanding of Inmon top-down approach and Kimball bottom-up approach

Experience in Creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS packages.

Creating SSIS solutions for ETL and Business Intelligence process for Data Integration and Migration Services.

Expert in designing (development) and deployment of SSIS package from various sources like MS Access, Oracle, Excel, Microsoft SQL Server, flat file, and XML.

Excellent in High-Level Design of ETL DTS Packages& SSIS Packages for integrating data using OLE DB connection from various sources like Look-ups,Fuzzy Look-ups, Aggregate Functions, Merge Join, Conditional Split, Data Conversion, Derived Column, Event Handlers, and Error Handlers etc.

Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.

Defining Data Warehouse (Star and Snow Flake Schemes), fact table, cubes, dimensions, measures using SSAS.

Good knowledge of SSRS architecture and Hands on experience in developing deploying and managing Parameterized reports and Linked reports, Sub reports, drill down reports, drill through reports, ad-hoc reports and Crystal Reports with a thorough knowledge of report service architecture. (Table, chart and matrix report) using SSRS.

Expert in calculating measures and dimension members using the Multidimensional Expression (MDX), mathematical formulas, and user-defined

Familiar with work environment Agile methodology and Scrum meeting

Strong ability to share knowledge with others and collaborate as part of a team to achieve positive outcomes with good communication skills.

Technical Skills

RDBMS: MS SQL Server 2012/2014/2016, MS Access.

Methodologies: SDLC Waterfall, Scrum, Agile methodology.

Tools & Packages: SQL Server Management Studio, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, ETL, Visual Studio. MS Word, MS Excel, MS PowerPoint.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), DTS, SQL Server Analysis Services (SSAS), MS Visio, Power BI

Web Technologies: XML, HTML, JavaScript.

Application Packages: MS Office Suite, MS Outlook.

Operating Systems: Windows 98/95, Windows XP, UNIX, Windows 2007/2008/2010

Professional Experience

State Street Bank, Boston, MA Mar 2017 – Till Date

Senior SQL Server Developer/MSBI Developer

Responsibilities:

Designed SSIS packages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2012.

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, 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.

Developed various Triggers, Stored Procedure. Migrated tables from the old data warehouse to a new database for transaction history of the application.

Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources and converted SAS environment to SQL Server

Generated Drill down, Drill through, Adhoc, Matrix Reports, parameterized reports using SSRS.

Created SSIS packages using data transformations like Merge, Aggregate, Sort, Multicasting, Conditional Split, and Slowly Changing Dimension and Derived column. Transformation of XML based on XSD File Experience with designing the ETL process, including data read/write, data transformations, error handling, process design, logging, and Development.

Experienced in enhancing and deploying the SSIS Packages from a development server to production server.

Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Gained working knowledge of Data modeling, creating a star and snowflake schemas in SSAS.

Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.

Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.

Optimized and Aggregated cubes with 40% performance for better performance.

Generated reports using SQLServer Reporting Services 2008 from OLTP and OLAP data sources.

Designed and deployed a report with Drill Down, Drill Through, Dropdown menu option, Parameterized and Linked reports.

Used Index Tuning Wizard, SQL Profiler and SQL Query Analyzer for Performance Tuning.

Worked in Agile Methodology to efficiently deliver the project on time.

Environment:

MS SQL Server 2008/2012/2014/2016, MS SQL Server Reporting Services (SSRS) 2013/2015/2017, MS SQL (SSIS) 2013/2015/2017, MS SQL Server Analysis Services (SSAS) 2013/2015/2017, Microsoft Visual Studio, Query Optimizer, Azure, MS Excel, MS Visio 2013.

Rythmos, Dallas, TX Mar 2016 – Feb 2017

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

Worked with web application development team, supported the backend to performing frontend enhancements.

Worked on Full life cycle development (SDLC) of the project involving in all stages of development.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL join for SSRS report.

Designed and developed ETL process using SSIS to load data from various sources like MS Access and SQL Server

Created SSIS packages with Error handling, notifications, and package configurations.

Worked on Control Flow tasks like for each loop, execute process tasks, execute package tasks, script tasks, and Data Flow tasks.

Deployed SSIS packages for after working on complex enhancements.

Proficient in MS SQL Server suite of products like TSQL, SSRS, and SSIS of MS SQL Server.

Proficient in creating SQL Server reports, handling sub reports and defining a query for generating drill down reports using SSRS.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Regenerating reports on weekly or monthly bases using SSRS 2012.

Evaluated database performance and performed maintenance duties such as tuning, backup, and restoration.

Involved in Data Modelling to develop the database design using Erwin and created database diagram in MS Visio and SQLServer Management Studio (SSMS).

Extensive experience in designing, creating and deploying SSIS packages for transferring data and Converted existing DTS packages to SSIS Packages and

Gained working knowledge of Data modeling, creating a star and snowflake schemas in SSAS.

Developed complex calculated members, Named Sets using MDX expressions for OLAP reporting requirements.

Environment:

SQL Server2014/2016, Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, SSIS, SSRS, SSAS, Visual Studio 2013/2015, Crystal Reports 8.0, Data Analyzer, XML, ASP.Net, MS Word, Excel, SQL Profiler, Azure, Business Intelligence Development Tools, MS Vision.

Capco Financials, Chicago IL Dec 2014 – Feb 2016

SQL Server Developer/ETL/SSRS

Responsibilities:

Worked on Agile Methodology throughout the project, performed a decisive role in developing and planning as well as coordinating with assigned sprints.

Involved in writing complex SQL queries with multiple table inner and outer joins, temporary tables, table variables, cursors for automating SQL Server migrations.

Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)

Developed various operational Drill-through and Drill-down reports using SSRS

Responsible for Installation, Configuration, and Administration of SQL Server

Developed SQL scripts to Insert, Update and Delete data in SQL database tables.

Was responsible for defining the relationship between tables and enforced referential integrity constraints.

Created and re-evaluated indexes and made required process modifications for better performance.

Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.

Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary using SQL Profiler and Index Tuning Wizard.

Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.

Did scheduling, creating snapshots and subscriptions for the reports using SSRS

Created interactive reports with SSRS, using the report parameters, query parameters, Filters, and Expressions.

Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.

Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts, and Graphs.

Environment:

Windows Server 2012/ 2008R2/2008/2003, SQL Server 2014/2012/2008 R2/2008/2005/2000, SSIS, SSRS, SSMS, SSDT, Power BI, Visual Studio 2008/2005/2012/2014, PWA, Share point, Microsoft Project server 2004/2007/2010

Gordon Food Service, Grand Rapids, MI May 2013 – Nov 2014

SQL Server SSIS/SSRS Developer

Responsibilities:

Created DTS packages to copy tables, schemas, views and to extract data from Excel using SSIS.

Transformed data from various data sources using OLE DB connection by creating various DTS packages.

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with the incremental load.

Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.

Converted data types using Derived Column, Data Conversion Transformation.

Defined Check constraints, Business Rules, Indexes, and Views

Optimized the performance of SSIS package and SQL Stored Procedures for better package execution.

Improved T-SQL queries, SQL stored procedure performance by dropping and recreating the Indexes

Working in an Agile environment, created the logical and physical design of database and database objects to fit new business requirement and implemented the new design into SQL server.

Excellent hands-on experience scheduling and the deployment of the reports and uploading files to a report server catalog from the report manager.

Served as an SSRS Reports Developer and SQL Server Developer in support of Service Management System.

Environment:

MS SQL Server 2012/2014, SQL server Reporting Services 2010/2012, SQL Integration Services 2010/2012, Microsoft Visual Studio, Microsoft Visual Basic, SQL Server Management Studio, MS Excel, T-SQL, Microsoft Project 2010, Team Foundation Server (TFS), Surround SCM Client.

NORTHERN TRUST, Chicago, IL Dec 2011 - Apr 2013

Role: SQL Server/BI Developer

Responsibilities:

Gathered functional requirements, Business requirements and wrote the technical specifications for building the Global Enterprise Data warehouse.

Created DDL, DML scripts, stored procedures and triggers according to the requirement and designed ad hoc queries on the database tables.

Created views/indexed views consisting of computed columns to facilitate easy user interface.

Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.

Done High-Level Design of ETL using transformations in SSIS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat files, Text Format Data).

Developed multi-dimensional databases (MDDB), OLAP cubes and data marts using SQL Server Analysis Services (SSAS) that stored and maintained the data.

Created complex Stored Procedures using Linked Server, CTE, Temp Table, SQL Joins, ranking functions and Dynamic SQL and responsible for performing T-SQL tuning, multi-tasking and optimizing queries which takes longer time in execution with SQL Server 2008/2012.

Performed Documentation for all kinds of reports and DTS and SSIS packages.

Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.

Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Involved in performance tuning using indexing (Clustered Index, Non-Clustered index) tables.

Documented all database changes, followed and enforced change and release management processes.

Environment:

SQL Server 2008/2012, SQL Server Reporting Services (SSRS)2012/2013, SQL Server Integration Services (SSIS)2012/2013, SQL Server Analysis Services (SSAS)2012/2013, SQL Server Data Tools, SQL Profiler, Windows 7, Microsoft Office SharePoint, Team Foundation Server.

TATA TELESERVISES LTD., INDIA Oct 2010 –Nov 2011

SQL Developer (India)

Responsibilities:

Worked as a developer on databases like MS SQL Server 2005, MS Access.

Installed and maintained MS SQL Server 2005.

Created Database Objects – Tables, Indexes, Views, User-defined functions, Cursors, Triggers, Stored Procedure, Constraints, and Roles.

Analyzed and prepared Statement of Work and Requirement Definition Document.

Extensively developed SQL Procedures, Functions, Triggers and Packages.

Tuned and Optimized SQL Queries using Execution Plan and SQL Profiler.

Troubleshooting performance issues and fine-tuning queries and stored procedures.

Develop SQL Server Agent jobs and packages to populate data.

The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.

Involved in performing database Backup and Recovery.

Created and manipulated many small and Complex packages to perform ETL operations.

Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.

Environment:

SQL Server 2008/2008R2, T-SQL, DTS, MS-Excel, Windows 2000/2003, Visual Studio 2008/2010, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Profiler, MS Visio, Data Analyzer, MS Excel, Word

Education:

Bachelor of Technology in Electronics and Communication Engineering, INDIA

Contact this candidate