Nov 2019 – Jun 2020 · 7 mos · Massachusetts, United States

• Built high-performing Qlik Sense applications using QVD layers, incremental data loads, and optimized data models. Implemented enterprise Qlik security rules, custom properties, and section access to manage user-level data governance.
• Led the development of regulatory-compliant BI platforms, supported SDLC testing processes, created multi-layered data models, and ensured accuracy and auditability for clinical and commercial data workflows within Takeda’s global analytics ecosystem.
• Collaborated with cross-functional teams to define KPIs, document metadata, implement data quality rules, and establish enterprise BI governance frameworks across Power BI, Qlik Sense, and Microsoft Fabric.
• Developed star-schema and snowflake models to support scalable BI analytics and reduce data redundancy. Collaborated with Active Directory teams to align AD groups with Qlik application access requirements.
• Authored complex SQL, PL/SQL, stored procedures, and views to support BI transformations and data cleansing. Engineered ETL pipelines consuming data from Snowflake, SQL Server, Oracle, and Data Lakes.
• Implemented automation scripts using PowerShell, batch scripts, and methodologies to streamline deployments.
• Conducted unit, integration, system, and regression testing for BI components across data pipelines and dashboards.
• Led requirement workshops with business analysts, SMEs, and cross-functional teams to define KPIs, data fields, and business logic. Documented BI architecture including ETL flows, lineage maps, transformation rules, and dashboard specifications.
• Maintained Qlik Root Admin responsibilities including license management, task reload configuration, and performance tuning.
• Ensured regulatory compliance, auditability, and validation of BI outputs consistent with pharmaceutical quality standards.
• Built incremental load strategies and QVD pipelines for performance-optimized Qlik Sense data refresh cycles.

Jun 2019 – Nov 2019 · 5 mos · Clayton, Missouri

• Expert in Qlik reports using List boxes, Multi box, Pie chart, Line chart, Funnel chart, Scatter chart, Bar chart, Straight table, Combo table, Pivot table, Containers Buttons and KPI’s. Designed Qlik Sense dashboards for patient outcomes, readmission tracking, LOS metrics, and clinical performance indicators.
• Designed, Developed, Converted and Maintained the QlikView and Tableau Apps into Qlik Sense Apps for rich user-friendly experience. Performed imaging or cloning of app from Tableau, Power BI and Good Data. Built extensible Qlik extensions and custom objects to enhance advanced analytical capabilities.
• Engineered QVD pipelines using incremental, resident, and binary loads to support high-volume healthcare datasets. Modeled clinical datasets using star-schema and snowflake structures to support governed, performant analytics.
• Backing up of QVF, QVW using GIT hub/ Source Tree before deployments. Developed Proof of Concepts for the in-house projects. Performed error handing, trouble shooting and debugging of the applications.
• Created Excel based reports, Pixel Perfect reports, power point reports using N-Printing tool and scheduling of task job in N-Printing Server. Created pixel-perfect N-Printing reports for leadership, physician groups, and clinical operations teams.
• Managed publishment and deployment of apps between STAGE, PEAT, and PROD environments. Administered Qlik QMC including reload tasks, license assignments, security rule configuration, and performance monitoring. Developed automation routines for report distribution, dataset refresh, and QMC task executions.
• Established connection strings between data source using data connectors and ODBC/OLEDB drivers and connect with Qlik Cloud Storage via API. Used Toad and complex SQL queries to validate the data in data marts and Teradata data warehouse. Developed complex apps based of two tier or three tier architectures. Worked extensively with Advance analysis Actions, Calculations, Parameters.

Feb 2019 – Jun 2019 · 4 mos · Maryland Heights, Missouri

