Prajakta Mane

Prajakta Mane - Professional Summary: Data entry expert and SQL development professional with strong verbal and written communication skills for writing relational database solutions for businesses. Good knowledge of SQL Server, MYSQL workbench, PGAdmin, SQL Server Integration Services, MSBI. Good understanding of Data warehouse concepts, ETL tools, Reporting tools Strong experience in MySQL and SQL Server. Skills Profile: Reporting tools Database ETL Tool Scripting/Programming Operating System Power Bi SQL Server, MySQL 8.0, SQLite SSIS SQL, PostgreSQL, HTML, CSS Windows, Ubuntu Professional Experience: Organization: Xpanxion (Client company) Duration: Dec 2020 to till now Project: Certona Client: KIBO Role: Backend Engineer Overview:The client KIBO provides cloud ecommerce solutions. Certona is basically a software and services include eCommerce, Order Management, manufacturers, and brands. It is basically a recommendation engine which recommends product. We were basically setting up different clients implementations like Adidas, Uniqlo and many more. Basically as input we were getting XML or JSON file so we were extracting that file and we were loading that product data in SQL server using SQL or SSIS and daily jobs were getting run and data was refreshing daily. Responsibilities: Creating a stored procedures to extract XML or JSON file into our SQL database. Extracting XML or JSON file into our SQL database using SSIS. Creating complex stored procedures to transform that data and store it into proper format. Creating XSLT files for performing XSLT transformation to show recommendations on website. Handling the Certona Experience Manager Activities. Creation and scheduling of SQL agent jobs. Performed unit tests on all code and all packages. Environment SQL Server, SSIS Organization: Xpanxion Duration: Sep 2020 to Nov 2020 Project: Order Manangement System Client: KIBO Role: Backend Engineer Overview:OMS that is Order Management System is basically project under client KIBO. OMS contains all the order related information OMS manages different client s data. They have all manufacturers, retailers, and fulfiller s information and also they have all the information regarding an each order that is placed on their site. The OMS manages orders effectively, the selection of the best fulfillment center for each order, providing of insights to help retailers keep fulfilment costs down, and the delivery of the best possible customer experience. We basically managing all the order related information through their OMS Admin site. Responsibilities: Handling all the activities related OMS Admin. Building MYSQL queries for creating sales report. Creating complex MYSQL stored procedures. Changing HTML templates like packing templates or contact us template. Refreshing any client site. Handling issues related to each order that is placed. Handling API calls using POSTMAN. Creating API keys. Checking logs in KIBANA. Environment Windows, MySQL workbench Organization: Ellicium Solutions Private Ltd. Client: OSI Soft Duration: Dec 2019 to Aug 2020 Role: ETL Developer, Tester, Power BI developer Project: Reporting Data Mart Overview The Client, OSI Soft is a leading IoT Company for operational Intelligence. The client wanted to create a data mart to maintain Master data for their customer as well as all sales information. We were extracting Customer data and sales information from various sources like salesforce, SAP etc. using SSIS ETL and are creating reports on top of that data using Power BI. Responsibilities: Designing data warehouse and all related extraction, transformation and load of data functions. Analysing data for source/target mappings, created scripts for data processing and automations. SQL server database modelling, design and development with complex sql scripts, stored procedure, views, defined functions, cursors. Designed and developed ETL packages using SQL Server Integration Services (SSIS) to import and export data from various sources such as MS Excel, SQL server, flat files. Designed PowerBI dashboards utilizing maps, scatter plots, pie charts, bar charts etc. Environment Windows, SQL server, SSIS, PowerBI Organization: Ellicium Solutions Private Ltd. Duration: Sep 2019 to Nov 2019 Project: Sales and Marketing Dashboard Overview: Northwind is a global sales company dealing in cycles and offices in various cities across the world. Their reporting mechanism for production planning and control, inventory management, sales and marketing is done through Excel spreadsheets. This system was manual, therefore error-prone and also time-consuming. Their management wanted a reporting dashboard for the company s inventory system. They were having identified the KPIs that will be displayed via the dashboard to the executive team anytime, anywhere. Responsibilities: Designed data warehouse and all related extraction, transformation and load of data functions. Developed SSIS packages to load data from various sources from Excel, MySQL,SQLite . Designed and developed a dashboard using PowerBI. Environment Windows, MySQL, SSIS, PowerBI POC s worked on Document Manager Application, Initial load stored procedure, Corona dashboard Education:- BE from Pune Vidyarthi Griha's College of Engineering, Savitribai Phule Pune University