SUMMARY

• 7 Years of Professional experience in Data warehouse concepts and their practical implementation.
• Real time knowledge on entire Microsoft data management technology stack (SQL Server 2012/2008/R2/2005, SSIS, SSAS, SSRS and Power BI).
• Designed and built very large complex data warehouses (size up to 2TB) and maintained optimized query performance by implementing Table Partitioning, query tuning using query plans & DMV’s, Profiler etc.
• Expert in DW designing for OLAP systems by conceptualizing data models at Star & Snow flake schema.
• Developed complex SSIS packages involving Design patterns, Parent/child packages, Error handling using Event Handlers, Custom Logging for SSIS Packages, configurations etc.
• Migrated several manual excel dashboards to SSRS using Drill - Through & Drill-Down reports. Also implemented Report Subscriptions for auto publish of reports.
• Developed and implemented a tool which is “Version Control of Documents by Automatic Rendering of SSRS Reports”, using C#. This tool interacts with SSRS Web service to automatically render reports to PDFs.
• Extensive experience of creating Scorecard/Benchmark/Dashboard and interactive Power View/Power Pivot report using Power BI/SSRS/Excel 2013/2010.
• Strong technical knowledge in SSAS (Sq1server Analysis Service) and created complex data models using both Multidimensional and Tabular approaches.
• Developed complex DAX calculations in tabular model and incorporated them as KPIs to provide more functionality to the end user.
• Developed a utility (MDX Generator) which can Auto Generate complex MDX queries in the background based on user filter selections.
• Developed a solution to implement SCD on fact tables by MDX and SSAS without loading daily snapshot data in to fact tables.
• Extensive work experience in Microsoft’s Big Data i.e. COSMOS and created complex SCOPE scripts to get the data from both structured and unstructured streams in COSMOS.
• Extensive experience in planning and implementing Disaster Recovery solutions, data archiving, backup/recovery strategies. Expertise in mentoring and setting up High availability environments like Database Mirroring, Replication (Snapshot, merge, transactional), Log shipping.

TECHNICAL SKILLS

Languages: C#.NET, SQL, MDX, DAX, PHP, SCOPE and PowerShell.

Modeling Tool: ERWIN, Kimball Modeling

Databases: SQL Server 2012, SQL Server 2008SQL Server 2005, Oracle.

BI Tools: SSAS, SSIS, SSRS, Power BI Suite.

Certification: OCA(Oracle Certified Associate)

PROFESSIONAL EXPERIENCE

SQL Server BI Developer

Confidential

Responsibilities:

• Awarded with “Best Performer for the quarter” from CEO of Wipro.
• Won the Feather in Cap Award for meeting the deliverables before time withUtmost quality and for the initiatives taken.
• Received client appreciation for developing EPG Analytics Scorecard, an innovative solution that allows the users to slice and dice more efficiently than excel based platform.Other Activities
• Started developing an analytical game app for Windows and Windows Phone stores to understand the game designing and implementation on .Net platform.

Confidential

SQL Server BI Lead

Environment: COSMOS, MS SQL Server 2012 Database, SSIS, Tabular, Power BI

Responsibilities:

• Abstract: Microsoft's App Certification process involves tedious manual review process which is costly and also time consuming. Working on these lines, Microsoft's engineering team has devised a system with pre-defined algorithms, which is capable of analyzing apps and determiningwhich really needs to be manually reviewed and the ones which can be directly sent to the Store or back to the developer for rectification. This Automated system needs proper data solution, which helps the engineering team and related stake holders to analyze the effectiveness of the system and also based on the data to continuously improve the system so that lesser bad apps are let through to the store, thus ensuring a fraud free Windows Store.
• Designed and implemented the data warehouse ETL in cosmos through complex scope scripts to retrieve data from multiple cosmos streams.
• Developed complex Power shell scripts for the ETL pipeline.
• Developed data warehouse to handle large data pulls daily by doing parallel load in SSIS and also by SQL Server partition switching.
• Developed tabular model to have quick response time for the user queries. Created calculated measures, KPIs, attribute hierarchies and perspectives to give user more flexibility in tabular usage.
• Created complex custom DAX calculations for multiple tabular KPIs and also implemented M2M relationships.
• Implemented performance tuning of Tabular models for faster query execution by improving DAX calculations and M2M relationships.
• Developed Power BI reports to provide advanced slice & dice functionality to user. Developed Complex Power shell scripts to handle the data orchestration in daily E2E pipeline (Cosmos Scripts submission, Checking the availability of cosmos streams, Custom Error handling to make the script resilient of environmental issues... etc.)

