Power Bi Developer

TAMILARASAN MANICKAM

Software Engineer

Customer Analytics India Private Limited, Chennai

****************@*****.*** 805-***-**** Salem

Profile Summary

Experienced Power BI and SQL Developer with over 2.5+ years of expertise in designing and developing analytical reports, scripting, and data analysis. Proven ability to translate data into actionable discernment, litheness and have a clear vision to drive business decision- making while delivering high-value BI and analytics solutions. As of now seeking a challenging role that leverages my skills to adapt the environments that drive growth, enhance organizational viability, and deliver business results. Renowned for exceptional teamwork, adaptability, and consistently delivering results. Reliable and focused on effectively meeting project goals. Professional Experience

Software Engineer Customer Analytics India Private Limited Feb 2023 – Present Present Project: Allucent

Domain: Health Care and Finance

Project Description: Allucent provides wide-ranging regulatory and planning services to small and midsized biotechnology companies, supporting the development and approval of therapeutic innovations through clinical trials and regulatory approval processes worldwide, utilizing a network of multiple providers. Environment: SQL, Power BI, Power Automate, Azure Devops, Report Builder, Dynamics 365

SQL & Power BI Developer with over 2.5+ Years of development experience in Microsoft tools.

Expertise in navigating challenging environments, managing timelines, understanding business and deriving the logic in SQL dynamically.

Skilled in handling data with SQL scripting, and knowledge of relational databases, views, parameterize stored procedures, and functions.

Worked to enhance the speed and efficiency of data retrieval from a database, it is essential to implement data defragmentation and optimize SQL queries.

Excellent innovative thinking skills for converting data into visually appealing reports, dashboards, graphs and drill-down and drill-through in tables and matrices KPI scorecards.

Proficient in Power BI data modeling and data warehousing concepts, specifically Star Schema, Snowflake Schema, Dimensions and Fact Tables.

To perceive the financial process and convert the logic that implemented in the provided Excel spreadsheet into a SQL query, utilizing data from a database. This endeavor requires a thorough understanding of the data structure and relationships, as well as the design of a related database scheme to efficiently store and manage financial information.

Resolved data peculiarities and produced the expected financial numbers.

Managed advanced Power BI features including advanced DAX, dataflows, incremental data refresh, direct query (Live Connection) method and various data transformations in Power Query Editor.

Implemented Row-Level Security (RLS) and Object-Level Security (OLS) to enforce security models, ensuring sensitive or reliable data is restricted from unauthorized users and access is controlled based on predefined security policies.

Utilizing complex Excel features like PivotTables, VLOOKUP, and data visualization tools, I conducted thorough data analysis and produced perceptive reports that helped the business make well-informed decisions.

Developed Power BI integration button clicks then export paginated report and automatically sends to the respective end users via Outlook and SharePoint folder, ensuring seamless report delivery and enhanced user experience.

Perform regular maintenance and updates to existing BI solutions to enhance functionality, incorporate new data sources or analytics capabilities and ensure the accuracy, completeness, and reliability of the data used for analysis.

Optimized query performance through indexing, query tuning, and profiling techniques to reduce data retrieval time and improve query efficiency, particularly while dealing with huge volumes of data.

Defined D365 functional requirements and test cases, ensuring comprehensive documentation for development teams

Provided cross functional support, enhancing collaboration and improving project outcomes across the teams

Managed repositories, branches, and merging pull requests for several developed reports, demonstrating a proficient ability to maintain branching strategies, resolve conflicts effectively, and streamline collaboration among team members.

Implement and oversee version control for all Power BI reports and utilize Continuous Integration/Continuous Deployment (CI/CD) methodologies to facilitate the production and deployment of reports.

Manage and maintain SQL and Power BI-related tasks within the DevOps environment Technical Tools & Skills

Microsoft SQL Server Management Studio (SSMS)

Microsoft Power BI Desktop

Power Automate

Report Builder (Paginated Report)

Advanced Excel, Microsoft PowerPoint, Word

Azure Devops

Microsoft D365

Soft Skills

Communication

Time Management

Task Management

Problem Solving

Teamwork

Work Ethic and Dependability

Leadership Skills

Flexible and Innovative Thinking

Decision Making

Education

Bachelor of Technology (Regular)

Department of Information Technology

Coimbatore Institute of Engineering and

Technology – 2022 Coimbatore

Languages Known

English (Proficient)

Tamil (Expert)

Additional Skills

Strong analytical skills with ability to identify and interpret current trends

Formulation of Action Plans

Adapt swiftly to new tools and Technologies.

Strategic Conflict Resolution, Mediation, and Team Organizing

Proficient in managing multiple tasks under tight deadlines

Reformulate the suggestion to more effectively convey the advancements made, thus enabling a more comprehensive understanding of the project's progress.

Awards

Team achievements - Allucent project for SQL and Power BI development Aug-2023

Team achievements - Allucent project for SQL and Power BI development Aug-2024

Contact this candidate