Sshalini Pattanaik

Senior Developer Responsibilities :

• Led a project aimed at providing data-driven analytical solutions using specialty pharmacy data for sales and marketing teams. Transformed the data and produced reports using the Power BI platform. Optimized dashboards with a focus on usability and performance.
• Acquired substantial domain knowledge through interactions with Product Owners and worked as Business Analyst, contributing to the successful delivery of an impactful analytic solution.
• Developed over 20 reports and dashboards, resulting in a 30% increase in operational efficiency.
• Collaborated with cross-functional teams to identify data sources and streamline data collection, resulting in a 25% reduction in report development time.
• Improved dashboard usability by implementing interactive visualizations, resulting in a 20% increase in user engagement.
• Implemented RLS (Row Level Security) for the reports.
• Developed automated workflows to seamlessly trigger Power BI dataset refreshes, enhancing data currency and ensuring timely availability of insights for stakeholders.
• Contributed to the development of new stored procedures, while optimizing and enhancing existing queries and stored procedures to improve database performance and efficiency.
• Implemented the important features: Integration of ChatGPT and CoPilot, and Automatic alert based on predefined threshold with Power Automate.
• Played a key role in skill development within the team, mentoring junior members to identify and address critical issues, and fostering a collaborative and growth-oriented work environment.
• Thoroughly documented application artifacts in enterprise tools (e.g., ) - Confluence, aiding knowledge transfer and troubleshooting.

Team Lead Responsibilities:

• Data Quality Management: Developed effective data quality management solutions by building algorithms and deploying machine learning models to detect outliers in the data and alert end users.
• Data Integration & Transformation: Worked on data integration and transformation to create a web-based platform for visualizing patient specialty services data and detecting trends.
• Advanced Data Analysis: Designed advanced data analysis solutions and developed dashboards per client requirements, producing business acceleration KPIs for senior management.
• Process Automation: Provided solutions in process automation to track all stages of the patient journey, including benefit verification, appeal, prior authorization, and drug dispensing.
• Development Support: Supported both existing and new development projects, optimizing applications, and addressing new requirements at the script and UI levels.

• Leading the development of end-to-end Qlik Sense solutions, from data extraction to dashboard creation.
• Automation of dashboard publishing from workspace to streams using CI/CD, Jenkins, J-frog.
• Implementing proper three-tier architecture, creating proper QVDs, and storing them in the required folder structure. Implementing all the functionalities as per mockup using only native charts. Creating proper QVD generators and reload tasks so that the dashboard gets refreshed automatically.
• Created reusable artifacts, which can be reused by the team, like, 1. Coding structure for Qlik Sense, 2. Creation and dependencies of reload tasks for all the environments, 3. Folder structure for storing QVDs and files, 4. Access-related dependencies on Reload tasks 5. Landing page optimization, 6. Auto mail triggered concept for reload tasks configuration, 7. Qlik Sense native dashboards building structure.
• Responsible for developing and maintaining Qlik Sense applications for various departments, streamlining data analysis processes, and improving overall business intelligence capabilities.
• Involved in working closely with business stakeholders to understand reporting needs and implemented data visualizations that provided actionable insights.
• Collaborated with the IT team to integrate Qlik Sense with other systems, ensuring seamless data flow and synchronization.
• Code deployment and maintained versions. As part of an onshore assignment, I am preparing and reviewing the project plan and strategies to determine the project scope. I am also reviewing the Business Requirements Documents (BRDs), discussing areas of concern with the client, and providing an overview to offshore team members.
• Adapt at leading cross-functional teams, optimizing data architecture, and driving data-driven decision making.
• Proficient in translating complex business requirements into actionable insights.
• Developed a self-service dashboard for the sales team, resulting in a 40% increase in data-driven decision making. Reduced report development time by 50% by implementing best practices and utilizing custom visuals.
• Collaborated with the IT team to streamline data collection, resulting in a 25% reduction in data processing time.

• Developed User-Friendly Interactive Dashboards: Created interactive Qlik Sense dashboards utilizing Qlik NPrinting to visualize KPI trends, marketing insights, and potential anomalies
• Visualization Design & Development: Experienced in designing and developing visualizations, as well as creating business requirement documents and plans for dashboard creation
• Incremental Data Load Implementation: Implemented incremental data loading strategies to significantly reduce daily refresh times for extractors and reports
• CI/CD Implementation in Qlik: Established CI/CD processes in Qlik and Mashup, enabling automated deployment of files

• Spearheaded the implementation of websites, mobile applications, and landing pages from concept through deployment using a responsive, mobile-first strategy
• Assessed UX/UI designs for technical feasibility, ensuring seamless user experience
• Partnered with cross-functional teams to develop user-centric web applications using HTML and CSS, guaranteeing responsive design and cross-device compatibility
• Supported Android app development, engaging in both front-end and back-end tasks to enhance app performance