SUMMARY

• Over 6 Years of IT industry experience with Microsoft SQL Server 2005/2008, SSAS/SSRS/ SSIS as SQL Developer
• Extensive experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS)
• Experience in using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema. Experience in developing SSAS Cubes, Dimensions and data source views and Deploying and Processing SSAS objects
• Developed Cubes using different types of storage modes like Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP) and Hybrid OLAP (HOLAP).
• Created Named Calculations and Named Query from Data Source View.
• Created Partitions, defined aggregations to optimize the processing of cubes.
• Experience in administering cubes by defining different security levels, roles modifying the measures of the cubes.
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
• Expertise in creating complex SSRS reports against OLTP, OLAP databases.
• Experience in different type of reports including Tabular forms, Matrix form, Conditional, Drill down, List items, Charts and Sub Reports.
• Experience in sorting the data, defining subtotals for the reports.
• Extensive experience in designing and developing rich user experience reports using Matrix, Tabular, Drill down/up, and Drill through features in using Business Intelligence Development Studio (BIDS )
• Experience in using Expressions to customize SSRS reports dynamically.
• Knowledge in working with all Collections in reports like Fields, Globals, User, Parameters, Variables and Report Items.
• Expertise in Report Caching and Subscriptions including Standard and Data - Driven Subscriptions.
• Created Groups and Interactive Sorting.
• Created different kind of charts like Column, Line, Shape, Bar, Area and Range.
• Experience in extracting and transforming data using SSIS.
• Created Stored Procedures, functions and views.
• Experience in creating Packages, Jobs and Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility.
• Extensively worked on SQL Server Profiler, Analysis Services and Integration Services.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectation.

TECHNICAL SKILLS

Databases: MS SQL Server 2008/2005/2000/7.0 , ORACLE, MS Access, Teradata V2R6/V2R5, DB2

Development skills: T-SQL, PL/SQL, SSIS/SSRS/SSAS.

Languages: VB.net, VB Script, HTML, CSS, XML, ASP.NET, MDX.

ETL Tools: DTS, SSIS (SQL Server Integration Services).

Reporting Packages: SQL Server Reporting Services, MS Excel

PROFESSIONAL EXPERIENCE

Confidential, St. Paul, Minnesota

BI Developer

Responsibilities:

• Studied the existing documents and modified the system based on requirements
• Modified the existing databases into data warehouse star schema design
• Created and modified the Dimensions, Measures and SSAS cubes
• Implemented the different aggregation data rollups to reduce the size of data
• Implemented the partitions in the SSAS cube based on dates.
• Used Analysis Services for creating Dimensions using Attributes, defining Hierarchies, Levels & Measures, and Measure Groups.
• Created Backup strategy for production, development and QA environment.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Worked independently to bring up solutions for various data sources and cube designs
• Worked on MDX for implementing custom drill though and other custom reports.
• Attended the design meeting and assisted the team in design and SSAS development related issues.
• Prepared some custom reports using excel 2007 and SQL Server Reporting Services.
• Created graphical representation of data in reports by using graphs (such as Bar, Column, Pie) for quick data analysis and trending using SSRS.
• Designed and developed multiple drilled down and drill through reports to integrate summary and detail data alongside using SSRS Report Designer.
• Formatted the reports using the Global variables and expressions.
• Created Filtered reports using report parameters, stored procedures & cascading parameters.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Creating sub reports, calling those sub reports in many other reports - SSRS.
• Created stored procedures, functions, triggers, indexes for speeding up the data loads
• Created SQL Agent Jobs for various packages and scheduled them. Implemented the mail notification
• Design and develop SSIS packages, stored procedures, configuration files, tables, views, functions and implement best practices to maintain optimal performance. .
• Created the SSIS Packages for loading the data from the source to staging databases and processing the cube.

Environment: SQL Server 2008/2005, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio Team Foundation 2008, Visual Studio 2005, Business Intelligence Development Studio, Windows Server 2008/2003, Office 2007, System Center Service Manager(SCSM).

Confidential, Fairfax, VA

BI Developer

Responsibilities:

• Worked with Business Analysts and Users to understand the requirement
• Developed Cubes usingSQL Analysis Services (SSAS).
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance.
• Optimized cubes for better query performance.
• Identified the dimension, fact tables and designed the data warehouse using star schema
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
• Worked on building the cube using cube wizard in analysis services refreshed the cube on regular basis and giving the permission on the cube to users.
• Designed and maintained complex stored Procedures using Joins and Sub queries and to retrieve data from multiple tables.
• Created reports by dragging data from cube and wrote mdx scripts.
• 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.
• Used Notification services to generate error messages.
• RunningTracefrom theProfilerto trouble shoot database and runningDBCC consistency checksfor other database maintenance aspects.
• Designed and written the queries in the query builder for retrieving the data.
• Designed custom reports usingSQL Reporting Services.
• Design and development of Reports, Drilldown-Reports, Summary Reports, Dashboard Reports, cascading parameterized and Parameterized Reports in SSRS.
• Performed ETLoperations to support the data loads and transformations usingSSIS.
• Created checkpoints and configuration files in SSIS packages, Experienced in slowly changing dimension in SSIS packages.
• Created andscheduled jobsfor various tasks and also was responsible for maintaining jobs

