SUMMARY

• 7+ years of IT experience in the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
• Strong technical knowledge in MS SQL Server development and experience Microsoft BI Tools.
• Microsoft Certified Technology Specialist in Business Intelligence and SQL Server 2008.
• Working Experience on SQL 2000/2005/2008/ R2/2012 including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• SQL Server 2005/2008/2008 R2 RDBMS database development including T - SQL programming.
• SQL Server 2008 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Very Good Understanding and Experience in SQL Server Integration Services(SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services(SSRS)
• Developing reports on SSAS & SSRS on SQL Server ( 2005/2008/2008 R2). Sound Experience and understanding of SSAS, OLAP cube and Architecture using BIDS
• Experienced in integrating different Microsoft BackOffice Components such as SharePoint and IIS with MS SQL Server.
• ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data warehouse Environment.
• Working Experience on slowly changing dimensions and creating SSIS packages using Active X scripts with Error Handling.
• Created complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008 and Transformation.
• Experience in Designing Dimensions, Data Aggregation and Storage design of Cubes, measures with Star schema and Snow-flake schema using SQL Server Analysis Services (SSAS).
• Experience in creating Gauge Reports with KPI’s, Report Model and Report Builder 1.0, 2.0.
• Thorough understanding of Kimball’s’ theory, KPIs and Perspectives, SQL 2008 Architecture.
• Developed MDX Queries against SSAS cubes to generate reports using BIDS
• Expert in performing ETL operations using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Worked on Data modeling, creating star and snowflake schemas in SSAS.
• Expert in designing complex reports like reports using Cascading parameters, Parameterized Reports and Report Models and ad-hoc reports, Crystal Reports using SSRS.
• Experience in defining Queries for generating drill down and drill through reports in SSRS 2008.
• Hands on Experience in Installing, Configuring, Managing and troubleshooting SQL Server 2008/2008 R2/2005/2000 and excellent communication and analytical skills, understands business requirements in various domains.

TECHNICAL SKILLS

SQL Server Tools: SSMS,BIDS, Enterprise Manager, DTS, Profiler, DTA, Upgrade Advisor

ETL & Reporting Tools: SSIS, SSRS, SSAS, BIDS, DTS, Business Objects, Informatica 7.1.3/6.2

Databases: SQL Server 2000/2005/2008/ 2008 R2,2012 MS Access, Oracle

Programming Languages: SQL,T-SQL,PL/SQL,VB

Operating System: Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0Windows XP/98/95, MS DOS, Linux.

Scripting: HTML, XML,VBScript, JavaScript,ASP,C#,ASP.NET,VB.NET, ADOMD.NET

Tools: Erwin, Visual Studio 2008/2005 and SharePoint, Report Builder 1.0/2.0/ 3.0

PROFESSIONAL EXPERIENCE

Confidential, FL

SQL Reporting Analyst

Responsibilities:

• Involved in reviewing the E-commerce application and interacted with business users to understand the report requirements for creating documents like data dictionary and technical specs.
• Worked in Agile Scrum Methodology with daily stand up meetings and great knowledge in TFS (Team Foundation Server) 2010.
• Involved in upgrading the databases and servers of SQL Server 2008R2 to SQL Server 2012.
• Created reports for users in different departments in different continents using web-enabled reporting by SQL server reporting services and SharePoint.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Involved in migration of several reports of SQL Server 2005 to SQL 2008.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2008 and then created reports using this data using SSRS 2008
• Configured and maintained Report Manager and Report Server for SSRS
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2008.
• Identified and worked with Parameters using complex expressions for parameterized reports in SSRS 2005.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Developed an automated report subscription process using SSRS 2008.
• Developed user requested reports using Crystal Reports and Excel
• Applied conditional formatting in SSRS to highlight key areas in the report data
• Created report links to refer other reports in a particular report. And also created report links for different servers.
• Created report snapshots to improve the performance of SSRS.
• Developed several sales, marketing, finance reports using Sub reports, Cross Tab, Drill down and Drill through, Matrix, tabular reports and Gauge reports using KPI’s
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
• Worked with SharePoint 2010 to publish documents and share reports for various Users.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005 and SQL 2008
• Developed complex reports against SSAS Cubes and MDX Queries.
• Using SSIS, built high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS transformations.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Used Sql Profiler for troubleshooting, monitoring, optimization of SQL server 2008 and SQL code.

Environment: SQL Server 2008, 2008R2 and 2012, T-SQL, SQL Profiler, Report Builder, SSRS, SSIS, Visual Studio 2005/2008, XML, Crystal Reports, Excel.

Confidential, NJ

SQL BI Consultant.

Responsibilities:

• Involved in reviewing the insurance application and interacting with business users to understand the user requirements.
• Involved in migration of SQL Server .
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Managed AMO (Analysis Management objects) using BIDS.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL using Business Intelligence development studio.
• Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
• Developed MDX Queries against SSAS cubes to generate reports.
• Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu and used gauge reports with KPI’s in SSRS.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
• Designed and Implemented various reports using Crystal Reports and responsible for the migration to SSRS.
• Designed, developed, tested deployed, supported, maintained and documented (KPIs), Scorecards, Time Aware Dashboards and accompanying Analytical Grids and charts with URL actions using Performance Point Server 2007 and SQL Server Analytical Services.
• Designed and build the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Used Sql Profiler for troubleshooting, monitoring, optimization of SQL server 2008 and SQL code.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Worked with SharePoint to publish and share reports for various clients.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.

Environment: SQL Server 2005/2008, T-SQL, PL/SQL, SQL Profiler, Report Builder, SSIS, SSRS, SSAS, MDX, ASP.NET, C#, Visual Studio 2005/2008, XML, Crystal Reports, ER-Win, MS Visio

Confidential, MN

MS SQL Server Developer/SSAS/SSRS/SSIS.

Responsibilities:

• Participated in creating reports that deliver data based on stored procedures.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
• Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
• Experience in creating SSIS packages using dashboard.
• Involved in writing classes for business logic layer using C#.
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, coding, triggers and cursors.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes using Business intelligence development studio.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Developed several Web controls -- composite and standard web controls -- using VB.NET and C#.
• ETL capabilities of SSIS were used to define imports of the data, build scheduling packages.
• Design, develop and went live after migrating several MS Access & SQL Server databases for corporate developers, resolving typical database issues.
• Iteration planning for new features and user stories in Agile Development methodology.
• Configured and maintained huge OLTP databases.
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment (SSAS).
• Migrated data from Oracle to SQL Server data warehouse and to generate the reports using SSRS for different SSAS Cubes.
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
• Loading data from various sources like, flat files, to SQL Server database Using SSIS Package.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Making a Report as per user requirement using MS Reporting Services 2008 (SSRS).
• Created SSIS Packages to migrate slowly changing dimensions.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Worked on improving the performance of the system.
• Involved in the tuning of the existing Database Objects.

Environment: SQL Server 2008, SSIS, SSAS, SSRS,, MDX, OLAP, XML, MS PowerPoint, MS SharePoint, MS Project, MS Access 2007/2003 & UNIX, .NET, C#, Agile Programming, Shell Scripting, Oracle, Crystal Reports.

Confidential, Atlanta, GA

SQL BI Developer

Responsibilities:

• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Excellent hands on experience with SQL Server Integration Service (SSIS), SQL Analysis Services (SSAS) and Reporting Services (SSRS).
• Involved in designing cubes in SSAS environment using Snowflake/ and Star Schemas.
• Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Installation and configuration of SQL Server 2008.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports,Subreports using Sql Server Reporting Services 2008.
• Created SQL Server Analysis Project using MS SSAS 2008.
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created complex SSAS cubes with multiple fact measures groups.
• Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Developed the chart type, tablix, matrix reports in SSRS (Sql Server Reporting Services) like enrollment status, Financial Aid, Degree Objective from the OLAP system using Business intelligence development studio.
• Used performance Point Services, SSRS, excel as the reporting tools.
• Wrote the expressions in SSRS wherever necessary.
• Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Modifying report content and exporting reports in multiple formats based on the business requirements.
• Designed and implemented Parameterizedand cascading reports using SSRS 2008.
• Developed data model based on the BA’s and the reporting Team using SSAS, SSRS.
• Created derived columns on the final fact and dimension tables as per the business requirements.
• Understanding the OLAP processing for changing and maintaining multi dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Created Analytical reports by PROCLARITY tool.
• Played a major role in production support of SSAS (cube refresh), SSIS jobs.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, Erwin, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle

Confidential, Atlanta, GA

SQL BI Developer

Responsibilities:

• Created complex SQL queries, stored procedures, functions, triggers, joins and SSIS/DTS packages.
• Migrated SQL Server 2000 DTS packages to SSIS 2005.
• Developed SSIS 2005 Packages to migrate data from Oracle, Access, flat files and Excel into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations.
• Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses.
• Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
• Configured Database Mail for sending automatic emails when a SSIS package is failed or succeed.
• Developed, deployed and monitored SSIS Packages.
• Developed custom reports and deployed them on server using SSRS.
• Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
• Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS.
• Formatted reports using Global Variables, Expressions and Functions for the reports.
• Created dashboards using Performance Point Server, combining scorecards and reports generated in SSRS, PPS, and Excel Services.
• Published dashboards on an intranet site using SharePoint Server.
• Configured Report Model for developing ad-hoc reports by the end-users.
• Uploaded reports on to the report manager and organized them into folders.
• Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor.
• Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
• Assisted in the application development, debugging, configuration, and optimization from database perspective.
• Involved in implementation of replications like Snapshot and Transactional.

Environment: - MS SQL Server 2005, Windows Server 2008,.MDX, DTS, SSIS, SSRS, PPS, SharePoint, T-SQL, ETL, MS Access, XML, Excel, Visual Studio 2008.

Confidential

SQL Programmer

Responsibilities:

• Created new tables, written stored procedures for Application Developers and some user defined functions
• Created SQL scripts for tuning and scheduling.
• Involved in Migration of databases of SQL Server 2000 to SQL Server 2005.
• Performed data conversions from flat files into a normalized database structure
• Created and managed users, roles and groups and handled database security
• Created Triggers to enforce data and referential integrity
• Defined Check constraints, Business Rules, Indexes, and Views
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server
• Data migration (import & export - BCP) from Text to SQL Server
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking)
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Performed development support, document reviews, test plan, integration of the system
• Creation/ Maintenance of Indexes for fast and efficient reporting process
• Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights
• Creation/Deletion of Linked Servers
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access)

Environment: SQL Server 2000 and 2005, T-SQL, PL/SQL.