View Bench List Portal

Similar candidates

• Mercy Pinargote
• Mihir Joshi
• Sri Hamsa
• Mahendra Madhala
• Bill Hludzinski

Over 8 years of IT experience in analysis, design, implementation & administration of Business intelligence solutions with Microsoft SQL server 2008/2005/2000 in development, Testing & production environment.
Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like MS EXCEL 2007, Microsoft Office.
Strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
Worked Extensively on Business Intelligence (BI) technologies to provide Historical, Current and Predictive views of business operations.
Strong experience in writing T-SQL, PL/SQL programming artifacts such as stored procedures, Triggers, Indexes, Views, Cursors, UDF using SQL server and Oracle Databases.
Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers(DDL&DML), User Defined Data types and Functions(UDF).
Extensive experience in Tuning SQL queries/SQL queries & improving the performance of the Database.
Expertise in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle and DB2.
Created, altered, maintained system roles and permissions to users on various database objects.
Strong debugging skills and the ability to solve complex problems.
Proficient in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
Expertise in using Try Catch block introduced in SQL Server 2008.
Experience on evaluating existing DTS packages on SQL 2000 and upgrading them to SQL 2005 SSIS packages.
Proficient in building data integration and workflow solutions and extract, transform and load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
Expertise in using SSIS tools like Import and Export wizard, Package Installation, SSIS package designer.
Extensive experience in developing ETL routines to integrate data from disparate data sources including relational databases, flat files, OLE DB Sources, MS excel spreadsheets.
Expertise in Performance tuning in SSIS packages by using Row Transformations, Block and Unblock transformations.
Excellent report creation skills using Microsoft Reporting Services (SSRS).
Proficient in designing Ad hoc reports and different types of Drill Down, Drill Through reports, Tabular reports, Cross tabs, Matrix reports, Custom reports, Crystal reports, Sub reports, Parameterized reports in multiple formats using multiple Data Sets and creating Charts using SQL Server Reporting Services SSRS 2005/2008
Expertise in designing enterprise reports using SQL Server Reporting Services (SSRS 2000/2005) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting services.
Experience in building star schema and snowflake schema depending on business requirements in SSAS.
Expertise in configuring and managing data sources, data source views, cubes, dimensions, roles and creating hierarchies with SSAS.
Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.