Rajimol Kuthapalli Rajendran

With expertise in Tableau, Excel, Power BI, SQL, MS Access, VBA, and VB.Net, I have successfully transformed data into actionable insights to drive business performance.

• Advanced Reporting: Expertly generated diverse reports, including Sales Performance, Inventory Turnover, and Store Productivity Reports, utilizing advanced Excel features such as PivotTables, VLOOKUPs, and complex charting techniques.
• Dynamic Data Visualization: Leveraged Power BI to create interactive dashboards, highlighting sales trends, inventory levels, and regional performance for enhanced decision-making.
• Data Management: Systematically collected, cleaned, and interpreted crucial datasets, including cost analysis, productivity metrics, sales forecasts, and demand patterns, to support strategic initiatives.
• Root Cause Analysis: Conducted in-depth investigations to identify discrepancies and inefficiencies, proposing data-driven solutions to enhance operational performance.
• Training & Mentorship: Provided comprehensive training on product specifications, retail analytics tools, and reporting procedures to new team members. Mentored colleagues in Excel macros, VB.Net, and Oracle, ensuring accuracy in report generation.
• Supply Chain Oversight: Monitored the end-to-end flow of goods, identifying bottlenecks and gaps to streamline operations and improve efficiency across the supply pipeline.
• Process Improvements: Implemented enhancements that reduced lead times and costs, significantly increasing operational efficiency.
• Effective Communication: Developed PowerPoint presentations and detailed Word documents to communicate complex data insights and business trends to senior management.
• Quality Control: Conducted rigorous quality control checks on key reports, ensuring accuracy through cross-referencing multiple data sources and applying statistical validation methods.
• Inventory Management: Evaluated daily business trends and collaborated on Open-to-Buy strategies to align inventory with market demands, optimizing product availability and preventing stock issues.
• Process Optimization: Streamlined business processes for increased efficiency and led cross-functional teams to successful project completions, improving overall productivity through comprehensive analysis.
• Strategic Planning: Developed and implemented strategic business plans that enhanced the company's market position and drove sustainable growth.
• Streamlined business processes for increased efficiency.
• Improved overall productivity with comprehensive process analysis.
• Identified areas of improvement through detailed data analysis.
• Designed new business model, resulting in streamlined operations.
• Analysed financial reports for informed decision making.
• Optimised resource allocation to enhance operational efficiency.
• Collaborated with IT department to integrate technology solutions into business strategy.
• Performed gap analysis, identifying areas of underperformance and inefficiency.
• Maximised project ROI, performing user acceptance testing (UAT) to validate user requirements and expectation.
• Analysed complex data sets and studied impacts on business growth and operational efficiency.
• Developed innovative methods to elevate customer satisfaction.
• Automated tasks to increase efficiency and reduce department workload.
• Formulated and submitted monthly performance reports for strategic decision-making.
• Developed and implemented ETL processes and enforced adherence to established procedures.
• Fostered efficient data extraction through design and development of ETL pipelines.
• Utilised industry-leading tools to support ETL operations.

Application Developer
Experienced in developing and implementing Windows applications using VB.Net and SQL Server 2005 for key hospital departments, including Registration, Pharmacy, and Billing.

• Requirements Analysis: Conducted detailed requirements analysis to translate departmental needs into functional applications, ensuring alignment with operational goals.
• Full Development Lifecycle: Managed the complete development lifecycle, including coding, implementation, testing, and providing training to end-users across departments.
• Documentation: Created and maintained comprehensive user and technical documentation to support application usage and development processes.
• Reporting Solutions: Generated custom reports using Crystal Reports 11 and Data Grid Views, delivering critical insights for decision-making.
• Database Management: Designed and managed database components, including triggers, views, and stored procedures, to support application functionality.
• Microsoft .NET Technologies: Engaged in database design, analysis, and module implementation using Microsoft .NET technologies, enhancing application performance and usability.
• User Support: Provided continuous support and training to ensure smooth application usage across departments, addressing issues promptly and effectively.
• Database Administration: Developed and maintained database administration tools and procedures, ensuring data integrity and optimal system performance.
• Collaboration: Collaborated with department heads to ensure applications met specific operational needs and improved workflow efficiency.
• Automation: Created automated processes within applications to reduce manual workload and minimize errors, enhancing productivity.
• Legacy System Transition: Supported the transition from legacy systems to newly developed applications, ensuring minimal disruption to hospital operations and user adaptation.
• Ensured seamless user experience by identifying and fixing bugs in live systems.
• Regularly performed code reviews fostering improved team collaboration and learning opportunities.