Bhanu Suhagiya

Professional Summary:

Over * years of IT professional experience as MS SQL Server/ Business Intelligence (BI) Developer in Windows environment for system analysis, design, development and testing various projects executed in SQL.

Extensive knowledge in designing relational database model and physical implementation as per business requirement.

Worked on complete SDLC for system analysis, design, development, testing and implementation of projects.

Experienced in logical and physical database design & development, normalization and data modeling using Erwin and SQL Server Enterprise Manager.

Extensive experience in writing Distributed Queries between SQL Servers and T-SQL queries (DDL and DML).

Adept in RDBMS concepts and constructs along with objects creation such as Databases, Tables, Normalization, UDFs, User Defined Data Types, Indexes, Views, Cursors and Triggers.

Experience with database optimization, database tuning, query optimization and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor.

Worked on SQL Server Integration Services to perform Extraction, Transformation, and Loading (ETL) tasks. Extracted data from various sources such as Excel, Flat file, Oracle, Access, Sybase to MS SQL Server.

Created extensive packages in SSIS and performed transformations on the data including Conditional Split, Merge Join, Aggregate, Multicast, Slowly Changing Dimension (SCD), Fuzzy Grouping and Lookup, Pivot and Union All, etc.

Extensively used the SQL Server Reporting Services and Crystal Reports for designing, generating and deploying reports.

Experienced in writing parameterized queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting and group the data, Defining Data Source and subtotals for the reports using SSRS 2005/2008.

Proven ability in creating and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS).

Very good experience in Designing, Implementing, Maintaining Complex Data Warehouse using SQL Server Analysis Services (SSAS)

Migration experience and knowledge of different versions of SQL Server (2000 to 2005, 2005 to 2008)

Worked on administration tasks such as data loading, batch jobs, data unloading, backup & recovery, user and application table management, upgrades, creating databases / file groups/files/transaction logs.

Experienced in creating Jobs, Alerts, SQL Server Agent, and scheduling SSIS Packages.

Knowledge of Computer Science theory & strong experience in modern programming languages.

Excellent oral and written communication skills, quick learner, can adapt quickly to a new technology, with ability to take new roles in minimum time.

Good team player with excellent interpersonal skills, strong communication and organizational skills.

Education Qualifications:

Master of Science in Electrical Engineering

Skillset:

MS SQL Server 2000/2005/2008/2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Access, SQL Server Analysis Services (SSAS), MS SQL Enterprise Manager, SQL Profiler, Query Analyzer, Data Transformation Services (DTS), Bulk Insert, BCP, Report Builder 3.0, Crystal reports, MS Visio 2003/2007, ERwin 4.0/7.x, C, C++, C#, ASP.Net, Internet & Web Programming Fundamentals, MSDOS, UNIX, Windows (NT, 95, 2000, XP, 7), Visual Source Safe, Tortoise Svn Version Control

Projects Summary:

AIG Advisor Group, New York, NY 12/2009 - Present

MS SQL Server/ SSIS/ SSRS Developer

American General Financial Services, a member of American International Group, Inc., provides loans, retail financing and other credit related products to more than two million families in United States. The project involved maintaining customer information and ensuring efficient data retrieval as required for core decision-making. Also, supported their infrastructure data warehouse and database server systems with regards to troubleshooting, maintenance, updates and create reports as per the requirements.

Hardware/Software:

MS SQL Server 2008, MS Visio, T-SQL, Excel, Access, Report Builder 3.0, ASP.Net and Windows Server 2008

Responsibilities:

Worked extensively on Business Model and Mapping (BMM) layer to develop various business models using Snowflake Schema and Star Schema with MS Visio.

Participated to build a complex Data Warehouse architecture for the storage of large amounts of data from OLTP database.

Created various types of cube in SSAS with fact tables and dimension tables (related to fact tables) as per business requirements.

Developed complex Functions, Views and other SQL joins and statements to retrieve data faster from Data Warehouse for the analysis purpose.

¬¬Created stored procedures for the business logic using T-SQL and performed coding of several database and maintained integrity constraints.

Managed indexing, debugging, optimization and performance tuning using SQL Profiler and SQL Server Agent.

Coordinated with different source system owners, day-to-day ETL progress monitoring with the help of SSIS, Data warehouse target schema design (Star Schema) and maintenance.

Designed SSIS Packages to transfer data from various heterogeneous sources like Text Files, XML (Extensible Markup Language) Files, Excel and Access to SQL Server using Business Intelligence Development Studio.

Created packages to transfer data from the transactional database system to the data warehouse.

Created and scheduled jobs to run the packages to ensure efficient data transfer without interrupting the day to day activities.

Worked on debugging of SQL queries in Execute SQL Task in SSIS as well on error handling with the help of Windows event handler.

Compressed data files by removing empty database pages and updating index statistics.

Implemented various Calculation, Aggregation, KPI and Partition of cube to retrieve data from Data warehouse for reporting purpose.

