Jul 2022 – Jul 2024 · 2 yrs · Pune, Maharashtra, India · Hybrid

• Velocity Clarity portal provides dashboard solutions for Equity, Client Metric Settlements, Client Instructions, and Fund accounting for the banking data analytics department.
• Worked with business analysts to identify requirements and translate them into technical specifications.
• Optimized existing data models and load scripts to improve performance.
• Implemented Set analysis to improve the calculation times on the front end.
• Worked on Data Modelling, Implemented Star schema & Snowflake schema.
• Used Qliksense bundle extensions like Show/hide container extension, Tabbed Container extension and
• Variable input extension other the normal visualizations like Line Chart, Bar chart, table chart, etc.
• Involved in Production Support and Qlik Support for various applications and failure analysis using QMC.
• Involved in creating test case scenarios for end users to test the applications.
• Knowledge of n-printing and Enterprise Qlik sense upgrades.
• Write SQL queries to match data between databases and developed dashboards

Mar 2021 – Jul 2022 · 1 yr 4 mos · India · Remote

Jan 2020 – Mar 2021 · 1 yr 2 mos · Pune, Maharashtra, India · Remote

• Client: ZS, Pune
• Hands on experience in Qlik Sense development, dashboarding and data modeling and reporting (ad hoc report generation) techniques.
• Experienced in application designing, architecting, development and deployment using Qlik Sense. Efficient in front-end development and know visualization best practices.
• Good at Data transformation, the creation of QVD files and set analysis.
• Able to comprehend and translate complex and advanced functional, technical and business requirements into executable architectural designs.
• Creating and maintaining technical documentation.
• Experienced in data integration through extracting, transforming and loading (ETL) data from various sources.

Sep 2017 – Dec 2019 · 2 yrs 3 mos · Pune, Maharashtra, India

• Client: Banking, Germany
• Description:
• This Qlikview Project is for providing the solutions and developing Internal and Regulatory reporting Dashboard for Bank Treasury Department, these dashboards are used by the bank to analyze liquidity risk associated with derivative collateral and include different parameters such as Revenue, Cost, Haircut, Collateral and Adjustments.
• Technologies and Tools: Qlikview 11, 12, QMC (Qlikview Management Console), Oracle, GIT Hub, JIRA, Service Now tool, Confluence, Access Point.
• Responsibilities:
• Worked as qlikview developer to create Qlikview Visualization and Dashboards for treasury project.
• Gathering requirement from stakeholders and translating business requirements into meaningful KPIs with help of Business Analyst.
• Worked on Data Modelling, Implemented Star schema & Snow flake schema.
• Created various kinds of visualization using Qlikview such as Charts, Tabular chart & Conditional Formatting. Implemented Incremental Load to improve Load Time.
• Developed Linked Tables, Concatenation and solved the loops issues.
• Created different types of sheet objects like List boxes, Buttons, Multi-box and many more.
• Working on Agile Methodology using JIRA for SDLC.
• Worked on Service now tool for Production Support Activities.
• Worked on GIT tool to maintain correct document version for deployment.
• Tested Applications, ensuring the application met the requirements, Data quality for Quality Assurance before delivering to the end users.
• Performed the Qlikview services restart based on requirement.
• Worked on Service now to take care of production changes/requests.
• Performed the Application deployment activities, completed 2 production release.

Nov 2016 – Aug 2017 · 9 mos · Pune, Maharashtra, India

• Client: Banking, Australia
• Description:
• The main objective of this Project is to provide different operation teams a single view for monitoring and tracking incidents, service requests that are open till date, open today, total reported, and how teams are adhering to SLA and its breach. The Project also provided a Summary level HOD View, which helped the Head of department to monitor performance of all the teams in IT-Operations.
• Technologies and Tools: Tableau Desktop 10.2, Tableau Server, Tableau Reader, CSV, Oracle
• Responsibilities:
• Developed Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Developed different type of visualizations and graphs
• Extracted data from database and non-database sources (Excel and text file) and generated reports by using Tableau desktop.
• Created different tableau charts including Bar Chart, Line Chart, Waterfall Chart, Pie Chart, Doughnut Chart and many more.
• Used filters, sets, parameters and calculated fields on tableau reports.
• Created hierarchies, sets, combined sets and groups in Tableau.
• Created Scatter Plots, Stacked Bars, Box and Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Tracking the Data Requests, Service Requests raised daily and providing a detail view of Incidents with their IDs, Assigned team, Open Date, Close Date and so on.
• Addressed production issues on performance tuning, enhancements etc.

Dec 2014 – Oct 2016 · 1 yr 10 mos · Pune, Maharashtra, India

• Client: Telecom, Belgium
• Description:
• This telecom project deals with providing L2 and L3 Support and maintenance for the fixed line customers of Belgacom for the successful submission and completion of their orders. As part of automation team, I was responsible for creating workflows for repetitive tasks.
• Responsibilities:
• Created automation workflows according to the requirements for repetitive tasks.
• Analysis of data received through Service Performance Dashboard.
• Writing SQL queries to obtain results from the databases and analyzing the problem areas.
• Ensuring all the systems is in sync and responsible for doing RCA for increase in inflow of Queue.
• Coordination with Onsite team in case of issues and resolution.
• To run exiting scripts to minimize backlog for repetitive tasks.
• Check email Alerts, Notification mails and any tickets in queue with their priority and directly contacting the customer regarding critical issue and Escalation mails.