SUMMARY

• Over 9 years of progressive experience in complete Software Development Life Cycle (SDLC) using SQL Server 2012/ 2008/2005/2000 versions.
• Extensive expertise in MS BI (SSIS, SSAS, SSRS).
• Experienced in both Online Transaction processing (OLTP) and Online Analytical Processing (OLAP) and Data Warehousing environments.
• Well experienced in database programming, development and deployment using SQL Server 2012/ 2008/2005/2000 which includes solid grasp of database architecture, performing logical & physical design, development of complex Cubes.
• Involved in various activities like preparation of functional and technical documents, discussions with the client regarding the proposed solution, migration strategy, related reports, unit level and User Acceptance Testing (UAT).
• An enthusiastic and goal - oriented team player possessing excellent communication, interpersonal skills with good work ethics.
• Extensive knowledge of Hansen architecture.

TECHNICAL SKILLS

SQL Server Tools: Analysis Services, Enterprise Manager, Query Analyser, DTS, SSIS, Profiler

Reporting tools: SQL Server Reporting Services 2008/2005/2000 , Excel 2010/2007, SharePoint

Databases: Oracle 11g, SQL Server 2008/2005/2000 .

Tools: TOAD, SQL Developer, Erwin, MS Visio

Languages: T-SQL, SQL, PL/SQL, MDX, DAX

PROFESSIONAL EXPERIENCE

Confidential, Baltimore

Senior SQL Data Warehouse SSRS Consultant

Responsibilities:

• Created reports by extracting data from cube and Generated reports using SQL Server Reporting Services 2008 R2 from OLTP and Mainframe data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Generated reports based on the statistical analysis of the data from existing Business Objects reports.
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Remediated most of Business Objects 6.1b reports to SSRS by comparing the existing functionality with the newly generated reports functionality.
• Involved with Query Optimization to increase the performance of the Report.
• Developed Reports for business end users using Report Builder with updating Statistics.
• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema
• Documented and maintained database system specifications, diagrams, and connectivity charts.

Environment: SQL Server 2008 R2, SSAS, SSIS, SSMS, SSRS 2008 R2,SQL Server Jobs, Oracle 11i/10g,SQL, PL/SQL, Mainframes, Business Objects.

Confidential, San Antonio

Senior MS BI Developer

Responsibilities:

• In depth knowledge of Hansen tables and architecture.
• Design and develop OLAP cubes for Multi-dimensional data reporting using SSAS 2008/2012.
• Involved in Analyzing, designing, building and testing of OLAP cubes with SSAS 2008/2012 and in adding calculations using MDX.
• Performance tuned the existing SSAS cubes in order to minimize the processing time.
• Created and fine-tuned various fact tables and dimension tables supporting numerous cubes.
• Worked extensively on SSAS storage and partitions, aggregations and calculations.
• Used MDX to create calculation formulae to enhance the cube productivity.
• Worked on SSRS reports and fine-tuned SSRS MDX queries.

Environment: SQL Server 2008/2012, SSAS, SSIS, SSMS, SSRS,SQL Server Jobs.

Confidential, Dallas

Lead SSAS/OLAP Developer

Responsibilities:

• Design and develop OLAP cubes for Multi-dimensional data reporting using SSAS 2005.
• Involved in Analyzing, designing, building and testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• Performance tuned the existing SSAS cubes in order to minimize the processing time.
• Created and fine-tuned various fact tables and dimension tables supporting numerous cubes.
• Worked extensively on SSAS storage and partitions, aggregations and calculations.
• Worked in Oracle Production assisting in oracle to teradata migaration.
• Used MDX to create calculation formulae to enhance the cube productivity.

Environment: SQL Server 2005, SSAS, SSIS, SSMS, SQL Server Jobs.

Confidential, Seattle

SSAS/OLAP Lead Developer

Responsibilities:

• Design and develop BISM Models for Multi-dimensional data reporting.
• Developed reports using BISM SQL AS 2012 which helped customers to query the reports in real time environment
• Created DAX queries with SSAS 2012 in analogues to MDX queries and implemented the same.
• Worked on DAX calculation formulae to mimic the MDX formulae in order to get the same output.
• Created DAX measures using BISM tabular model.
• Fine-tuned the tabular model and used memory compression techniques to efficiently reduce the processing time of tabular models.

Environment: SQL Server 2008/2012, BISM, SSAS, Excel 2010, MDX and DAX.

Confidential, Charlotte

Lead SSIS/SSAS/SSRS Developer

Responsibilities:

• Designed and developed OLAP cubes for Multi-dimensional data reporting using SSAS 2008.
• Worked on Data models for the Multi-dimensional databases and data warehouses.
• Developed SSIS Packages Scripts to extract data from the numerous data sources.
• Created and restored SSAS database backups from development to production servers.
• Worked on SSAS XMLA scripts to fine tune, add or change attributes of dimensions.
• Worked as a developer to tune the queries, run scripts and move the database from production to development servers
• Develop SQL Server Stored procedures and SSIS Packages Scripts to extract data from the database.
• Worked on creating Excel Pivot tables and charts shows the summarized data and gives the control to the user on how they want to view the data.
• Designed, developed, debugged and tested reports in SQL Server 2008 Reporting Services (SSRS) and deployed them into SharePoint portal
• Created User Interfaces for Multidimensional models using SharePoint & SSRS reports.
• Involved in unit testing of the TK Web application.

