SUMMARY:

• 7+ Years of Professional experience in Data Design and Development as MS SQLBI Server 7.0/2000/2005/2008 R2 database developer/administrator involving in analysis, design, creation, maintenance and implementation of project requirements for Data Modeling and Data Management.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2005/2008/2008 R2.
• Developing reports on SSAS SSRS on SQL Server (2000/2005/2008 R2). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• ETL expertise in using tools like DTS/SSIS, Bulk Insert, BCP and creating
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• 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.
• Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Hands-on experience on Dimensional Data Modeling using Erwin.
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experience in implementation and support of SQL Server Database Systems, Reporting Services (SSRS), Analysis Services (SSAS) and Integration Services (SSIS) built cubes and drill down reports, partitioned views and large data sets.
• Experience in performing back-up/recovery, running Database Consistency Checks using DBCC, implementing security, configuring replication.
• Experience in creating Reports from Web Services and used MDX on Cubes to create reports in SSRS.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Extensive experience on Data modeling, Erwin 3.5.2 (Logical, Physical and Star Schemas) Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT Dimensions tables, Physical Logical data modeling.
• Perform unit testing at various levels of the ETL.
• Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server (2007/2008) version.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Experience in implementing all types of Replication Models like Snapshot, Merge and Transactional and in Database Backup, Recovery and Disaster Recovery procedure.
• Expertise in planning and implementing MS SQL server security and database permissions.
• Experience in investigating and applying necessary SQL Server database service packs and patches.
• Proficient knowledge of writing, modifying and implementing Stored Procedures, functions, views, Triggers.
• Expert in designing, maintaining tuning various RDBMS like SQL Server 2000/ 7.0/ 6.5, Oracle 8i and MySQL.
• Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Good knowledge of System Development Life Cycle (SDLC).

Technical Skills:

C, C++, .NET, T-SQL, VB script 6.0, Active Scripting.

RDBMS:

MS SQL Server 7.0,2000,2005, 2008/2008 R2, MS-Access.

Front End:

MS Visual Basics 6.0

Web Technologies:

HTML, XML and Java Script

Middle Tier:

MSMQ, Web Logic, Web Connect, Microsoft .Net Technology

Reporting Tools:

Crystal Reports, SQL Server Reporting services (2000,2005 and 2008), ProClarity, Performance Point Server

Web Server Technologies:

IIS

Data Modeling Tool:

ERWIN , Visio

Operating System:

Windows 2000 Advanced Server, Windows 2000 data center, Windows NT, Windows 95/98/2000 XP

Other Tools:

Idera Diagnostic Manager, Quest spotlight, fog light, VMware, OLAP, and OLTP.

Hardware:

EMC DMX IBM Fast T 700 Storage Area Network (SAN), Compaq Proliant 8000, 6500, 6000

PROFESSIONAL EXPERIENCE:

Confidential
Greenwood Village, Colorado August 2011- Present
SQL BI Developer

Red Robin Gourmet Burgers is a chain of casual dining restaurants founded in 1969 in Seattle, Washington, and now headquartered in greenwood Village, CO. In 1969, local Seattle restaurant entrepreneur Gerry Kingen bought the restaurant and expanded it. The business dropped the "Sam\'s" and simply became Red Robin. It was a favored hangout for University of Washington students. Kingen continued to operate the location as a tavern for a few years, but later added hamburgers to the menu, and sales skyrocketed.

Roles Responsibilities:

