Resume Details
V. K.

Location Indianapolis, IN  
Contact Click to View Contact
Source Vendor Candidate
Salary N.A.
Rate N.A.

Resume


 

Vijay Kommanaboina

                                                                                          

 

PROFESSIONAL SUMMARY

 

  • Over Ten (10) years of IT experience which includes analysis, design, development, testing and implementation of applications, reports and databases (MS SQL Server 2008r2/2005/2000) in production environments.
  • Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems
  • Expertise with continuous integration and nightly deployments using TFS with a Test Driven Design approach
  • Extensive experience developing and implementing Microsoft SQL Server integration services (SSIS), Microsoft SQL Server Reporting Services (SSRS), SSAS (analysis services) and MDX for data warehouse and data mart solutions.
  • Experience in migration of DTS packages in to SSIS packages.
  • Extensive experience in writing and debugging complex stored procedures, cursors, triggers, Inner Joins & Outer Joins, views and user-defined functions.
  • Possesses extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report authoring, report management, report delivery and report security.
  • Installed, configured and maintained SSRS server.
  • Experience in creating new reports and ad-hoc reporting in SQL Server Reporting Services (SSRS).
  • Implemented SQL Server OLAP services (SSAS) for building the data cubes.
  • Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
  • Excellent understanding of data mining algorithms, high performance and optimal algorithms.
  • Experience with .NET framework using ASP.NET, C#, XML and ADO.NET database connectivity.
  • Experience in designing the logical data model and physical data model.
  • Experience in supporting large databases up to a size of two terabytes.
  • Experience with design and implementation of Star Schema and Snowflake Schema Dimensional model.
  • Delivered 24/7 support including scheduled and emergency night and weekend work.

 

 

                                                                             EDUCATION

 

  • Masters in Electrical Engineering, BTH University.

SKILLS

 

Languages

T-SQL, PL/SQL, C#, C, C++, Java, UNIX shell scripts, XML, HTML

Databases

MS SQL Server 2008/2005/2000, Oracle 8i/9i and 10g, DB2, MS Access, Nettezza.

ETL Tools

DTS, SSIS, Informatica, Power Center 6.2/7.1.x/8.1.1/8.6.1,DataStage 6.0

Reporting Tools

MS Reporting Services, Crystal Reports XI, Business Objects XI r2/6.x

Database Tools

TOAD, PL/SQL Developer, SQL-Navigator, SQL*Plus, Test Director, Win Runner

Data Modeling Tools

Physical and Logical Data Modeling using ERWIN, MS Visio

Operating Systems

Windows NT, Windows 2000, XP, UNIX

.NET Framework

MS VISUAL STUDIO 2005, C#.NET,IIS 7, ADO.NET,ASP, VB.Net

PROFESSIONAL SUMMARY

 

CNO Financial Group Indianapolis, IN                                                                Aug’12 – Present

Sr. SQL BI Developer

 

RESPONSIBILITIES:

  • Actively participated in interaction with users, Team lead, DBA’s and technical managers to fully understand the requirements of the system.
  • Performed Migration of data from SQL Server 2005 to 2008.
  •   Developed a data model and implemented the same using Visual Studio.
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
  • Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints.
  • Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
  • Designed SSIS (ETL) Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server 2008.
  • Created the packages in SSIS (ETL) with the help of Control Flow Containers, Tasks and Data flow Transformations.
  • Developed Slowly Changing Dimensions (SCD) in SSIS (ETL) to perform the Incremental and Historical loads of data in the data warehouse.
  • Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes
  • Worked with Inbuilt Transformations in SSIS (ETL) like Persistent Lookups to enhance performance for lookups and more utilization of I/O resources.
  • Efficiently utilized the Merge Join in SSIS and Merge statement to populate the data warehouse from a source database which provides efficient and granular level of control.
  • Performed Data profiling tasks In SSIS (ETL) using the Data Profile Viewer and then clean and standardize the data as appropriate for the Databases.
  • Conducted the Error handling in SSIS (ETL) using the Event Handlers.
  • Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
  • Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS.
  • Generated various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the web front end.
  • Analyzed and created Facts and Dimension Tables using SSAS.
  • Created the Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.
  • Developed Multi dimensional Objects Cubes, Dimensions using SSAS.
  • Running DBCC consistency checks and fixing data corruption in application databases.
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

ENVINORMENT: MS SQL Server 2008R2, SSAS, SSRS, T-SQL, OLAP Services, MDX, Share point 2010, MS Access, ASP.NET, XML, Microsoft Source safe

Eli-Lilly, Indianapolis, IN                                                                                   Jun'10 - July'12

Sr. SQL Server BI Developer

