Meghana A

• Working as Senior Database developer, Good knowledge in MS-SQL programming, PostgresSQL, MONGO DB
• Good work experience on Creation of Sub Queries, Joins, Stored Procedures, Views, Functions, Cursors, Triggers, Index, XML and CTE
• Good work experience in Query optimization and Resolving performance issues of the queries
• Involved in error debugging in applications via SQL Profiler,Execution Plan,Pg_Stat_Statements
• Involved in creation SQL job, Data Processing, and delta changes activity
• Experience in Aggregation,Sharding,Clustering in MongoDBAtlas,Shell and MongoDB Compass
• Database migration From one SQL Environment to another by Using Azure and AWS DMS
• Project 1: QMS (Queue Management System)

This project is a DB oriented project designed DB and all logic has written in Database. And Product developed for one of the Temple. A queue management system (QMS) is a tool that helps manage the flow of customers and their experience while waiting for service. QMS can help improve customer experience and efficiency by: Reducing wait times: QMS can help reduce wait times by organizing and prioritizing queues. Improving customer satisfaction: QMS can help improve customer satisfaction by providing real-time information about wait times and service availability.

• Project 2 : ParkZeus (Domain : Parking Domain)

ParkZeus is a parking platform from Bosch that helps make parking smarter for both parking providers and seekers. It offers a range of features, including: Customization ParkZeus offers multiple customization options to help you create parking solutions that meet your specific needs. ParkZeus provides access to the Bosch ecosystem. Automated parking assistance:Developed automated parking assistance systems that can help vehicles enter and exit parking spaces without driver input. Smart parking system: Bosch's smart parking system uses lidar sensors to scan the area around the vehicle and issue driving commands. The system is designed to react faster than a human and stop the vehicle if it detects an obstacle or fault.

• Project 3 :Mobility Cloud Platform(MCP)(Domain:Billing)

MCP is a launchpad and ecosystem for developing, implementing and scaling IoT enabled digital products for new age connected solutions with the help of our scalable high-performance multi-tenant architecture, re-usable technology stacks, support for a wide range of devices and complete operational support with required tool chains. With MCP, Bosch wants to enable digital transformation at startups and corporates alike.Infrastructure Services,Mobility Software Services,Peripheral Services,etc.,

• Worked 3 years as SQL Developer and strengths in SQL Development, Report Designing, Data Integration and Business Intelligence solutions using SQL Server, IRT software and MySQL
• Other strengths include deep analytical and technical aptitude, coding skills, client services skills, and the ability to solve business problems
• Projects: Astellas/AbbVie/Merk-EMD Sereno/Oncology/NGM Pharma/Trillium
• The objective is to provide clinical supply chain intelligence and clinical operations knowledge management Through Interactive Response Technology (IRT), with a focus on patient randomization and trial supply management
• Tools and technology used: IRT software, SQL Server, MY SQL, Spira, ASP, VB.net, JIRA, QCTMS
• Responsibilities: Working on projects related to clinical trials in medical industry Projects to be delivered in short timeline and high quality
• Worked in more than 30+ projects of same category and currently working Sub Queries, Joins, Stored Procedures, Views, Functions, Cursors, Triggers, Index, CTE and SQL Query optimization
• Customizing BO and Crystal reports as per client request
• Presentation of Study request change to management
• Verifying user request specifications and helping project management team to prepare URS and SRS
• Domain: Health Care (Clinical Trial) Queue management system
• Developed scalable and maintainable code, ensuring long-term stability of the software.