SUMMARY

• Over 16 years of experience in client/server and web technology, including around 15 years of experience in OLAP/OLTP/DSS (Data Warehousing) presents distinctive competency in Business Objects/Web intelligence Universes, Reports and Security.
• 3+ years of experience as Microsoft BI developer and data analyst with Microsoft SQL Server 2016/2014//2008 , SSIS/SSRS/SSAS, OLTP, OLAP (Different environment such as Production, UAT, and development) and Power BI, DAX Studio and VertiPAQ analyzer in various domains.
• Highly experienced in using DAX (Data Analysis Expressions) functions and creating required Calculated columns/ measures/tables in creating Power BI dashboards and reports.
• Dynamic Row level security both Static and Dynamic has been implemented both on Power BI Service (Cloud) and Power BI Report Server (On Premise)
• Experienced in creating Data Flows and good understanding on performance techniques like Data Folding and Query Reduction.
• Worked and mentored the team with various Power BI Models, DAX Functions and M Code language functions on Power BI and Power Query.
• Designed various Dashboards to match with the client BI needs with available and custom visuals on Power BI
• Created different environments for DEV / QA / PROD within Power BI on cloud with the workspace techniques.
• Experienced with Deployment pipelines to maintain Datasets and Reports with various environments like Dev /QA/ Prod with Power BI Premium capacity.
• Composite Models have been created and implemented with Aggregations and Dual Storage modes in Power BI for the best performance for very large - scale datasets.
• Strong experience in error handling, debugging, testing and error logging for SSIS.
• Designed and developed SSIS packages to extract data from the transactional and/or operational databases, transformed the data per analytical / reporting business needs, and loaded the data into a data warehouse or data mart.
• Highly experienced on Data preparation on Power Query, Data modelling and various performance techniques within Power BI.
• Experienced in giving basic training on Power BI modules with its features and functionalities and mentoring the team on Power BI.
• Developed multiple dashboards, analytical reports, KPIs, and interactive reports based on business requirements using Power BI
• Sound knowledge of Data Marts, Operational Data Store (ODS), OLAP, dimensional Data Modeling with Ralph Kimball Methodology (Star Schema Modeling, Snow-Flake Modeling with FACT and Dimensions Tables) using Analysis Services (SSIS).
• Expert in creating several types of complex reports using SSRS (SQL server reporting services) such as Drill-Down, Parameterized, Cascading, Conditional, Ad-hoc, Sub-Reports, and Charts.
• Developed complex SQL queries, common table expressions (CTEs), Views to support Power BI
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering and deploying reports to Power BI Service.
• Experienced in working with different get data modes like import, Direct query and live access and its limitations.
• Willing to work hard to meet intensive schedules and having excellent communication, presentation and interpersonal.

TECHNICAL SKILLS

Operating Systems: UNIX (Solaris 2. x), IBM AIX 5.2, and Windows95/98/NT/7/10

Languages: T SQL, DAX, M CODE, SQL*Plus, PL/SQL, XML, JAVA script, ABAP/4, HTML DHTML VB Script and Visual Basic 5.0 & 6.0

RDBMS: SQL Server 2016/2014/2012/2008/ R2/2005, Oracle7.x 8.x, Tera data, Sybase and DB2 UDB 10.5/8.x, MS Access.

Software Packages: MS - Excel, PowerPoint, Word, TOAD and Tally, PVCS.

ERP Packages: SAP ECC 6.0, SAP R/3 (FI/CO) 3.G, SAP - BW/BI 7.3/7.0/3.5

ETL: SSIS, Business Objects Data Services 3.X, Business Objects Data Integrator 3.X/6.5 Data stage vers 5.x, 6.x, and 7.x - Designer, Director, Manager, Administrator, and Informatica Power Mart/Power Center 10.5

OLAP/ DSS Applications: Power BI Desktop Monthly updates all versions, Power BI Report Server, Power BI Service, DAX Studio, Vertipaq Analyzer, SQL Server Profiler. SSAS, SSRS, Report Builder 2.0/3.0, Business Objects vers 4.3/4.2/4.1.4/4.0 & 5.1.2, 6.5, Xi Rel1 & Rel2 /R3.0 - Designer, Supervisor, Business objects user module, Broadcast Agent, Central Management Console, Set Analyzer, BO Auditor, Import wizard, Xcelsius 2008, WEBI Rich client, Info view, ZABO, Performance Manager, Crystal 2013, crystal 2011 and crystal for Enterprise, SAP BI.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Power BI Developer / Lead

Responsibilities:

