SUMMARY:

• Having 9+ Years of Experience in Data Warehousing Business Intelligence solutions (SQL Server, SSIS, SSAS, Power BI & SAP Business Objects). Involved in analysis & development of Business Applications, using integrated queries and reporting for managerial decision support systems.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow - Flake Schema Modeling, FACT and Dimensions Tables using Analysis Services.
• Excellent command on MS SQL Server 2005/2008/2012/2016 in constructing triggers, tables, Joins, stored procedures, views, indexes, User Defined Functions to facilitate efficient data manipulation and consistent data storage.
• Proven Power BI development experience with desktop, Server and SaaS versions. Familiarity with Direct Query functionality within Power BI.
• Provide analytical, complex and specialized client service analysis using Power BI dashboards.
• Experienced in developing and supporting Microsoft BI and reporting capabilities (PowerPivot, Power BI, Power View, SQL Server Reporting Services).
• Experienced in building complex ETL packages using varied and complex data sources and merging them into a single data model.
• Skilled in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS, Import, Export Data, Bulk Insert and BCP utilities.
• Expertise in writing SSIS packages with Configuration, Custom Logging, Deployment, SQL Mail, Check Point, Custom Control Flow, Auditing, Variables, Expressions, Procedure Error Handling and Data Error Handling, in SSIS.
• Experience in designing Database Models using MS Visio and ERWIN for both Relational and dimensional modeling.
• Good in gathering Business Requirements from business stakeholders, analyzing, documenting System Requirement specification, Functional Requirement specifications.
• Ability to work in challenging and versatile environments and strive for excellence.
• Flexible and versatile to adapt to any new environment and work on any Business Intelligence technologies.

TECHNICAL SKILLS:

BI Tools: Power BI, SSRS & SAP Business Objects

ETL Tools: SSIS

Data Warehousing: SSAS, Data Modelling, Data Mining

RDBMS: SQL Server & Oracle

PROFESSIONAL EXPERIENCE:

Power BI/MS BI Consulatant

Confidential

Highlights & Responsibilities:

• Worked on preparing performance Dashboard, Job Failure stats, Data Volume check using SSRS, SSIS, and SQL
• Developed multiple kind of Power BI Reports and Dashboards.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service & Report Server.
• Explore & Analyze data in a variety of ways and across multiple visualizations using Power BI.
• Understanding the business requirement and functional specification of the client module with Business Executives & Analysts.
• Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2014 and developed ETL packages to extract and transform data from data sources like MS Access
• Involved in Data Scrubbing and Data Cleansing using MDS, DQS
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for DBMS
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Designed, developed, debugged Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Created Dashboard Reports using Power BI and SAP Dashboards
• Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports
• Created various visualizations such as Stacked Charts, Pie Charts, Donut Chart cards as per business requirements. Worked on RLS to constrain the user access to the row level data
• Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS)
• Migrated an existing SQL Server Database to use Azure Database
• Published Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server using Direct Query
• Managed relationship between Power BI using Schemas such as Star & Snowflake
• Created calculated columns and measure in Power BI and Excel depending on the requirement using DAX expressions
• Good knowledge in Data Cleansing using Power Query in Power BI Desktop Editor
• Provided ongoing support and configuration for JIRA projects, workflow, screens, fields, permissions and other administrative tasks

Environment: Power BI, MS SQL Server 2014, SQL Server Integration Services 2014 (SSIS), SQL Server Analysis Services 2014 (SSAS), SQL Server Reporting Services (SSRS), MDX, DAX, T-SQL, Microsoft Visual Studio 2014, JIRA, MDS, DQS Power BI Desktop, Power Query, TFS, Azure, MS Access, ETL, Excel.

MSBI Consultant

Confidential

Highlights & Responsibilities:

• Involved in analysis, design and development of project to consume transactional data, consolidate into data warehouse and creating reports and dashboards, writing complex Stored Procedures for creating datasets for Reports and dashboards.
• Gathered business requirements, defined and designed the data sources, data flows, data quality analysis, worked in conjunction with the data warehouse architect on the development of logical data models.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS
• Also, worked on Excel Power Pivot for providing ad-hoc reporting for the clients.
• Implemented error handling and roll back process in ETL load.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Developed modules to extract, process & transfer the customer data using Teradata utilities.
• Created region level security in reports to prevent users of one region from seeing data of a different region and implemented subscriptions for Reports using SSRS.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Created reports in SSRS using several types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Designed SSAS cube to hold summary data for dashboards and OLAP Analysis.
• Created User Defined Hierarchies depending on the business requirement using SSAS.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Created different measure groups and calculations using SSAS.
• Created usage-based aggregations in cube to minimize time for query retrieval from client tool
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI Created Databases, Tables, Views, Indexes and Created and maintained Roles and Database users.
• Scheduling Jobs and Alerting using SQL Server Agent in Power BI
• Created datasets for reports using T-SQL and stored procedures
• Performed DBA tasks like Backup, Restoration of tables and Stored Procedures and Refreshing Databases on weekly basis.
• Created reports by connecting to IMCE from SAP Lumira, SAP Business Objects Explorer BEx and MS Excel through ODBO/MDX for multi-dimensional reporting. Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: SQL Server 2005, 2008R2, 2012, IIS 7.5 Windows Server, 2003R2, 2008R2, ETL, My SQL, SAP Business Objects, Remedy, JIRA, VM Server, SharePoint

SAP BO Developer

Confidential

Highlights & Responsibilities:

• Hands on using variety of SAP Business Objects tools like Designer, Web Intelligence, Lumira and Information Design Tool.
• Experience in developing Universe from scratch.
• Having Experience in Testing Universe & Reports
• Well qualified in creating Ad-Hoc reports using Business Objects Web Intelligence.
• Good Exposure in Central Management Console.
• Having Knowledge on Installation & Configuration of Business Objects XIR2/3.1/4.1
• Created new objects for the required metrics.
• Solved Join path problems by Aliases & Contexts.
• Tested the Universe & Reports for all combination of Test Cases.
• Developed Reports using various functionalities in Desktop Intelligence like slice and dice, Drill capabilities, Master Detail, and Cross Tab tables, Breaks and Variables and Scope of analysis.
• Involved in Development of Ad-Hoc and Canned reports as per the Business and the client requirement.
• Involved in Testing of the reports and developed Unit Test Process and the Unit Test Result for the reports developed before moved in to the Production Area.
• Understanding the Business Requirement Documents and the Specifications by Client.
• Involved in various discussions with end user to get more insight on the Business requirements.

Environment: SQL Server, SAP Business Objects, SSIS, SSAS