SUMMARY

• Around 6 years of IT experience in database design, development and business intelligence of Microsoft SQL Server 2008/2008R2/2012 across domains like health care, Banking, Insurance and Finance.
• Extensive experience in MS SQL Server 2008/2012 with Business Intelligence in SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis.
• Extensive knowledge of Relational Database Management Systems (RDBMS).
• Experience in installation and configuration of SQL Server 2008 and 2012.
• Proficient in logical and physical data modeling, Forward and Reverse engineering using Erwin, Normalization, de - normalization and building Referential Integrity Constraints.
• Experience in creating databases, transactions, tables, indexes, constraints, writing and debugging stored procedures, triggers, views, functions and cursors using.
• Expert in monitoring SQL Server Performance, troubleshooting using Execution Plan, SQL Profiler and Index Tuning Wizard.
• Extensive experience in creating various reports using Reporting Services (SSRS 2008 R2/ 2012) and Deploying and managing reports on Report Server and SharePoint Server.
• Experience in creating different kinds of subscriptions to deliver reports to users on schedule basis.
• Experience in creating visualizations and dashboard reports using Tableau Desktop.
• Experience in ETL process using Integration Services (SSIS) SSIS Import ExportData, Bulk Insert, BCP and DTS/SSIS Packages.
• Experience in creating, deploying and automate SSIS Packages.
• Automating the Database Maintenance tasks, SSIS packages by creating Jobs using the SQL Server Agent.
• Experience in business intelligence/data warehousing practices and tools (including SSAS)
• Extensive experience in creating multiple reports (SSRS) including parameterized reports, Tabular forms, Matrix forms, Drill-down reports, Drill-through reports, Charts, Sub-reports using SSRS2012/2008
• Knowledge in developing SSAS cubes using visual studio 2008 R2/2012. Creating reports from cubes using MDX
• Experience in implementing Partitions, Aggregations, and handling many to many relationships between tables in the cube.
• Worked on source code control systems like TFS.
• Knowledge of VB, C#.NET, ASP.NET, ADO.NET.
• Knowledge of Agile Methodology. Experience in working with offshore team.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Excellent Written, Analytical Skills, Verbal Communication skills with a customer service oriented attitude.

TECHNICAL SKILLS

Database Management System: MS SQL SERVER 2012/2008R 2/2008/2005/2000, MS-Access,DB2

Database Utilities: Enterprise Manager, query analyzer, SQL server, Profiler, SQL Server Management Studio.

ETL Tools: SQL Server integration services (SSIS), Data Transformation Services

Reporting Tools: MS SQL Server Reporting Services, Crystal Reports,Tableau

Programming Language: TSQL, SQL,C,C++,VB,C#.NET

Operating Systems: WindowsServer 2000/2005/2008/2008 R2/2012

Utility Tools: MS Office, Visual Source Safe 6.0

PROFESSIONAL EXPERIENCE

Confidential, Detroit

SSRS, SSIS developer

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• As a Team Player, involved in gathering the Business Requirements for Extraction of Data from different sources.
• Responsible for database design and creation of tables, views and functions.
• Developed custom reports using SSRS/SQL Server BI studio.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
• Designed and built OLAP cubes to meet reporting needs.
• Worked on project parameters in SQL Server data tools 2012 and referenced them in the packages of the project.
• Designed cubes with star schema using SQL Server Analysis Services 2012(SSAS). Created several dashboards with Key Performance Indicators.
• Understanding OLAP process for changing and maintaining the warehouse, optimizing dimensions, hierarchies and adding the aggregations to the cube.
• Used source code control systems like TFS.
• Extract Transform Load (ETL) development using SQL 2012/2008 Integration Services (SSIS).
• Created SSIS packages using various Data transformations like conditional splitting, Fuzzy Look Up, for each Loop, Multi Cast, column conversion, Fuzzy Grouping.
• Used system stored procedures and DBCC commands.
• Wrote some complicated stored procedures in order to meet the requirements.
• Successfully migrated the data from various sources such as Oracle, Flat files, Excel files and MS Access.
• Created new SSIS packages for Extracting data using Sequence Container, For Each Loop, Container, Execute SQL Task, Merge Transformation etc.,
• Modified the Existing SSIS Packages to improve the performance of Data Load.
• Generated Quarterly, Semi-Annual and Annual reports through Tabular and Matrix reports using SSRS Reporting tool.

