Lawrence Grimes
Pune
Summary
Experienced Data Engineer with 4 years of expertise in PL/SQL, Tableau, Power BI, and SQL Server 2019. Proven track record of designing and implementing efficient and scalable database solutions that optimize business processes, enhance data accessibility, and drive profitability.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Software Engineer
Globant
05.2024 - Current
- Company Overview: Partnered with colleges and nonprofit organizations for nearly 50 years to enhance student enrolment, retention, and donor engagement
- Focused on helping institutions succeed through expert-led strategies that drive student success and long-term donor relationships
- Developed and optimized complex stored procedures, functions, and views to manage and retrieve data, improving client profitability by 15% and streamlining stakeholder engagement
- Wrote advanced SQL queries in SSMS to conduct detailed data analysis, resulting in 30% more efficient daily operations for client teams
- Maintained and debugged Azure Databricks notebooks, resolving critical code issues
- Automated jobs and data pipelines using ADF, reducing manual data handling time by 25% and ensuring consistent data flow
- Managed data migration from Azure Blob Storage to Power Apps
- Leveraged Power Apps and Power Automate to streamline data manipulation and transfers to Synapse, improving data insight delivery to business teams by 40%
- Partnered with colleges and nonprofit organizations for nearly 50 years to enhance student enrolment, retention, and donor engagement
- Focused on helping institutions succeed through expert-led strategies that drive student success and long-term donor relationships
Junior Software Engineer
mPHatek Systems Pvt. Ltd
04.2022 - 04.2024
- Company Overview: Bajaj Finserv Limited is a one of the leading non-banking financial companies (NBFCs) of India with a customer base of 83.64 million, we handled the primary data from the customers which was flown from the oracle database to the EDW (enterprise data warehouse) on a daily basis with the help of procedures and jobs which were run, developed and maintained by us on a daily basis
- Developed and maintained complex SQL queries, stored procedures, functions, triggers, views, cursors & sequences to extract and manipulate data for various applications
- Analysed and optimized database performance to ensure data integrity and system efficiency
- Collaborated with cross-functional teams to gather requirements and deliver database solutions that meet business
- Using Toad(tool) to monitor and resolve the Database issues monitor and improve the efficiency
- Created and shared real-time dashboards using Power BI to provide insights on key performance indicators
- Implemented ETL pipelines resulting in a 20% reduction in data processing time, optimizing performance and reliability
- Successfully handled and resolved IT requests on a daily basis, ensuring timely resolution and customer satisfaction
- Developed visually compelling reports and interactive dashboards using Power BI Desktop
- Designed and implemented data models in Power BI, including establishing relationships between tables, creating calculated columns, measures, and tables using DAX
- Conducted in-depth data analysis and exploration to identify trends, patterns, and actionable insights, leveraging Power BI's analytical capabilities
- Documented data sources, data models, calculations, and development processes to ensure transparency, reproducibility, and maintainability of Power BI solutions
- Bajaj Finserv Limited is a one of the leading non-banking financial companies (NBFCs) of India with a customer base of 83.64 million, we handled the primary data from the customers which was flown from the oracle database to the EDW (enterprise data warehouse) on a daily basis with the help of procedures and jobs which were run, developed and maintained by us on a daily basis
Analyst
Fresh Gravity
11.2020 - 04.2022
- Utilized advanced SQL functionalities such as joins, windows functions, and case statements to efficiently handle data transformation tasks
- Processed and retrieved required data for cross-functional teams, improving data processing time by 15%
- Assisted in data entry, preparing data for efficient loading into databases, ensuring 100% accuracy in data entry tasks
Education
Masters - Business Intelligence, SQL, Tableau, Power BI
ITprenuer
BSC - Aircraft Maintenance Engineering
Singhania University
Skills
- SQL Server
- Oracle PL/SQL
- Azure SQL
- Database scripting
- Data Modeling
- Performance Tuning
- Database Design
- Data Migration
- Database Optimization
- Azure Databricks
- Azure Data Factory
- Power BI
- Tableau
- Power Apps
Certification
- Business Intelligence using Power BI
- Data visualization with Power BI certificate
- Informatica Master Data Management Concepts
- Informatica Cloud
- Data Engineering Foundation Certification
Projects
Hospital Management System, Developed a comprehensive Hospital Management System database, optimizing data organization for doctors, patients, and departments., Utilized Tableau to design visualizations that provided actionable insights on medicine costs, team leads' success ratios, and patient summaries, enhancing decision-making., Applied best practices in data modeling and database design, improving system performance by 30%., Collaborated with system administrators to ensure system availability and reliability, maintaining 99.9% uptime., Contributed to clear documentation of database architecture and processes, improving knowledge sharing and future system scalability., Successfully presented project findings to stakeholders, receiving positive feedback for clarity and impact.
References
Available upon request
Languages
English
First Language
Hindi
Intermediate (B1)
B1
Timeline
Software Engineer
Globant
05.2024 - Current
Junior Software Engineer
mPHatek Systems Pvt. Ltd
04.2022 - 04.2024
Analyst
Fresh Gravity
11.2020 - 04.2022
Masters - Business Intelligence, SQL, Tableau, Power BI
ITprenuer
BSC - Aircraft Maintenance Engineering
Singhania University
Similar Profiles
Ashish GuptaAshish Gupta
Project Delivery Manager at GLOBANTProject Delivery Manager at GLOBANT
Andres NikolicAndres Nikolic
Quality Engineer at GlobantQuality Engineer at Globant
Ganesh ChimteGanesh Chimte
Technical Architect at GlobantTechnical Architect at Globant