Extensively worked on Reporting Services Configuration Manager for the configuration of Accounts and Web Services on Reporting Services.

Designed and implemented reports with different layouts using SSRS 2008 and exported them into Excel, PDF and HTML.

Created Ad-Hoc reports for the meeting purpose with the help of Report Builder.

Configured snapshot replication for reporting, user acceptance test and development servers.

Managed and monitored the system utilization by using the query optimizer and checking the execution plan and worked in Enterprise Manager for job scheduling.

Blue Cross Blue Shield of New Jersey, Newark, NJ 1/2009 – 11/2009

MS SQL Server /BI Developer

The Blue Cross Blue Shield Association (BCBSA) is a federation of 39 separate health insurance organizations and companies in the United States. The project involved understanding of Healthcare Data in the core areas of Claims, Eligibility, Customers and Providers. The responsibilities as a SQL Server/ BI Developer were the migration of data from various sources to the application repository using SSIS and migration of SQL Server 2005 to SQL Server 2008. Further, the project involved development of complex reports using SSRS.

Hardware/Software:

MS SQL Server 2005/2008, MS Access, DTS, Query Analyzer, BCP, SQL Profiler, Erwin, Import & Export Data Wizard, Windows 2003 Server.

Responsibilities:

Involved in logical & physical design, database development and testing of the complete functional system.

Extensively worked on migration of OLTP databases from SQL Server 2005 to SQL Server 2008.

Created SSIS packages mainly with SQL Script Task, Execute SQL Task, FTP Task to extract data from heterogeneous sources into SQL Server 2005.

Widely used data conversation for the data coming from various sources like scratch, Oracle and Access.

Used Merge join, Fuzzy Lookup, Data Transformation for the cleansing of data coming from scratch and other data sources.

Also used slowly changing dimension for handling changes in the data coming from the OLTP database.

Created Jobs to extract data from different source systems using SSIS packages.

Invoked several Stored Procedures within these Jobs that would aggregate the data and load them in temporary staging table, having the same architecture as the table for which the import is done.

Implemented several jobs in SQL Server Agent to run SSIS packages on regular time and daily bases.

Defined and scheduled several SSIS packages to move data between servers, and set up nightly transfer jobs.

Developed complex T-SQL code for the application and implemented constraints on tables.

Worked as a developer in creating complex Stored Procedures, triggers, and views and other SQL joins and statements for applications.

Worked on performance tuning using database Tuning Advisor and SQL Profiler.

Created SSIS packages for processing fact tables and dimension tables with complex transforms and also configured and deployed SSIS packages to import and export data from various data sources.

Worked on complex data loading (implemented the batch data cleansing and data loading).

Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting the data from the defined data sources using SSRS.

Created numbers of cubes, dimensions and business critical factors using SQL Server Analysis Service (SSAS) representing aggregation in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.

Depository Trust & Clearing Corporation (DTCC), New York, NY 6/2007- 12/2008

MS SQL Server/ BI Developer

DTCC is a post-trade financial company. It provides a safe and secure way for buyers and sellers of securities to efficiently make their exchange. DTCC provides clearance, settlement and Information for Equities, corporate and municipal bonds, government and mortgage-backed securities. Project involved transferring of transactional data into data warehouse and the historical database.

Hardware/Software:

MS SQL Server 2005, T-SQL, MS Excel, MS Access, Visual Studio 2005, Crystal Reports and Win Server 2003

Responsibilities:

DTCC has a highly transactional OLTP system, where I was extensively involved in writing complex Stored Procedures, Triggers and creating SSIS packages.

As a part of the team, participated in meetings with BA's, to determine Client Requirements and System Specifications.

Increased Stored Procedures performance by using SQL Server Traces, Index Tuning Wizards and Execution Plans.

Built Ad-Hoc reports using SQL Server Reporting Services (SSRS) and Report Builder, then altered with Excel.

Used SQL Server Profiler to trace the slow running queries and the server activity.

Created Indexed Views to optimize queries and created Triggers on Views to populate base tables.

Created SSIS packages by using SQL Task, Data Flow Task, FTP Task, and Execute Process Task to migrate data from third party application to current OLTP database.

Develop different account level and security level reports using SSRS by different types of subscription..

Converted various Crystal Report reports into SSRS reports.

Coordinated and managed changes to database schema. Assisted in debugging and correcting Longview database stored procedures.

Designed complex dynamic reports for business users by using Crystal Reports/SSRS.

Created SSIS package to convert some part of Share Point data into SQL Server Database.

Experienced in formulating the robust disaster recovery strategies by creating Complete, Differential, and Transaction Log Backups and by setting up the Log Shipping, Database Mirroring.

Performed database consistency checks with DBCC utilities.

Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.

Wachovia, Philadelphia, PA 3/2006 – 5/2007

MS SQL Server/ BI Developer

