SUMMARY

• Around 6 years of experience in IT industry performing Database Design, Development using SQL Server 2012/2008/R2/2005 in Developing, Testing and Production environments with various domains like Financial, Insurance and Health Care.
• Experience in software Analysis, Design, Development, Testing, Implementation and Production Support of Client/Server and Web based applications.
• Sound knowledge of Data marts, Data warehousing, Dimensional Data Modeling, Start Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables using MS Analysis Services.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Expert in writing T-SQL, working on DTS,SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
• Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Experience in writing stored procedures, Indexed views and triggers for data consistency and manipulation.
• Experience in creating DTS/SSIS packages for transferred data modifications and transforming data using DTS Import/Export Data, Bulk Insert, Data Replications and DTS Packages.
• Hands on experience in creating ETL packages using SQL Server 2008R2, 2008 & 2005 Integrations services (SSIS). Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and unblock Transformations.
• Migrated data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integrations Services (SSIS) to overcome the transformation constraints.
• Very good experience in developing reports using SQL Server 2012/2008/2005 Reporting Services (SSRS).
• Hands on experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report)
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Worked with OLAP and Data warehouse application and worked with star schema, dimensions and worked with implementing SSAS and SSRS to support large reporting needs.
• Good knowledge in the installation and configuration of SQL Server 2012, 2008 and 2005.
• Experience in Database Backup, Recovery and DR procedures for large, medium and small database instance.
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as proactive team member.

TECHNICAL SKILLS

• MS SQL Server 2005/2008/2008 R2/2012
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• SQL Server Reporting Services (SSRS)
• BIDS
• DTS
• Import/Export Data
• Bulk Insert
• BCP
• SQL Profiler
• SQL Query Analyzer
• Enterprise Manager
• Management Studio
• Replication
• SQL Agent
• SQL Developer
• MS Visual Source Safe 6.0/8.0/2005
• T-SQL
• PL/SQL.

PROFESSIONAL EXPERIENCE

Confidential

SQL BI Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and dataflow, data quality analysis, working in conjunction with data warehouse architect.
• Designed SSIS packages to transfer data from various sources like Text files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL server using BI Development Studio.
• Worked on DTS Packages, Import and Export Wizard for transferring data from Heterogeneous Database (Oracle and Text files and Excel files and MS Word 2007 files) to SQL server.
• Developed ETL Process using SSIS with Various Control Flow, Data Flow task and stored procedures for Work Order Validation Process.
• Used Lookup transform to create the SSIS package for inserting new entries from Excel master source spreadsheet to the SQL server table and update the old data.
• Responsible for the deployment of the reports on the reporting server and schedule subscription for the windows file share.
• Developed different types of reports like Tabular report, Matrix Report, Drill Down, and Drill through Report.
• Involved in writing SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Build packages and handled slowly changing dimensions to maintain the historic data.
• Responsible for optimizing all indexes, SQL queries, Stored Procedures to improve the quality of software.
• Created and configured OLAP cubes using SQL Server 2012 Analysis Services and Performance Tuning and scaling to large number of users.
• Build the Dimensions, Cubes with star schema and snow flake schema using SQL Server Analysis Services (SSAS) and created SSRS reports.

Environment: SQL Server, T-SQL, SSMS, PowerPoint, MS Server Integration Services (SSIS), MS Server Reporting Services (SSRS), Visual Studio, PL/SQL.

Confidential

SQL BI Developer/SSRS/SSIS Developer

Responsibilities:

• Built a SSIS package to develop staging tables which would hold required data for larger reports, to save the report processing time each time the report is being accessed by the users, as all the calculations will already be performed by SSIS package in the non-business hours every day.
• Worked with various control flow tacks in SSIS including Data Flow Task, Execute SQL Task etc. including Container Tasks like for loop container and for-each loop container and used sequence container to manage various tasks.
• Designed Report Templates using constant information like Company Logo, Department Name etc. that could be used in future.
• Worked on reports as simple as just Data Dump from a table to as complex as reports with Multiple Tables within same report with various functionality like Drill through, Parameterized and Chart Report.
• Helped HR department in creating report with year to year and month to month summary using Matrix functionality.
• Held the authority to manage the Security of developed report in the development environment by providing different kind of access to different people depending on the role of the users in the report like Browser Access, Content Manager Access etc.
• Created Menu Reports i.e. report that would provide menu of reports that come under the same group, and which would direct user to specific report they click on.
• Created various kinds of chart reports such as Bar Chart, Line Chart, and Pie Chart. Also created complex chart report with two axes (primary and secondary axes) to show data with various data types/formats such as turnover with various chart formats within same graph.
• Created drill down report to show different characteristics and performance of Discharge its contractual obligation to help the sales to make decision.
• Worked on scheduling automatic run of the reports using subscription and deliver the reports to the business users, in various formats and with various messages using expressions.
• Manage the bigger report to use Snapshot Report feature to save the processing time of the reports which are being continuously accessed by different users.
• Worked on analytical service for creating a business intelligence semantic model such as tabular, multi-dimensional and power pivot.

Environment: MS SQL Server 2012, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (SSIS, SSRS), MS Office

Confidential

SQL Server/BI Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Created Stored Procedures, Triggers, Indexes, User Defined Functions, and Constraint on various database objects to obtain the required results.
• Used data profiling tasks to analyze the quality of the customer data from various sources and created SSIS packages to store consistent data in central repository.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Responsible for Scheduling jobs, Altering and Maintaining SSIS packages.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report criteria in various reports to make minimize report execution time and to limit the number of records required.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameters types like hidden, internal default (queried and non queried parameters).
• Used various SSIS tasks such as Conditional Split, Derived column, which were used for Data Scrubbing, data validation checks during staging before loading data into the Data Warehouse.
• Used ETL to implement Slowly Changing Transformation to maintain Historical Data in Data Warehouse.
• Used Merge in development, test and production for changing the referenced data.

Environment: SQL Server 2008R2/2012, SQL Server Integration Services, Enterprise Management Studio, SSRS.

Confidential

SQL Server BI Developer

Responsibilities:

• Designed and developed SSIS packages to move data from production environment to different environments within the organization.
• Developed and maintained a combined data store for reporting purposes.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Generated daily, weekly and Monthly reports for the managers.
• Designed ETL architecture for data transfer from OLTP to OLAP with the help of SSIS.
• Installed and configured MS SQL 2005 along with Visual Studio on a network domain system.
• Migrated database from SQL Server 2000 to SQL Server 2005 using SSIS package.
• Designed and implemented SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS package.
• Designed and implemented database schema for data warehouse.
• Generated parameterized, drill down and drill through reports using Global variables, expressions and functions using SSRS.

Environment: MS SQL Server, Visual Studio 2005, DTS, Data Analyzer, MS Access, SQL Profiler, Windows XP, MS SQL Server 2005, SSAS, SSRS, SSIS.

Confidential

SQL Server BI Developer

Responsibilities:

• 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).
• Designed and created Microsoft Excel spreadsheets to implement mathematical data analysis models and to provide an attractive and functional user interface.
• Actively supported business users for change requests.
• Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
• Used Lookups Transformation to get the data from reference data sets.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Creating Reports as per user requirements using MS Reporting Services 2000/2005
• Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.

Environment: MS SQL Server 2005/2000, SQL Server Management Studio (SSMS), Query Analyzer, Enterprise Manager-SQL, SQL Server Integration Services (SSIS), Microsoft Excel, SQL Server Agent.