Power Bi Business Intelligence

Laxman Javaji

Sr. Power BI Developer – Data visualization Power BI Snowflake SQL SSRS ETL OBIEE Azure

Contact: +1-945-***-**** ******.******@*****.***

Professional Summary

●14+ years of professional expertise in Business Intelligence, Reporting, and Data Analysis services.

●Proficient in Power BI, SAP Business Objects BI, OBIEE, Tableau, SQL, PL/SQL, Oracle Forms, and Reports.

●Experience in developing Dashboard, Ad-hoc and Parameterized Reports, create complex reports (ex: drill down reports using different objects) using SSRS.

●Experienced in Reporting tools SSRS, Crystal Reports, Business Object and Visualization tools Power BI and tableau.

●Good Experience in creating reports & dashboards with different types of tables, charts & graphs via Power BI Desktop

●Experience in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS, SSAS and Power BI.

●Overseas security and compliance within the Snowflake environment. This role includes tasks such as granting and revoking privileges, implementing multi-factor authentication, and ensuring data privacy.

●Builds and maintains data pipelines, ETL processes, and integrates various data sources into Snowflake. This role is responsible for ensuring data quality, performance optimization, and troubleshooting issues.

●Experience in developing BI applications using Power BI as reporting tool.

●Experience in Power BI Report and Dashboard development.

●Expert in involving variety of features using complex expressions to Calculate, Group, Filter data in the report using SQL SSRS.

●Extensive experience in creating database objects such as Tables, Constraints, Indexes, Views, Stored Procedures, UDFs and Triggers using Microsoft SQL Server Management Studio.

●Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

●Hands-on experience in creating cubes, perspectives and deploying using SQL Server Analytical Services (SSAS).

●Expertise in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and in SQL Server Analysis Services (SSAS) in Business Intelligence (BI).

●Good experience in creating OLAP cubes using SQL Server analysis services (SSAS).

●Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services.

●Experience in using ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.

●Proficient in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS packages.

●Proficient in performing various SSIS data transformation task such as Look-ups, Fuzzy Look-ups, Aggregate Functions, Merge Join, Conditional Split, Data Conversion, Derived Column, Event Handlers, and Error Handlers etc.

●Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, and Excellent knowledge in RDBMS concepts and Data Warehouse Concepts.

●Good understanding of Normalization, De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.

●Design and develop high-quality, detailed, and accurate Pixel Perfect Reports using BI Publisher to meet specific business requirements.

●Analyze and integrate data from various sources to support the development of Pixel Perfect Reports, ensuring data accuracy and consistency.

●Experience working in Agile and Waterfall model working methodologies.

●Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.

Educational Background

Bachelors in Commerce and Accounts- 2008 From Osmania University - Hyderabad, India

Technical Skills

Databases

MS SQL Server, Oracle, PL/SQL, MS Access

Programming Languages

T-SQL, XML, Java, Python

Tools/Utilities

Enterprise Manager, SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio, SQL * Plus, Ervin, Power BI, Tableau

Database Design Tools &

Data Modeling

MS Visio, MS Access, MS SQL Server, Star Schema/Snowflake Schema modeling. Physical & logical data modeling, Kimball & Agile Scrum Methodologies.

Business Intelligence Tools

Business Intelligence Development Studio (BIDS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), DTS Packages, Performance Point Server, Visual Studio.

Operating Systems

Windows Variants

Project History

Project #1 : Ramada by Wyndham (Hotels) Aug 2023 – Till Date

Role : Sr. Power BI Developer

Responsibilities:

•Worked with Business Systems Analysts to fine tune specifications by ensuring that all database constraints are satisfied and perform impact analysis of changes

•Creates reports using Power BI for SharePoint list items

•Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs along with slicers and dicers enabling end-user to make filters.

•Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

•Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

•Created Power BI dashboard and generated reports.

•Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.

•Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.

•Created reports on Power BI Desktop and published on Power BI Report Server.

