SUMMARY:

• Result - driven IT Professional with 7+ years of expertise in database design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008 R2/2008/2005 in development, test and production environments.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2014/2012/2008 R2/2008.
• Highly skilled in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Expert in developing report using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Good experience in creating Dashboards using QlikView.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Strong experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in SQL Server 2012 Self Service BI tools like PowerView, BISM Tabular models and SQL Server Data tools.
• Strong experience in creating dashboards using gauges and charts for analysis using SSRS 2008 R2.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in Performance Tuning and Query Optimization.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Strong technical experience in Web technologies like C# and ASP.NET.
• Experience in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.

TECHNICAL SKILLS:

SQL Server Tools: SSDT, SSMS, BIDS, Report Builder, DTS, Profiler, DTA, Upgrade Advisor

Monitoring & compliance Tools: Lite Speed, Spotlight, SCOM, SQL Secure

ETL & Reporting Tools: SSIS, SSRS, SSAS, Excel 2013, Power View, PowerPivot, PPS, Tableau

Databases: SQL Server 2014/2012/2008 R2/2008/2005, Oracle 9i, 10g, Teradata, SAP

Programming Languages: SQL, T-SQL, PL/SQL, C, C++, Java, C#, VB

Operating Systems: Windows 95/98/NT, Windows XP/2003/2000, UNIX, MS-DOS

Web Technologies: AngularJS, HTML, XML, VBScript, SharePoint 2010, C#, ASP.NET, VB, .NET

Tools: Erwin, VS 2008/2005, Visio, TFS, Visual Source Safe, Sub Version

PROFESSIONAL EXPERIENCE:

Confidential - Indianapolis, IN

Sr. SQL/BI Developer

Roles & Responsibilities:

• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Extracted data from Oracle and migrated into SQL Server 2005 using SSIS .
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS) .
• Worked on different kinds of Transformations in SSIS like Slowly changing dimension (SCD’s), Lookup, Merge, Derived column, Multicast, Conditional split, Aggregate, Fuzzy lookup, Pivot and Un-Pivot as per the client requirement.
• Architected and developed QlikView business intelligence dashboards, reports and ETL scripts extracting data from Oracle, Logs, MySQL, MS SQL and XMLs. Lead generation, editorial.
• Worked in Object Oriented Analysis and Design in C#.
• Created Configuration Files for Packages and SSIS logging on XML Files.
• Developed different kind of reports such a Dashboards , Sub Reports , Charts , Matrix reports , Linked Reports Using SSRS .
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS .
• Identified and worked with parameters for parameterized reports in SSRS in SQL Server 2008R2.
• Scheduled SSRS 2012 Data alerts on mission critical reports to send alerts based on business rules.
• Used SSRS reports with parameters from PerformancePoint Services deployed in SharePoint 2013.
• Participated in the design and development of the Data Warehouse using Star Schema and Snowflake Schema.
• Involved in creating new logical and physical design of the database to fit new business requirements and implemented new design into SQL Server 2012.
• Developed SSAS Cubes by creating Measure Groups, Dimensions, Aggregations, Hierarchies, Partitions and Perspectives using SSAS 2008 R2.
• Setup and monitored jobs for loading and processing SSAS Cubes.
• Involved in process building and maintaining different platforms including SQL Azure 2012 servers.
• Involved in building the Synchronization process between multiple servers across different platforms like Oracle, SQL Server 2008, SQL Azure, SQL Server 2012 etc.
• Designed SSIS packages in SQL BI to extract data from Salesforce.com using WSDL (web service) feed and to integrate with the report delivery system integrated with the enterprise portal.
• Troubleshoot issues with ETL load (SSIS and Stored Procedures) and Cube processing.
• Created ETL technical specification documents describing ETL design and load strategies to populate operational data store and DataMart’s.
• Involved in Automation of ETL processes and jobs using PowerShell to reduce manual intervention.
• Utilized CMC to administer Business Objects including deployment and export of BIAR files.
• Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.
• Used SSRS reports with parameters from PerformancePoint Services deployed in SharePoint 2013.
• Participated in code-review sessions on existing SSRS report’s performance and Dataset query tuning.
• Designed and created Crystal Reports based on technical specifications provided.
• Developed MDX queries for SSRS reports from SSAS Cubes.
• Created script tasks and components with C++.C# and VB.NET in SSIS as part of ETL load.
• Developed power view reports using Tabular Models in SQL Server Data Tools.
• Installed SQL 2012, TFS 2012. Migrated all the scripts and objects from SQL 2008 to SQL 2012
• Created standard and data driven subscriptions for weekly, monthly and daily reports.
• Involved in Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.

Environment: SQL Server 2014/2012/2008 R2/2008, Teradata, SharePoint 2013/2010, SQL Server Data Tools, T-SQL, SSIS, SSRS, SSAS, BIDS, Tabular, Excel 2013,XL-Cubed, PowerView, TFS, Power pivot, PL/SQL 8.0and Central Management Console, Performance Point, MDX, Report Builder 3.0,Crystal Report 8.0, DTS, C#,C++, VB.NET, Erwin 4.0,XML, SVN, Rally, Windows Server 2008, NET 3.5

Confidential - Woonsocket, RI

SQL/BI Developer

Roles & Responsibilities:

• Design and develop Business Intelligence solutions using MSBI tools (SSIS, SSRS and SSAS).
• Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE’s, Views, Joins and Triggers.
• Write and debug T-SQL Queries, SSRS Reports, SSIS Packages and Stored Procedures.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL .
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Worked as Data Base Administrator (DBA).
• Extensively used WEBI, to create ad-hoc and schedule complex reports, and Central Management Console (CMC ).
• Enhanced and translated existing dashboards in SSRS into QlikView and worked extensively with the set analysis.
• Responsible for providing 24x7 Production support, Database and Log Backups & restoration, Backup strategies and scheduling Backups.
• Created SSIS packages to capture the Incremental changes for the Data warehouse.
• Designed and developed SSIS packages to load data from Flat files, Excel to Data warehouse using C#.NET.
• Developed complex mappings using SSIS to transform and load the data from various source systems like Oracle database, DB2 and Teradata database, Excel, Flat files into the SQL 2012 Server target staging database.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Generating PowerShell scripting to avoid errors and also used for SSRS.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Developed Dashboards, Gauges, Tabular, Matrix, Charts, Crystal reports Parameterized and Sub-reports in SSRS 2012/2008 R2.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services ( SSRS).
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Using SSRS creating well-formed reports and web-based reports for health related applications and transactions.
• Worked in Object Oriented Analysis and Design in C#.
• Worked on JSON objects in Web API REST Services and SOAP.
• Supported, modified and maintained Crystal Report currently in the production environment.
• Developed complex formulas in Crystal Report for reporting calculations and metrics.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Involved in performance tuning the slow running reports and stored procedures by creating appropriate indexes and analyzing execution plans.
• Created data-driven subscriptions in SSRS using windows file share as well as Email subscriptions
• Used complex queries and Stored Procedures for generating real-time operational SSRS reports.
• Used Excel Pivot tables to manipulate data in order to perform data analysis.
• Used A ngularJS framework and integrated with SQL Server DB.
• Developed reports with cascaded parameters from SSAS Cubes using MDX queries and Calculated Members.
• Developed SSAS Cubes using Star Schema with partitions, aggregations, hierarchies and perspectives.
• Developed SSRS and Excel Power pivot table based on OLAP Cubes.
• Used Subversion (SVN) for source control, to deploy the code from Dev to QA, QA to Prod.
• Used ADO.NET to extract data from database.
• Worked on LINQ for query the data objects in C++, C#, VB.net.
• Responsible for Servers in SharePoint - Installed and configured SharePoint 2010, maintenance of Web Front End Servers, Indexing Servers, and maintaining Database servers.
• Participated in Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Participated in SQL Server 2014installation, Violin Flash Memory and POC on new features.
• Troubleshoot and resolve issues reported by business users.
• Develop and direct software system testing and validation procedures, programming, and documentation.
• Used Team Foundation Server (TFS) for central repository as a versioning control.

Environment: SQL Server 2014/2012/2008 R2/2008, Oracle 11g, Teradata, SAP, SharePoint 2013/2010, SQL Server Data Tools, T-SQL, SSIS, SSRS, SSAS, SQL Server BIDS, Tabular, Excel 2013, PowerView, TFS, Power Pivot, Performance Point, MDX, Tableau, Report Builder 3.0,Crystal Report 8.0, DTS, C++,C#, VB.NET,JSON, Erwin 4.0,XML, Violin Flash Memory, Windows Server 2008, .NET 3.5

Confidential - Atlanta, GA

SQL Server BI Developer

Roles & Responsibilities:

• Created database objects in SQL Server 2005 including Tables, Triggers, Views, Stored Procedures, User Defined Functions (UDF) and Indexes.
• Involved in Testing and Debugging Stored Procedures and functions, database tuning.
• Created jobs and monitored job history for maximum availability of data and to ensure consistency of the databases.
• Designed new databases according to Business requirements like logical design and physical design.
• Migrated Multi Terabytes databases and users, logins, stored procedures and tables using DTS/SSIS packages from MS SQL Server 2000 to MS SQL Server 2005 .
• Created SQL Server Integration Service packages (SSIS) and used it to Extract, Transform and Load (ETL) into Database tables.
• Used PowerShell script for SQL Server Maintenance activities.
• Generated database monitoring and data validation reports in SQL Server Reporting Service ( SSRS ).
• Deployed SSIS packages and Reports to Production Servers.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created SSIS packages to load data into SQL Server using various transformations in SSIS .
• Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse.
• Experienced in ETL using DTS Import/Export Data, Bulk Insert, BCP, Data Replication and DTS Packages.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS .
• Created Parameterized reports, Cross-Tab reports, Drill down reports ; Summary reports by using SSRS and designed reports using Crystal Reports
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created several Complex Reports (sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarized and conditional formatting) using SSRS .
• Created Jobs Performance report that queries sys tables and shows how long each job ran and weekly-average duration using SSRS .
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created report snapshots to improve the performance of SSRS.
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2005 database and performed tuning on it.
• Migrated database from SQL server 2000 to SQL server2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures.

Environment: SQL Server 2005, Windows 2000/2003,T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2008, Visual Studio 2005, Visual Team Foundation Server.

Confidential

SQL Developer

Roles & Responsibilities:

• Conducted performance tuning/MS SQL Server development - SQL Profiler, SQL scripts, Stored Procedures, Triggers, Functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer).
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Created and developed Stored Procedures and Triggers to handle complex business rules, history data and audit analysis.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager.
• Created and administered multiple development, training and production databases.
• Developed and created data dictionary, advanced queries, views, indices and functions for databases.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Data migration (import & export - BCP) from Text to SQL Server.

Environment: MS SQL Server 2005, T-SQL, DTS, Windows XP, MS Visio 2000 and MS Projects 2000