Environment: MS SQL Server 2005/2008/2012, MS SQL Server Reporting Services 2005/2008/2012, T-SQL, Oracle 11g., SSAS 2012

Confidential, Columbus, OH.

SQL BI Developer

Responsibilities:

• Involved in gathering, understanding and validating the project specifications.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for generating reports using SSRS.
• Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
• Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules using T-SQL.
• Designed, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services 2012.
• Developed complex T-SQL queries for the ETL packages.
• Designed packages in SSIS2012 with various complex transformations such as derived column, conditional split, lookup, aggregation, execute SQL task.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Created user variables, property expressions, script task in SSIS.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS. Expert in SSIS Deploying and Scheduling packages
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Designed Cascading (Collapsed), Printable, interacted reports (drill-down and sorting functionality).
• Responsible for deploying reports to report manager and troubleshooting for any error occurs in execution.

Environment: MS SQL Server 2005/ 2008/ 2012, T-SQL, MS SQL Integration Services 2008/2012, MS SQL reporting Services2005/ 2008 R2/ 2012.

Confidential, NJ

MSSQL Server / BI Developer

Responsibilities:

• Developed T-SQL queries, stored procedures, functions and triggers for this complex integration. Actively involved in different stages of Project Life Cycle.
• Generated reports (using SQL Server Reporting Services) based on the user requirements to produce detailed summary for analysis.
• Developed complex Stored Procedures, triggers, cursors, tables, constraints, views and other SQL joins and statements for applications.
• Using all kinds of SQL ServerConstraints(Primary Keys, Foreign Keys, Defaults, Check, Unique etc.).
• Writing ComplexT-SQLQueries, Sub queries, Co-related sub queries and Dynamic SQL queries.
• Scheduled Jobs on various stored procedures and packages to automate processes.
• Created SQL server Reports using SSRS 2008. Created drill down reports, drill through reports, charts report and parameterized Reports in SSRS 2008.
• Identified the data source and defining them to build the data source views. Generated Reports using global variables, expressions and functions for the reports.
• Responsible for deploying and managing reports on Report Server.
• Responsible for creating various kinds of Subscriptions like Email subscriptions and File Share Subscriptions.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created packages in SSIS with error handling worked with different methods of logging in SSIS.
• Experienced in critical problem solving, building tools to integrate and manage large sets of data.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.

Environment: SQL Server 2008, 2012, SSRS 2008 R2, SSIS, .Net Frame Work, ADO.Net, ASP.Net 4.0, XML, Java Script, C#

Confidential, IL

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Designed ER diagrams (Physical and Logical using Erwin) and mapped the data into database objects.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed source/target analysis of data structures & content.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Published reports and dashboards on WEB.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, and Stored procedures.
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
• Used data compression techniques for Back Up.
• Involved in analyzing data and developed models on the analyzed data.

Environment: SQLServer2005, 2008, 2012, SSRS 2008 R2, SSIS, SSAS .Net Frame Work, VB.Net, ASP.Net, XML, VB6, VB Script, Java Script, C#

Confidential

MS SQL Server Developer

Responsibilities:

• Actively participated in gathering business requirements and system specifications.
• Created new databases, tables and established relationships between the tables in the database.
• Created efficient stored procedures and functions to support organized data storage and manipulation.
• Created views to display required information on user interface and trigger to validate consistent data entry into the database.
• Extensively involved in writing stored procedures, triggers, common table expressions and functions based on client requirement.
• Created and administered multiple developments, production and training databases.
• Reduced system downtime risk through automatic offsite backup and recovery over network.
• Responsible for installing and configuring SQL Server 2005 on Windows NT Operating systems.
• Used BCP utility to publish table output to text files.
• Identified, tested and resolved database performance issues like monitoring and tuning to ensure database optimization
• Maintained SQL scripts for changes in database objects.
• Involved in running trace from the profiler to troubleshoot database and used DBCC check commands to check the consistency of the database.
• Provided support for database backup/restore and database transfer activity from test environment to production environment.
• Set up SQL mail and created jobs to automate and schedule many tasks.
• Involved in support team and helped in 24X7 production support.
• Involved in coordinating post-implementation events such as testing.

Environment: SQL Server 2005, T-SQL, Windows NT, MS Access, Visual Basic 6.0, Enterprise Manager.