Raman Sharma
Data Modeler
Delhi
Summary
A versatile and accomplished Data Modeler and ETL Specialist, I have a strong track record of success in designing and implementing data solutions across various industries. My expertise includes creating ER diagrams, developing customized data models, and orchestrating ETL processes, supported by a deep proficiency in SQL, Python, and data modeling methodologies. With experience in data visualization tools such as Power BI and Tibco Spotfire, coupled with project management skills, I bring a holistic approach to data-driven decision-making. My financial acumen, automation capabilities, and commitment to excellence make me a valuable addition to any team seeking to harness the power of data for strategic advantage.
Overview
5
5
years of professional experience
8
8
years of post-secondary education
4
4
Certifications
Work History
Data Modeler
Aventior Digital Private Company
Pune
03.2022 - Current
- Identified and described relationships between data fields in enterprise databases.
- Progressed and maintained official description of enterprise datasets.
- Created ER diagrams for various industries, including Life Sciences, Drug Manufacturing, Advertising, and AI platforms, collaborating with clients like KSQ Thorin, Acuitas, Giddyup, 2seventyBio, Crio, etc.
- Developed data models tailored to client needs, securing client approval for model designs.
- Designed and implemented databases and ETL (Extract, Transform, Load) jobs to extract data from diverse sources, such as AWS S3 buckets, Google Buckets, and other data repositories.
- Conducted recurring Data Wrangling activities on the Google Cloud Platform Data prep, including data cleansing, transformation, manipulation, and duplication reduction.
- Demonstrated proficiency in Linux scripting for tasks such as file downloading, copying, and moving within Google Buckets/Local Directories.
- Utilized data modeling methodologies to create Snowflake and Star schemas based on client data requirements.
- Possessed expertise in SQL, Python, ETL job development, and robust data modeling methodologies.
- Worked with various SQL databases, including SQL Workbench, PostgreSQL, MS SQL, MySQL, etc., to meet client needs.
- Developed ETL jobs using Python scripts in environments such as Jupyter notebooks and Visual Studio.
- Employed ER diagram tools like Lucid Chart, SQL Workbench, Erwin, and ER Studio for effective data modeling.
- Utilized Tibco Spotfire and Power BI for data visualization to provide actionable insights to clients.
- Contributed to the CPV NXG project, developing an Automated Visualization-based Website to generate client visualizations with a single click.
- Leveraged Azure Data Factory and Azure Databricks for efficient handling of SQL databases as part of project work.
Senior Account Receivable Analyst
Jones Lang Lasalle Pty Ltd
Gurgaon
04.2021 - 01.2022
- Developed visually appealing dashboards and presentations using Power BI to showcase progress in the Unallocated Report.
- Conducted accounts reconciliation, identifying and rectifying discrepancies in financial records.
- Generated reports comparing Total Customers vs. Paid Amount and Outstanding Amount to assess the effectiveness of the Dunning process.
- Identified, recommended and executed opportunities to enhance accounts receivable and billing processes to meet finance requirements.
- Utilized SQL databases to extract data directly from client servers, streamlining data retrieval processes.
- Automated reconciliation tasks through various lookups and joins via SQL Workbench, improving efficiency and accuracy in financial operations.
- Automated reconciliation processes, leading to a save time in joining the multiple data files from multiple data sources which increases operational efficiency.
Accounts Receivable Specialist
Jones Lang Lasalle Pty Ltd
Gurgaon
11.2019 - 04.2021
- Managed Cash Application process, ensuring accurate and timely recording of incoming payments.
- Created and maintained the Unallocated Report, meticulously tracking unidentified or misapplied payments.
- Sent dunning reminders to customers for outstanding invoices, demonstrating proactive communication skills.
- Developed visually appealing dashboards and presentations using Power BI to showcase progress in the Unallocated Report.
- Conducted accounts reconciliation, identifying and rectifying discrepancies in financial records.
- Successfully resolved discrepancies in the Unallocated Report, reducing outstanding balances by [mention a specific amount].
- Enhanced customer engagement through timely dunning reminders.
- Provided actionable insights through Power BI dashboards, facilitating data-driven decision-making.
- Ensured accurate financial statements through rigorous accounts reconciliation, contributing to financial stability.
Apprenticeship Trainee
Genpact Private Limited, Gurgaon
Gurgaon
11.2018 - 11.2019
- Successfully completed a comprehensive apprenticeship program at Genpact Private Limited, gaining hands-on experience and expertise in various key areas.
- Developed proficiency in reporting and data visualization using industry-standard tools such as Power BI and Tableau. Utilized these skills to create interactive and insightful reports for data-driven decision-making.
- Participated in Personality Development Training sessions, enhancing communication skills, self-confidence, and leadership abilities. Demonstrated improved interpersonal skills in a professional setting.
- Acquired a strong command of Microsoft Office Suite, from basic to advanced levels, including Word, Excel, PowerPoint, and Outlook. Utilized these tools to streamline tasks, improve productivity, and create professional documents and presentations.
- Demonstrated the ability to create effective presentations by applying acquired knowledge and skills. Presented ideas and findings to internal teams and clients, effectively communicating complex information in a clear and engaging manner.
- Received Project Management Training, equipping me with the knowledge and techniques required to plan, execute, and monitor projects effectively. Successfully contributed to project teams, ensuring the timely completion of tasks and project milestones.
- Gained a solid understanding of the Accounts Payable and Receivable process, including financial data analysis and reconciliation. Contributed to financial accuracy and efficiency by participating in accounting-related tasks.
- Overall, my apprenticeship at Genpact Private Limited allowed me to acquire a diverse set of skills and practical experience in areas ranging from data analytics and project management to personal development and finance. These skills have enhanced my versatility and readiness to contribute effectively in various professional settings.
Education
Data Science
DV Analytics
Bangalore 04.2021 - 02.2023
Banking and Finance, Banking and Finance
Symbiosis Center of Distance Learning
Pune, MH 04.2020 - 04.2022
B.Com - Commerce
Delhi University- School of Open Learning
New, Delhi 10.2014 - 11.2018
Skills
Python
Azure Synapse Analytics
Tibco Spotfire
Power BI
TableauAlteryx Designer
Microsoft ExcelErwin
ER studio
Lucid Chart
Azure DataBrick
GCP DataBrick
Business Intelligence
Prompt Engineering (OpenAI)
Accomplishments
- Data Warehouse- Data lake
- Excellent
- Additional Information
- Having explosure in creating ER model in LucidCharts, SQL
- Benchmark
- I worked with various databases- MS SQL, PostgreSQL
- I worked with Jupiter Notebook for Data Analysis via Python
- In terms of ETL Tool- Having an exposure with Alteryx Designer and CPV Auto/Drip
Certification
Advance Microsoft Excel
Timeline
Data Modeler
Aventior Digital Private Company
03.2022 - Current
Industrial Data Science
02-2022
Senior Account Receivable Analyst
Jones Lang Lasalle Pty Ltd
04.2021 - 01.2022
Data Science
DV Analytics
04.2021 - 02.2023
PowerBI- Dashboard Basic to Intermediate
12-2020
Banking and Finance, Banking and Finance
Symbiosis Center of Distance Learning
04.2020 - 04.2022
Accounts Receivable Specialist
Jones Lang Lasalle Pty Ltd
11.2019 - 04.2021
Personality Development
07-2019
Apprenticeship Trainee
Genpact Private Limited, Gurgaon
11.2018 - 11.2019
Advance Microsoft Excel
11-2018
B.Com - Commerce
Delhi University- School of Open Learning
10.2014 - 11.2018