Environment: SQL Server 2005/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, C#, ASP.Net.

Confidential, Chicago, IL

SQL/BI Developer

Responsibilities:

• Analysis done on data warehouse using SQL and Microsoft Access/Excel..
• Created standard report Subscriptions and Data Driven report Subscriptions
• Involved in writing MDX queries and manipulating the multidimensional data in OLAP cubes.
• Built cube partitions using MOLAP, HOLAP, ROLAP methods for faster query performance and processing speed.
• Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis. .
• Created complex SSAS cubes with multiple fact measures groups, multiple dimension hierarchies and defined attribute relations based on the OLAP reporting needs.
• Created Stored Procedures for Batch Processing.
• Worked With KPI (Key Performance Indicator) While Developing Reports From Cubes. To set Certain Goals Every Month and Updated Status.
• Generated the weekly, monthly, and quarterly reports by using SSRS.
• Created data sources, connection strings and defined the datasets for generating the report.
• Designed and written the queries in the query builder for retrieving the data.
• Creation and implementation of canned reports in SSRS.
• Personalization of User dashboard to view scorecards and chart reports.
• Created monthly reports using reporting wizard with Visual Studio.
• Identified and worked with Parameters for parameterized reports in SSRS 2008 R2.
• Generated Reports using Expressions and Functions for the reports
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005.
• Created, scheduled and monitored daily SQL jobs using SSIS packages.

Environment: SQL Server 2008, SQL Server 2005, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Windows Server 2003, SQL Profiler, Oracle, MS Excel, C, C++, Visual Studio 2008

Confidential, Alpharetta, GA

SQL BI Developer

Responsibilities:

• Responsible for building various Database Diagrams using Star schema and Snow Flake schema depending on the Business needs.
• Used various transformations, for implementing the Data Modeling, like Multicast, Slowly Changing Dimensions, and Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Designed and created Databases, Indexes, Views, Aggregations, Stored Procedures, Partitions and Data Integrity.
• Worked with SQL Server Analysis Services (OLAP)
• Creating an OLAP cube by using the Cube and Dimension Wizards.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Created KPI Objects in line with Requirement Docs.
• Processed cube to perform incremental updates.
• Created reports using SSRS from various sources like SQL Server 2005/2008 and Cubes from Analysis Services.
• Fixed issues in the existing reports and exported reports in multiple formats based on the business requirements.
• Involved in documentation of the Reports, Tables, Stored Procedures and User Defined Functions that were used in the reports.
• Optimizing the queries, applying the optimization techniques to improve the performance - in SSRS.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008R2.
• Designed reports using SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics.
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS in Visual Studio.
• Built Drill Down, Drill through, linked and sub reports using SSRS 2008.
• Designed various Cubes as per the requirements for various clients using SSAS.
• Designed Complex SSIS ETL packages to load the data from different sources like OLEDB, EXCEL, FLAT Files, RAW Files and DB2 etc into various Data warehousing system.
• Scheduled SSIS packages with SQL Server Agent.

Environment: SQL Server 2008/2005, T-SQL, Windows XP/2003, Visual Studio 2008/2005, Oracle, SQL Server Integration services, SQL Server Reporting services, SQL Server Analysis Services, Visio, Microsoft-Office 2003/2007, MS-Excel 2003/2007, Team Foundation Server 2005.

Confidential

SQL BI Developer

Responsibilities:

• Created database objects likeTables, User Defined Functions, Triggers, Procedures, Functions, IndexesandViews, SQL joins and statements as per the team’s request through team tracks.
• Involved in supporting database & BI (ETL, Analytics, and Reporting) activities for various applications and teams across all business units.
• Designing, processing and deploying Cubes from the different fact and dimension tables based on the business requirement using SSAS
• Developed reports from these OLAP cubes using SSRS.
• Used Analysis Services (SSAS) processing task to update with the current data.
• Involved in dimensional modeling by Identifying the fact and dimension tables based on the user & reporting requirements.
• Created Monthly portfolio reports using SQL Server Reporting Services (SSRS).
• Created Tabular, Matrix, and Drill down reports for different levels of risk officers and sectors.
• Written queries for the matrix and drilldown reports.
• Configured, Installed, Administered Reporting Services 2005/2008
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill Down Reports
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created Report Email Subscription using Data Driven and Time Driven ReportSubscriptions.
• Queried against Heterogeneous Data Sources like SQL Server, Oracle, to retrieve records for data loads using SSIS 2005/2008.
• Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs.
• Used differentControl Flow Tasks and Data flow Taskfor Creating SSIS Packages. Used different types ofTransformationsfor Data Conversion, Sorting and cleaning the data from different Sources into Company Format

Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, SQL Server Management Studio (SSMS).

Confidential

SQL Developer

Responsibilities:

• Created DDL scripts to create database schema and database objects.
• Created functions, views and triggers.
• Developed source to target specifications.
• Created DTS package and schedule the jobs for batch processing.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Greatly involved in Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects to improve the data base performance to have best out of it.
• Worked on building the cube using cube wizard in analysis services, refreshed the cube on regular basis and giving the permission on the cube to users
• Worked on submitting various reports from database using Excel pivots and SQL Reporting

Environment: Visual Basic 6.0, MS SQL Server Reporting Services 2005, Windows 2003.