Power Bi developer

Anto Raj Mithun

Contact Number: +1-214-***-****

Email Address: ad2tva@r.postjobfree.com

PROFESSIONAL SUMMARY

Over 6 years of Industrial Experience in BI solutions & Technical IT Support using T-SQL, Tableau, Power BI and working experience on Customized PL/SQL stored procedures, functions and packages.

Experienced in SDLC environment of project including requirement gathering, creating technical specifications, development and testing of end product.

Experienced in writing complex SQL queries which involve multiple tables’ joins, common table expressions (CTEs), user defined functions, views & triggers for data consistency and data manipulation according to the business requirements.

Hands on experience in understand business requirements in the BI context and design data models to convert raw data to meaningful insights.

Well experienced in creating dashboards and visual interactive reports using Power BI.

Taken care of data warehouse development.

Excellent experience in developing Reports using Tableau.

Increasing the efficiency and automation of various IT system applications and databases.

Build Various dashboards using Tableau. Based on customer requirement.

Utilize Power BI to build interactive and visually appealing dashboards and reports.

Identifying new opportunities to increase efficiency and performance.

Experienced in Jira ticketing tool managing different types of issues (stories, tasks, sub-tasks)

Experienced in Agile Scrum methodologies for report deliverables optimizing with story points estimations.

Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNOLOGY SUMMARY

Databases: MS SQL server, Oracle, PostgreSQL, MySQL, Mongo DB

BI&DW Tools: Microsoft Power BI Desktop, Tableau

Data Warehouses: Snowflake

Languages: SQL, PL/SQL, Python, T-SQL

Methodologies: Agile/Scrum/ Waterfall

Other tools: JSON, JIRA

Education

B. Tech in Information Technology, Noorul Islam Centre for Higher Education, India

PROFESSIONAL EXPERIENCE

Brierley + Partners –Power BI developer, December 2020-Till Date, Frisco, Tx, USA

Interacted with Business Analysts and end users to gather business requirements.

Written Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Study, analyze and understand business requirements in context to business intelligence.

Design and map data models to shift raw data into meaningful insights.

Utilize Power BI to build interactive and visually appealing dashboards and reports.

Run DAX queries and functions in Power BI.

Make essential technical and strategic changes to improvise present business intelligence systems.

Identify the requirements and develop custom charts accordingly.

Perform detailed analysis on tested and deployed Power BI scripts.

Create documents and maintain logical & physical data models in compliance with enterprise standards and maintained corporate metadata definitions for data stores within a metadata repository.

Involved in the designing, development, modification and enhancing database structures and database objects.

Collaborate with stakeholders to understand their data needs.

Ensure the accuracy and reliability of data presented in the dashboards.

Train end-users on how to use the dashboards and reports effectively.

Troubleshoot data-related issues and maintain the Power BI infrastructure.

Stay updated with the latest Power BI features, updates, and best practices.

Involved in extensive DATA validation by writing several complex SQL queries and involve in back-end validations and work with data quality issues. Create database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

Ability to use critical thinking to solve issues that arise.

Ability to troubleshoot database performance issues.

Ability to deliver successfully tasks and projects independently.

Ability to do performance tuning: query optimization (avoid coding loop and correlated subqueries), applying indexes and partition functions.

Tools & Technologies: SQL Server, SQL, PL/SQL, PostgreSQL, Microsoft Power BI Desktop

Alliance Healthcare Group - Data Engineer (Analytics & Data Warehouse), June 2020-December 2020, Malaysia

Written complex SQL&T-SQL Queries to implement the business logic.

Interacted with Business Analysts and end users to gather business requirements.

Experienced in developing and implementing data models to meet business needs.

Designed data models to convert raw data to meaningful insights.

Creating a dashboards and visual interactive reports using Power BI

Performed DAX queries and functions in Power BI.

Created charts and document data with algorithms, parameters, models, and relations explanations.

Mastered the ability to design and deploy rich graphic visualization with drill down and drop-down option and parameters using tableau (Claim adjudication and fraudulent detection).

Cleansing up dirty data makes it easier to combine and analyze your data or makes it easier for others to understand your data when sharing your data sets.

Normalize formatting to support Tableau’s ability to read/analyze the information. Build Various dashboard to find out claim fraud detection.

Able to build visually stunning and interactive dashboards.

Able to manipulate and blend data in order to design dashboards and visualization. Twisting SQL queries for improving performance.

Identifying patterns and meaningful insights from data by analyzing it.

Resolving any data or performance issues related to workbooks and data sources.

Analyze existing SQL queries for performance improvements and suggest new queries.

Hands on with Performance optimizations.

Monitor the performance of the database, data quality, troubleshoot and resolve problems.

Experienced in Jira ticketing tool managing different types of issues (stories, tasks, sub-tasks)

Experienced in Agile Scrum methodologies for report deliverables optimizing with story points estimations.

Tools & Technologies: SQL Server, SQL, PL/SQL, PostgreSQL, Tableau, Microsoft Power BI Desktop

Zen Linen International Pvt Ltd- SQL Developer (June 2018- March 2020), Chennai, IN

Recognize business requirements in the context of BI and create data models to transform raw data into relevant insights.

Utilize Power BI to build interactive and visually appealing dashboards and reports.

Build multi-dimensional data models.

Key role involvement in writing SQL Queries, Dynamic-queries, sub-queries and joins for generating Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

Experienced in database activities like Data Modeling, Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Normalization and Documentation.

Optimized the performance of slow running SQL Quires by changing the Index Columns and adding Cluster Index on the appropriate column of the Table.

Involved in the continuous enhancements and fixing of production problems.

Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Extensively used bulk collection in PL/SQL objects for improving performance.

Design and map data models to shift raw data into meaningful insights.

Experience in gathering data from various sources and transforming it into insightful reports and dashboards. Proficient in data modeling and integrating reporting components from multiple data sources.

Developed and Customized Invoice Reports and dashboards using the Power BI platform.

Transform business requirements into technical publications.

Successfully implemented a Power BI solution for a large manufacturing client.

Identify the requirements and develop custom charts accordingly.

For a better understanding of the data, use filters and visualizations.

Create charts and data documentation with explanations of algorithms, parameters, models, and relationships Construct a data warehouse.

Experience in working closely with various stakeholders, including business analysts, project managers, and data scientists, to understand their data needs and deliver solutions that meet them.

Ensuring the accuracy and reliability of the data presented in the dashboards and reports. This involves validating the data and implementing quality checks.

Ensuring data security is another important responsibility. This involves implementing appropriate access controls and data protection measures.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Customized and Developed PL/SQL procedures, functions, packages, triggers, tables, views, materialized views based on client Requirement.

Analyze and resolve current Production application issues.

Worked with different types of Data task to resolve issues daily using complex SQL quires in the production environment.

Participated in design and code reviews.

Perform root cause analysis on all processes and resolve production issues and validate all data.

Monitor the performance of the database and ensure optimum performance.

Tools & Technologies: Microsoft Power BI Desktop, SQL Server, SQL, PL/SQL, PostgreSQL

Contact this candidate