Rushikesh Ambulgekar

Clarity Jaspersoft Report & Docpro SSRS Reports Conversion into Power BI reports

• Developed & delivered 16 complex Power BI reports for PMO Emerson.
• Collaborated with business stakeholders to gather requirements and understand data needs.
• Created and maintained data models, transforming raw data into meaningful information.
• Implemented and optimized ELT & ETL processes for efficient data extraction, transformation, and loading.
• Configured Power BI dashboards to visualize key performance indicators of the organization.
• Observed and document lessons learned and advise Project Manager on ideas to make the project successful.
• Managed version control system for tracking changes made in different releases of BI applications.
• Created or reviewed technical design documentation to drive accuracy of reporting solutions.
• Performed complex SQL queries on large datasets using SQL Server Management Studio.
• Establish data level security, object level, row level security.
• Administered Production and Development workspaces.
• Provided training sessions to end-users on using Power BI reports and self-service analytics.

MIS Reporting & Global Profit Review Analysis -

• Developed & delivered 5 Business Power BI reports for EEEC.
• Converted exiting Excel Macro based reports to Power BI
• Provided support and maintenance to existing management information systems reports (MIS)
• Implemented and optimized ETL & ELT processes for efficient data extraction, transformation, and loading
• Prepared weekly, monthly & quarterly MIS reports and Power point presentation for the stakeholders.
• Prepared Global Profit Review analysis Dashboard for KPI.
• Optimized Exiting Excel reports using VBA Macros.

Database Administration (Microsoft SQL Server) –

• Strong SQL knowledge and experience in DML, DDL,DCL, DDL SQL queries.
• Good at T-SQL Stored Procedure programming skills.
• Developed SQL Queries, Views, worked on Stored Procedures, Dataflows to extract, transform, and load data for reporting and analysis purposes.
• Monitoring Email alerts of linked servers, Health maintenance of Database etc.

Software Lifecycle (DocPro & PMO CTS) –

• Led end-to-end software lifecycle management for multiple projects, ensuring timely delivery and adherence to quality standards
• Collaborated with cross-functional teams, including business stakeholders, developers, and testers, to gather requirements and define project scope
• Created comprehensive project plans, outlining key milestones and deliverables, and monitored progress to ensure on-time completion
• Implemented Agile methodologies, facilitating daily stand-up meetings, sprint planning, and retrospectives to improve team collaboration and productivity
• Conducted thorough testing and quality assurance procedures to identify and resolve issues, ensuring robust and reliable software solutions
• Collaborated with operations & IT teams to monitor and support production systems, performing troubleshooting and bug fixes as required