Data & BI Specialist
Tec Evolution Technology Systems
Total years of experience :12 years, 9 Months
IT services and consulting operated under POM Holding.
• Proactively enhance and secure database systems & Power-BI on premises solutions to ensure seamless business operations.
• Mentor team members which include a DBA and two Analyst/Scientists.
• Manages complex datasets by identifying, aggregating, cleaning, and validating data from multiple sources in preparation for reporting use.
• Developed and maintained Power BI dashboards/reports for various business operations across multiple systems, including Dynamics 365 ERP, MRI CAFM, Ivanti ITSM, Moodle LMS, SharePoint, Hospitality, Project Management, Portfolio Management, and Survey Tools.
• Oversaw the management of database systems, including supervising DBA tasks, defining workflows for change requests, and driving continuous improvement.
• Collaborated with cross-functional teams and stakeholders to understand their data needs and provided insights that supported informed decision-making.
• Successfully migrated Excel and Access database applications to Low-Code Platforms (Joget, MS-SQL), improving usability and efficiency.
• Played a key role in migrating databases and Power BI RS to a private cloud (G42), optimizing system performance and scalability.
• Conducted regular maintenance, monitoring, and optimization of database servers, utilizing performance metrics to identify and address issues.
• Proactively monitored error logs, long-running queries, deadlocks, and performance bottlenecks, taking prompt action as needed.
• Expertly installed and configured database servers for development instances, ensuring smooth onboarding into the production DB cluster.
• Maintained up-to-date database servers with the latest Cumulative Updates (CU), following rigorous testing and approval processes.
• Implemented tuning and optimization strategies, including indexing, statistics maintenance, and integrity checks, resulting in significant enhancements to system performance and efficiency.
• Developed a custom solution (usidng SQL and PowerShell) for data anonymization during database restoration in development instances.
B-to-B E-Commerce company for floral products
• Manage the Florisoft online platform business application (.Net - SaaS) to ensure smooth business operations and the integrity of supplier systems with the platform.
• MIS Reporting: design and develop KPIs, and dashboards based on the Sybase database and platform reporting tool.
• Develop and maintain new processes and procedures by understanding business requirements.
• Administration support on domains, email, and websites using WordPress CMS.
• Ensure system integrity and configuration standards are met.
Multi-brand F&B and Entertainment franchise owner in the GCC Region. Operated brands are Chuck E Cheese, CaliBurger, and fine dine-in restaurants.
• Configuration and Installation of NCR Real POS Terminals and Peripherals on OPOS/ Java POS
• Troubleshooting the issues, Windows customizations and Installation
• Developing System Images with different flavor of the Hardware and OS. Maintenance of Firmware update for the peripherals
• NCR POS hardware Demo Preparation and Presentation
• Providing remote support, Onsite support and Back to base support as per SLA
• Attending the calls over the emails, phones and scheduling on-site support
• Working with Rollout Plans, Internal/External Meetings
• Installing and configuring PC and hardware troubleshooting
• OS, applications and Outlook Installation & configuration, Windows customization
• Providing Remote support either on site or over the telephone to help set up systems or resolve issues
• support, including procedural documentation and relevant reports
• Organization EDP front office employee shifting’s | Generating the job card reports & submits to the EDP Manager
• Maintaining the SQL Database backup, monitoring daily backups as per schedule
Secondary School Certification is the 10th Class in AP, India