Rahul Nair
Wellington,WGN
Summary
A seasoned data architect with over 12 years of experience in designing, architecting and implementing data transformations within different industries. Specialized in using various ETL/Reporting tech stack as the key tools to develop and optimize data pipelines for operational and analytical needs. Demonstrated a proven track record of working in fast-paced, dynamic environments and delivering high-quality, reliable and scalable solutions. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.
Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
16
16
years of professional experience
5
5
Certification
Work History
Data Architect
BNZ
09.2023 - Current
- Unified disparate data structures and operating environments during revamps of processing facilities, data centers and more.
- Complied with regulatory guidelines such as CCCFA in design architecture, ensuring adherence to strict privacy and security laws.
- Complied with regulatory guidelines such as IFW in design architecture, ensuring adherence to strict privacy and security laws.
- Incorporated cloud architecture into new facility planning, reducing need for on-site equipment and technical support personnel.
- Drafted conceptual and logical data models for high-level system planning tasks, optimizing each model to customers' needs and budgets.
- Designed internal process improvements to automate repetitive tasks, shortening data delivery times.
- Automated data quality checks, data validations and data reconciliations to ensure data accuracy, consistency and completeness.
- Collaborated with cross-functional teams, including business analysts, data scientists, and software engineers, to understand data requirements and translate them into scalable data solutions.
- Created sets of pre-fabricated systems architecture models for deployment at multiple facilities across enterprise-class organizations.
- Managed end-to-end data processing, including data ingestion, data transformation, data storage, and data delivery.
- Generated detailed studies on potential third-party data handling solutions, verifying compliance with internal needs and stakeholder requirements.
- Analyzed large datasets to identify trends and patterns in customer behaviours.
- Designed and developed analytical data structures.
- Prepared written summaries to accompany results and maintain documentation.
Senior Data Engineer/Data Architect
BNZ
11.2018 - 09.2023
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Improved data collection methods by designing surveys, polls and other instruments.
- Modeled predictions with feature selection algorithms.
- Implemented randomized sampling techniques for optimized surveys.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Analyzed large datasets to identify trends and patterns in customer behaviors.
- Compiled, cleaned and manipulated data for proper handling.
- Versatile professional with strong problem-solving skills and history of adapting to diverse challenges. Applies innovative solutions and technical expertise to deliver exceptional results. Committed to streamlining processes and advancing organizational objectives.
Senior DW&BI Specialist
Westpac NZ
02.2016 - 11.2018
- Designed, architected and developed ETL data pipelines using Kafka,Informatica,Oracle and hadoop for financial reporting and analysis purposes.
- Worked on Big Data Platform using SMACK Architecture. and experienced with Hadoop,Kafka,Databricks,Scala and Python.
- Worked closely with business stakeholders to understand their data requirements and translate them into data models, data mappings and data transformations.
- Automated data quality checks, data validations and data reconciliations to ensure data accuracy, consistency and completeness.
- Demonstrated leadership skills in managing projects from concept to completion.
- Worked effectively in fast-paced environments.
Senior Consultant
EQUINIX
06.2014 - 02.2016
- Worked as an Senior Informatica/OBIEE Consultant for designing, developing, testing, troubleshooting and debugging of the business requirements
- Served as the Focal Point for the entire system development team for development and issues related with event processing modules (Stage area, Operational data Store)
- Optimized ETL processes to reduce data processing time and improve system performance. Delivering & implementing the projects as per scheduled milestones
- Handling 15 Source Systems to populate the datawarehouse.Example includes Siebel CRM, Siebel UCM, Salesforce, Singleview, Caplogix, IBX Master etc
Senior Software Consultant
HP
12.2013 - 05.2014
- Provided technical support using knowledge of complex technology to solve problems and support new projects.
- Evaluated multiple software solutions during early software architecture plotting and system migration planning stage.
- Created and maintained job schedules, workflows and dependencies
- Conducted data analysis, data profiling and data modeling to understand source data structures and identify data quality issues.
BI Consultant (Team Lead)
Deutsche Bank
08.2012 - 12.2013
- Informatica Powercentre 8.6, The ETL Common Framework Implementation project aimed at creating an ETL framework which is capable of error handling, archiving, automatic parameter file generation & status Updation of the Informatica jobs etc
- Provided technical guidance and support to team members to troubleshoot data pipeline issues
- Contributed in creating a ETL common framework which includes error handling, populating and updating common tables, Unix scripts to update status of Informatica jobs, Archive files functionality, Log files Cleanup, automation of the creation of parameter file from database etc
- Involved with the Data Modelling team and provided suggestions in creating the data model
Software System Specialist
ACS,A Xerox
02.2011 - 08.2012
- Assisted with day-to-day operations, working efficiently and productively with all team members.
- Working as an Informatica Team Lead for designing, developing, testing, troubleshooting and debugging of the business requirements.
- Conducted data analysis, data profiling and data modeling to understand source data structures and identify data quality issues.
Assistant System Engineer
Tata Consultancy Services
11.2008 - 02.2011
- Worked as an Informatica developer for designing, developing, testing, troubleshooting and debugging of the business requirements
- Managing requirement gathering, system analysis and finalization of technical / functional specifications
- Implemented data encryption and data masking techniques to ensure data privacy and security.
Education
Bachelor of Engineering -
Rajasthan University
11.2008
Skills
- System Architecture Design
- Key performance indicators
- Expertise in ETL/ Reporting and various OLTP/OLAP systems
- Cloud Architecture Design
- Software-as-a-Service Development
- Strong understanding of data modelling, data warehousing and data integration concepts
- Spark, HadoopDBT, Airflow,SSIS, Ab Initio, Informatica
- Security Protocols
- Programming : SQL,Python,SAS,Unix Scripting
- Business Intelligence
- Data Security
- Data Governance
- Security management
Certification
- Six Sigma Green Belt Certified
- Oracle Certified Associate
- Informatica S-8 PowerCenter Design Certified Associate
- IDMC Certified
- Snowflake Certified
Additional Information
- Accredited with the: On The Spot Award at workplace during Q3 year 2010.
- Client recognition Award in Q3 year 2010 Feather in the Cap Award in 2011 at workplace.
- Honored with the: 2nd prize in National Level Science Project Competition.
- Attended BARC special camp for ALL INDIA Merit holders. Various prizes at school and college level in debates and elocution.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Data Architect
BNZ
09.2023 - Current
Senior Data Engineer/Data Architect
BNZ
11.2018 - 09.2023
Senior DW&BI Specialist
Westpac NZ
02.2016 - 11.2018
Senior Consultant
EQUINIX
06.2014 - 02.2016
Senior Software Consultant
HP
12.2013 - 05.2014
BI Consultant (Team Lead)
Deutsche Bank
08.2012 - 12.2013
Software System Specialist
ACS,A Xerox
02.2011 - 08.2012
Assistant System Engineer
Tata Consultancy Services
11.2008 - 02.2011
Bachelor of Engineering -
Rajasthan University
- Six Sigma Green Belt Certified
- Oracle Certified Associate
- Informatica S-8 PowerCenter Design Certified Associate
- IDMC Certified
- Snowflake Certified
Similar Profiles
PAULINE BENSONPAULINE BENSON
UX Content Designer at BNZUX Content Designer at BNZ
Jade CheahJade Cheah
Operations Associate at BNZOperations Associate at BNZ
STEPHEN RAMSAYSTEPHEN RAMSAY
Customer Banking Specialist- Banker 1-4 at BNZCustomer Banking Specialist- Banker 1-4 at BNZ