AAKANKSHA BHARDWAJ

Having 9.8 years of professional experience in BI/Analytics area with expertise of handling the projects with a larger group of stakeholders leveraging excellent analytical and logical skills. 9.8 years of experience into Banking, Insurance and Energy Utility domain.

• Having 9.8 years of experience in all SDLC phases with expertise in handling the projects with a larger group of stakeholders leveraging excellent data analytical and logical skills. Matured in Banking, Energy Utility and Insurance domain.
• Ability to deliver Analytics/BI solutions through ETL technologies.
• 1-year onsite experience working with European Client and worked there as a primary point of contact for a migration project.
• 1 year onsite experience working with Irish Client and worked there as a Data Analytics Reporting Manager.
• Worked as Off-shore coordinator lead for ETL Team consists of total 12 members.
• Worked as an Incident Manager for AMS domain under European client.
• Working as a BI Tower lead currently for Data and BI Analytics domain and managing a team of 30 members.
• Coordinate with IT Business Partners for different BI Applications in resolving issues & improving processes.
• Specialized in analyzing and interpreting data to drive better business solutions through visualizations tool( Power BI and QlikView).
• Coordinate with IT Business Partners for different BI Applications in resolving issues & improving processes.
• Good Understanding of Database technologies like Oracle, SQL Server, SSMS etc.
• Excellent experience providing solutions on Business Intelligence and DWH projects.
• Experience in designing and implementing ETL (Extract, Transform, Load) processes.
• Participate in the development plans & resource estimation for task planning.
• A team player with exceptional analytical, problems solving, interpersonal, communication & team management skills.
• A team player with exceptional analytical, problems solving, interpersonal, communication & team management skills.
• Achieved continuous promotions from Associate Software Engineer to Senior Software Engineer.
• Have experience in working with Waterfall model and Agile methodologies and Dev ops tools like GIT (Gitbash , Gitlab , Artifactory, Jenkins and Bitbucket).
• Have experience in monitoring production jobs and performing analysis for production issues and capable of providing detailed root cause and solution- oriented approach for the same.

AZ -900 Microsoft Azure Fundamentals Certified

Certified Alteryx Foundation Micro Credential

• Recognized twice as “Star of the month” award in IBM
• Microsoft Azure fundamentals Certified.
• Certified in Alteryx Foundation Micro-Credential Program
• Awarded for Customer Excellence by Accenture Solutions Pvt Ltd for excellent customer service.
• Awarded continuous promotions in First Company-Accenture Solutions Pvt Ltd
• Received tremendous appreciation for my Teamwork, Leadership skills & technical skills from senior management in current and previous organizations Recognized twice as “Star of the month” award.

Travelling, Cooking and love doing adventurous activities

Uiscee Eireann (Irish Waters -Ireland)

Role - BI & Analytics Reporting Tower Lead  (Sept 2023- Till Date)

Technologies - SAP BO, QlikView, OWB, Oracle BI Publisher, Azure Data Factory and Microsoft Power BI

• Leading the BI & Analytics Reporting Team which consists of 30 team members.
• Responsible for planning and coordinating all the activities required to perform, monitor, and report on the process which comes under BI Domain.
• Led the entire knowledge transition phase from onsite for 7 applications comes under BI Analytics domain and received successful go ahead from client in one go.
• Single point of contact at Onsite for all deliverables comes under BI Domain related to Incidents, Service Requests, problem tickets and various enhancement.
• Lead the team of various members like Data Analysts, Azure Data engineering, ETL developers, SAP BO and QlikView Developer.
• Preparing weekly reports and Presenting progress on Incidents/Enhancements on weekly basis to the Client stakeholders .
• Primary Person at Onsite for datawarehousing and ETL related projects discussion.
• Creating SLA Report using Power BI for Business teams and Leadership team.
• Automated and framed various governance policies along with Data Authority at client side to manage Power BI Administrative activities.
• Facilitate and managing the License Review for Power BI and conducting several reivew meetings with Data Authority for workspace and report management in Power BI production environment.

