Pankaja Rilkar
Software Engineer
Bhandup(W)
Summary
Individual with ability to follow established procedures and work under little or no supervision. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
3
3
years of professional experience
4
4
Certifications
Work History
Software Engineer - MSBI
Paramatrix Technologies PVT LTD
3 2022 - Current
- Worked efficiently to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.
- Designed and developed data models, ETL processes, and data integration workflows using Microsoft SQL Server
Integration Services (SSIS). - Successfully Migrated all MSBI tools from SQL server 2012 to 2022
- Taking responsibility for the full life cycle of the projects: Planning,Designing, Development, Testing, Deployment and Maintenance.
- Designed and build reports, dashboards, and visualizations using Microsoft SQL Server Reporting Services(SSRS) and Power BI.
- Monitored and troubleshoot BI solutions, identify performance bottlenecks, and optimize query performance.
- Document technical specifications, system configurations, and user guides for BI solutions.
MSBI Developer
Infowave systems, Inc
10.2021 - 03.2022
- Reduced time spent on manual report generation by automating recurring reports with SSRS subscriptions.
- Streamlined data extraction from various sources, including relational databases, flat files, and APIs, using SSIS packages.
- Maintained thorough documentation of all developed solutions for easy reference during future updates or modifications.
- Optimized database performance through the creation of efficient T-SQL queries, stored procedures, and triggers.
- Supported business decision-making by creating interactive dashboards for data visualization in Power BI.
Software/Zoho Developer
Shivaami Cloud services Pvt Ltd
1 2021 - 9 2021
- Created customer portals, HTML page views, creating dashboards, creating reports, embedding forms/reports/pages, email, SMS campaigns.
- Used SQL queries to fetch data from different apps and create tables in Zoho Analytics.
- Taking responsibility for the full life cycle of the projects: Designing, Development, Testing, Deployment and Maintenance.
- Effectively utilized modules features to automate various business processes. CRM, Desk, SalesIQ,Projects, Analytics
- Created apps using Zoho Creator and Appsheet (e.g., ERP management, Investment Management, CRM application, IT Ticketing, Subscription Management) for various clients
- Fetched and migrated Data using REST API’s and oauthtokens.
Education
Bachelor of Engineering - Computer Engineering
Lokmanya Tilak College of Engineering
Navi MumbaiSkills And Tools
- Languages – SQL,PL SQL,Deluge,Java,C#,Python
- Analytical Tools -SSAS,Tableau, Power BI, Google Data Studio
- Methodologies - Data Warehouse, ETL, Data Quality, Data Modelling, Data Visualization.
- Platforms/ Tools - Microsoft SQL Server Management (SSMS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), MS office,Visual studio code, Microsoft Excel, Jupyter Notebook, Atom, Zoho CRM,Zoho books, Zoho Creator, Zoho Desk, Zoho Mail, Zoho campaign, G-suite, Appsheet.
- Systems -Windows, Linux, Ubuntu
Project Portfolio
- Student tutorial, Final year Diploma project, NetBeans, SQL, php, HTML
- IOT based Electricity controlling and management System, Final year Degree project, Arduino, blynk, firebase, fritzing, Arduino uno, Node mcu, Current sensor, Display, load
- CRM and IT ticketing Application, Appsheet, google sheet, Appscript, SQL
- ERP Management and Investor Management, Zoho Creator, Deluge, HTML, Java Script
- Interactive Resume, Tableau, https://public.tableau.com/app/profile/pankaja.rilkar/viz/Book2_16239189023330/Resume
Certification
Python for beginners - Udemy
Timeline
MSBI Developer
Infowave systems, Inc
10.2021 - 03.2022
Software Engineer - MSBI
Paramatrix Technologies PVT LTD
3 2022 - Current
Software/Zoho Developer
Shivaami Cloud services Pvt Ltd
1 2021 - 9 2021
Bachelor of Engineering - Computer Engineering
Lokmanya Tilak College of Engineering
Similar Profiles
DIPESH INGLEDIPESH INGLE
Systems/Network Engineer (DevOps Focus) at Paramatrix Technologies PvtSystems/Network Engineer (DevOps Focus) at Paramatrix Technologies Pvt
DIPESH INGLEDIPESH INGLE
Systems/DevOps Engineer at Slashrtc Software Services PVT LTDSystems/DevOps Engineer at Slashrtc Software Services PVT LTD
Naval GogateNaval Gogate
Quality Assurance Officer at CITI Corporate Services Pvt LtdQuality Assurance Officer at CITI Corporate Services Pvt Ltd
Sophia AyoubdelSophia Ayoubdel
Babysitter at Self EmployedBabysitter at Self Employed
Pratik KadamPratik Kadam
Kitchen Supervisor at The Food TownKitchen Supervisor at The Food Town