• Designed Qlik Sense dashboards to support claims cost analysis, provider scoring, utilization management, and operational KPIs. Built QVD pipelines using incremental loads, binary loads, and mapping tables to optimize Qlik data modeling.
• Developed and optimized the Qlik complex apps and N-print reports both in Desktop, Web version and Qlik Cloud Enterprise. Designed pixel-perfect and excel N-Printing reports for regular distribution to medical directors, auditors, and executive leadership.
• Automated and scheduled daily load of QVD documents using Qlik Publisher and notified load status by email. Scheduling of complex jobs both on the Qlik server and N-Print for end users and clients in pixel perfect, excel.
• Experience in implementing the new features of Qlik Sense like Story Telling, Beta maps integrations, Pivot Table, KPI Object.
• Collaborated with actuarial analysts and clinical program teams to refine KPIs and delivery logic. Tuned SQL stored procedures, views, and indexing strategies for high-volume healthcare claims data.
• Implementation and usage of Data Modeling Schema's, Incremental Load, Dimensional Modeling, and slow changing dimensions. Building of complex data models of Star Schema, Snowflake and De-Normalized Schema.
• Developed Power BI dashboards featuring dynamic bookmarks, KPI traffic-light matrices, and interactive master pages. Implemented RLS across Power BI datasets and Section Access rules in Qlik Sense to safeguard PHI and sensitive data.
• Deploying both the internal and external Qlik reports onto the Qlik servers and publishing the reports on Live Streams with backing up QVF’s files via GIT/Source Tree. Conducted UAT, regression testing, and production validation for all BI reports.
• Creating test cases and performing of unit, integration and system test for Data Warehouse and Data mart. Document to support including flowcharts and diagrams. Documented ETL transformations, QVD pipelines, dashboard specs, and business rules.

Mar 2017 – Feb 2019 · 1 yr 11 mos · O'Fallon, Missouri

• Creating, Implementing, Developing, Building, Maintaining and optimization of the dashboards to load domain data from Oracle database, Flat files, SQL Server, CSV files to Data Warehouse.
• Writes/Programs/Develops and implements visual data reports and creates personalized, interactive data visualizations, reports, and dashboards from multiple data sources.
• Provided data consulting services to Mastercard, a global payments technology company, focusing on leveraging data analytics to drive business growth and innovation, utilizing a broad spectrum of technologies including Power BI, Qlik Sense, SSIS, SSRS, Azure SQL, Azure Data Lake, Tableau, Alteryx, and the Power Platform.
• Designed and implemented data solutions to support various business functions, including finance, marketing, and risk management, enabling data-driven decision-making and strategic planning. Developed interactive dashboards and reports to analyze transaction data, identify fraud patterns, and optimize pricing strategies, empowering stakeholders with actionable insights.
• Implemented the Data Modeling Schema's, Incremental Load, Dimensional Modeling, and slow changing dimensions. Building of complex data models of Star Schema, Snowflake and De-Normalized Schema.
• Rewritten or refactor QlikView ETL logic into scripts compatible with cloud environments. Performed through Test Suites and validate ETL scripts to ensure accurate data processing and integrity.
• Worked on optimizing the ETL workflows for performance, scalability, and cost-effectiveness in the cloud environment. Document migration processes, configurations and best practices for future reference.
• Deploying both the internal and external Qlik reports onto the Qlik servers and publishing the reports on Live Streams with backing up QVF’s files via GIT/Source Tree. Performed Qlik installations on single node and multi node platform of STAGE, PEAT environment. Migrated reporting assets from Good Data, SSRS, and Splunk to Qlik.

Jan 2016 – Mar 2017 · 1 yr 2 mos · San Francisco, California

