TECHNICAL SKILLS

• Microsoft BI stack
• COSMOS
• Power BI
• Power Pivot
• XMLA
• T - SQL/PLSQL
• MDX and Analyzer.

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Sr. Database Analyst

Responsibilities:

• Worked as part of SMSGR (Sales & Marketing Services Group Readiness) team in providing training statistics and trends for large audience such as Cloud and Enterprise (C & E), Windows, Application Services Management/Office CRM/Dynamics and Readiness teams spanning across 50+ Power BI reports/portal hosting and generation.
• Worked extensively with Power BI in providing rich visualizations with training set metric collection and reporting ranging from Pitch Perfect, Tech Ready, S4, and Technical Certification to FRI (Field readiness Index).
• Working knowledge of Microsoft Big Data architecture implementation using COSMOS, Work flow management using CAS Job Scheduler, Catalog offering from Geneva Analytics Self-Serve.
• As a Business and Reporting Analyst, have been responsible for end to end communication with Business Owners of Cloud and Enterprise (C & E), Windows, Application Services Management/Office, CRM and Readiness Dashboard team at global level catering to North America, APAC, South America, and Europe for Requirement gathering, Requirement analysis, Active feedback collection and recursive improvement, Dataset Infrastructure development and maintenance (SSAS cube design, Azure/on-prem SQL objects to support Power BI), Live Site troubleshooting & TSG generation, Logging and Documentation.
• Mentored and managed offshore team’s efforts in meeting Power BI report generation goals for Readiness dashboard by delegation and nightly one on one status meetings.

Environment: MS SQL 2012 Tabular/multi-dimensional, T-SQL, MDX and Power BI.

Confidential, Greensboro, NC

BI - SSAS/SSIS/SSRS Developer

Responsibilities:

• ETL development and maintenance using TSQL/SSIS architecture (100+ stored procedures, 50+ views, etc.) for MedEcon Data Warehouse Environments for CTA(Care Team Advance) which supports Confidential /Accordant clients with Membership and Claims for over 18 Confidential /Accordant disease coverage.
• Design, development and implementation of SPECIALITY cube which handles Specialty medicines and coverage that Confidential /Accordant offers, metrics include Billings, Allowed Amounts, Payables, etc with 12 dimensions and 6 facts.
• Designed and maintained over 20+ SSRS canned reports that track Pharmacists and Drug usage using MDX (multi dimensional expressions).
• Responsible for new client implementation process to facilitate Medical Membership and Claim file import process using TSQL/SSIS.
• Implemented performance tuning on DW and cube environments using partitions (table level and cube level) and index management.
• Implemented incremental changes using Agile methodology with one week sprints for SPECIALITY and MED-ECON cubes, serving ad-hoc reporting using Excel/Power Pivot and 50+ canned reports using SSRS.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using SQL Server Reporting Services (SSRS).
• Preparing Dashboards using calculations, parameters in SQL Server Reporting Services (SSRS) using MDX and cube-access.

Environment: MS SQL SSIS/SSAS/SSRS 2008, T-SQL, SQL, MDX, XMLA

Confidential, Trinity, NC

BI - SSAS/SSIS/SSRS Developer

Responsibilities:

• Worked on Time Extender ETL flip for Sealy GDW (Global Data warehouse serving Sealy North America region with 15 dimensions and 8 measure groups) to TSQL/SSIS architecture (over 150 objects such as stored procedures, views, etc.) with stored procedure implementation, logging and audit.
• Implemented performance tuning on DW and cube environments using partitions (table level and cube level) and index management.
• Implemented incremental changes using Agile methodology with one week sprints for Sales and Invoice cubes, serving ad-hoc reporting using Excel/Power Pivot and 50+ canned reports using HALO PRIZM.
• Introduced practically proven and viable cube performance tactics such as default measure group creation and implementation using SQL Server Analysis Services (SSAS).
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau and SQL Server Reporting Services (SSRS).
• Preparing Dashboards using calculations, parameters in Tableau and SQL Server Reporting Services (SSRS).
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports using Halo PRIZM for the Key Performance Indicators for the top management.

Environment: MS SQL SSIS/SSAS/SSRS, T-SQL, SQL, HALO BI/PRIZM, MDX, XMLA

Confidential, Berkeley Heights, NJ

BI - SSAS/SSIS/SSRS / Tableau Developer

Responsibilities:

