SUMMARY:

• 8+ years of experience in Analysis, Design, Development, Deploy, Administration and Support of Applications using SQL Server 2000, 2005, 2008 R2, 2012, 2014 and MSBI 2005, 2008 R2, 2012 and 2014
• 9+ years of experiance in Microsoft Business Intelligence (SSIS, SSRS, SSAS) 2008 R2, 2012 and 2014
• 1+ years of experience in Microsoft Power BI
• Sound knowledge on OLTP, OLAP and Datawarehouse concepts
• Good experience in designing Databases, Tables, writing complex queries, stored procedures, functions, views, indexes
• Good knowledge on SQL server Installation,migragation, upgradation (SQL Server, SSAS, SSRS) and data transfer between servers
• Good experience in query performance tuning and profiler usage
• Had experience on setting up SQL Server - Replication, Mirroring, Log Shipping, Performance Tuning, Users & Security and Backup Strategies and Issue trouble shooting
• Good understanding of designing and implementing ofETL engines
• Strong experience in design, develop, deploy and support SSIS packages using SSIS 2005/2008 R2/2012/2014
• All Control flow / Dataflow tasks, Loops, Containers, Parameters, Variables, Event handlers, Post Deployment Configurations, Jobs, Scheduling
• Good experience in designing and implementing multidimensional cubes using SSAS multidimensional and SSAS Tabular
• Schema models, Dimensions, Facts, Hierarchies, Cube structure, Dimension usage, Partitions, Aggregations, Perspectives, attribute relations, Named query, Named Calculations, MDX, DAX queries
• Very good experience in Designing, Implementing and Deploying reports using SSRS 2005, 2008 R2/ 2012/ 2014
• Developed all types of reports like Plain, Parameterised, Cascading Parameters, Drilldown, Drillthrough, Subreport
• Implemented Dashboard and reports to multiple customers usng Power BI and deployed to office 365
• Created PBIX file from multiple data sources and then created tileson dashboards
• Experience onSDLC in service model as well as product life cycle like Product versioning, Branching, Roadmap, Applying patches…etc
• Good experience in preparing documents like ADD (Architectural Design Document), HLD (High Level Design), DDD (Detailed Design Document) and User Manual
• Working Experience on tools like Adept SQL, DB Scribe, Enterprise Architect and MS visio
• Experience in Leading Teams for multiple projects
• Good team player with good communication and mentoring skills
• Experience in driving multiple projects with multiple teams

TECHNICAL SKILLS:

SQL, TSQL, Database: SQL Server 2005, 2008 R2, 2012, 2014, Teradata

ETL: SSIS 2005, 2008 R2, 2012, 2014

Data Warehouse, Analysis: SSAS 2005, 2008 R2, 2012, 2014

Reporting: Power BI, PPS, SSRS, Excel, Tableau

Application Scripting: C#

Designing: Visio, Enterprise Architect

Operating Systems: Windows 2000, 2003, 2008, 2012

Other Tools: Adept SQL, DB Scribe

Documentation: Word, Power Point

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

MS BI Tech Lead/ Snr Developer/Architect

Technical Environment:Windows 2008 Server, SQL Server 2012, SSIS 2012, SSRS 2012, SSAS 2012, Excel Reports, Power BI, SharePoint 2010, Office 365

Roles & Responsibilities:

• Requirement gathering and analysis
• Designand implementation of Database and Data warehousefor the project
• Created Database, Tables, Complex queries, Stored Procedures, Functions, Views, Performance tuning
• Design and implementation of ETL mechanism, Reports and Dashboards
• Created around 30 packages to load different plants (Excel files) data into staging area
• Data models design and implementation
• Designed and Implemented multidimensional cube
• Created calculated measures
• Created many Report pages with different report views using Power BI
• Created Dashboards using Power BI and deployed into Office 365
• Created around 20 SSRS reports, 40 Excel reports
• Worked with offshore team of 4
• Demos and status calls with client

MS BI Team Lead / Architect

Technical Environment: Windows 2008 Server, SQL Server 2012, SSAS 2012, SSRS 2012, ASP.Net, Power BI, Office 365

Roles & Responsibilities:

• Requirement gathering, Analysis, Design
• Staging database and Datawarehouse design and development
• Data load logics from client database to application database
• Percentile calculations
• Front end screens design and co-ordination
• Data models design and implementation
• Developed Multidimensional cube
• Created SSRS reports from cube
• Implemented Power BI reports and Dashboard
• Working with offshore team
• Demos and status calls with client
• Customer interaction

MS BI Team Lead

Technical Environment: Windows 2008 Server, BODS, SQL Server 2012, SSAS 2012, Tableau, SharePoint 2010, SAP BI

Roles & Responsibilities:

