Data Analysis Technical Lead

Priya Gopal

BI Technical Lead

Lancaster, PA • +1-223-***-**** • *****.********@*****.*** • linkedin.com/in/priya-g-bb96b4208 Project : Tools & Automation ( Wipro Ltd – Oct’16 to May’24 ) Client : Banking, Airlines, Telecom

Role : Technical Lead

Technology : PowerBI, Power Automate, PowerApps, Report Builder, QlikSense, QlikView, Qlik NPrinting & MS SQL

Roles and Responsibilities :

• Fostered a positive work environment that encouraged collaboration and Innovation among team members.

• With over 7+ Years of experience in Data Analysis, Design, Implementation, Administration and Support of BI using PowerBI, QlikSense

& QlikView.

• Front Ending Customer Demos / Handling customer meetings.

• As a Senior BI, Identifying and resolving L2/L3 level technical issues in a timely and efficient manner, also supporting team members on development activities.

• Provided End-To-End support for PowerBI, QlikSense & QlikView Insights.

• Provided knowledge session on Power Platform, Qlik & ITIL to the team. PowerBI

• OnPrem gateway setup to establish the connectivity from OnPrem Sources to PowerBI Service.

• Data imports from various sources using ODBC/Cloud/Database connectivity.

• Extensively involved in creating the Complex Data Model using Power Query & DAX for PowerBI Dashboards.

• Worked on RLS based access enablement to the users.

• Efficiently worked on complex data model with optimization (Power Query, DAX), Dashboard Design and Publishing it on workspace.

• Developed ITSM (using ServiceNow. Remedy, Summit and others), Asset Reconciliation, Infra Monitoring, Endpoint & Software Compliance, Operational & Talent Insights in PowerBI Cloud Platform using various data sources (SQL, ServiceNow, PostgreSQL, APIs, MySQL & SharePoint).

• Implemented Ad hoc reports using Power Paginated Reports.

• Implemented solutions with Power Automate Flows for report automation & data collections.

• Configuring and monitoring workspace to publish the dashboard on PowerBI Service & Optimizing based on needs.

• Worked on Dataflow for the Data Extraction with optimized queries.

• Gathering data and translating complex business requirements into optimal and scalable data models and visualizations, including building pages, KPIs, and dynamic charts.

QlikView & QlikSense

• Involved in entire project life cycle from requirement gathering to production of Qlik Dashboards.

• Extensively worked in QlikSense/QlikView Setup in single/multi node Environment.

• Worked on version upgradation / dashboard enhancements of QlikView/QlikSense.

• Worked as a QlikSense & QlikView administrator to create/monitor the Tasks/Apps/Stream, Publishing insights, User Access enablement, Creating the Data connection, Security Rule, Enabling SSL to hub & configure the services.

• Implemented MFA Integration with Azure.

• Worked on Data Extractions from the SQL/My SQL/ServiceNow and other sources to QlikSense/QlikView.

• Worked on Data Extraction with Full/Incremental load and creation of dashboard with QVDs using the scripts and automated by scheduling it thru QMC Tasks.

• Worked on Dashboards using Functions, Variables, Nested Variables & Set Analysis in QlikSense and QlikView as part of Data model & Visualization.

Dedicated team leader with the ability to effectively manage and achieve project goals. Experienced and dedicated Data Analyst with several years of experience identifying efficiencies and problem areas within data streams, while communicating needs for projects. WORK EXPERIENCE (12.8 Yrs)

OBJECTIVE

DEGREE UNIVERSITY YEAR CGPA

MS in System Engineering Integrated Degree with Wipro Ltd & Birla Institute of Technology 2016 6.99 Bachelor of Computer Application Kongu College of Arts & Science,Tamilnadu(India) 2011 7.32 HSC St.Theresa’s Girls Higher Secondary School – Tamil Nadu(India) 2008 83.75% SSLC Government High School – Tamil Nadu(India) 2006 87.2%

• Developed various dashboards using ITSM tools, CMDB, Compliance tools in QlikView & QlikSense with business need KPIs.

• Created Stories in QlikSense based on Customer requirements using Story telling feature.

• Validated the data model and dashboard on code review, testing and confirming visualization of functionalities & ensuring optimal data model, accuracy and effectiveness of the data and applications.

• Provided demo to clients about the dashboards and usage QlikSense.

• Installed & configured the NPrinting into the environment for Report automation from QlikSense.

• Implemented multiple Ad hoc reports with NPrinting.

• Worked on Report Automation using QlikView Macros.

• Worked on Backup & Restoration of QlikSense & NPrinting Apps/Reports. Project : Tools & Automation ( Wipro Ltd – Sep’11 to Sep’16 ) Client : Banking, Airlines, Telecom

Role : ITSM Application Implementor/Senior Software Engineer Technology : ITSM Modules, IIS, MS SQL

Roles and Responsibilities :

• Worked as ITSM Tool Implementer & Support for eHelpline (ITIL Based Tool) Service Desk ticketing tool.

• Front ending the customer demo about the tool and its features.

• Data collections for configuration, UAT confirmation.

• Hosting the application in IIS and enabling connection from Application to Database.

• Configuring Services like AD Services, SMS Services & Mail Services.

• Creating Pre-cautionary SQL Jobs – DB Maintenance plan, clean up and application related jobs.

• Tool version migration on regular intervals as per development team patch release.

• Providing training to internal support/implementation to new joiners. Making them efficient to handle the projects effectively & independently, explaining their roles and responsibilities.

• Worked on SQL triggers, functions and procedures based on requirements. TECHNICAL SKILLS

• Effective Tech Lead

• QlikSense

• QlikView

• Qlik NPrinting

• MS SQL

• ITIL

• PowerBI Visualization

• DAX, M Query

• Power Automate

• Paginated Reports

• PowerApps

STAR ACHIEVEMENTS

• Zenith Best Delivery Individual

• Inspiring Performance

• Automation Champions

• CIS Star of the Week

• Best Automation Case Studies

ACADEMIC BACKGROUND

Contact this candidate