Confidential

SQL Server BI Developer/Lead

Environment: COSMOS, MS SQL Server 2012 Database, SSIS, SSAS and SSRS, ASP.NET

Responsibilities:

• Abstract: The project deals with data analytics and data mining around application marketplace for the data produced through App development and certification, usage pattern, app purchases, popularity, review and ratings. This Project scope also involves the design and storage of data, preparing reports and KPIs from the databases in order to facilitate the management to take business related decisions.
• Creation of functional specification upon client requirements for release work items.
• Worked on IQuery/Cosmos scripting for data loading from Cosmos to SQL data warehouse.
• Developed complex tailor made MDX queries to pull the data from cube
• Designed and developed SSIS packages and optimize the load time from cube to data warehouse upon its implementation.
• Design and Development of SSAS cubes and SSRS reports for data analysis and reporting.
• Implemented Kimball principles in our design of data warehouse.
• SQL Server databases high availability AlwaysOn implementation.
• Prepared Scorecards, Benchmark & Dashboard reports for Windows App Store team.

Confidential

SQL Server BI Developer

Environment: SQL Server 2008, SSAS and C# with Visual Studio 2010

Responsibilities:

• Abstract: This project deals with developing data mining and analytics system for windows phone based on the data produced through the life cycle of phone right from the point it leaves the manufacturing to the point where the customer uses the phone to make calls, purchase applications and uses other services. This projects primary goal is on analytics around marketplace for the data produced through app development and Certification, usage patterns, rating etc.
• Designed the Cube Architecture (introducing new dimensions, measure groups, databases, partitions etc.) based on Business requirement.
• Designed and implemented ETL using SSIS and Cube using SSAS for Data Warehouse (Creating KPIs, Calculated Members, Dimensions, Dimension Relationships, Creating Partitions, Building MDX queries to test the data)
• Created a solution to implement cube over SCD fact tables by giving the ability to view the day wise data at the granular level. This solution saves a lot of disk space and in turn provides the data at much faster speed.
• Developed Complex stored procedures including slowly changing dimension implementation.
• Strong knowledge in performance tuning of both SQL and cube.
• Developed unit test cases in C# to validate the process flow and also the accuracy of Data mart & Cube
• Involved in Project Design Documentation

Confidential

SQL Server BI Developer

Environment: SQL Server 2008, SSAS, SSIS, SSRS, Silverlight with Telerik controls, Visual Studio 2010 and Sharepoint 2010

Responsibilities:

• Abstract: The Enterprise and Partner Group (EPG) ensures that Enterprise Customers and their Partners realize the most business value from their relationships with Microsoft. Together with Communications Sector, Public Sector, and Services, EPG professionals serve Microsoft's approximately 17,000 enterprise customers worldwide. The EPG team is comprised of a central team (WW EPG), whose purpose is to lead the EPG field and guide the business groups, and field-based professionals who deliver World Class Sales and Services to Microsoft Enterprise Customers and Partners worldwide. Enterprise Partner Group is intended to provide the key operational metrics and financial metrics to its partners. The scope of the project includes support and maintenance of the existing reports for EPG, providing development and testing support for the new reports, create new reporting solutions for the data warehouse as required by the client.
• Designed and implemented ETL and Cube for Data Warehouse (Creating KPIs, Calculated Members, Dimensions, Dimension Relationships, Creating Partitions, Building MDX queries to test the data)
• Created a tool to Generate Dynamic MDX queries upon user’s selection (i.e. what measures, row labels, report filters he selected) in the pivot table field list. This stored procedure is used for MIS reporting (EPG Analytics Scorecard) built on Silverlight integrated with SharePoint. The scorecard helps in faster generation of MIS reports even with increased sets of analytical data
• Developed “Pivot Table Field List” similar to excel pivot table by getting the list of dimensions, measures and KPIS from Cube by querying Cube DMVS and designed the frontend by using Expression Blend, Silverlight and WCF.
• Created Analytical Reports in Excel which are the key for business improvement by giving the ability to slice and dice the data for the field based professionals and other vendors.
• Strong knowledge in performance tuning of both SQL and cube.
• Design and implementing Scorecards and Dashboards.