Wachovia is a diversified financial services company providing banking insurance, investments, mortgage and consumer finance. Project was involved to gathering large amount of data from various external sources (Oracle, Excel, etc.) and load it into a data warehousing system (Enterprise Cube) with the help of ETL process. These data from Data warehouse then presented through user interface for to generate various reports with SSRS for decision making process.

Hardware/Software:

Windows XP, MS SQL Server 2005, Visual Studio 2005, Visio Enterprise, MS Access 2003, MS SQL Reporting Services(SSRS), SQL Server Integrated Services(SSIS), Oracle, Business Intelligence (BIDS), C#, C++, T-SQL

Responsibilities:

Wrote complex T-SQL stored procedures to retrieve data dynamically from database for the reports.

Generated Dynamic reports using SSRS from various Cubes generated in SSAS.

Designed, developed and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS).

Responsible for ongoing maintenance and change management to existing reports and optimize report performance. (SSRS).

Performed Report Testing and Verification as per Internal Reporting system requirements.

Created calculated member for complex calculation in reports using Business Intelligence.

Created matrix reports, drill-down reports and table formatted reports

Involved in building an extensive OLAP data warehouse on SQL Analysis services(Cubes, stars schema)

As part of a team, created various reports according to the requirements and also individually authored, installed, deployed and managed reports using SSRS for a library database.

Developed and Implemented the SQL Server Integration Services (SSIS) packages to populate the data into Enterprise Data Warehouse from various sources like Flat File Source, Excel Source into OLEDB destination (SQL Server).

Wrote Some KPI for Cube development to implement it in the reports.

Maintained and Created Replication: Merge Transaction and Snapshot. Also implemented data transformation to the published articles.

Exported reports into Excel –Friendly Production Quality.

Implemented the DTS Packages in SSIS to transfer and load the data.

AT&T, Atlanta, GA 11/2004 – 2/2006

MS SQL Server/ SSIS/ SSRS Developer

AT&T Corporation is a telecommunications company which owns and operates the largest wireless telecommunications network in United States. Project was involved to implement an automated system with the help of SSIS and migration of SQL Server 2000 to SQL Server 2005. Involved in creation and customization of reports for various perspectives to the managers to help in their decision making process. I have automated reports to send to respective subscriptions.

Hardware/Software:

MS SQL Server 2000/2005, T-SQL, Enterprise manager, Crystal Reports, ERWIN, MS Office & Windows 2K platform

Responsibilities:

Actively involved in different stages of Project Life Cycle.

Participated in gathering of User Requirement and System Specification.

Worked on designing of the application that covers process flow of the business logic.

Participated in database logical design to fit new business requirement, and implemented new design into SQL Server 2005.

Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.

Created and maintained database, tables, user logins, views, indexes, and constraints to implement business rules and also created Triggers to enforce data and referential integrity.

Created stored procedures for maintaining SQL Server and for Application Developers.

Maintained and Created Replication: Merge Transaction and Snapshot. Also implemented data

Developed applications like integrating existing user-developed Access databases into SQL server back-end and modifying front-end screens.

Administered security, user account management and access privileges.

Developed the SSIS packages to transform data from SQL 2000 to MS SQL 2005(DTS to SSIS conversion).

Created SSIS packages for processing fact and dimension tables with complex transforms and also configured and deployed SSIS packages to import and export data.

As part of a team, created various reports according to the business requirements and also individually authored, installed, deployed and managed reports using SSRS for a library database.

Generated drill down and drill through reports from data warehouse using SSRS.

Optimized indexes with the use of Index Tuning Wizard and Rebuild indexes.

Used SQL Server Profiler to trace the slow running queries and the server activity.

Analyzed and debugged jobs and procedures.

Performed Backup operations.

Standard Charted Bank, Mumbai, India 11/2003 – 9/2004

Jr. SQL Developer/DBA

Standard Chartered Bank is a British financial services company headquartered in London, England with operations in more than seventy countries. Standard Chartered Bank is also one of the larger foreign banking corporation in India. Involved as an SQL Server 2000 developer with responsibilities such as requirement analysis, design, document, development, enhancement and support of the Database.

Hardware/Software:

MS SQL Server 2000, T-SQL, Enterprise manager, MS Visio 2003, MS Office 2003, Windows Server 2000

Responsibilities:

Worked with the DBA to create the logical and Physical design of database for projects according to application requirements.

Created/reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.

Coded Stored Procedures, complex functions and triggers at High level to retrieve data faster.

Fine Tuned the SQL queries using hints for maximum efficiency and performance.

Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.

Participated in User Acceptance Testing (UAT) for different modules.

Created and customized DTS packages and used it to load data from difference sources.

Prepared proper backup and recovery plans.

Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Used SQL Server Profiler to trace the slow running queries and the server activity.

Worked on DBA activities like creating users, roles and granting and revoking privileges.

Merging data into a single server for achieving better control, consistency & security of data.

Contact this candidate