RESPONSIBILITIES:

  • Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS
  • Implemented SQL Server SSIS packages for ETL methodologies
  • Installed, configured and maintained SQL Server Integration Services (SSIS).
  • Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB etc. to Access etc.
  • Designed and developed a dimensional model for the OLAP Cube by an in depth study of the user requirements and the existing database schema.
  • Designed relationships between the dimensions and measures. Resolved complex many - many
    relationships
    and referenced relationships between the dimensions and the measures.
  • Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.
  • Used MDX to query the OLAP database in order to generate OLAP reports.
  • Developing calculated measures and assigning these aggregation levels based on dimension hierarchies.
  • Created Dimensional Hierarchy (Geo Calendar Product Distributor) Level based Measures.
  • Defined Key Performance Indicators (KPI) in SSAS.
  • Responsible for detecting KPI changes, surprising values data, data exploration and explanation through data mining algorithms etc.
  • Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
  • Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
  • Developed reports using SSRS and published as PDF, Excel, and CSV formats.

 

Environment: MS SQL Server 2008, SSAS, SSRS, T-SQL, OLAP Services, MDX, Share point 2010, MS Access, Netezza, ASP.NET, XML, Microsoft Source safe, Clear Quest

CITRIX, FL                                                                                                        Jun'09 - May'10

Sr. SQL Server BI Developer

 

RESPONSIBILITIES:

  • Logical and Physical design of database for projects on basis of user requirements using ERWIN.
  • Created new tables, wrote stored procedures for application developers and some user defined functions. Created SQL scripts for tuning and scheduling using T-SQL.
  • Defined Check constraints, Indexes, Views, Created Triggers to enforce data and referential integrity.
  • Used the Control Flow and Data Flow Tasks and Transformations in Creating SSIS (ETL) Packages.
  • Worked on SSIS (ETL) Packages, Import/Export for transferring data from Heterogeneous Databases to SQL Server.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse.
  • Enabled Logging, Database mirroring, Replication for the SSIS (ETL) packages.
  • Configured Server for sending automatic mails to respective people on SSIS (ETL) process failure or success.
  • Generated various reports based on business requirements using SSRS that could be used to send information to diverse group of users, clients and managers.
  • Created various Weekly and Monthly reports showing detailed information in SSRS.
  • Created Cross-Tab, Drill-down, Parameterized and Sub-Reports using Report definition Language (RDL).
  • Defined Star Schema, OLAP Cubes and Dimensions with SSAS.
  • Created the Data source views to analyze the metadata based on multiple data sources during development without an open connection to any underlying data source using SSAS.

 

  • Analyzed the Cubes by performing calculations, perspectives, actions and Key Performance Indicators (KPI’s) in SSAS.
  • Modified the measures, dimensions, attributes, hierarchies, measure groups and deployed the changes to the deployed cube in SSAS.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Tuning Advisor.

 

ENVINORMENT: SQL Server 2008/2005 SSIS, SSRS, SSAS, Visual Studio 2005, Windows Enterprise Server 2003, ADO.NET, Team Foundation Server(TFS), XML, HTML, Erwin.

 

PNC/National City Bank, Cleveland, OH                                                                             Jan’08- May’09    Sr. SQL BI Developer

 

RESPONSIBILITIES:

  • Extensively involved in interacting with the business users and gathering the requirements for the data warehouse.
  • Analyzed the requirements and provided best possible solutions.
  • Created project plan and a business requirement document and presented it to the client for their review.
  • Creating the complex stored procedures, user defined functions to meet the business rules.
  • Converted the data mart from Logical design to Physical design, defined data types, Constraints, and generated Schema in the Database.
  • Optimized the database by creating various clustered, non-clustered indexes and indexed views.
  • Creating, loading, and modifying a new package or an existing package or add and configure components, making changes object by using Control Flow Tools and Data Flow Tools and then verify it.
  • Designed cubes with star schema using SQL Server Analysis Services (SSAS).
  • Used MDX to query the OLAP database in order to generate OLAP reports.
  • Developing calculated measures and assigning these aggregation levels based on dimension hierarchies.
  • Created Dimensional Hierarchy (Geo Calendar Product Distributor) Level based Measures.
  • Responsible for detecting KPI changes, surprising values data, data exploration and explanation through data mining algorithms etc.
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
  • Developed reports using SSRS and published as PDF, Excel, and CSV formats.
  • Involved in Unit testing integrated testing and System testing.
  • Used Visual Source Safe for version control. 

 

Environment:  SQL Server 2008/2005, Oracle 10g, SSRS, SSIS, SSAS, T-SQL, Visual studio 2008/2005, Windows Serer 2003, HTML, IIS, Visio, Visual Source Safe 2005.

 

AETNA   Health Insurance, Middletown, CT                                                         Apr’07 – Jan’08

Sr. SQL BI Developer

 

