About Me
Having Around 4+ Years of Professional IT Experience with Business Intelligence tools like Power BI (Power BI Desktop and Power BI Service). Experience in connecting with multiple data sources like SAP BW, SharePoint ser…
Having Around 4+ Years of Professional IT Experience with Business Intelligence tools like Power BI (Power BI Desktop and Power BI Service). Experience in connecting with multiple data sources like SAP BW, SharePoint services, SQL Server, and Excel from Power BI to build complex Datasets. Extensively worked on performing the ETL Activities in Power Query.
Experience
Data Analyst/Power BI Reporting
Power BI
Participatedin requirements meetings andScrum Calls to understand the Report Requirements.
Identified and documented detailed business rules.
Be able to create advanced-level reports utilizing Cognos, SQL, MS Excel, and other tools as needed for
aggregate reporting, safety data surveillance, data mining, and risk management.
Develop & Support the Standard/ad-hoc reports against TM1 using IBM Cognos v11
Contribute to the design and implementation of the metadata, ETL, and/or reporting components of
the solution. This includes testing and, at times, deployment of the components
Produce client deliverables such as detailed design documentation, configuration documentation, and
unit test plans
Conduct report validation efforts to ensure proper data representation
IntegratedCustom Visuals based on business requirements usingPower BIdesktop.Created
Hierarchies andDrilldown Reports.
Installed and ConfiguredData Gateways toRefresh and Schedule Refresh theDataset.Managed access
to Reports,Dashboards, andData for individual users using roles.
Implemented RowLevel Security as part of Security.
Provided continued maintenance and development of bug fixes for the existing and new Power BI
Reports.
Principal Resource Coordinator
Data Analyst/Power BI Developer
Participated in requirements meetings and Scrum Calls to understand the Report Requirements.
Identified and documented detailed business rules.
Created advanced-level reports utilizing Cognos, SQL, MS Excel, and other tools as needed for aggregate reporting, safety data surveillance, data mining, and risk management.
Developed and supported the Standard/ad-hoc reports against TM1 using IBM Cognos v11.
Contributed to the design and implementation of the metadata, ETL, and/or reporting components of the solution.
Tested and, at times, deployed the components.
Produced client deliverables such as detailed design documentation, configuration documentation, and unit test plans.
Conducted report validation efforts to ensure proper data representation.
Integrated custom visuals based on business requirements using Power BI Desktop.
Created hierarchies and drilldown reports.
Installed and configured data gateways to refresh and schedule refresh the dataset.
Managed access to reports, dashboards, and data for individual users using roles.
Implemented Row Level Security as part of security.
Provided continued maintenance and development of bug fixes for the existing and new Power BI reports.
Tableau /Power BI Developer
Imported data from data sources and prepared the data in Power Query as per user requirement.
Built relationships between the various tables in Power Pivot.
Provided Tableau developer support to the SEA 10 corporate operations and Total Force directorate.
Involved in various phases of the project like development, testing and support.
Defined the scope of the project, gathered business requirements, did analysis and documented requirements.
Created new columns and new measures using DAX functions.
Created different filters like visual level filters, page level filters, and report level filters as per reporting needs.
Created various customized and interactive reports and dashboards in Power BI.
Published reports to Power BI Service and provided access to required users.
Designed diverse types of reports like drill down, drill through, and Sync Slicer.
Developed custom report tool tips for different reports to showcase multiple data points in one report.
Built 50+ Tableau reports, dashboards, and metrics in EDW, resulting in a 25% improvement in efficiency.
Used visualizations like donut chart, pie chart, bar graph, tree map, waterfall charts, and card visualizations.
Power BI Developer
Participated in requirements meetings and Scrum Calls to understand the Report Requirements.
Used Power Query / Query Editor for data transformation as per the reporting needs.
Created data model in Power Pivot by establishing the relationship between the tables.
Enhanced the data model by creating new columns and new measures using DAX.
Developed at least two to three visual options for each report for discussion with stakeholders and customers.
Created hierarchies and drilldown reports.
Created Microsoft Power BI dashboards in Power BI Service using reports.
Installed and configured data gateways to refresh and schedule refresh the dataset.
Managed access of reports, dashboards and data for individual users using roles.
Implemented Row Level Security as part of security.
Provided continued maintenance and development of bug fixes for the existing and new Power BI reports.