Rushil Tikai Tikai

• Project Leadership in Agile Environments: Successfully led BI projects using Scrum and Agile methodologies, ensuring on-time delivery and alignment with strategic goals.
• Business Process Optimization: Analyzed and improved existing business processes, resulting in increased operational efficiency and reduced costs across projects.
• Data-Driven Insights: Performed comprehensive data analysis with SQL and ETL tools, identifying trends and opportunities that drove data-driven decision-making and revenue growth.
• Implemented automated testing frameworks to enhance efficiency and accuracy, reducing manual testing efforts by 50% and improving overall test coverage.
• Applied the PDCA (Plan-Do-Check-Act) cycle and DMAIC to systematically enhance product quality, leading to a 25% reduction in defects and a more streamlined data process across multiple projects.
• Stakeholder Management & Requirements Analysis: Managed stakeholder relationships, gathering and translating business needs into actionable system enhancements.
• Coordinated release cycles with development, QA, and operations teams, effectively mitigating risks and ensuring smooth transitions from development to production.

• Managed multiple service projects concurrently, showcasing strong multitasking and prioritization skills.
• Monitored and optimized ETL processes, ensuring accurate data transfers and timely updates from source files to data marts.
• Proactively managed BI applications, ensuring optimal system performance and quick resolution of operational challenges.
• Monitored and analyzed testing results, using key quality metrics to drive continuous improvements and optimize the QA process.
• Oversaw change management processes, including RFCs, to ensure smooth system updates and continuous improvement.
• Engaged in stakeholder management to communicate project status, address concerns and align with business requirements.
• Streamlined workflows in Informatica PowerCenter, developing recovery workflows to maintain data flow and system reliability.

• Consultancy Across Multiple Clients: Engaged as a consultant for various clients, gaining experience in diverse IT environments and projects, adapting solutions to meet unique client needs and challenges.
• Project Management: Led and managed BI projects from inception to completion, overseeing project timelines, resources, and deliverables to ensure successful implementation and client satisfaction.
• Data Analysis & Insights: Conducted in-depth analysis of large datasets using SQL to identify key business trends, driving revenue growth.
• Data Integration and ETL Processes: Designed and implemented data integration solutions, utilizing ETL tools to aggregate data from multiple sources into cohesive, actionable insights.
• Dashboard and Reporting Solutions: Developed and deployed dynamic dashboards and reports using tools like Power BI, empowering clients with real-time data visualization and analysis capabilities.

• Customer-Centric Solutions: Analyzed customer needs to deliver tailored solutions, ensuring alignment with client priorities and goals.
• SQL & Data Analysis: Executed SQL queries in Oracle to retrieve and analyze financial data, aiding in the management of unpaid invoices.
• Solution Design: Collaborated with the IT team to design and implement effective solutions that met business needs and aligned with technical constraints.
• Developed and executed test strategies: Developed and implemented customized test strategies for financial data products, ensuring data integrity, security, and high performance while adhering to stringent financial regulations.
• Created and maintained QA documentation, including test plans, test scripts, and defect reports, ensuring full traceability and adherence to banking industry standards, while enhancing the overall quality control process.
• Risk & Issue Management: Identified project risks and implemented mitigation strategies, while managing tickets and documentation using Jira for seamless deployment.
• Client Relations: Maintained strong client relationships, providing consistent updates and addressing concerns to ensure satisfaction and project success.

• Ensured adherence to quality standards and regulatory compliance, particularly in the medical sector, where accuracy and data security are paramount.
• Developed and optimized SQL stored procedures to ensure data compatibility and integrity with the new HR system.
• Utilized performance testing tools to validate system scalability and reliability, particularly in high-stakes financial environments where data integrity is critical.
• Performed data mapping to align old data formats with new system requirements.
• Automated ETL processes using SSIS, streamlining data processing and enabling more timely reporting capabilities.
• Conducted thorough data analysis to extract insights, identify trends, and support data-driven decision-making processes.
• Project Planning and Execution: Developed detailed project plans, including timelines, milestones, and resource allocation, ensuring all project deliverables were met efficiently.
• Testing and Validation: Developed test plans and coordinated user acceptance testing (UAT) to ensure that solutions met business requirements and were free of defects.

• Established automated ETL processes and performed daily data analysis to support business operations.
• Automated data input by retrieving and storing JSON source files in tables using SSIS, and created SQL views, stored procedures, and CTEs to resolve business challenges and boost operational efficiency
• Leveraged Microsoft SSIS, PowerBI, and SQL Server Management Studio 2018 to successfully meet project objectives.
• Facilitated regular QA reviews and audits, using the PDCA approach to identify areas for improvement and implement effective solutions that enhance overall product quality.
• Utilized testing tools to perform regression tests, unit tests and user acceptance tests, ensuring system stability, identifying defects early, and improving overall product quality.
• Conducted thorough risk assessments and developed mitigation strategies, successfully addressing potential release issues before deployment.
• Delivered insights to stakeholders through PowerBI and Excel, ensuring effective data visualization and clear communication.
• Conducted requirements analysis to document and define business needs, ensuring project alignment.
• Developed and maintained comprehensive project documentation, including status reports and evaluations, to support project tracking and reviews.

• Azure BI Mastery: Completed a specialized masterclass in Data-Driven working, focusing on Microsoft Azure and key BI tools like SQL, PowerBI, and SSIS.
• SSIS & SSRS Development: Created and modified SSIS packages and SSRS reports to optimize data integration and meet customer reporting needs.
• Operational BI Management: Managed and maintained BI applications, ensuring seamless operations and minimal downtime.
• Customer-Centric Solutions: Conducted in-depth analysis of customer needs to deliver tailored BI solutions, enhancing service quality and satisfaction.
• Incident & Change Management: Acted as the primary contact for incident resolution and managed Requests for Change (RFCs), ensuring structured implementation of updates.
• Azure Resource Management: Managed Azure resources and made adjustments to Azure Logic Apps to improve performance and efficiency.

• This position was an extension of the graduation internship, aimed at realizing the recommendations presented in the thesis.
• Microsoft SharePoint Research: Investigated the potential applications of Microsoft SharePoint within RET to enhance operational efficiency.
• Increase Transparency: Analyzed and documented existing processes to identify areas for improvement and increase transparency.
• Lean Implementation: Applied Lean principles to eliminate unnecessary work and streamline processes, enhancing overall efficiency.
• Business and Technical Alignment: Combined business requirements with technical opportunities to develop effective solutions.

Deliver an advisory report with recommendations for a new, optimized method for managing incoming and outgoing post, both digital and analog.
Analyze the current working methods, identify bottlenecks, and gather user experiences.

Optimized Database Components: Implemented new components and improvements that significantly enhanced database performance, efficiency and usability.
Establish Relationships Between Tables (Modeling): Developed and implemented database schema to ensure efficient data relationships and integrity, improving overall database performance.
Create Queries Related to Database Refreshing: Designed and executed SQL queries for regular database updates and refreshing processes, enhancing data accuracy and availability.
Create Macros: Automated repetitive tasks and processes using macros, increasing operational efficiency and reducing manual errors.
Testing: Conducted thorough testing of database components and processes to identify and resolve issues, ensuring reliable and accurate data handling.
Prepare Work Instructions for End Users: Compiled comprehensive work instructions and documentation for end users to facilitate smooth adoption of new processes and tools.