Summary
Overview
Work history
Education
Skills
Certification
Accomplishments
Timeline
Generic
Harry Bhalla

Harry Bhalla

Hucknall,Nottinghamshire

Summary

With nearly 15 years of experience in delivering comprehensive end-to-end ETL solutions, I am an experienced Data Warehousing Application solution developer. I possess a strong command of data warehousing concepts and an excellent skillset. My expertise extends to data insights and analysis, pattern recognition, and generic solution building for diverse data requirements. As an outstanding team player and leader, I am adept at fostering positive interpersonal relationships. I eagerly anticipate the challenges and opportunities that will contribute to my professional growth and learning.

Overview

14
14
years of professional experience
1
1
Certification

Work history

Senior Data Warehouse Analyst

Nottingham University Hospitals
Nottingham, Nottinghamshire
08.2022 - Current
  • Data Management Responsibilities: Develop and modify ETL routines, ensuring data onboarding, cleansing, and transformation for the Data Warehouse application.
  • Collaboration and Communication: Collaborate with various teams, including Trust Analysts, Finance, and Trust Interface, for data-related activities and coordinate with vendors for source system upgrades.
  • System Improvement and Maintenance: Continuously enhance the Data Warehousing application by introducing checks for anomalies in job behaviour and maintaining the system.
  • Data Engineering Responsibilities: Address data requirements, develop optimised SQL solutions, and provide support for data issues.
  • Collaboration and Communication: Collaborate with various teams, including Information Services, Finance, and third-party software providers, to understand and document requirements.
  • Risk Management and Knowledge Sharing: Identify and mitigate risks related to data breaches and share best practices and knowledge with colleagues.
  • Downtime Minimisation: Conduct a rehearsal of the planned approach before the go-live phase to minimise application downtime during significant changes and upgrades.
  • System Knowledge Enhancement: Develop additional skillsets and adapt to technical upgrades to enhance knowledge of the healthcare system’s operations, its collaboration with IT for data management, and the flow of information between intra-hospital departments.

Solutions Architect (Assistant Vice President)

Barclays
Pune, Maharashtra
11.2017 - 08.2022
  • Interpret stakeholder requirements, explain the project to the team, and contribute to delivering functional specifications.
  • Design and develop new features for the existing reporting application, providing multiple business insights.
  • Develop automated data quality check scripts to minimise application failures.
  • Develop a business application for data insights reporting using various tools and technologies.
  • Participate in all application development phases, including requirement gathering, analysis, design, development, testing, support, and deployment.
  • Develop generic graph codes for data acquisition from Salesforce, Oracle, and flat files.
  • Develop shell scripts for performing stats checks on the application’s databases.
  • Design data flow diagrams of the application, detailing data insights, sources, targets, and transformations.
  • Perform requirement analysis for ad-hoc business change requests, build new code, perform unit and integration testing, and deploy changes to production.
  • Provide warranty support for the newly developed application.
  • Debug and develop solutions to existing application code, providing optimised and corrective solutions.
  • Develop and maintain code according to technical and functional specification documents, adhering to quality accredited standards.

Senior Associate Projects

Cognizant Technology Solutions
Pune, Maharashtra
08.2016 - 11.2017
  • Involved in multiple client requirements gathering sessions, comprehending the business model, and documenting code migration requirements for the team.
  • Participated in the complete SDLC lifecycle for the application, interpreting requirements, coding TD scripts, performing unit and regression testing, deploying code to multiple environments, and providing warranty support.
  • Created automated shell scripts for testing record counts and data anomalies, ensuring records aren’t skipped without contacting the source. Developed automated email alerts for program and job failures, sending recovery suggestions to specific teams.
  • Developed and designed scripts with robust support for sparse rebuilt functionality, maintaining a centralised date control feature. Documented the recovery mechanism in case of live failures.
  • Performed unit testing, prepared test cases for post-production deployment, and validated data based on major and minor keys to ensure data quality.
  • Conducted technical reviews, suggested fixes, created stored procedures for historical data bugs, debugged code issues, optimised performance by redesigning indices, and automated statistics collection scripts.
  • Deployed production views to limit data visibility to users based on roles and sensitivity. Defined functional requirements, processes, improvements, project scope, code, testing, documentation, and deployment. Prepared training, administrative docs, and framework walkthroughs for multiple teams to demonstrate project improvements.
  • Interacted with the data quality team and end users to identify gaps in test cases. Prepared documentation for live proving the application with case logs and explanations for all testing performed, and got sign-off from business end-users.

Associate consultant

