SUMMARY:

• 9+ years of IT experience in the Analysis, Design, Development, Implementation and Testing Client/Server applications using Microsoft SQL Server 2005/2008/2008 R 2/2012/2014/2016 and Business Intelligence Suite.
• 5+ years of experience in Microsoft’s Business Intelligence technologies (SSAS, SSRS, SSIS)
• 3+ years of experience in designing, developing, optimizing and administering SSAS Tabular Models
• Used 2012, 2014, 2016 versions of SSAS to develop tabular models and expertize in performance tuning of Tabular cubes
• Expertise in creating OLAP cubes and developing complex calculations, Aggregations, implementing dynamic security model using MDX functions in SSAS.
• Expertise in designing efficient processing strategies of SSAS Cubes for both incremental and full processing options.
• Expertise in implementing complex Confidential , MDX calculations to solve complex business scenarios
• Experience in configuring security, Organizational Content Packs, data Gateways, refresh schedules for PowerBI service.
• Experience setting up reporting platforms ground up in Microsoft technology stack (Sharepoint, SSRS, PowerBI, PowerPivot, SSAS, Confidential, MDX,T - sql, DimensionalModeling, SSIS)
• 4+ years of experience with PowerPivot
• Used PowerQuery to acquire data and PowerBI desktop for designing rich visuals
• Good understanding of BI semantic model and how Microsoft’s Business Intelligence stack (SSAS cubes, SSRS, performance point, PowerPivot) fits into Sharepoint
• Good understanding of Facts, Dimensions, KPIs
• Experience in designing Star, snowflake schemas for Data Warehousing and OLAP needs
• Good experience using Excel for data management and Dimensional modeling
• Extensive experience in data migration between homogeneous & heterogeneous systems using various tools (Bulk Insert and SSIS).
• Extensive experience in T-SQL to write: stored procedures, triggers, functions, tables (including Partitioned Tables), views, indexes and relational database models.
• Expertise in extracting, transforming and loading (ETL) of data using SSIS Packages.
• Expertise in writing performant MDX, Confidential queries against cubes for SSRS datasets
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2012/2008R2/2008.
• Expert in developing Drill through and Drilldown reports using MS SQL Server Reporting Services (SSRS)
• Extensively used performance monitor/SQL profiler/DMVs to solve dead locks, to monitor long running queries and trouble shoot cubes
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled SSIS Packages based on Business or application needs
• Experience developing dashboards using performance point services 2010, SSRS and deploying to the SharePoint.
• Experience in migration of Data from Excel, Flat file and Teradata to MS SQL Server by using SSIS packages
• Thorough understanding of OOPS programming style with respect to C# language.
• Thorough understanding of each phase of software development life cycle(SDLC)
• Excellent verbal and written skills and ability to document based on target audience (Managerial, functional, technical users)
• Experience and ability to coordinate/Communicate with internal teams and customers of project
• Hands on experience on Power View and Tableau Software's for powerful and interactive platform for visual analysis and business intelligence
• Experienced in using various client tools such as SSRS, PerformancePoint, PowerPivot, Power View, PowerBI desktop and good understanding of dashboard design patterns and visuals

TECHNICAL SKILLS:

Languages: C#

Client &Server Side Scripting: ASP.NET 3.0/3.5/4.0, JavaScript, MDX, Confidential

Web Technologies: ASP.NET, HTML

Reporting Client tools: MS SQL Server Reporting Services(SSRS), PerformancePoint, PowerPivot, Power View, PowerBI

IDEs: SQL Server Management Studio (SSMS), SSDT, SQL Server Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008/2010 Team Edition and 2012, 2015 Professional Editions.

Versioning: Team Foundation Server ( Confidential ), SVN, Perforce

Windows/Server, UNIX, MS: DOS

Methodology: Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Power BI/SSAS Developer/ Technical architect

Responsibilities:

• Explain complex design items through documents and white-board sessions
• Work with Business, team of Technical Architects to create overall user interface, implement reporting solutions with complete considerations on Infrastructure capability, performance, supportability to achieve end user business results.
• Conducted brainstorming sessions with business to identify critical metrics that add immediate value to business.
• Develop POC models and lead BI technical team by creating technical specifications
• Implemented complex and dynamic Confidential calculations for SSAS 2016 Tabular model
• Responsible for managing SSAS instances that were present on Azure Virtual Machines
• Implemented Many to many and parent child hierarchies for complex Product Hierarchies of client
• Extensively used Confidential patterns and design patterns for configuring Currency calculations, snapshot measures, time series calculations
• Guide off-shore team on Confidential, PowerBI desktop, PowerBI service and Dimensional modeling.
• Created various measures with Confidential and rich PowerBI visuals for business and Configured security, Organizational Content Packs, Workspaces, data Gateways, refresh schedules for PowerBI service.
• Provide Support for existing BI platforms with SSAS multidimensional cubes