• Started this project from scratch in understanding Dashboards requirements, gathering info, creating TDD based on FDD, studying existing databases to make sure all required data is available to start creating Data Model within Power BI.
• Solid Command on Data preparation with required transformations and creating required Date tables to take the Time intelligence on Power BI Dashboards.
• Implemented with all best features and options while creating Reports and Dashboards with different up-to-date visuals.
• Solid experience on both Cloud and on premise server to deploy Power BI Dashboards and maintain normal and Row level Security.
• Created Golden Datasets on Power BI Service to avoid “Data Set Silos” and created different environments for Dev / QA/Prod environments with the help of Workspaces.
• Highly experienced on Performance tuning with various techniques like Aggregate Awareness, configuring and managing Aggregations within Power BI.
• Implemented composite model for the best performance for the very large-scale datasets size having in terabytes.
• Worked closely with Power BI Admin to incorporate Deployment pipelines for various environments for dev / QA / Prod on Power BI Premium capacity.
• Optimum and Best possible solutions given while creating of Calculated Columns / Measures/Tables with appropriate techniques having best performance.
• Dynamic Row level security (RLS), both Static and Dynamic with hierarchies were implemented successfully on Power BI Service (Cloud)
• Created gateways for the databases on Premise to refresh and schedule the reports /Dashboards and datasets.
• Created custom calculated columns and parameters on Power Query with M code.
• Worked with data models with complex relationships in Power BI and connected different data sources to Power BI desktop.
• Commendable experience in modelling, creating the relationships and selecting appropriate data storage modes.
• Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.
• Data Flows have been created with self-service Data preparation to help other BI Reports as a single source and ready to use the dataset.
• Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).
• Data Folding and Query reduction techniques and Data Silos have been taken care while implementing Steps with transformations on power Query.
• Generated Drill down, drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize report using SSRS.
• Both Query Parameters and Report parameters including what if Analysis parameters have been created.
• Highly experienced in creating Analytical Reports, Paginated reports and Dashboards on Power BI and SSRS and Report Builder.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.
• Basic training to Power Users and Business Analysts has been given on Power BI and mentoring the team on Power BI Features and Functionalities.

Confidential

Power BI Lead / Architect

Responsibilities:

• Created required Data Models to accomplish Various Report requirements for the client and created Dashboards after publishing in to power BI Service.
• Excellent Command on using DAX (Data Analytic Expression Language) and M Code Language.
• Worked with most of the features available in Power BI Desktop in creating Reports and updated knowledge with all features
• Created different types of visualizations viz., geographical visualizations after slicing and dicing the account operations related data to analyze financial data across different locations of the bank.
• Experienced in working with DAX commands to pull up more calculated data out of the tables.
• Command in creation of Calculated Columns / Measures/Tables with appropriate techniques having best performance.
• Dynamic Row level security (RLS) was implemented successfully on Power BI Service(Cloud)
• Worked with gateways to schedule the report and data using different gateways
• Developed custom calculated measures using DAX in Power BI to satisfy business needs
• Worked with data models with complex relationships in Power BI and connected different data sources to Power BI desktop.
• Published many reports and visualizations created to the Power BI service and thereby develop dashboards.
• Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.
• Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
• Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).
• Created complex Custom Views using SQL Developer to create data sets for Power BI dashboards
• Generated Drill down, drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize report using SSRS.
• Review reporting outputs for transparency, consistency, and accuracy.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status

Confidential, Pennsylvania

Sr. Power BI Developer / SSRS/SSAS Developer

Responsibilities:

• Working extensively in Power BI report creating tabular cube, creating data model for Power BI Report, Validating data quality of the report.
• Created different types of visualizations viz., geographical visualizations after slicing and dicing the account operations related data to analyze financial data across different locations of the bank.
• Experienced in working with DAX commands to pull up more calculated data out of the tables.
• Developed custom calculated measures using DAX in Power BI to satisfy business needs
• Worked with data models with complex relationships in Power BI and connected different data sources to Power BI desktop.
• Published many reports and visualizations created to the Power BI service and thereby develop dashboards.
• Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.
• Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
• Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).
• Created complex Custom Views using SQL Developer to create data sets for Power BI dashboards
• Generated Drill down, Drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize report using SSRS.
• Review reporting outputs for transparency, consistency, and accuracy.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status
• Created Universes and Complex Reports with BO IDT and WEBI and created several Crystal
• Universes have been created on IDT with single and Multi source Data Sources.
• Right from gathering Reporting Requirements, preparing TDD and WEBI Reports and Unit testing completed and moved them from Dev environment to PROD.
• BO and Crystal reports created to meet as is approach with various Reporting techniques.
• Designed and developed SSIS Packages (.dtxs files) to import and export data from MS Excel, SQL Server, Oracle and Flat files.
• SSIS packages to update tables with monthly data and automated it through scheduled jobs for the beginning of every month.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Expertise in validating the data between source and target systems.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.
• Created Package Configurations to deploy packages from development to production server.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Experienced in participating meetings with business users to gather the requirements.
• Involved in the analysis of existing database structures and creating the new tables and views as per the requirements.
• Worked with development teams in the design of physical databases and in modification.
• Closely worked with professional data modelers and with business stakeholders, as well as potential users of the information system.

Environment: MS SQL Server 2014/2012, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI, T-SQL, ORACLE, Microsoft Office 2010, OLAP, SAP BO 4.X, CRYSTAL REPORTS 2016, UDB DB2.