Professional Summary

• 7+ years of IT Experience in Data Warehousing, Database Design and ETL Processes in the Test and Production environments of various business domains like finance, manufacturing and health care industries.
• Good hands of experience in Database Design, Development and business intelligence of Microsoft SQL Server 2008/2005/2000(R2) in Development, Test and Production Environments with various business domains.
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Highly proficient in Development, Implementation, Administration and Support of ETL processes for Large-scale Data warehouses using SSIS.
• SQL database experience in a high transaction and multi server production environment.
• Experience in Database Development, Data Warehousing, Design and Technical Management.
• Good understanding indatabaseanddata warehousingconcepts (OLTP & OLAP).
• Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2005/2008.
• Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler.
• Developing reports on SSAS & SSRS on SQL Server (2005/2008 R2). Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using DTS and SSIS services.
• Worked on OLAP Data warehouse , Model ,Design and Implementation
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server performance.
• Expert in creating the MDX cubes and dimensions.(SSAS)
• Experience in UNIX shell scripting, job scheduling and communicating with server using pmcmd.
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects
• Supported team in resolving SQL Reporting services and T-SQL related issues and 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.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Good knowledge in using system tables such as sysindexes, sysprocesses, sysobjects and syscomment in various queries and using Database Console Commands (DBCC).
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• In-depth understanding of Data Warehousing and Business Intelligence concept
• Designed and developed efficient Error handling methods and implemented throughout the mappings in various projects.
• Good knowledge of Master Data Management concepts.
• Responsible for interacting with business partners to identify information needs and business requirements for Reports.
• Good Knowledge of Kimball and Inmon data warehouse design approaches and considerations
• Good understanding of dimensional models, slowly changing dimensions, star & snowflake schemas.

Technical Skills

Databases

Oracle 10g/9i/11i/R12, DB2, SQL server 7.0/2000/2005/2008 R2, MS Access 2000/2005, Teradata

Languages

Transact- SQL, PL/SQL,HTML, C, C#, PERL

Operating Systems

Windows NT/98/2000/XP/Vista/7, Linux, Unix, MS-DOS, Sun Solaris.

OLAP/Reporting Tools

SQLServer Analysis Service(SSAS), SQL Server Reporting Service(SSRS), MDX, Share Point MOSS 2007, Crystal Reports 9/10/XI, Business Objects 6.x, Cognos

ETL Tools

SQL Server Integration Services (SSIS), SQL Server DTS, Cognos Data Manager

Data Modeling Tools

Microsoft Visio 2000/2003

SQL Server Tools

SQL server Management Studio, SQL server Query Analyzer, SQL server mail service , DBCC, BCP , SQL server profiler

Web Technologies

MS FrontPage, MS Outlook Express, FTP, TCP/IP, LAN,PHP

Other Tools

Microsoft Office, MS Visio, Visual Basic

Professional Experience

Confidential,COLUMBUS, OH. Aug 2011 – Till Date
Role: SQL BI Developer

The Huntington National Bank provides full-service commercial, consumer banking services, mortgage banking services, equipment leasing, investment management, trust services, customized insurance service program, and other financial products and services.

Responsibilities:

• Installation of SQL Server 2008 on Development and Production Servers, setting up databases, users, roles and permissions.
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Designed and developed database objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Created Indexes to get high level performance in making consumer search queries faster.
• Performed ETL operations to support the data loads and transformations using SSIS.
• Involved in migration from Oracle to SQL Server 2008 using SSMA and SSIS.
• Developed Cubes using SQL Analysis Services (SSAS) for business and retail consumers.
• Involved in Analyzing, designing, building &, testing of OLAP cubes.
• Deployment of SSAS Cubes to the production server.
• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Generated reports from the cubes by using SQL reporting services (SSRS) and ProClarity.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Worked on creation of dashboards, scorecards and building reports using performance point server 2007.
• Experience in developing and extending SSAS Cubes, dimensions and data source view SSAS- Data Mining models and deploying and processing SSAS objects.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of Sharepoint with SSRS.
• 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).
• Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Implemented automated backup and database maintenance / cleanup jobs.
• Managed Logins, Users, Roles and User permissions
• Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
• Implemented site information architecture utilizing various SharePoint resources including Document Libraries, Lists, Form Libraries, Content Types, Column, Information Management Policies and Version Controlling.
• Enhanced and developed UI functionality using ASP.NET, HTML
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Create and Update Stored Procedures to produce sql tables and flat files from the production database
• Created various weekly, monthly/quarterly Tabular and Matrix Reports using SSRS to assist in decision making.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment: SQL Server 2005/2008, Query Analyzer, OLAP, OLTP, MDX, SSIS 2008, Performance Point Server 2007, T-SQL, Proclarity, Excel, ETL, Microsoft SQL Reporting Services 2008 (SSRS),MS SQL Analysis Services(SSAS) ,ASP.NET, Sharepoint, Visual Studio, Windows 2000/XP.

Confidential,May 2010 – July 2011
Role: SQL BI Developer

