HARJOT KAUR

• Delivered excellent customer service through prompt responses to client inquiries, addressing concerns effectively, and building strong relationships.
• Ensured accurate record-keeping with diligent data entry and database management for vital company information.
• Updated reports, managed accounts, and generated reports for company database.
• Supported executive staff through scheduling meetings, coordinating travel arrangements, and preparing crucial documents.
• Assisted in onboarding new employees, providing training materials, and coordinating orientation schedules to ensure a smooth integration into the team.

• Technologies Used: SQL,SSRS, Jira, Service Now, MS-Excel
• Presenting outcomes of data analysis to leadership and other stakeholders.
• Hands on experience in Tableau development, dashboarding and data modeling and reporting (ad hoc report generation) techniques.
• Automation of several Ongoing Manual reports using Data Analysis and Visualization tools.
• Data integration through extracting, transforming, and loading (ETL) data from various sources
• Supported leadership team with reporting, analysis, and business presentations to inform divisional strategies
• Strong database design and SQL skills
• Ensure all requirements and analysis is in line with best practices, principals and standards defined by Analytics team
• Working with executive reporting to turn operational reports into visually appealing, easy to understand automated stories.
• Engage with stakeholders to discover, analyze and evaluate business intelligence needs in order to design appropriate solutions.
• Communicating with customers to analyze historical data and identify KPI's

• Provide relevant analytical support to the Manager in providing guidelines in developing data analysis and reports to track and forecast Retail Renewal Mortgages portfolio performance and trends
• Created Tableau reports for retail renewal mortgages project
• Identify business trends utilizing real data, compile analysis reports that are delivered to developers and then follow-up on all results
• Creating a detailed business analysis, outlining problems, opportunities, and solutions for a business
• Complete in-depth analysis of workforce data for trend analysis, planning, and decision-making purposes

• Evaluate business processes, identify opportunities for improvement, document & communicate business requirements, and implement initiatives
• Develop solution documentation, training documentation, support documentation, functional and technical specifications, and other relevant document sets for support of their respective solutions
• Ensure all work and deliverables adhere to relevant business and IT security standards, governance policies, and regulatory requirements
• Research, learn, and adapt new technologies, relevant industry standards, and best practices
• Other duties as required
• Used critical thinking to break down problems, evaluate solutions and make decisions
• Developed team communications and information for meetings

Project Undertaken:

1. British Petroleum: It is a British multinational oil and gas company headquartered in London, England. BP has selected Accenture as its global outsourcing provider of finance and accounting (F&A) services.

Tools & Technologies Used:

Tableau, Qlik View, MS-SQL, JIRA, GIT Hub, Agile Methodologies and MS-Excel.

Job Profile: APPLICATION DEVELOPMENT ANALYST

· Developed Tableau based application consisting of 20+ reports and 50+ features for the client using large datasets.

· Gathered functional and non-functional client requirements in order to optimize the design of deliverables (reports, dashboards, alerts, visualizations)

. Design, test, monitor and troubleshoot stable and effective SQL scripts and ETL processes.

· Monitoring and optimizing the performance of database.

· Worked as Tableau Administrator and performed regular server maintenance and upgrades.

· Communicate results through presentations, reports, tools, and data visualizations for clients, internal staff.

· Wrote sophisticated SQL queries to extract data and build complex models.

· Worked closely with Testing team to keep the number of defects to minimum.

· Handling Application Outsourcing Support for defect resolution using QMC, UNIX and JIRA.

2. Royal Mail Group: Royal Mail is the UK's designated Universal Postal Service Provider.

Tools & Technologies Used:

Tableau, MS-SQL, UNIX, VM Ware, Data Warehouse Structures and Models.

Job Profile: SOFTWARE ENGINEER ASSOCIATE

· Collecting, organizing, and analyzing data to identify trends, patterns, and insights.

· Conduct ad hoc analyses to support business decisions.

• Developing,maintaining and managing advanced reporting, analytics, dashboards and other BI solutions.
• Performing and documenting data analysis, data validation, and data mapping/design.
• Reviewing and improving existing systems and collaborating with teams to integrate new systems.
• Conducting unit tests and developing database queries to analyze the effects and troubleshoot any issues.

• Company Overview: Working for client Sprint which is an American telecommunications holding company that provides wireless services and is a major global Internet carrier
• Perform analysis and diagnosis of highly complex networking problems
• Act as technical expert with other team members, as well as with other Ericsson worldwide teams
• Maximizing network performance by monitoring performance, troubleshooting network problems
• Undertaking data network fault investigations in local and wide area environments, using information from multiple sources
• Fault / Incident Management
• Working for client Sprint which is an American telecommunications holding company that provides wireless services and is a major global Internet carrier