PROFESSIONAL SUMMARY:

• Extensive 8+ years of experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using MSSQL Server 2005/2008/R2/2012.
• Involved in hard Coding and data analysis of Complex Queries, Ad hoc queries, heavy stored procedures, Batch Scripts, Triggers, and Functions using T - SQL.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard and SSIS.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculate metrics that were revealed in functional analysis.
• Experience in creating datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Experience in developing applications using C#. Net, VB.Net. /SharePoint technologies.
• Designed front-end in VB.Net 2008 for crystal report for live core banking project.
• Developed SQL scripts to handle different databases of insurance applications and created front end application in VB.Net 2005 to achieve desired results and data.
• Design and develop Windows Forms using VB.Net, SQL Server 2000 and Infragistics.
• Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
• Experience building various web and desktop applications under .Net Framework using ASP.Net, C#, ADO.Net, ADO.Net, and Entity Framework to SQL Server.
• Used ADO.Net Entity Framework to connect, retrieve a manipulated data with database operation by implementing Data Access Layer.
• Extensive Knowledge in SSAS storage, partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX, DAX and SQL.
• Good Knowledge in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX, DAX.
• Extensive experience in Enterprise Data Management (MDM, BI/ETL) as an developer, business Intelligence.
• Design and develop ETL solutions for Data Warehouse. Implement Master Data Services (MDS) on SQL Server 2012.
• Developed reports & Dash board by using excel services and business Intelligence.
• Design and create dash board reports which illustrate the data in tabular format and well formatted charts.
• Expertise in Enterprise Reporting in generating reports using linked reports, sub reports and filters, charts in SQL server reporting services.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Excellent communication and interpersonal skills and has ability to handle multiple tasks; can take initiative to handle responsibilities independently as well as a proactive member of a

TECHNICAL SKILLS:

• MS SQL Server Integration Services 2012/R2/2008/2005, SQL, SSIS, C#, VB.net, ADO.NET, T-SQL, Crystal Reports9.0, Data Modeling, Visual Basic, ASP.Net, Microsoft Visio, Scripting tuning HTML, XHTML, XML, CSS, JavaScript, AJAX, OLAP, OLTP, IBM, UNIX scripts, Dash-board using Crystal Reports, MDX, DAX and SQL, MDM, MDS, MS SQL Server 2005/2008/2008 R2/2012, Oracle 10g, MS Access, MS DOS, SQL, complex database structures and maps, WinNT/2000/2003/XP, PowerShell, Arc-GIS, MapPoint 2010, Erwin.
• Databases
• T: SQL, PL/SQL, Dynamic SQL, MDX, C, XML, HTML, HTTP, Shell Scripting Oracle, MS-Access, MS SQL Server, Teradata, MS SQL Server (2014, 2012, 2008R2, 2008, 2005), Oracle 9i/10g (SQL, PL/SQL, Stored Procedures, Triggers)
• DWH / BI Tools
• SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports
• Design & Modeling
• MS Visio, ERWIN 4.5/4.0, Star Schema, FACT & Dimensions tables, Physical & logical data modeling and De-normalization techniques, FACT, Physical and logical data modeling
• Packages
• MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007
• Tools: and Utilities
• SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, DTS, Business Intelligence Development Studio (BIDS),Crystal Reports, Power Pivot, Microsoft Office, Excel Power Pivot. Excel Data Explorer, Tableau.
• Operating Systems
• Windows Vista/XP, NT, MS: DOS and UNIX
• Languages
• C, C++, MDX, SQL, T-SQL, PL/SQL, Visual Basic, C#. ASP.NET, My SQL, HTML, CSS, XML
• Source control tools
• TFS, Visual Source Safe, SVN

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SQL Server / BI Developer

Responsibilities:

• Excellent report creation skills using Microsoft SQL Server 2014/2012/2008 R2 Reporting Services (SSRS) with skill in using Report Designer as well as Report Builder.
• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2014/2012/2008 (SSAS)
• Worked on OLAP Data Warehouse Analytics, Model, Design, and Implementation.
• Experience in Modeling and designing SSAS Analytics Multidimensional cubes.
• Developed Complex Stored Procedures, Views, and Temporary Tables as per the need.
• Responsible for developing and maintaining Tableau dashboards.
• Used MDX and DAX queries to apply calculations to the cube in SSAS 2014/2012/2008 .
• Developed reports like Claim Statements, Fee Bills Transactions, and some end request user reports on periodic basis.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Developed interactive pages of the application using ASP.NET, ADO.NET, Ajax, Entity Framework, Web Forms, pages with C# for the code behind modules and agile methodologies for .Net Framework.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
• Worked in Agile/Scrum Methodology with daily stand up meetings and vast knowledge in TFS (Team Foundation Server) 2010.
• Performed Testing, Debugging and Migrating ASP.Net Website from Visual Studio 2005 to Visual Studio 2010.
• Major responsibilities include getting requirements from the user, writing stored procedures for reports and developing reports using Crystal Reports 2008.
• Write Technical specification for the related work for each SSAS Tabular models.
• Used recently introduced Power BI to create self-service BI capabilities and use tabular models.
• Using Excel and VBA in the development of robust and flexible reporting systems.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle)
• Created Power BI Reports using the Tabular SSAS models in Power BI desktop and published them to Power BI Service.
• Experience on publishing Power BI reports on dashboards in Power BI server.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Qlikview.
• Worked with live, import data into Power BI for creating reports, and managed relationship between tables in Power BI using star schema.
• Execution of SQL queries to extract data from DB2 tables for running test scripts.
• Extracted data from SQL Server 2014/2012/2008 into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL.
• Created integration part to connect CRM with SharePoint2010.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.
• 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.

Environment: SQL Server 2014, 2012, SSIS (2012/2008), SSRS (2012/2008), SSAS 2012/2008, Visual Studio 2010/2013, MS Excel 2010, TFS (2012), MS Power BI, QlickView

Confidential, Columbus, OH

MS SQL Server SSIS Developer

Responsibilities:

• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Generated several drill down and drill through reports using SSRS.
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from SQL Server 2012 MS Excel and Flat files.
• Involved in migration from SQL Server and 2014.
• Used various transforms in SSIS to load data from flat files to the SQL databases.
• Created ETL packages using SSIS to extract data from relational database and then transform and load into the data mart.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
• Prepared Visio diagrams/documents to track and implement the blueprint of the ETL dataflow/process implementation from Initial phase, Ongoing, Deployment to Production Environment.
• Created SSIS packages to mitigate into the data warehouse database from heterogeneous databases/data sources.
• Involved in Visual Studio 2012 and Synced/loaded projects with TFS 2010.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages
• Write Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2012.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Used Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server databases.
• Used Visual Team Foundation server for version control, source control and reporting.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views using T-SQL code and SQL joins for applications.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS 2012
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Developed and Updated Web application in bootstrap, MVC5 and SQL2012 (BI Stack) to improve the processing mechanization over 20%.
• Created and modified UNIX Shell Scripting according to the changing needs of the project and client requirements.
• Supported application written in Oracle PL/SQL and converted into T-SQL packages.
• Created data extraction ETL jobs using SSIS, DTS, extracting data from MS ACCESS, Oracle and MS Excel and loading into SQL Server Databases.
• Participated in Databases Architecture and data modeling design.
• Created SQL Server Reports using SSRS 2012.Identified the data source and defined them to build the data source views.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL.
• Advanced extensible reporting skills using SQL Server 2012 Reporting Services (SSRS).
• Creating Star and Snow Flake Schema design using Visio, defining relations between tables.
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report.

Environment: MS SQL Server 2008R2 & 2012 Enterprise Edition, Microsoft Visual Studio 2012 MDX, T-SQL, Oracle PL/SQL, MS Access, MS Excel, Windows 2008 Server, Tableau, OLAP, Visual basic .NET, UNIX.

Confidential, Columbus, OH

SQL Server SSIS/SSRS Developer

Responsibilities:

• Responsible for creating reports based on the requirements using SSRS 2008 R2/2012. Worked on generating reports using Crystal Reports, SQL Server Reporting Services and Excel spreadsheet. Created complicated reports like parameter based reports, graphical reports, excel reports, drill-down chart and tabular report using SSRS2008 R2/2012.
• Continuously interacted with users to gather the business requirements.
• Created design specification documents for the new reports developed through SSRS.
• Published ad-hoc reports through Report Manager.
• Involved in hard Coding and data analysis of Complex Queries, Ad hoc queries, heavy stored procedures, Batch Scripts, Triggers, and Functions using T-SQL.
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report.
• Data Driven Subscription both Email And Windows File Sharing.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users to look at them.
• Fine-tuned existing reports by running execution plan on queries and identifying tables that need indexes
• Provided database technical support to ASP.NET application developing team to optimize existing Auto Insurance Query System. Troubleshot slow issues and optimized data access in SQL server.
• Involved to build Customer Information Management System with application developing team, provided supports on connection between front end and database (data access).
• Designed and Created databases, tables, views, stored procedures and triggers.
• Modified existing database by adding tables and relationships.
• Perform SQL Server 2008R2 backups and restores.
• Resolve SQL Server 2008R2 server job failures.
• Build and configure SQL Server 2008R2 servers.
• Creating Star and Snow Flake Schema design using Visio, defining relations between tables
• (Primary keys, foreign keys).
• Designed, modified and troubleshoot SSIS packages.
• Utilized SSIS Checkpoint, Loading Dimension with the SSIS slowly changing Dimension Wizard and used different SSIS Control Flows.
• Created ETL in DTS packages by using Data Transform Task, VBScript task, SQL task and send Email task to migrate data from different functional databases into SQL Server 2008R2/2012.
• Created notifications, alerts to let support team know in case there are any failures.
• Migrated database from SQL server 2008 R2 to SQL Server 2012 using both Copy Database Wizard and Detach & Attach method.
• Configured Error and Event Handling: Precedence Constraints, Break Points, Check Points,
• Logging, TRY and CATCH Blocks.

Environment: MS SQL Server 2008R2 /2012, Management Studio(SSMS), ETL, ASP.NET, Crystal Reports9.0, Data Modeling, OLAP, Data warehousing SSIS, C#, VB.net T-SQL, DB2, SSAS, SSIS, SSRS 2008 R2/2012, IBM, UNIX scripts, MS SQL Server 2005/2008/2008 R2/2012, Oracle 10g, MS Access, MS DOS, SQL, complex database structures and maps, WinNT/2000/2003/XP, PowerShell, Arc-GIS, MapPoint 2010, Erwin.

Confidential, Columbus, OH

MS SQL Server SSIS Developer

Responsibilities:

• Involved in designing, reviewing, and creating Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.
• Optimized Query Performance, Session Performance and Reliability.
• Designed Extract Transform Load (ETL) process to populate the data warehouse using SSIS
• Loaded Data to the Interface tables from multiple data sources such as MS Access, Oracle, Text files and Excel Spreadsheets using SSIS.
• Data access layer implemented using ADO.NET with Database .
• Implemented ADO.NET concepts to connect to the database. SQL .NET Data provider, Data Adapter and Data Set were used to retrieve and access data.
• Applied various data transformations such as SCD (Slowly Changing Dimension) to maintain the history of the data, Aggregate, Sort, Multicasting, Conditional Split and Derived column.
• Developed Query for generating drill down reports in SSRS 2008. Prepared AD HOC reports through report builders.
• Generated Reports using Expressions and Functions for the reports using SSRS 2008.
• Generated Snapshot, Drill Down, and parameterized reports using SSRS
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Enhanced the functionality in database and data warehousing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).

Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),, C#, VB.net, ADO.NET, SQL Profiler/Analyzer, Management Studio, OLAP, OLTP, Import/Export Wizard, Excel, Arc-GIS 10.0, Map Point 2010 .

Confidential

MS BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Created SSIS Packages to transfer data from various sources like Text Files, SQL Server, Excel and Access to SQL Server.
• Developed C# scripting for packages using Scrip task
• Involved in upgrading packages from SQL server 2005 to SQL server 2008
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Involved in creating OLAP cubes and dimensions for the analysis using SSAS.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Used SQL Server profiler for auditing and analyzing the events, which occurred during a particular time horizon and stored in script.
• Involved in the design and development of web forms for the application using ASP.Net to take care the cosmetic works of the reports deployed on the server.
• Used "SQL Profiler TSQL Duration" template for tracking execution time of TSQL Statements.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL Server 2005 SSIS, SSRS, SSAS, Visual Studio 2005, VSS 2005, Erwin 7.2, Oracle PL/SQL, Windows NT/2003.