RESPONSIBILITIES:                                                                                             

  • Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model.
  • Used intergraded Master Planning using MS Project Server 2007
  • Involved in designing of Conceptual Logical Model and Physical Model
  • Wrote various T-SQL stored procedures and Triggers, Inner Joins, Outer Joins to carry out tasks.
  • Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the customer data from various source systems feeds using SSIS

 

  • Worked Extensively with SSIS to import, export and transform the data between the linked servers.
  • Experience with the Share point 2007 to upload the SSIS packages in to Web portal.
  • Implemented SQL Server OLAP services (SSAS) for building the data cubes.
  • Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
  • Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.
  • Designed and developed various data mining procedures to enable intelligent querying.
  • Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
  • Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports in SSRS.
  • Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
  • Tested SQL code in PowerBuilder with Sybase data to ensure reliability of interfaces
  • Fine-tuned the logic in stored procedures, Functions and Triggers for optimum performance.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
  • Used Microsoft Source Safe for version control and configuration management.
  • Provided 24/7 support to all production, development, staging and clustered servers.

 

 

Environment: SQL Server 2005, SQL Server Integration Services (SSIS), SSRS, SSAS, Visual Basic 6.0, DTS, T-SQL, Share point 2007, Oracle 9i,Active X, C#.NET, ADO.NET, XML, Sybase, Clear Quest, Windows 2003

 

Ericsson, Stockholm, Sweden                                                                              Feb’06 - Jan’07        

SQL BI Developer

 

RESPONSIBILITIES:

  • Installation of the Microsoft SQL Server 2005 on New Production and Test servers with latest Security updates involving Service Packs and Security patches.
  • Designed GUI interfaces using various controls provided by ASP.NET environment
  • Created Stored Procedures, Triggers, Views and User Defined Functions to support the Application.
  • Migrated DTS packages into SSIS packages
  • Extensively worked on MDX Queries.
  • Reports are defined in Report Definition Language (RDL) with the included Business Intelligence Projects plug-in installed or with the included Report Builder
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Involved in Source Data Analysis, analysis and designing mappings for data extraction.
  • Also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
  • Working on Analysis services (SSAS 2005) to create multidimensional cubes to slice and dice the data.
  • Created the star schema for OLAP reporting data archiving and data marts
  • Used SSIS packages to move logins and jobs from one server to another server.
  • Data Analysis to create reports off of the cube using Microsoft reporting services (SSRS)
  • Monitoring SQL server performance using SQL profiler to find performance and dead locks.
  • Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
  • Governed and maintained performance and analysis portfolio of SSRS report.
  • Defined Parameters to SSRS in C#.NET to run dynamically at Runtime.
  • Worked with SQL server Profiler to generate traces.
  • Extensive testing on the Performance of the Stored Procedures.

Environment: MS SQL Server 2005 Management Studio, T-SQL, SQL Server Integration Services (SSIS), SSRS, SQL Server CE client, ASP.Net, C#.Net, Sybase, MS Access, Windows 2003/2000/XP, MS Visio

 

Cosmo9, India                                                                                                                Oct’03 – Jan’05

SQL BI Developer            

    

RESPONSIBILITIES:                                                                                     

  • Developed System Standards, System Architecture, Scenarios, detailed Screen Specifications and documented Logical and physical Data Model.
  • Worked Extensively with SSIS to import, export and transform the data between the linked servers
  • Worked on Stored Procedures and Database Triggers. Worked on large number of business analytical functions.
  • Created databases and specified automatic growth options.
  • Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
  • Designed and developed a dimensional model for the OLAP Cube by an in depth study of the user requirements and the existing database schema.
  • Used the UDM Model to create Named Queries in the Data Source View.
  • Designed relationships between the dimensions and measures. Resolved complex many – many relationships and referenced relationships between the dimensions and the measures.
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
  • Created Ad-Hoc reports using Report Builder.
  • Designing and building data load procedures, using MS SQL Server
  • Generated database SQL scripts and deployed databases including installation and configuration
  • Created Packages using Integration Services.
  • Written complex SQL statements using joins, sub queries and correlated sub queries.
  • Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
  • Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
  • Provide 24 X 7 supports to all production, development, staging and clustered servers.
  • Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service and SQL 2000 on windows 2003 enterprise edition.
  • Used Microsoft Source Safe for version control and configuration management.
  • Supported front-end applications under .Net framework.

Environment: SQL Server 2000/2005, SSIS, SSRS, SSAS, DTS, T-SQL, Active X, .Net, MS Reporting Services, Windows 2003

 

 


A. B.
Skill: IT-Database Design Location: West Chester , OH   
Description:
S U M M A R Y Has over twenty years of experie.... more
S. P.
Skill: IT-Database Design Location: Cincinnati , OH   
Description:
Professional Summary: Thirteen years of extensi.... more
R. N.
Skill: IT-Database Design Location: Mount Orab , OH   
Description:
OBJECTIVE Database Design / Administrator To .... more
B. C.
Skill: IT-Database Design Location: Rowland Heights, CA   
Description:
v\:* {behavior:url(#default#VML);}o\:* {behavior:u.... more
G. R.
Skill: IT-Database Design Location: Long beach, CA   
Description:
Ganesha Ratha  .... more