• Actively participated in interactions with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Created an ETL solution that reads product, Vendor, and order data from .CSV files on a network share into a SQL Server Database. The solution also validated incoming data and performed notifications when jobs complete. The order data thus loaded into SQL Server was used to generate reports using the new SSRS 2008 R2 reporting functionality (including the Tablix Control). The reports were set up for automatic delivery based on standard report subscriptions.).
• Integrated SQL Server 2008 R2 reporting services with MOSS (Microsoft Office Share Point Server) to automatically deliver reports to the Share Point portal
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS
• Created systems for capturing error data in flat file using flat file destination, sending the error data in flat file attached to the corresponding mail ids using Sent Mail Task, and correcting error data.
• Implemented Error Handling in Stored Procedures using Try and Catch,@@error and Raiserror.
• Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Union-All, Merge, Merge Join and Derived Column.
• Utilized event handling effectively to generate audits and logs for the generated packages.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different locations.
• Part of team of 3 Business Intelligence developers to implement enterprise-wide Microsoft Business Intelligence solutions using cutting-edge technologies such as Performance Point Server 2007 (PPS), Reporting Services (SSRS) and Microsoft Office SharePoint Server (MOSS). Reports run on both SQL Server 2008 and 2005 platforms.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA.
• Design dashboards, including scorecards and reporting with the Dashboard Designer delivered via MOSS for One.
• Deployed designed PPS dashboards reports in MOSS site using PPS Dashboard viewer Web Part for web based access for multiple end users
• Deployed SSRS Reports in SharePoint for web based access for multiple end users
• Identifying the bottlenecks (in sources, targets, and packages) and tuning it.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008 R2.
• Build different types of chart reports using SSRS like column chart and Pie charts.
• Created sub reports and pass through parameters from main report to the sub reports.
• Deploying and Scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Created Complex Stored Procedures, triggers, cursors, tables, Views and other SQL joins and statements for applications by using T-SQL. Worked on Performance point server and created management reports.
• Experience in creating snapshots of reports to reduce the load on the server.
• Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance.

Environment: SQL Server 2008/ 2008 R2, SSIS, SSRS, SSAS, OLAP, OLTP, Performance Point Server, SQL Server Business intelligence Development Studio(BIDS), Access, XML, Web Services, VB.NET,ASP,ASP.NET, C#, MS Excel, Windows 2000 Server, T-SQL, ASP, MS Visual Studio.NET, Unix.

Confidential, Madison, Wisconsin June 2009 - July 2011

SQL BI Developer

DHS is a Health Service focus on specific strategy and guiding principles in all of our work for the people in Wisconsin. The Department supports policies vital to a fair and vibrant marketplace that delivers affordable, high-quality healthcare to our citizens and leverages our state\'s tradition of strong health outcomes, innovation and world-class provision of healthcare.