• Designed and developed BI Reporting solution enabling users to effectively utilize the tools to create Analytical Reports, Dashboards, and Scorecards, helping clients align KPIs performance metrics to strategic drivers and priorities.
• Worked directly with business users to define and prototype Applications. Worked with senior management to plan, define and clarify dashboard goals, objectives, and requirement.
• Lead, Developed the Qlikview environment and supporting the business decision process. Installed ad configured complete Qlikview, Qlik Sense server setup, IIS web server in multi clustered environment.
• Created the Qlikview dashboards and charts and QlikView performance optimization. Building the Qlik Sense dashboards and data modeling. Building expressions using set analysis and extension development.
• Extracted data from JDE tables and converted them into advanced visualization reports using Qlik.
• Migrated reports from OBIEE 10.1 to Qlikview 12 and Qlik Sense 3.1. Data modeling, analysis, design, testing, development, and implementation. Ability to optimize existing Qlikview reports to improve business productivity.
• Implemented the Qlikview dashboard security model using Section Access. Implemented all levels of security at row level, field level, and sheet level. Built QVD pipelines using incremental loads, resident loads, and binary loads.
• Built the Self-service Model Creating dashboards by extracting data from database write and externalize the load scripts, store the data as QVD files and designing the UI based on business/user requirements. Use of Set analysis and aggregation functions for sheet objects. QlikView data modeling by building the Star schema and resolving loops/synthetic keys.
• Developed Qlikview Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island. Deploying the Qlikview reports onto the Qlikview servers and publishing the reports on Access Point.

Jun 2015 – Dec 2015 · 6 mos · Tampa, Florida

• Built Qlik Sense Apps, templates, story generation, data modeling and Qlik Sense app performance optimization. Created the QlikView dashboards and Charts. QlikView Data Modeling and performance optimization.
• Data modeling, analysis, design, testing, development, and implementation. Fixing Complex issues using Set analysis, back-end SQL scripting and joins. Developed Qlik Sense dashboards supporting claims analysis, member demographics, provider performance, and managed-care KPIs. Built QVD pipelines utilizing incremental, resident, and binary load strategies.
• Worked with a cross-functional team of developers and business analysts to deliver on strategic data and analytics. Consolidated data into Qlikview from various data sources (SQL Database, Oracle Database Text files and Excel files).
• Configured different Qlik Sense roles and attributes-based access control and designed the Qlik Sense Governance and development cycle. Expertise in Qlik Sense development, data modeling, master items and maps.
• Expertise in the Qlik sense architecture and sizing. Experience with Qlik Sense Extensions and workbench. Expert in Qlik sense extensions and embedding in websites. Lead and developed the QlikView environment and supporting the business decision process.
• Data modeling, analysis, design, testing, development, and implementation. Generate QVD files created by ETL logic to feed Qlikview applications.
• Ability to optimize existing Qlikview reports to improve business productivity. Implementing the QlikView dashboard security model using Section Access. Implemented all levels of security at row level, field level, and sheet level.
• Building the Self-service Model Creating dashboards by extracting data from database write and externalize the load scripts, store the data as QVD files and designing the UI based on business/user requirements.
• Use of Set analysis and aggregation functions for sheet objects. Created macros in VBScript to meet the business requirements.

May 2012 – Nov 2013 · 1 yr 6 mos · Hyderabad · On-site

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using TSQL in SQL Server 2005. Developed ad hoc SQL queries for reporting, QA validation, and business analysis.
• Developed SQL Server stored procedures, functions, triggers, and views supporting enterprise application logic. Exposure to SSRS, SSIS, OBIEE and Cognos. Designed SQL scripts to perform data validation, cleansing, and reconciliation.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data. Updated database statistics, indexes, and structures to maintain server performance.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team. Provided ongoing support for database, ETL, and reporting across development and QA environments
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning. Managed user access and created new security accounts.
• Performed Backup and restore of databases. Developed and implemented database and coding standards, improving performance and maintainability of corporate databases. Debugged database code, resolved defects, and supported production issue. Performed QA testing for ETL processes, SQL code and report validations.
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server. Updated the statistics information for both the old and new servers.
• Assisted with various ad hoc query requests. Provided back-end support for functional testing and performance testing.
• Built SSIS and DTS packages for extracting, transforming, and loading data from flat files and Excel. Created OBIEE, Cognos, and SSRS-based reports and extracts for business stakeholders.