Supply Chain Software Developer
Resume:
MARUTI GAWALI
***************@*****.***
WORK EXPERIENCES
Xcaliber Infotech Pvt. Ltd. Pune May/2023 - Present. Software Developer (SQL)
Project 1) Midas Integration Module (Reverse Logistic and Supply Chain)
Summary : This project involves a reverse logistics supply chain for gadgets such as mobile phones and gateways (routers) returned by clients' end customers or vendors. The return process flow differs for mobiles and gateways. Each returned device undergoes several stages, including visual inspection, factory reset, necessary repairs (if required), quality checks, and finally, preparation for resale. Project 2) Encore (Data Migration)
Performed data migration and developed data pipelines from NoSQL to SQL and SQL to SQL systems.
• Skilled in creating database objects such as Tables, Functions, Stored Procedures, Views, and Triggers in PostgreSQL using PL/pgSQL.
• Worked on extension and foreign tables, along with cross-database queries, to integrate external and internal data sources for reporting and analytics.
• Proficient in writing and optimizing stored procedures in MS SQL Server.
• Developed SQL Server stored procedures and triggers to calculate analytical data based on client requirements.
• Skilled in SDLC, RDBMS, DBMS, analysis, design, development, and support of applications.
• Capable of adapting to and learning new and emerging technologies quickly.
• Communicated with onshore Business Analysts and clients to identify production issues, and addressed and resolved them within the current sprint.
• Strong ability to work effectively both independently and within a team environment.
• Possess good work ethics along with excellent communication and interpersonal skills
• Experience with SQL Server, ETL, SSIS, and JIRA.
• Connected to SQL Server databases using connection strings for seamless data access.
• Experience in designing ER diagrams using tools like Lucid chart.
• Solid understanding of the ETL process and data integration workflows.
• Strong grasp of normalization concepts and best practices in database design.
• Knowledge of data warehousing and DWH concepts including OLAP, OLTP, Star Schema, Snowflake Schema, and Galaxy Schema.
• Results-driven team player with strong problem-solving skills, capable of working under tight deadlines in a target-oriented environment.
• Self-motivated, proactive, and a quick learner of new concepts and technologies.
• Developed SQL scripts to transfer, validate, and optimize large datasets across multiple systems.
• Designed and developed ETL packages to transfer data from MySQL to PostgreSQL, ensuring data accuracy, consistency, and performance optimization.
• Basic knowledge of Snowflake, data warehousing concepts; earned Snowflake Hands-on Essentials and Snow Convert Developer badges.
JOB OBJECTIVE
To achieve a challenging position in
Software Development in a result-
oriented company, where acquired skills
and education will be utilized towards
continuous growth and advancement.
Looking for a Software Developer (SQL)
Job where I can utilize my skills.
EDUCATION
2023: Post Graduate Diploma in
Advanced Computing, CDAC, PUNE
2020: Master of Science
2018: Bachelor of Science
TECHNICAL SKILLS
SQL PostgreSQL SQL Server T-SQL
PLPGSQL pgAdmin4 SSMS Dbeaver
Oracle SQL Developer SQL Server
2016/2019 Oracle PL/SQL Snowflake
JIRA YouTrack GIT VSCode Visual
Studio 2019 Python (Basics) Core Java
SSIS.
SOFT SKILLS
• Cross-Functional Communication
• Problem-Solving & Adaptability
• Ownership & Accountability
• Time Management & Organization
PERSONAL DETAILS
• Languages: English, Hindi & Marathi
• Address: Pune
Contact this candidate