Pavan Ramarao

Experience

• 

  Wipro Limited

  Jul 2006 - Oct 2016

  Project Manager | Tech Lead | Business Analyst | Developer

  • Developed complex SQL queries and stored procedures to meet business requirements and functional specifications.• Designed, implemented, and optimized database structures to ensure high performance and data integrity.• Worked with CNI systems and ensured compliance to GDPR rules• Worked in multiple complex data transformation projects. • Created Database Design and optimized it using normal forms• Created system design using SOLID principles and design patterns• Engaged in unit testing and participated in code reviews to adhere to coding standards and best practices.• Managed database performance, troubleshooting issues, and ensuring data quality.• Developed complex web applications utilizing .NET core, C# and MVVM following object-oriented principles.Led requirement workshops and coordinated with offshore team members to convert requirements into solutions and conducted release planning and execution.• Spearheaded the delivery of projects in PRINCE 2 (waterfall) and Agile methodologies for major utilities and energy companies such as Shell and National Grid from investment proposal to service handover.• ed requirement workshops and coordinated with offshore team members to convert requirements into solutions including performing hands-on design and development talks and release planning and execution. Show less

• 

  Aon

  Oct 2016 - Jun 2018

  Delivery Lead

  • Led the successful implementation of an Enterprise Content Management platform across multiple geographies. • Developed Python scripts and PL/SQL programs to extract, transform and load taxonomy data for large insurance clients for storage and easy retrieval• Helped the PMO team with regular reporting and maintaining of the project metrices• Key member of the PMO team and ensured project delivery through well-defined plans and monitoring and reporting of progress.• Managed project risks, issues, and changes and ensured built in quality through reviews and automation. Show less

• 

  Capita

  Jul 2018 - Jul 2021

  Senior Development Manager

  • Lead the delivery of bespoke mobile application, used for work and asset management, through sprints following the lean agile development for multiple clients such as Scottish Power, Network Rail, SGN etc.• Lead three different teams totalling 35 team members. Performed people management responsibilities such as growth talks, performance appraisals, training and upskilling of team members, conflict management and career planning.• Successfully transitioned roles from onsite to India ensuring minimal impact to delivery.• Set up processes and metrices for smooth flow of deliverables, early forecasting of issues/deviations, efficient change and risk management and transparent reporting of the project status to all stakeholders.• Closely worked with Sponsors for creating business cases and performing cost benefit analysis is in line with business objectives• Developed complex SQL queries and stored procedures to meet business requirements and functional specifications.• Conducted peer code reviews and mentored junior team members to promote best practices and collaborative teamwork• Created and maintained technical documentation, including database schemas and design documents.• Lead the delivery of bespoke mobile applications to multiple utilities clients using C#, .Net core and SQL server for backend end and XAML, CSS for backend.• Created high-level system architecture and system design using SOLID principles and design patterns.• Developed RESTful APIs for enhanced integration with third-party systems.• Utilized Docker and Kubernetes for containerization and orchestration, optimizing deployment processes. Show less

• 

  Siemens Technology and Services Private Limited

  Aug 2021 - now

  Products & Solutions Development Team Leader

  • Collaborated with multiple product stakeholders and successfully lead the integration of their products into our bespoke mobile application product• Facilitated collection of data from Internet of things hub and store them on data lakes hosted on our custom cloud platform and developed ETL scripts for storage and easy retrieval of the data for analytics• Created analytics information using custom BI tools that helped to get better insight about feature utilisation that helped in the sales of the devices.• Led product development through sprints and quarterly releases following tenets of lean agile methodology. Ensured flow of deliverables by removing impediments/blockages and providing solutions to issues encountered during the sprints.• Ensured built in quality through review workflows, CICD pipelines, automated tests, stage gates and release milestones checklists• Upskilled team members through training plans to improve productivity, foster innovation and keep up with the growing market.• Constantly engaged with the team and kept them motivated thorough interactions and regular growth talks.• Kept track of the project budgets by regular review and reporting of finances, accurately predicting the labour and material costs and optimising project costs through FOC imports and productivity improvements.• Ensured smooth releases by collaborating with support teams such as export control, IP management, quality control and Google/Apple play store teams.• Kept stakeholders updated through release forecasts, product roadmaps, dashboards and sync meetings Show less