•Involved in Building Multi-Dimensional Cubes, Data Modeling, and OLAP Cubes using SSAS.

•Devises data verification methods and standard system procedures.

•Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.

•Utilized multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transforming and finally loading into the staging database.

•Involves in designing and implementing parameterized and cascading parameterized reports using SSRS.

•Implemented SSIS packages utilizing checkpoint, logging, breakpoint, and transaction options.

•Involved in creating Sub-Reports, Drill down reports, and Drill through reports and Tabular reports using SSRS.

•Involves in configure and maintain Report Manager and Report Server for SSRS.

•Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.

•Widely used SQL Profiler for investigating, checking, and enhancement of SQL Server and non-creation database code and in addition T-SQL code from engineers and QA.

•Developed Server-side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.

•Responsible for Migrating data from Multifarious Data Sources and legacy systems (Oracle, Flat file, and Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS).

•Expertise in using ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.

•Implemented Report Snapshots to improve the performance of SSRS reports.

•Optimized the Database for best performance, with DBCC, partition table.

•Involved in Session monitoring, log analysis Implemented Various Data Transformations using Slowly Changing Dimensions.

Environment: Power BI, SQL Server, SSIS, SSRS, SSAS, TSQL, ETL, SQL Profiler, MS PowerPoint, Snowflake, MS Project, Oracle, Visual Studio and Windows.

Project #2 : Tata Consultancy Services June 2016 – July 2023

Role : Sr. Power BI Developer

Responsibilities:

•Designed, developed, and implemented reporting and dashboard solutions for enterprise-level healthcare systems, leveraging Power BI to capture business-case and technical requirements.

•Utilized SQL extensively to collaborate with SQL and Data Management teams in sourcing new data and developing data models for enhanced analytics and insights.

•Monitored daily ETL results to ensure accurate and timely data loading into Power BI, troubleshooting and resolving issues promptly.

•Enhanced reporting efficiency by refining and standardizing existing architecture, data models, and measures, adhering to Power BI community best practices.

•Documented data models, algorithms, metrics, and refresh schedules comprehensively using tools such as DAX Studio and Power Automate for clear sharing across teams.

•Conducted thorough testing of data for accuracy using DAX Studio and SSIS, researching and correcting irregularities to maintain reporting integrity.

•Demonstrated proficiency in creating and managing report and dashboard subscriptions within Power BI, ensuring timely delivery of insights to stakeholders.

•Conducted deep dive analyses of billing, denial, volume, and revenue trends using Power BI and SQL, providing root cause analysis on an ad hoc basis.

•Implemented detailed row-level security on data and understood application security layer models in Power BI, ensuring data privacy and compliance.

•Actively stayed updated on Power BI updates and release notes to leverage new features and capabilities effectively.

•Design, develop, and maintain interactive dashboards using OBIEE, enabling stakeholders to visualize and analyze data effectively.

•Create insightful and user-friendly visualizations using OBIEE to support data-driven decision-making and enhance business intelligence capabilities.

•Communicated effectively with stakeholders through excellent oral, written, and interpersonal skills, utilizing tools like Power BI for data visualization and storytelling.

•Assisted in data collection, preprocessing, and engineering tasks to support data scientists in developing and deploying AI/ML models, leveraging Python and PySpark.

•Developed and maintained upstream data quality assurance processes to ensure data accuracy and completeness before loading into applications, collaborating with Data Quality teams.

•Independently retrieved and interpreted product or regulation specifications, such as grouper input requirements, data requests, or federal transparency regulations, to support analytics initiatives.

•Developed a deep understanding of common healthcare utilization and cost metrics, including HEDIS, and maintained documentation of all development activities and code reviews.

•Supported inbound and outbound data loads aligned with Analytics team requirements, ensuring accuracy and completeness of data operations within the CDW and reporting/analytic layer.

•Maintained documentation of all development activities and conducted code reviews to ensure code quality and adherence to best practices.

•Implemented Python scripts for data preprocessing, feature engineering, and model deployment, collaborating closely with data scientists to integrate AI/ML models into reporting solutions.

