SUMMARY

• Over 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008 in Development, Test and Production Environments on various business domains like Financial, Insurance and manufacturing.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Developing reports on SSRS on SQL Server (2000/2005/2008 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T - SQL.
• Great ability to create and manage various database objects like tables, views.
• Worked Extensively on ETL process using SSIS package.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in using T-SQL in SQL Server 2000/2005 and 2008 platforms.
• Experience in Performance Tuning and Query Optimization.
• Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports with PPS.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Expert in creating Parameterized Reports.
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS, Sharepoint.

Database: MS SQL Server 2008 R2, 2005, 2000, SQLCMD, Microsoft Office 2007/2003, MS-Access.

Language: C,C++,HTML,XML,TSQL,MYSQL,DHTML,VB.NET,ASP.NET,.NET Frame Work, C#, JavaScript

Operating System: Windows XP/NT/ 2000/2003/2008 , DOS

Tools: Erwin Data Modeler, MS Visio, SAS/Access, Crystal Reports8.5,10,XI,R2,BusinessObjects,Microsoft office 2003/2007

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SQL BI (SSAS/SSRS/SSIS) Developer

Responsibilities:

• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Involved in migration from SQL Server 2005 to SQL Server 2008.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
• Extract Transform Load(ETL) development Using SQL server 2008,SQL 2008 Integration Services(SSIS)
• Generated several drill down and drill through reports using SSRS.
• Expert in creating Star schema cubes using SSAS.
• Extensively worked on OLAP cubes using SSAS.
• Created and Managed OLAP Cubes using SSAS.
• Used Performance Point Server to create reports, scorecards and dashboards.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Designed and created the table schema and stored procedures that will be used in Data QC.
• Designed and developed the Data QC Maintenance website that will be used to maintain the application tables, execution of main Data QC store procedures, and report generation that will be exported to Microsoft Excel file.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
• Responsible for documentation of system related activities.
• Provides technical documentation of the system
• Experienced in integrating different Microsoft BackOffice Components such as Share Point and IIS with MS SQL Server
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment: MS SQL Server2005/ 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio.NET# 2008, TFS (Share Point ), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

Confidential, CA

BI Developer (SSRS/SSIS/SSAS)

Responsibilities:

• Created SQL server Reports using SSRS 2008.Identified the data source and defined them to build the data source views
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design(SSRS)
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2000 & 2005(SSAS)
• Used scripts and variables, email notifications for ETL process using Data Integrator.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.
• Enhancing and deploying the SSIS packages from development server to production server.
• Designed and built OLAP cubes to meet reporting needs.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS). Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS).
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created Packages in SSIS with error handling.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc
• Created Time Dimensions on OLAP Cubes using SSAS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created complex SSIS packages using proper Control and Data flow elements.
• Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Involved in migration from SQL Server 2005 to SQL Server 2008.

Environment: MS SQL Server 2008 and 2005, T-SQL, SSRS, SSAS, SSIS Packages, SSRS,ETL, ODBC, Erwin, ASP.Net 3.0, Ado.Net 3.0, C#.Net, Excel, Business, Business Objects Data Integrator 6.5, SharePoint Server, MDX, ProClarity, OLAP, OLTP, DB2, Access, Windows 2003 Server, IIS 6.0.

Confidential, Toledo, OH

BI Developer (SSRS/SSIS/SSAS)

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created SSIS packages to load data from Oracle to Sql Server using various transformations in SSIS.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Analyzed the existing tool and participated in meetings with the business users to gather
• Requirements and design goals of data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Used SQLCMD to write Stored Procedures in command line utility and it uses OLEDB to execute T-SQL batches.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs & deployed cubes.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
• Created report snapshots to improve the performance of SSRS.
• Combined Dundas chart control with .NET Grid view control and binded both of those controls to a common data source.
• Responsible for managing daily activities of department including compliance initiatives, group practice agreements, managing health care claim strategies and other.
• Responsible for helping manage the daily operation of the company, meeting with clients and brokers for brokerage, holding employee meetings, resolving conflicts.
• Created T-SQL Functions, Cursors, views, indexes, stored procedures and triggers.
• Migrated database from SQL server 2000 to SQL server 2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures.

Environment: SQL Server 2005, Windows 2000/2003, Microsoft office 2003,XML,T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, Visual Studio 2005,.NET Frame Work 1.0,SharePoint 2007.

Confidential, Bloomington, IL

SSIS SQL Developer

Responsibilities:

• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Performed cost benefit analysis of different ETL packages (SSIS) to determine the optimalProcess.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Responsible for Data migration from SQL Server 2000 to SQL Server 2005 Databases.
• Developed an automated report subscription process using SSRS.
• Applied conditional formatting in SSRS to highlight key areas in the report data
• Used Report Builder to do Ad-hoc Reporting.
• Created report links to refer other reports in a particular report.
• Resolved any deadlocks issues with the Databases/Servers on a timely basis.
• In-Depth working knowledge of ODBC.
• Handled Underwriting and pricing of renewal accounts within underwriting authority for
• Property Casualty, General Liability, Business Automobile, Umbrella Liability, Crime and Workers
• Compensation. Assisted (via remote) with payroll, tax, and account processing.
• Imported and exported data into MS Access databases and Debugged VBA scripts linked to said databases.
• Created multiple hierarchical aggregates for faster performance.
• Installed SQL server 2000 on Windows 20003 servers and involved in Physical and logical Database Design using Erwin tool.
• Created database objects like tables, users, roles, stored procedures, triggers.
• Worked on solving issues by doing data recovery in existing database.
• Used various formatting techniques like interactive sorting, grouping to created user friendly reports.

Environment: SQL Server 2005, Windows 2000/2003,MS Access 2000/2003,T-SQL,Windows 2000 Advanced Server, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
• Involved in Normalization of the database and bringing it to 3NF.
• Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
• Created ER diagrams using Visio.
• Created Views to enforce security and data customization.
• Created Non-Clustered indexes to improve query performance and query optimization.
• Involved in the performance tuning and optimization of T-SQL queries.
• Responsible for Data migration from SQL Server 7.0 to SQL Server 2000 Databases.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Developed user requested reports using Crystal Reports and Excel.
• Created Drill down and Drill through reports using Crystal Reports

Environment: SQL Server 2000, Windows XP/2000, Crystal Reports, Excel.

Confidential

MS SQL Server Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Designed and implemented the Logical and Physical model of the database using Erwin.
• Planed, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Installed and maintained MS SQL Server 2000.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Managed and monitored the use of disk space.
• Planned Backup strategy based on projects requirements.
• Worked with DTS packages and MSOLAP Services.
• Maintained the consistency of the client’s Database using DBCC.

Environment: MS SQLServer2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server.