Pankaja Rilkar

Experience

• 

  Sharekhan

  Jun 2017 - Dec 2017

  Intern

  Outlook Mail ID Management: Created and deleted Outlook mail IDs for Head Office (HO), branch offices, business partners. Application Installation & Configuration: Installed and configured Share khan's in-house applications through remote tools. Onsite Engineer Allocation: Assigned onsite engineers based on user requirements for efficient task execution. Remote Server Management: Performed server resets and configurations for Share khan branches and business partners via remote applications. Show less

• 

  Shivaami Cloud Services Pvt. Ltd. Your Cloud Services Brokers

  Jan 2021 - Oct 2021

  Software Developer

  Customer Portal and Dashboard Development: Created customer portals, HTML page views, and interactive dashboards, enhancing user experience and enabling data-driven decision-making. Developed reports and embedded forms, reports, and pages to improve functionality and accessibility. Email and SMS Campaigns: Managed and executed email and SMS campaigns, improving customer engagement and communication efforts. Data Integration with Zoho Analytics: Utilized SQL queries to fetch data from various applications and create tables in Zoho Analytics, ensuring accurate reporting and insights. Full Project Lifecycle Management: Took full responsibility for the entire project lifecycle, including designing, developing, testing, deploying, and maintaining solutions to meet client needs. Business Process Automation: Leveraged Zoho modules (CRM, Desk, SalesIQ, Projects, Analytics) to automate a range of business processes, enhancing efficiency and reducing manual effort. App Development with Zoho Creator and Google App sheet: Developed custom applications (e.g., ERP management, Investment Management, CRM, IT Ticketing, Subscription sManagement) using Zoho Creator and Appsheet to address various client’s needs and requirement Data Migration and Integration: Successfully fetched and migrated data using REST APIs and OAuth tokens, ensuring seamless data integration and transfer between systems. Show less

• 

  Infowave Systems, Inc

  Oct 2021 - Mar 2022

  Jr. MSBI Developer

  -Automated Report Generation: Reduced the time spent on manual report generation by automating recurring reports through SSRS subscriptions, improving efficiency and accuracy. -Streamlined Data Extraction: Streamlined data extraction from various sources—including relational databases, flat files, and APIs—using SSIS packages, enabling faster and more reliable data integration. -Thorough Documentation: Maintained comprehensive documentation of all developed solutions, ensuring ease of reference and a seamless process for future updates or modifications. -Database Performance Optimization: Optimized database performance by creating efficient T-SQL queries, stored procedures, and triggers, resulting in faster query execution and enhanced system performance. -Support for Decision-Making: Supported business decision-making by designing and developing interactive dashboards and visualizations in Power BI, providing actionable insights to key stakeholders. Show less

• 

  Paramatrix Technologies Pvt Ltd.

  Mar 2022 - now

  Designed and Developed Robust BI Solutions: Efficiently designed and developed solutions to meet client requirements for functionality, scalability, and performance. Data Integration and ETL Development: Designed and implemented data models, ETL processes, and data integration workflows using Microsoft SQL Server Integration Services (SSIS). Migration Expertise: Successfully migrated all Microsoft Business Intelligence (MSBI) tools from SQL Server 2012 to SQL Server 2022, ensuring a smooth transition with minimal disruption. Full Project Lifecycle Management: Took full responsibility for all project phases, including planning, design, development, testing, deployment, and ongoing maintenance. Report and Dashboard Development: Designed and developed interactive reports, dashboards, and visualizations using Microsoft SQL Server Reporting Services (SSRS) and Power BI, Tableau providing actionable insights for business stakeholders. Performance Monitoring and Optimization: Monitored and troubleshot BI solutions, identified performance bottlenecks, and optimized query performance to ensure high efficiency. Documentation and Technical Support: Documented technical specifications, system configurations, and user guides for BI solutions to ensure clarity and support for end-users. Show less

  • Software Engineer

    Mar 2022 - now

  • Assistant Software Engineer

    Mar 2022 - Nov 2024