• Understanding of the existing cube structure in SAP BI
• Staging database and Data warehouse design and development
• Data models design and implementation
• Implementation of cube in SSAS like SAP BI cube
• Data warehouse design and implementation
• Migrate Dimensions, Facts, Calculations to SSA from SAP BI
• New calculated measures
• Testing and comparisons with SAP BI system
• Demos and status calls with client
• Leading the front-end team of 3 people

MS BI Team Lead

Technical Environment: Windows 2008 Server, BODS, Teradata, SSAS 2008R2, SSRS 2008 R2, SharePoint 2010, PPS 2010, Tableau

Roles & Responsibilities:

• Database design and Implementation as per new CRs
• Writing very complex queries and stored procedures for SSRS reports
• Implemented SSRS report logics in VB.Net
• Semantic layer design for new CRs
• Deployment into different environments like QA, Pre-prod and Prod
• Reports and Status updates to customer
• Co-ordinating with other teams who are part of this project
• Trouble shoot and fix the issues/tickets received from end users
• Implementation of Enhancements and CRs
• Servers upgradations (Tableau, SSRS)
• Reports and Status updates to customer
• Coordinating with other teams who are part of this connect program
• Application Developments
• Leading the team of 9 people
• Newly written code review
• Testing of newly added logics before deploying them to Prod

Confidential, Philadelphia, PA

MS BI Team Lead

Technical Environment: Windows 2008 Server, SQL Server 2008 R2, .Net 4.0, SSIS 2008, SSRS 2008, SSAS 2008, SharePoint 2010, Power View 2010, Web Services

Responsibilities:

• Confidential is a science-led global healthcare company. We research and develop a broad range of innovative products in three primary areas of Pharmaceuticals, Vaccines and Consumer Healthcare longer. We have a significant global presence with commercial operations in more than 150 countries, a network of 89 manufacturing sites, and large R&D centers in the Confidential, Confidential, Confidential and Confidential .
• The Objective of this project is to collect the consolidated backend operations data from various source systems on Daily, Weekly, Monthly and Quarterly frequency into the system and generate Dashboards and Reports. Pulling the source data from Excel, CSV, SQL Server, Oracle, Teradata, SAP by mapping the source dynamically push it to data mart and process it by applying business logics and calculations based predefined metrics and generate dashboards and reports.

MS BI Team Lead

Technical Environment: Windows 2008 Server, SQL Server 2008 R2, .Net 4.0, SSIS 2008, SSRS 2008, SSAS 2008, SharePoint 2010, Power View 2010, Web Services

Roles & Responsibilities:

• Requirements gathering and analysis
• Architectural Designs for applications and products including database design, Cubes design, Dimensions and Facts design
• Developing Staging, Data warehouse and DataMart’s
• Designed Architecture for CRP Phase 1 (Application) include ETL, Databases, Warehouses, Cubes
• Designed Architecture for CRP Phase 2 (Product)
• Designed warehouses for 3 projects (Aricent, CRP Phase 1 and Phase 2) include ETL, Databases, Warehouses, Cubes
• Writing complex queries, stored procedures and Views
• Dimensions and facts development
• Data models design and implementation
• Database, SSIS packages testing
• Cube, Calculated measures testing
• Code review

MS BI Team Lead

Technical Environment:Windows 2008 Server, SQL Server 2008 R2, SSIS 2008/SSRS 2008/SSAS2008 R2, Java, Web service

Roles & Responsibilities:

• Requirements gathering and analysis
• Database design for the project
• Created tables, stored procedures, functions and views
• Written complex queries and business logics in SQL
• Created SSIS packages to load the data from flat files
• Encryption and decryption of data before loading and after processing
• Application testing
• Database logics testing
• SSIS packages testing
• Database code review

MS BI Developer

Technical Environment: Windows 2008 Server, SQL Server 2008 R2, SSIS/SSRS/SSAS 2008 R2, .Net.

Roles & Responsibilities:

• Created couple of dashboards by using PerformancePoint Server 2010
• Created around 18 packages by using SSIS to import the data to SQL Server
• Identifying the customer requirement and Created around 80 reports for various stake holders like Drill down reports, Sub reports, Drill through reports…etc
• Regular monitor on reports functionality, reporting servers and issues fixing
• Upgraded SQL Server, SSRS Production server from 2005 to 2008 R2
• Responsible for the Change requests and estimating the dates.
• Responsible for assigning the tickets to the right resource and monitoring the status
• Configured Transactional Replication
• Logins, Roles, Users security and backup strategies
• Design the application and database architecture
• Developed entire database and business logics
• Designed and implemented Cube
• Written complex queries and stored procedures for business logics
• Developed Dashboards and reports
• Application testing
• Code deployment to QA and Prod environments