Jannu Jyothi

Tools: Power Apps (Canvas + Model-Driven Hybrid), Power BI, Dynamics 365, Excel

Objective: To provide a real-time solution for sales managers to track leads, opportunities, and pipeline performance.

Responsibilities:

• Built a hybrid Power App integrating Canvas UI with Model-Driven logic tied to Dynamics 365 Sales.

• Developed real-time dashboards in Power BI using Power BI Embedded inside the app.

• Enabled mobile data capture with offline sync for field reps.

• Configured cascading dropdowns, lookup fields, and conditional formatting using Power Fx.

• Built Power Automate flows to assign leads based on region, industry, and performance.

Tools: Power Apps (Model-Driven), Power Automate, SharePoint Online, OneDrive

Objective: To create a centralized platform for managing audits, tracking compliance violations, and automating follow-up actions.

Responsibilities:

• Designed a Model-Driven app for audit scheduling, issue logging, CAPA (Corrective & Preventive Actions), and status updates.

• Linked SharePoint for document management and OneDrive for internal file sharing.

• Used Power Automate for notification triggers, escalation workflows, and report generation.

• Implemented dynamic views, filters, and charts based on audit type, severity, and status.

• Ensured regulatory compliance with electronic signature and approval logs.

Tools: Power Apps (Model-Driven), Dataverse, Power Automate, SharePoint, Outlook

Objective: To digitize and automate the manual expense reimbursement process used by 1000+ employees across departments.

Responsibilities:

• Developed a Model-Driven App with custom tables in Dataverse to manage expense claims, approvals, and audit logs.

• Designed a multi-tier approval process with custom logic for department heads, finance controllers, and compliance teams.

• Integrated Outlook for email alerts and Teams for task approvals via adaptive cards.

• Created Power Automate flows for real-time notifications, SLA tracking, and reminders.

• Built an Admin panel to manage reimbursement policies, limits, and approver mappings.

Tools: Power Apps (Canvas), Power Automate, SQL Server, Power BI, Azure AD

Objective: To replace the legacy desktop-based asset tracking system with a cloud-based, mobile-friendly Power Apps solution for tracking machinery, tools, and equipment across 30+ locations globally.

Responsibilities:

• Designed a responsive Canvas App used by 500+ field engineers and inventory managers.

• Integrated with SQL Server for live inventory data and asset status.

• Created multi-stage approval flows using Power Automate for asset allocation, maintenance, and disposal.

• Implemented role-based security using Azure AD and conditional UI visibility.

• Developed custom logic using Power Fx to dynamically filter and validate asset data.

• Deployed Power BI dashboards to track asset lifespan, location history, and utilization rate.

Tools: Power Apps (Canvas + Model-Driven Hybrid), Power BI, Dynamics 365, Excel

Objective: To provide a real-time solution for sales managers to track leads, opportunities, and pipeline performance.

Responsibilities:

• Built a hybrid Power App integrating Canvas UI with Model-Driven logic tied to Dynamics 365 Sales.

• Developed real-time dashboards in Power BI using Power BI Embedded inside the app.

• Enabled mobile data capture with offline sync for field reps.

• Configured cascading dropdowns, lookup fields, and conditional formatting using Power Fx.

• Built Power Automate flows to assign leads based on region, industry, and performance.

Tools: Excel VBA, PivotTables, Charts

Objective: To automate daily, weekly, and monthly sales reports for the regional sales team using Excel VBA.

Highlights:

• Created macros to pull data from multiple sheets and consolidate sales data into a summary dashboard.

• Used VBA to auto-refresh PivotTables, generate PDF reports, and email to stakeholders.

• Enabled one-click report generation, reducing manual effort by over 90%.

Tools: Excel VBA, Outlook Integration

Objective: To streamline invoice creation, sending, and tracking for a finance team.

Highlights:

• Developed a form-based interface for entering invoice data, automatically saved and stored in Excel.

• Created VBA scripts to email invoices via Outlook and log sent status with timestamps.

• Improved invoice dispatch accuracy and maintained a searchable digital log of all transactions.

Tools: Excel VBA, Data Validation, Regex

Objective: To ensure data quality in large datasets received from external vendors.

Highlights:

• Implemented VBA routines for bulk data validation including phone numbers, dates, and IDs.

• Flagged duplicates, missing values, and outliers with detailed summary reports.

• Reduced manual QA review time by 75% and improved data reliability.