•Developed automated data pipelines using Python to streamline data collection, cleansing, and transformation processes, improving overall efficiency and accuracy of analytics workflows.

Environment: Power BI, SQL Server, SSIS, SSRS, SSAS, TSQL, ETL, SQL Profiler, Snowflake,MS PowerPoint, MS Project, Oracle, Visual Studio and Windows.

Project #3 : Cognizant Technology Solutions Oct 212 – May 2016

Role : Business Intelligence Developer

Responsibilities:

•Provided Tier 5 Application Development and Tier 3 Application Support for both internal and external applications at FTC.

•Led Business Intelligence operations, leveraging Power BI to drive insights and enhance agency performance during transition to cloud platform.

•Developed reporting needs for ServiceNow applications in Tier 5 projects, ensuring efficient data extraction and visualization.

•Utilized Power BI to extract data from SQL database, creating datasets and reports for collaboration via Premium capacity.

•Facilitated transition from SAP BO to OBIEE, supporting development work in Power BI and providing comprehensive user training.

•Created datasets from on-premises and cloud application data in Power BI Desktop, optimizing reporting processes.

•Managed Power BI Premium and Pro license environments, publishing reports and dashboards for organizational use.

•Utilized DAX queries extensively and embedded Power BI reports within various internal applications.

•Implemented Power BI Gateways to connect on-premises data sources, ensuring data accuracy and timeliness.

•Developed and deployed Universes for applications, generating complex reports using SAP Business Objects XI and BI 4.2.

•Mentored Finance and HR staff on reporting tools, assisting with platform upgrades and documentation.

•Upgraded BO platform from XI 3.1 to BI 4.2, converting reports and preparing training materials for Web Intelligence 4.2.

•Designed and modified Universes using UDT and IDT, with proficiency in SAP BO administration tools.

•Collaborated with administrators on BO 4.2 installation, configuration, and content migration.

•Designed reports and dashboards in Tableau, sharing workbooks via Tableau Server.

•Worked with application development team on Oracle Forms and Reports 11g, utilizing SQL and PL/SQL for report generation.

•Demonstrated proficiency in web application technologies including Java, HTML, CSS, XML, JavaScript, SQL, and PL/SQL.

•Utilized database tools like TOAD and SQL Server Management Studio for efficient data management.

•Led requirement gathering, analysis, and functional/technical documentation efforts to support application development.

•Managed incident management processes using Remedy and Service Now platforms.

Environment: Power BI, SQL Server, SSIS, SSRS, TSQL, MS PowerPoint, MS Project, Visual Studio, OLAP, ETL, Excel and Windows.

Project #4 : I Space Global Services March 2010 - Oct 2012

Role : Business Objects Developer

Responsibilities:

•Worked with the Business analysts and the DBA for requirements gathering business analysis, testing, metrics, and project coordination.

•Created PL/SQL VIEWS to provide specific access to different roles.

•Developed Procedures for efficient error handling process by capturing errors into user managed tables.

•Worked on Oracle Forms and Reports 11g/10g for creating basic forms and reports that support one of the internal applications.

•Trained on SAP Business Objects by the Business Objects developers in the organization.

•Worked with other Business Objects developers and admin while creating and publishing reports in Business Objects XI 3.1.

•Created complex reports based on requirements from users of different applications using Web Intelligence Rich Client and Desktop Intelligence.

•Created hyperlinks to intranet pages from the Web reports.

•Extensively used filters, sections, breaks, drill, input controls, sort, calculations, and functions in the reports.

•Created variables using measures and formulas as per analysis requirements for the reports.

•Worked with Web reports through Info View.

•Worked with Admin for report publishing and scheduling.

Environment: MS SQL Server Management Studio, Query Analyzer, SQL Profiler, BCP, ETL, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).

Certifications

●Microsoft Data Analysis - Power BI

●Six Sigma Green Belt

Contact this candidate