G.V.Sai Deepika
Bengaluru
Summary
Dynamic Product Support Technical Advisor with 9 years at IQVIA, excelling in SQL and Power BI. Proven track record in delivering high-quality dashboards and reports, enhancing application performance, and ensuring timely resolution of client issues. Strong analytical skills and a commitment to excellence drive successful outcomes in fast-paced environments.
Overview
5
5
years of professional experience
Work History
Product Sppt Tech Advisor
IQVIA
Bangalore
03.2020 - Current
- 4 years of experience in dashboard developments
- Creating dashboards for claims & tickets data
- Discussing with clients to understand the requirements
- Discussing with database team to understand the data and to check the feasibility for developments and providing the timelines for client as per data
- Querying the database with SQL to understand and analyse the data
- Creating Store Procedures, Functions, Views and CTE in SQL as Per Business Requirement
- Transform data and implement business logic using DAX formulas, ensuring that the data is accurate, clean, and ready for analysis
- Creating relationships between tables in the tabular model to facilitate efficient data querying
- Importing the data from data sources and preparing the data as per user requirement
- Developing visual reports, dashboards and KPI scorecards using Power BI desktop
- Implementing row level security on data and dynamic Row Level Security
- Implementing complex DAX and conditional formatting in Power BI Desktop
- Adding new tables, creating calculated columns, calculated tables and measures for Existing Model
- Prepares Daily, Weekly, and Monthly & Quarterly dashboards
- Experienced in creating different custom visualizations like Bullet Chart, Chiclet slicer, Gauge chart and various default charts like Lines, Pies, Scatter, Tree map, Slicer, Bar chart, Funnel chart etc
- In Power BI
- Creating bookmarks, complex DAX measures, calculated columns and tables to perform business-specific calculations and aggregations
- Creating Run book and publishing the reports to service development environment and creating a deployment pipeline to stage environment and moving the dashboard to stage for testing
- Scheduling the refreshes
- Created Testing Document for Power BI and Backend SQL Server to Validate the Data
- Interact with the Product heads on a regular basis
- Expertise in Power BI desktop, Power Bi Service
- Ensuring timely & quality of delivery by adhering to Quality Process
Product Sppt Tech Advisor
IQVIA
Bangalore
03.2020 - Current
- 5 years of experience in L2 and partial L3 levels of Production Support and application enhancement
- Provided front-end and back-end support to applications
- Proficient in SQL, SQL Server, and Web services/Soap UI
- Created various reports and dashboards in Salesforce based on client requirements
- Subject Matter Expert in Billing Applications, providing END to END support with T2 and T3 levels and experience in Progspex
- Hands-on experience in creating SQL Server database objects such as tables, views, stored procedures, functions, and joins
- Skilled in using DDL, DML, TCL, DQL, and DCL commands on SQL Server 2018
- In-depth knowledge of SQL statements, views, indexes, constraints, sequences, joins, and subqueries
- Strong ability in solution providing and SQL query writing
- Expertise in data migration using SQL
- Loader and bulk inserts
- Thorough understanding of Software Testing Life Cycle (STLC) and Software Development Life Cycle (SDLC)
- Involved in various project phases including development, documentation, and defect fixing
- Processed pharmacy transactions with a customized in-house claims adjudication system
- Experienced in daily and semi-monthly billing activities, generating and inspecting reports before client sharing
- Experienced in creating groups, card IDs, data loads, version updates, and change tickets, and generating reports in the change management tool
- Handled deployments for billing, claims engine, OPUS Portal, MDDB, OpusWebService, OpusHealth, and pharmacy portal applications
- Monitored tickets via Salesforce CSM and ServiceNow, providing SLA to end users/stakeholders and adhering to ITIL concept while maintaining SLAs
- Prepared reports according to business requirements using SQL queries
- Domain knowledge in US Healthcare
- Experienced in application and process monitoring using tools like SQL Developer, SSMS, FileZilla, IQVIA-CSS, OPUS Portal, Billing-Command Console, and Billing-Utility tool
- Provided 24
- 5 system monitoring and support to clients
- Prepared quality documents for various processes
- Quick at grasping new technical and business concepts and applying them as needed
- Regularly attended meetings and interacted with clients/internal stakeholders
- Took ownership of various tasks/processes, ensuring on-time completion
- Proactively monitored and resolved P1 to P4 tickets in the ticketing queue
- Addressed client issues during production via emails or alerts, and managed open and closed tickets by coordination
- Managed day-to-day issues by task allocation, assigning roles, and responsibilities
Education
Bachelor of Technology - Electronics and Communication
Y.S.R Engineering College of Yogi Vemana University
Proddatur, A.P, INDIA01.2017
Skills
- SQL
- Microsoft SQL Server
- Salesforce
- Microsoft Power BI
- Power BI Desktop
- Power BI Services
- OPUS Portal
- NET
Certifications Training
- JAVA and Web technologies (HTML, CSS), JSpiders
- VIMP Leadership and Communication Program
- SQL Essential Training, LinkedIn
- Excel Essential Training, LinkedIn
- Business Collaboration in the Modern Workplace, LinkedIn
- HTML Essential Training, LinkedIn
Soft Skills Strengths
- Willingness to learn
- Flexible to work in all conditions
- Co-operative
- Team player
- Ambitious with high energy levels
- Quick learner with positive attitude
Training
New Inventions in Electronics, at Y.S.R Engineering College of Yogi Vemana University
Disclaimer
I hereby declare that the information provided here is best of my knowledge.
Projects Presentations
- Smart Attendance System by using Face Recognition System with Local Binary Patterns, This system is used to mark attendance automatically by face recognition.
- Poster presentation, Augmentative and Alternative Communication (AAC), organized at JNTUA College of Engineering, Anantapur
- Paper presentation, Implementation of Digital Radar Technology in Intelligent Transport System, at Annamacharya Institute Technology & Sciences, Rajampet
Activities
- Acted as secretary for WECAN association during 4th year B. Tech.
- Singing
- DIY Projects
Timeline
Product Sppt Tech Advisor
IQVIA
03.2020 - Current
Product Sppt Tech Advisor
IQVIA
03.2020 - Current
Bachelor of Technology - Electronics and Communication
Y.S.R Engineering College of Yogi Vemana University
Similar Profiles
Megan MunroeMegan Munroe
Associate Scientist at IQVIAAssociate Scientist at IQVIA
Lokesh ALokesh A
Salesforce Engineer-2 at IQVIASalesforce Engineer-2 at IQVIA
Arvindh GVArvindh GV
Applications/Software Developer II at IQVIAApplications/Software Developer II at IQVIA