About
As a SQl/Power BI developer I have a successful track record in handling substantial volumes of data. I was part of teams that effectively managed data by constructing intricate models and creating scripts to extract valuable insights. I utilized both SSRS and Power BI to develop comprehensive reports and implement impactful data visualizations, offering the stakeholders a clear and insightful presentations of complex information for informed decision-making.
With a background in finance and costing, I bring a strong understanding of costs, expenses, and financial metrics assessment to the table. My dual experience as a cost analyst and BI developer positions me as a preferred candidate for the BI developer role.
Looking for Full-TimePortfolio
Human Resource Dashboard
The primary goal of this project is to leverage the capabilities of a Human Resource to gain valuabl... ... More
Employment History
-
SQL / Power BI Developer
Colaberry Inc
November 2020 - Present
• Extensive hands-on experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using MS SQL Server 2019.
• Excellent backend skills in creating SQL objects such as Tables, Stored Procedures, Effective Functions, Temp Tables, Indexes to facilitate efficient data manipulation and consistency.
• Strong experience in client interaction and understanding business applications, Data Modeling, Data Mining, Data flow and Data relations.
• Implement Star and/or Snowflake schemas while designing relational database and data warehouse as per business and report requirements.
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS).
• Proficient in creating SSIS Packages for integrating data using OLE DB, SQL Server Connection from heterogeneous sources (Excel, CSV, Flat file, Data, XML and Zip file) by using multiple transformations.
• Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Modeled data requirements to successfully create graphs and metrics in Power BI to create insightful and visually appealing data visualizations.
• Designed and implemented data models using Power BI to establish relationships between different data tables.
• Created calculated columns and measures using Data Analysis Expressions (DAX) for advanced calculations.
• Incorporated a variety of visualizations such as tables, charts, maps, and custom visuals to convey insights effectively and also implemented drill-down and drill-up functionalities for users to explore data at different levels.
• Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.
• Worked with Business Analysts, Web development team and users on database solutions.
• Collected business requirements from users and translated them as technical specifications and design documents for development.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills. -
Cost Analyst
Henkel India Limited
January 2010 - December 2010
At Henkel India Ltd, a FMCG Company, reported to the Cost Analysis Manager and Business Controller of the Finance department.
• Variance analysis – calculation of brand-wise material consumption and factory overheads and analyze the differences and report.
• Sourcing pattern analysis – to identify the lowest cost of source of supply for outsourced products by computing landed cost for each product.
• Dashboard - develop key performance indicators in consultation with each department, compute the same based on actual reported numbers on a monthly and year-to-date basis and report to department heads for their analysis and controlling.