Ramaswamy Iyer

About Ramaswamy Iyer

A self-motivated and highly efficient Business Intelligence professional with a passion for delivering data-centered solutions that enable better decisions from the executive team and throughout the entire organization. Over 6+ years of experience in database/warehouse design and development with a focus on planning, implementing, deploying and supporting enterprise-level Business Intelligence and Data Warehouse implementations.Have a proven track record in delivering mission critical/ large projects from inception to completion, adeptly applying experience too efficiently and elegantly solve problems and create solutions.Exceptional communization and organizational skills illustrated by leading major complex initiatives simultaneously that result in measurable improvements in ROI. Capable of delivering results as a high-performing individual-contributor.Always on the lookout for challenging environments and projects capable of fully exploring my skills and talent.Extensive knowledge of DW/BI Tools / Skills such as Tableau, Presto Query Fabric, Teradata, SSIS, Microstrategy, SAS Visual Analytics, SQL Server, T-SQL, Power BI, Agile, Business ObjectsIndustry Experience: Video and Telecommunications, Healthcare services, IT Services, Research, Financial Services, EducationActively looking for Business Intelligence Analyst| Data Analyst| BI Developer| BI Engineer roles.

Experience

1. Senior Business Intelligence Analyst

   Valcourt Group

   Jun 2023 — Present

   A highly technical role involving multiple projects that required understanding the intricacies of the business and designing end-to-end custom solutions integrated with Sage 300 Construction for the organization’s waterproofing Companies, Window Cleaning, AR, and AP modules.• Designed, developed, and maintained Job Cost Summary, Job Transactions with Labor Hours, Labor Hours, and Accounts Receivable Reports in MS Data Fabric to provide actionable insights and information into key financial and operational metrics.• Created and maintained data pipelines and ETL processes using Azure Data Studio and MS Data Fabric Lakehouse, SQL Endpoint and data factory.• Troubleshoot, Optimize the performance of existing reports and dashboards within the Data factory, ensuring data accuracy and consistency. • Developed interactive and visually compelling dashboards that provided actionable insights for leadership.• Developed documentation and monitored, maintained the health of data sources and report repositories.• Conducted data analysis and proactively identified trends, anomalies, and patterns within the data. Validated the data further to ensure data accuracy and consistency and opportunities for process improvement.• Collaborate with IT teams to ensure data security, integrity and compliance with best practices.

Education

• University of Colorado Denver Business School

  Master of Science - MS, Management Information Systems, General

• Harrisburg University of Science and Technology

  Master of Science - MS, Data Analytics

• University of Mumbai

  Bachelor of Engineering (B.E.), Information Technology

  2008 — 2013

Skills

• Microsoft Office
• C++
• Html
• Research
• Microsoft Excel
• Microsoft Sql Server
• Project Management
• Mysql
• Java
• Microsoft Access
• Sas Visual Analytics
• Microstrategy
• Tableau
• Advanced Java (Oops)
• Management
• Data Analysis
• Sql
• Microsoft Word
• Powerpoint
• Public Speaking
• Customer Service
• Leadership
• Team Leadership
• Epic Ehr
• Javascript
• Project Libre
• My Sql
• Html5
• Sharepoint Designer
• Software Testing
• Customer Service and Leadership
• Software Testing Life Cycle
• Social Media
• Information Technology
• Marketing
• Oracle Toad Sql
• Infoed
• Networking
• Data Management
• Process Improvement