Roles Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Installed and Configured SQL Server 2005/2008 enterprise edition per client request.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2005/2008.
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in using different transformations like fuzzy lookup, derived column transformations etc in SSIS packages.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Perform unit testing at various levels of the ETL.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008(SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube in SSAS.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Excellent knowledge in creating reports using SSRS.
• Migrated SSRS 2005 reports in to SSRS 2008 reports .
• Involved in creating different kinds of reports like tabular reports, matrix reports, sub-reports, drill down reports etc and deployed them to the report manager using SSRS.
• SSRS experience with extensive report development experience, dash boarding and development of cubes for reporting.
• Experience in integrating SharePoint Server with SSRS and deploying SSRS reports on to SharePoint Server.
• Done performance tuning to optimize the run time.
• Changed stored procedures according to the new hierarchy.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring.
• Created .net scripts to load data into Informix tables.
• Used Performance Point Server to create reports, scorecards and dashboards.
• Managing the use of disk space, memory and connections. Running DBCC consistency checks, fixing data corruption in application database.
• working knowledge in Application testing, Data Modelling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.
• Environment: SQL Server 2005/2008 /2008 R2, SSIS, SSRS, SSAS, OLAP, OLTP, Erwin, Performance Point Server, SQL Server Business intelligence Development Studio(BIDS), T-SQL, VB.NET,ASP,ASP.NET, C#, MS Excel, Windows 2000 Server, T-SQL, ASP, MS Visual Studio.NET, Unix.

Confidential, Richfield, Ohio June 2008 - May 2009

SQL BI Developer

Snap-on Business Solutions is based in Richfield, Ohio. We are focused on helping vehicle and equipment manufacturers and their dealership networks increase sales, reduce structural costs, and improve customer experiences. SBS designs information tools that center on improving productivity in franchised dealerships and the supply chain.

Roles Responsibilities:

• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2008 Integration Services (SSIS).
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• 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.
• Perform unit testing at various levels of the ETL.
• Worked on Migration of packages from DTS using SQL Server Reporting Service (SSRS).
• Generating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Involved in Report writing according to business requirement using SSRS and Crystal Reports.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created the storage type (ROLAP), Created cubes for Business Intelligence (SSAS).
• Involved in writing MDX Scripts for the OLAP CUBES in SSAS.
• Utilized Analysis Services (SSAS) to design multi-dimensional models, including the construction of Data View, Fact and Dimension tables, and OLAP Cubes while adhering to enforced development methodologies.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition in SSAS.
• Experience in building and maintaining Data marts. Created roles for using the cubes
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
• 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.
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
• Experience in designing the reports in ProClarity for SSAS cubes.
• Gathered requirement from users and developed year to date reports in ProClarity.
• Involved in the implementation of Performance Point Server (PPS).
• Responsible for documentation of system related activities.
• Setup replication within the sql databases.
• Provides technical documentation of the system
• Code reviews to move it to the production developed by developers.
• Setup the database with suitable memory and hard disk space allocation, creating different user and security profiles for the team.

Environment: SQL Server 2000/2005/2008, Crystal Reports 8.5, MS Access, XML, Web Services, and Analysis Services Oracle 10g,SSRS, SSAS, SSIS, Performance Point Sever 2007,T-SQL, ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL2007.

Confidential, Sep 2006 - May 2008

Hyderabad, India

SQL Developer

The objective of this project was to maintain enhancement of a few databases for the Credit card and Merchant Resolutions department. Work on various possible performance-related issues including Database Tuning with the sole intention of achieving faster response times and better throughput. The enhancement was planned by importing a few tables from different databases (Finance Sales), modifying the existing table structure, creating necessary views and temporary tables and loading data in this database.

Roles Responsibilities:

• Installation, configuration of MS SQL Server 7.0 and 2000
• Consistency and Integrity
• SQL server Upgrade from 7.0 and to SQL 2000
• Merging 2 different version of databases to one single database and upgrading to SQL 2000
• Installation of service packs and security patches
• Creating and managing schema objects such as tables, views, cursors, indexes, procedures dynamically for any tables, triggers and maintained Referential Integrity
• Database and log backups and restoration, backup scheduling the backups. Backing up master and system databases and restoring them
• Query optimization and performance tuning. Writing triggers and stored procedures and optimizing it.
• Managing the use of disk space, memory and connections. Running DBCC consistency checks, fixing data corruption in application databases
• Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
• Server and Application fine-tuning and trouble shooting
• Assisted developers in Design, development and Implementation of various applications
• Migration of schema and data from Development and Production server.

Environment: MS SQL Server 7.0/2000, Windows 2000 Server, Windows NT Server, TSQL, ASP, Visual Interdev, PC anywhere, MS Outlook

Confidential July 2005 - August 2006

Hyderabad, India

Jr. Database Developer
This project involved migration of data from MS Access to SQL Server 6.5 and then executing complex queries on the data.

Roles Responsibilities:

• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for the system.
• Developed several database objects such as tables, triggers and views and also stored procedures.
• Created Snapshot Replication for the Development and Testing Databases across different Servers.
• Created and scheduled jobs and alerts.
• Studied the existing environments and accumulated the requirements by interaction with various aspects.
• Successfully loaded data from an EXCEL, Access, Flat files into a SQL Server database.
• Developed executed several optimized queries.
• Written several stored procedures to achieve various functionalities of the system.
• Created packages using DTS for moving data from MS Access to SQL Server.
• Assisted the Application team in data modeling and T- SQL coding.
  

Environment: SQL Server 6.5, Visual Basic 5.0, Windows NT, T- SQL, EXCEL, Access

Education Certifications:
Bachelors in Computer Engineering at Confidential, University,