LUMINOR BANK (Northern Europe)

Role - Data & BI Tower Lead(Aug 2021 - Aug 2023)

Technologies - Qlik view, Nprinting, Informatica, OWB,Tableau, Microsoft Power BI, SQL Developer 12c, Service Now and Jira.

• Leading the Data and BI Tower in Luminor account which consists of 8 team members.
• Single point of contact for critical and non-critical incidents/requests coming up for IBM team.
• Preparing reports and Presenting progress on Incidents/Enhancements weekly basis to the Client .
• Responsible for planning and coordinating all the activities required to perform, monitor, and report on the process.
• Primary Point of contact for Tableau and other Datawarehouse applications like Qlikview and Nprinting where handling various developments, P2 /P3 incidents and service requests from start to end.
• Creating SLA Reports using Tableau and Power BI for Business teams and Leadership team.

CAPITAL GROUP-US

Role- Data Analyst(Nov 2020 - Aug 2021)

Technologies -Alteryx Designer 2020.4, Tableau Desktop 2020.4 , Tableau Server, Git bash, Bitbucket, Microsoft SQL server, Microsoft Azure Services(Data Bricks).

• Responsible for Monitoring and maintenance of various tableau dashboards.
• Handled Digital Analytics team
• Responsible for scheduling the ETL jobs using Alteryx designer.
• Well versed with LSIP tracking, Issue tracking, and Project Management using JIRA Tool.

ING Bank of Belgium

Role- Senior BI Analyst (July 2017 - Aug 2020)

Technologies - Informatica Power center 10.1.0,OWB,HPALM ,HAEPM, Oracle SQL developer(11g and 12c),GIT, Snow

• Played Key role for ODS team by handling major end to end implementation for two migration projects.
• Created several mappings, reusable transformations, sessions, workflows and efficiently used various transformations like Lookup, Joiner, Aggregate, Filter, Source qualifier, Expression, Router, and Update Strategy.
• Lead a ETL Team of 12 members and tracked a note of individual tasks & managed resource planning as well.
• Individually responsible for maintaining and and sharing the weekly status report with Client.
• Well conversant with DWH concepts using multiple ETL technologies.
• Created several mappings through OWB tool using several operators like de -duplicator, Input ,Output parameters, Joiner, Filter operators.
• Well versed with several sessions and workflows properties for proper error handling process in Informatica.
• Delivered multiple demo sessions for the developed scope to Client stakeholders.
• Worked and assisted the team in every phase of SDLC as an experienced team player.
• Conducted Unit Testing ,System Integration Testing, Performance testing, Regression testing and provided solutions for UAT if any bug fix is required.
• Prepared various code migration and deployment related documents and deployed code in multiple environments.

Bank of Ireland

Role: BI Analyst(Mar 2017 - July 2017)

Technologies-Informatica power center 9.6.1, Teradata 14.10, HPQC

• Data loading from multiple heterogeneous source systems to data warehouse using Informatica 9.6.1.
• Handled Performance Tuning in ETL mappings and SQL queries.
• Worked on HPQC Tool for defects management.

AXA-Insurance -Hongkong

Role: BI Analyst (Feb 2015 - March 2017)

Technologies: Informatica Power Centre 9.1.0, SQL Oracle Developer 10c, HPQC, Unix.

• Prepared and presented various Technical Design specifications and deployment related documents.
• Handled end to end implementation for major release as a part of BAU
• Created ETL Mappings, Mapplets, Workflows, and Worklets using Informatica Power Centre and Power exchange for AS400.
• Good exposure in providing solution-oriented approach for Production issues as debugged several Informatica issues.
• Creation of info maps, libraries, data set with the help of SAS BI tool and Generated excel reports for top management with the help of SAS BI tool.
• Well versed in Test Analysis which includes Requirement understanding, Effort estimation, Defect management, Test Plan and Test Cases preparation.
• Hands on experience on Oracle Database by writing SQL complex queries.