Capgemini
Pune, Maharashtra
11.2014 - 08.2016
  • Participate in requirement gathering sessions with the client, suggest and provide inputs to the changes requested by the business and document the complete requirements for technical interpretation and follow change management protocols.
  • Responsible for the addition /modification of new features for the application specifications, and perform unit testing and fix any bugs found during the testing.
  • Coding automated program scripts /stored procedures for loading the data across multiple dimensions as per business model requirements. Develop and design an application to ingest the data from different originating applications, including mainframes, Oracle server,
    XML formats, using multiple data sources and ODBC/JDBC connectors.
  • Responsible for developing and implementing multi-data processing parametrised generic applications. Debug and analyse the existing code for application bugs and produce a well-optimised solution as per the industry coding standards.
  • Interact with Business end users once the application is deployed to identify any gaps in test cases. Responsible for maintaining the application post-deployment to production. Design the
    data flow diagram of the application for an end-to-end knowledge of jobs, functions used, inputs and outputs parameters used. Creating documentation and illustrations for other warehouse application developers, explaining the acronyms and standards followed
    while coding.

Systems engineer

Tata Consultancy Services
Kolkata, West Bengal
11.2013 - 10.2014
  • Design and develop new features for the existing warehousing application, conduct unit testing, and provide fixes.
  • Develop shell scripts to automate environment setup for the application, making them reusable across multiple portfolios.
  • Reduce build time by utilising parameterised scripts for the same program/code in development, SIT, OAT, and PROD environments.
  • Develop applications using various tools and languages, including JAVA, LINUX, SHELL scripting, SQL, and TERADATA suite scripting.
  • Design and develop multiple KPI applications that support parallel execution on multiple datasets, thereby reducing overall job run time.
  • Gather, analyse, and perform feasibility checks on business enhancements requirements, build code in accordance with new business demands, and conduct regression testing.
  • Debug and develop source scripts, producing generic solutions for implementation across all source systems in an optimised and documented manner.
  • Code generic and automated procedures/programs for repetitive activities, document run-time requirements, and share them with other developers and support team members.
  • Test developed reports for multiple business scenarios, ensuring data quality consistency across multiple drill-down levels.

Senior Software Engineer

Tech Mahindra
Hyderabad, Telangana
04.2011 - 10.2013
  • Analyse technical specifications and suggest code optimization.
  • Fill timesheets and complete invoicing on time.
  • Interact with customers, flagging requirements or issues to seniors.
  • Develop software code based on customer requirements.
  • Track open tickets/incidents and allocate resources.
  • Continuously improve processes to save time, money, or enhance customer satisfaction.
  • Adhere to quality processes, update defect logs, test scripts, and comply with timelines.
  • Perform self-code reviews.
  • Develop project status reports and perform re-usage, accuracy, and efficiency activities.
  • Collaborate with others, meeting individual and team goals.
  • Provide application production support as per process/RACI Matrix.

Education

Bachelor of Technology - Computer Sciene Engineering

Lovely Professional University
Phagwara , Punjab , India
09/2006 - 09/2010

Skills

Personal Skills:
* Problem-Solving
* Critical Thinking
* Analytical Mindset
* Target-Oriented & Motivated

Leadership:
* Time Management
* Attention to Detail
* Robust Decision Making
* Polymath

ETL Tools:
* Ab-initio
* Informatica
* SSIS

*Teradata Utilities


Database:
* MS-SQL Server
* Teradata
* MySQL
* Oracle

Operating Systems:
* Windows
* Linux
* Unix

Hadoop Ecosystem:
* Hive
* Impala
* HDFS
* Parquet file formats
* Pyspark

Languages:

*Shell Scripting

*C# coding(SSIS)

*PL-SQL

Certification

Teradata 12 certified Professional

Teradata 14 certified Professional

Big Data Expert Training Programme

Microsoft Certified Data Engineer


Accomplishments

Awarded by the Nottinghamshire Care Board for the Opportunistic Flu Vaccination Programme project, whereby technological ETL data flow was leveraged to support clinic staff to offer and administer flu vaccination to the eligible patients in the outpatient clinic.


https://healthandcarenotts.co.uk/ics-award-for-nottingham-city-and-south-notts-place-based-partnership-teams/

Timeline

Senior Data Warehouse Analyst

Nottingham University Hospitals
08.2022 - Current

Solutions Architect (Assistant Vice President)

Barclays
11.2017 - 08.2022

Senior Associate Projects

Cognizant Technology Solutions
08.2016 - 11.2017

Associate consultant

Capgemini
11.2014 - 08.2016

Systems engineer

Tata Consultancy Services
11.2013 - 10.2014

Senior Software Engineer

Tech Mahindra
04.2011 - 10.2013

Bachelor of Technology - Computer Sciene Engineering

Lovely Professional University
09/2006 - 09/2010

Similar Profiles

Create profile
Harry Bhalla