Environment: Confidential Editor, Teradata, Sql server 2016,2012, SSAS 2016, PowerPivot, Azure VMs (Microsoft’s platform as a service), SSDT 2015, Windows server 2014, PowerBI service, PowerBI desktop

Confidential, Pittsburgh, PA

PowerBI reporting Platform Developer/Architect

Responsibilities:

• Implemented complex Confidential calculations for SSAS 2014 Tabular model
• Assist Architectural teams to come up with performance enhancements Confidential calculations, Cube and processing options
• Single handedly migrated SSAS 2014 tabular cube to SSAS 2016 version
• Monitor overall health of SSAS instances and Servers
• Used Profiler to troubleshoot performance bottlenecks by analyzing Query plans and various other stats
• Maintain and support various SSRS reports using Confidential and MDX queries
• Administer and implement new requirements to SSAS 2014 Tabular Model that is Critical for Sales and Capital data for various Divisions and branches of Confidential across the globe
• Propose various Performance enhancement techniques to effectively source data for SSRS reports and power BI users.
• Wrote efficient MDX queries to retrieve data from Tabular cube by eliminating MDX SubCubes SSRS Query designer generates for improved performance and better user experience
• Administer Confidential for source control and configure various SSAS projects
• Analyze Confidential data source (out of box DataWarehouse and Cube that comes with Confidential installation) to generate various SSRS reports on resource planning for Project Managers
• Oversee, Code review and unit test off-shore team’s efforts
• Participate and coordinate in requirement gathering with Business users and business analysts

Environment: SSAS 2016, MS SQL Server 2014, 2012, SSDT, Confidential 2015, Windows server 2014

Confidential, Austin, TX

Lead Business Intelligence Consultant

Responsibilities:

• Maintain and support various SSRS reports using T-sql(Stored Procs) and MDX queries
• Administer and add features to 2012 Analysis services database that is single source of truth for entire Confidential organizational data
• Manage and develop SSIS packages from various sources that have data related to Product, Shipment, Warranty and sales related data to populate data warehouse.
• Propose effective solutions for business problems and do proof of concepts
• Wrote MDX queries to retrieve data from cubes and display in various client tools
• Create various report actions on existing Cubes using MDX
• Implement Confidential for source control and configure various Business Intelligence stack project types (SSIS, SSAS, SSAS Tabular, SSRS, ASP.NET applications)
• Lead Production Support of multiple Microsoft business intelligence solutions that were already in place
• Oversee, Code review and unit test junior Development teams code
• Design technical specifications to delegate work to off-shore developers
• Participate and coordinate in requirement gathering with Business users and business analysts

Environment: MS SQL Server 2014, 2012, 2008R2, BIDS, SSDT, PolyVista, Tidal, Team Foundation Server 2010

Confidential, Detroit, MI

Business Intelligence Consultant

Responsibilities:

• Actively participated in requirement gathering for Data warehousing project and define requirements for SSAS data sourcing purposes
• Implemented complex Confidential calculations for SSAS 2016 Tabular model
• Responsible for managing SSAS instances that were present on Azure Virtual Machines
• Monitor overall health of SSAS instances and Servers
• Implemented Many to many and parent child hierarchies
• Extensively used Confidential patterns and design patterns for configuring Currency calculations, snapshot measures, time series calculations
• Lead dimensional Modeling SSAS, PowerQuery, PowerBI for Organizational BI practice that is relatively new.
• Guide BI team on Confidential, PowerBI desktop, PowerBI service and Dimensional modeling.
• Created various measures with Confidential and rich PowerBI visuals for business and Configured security, Organizational Content Packs, data Gateways, refresh schedules for PowerBI service.
• Administer Confidential for source control and configure various SSAS projects
• Participate and coordinate in requirement gathering with Business users and business analysts
• Experience with STAR Schema structures, theories, principles, and best practices, Data Governance, Data Quality Management, Metadata Management, and Conceptual and Logical Data Design.
• Extensively worked on Data Modeling using SSIS that included data profiling, ensured data quality, source systems analysis, business rules validation, source to target mapping design, prepare sample data example and data validation with ETL (SCD 1, SCD 2 types tables and Fact tables)

Environment: Sql server 2016, SSAS 2016, Azure VMs (Microsoft’s platform as a service), SSDT, Confidential 2015, Windows server 2014, PowerBI service, PowerBI desktop

