Tamilarasan Manickam
Summary
Dynamic Power BI and SQL Developer with over three years of experience in creating advanced analytical reports, dashboards, and data models. Expertise in data analysis, scripting, and database management enables the extraction of actionable insights to drive strategic decision-making. Proven ability to translate complex data into clear, visual insights that enhance business performance. Strong collaboration skills with cross-functional teams and adaptability to evolving project requirements ensure timely delivery of high-quality BI solutions while maintaining a commitment to innovative analytics that support business growth and project objectives.
Overview
3
3
years of professional experience
Work History
Associate Senior Software Engineer
Customer Analytics India Private Limited
Chennai
08.2022 - Current
- Project: Allucent (Apr 2023 - Present)
- Project Description: This project focuses on developing Power BI dashboards and reports using data from Costtool, Salesforce, and D365, covering financial, employee, vendor, customer, transaction, order, and product information. It involved data modeling, transformation, and automation to ensure exact, prompt, and seamless reporting. Advanced visualizations were employed to simplify insights and support data-driven decision-making, offering a unified view of key business metrics to enhance organizational performance.
- Responsibilities Held:
- Designed and developed advanced Power BI dashboards and reports, KPIs, and drill-down reports, enhancing decision-making processes.
- Built data models using Star and Snowflake schemas, improving performance with large datasets.
- Managed SQL scripting for data extraction, transformation, and loading (ETL), improving data retrieval speed through query tuning and indexing.
- Implemented data defragmentation and query optimization techniques to enhance database efficiency.
- Created parameterized stored procedures and user-defined functions to support dynamic data analysis.
- Transformed financial data from Excel into SQL queries, ensuring accuracy and adherence to business logic.
- Resolved complex data inconsistencies, delivering reliable financial reports.
- Procured advanced Power BI features, including DAX, dataflow, incremental refresh, bookmarks, and Direct Query mode.
- Derived Row-Level Security (RLS) and Object-Level Security (OLS) to restrict data access based on user roles.
- Automated report delivery by integrating Power BI with Outlook and SharePoint.
- Conducted regular maintenance and enhancement of BI solutions, incorporating new data sources and analytics capabilities.
- Supervised source control repositories, branches, and pull requests, streamlining collaboration and deployment workflows.
- Applied CI/CD methodologies for report deployment within a DevOps environment.
- Scheduled automatic flows to send exported report files to users via email and upload them to specified locations.
- Specific functional requirements and test cases for D365 integrations, ensuring comprehensive documentation.
Associate Senior Software Engineer
Customer Analytics India Private Limited
Chennai
08.2022 - 03.2023
- Project: TSI Operation and Planning (Aug 2022 – Mar 2023)
- Project Description: A range of integrated business, infrastructure, and operational data in a data warehouse environment, with surrounding analytical and reporting (BI) capabilities. Migration of data from Microsoft Azure SQL Data Warehouse to our environment.
- Responsibilities Held:
- Computed and validated scripts to fix duplicates, ensuring data accuracy, detecting inconsistent data, and aligning with business granularity.
- Utilized data visual representations for strategic planning and worked with visual-level filters and conditional columns.
- Wrote DAX expressions to meet business calculations by used logical, time intelligence, and date functions to align with end-user expectations.
- Transitioned from manual to scheduled refresh processes for BI files.
Education
Bachelor of Engineering -
Coimbatore Institute of Engineering and Technology
07.2022
Skills
- Business Intelligence: Dashboard Development, Paginated Reports, Data Modeling, DAX, Power Query, Dataflow, KPI Scorecards, Row-Level Security, Object-Level Security
- Database Management: Dynamic Stored Procedures, Views, Functions, Query Optimization, Data Warehousing
- Integration & Automation: Power Service, Data Refresh, Data Transformation, Workflow Automation, Deployment pipeline, DevOps Task Management
- Tools & Technologies: Microsoft Power BI, SQL Server, Azure DevOps, SSRS (Report Builder), Microsoft D365, Azure Synapse, Power Automate
Timeline
Associate Senior Software Engineer
Customer Analytics India Private Limited
08.2022 - Current
Associate Senior Software Engineer
Customer Analytics India Private Limited
08.2022 - 03.2023
Bachelor of Engineering -
Coimbatore Institute of Engineering and Technology