PROFESSIONAL SUMMARY:

• A Skilled software professional with 4.5+ Years of experience in creating OLTP and OLAP Data ware house using Microsoft SQL Server 2012/2010/2008 .
• Worked on the complete Software Development Life Cycle (SDLC).
• Excellent Knowledge in RDBMS Concepts and Data Modeling using Erwin 4.0, Star and Snowflake Schemas.
• Proficient in writing T - SQL Statements, Complex Stored Procedures, Dynamic SQL queries, Batches, Scripts, Functions, Triggers, Views, Cursors and Query Optimization.
• Experience in Installations, Up-gradations, Configuring and Maintenance of Microsoft SQL Server 2005/2008/2012 , Microsoft Visual Studio 2008/2010/2012.
• Created ETL Metadata Driven Framework to maintain standard across all ETL Developer and company standard.
• Responsible for performance tuningofstored procedures, Database Tables using TablePartitioning, SQL Profiler and Database tuning wizard.
• Hands on experience overallETL (Extract Transformation & Load) process.
• Skilled in High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, MySQL, PostgreSQL, flat file, Text Format Data) .
• Hands on experience in MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS) using Business Intelligence development studio (BIDS).
• Worked on upgrading from DTS to SSIS packages.
• Experience in designing Database Models using Microsoft Visio and creating class diagrams, activity diagrams, use cases diagrams, sequence diagrams and flow charts using UML.
• Experience in Design, Development, Implementation and Documentation of business requirements in Microsoft .NET framework 2.0/3.5 using Microsoft ASP.Net, Microsoft ADO.NET, C#.Net, VB.Net, Web Applications, Windows Applications and XML.
• Worked on Notification services in setting up the Scheduled jobs and alerts.
• Hands on experience on Data WarehouseStar Schema Modeling, Snow-Flake Modeling, FACT & Dimension Tables, Physical and Logical Data Modeling.
• Proficient in implementing the business logic to design/develop the Cubes,Aggregation, Masures using SQL Server Analysis Services (SSAS).
• Expertise in generating reports using SQL Server Reporting Services tool,Crystal Reports andPivot Charts/Tables in MS Excel Spreadsheet.
• Extremely motivated, diligent, conceptually strong team player with ability to take new roles and adapt quickly to new technology.
• Detail-oriented, results-driven, excellent verbal and written communication skills with interpersonal and conflict resolution skills and possesses strong analytical skills.

TECHNICAL SKILL:

Database: SQL Server 20012/2008r2/2008/, Oracle 11g/10g, MySQL, PostgreSQL, Microsoft Access.

Tools: & Technologies SQL Server Management Studio, Business Intelligence Development studio (BIDS), SQL Profiler, Query Analyzer, Export & Import (DTS), SSIS, SSAS, SSRS and SQL Configuration Tools, MS SharePoint 2010

ETL Tools: Data Transformation Services, SQL Server Integration Services, BCP, Import Export Data, Bulk Insert.

Data Modeling Tools: ERWIN, MS Visio.

Programming Language: T-SQL, ASP.NET, C#, VB.Net C, C++, Visual Basic

Web Tools: MS-Front Page, Visual Studio 2012/2010/2008 , XML, CSS, HTML, IIS.

Reporting Tools: SSRS, Crystal Reports, MS Access, MS Excel

Operating System: Windows/Windows Servers, Mac and Linux

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. BI developer/ SSIS/ SSAS / SSRS Developer

Responsibilities:

• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Maintained the database schema and all project in Team foundation server(TFS)source code control
• Developed the PL/SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
• Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS
• Implemented failure alerts using email in SSIS.
• Created complex prototypes, code, test, debug, document, and implement SQL and web application development.
• Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server 2008r2/2012Analysais Services (SSAS).
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008r/2012(SSAS).
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008r2.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports, Drill-through and Drill-down using SSRS/Report Builder 3.0
• Created dashboards for Inpatient,outpatient,Finance and safety using benchmarked data to provide an analytical snapshot of point in time data.
• Expertise in deploying SSIS Package, SSRS Reports and SSAS Cubes using command line utilities
• Modified custom page in SharePoint designer to permit users kick off specific workflows based on user selections and privileges.

Environment: SQL Server 2014/2008r2/, Oracle 11g (SQL Server Management Studio, SQL Profiler, Integration Service (SSIS), Reporting Services (SSRS)), SharePoint 2010/2013,.NET, C#, Windows Server 2008r2/2012/2014

Confidential, TOWSON, MD

Sr.BI Developer/ SSIS/SSRS/SSAS Developer

Responsibilities:

• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Maintained the database schema and all project in Team foundation server(TFS)source code control
• Developed the PL/SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
• Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS
• Implemented failure alerts using email in SSIS.
• Created complex prototypes, code, test, debug, document, and implement SQL and web application development.
• . NET is the framework for which we develop applications .
• The Common Language Runtime (CLR) is the environment where all programs in .NET are run.
• It provides various services, like memory management and thread management. Programs that run in the CLR need not manage memory, as it is completely taken care of by the CLR.
• All programs targeted to .NET are converted to MSIL (Microsoft Intermediate Language). MSIL is the output of language compilers in .NET.
• Created different hierarchical, interactive storage reports using C#.
• Collaborated with a team of .NET developers in designing and developing enhancements to a large enterprise application developed in C#.
• Designed GUI using C# and Designed database layers in C#.
• Created dashboards using Microsoft PerformancePoint.
• Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server 2008r2/2012Analysais Services (SSAS).
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008r/2012(SSAS).
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008r2.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports, Drill-through and Drill-down using SSRS/Report Builder 3.0
• Created dashboards for Inpatient, outpatient, finance and safety using benchmarked data to provide an analytical snapshot of point in time data.
• Expertise in deploying SSIS Package, SSRS Reports and SSAS Cubes using command line utilities
• Modified custom page in SharePoint designer to permit users kick off specific workflows based on user selections and privileges.

Environment: SQL Server 2012/2008r2/, Oracle 11g (SQL Server Management Studio, Agile,SQL Profiler, Integration Service (SSIS), Reporting Services (SSRS)), SharePoint 2010/2013, .NET, C#, Windows Server 2008r2/2012