Confidential, Chicago, IL

Business Intelligence Consultant

Responsibilities:

• Create and maintain SSRS reports using T-sql (Stored Procs) and cube.
• Create various drilldown, drill through reports and manage subscriptions using SSRS.
• Create technical documentation for existing reports, Cubes.
• Propose effective solutions for business problems and do proof of concepts.
• Create tabular and multidimensional cubes for POCs.
• Wrote MDX, Confidential queries to retrieve data from cubes and display in various client tools.

Environment: MS SQL Server 2012, SSDT 2010, SharePoint 2010, Team Foundation Server, SVN

Confidential, Minneapolis, MN

Technical Lead

Responsibilities:

• Create numerous dashboards using SSRS reports
• Create various drilldown, drill through reports
• Used SSAS Cubes as data source and configure SharePoint deployment environment
• Create and review SSAS tabular cubes for consuming as a data source for reports, Dashboards, Pivot table
• Developed multiple dashboards using PerformancePoint using Tabular cubes as data source.
• Used MDX To create SSRS reports using tabular model (cube) as datasource and are deployed to Sharepoint
• Used MDX To Create PerformancePoint filters, KPIs, Dashboards
• Worked with SharePoint admin in troubleshooting and resolving SSRS Service application in SharePoint.
• Guide junior developers and handle version one tool to delegate work across 6 team members in an off-shore and on-Shore model
• Create technical design documents
• Work with Scrum master and project manager to prioritize development items to deliver meaningful sprints on time

Environment: MS SQL Server 2008R2/2012, SSDT 2012, PerformancePoint, SharePoint 2010, Team Foundation Server.

Confidential, Pittsburgh, PA

Off-Shore team lead

Responsibilities:

• Writing Complex T-SQL code to analyze issues reported.
• Writing Stored Procedures, Views and Functions as needed.
• Work on Development requests and also on Incidents pertaining to Data changes.
• Work on Designing data models as per the requirement.
• Do the code review of other requests, before they are deployed to other environments.
• Create SSRS reports and deployed to the SharePoint Portal.
• Create and deploy SSIS packages that migrate data from Teradata and flat files to SQL Server database using BIDS.
• Design schemas, SSAS cubes for OLAP needs
• Build ad-hoc MDX queries in SSMS, Excel to help business users understand models and for unit testing purposes.
• Developed multiple dashboards using PerformancePoint using Multidimensional cubes as data source.
• Worked with SharePoint admin in troubleshooting and resolving PerformancePoint Service application in SharePoint.
• Create various jobs to execute SSIS packages and database mail alerts.

Environment: .NET 4.5, MS SQL Server 2008R2/2012, Windows Server 2003, MS Visual Studio 2008/2010/2012 , SharePoint 2010,Team Foundation Server, APEX SqlServer stack toolkit, Toad for SqlServer.

Confidential, Pittsburgh, PA

MS SQL Server Database Developer

Responsibilities:

• Work closely with application developers in database design.
• Wrote SQL Queries, SQL Stored Procedures, Views, Functions and Cursors as needed.
• Used SSIS packages, DTS, and bulk inserts for importing and exporting of data.
• Performed daily backups and restoring of data whenever necessary.
• Create Scorecards, KPI’s, Analytical charts and dashboards using PerformancePoint Service and deployed to SharePoint Server.
• Created multiple dashboards for a wide range of audience using PerformancePoint following a hierarchy.
• Implemented change requests as required and performed unit testing and integrating testing.
• Performed unit testing and integration testing.
• Used MDX extensively to centralize business logic in cubes and retrieve data and feed to various client tools

Environment: ASP.NET, C#, HTML, JavaScript, MS SQL Server 2008, SharePoint 2010, MS Visual Studio.NET, MS Exchange Server 2003, Microsoft Visio, DTS, MS SQL Server 2008

Confidential, Pittsburgh, PA

MS SQL Server SSIS/SSRS/BI Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect used (Kimball’s approach)on the development of logical data models.
• Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Designed and implemented complex SSIS package to migrate data from multiple data sources (Teradata) for data analyzing, deploying and dynamic configuring of SSIS packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to CDW with SSIS
• Generated reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services 2005.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2005.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in MS SQL Server 2005 with the use of the Query Analyzer and Database Engine Tuning Wizard.
• Established backup and recovery of MS SQL server 2005 by using SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Used Visual Source Safe (VSS) for version control.

Environment: MS SQL server 2005, SSIS, DTS, SSRS, Profiler and Windows Server 2003