Environment: SQL Server 2008, SSAS, SSRS, SSIS, SSMS, SQL Server Jobs, SharePoint Reports.

Confidential, Tallahassee

SSIS/SSAS Developer

Responsibilities:

• Design and develop OLAP cubes for Multi-dimensional data reporting using SSAS 2008.
• Worked as a developer to tune the queries, run scripts and move the database from production to development servers
• Created and fine-tuned various fact tables and dimension tables supporting numerous cubes.
• Designed and developed end to end of ETL process for Data mart
• Created new multidimensional models which supported the hospital data from numerous counties.
• Unit tested the OLAP cubes to ensure data compliance.

Environment: SQL Server 2008, SSAS, Enterprise Manager, SQL Server Jobs, Microsoft Visio, tool.

Confidential, Burbank

SSIS Developer

Responsibilities:

• Implemented ETL process of extracting the data from the OLTP and transforming it into the warehouse servers.
• Created SSIS packages for Uploading of Various different format of files and databases to MS SQL.
• Develop SQL Server Stored procedures and SSIS Packages Scripts to extract data from the database.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.
• Worked on creating Excel Pivot tables and charts shows the summarized data and gives the control to the user on how they want to view the data.

Environment: SQL Server 2005, SSIS, Enterprise Manager, SSIS Packages, SQL Server Jobs, Microsoft Visio, Cogno’s tool.

Confidential, Tallahassee

SSIS/SSAS/OLAP Developer

Responsibilities:

• Design and develop OLAP cubes for Multi dimensional data reporting using SSAS 2005.
• Involved in Analyzing, designing, building and testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• Performance tuned the existing SSAS cubes in order to minimize the processing time.
• Designed ETL packages, populated fact and dimension tables using SSIS 2005
• Created and fine-tuned various fact tables and dimension tables supporting numerous cubes.
• Worked extensively on SSAS storage and partitions, aggregations and calculations.
• Used MDX to create calculation formulae to enhance the cube productivity.
• Worked in tandem with BI Architect to ensure data compliance.

Environment: SQL Server 2005, SSIS, Enterprise Manager, Crystal Reports 8.0/8.5, SSIS Packages, SQL Server Jobs, Microsoft Visio, ASP.Net, Dundas Visualization tool.

Confidential, Tampa

SSAS/OLAP Analyst

Responsibilities:

• Captured data requirements with visual data models using ERWIN and MS Visio
• Translated relational data models to translational data models for SSAS cube development.
• Designed and developed OLAP cubes for Multi-dimensional data reporting using SSAS 2000.
• Worked on Data models for the Multi-dimensional databases and data warehouses.
• Experience in writing MDX queries for cubes.
• Created complex stored procedures and views for the above modules which were used extensively for Reports.
• Developed SQL Server Stored procedures and DTS Packages Scripts to extract data from the database
• Tuned SQL queries using show plans and execution plans.
• Used Data Transformation Services (DTS) an Extract Transform Load (ETL) tool of SQL Server to populate data from various data sources by creating packages for different data loading operations.
• Worked as a developer to tune the queries, run scripts and move the database from production to development servers

Environment: SQL Server 2000, Enterprise Manager, Query Analyzer, Data Transformation Services (DTS), Packages, SQL Server Jobs, ERWIN and MS Visio.

Confidential

SQL Server Developer/ DBA

Responsibilities:

• Created users, application development and maintaining the database, controlling user access right and managing data security.
• Used Microsoft Analysis Services 2000 to build OLAP Cubes, dimensions, Measure and Virtual cubes and deploy them.
• Generated Script files of the databases when ever changes are made to stored procedures or views or any other database objects.
• Used Data Transformation Services (DTS) of SQL Server to populate data from various data sources by creating package for different data loading operation for application.
• Managed the use of disc space, memory and connection.
• Ran DBCC consistency checks and fixing data corruption in application databases.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Created views and Index views to reduce database complexities for the end users.
• Importing and exporting the data using DTS.
• Review database designs for compliance with company standards.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Involved in Performance tuning and Query optimization of the Database as required by the application.

Environment: MS SQL Server 2000/2005, DTS, SSIS, SSRS, T-SQL, XML, Visual Studio 2005, MS Office, SQL Profiler, Windows 2000/2003.

Confidential

SQL Server Developer/ DBA

Responsibilities:

• Installation and administration of MS SQL Server 2000 and Windows 2000.
• Coding complex SQL Stored procedures according to the Specs Joining the different tables and conditions.
• Created the Temp tables in the stored procedure for different application.
• Wrote stored procedures and T-SQL code to accomplish various tasks.
• Created different functions in the application.
• Created the index to increase the performance of stored procedure.
• Created the batch stored procedures for the Report Scheduler according to the monthly, weekly or daily.
• Created database tables, constraints and indexes.
• Involved in performing a data mapping, quality assessment converting multiple databases for all product types.
• Partitioned tables which had frequent inserts, deletes and updates to improve the overall performance.
• Set up the DTS package for importing and exporting data to and from SQL Server.
• Used DTS to convert Excel data to SQL Server 2000.

Environment: SQL Server 2000, T-SQL, DTS, VB 6.0, Visual Source Safe, MS Office, and Windows 2000.