• Migrated 15 pre-defined excel reports to SSRS canned reporting solution using MDX. Fine-tuned slow running SSRS reports using Non Empty/Replacing Filter function.
• Experience in designing leaf level calculations for SSAS multi-dimensional cubes such as Logility.
• Experience in writing client-side as well as Server-side Multi-dimensional Expressions (MDX) for incorporating data querying capability for Inventory and Forecast cubes.
• Implemented Push/Pull orders forecast for Sales Forecast process for CPD, LPD and PPD IF using TSQL and SSIS (SQL Server Integration Services).
• Working in an Agile Software design paradigm consisting three Inventory and Forecast multi-dimensional cubes for Consumer, Luxury and Professional Product divisions, helping in serving ETL goals.
• Fine tuning and speeding up daily TIDAL jobs involving SP/view related incremental process using TSQL and SSIS (SQL Server Integration Services).
• Supporting Logility offline application and PROD support for Logility ETL tree containing 12 SSIS packages and TSQL.
• Extensively designed and implemented custom SSIS components for embedding Logility business logic.
• PROD support for existing SSIS objects and Store procedures; grabbed performance metrics and improvised existing batch performance by achieving parallelism and dependency preservation.
• Implemented DW process for new master data imports such as Partner brand hierarchy changes, Synergy distribution channel import using TSQL.

Environment: MS SQL SSIS/SSAS/SSRS, T-SQL, SQL and C#.

Confidential, Parsippany, NJ

SQL Server BI Developer

Responsibilities:

• Development and Maintenance of existing ETL layer - Transactional Acquisition load, Transactional DW load and Master Acquisition load using SQL Server Integration Services (SSIS).
• A thorough understanding of SQL Server Analysis Services BI stack with experience ranging from XMLA driven deployment aspects to client/server - side MDX (Multi-Dimensional Expressions). Expert in designing and maintaining scalable Enterprise cube architecture involving high volume data (POS).
• Implemented query Performance Tuning of operational ALLOY 2.3 applications using index management, trigger introduction and logging using creation of audit tables.
• Provision of ADHOC queries to End users in the development of existing Enterprise reporting solution using SQL Server Reporting Services (SSRS).
• Data validation and cleansing in DW which feeds the enterprise Micro-strategy reports.
• Production Support for ALLOY application for operational SSRS (SQL Server Reporting Services) reporting platform which involved Business, Non-Business, IT and staffing user groups for over 30 enterprise reporting solutions.
• Designed, developed and implemented several reporting needs for Internal SOW (Statement of Work), External SOW (Statement of Work), Tactic List and Executive Financial Summary.
• Development and design of ALLOY SSAS cube solution using 13 dimensions and 22 measure groups using SQL Server Analysis Services (SSAS).

Environment: MS SQL SSIS/SSAS/SSRS, T-SQL, SQL, PL/SQL, MDX, Oracle, C#

Confidential, Mt.Laurel, NJ

SQL Server BI Developer

Responsibilities:

• Development of Retail Management Call Center reporting solution using SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Retail Management Call Center cube design and development with 10 Facts and 28 Dimensions using Agile Software Development.
• Implemented efficient SSAS designs by incorporating leaf level calculations at the database level to gain performance compared to calculations design.
• Implemented Incremental Deployment Strategy for SSAS objects using SSAS Deployment Wizard and capturing Calculations using SQL Profiler for use in Calculations-only Deployments. Utilization of ASCMD command in XMLA execution for TIDAL jobs.
• Implementation of a total of 36 Crystal Reports migration with Oracle 10 back-end to SSRS in multiple phases using SDLC in a rapid implementation phase that contained 30 development days and 15 QA days.
• Implemented Delta processing for SSAS multi-dimensional cubes by implementing Current partition creation for every measure group and implementing XMLA-driven processing jobs.
• Performance tuning of SSAS Server by intelligently switching between Partition design and Aggregation design to achieve maximum network efficiency. Involved in creating advanced Aggregation designs using BIDS helper application.
• Implementation of SQL-driven (Oracle 10) SSRS dataset code migration to Multi-Dimensional Expressions (MDX) using SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).

Environment: MS SQL SSIS/SSAS/SSRS, T-SQL, SQL, PL/SQL, MDX, Oracle, C#

Confidential

SQL Developer

Responsibilities:

• Designed, developed and implemented back end OLTP support for Dell’s proprietary ticket/support management system.
• Designed and supported a scalable ETL process for the DIT database using TSQL, SQL Server Integration Services (SSIS); and responsible for backup/recovery for DIT db.
• Fine-tuned existing legacy stored procedures and implemented improvised ETL trees and scheduling for faster change data capture (CDC) mechanisms.
• Worked on Enterprise reporting platform to measure call center statistics.