Fifth Third Bank (5/3 Bank) is a U.S. regional banking corporation, headquartered in Cincinnati, Ohio and is the principal subsidiary of holding company Fifth Third Bancorp.
Fifth Third Bancorp is a diversified financial services company with $111 billion in assets, operates 15 affiliates with 1,232 full-service Banking Centers, including 106 Bank Mart locations open seven days a week inside select grocery stores and 2,213 ATMs.

Responsibilities:

• Installed and Configured SQL Server 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 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 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.
• 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
• Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• 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.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Experience in Creation and deployment of cubes on SSAS.
• Excellent knowledge in creating reports using SSRS.
• 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.
• Experience in integrating SharePoint Server with SSRS and deploying SSRS reports on to SharePoint Server.
• Written a UNIX script for Central America Project to create the report for the database source.
• Done performance tuning to optimize the run time.
• Changed stored procedures according to the new hirearcy.
• 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.
• Configure backup/recovery strategy per client request. Full Backup database on specific time, transaction log backup using different check point per client request.
• Environment:MS SQL Server 2008/2005, SQL SSAS,SSRS,SSIS,OLAP, MDX, Sharepoint, ETL, Windows 2000 Server, Windows NT Server, TSQL, ASP, MS Visual Studio.NET,teradata, Unix, Informix.

Confidential, Washington D.C, DCJan 2009 – Apr 2010
Role: SQL BI Developer

The DCI Group, LLC is one of the top strategic public affairs consulting firm associated with telemarketing company Feather Larson & Synhorst DCI and the direct-mail firm FYI Messaging. The idea of the project is to initially build data marts and then integrate all marts into one enterprise wide data warehouse.

Responsibilities:

• Involved in gathering user Requirements, application design, and analysis of hardware requirements to meet business needs.
• Developed various Views, Stored Procedures and function as per Agile Methodology.

• Having a good experience in Data modeling and involved in Designing Logical and Physical Data model using Erwin Tool.
• Extensively used XL web services in SharePoint Portal 2007.
• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules,
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008/2005.
• Defaults, user defined data types and functions in SQL Server 2008/2005.
• Actively involved in creation of database, modifying tables, triggers, and store procedures.
• Created SSIS Packages to migrate slowly changing dimensions.
• Migrated data from the MS Access database using SSIS Packages.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.
• Involved in the Data modeling, Physical and Logical Design of Database
• Incorporated business logic in SSIS while converting from MS Access and Text to SQL Server.
• Created Backups for databases and automated the process.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005(SSAS).
• Created Transactional Replication, Pull Subscription and defined editions to transfer data from branch to head office and vice versa.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Created Dashboards from reports and XL work books in SharePoint (MOSS) 2007.
• Created Indexes for fast retrieval of the data and involved in Performance tuning.
• Created new database/tables to put in the extracted data and rebuild the relationship.
• Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports.
• Involved in Backing Up & Restoring User Databases.
• Extracted data from SQL Server for report, backup, testing purposes by using DTS,

Environment:MS SQL Server 2008/2005/2000/7.0, T-SQL, Stored Procedures, Performance Point Server, MDX, OLAP, Sharepoint, SSAS,SSRS,SSIS, SQL Server Enterprise Manager, ETL, DTS, SSRS 2000/2005,ASP.NET, Visio, SQL Server Query Analyzer, SQL Profiler, Sharepoint, ERWIN.

Confidential,New York, NY Oct 2007 - Dec 2008
Role: SQL BI Data Warehouse Developer

1199SEIU Funds are among the strongest and largest labor-management funds in the nation, providing a range of comprehensive benefits to 400,000 working and retired healthcare industry workers — members of 1199SEIU United Healthcare Workers East.

Responsibilities:

• Installed and Configured SQL Server 2005 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 for transactional information of customers.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2005.
• 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.
• Helped clients with ProClarity for providing access to cubes in OLAP.
• Created and updated Stored Procedures to produce sql tables and flat files from the production database
• Experience in using xp_cmdshell sql command which exports the flat file onto a physical location
• Ability to run the Stored Procedures in multiple modes (i.e. production, test, debug etc.)
• Experience in using the inbuilt SQL scheduler for automating the Stored Procedures
• Ability to run scripts which archive the Stored Procedure output tables
• Experience in error tracking and reporting mechanisms
• Used best practices like maintaining extract log, using a single table for all the parameters, version control for code.
• Created and consumed Web Services using C#.
• 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.
• Understanding OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Excellent knowledge in creating reports using SSRS.
• Involved in creating different kinds of reports like tabular reports, matrix reports, sub-reports, drill down reports and deployed them to the report manager using SSRS.
• Experience in integrating SharePoint Server with SSRS and deploying SSRS reports on to SharePoint Server.
• Done performance tuning to optimize the run time of processing.
• Changed stored procedures according to the new hierarchy.
• querying from multiple databases and write scripts to manage transactions between two or more DBs
• 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.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Running DBCC consistency checks, fixing data corruption in application database.
• Configure backup/recovery strategy per client request.
• Full Backup database on specific time, transaction log backup using different check point per client request.

Environment: MS SQL Server 2000/2005, Windows 2000 Server, C#, OLAP, Proclarity, SSIS, SSRS, ETL, Windows NT Server, TSQL,ASP, MS Visual Studio,. NET, UNIX, C#, Informix.