Gurjot Kaur Bandasha

• Improved data quality by creating standard data enrich functions to clean data elements such as zip code, phone number, name, address etc..
• Performed branch management in GitHub. Setting up environment level branches for code promotion.
• Created multiple Roxie services on ESP to make data readily available for web applications.
• Utilized pre-existing sub-modules like Useful ECL, Blend Join, and Notify Function for job chaining.
• Engineered advanced name matching logic using regex and parallel processing techniques, resulting in enhanced data deduplication and matching accuracy.
• Conducted daily code reviews, offering valuable feedback, and maintaining high code quality standards.
• Self-learned cloud services to assess the benefits of transitioning to Azure cloud from on-premise solutions.
• Applied EMBED SQL and Python within ECL to optimize data processing and manipulation.
• Expertly parsed complex file formats such as ACH, Bai2, Check21, VSS, and ICL, ensuring data integrity and compliance.

• Oversaw all technology functions, including vision and strategy, product development, quality assurance, project management, systems administration / infrastructure and systems operations.
• Lead team of 25 developers which included Node JS developer, React Developers, DevOps, Linux Administrator and ETL Developers.
• Provide technical and business oversight to all projects.
• Engaged in Agile Project Management as well as Waterfall delivery methodologies utilizing GitHub and Azure Boards.
• Oversees unit and system integration testing and code reviews for work completed by programming team.
• Analyzed, identified, and recommended business process and technology solutions for initiatives and programs within this company.
• Served as subject matter expert to leadership team.
• Provided strong leadership to enhance team productivity and morale.
• Managed large-scale projects and introduced new systems, tools, and processes to achieve challenging objectives
• Held monthly meetings to create business plans and workshops to drive successful business.
• Identified cost improvement changes and cost savings plans to increase company savings.
• Controlled resources and assets for department activities to comply with industry standards and government regulations.
• Planned, created, tested and deployed system life cycle methodology to produce high quality systems to meet and exceed customer expectations.
• Setup processed to make sure we deliver secure code by implementing sonar scans, running Zap testing and also rpm audits as part of every build that is created.

• Led and mentored high-performing team, providing guidance and management to ensure successful project execution and team development.
• Actively participated in hiring process, including candidate screening, interviews, and evaluation, contributing to recruitment of top talent for data engineering team.
• Developed and documented standards and procedures to maintain consistent data quality, adhering to industry best practices and fostering culture of quality assurance.
• Proactively recommended technological developments and efficiency improvements, staying updated with industry trends and emerging technologies to enhance data engineering processes.
• Oversaw ETL flow management, ensuring seamless extraction, transformation, and loading of data from diverse sources to destinations, handling large data volumes efficiently.
• Implemented and optimized ELK (Elasticsearch, Logstash, Kibana) stack for real-time log processing, analysis, and visualization, significantly enhancing operational insights.
• Designed and executed complex data cleaning and transformation logic, guaranteeing data accuracy and consistency.
• Collaborated closely with clients, actively participating in requirement gathering, and translating client needs into actionable technical specifications.
• Worked closely with the web development team, contributing to data-driven feature integration to improve user experiences and streamline data access.
• Addressed design challenges and evaluated alternative design models to meet project requirements.
• Evaluated project requirements to identify and mitigate risks.

• Extensive knowledge of designing and developing data pipelines using real-world financial transaction and customer data.
• Experience with enterprise support models for data management, security, database programming, service delivery, performance monitoring, and user support standards.
• Owns design and development of significant components or modules and contributes to reviews of other components within overall architecture
• Ensure that code adheres to defined standards and best practices for accessibility, security, standard coding practices, performance, and quality.
• Translated customer and system requirements into robust software design with test-driven approach.
• Created Ruled based reports and came up with a dynamic way of setting parameters.

• Developed complex Big Data queries using Enterprise control language (ECL).
• Analyzed large-scale data files and generated intricate reports, visualizing data using tools like Kibana.
• Conducted data cleansing, transformation, and profiling (ETL) of financial data, utilizing ECL functions such as Projects, Transform, Iterate, Rollup etc..
• Performed Root Cause Analysis (RCA) to detect and correct anomalies, ensuring high data quality for Big Data Analytics.
• Successfully resolved critical bugs and issues within tight timeframes, maintaining our SLAs.
• Utilized Cron tab for job management and scheduling on the cluster, optimizing data processing workflows.
• Implemented Agile methodologies and utilized GitHub Issues for product development, ensuring rapid and flexible project execution.
• Ensured code adhered to defined standards and best practices, including accessibility, security, standard coding practices, performance, and quality.

• Designed and implemented SSIS ETL processes, supporting various file structures and business processes.
• Developed data loading workflows and custom enrichment using leading ETL tools.
• Integrated client data using Jitterbit with iTraycer, an internal application.
  Generated reports and data flows to meet client requirements using Visual Studio Data Tools.
• Created batch upload processes for Customer and Item Master data using SSIS toolbox.
• Designed and implemented databases and table structures for web applications.
• Documented and communicated database schemas using accepted notations.

Client : Oracle and Atos Singapore

• Performed Installation and configuring of various Middleware Components OIM, SOA, OHS and WebLogic application server (11gR2) in DEV, SIT, UAT and Pre-PROD environments.
• Led infrastructure projects to augment server capabilities, and address database and networking needs.
• Complied 50-page issue resolution document, addressing categorized technical issues and their best resolution methods improved support efficiency by 100%.
• Supported troubleshooting infrastructure problem as well as performance issues of Oracle SOA SuiteR2 and monitored logs of Oracle HTTP servers
• Worked closely with Project Management team to consolidate and analyze requirements to improve decision-planning process, meeting project deadlines using agile software development methodologies
• Identifying source of error/issues reported and carrying out preliminary resolution steps using various troubleshooting tools/Knowledgebase
• Generated on-demand ad-hoc reports and dynamic dashboards, presented to client for evaluation and calibration, constantly communicated with higher- level authorities
• Performed Testing on all server setup before handing it over to development team (End to end testing).