Srikanth Lanka
Sydney,NSW
Summary
17 years experience in Data & Analytics with a strong desire to exceed expectations and deliver quality solutions. I am a motivated, communicative, team-work oriented professional who feels comfortable working in an agile environment. I aspire to provide exceptional service to every unique stakeholder across the organisation while seeking critical feedback for constant improvement with a desire to learn and adapt to new technologies.
Overview
18
18
years of professional experience
1
1
Certification
Work History
IICS CDI/CAI LEAD
CAPGEMINI AUSTRALIA
07.2024 - Current
- Collaborate with Data Product Owners for prioritization of the backlog and create a delivery roadmap for the deliverables.
- Collaborate with the solution architect for re-platforming the existing VSR(Victorian Student Register) platform using an IDMC MDM solution.
- In-Depth analysis of the DoE legacy systems and documentation.
- Prepare the Solution Architecture Diagram for the Data Integration from various source systems to the target Azure data lake environment.
- Work with the Informatica product vendor team to discuss the results of the Fit-Gap analysis.
- Document the outcomes of the meetings with the vendors and schedule meetings with the client stakeholders to propose new solutions as a part of the re-platforming program.
- As a stretch initiative, learning Python programming language and preparing for certification.
- Enhanced data quality with thorough validation and cleansing techniques, ensuring accuracy in analytics reports.
- Provided expert guidance on best practices for data management, sharing insights that led to more efficient processes.
INFORMATICA DEVELOPER
LATITUDE FINANCIAL SERVICES
06.2023 - 07.2024
- Involved in all stages of SDLC from requirement gathering till production deployment and user training and production support tasks.
- Design, develop and test ETL mappings and workflows using Informatica and analyze systems for accuracy.
- Developed various mappings using transformations such as Aggregator, Lookup, Filter, Router, Joiner, Sorter and Sequence Generator transformations.
- Experienced in creating stored procedures using PL/SQL and also troubleshooting complex procedures.
- Experienced in UNIX shell scripting and troubleshooting shell scripts as a part of Incident analysis.
- Effectively used Informatica parameter files for defining mapping parameters and variables & relational connections.
- Made use of static deployment groups to migrate code from one environment to the other.
- Worked significantly with Informatica Data Quality(IDQ) tool and have developed mappings using the below transformations.
- Address Validator, Parser, Key Generator, Expression and Match Standardizer.
- Level : INFORMATICA DEVELOPER
- Business Domain : BANKING
DATA ENGINEER
BFS - MACQUARIE GROUP
01.2022 - 05.2023
- Experienced with AWS EC2 CLI commands.
- Worked on setting up the test environments by refreshing data from production on AWS EC2 environment.
- Used Bamboo pipelines to copy the Parquet files from production to the test environment.
- Performed Integration testing by triggering the DAGs in Airflow and execute test cases manually to verify the data integrity.
- Used the Talend Framework to build reference tables and also create the corresponding Airflow pipelines to load data to the tables in Hive.
- Used Stash to perform code merging.
- Participate in all sprint ceremonies – host the daily standup as per the roster, take active part in the sprint planning, backlog refinement and retro meetings.
- Level : DATA ENGINEER
- Business Domain : BANKING
SENIOR DATA ENGINEER
ING AUSTRALIA
10.2019 - 01.2022
- Work with the CJEs of Consumer Lending & Mortgages tribes to gather the data requirements and convert them to low level Informatica Design documents.
- Part of the Data Engineer Leads group that hosts weekly Cross Team Engagement(CTE) meetings for design reviews and provide feedback to adhere to the ETL design standards.
- Host the Backlog Refinement, Sprint Planning to review the product backlog and create user stories for every sprint.
- Experienced in performing detailed code reviews after the build phase to ensure coding standards are followed.
- Developed a new Collections System for the bank by closely working with the product vendor team and designing/building Informatica mappings to load Accounts, Customer & Transaction data.
- Involved in the architecture review meetings with the Enterprise Information Architects for finalising the solution design for the new Collections system.
- Experienced using Data Quality Workbench & Data Quality Server in the Informatica Data Quality tool.
- Extensively used the Workbench tool to test and execute plans, data investigation and testing of DQ methodologies.
- As a “Stretch” initiative, I am working on designing the logical data models for the Enterprise Data Warehouse by reverse engineering the existing physical models using IBM Infosphere Data Architect.
- Primary On-Call POC for troubleshooting batch failures to the Enterprise Data Warehouse (RADAR) hosted on MS-SQL Server 2016.
- Developed complex code, scripts, Extract Transform Load (ETL) mappings, stored procedures, queries, reports for critical high impact projects.
- Level : SENIOR DATA ENGINEER
- Business Domain : BANKING
Principal IT Developer - Informatica (Project Lead)
ACCENTURE, MEDTRONIC
07.2007 - 08.2019
- Performed Line Manager responsibilities for the BI tower with 30 members that included the skills – Informatica v10.x, SAP BW,SAP Business Objects & MS-Power BI.
- Held weekly meetings with the BI heads across various geographies(EMEA, APAC, Americas) to discuss and review the roadmap for the team.
- Part of the Recruitment panel for hiring Informatica developers and conducted interviews for more than 100 potential candidates in a span of 3 years.
- Design, develop, automate and support complex BI solutions using ETL & Analytics tools.
- Developed logical and physical data flow models for ETL applications.
- Excellent understanding & experience of the active and passive Informatica transformations.
- Demonstrated working knowledge of Informatica PWC 10.x and it’s equivalent databases like MS-SQL, Oracle Exadata & SAP HANA.
- Provide insights into the best practices that have to be followed in the Information Management domain.
- Maintain documentation in the form of Standard Operating Procedures(SOPs) for existing ETL processes.
- Excellent understanding of the Informatica Metadata tables to get insights into the performance of the jobs.
- Designed productivity dashboards using PowerBI to monitor team’s performance.
- Manage stakeholder communication regularly to provide key business updates about the availability of data on-time for performing analytics.
- Level : Principal IT Developer - Informatica (Project Lead)
- Team Size : 30
- Experience Range : 0-10 Years
- Business Domains : Banking, Insurance& Healthcare
Education
Bachelor's Degree - Electronics & Communication Engineering
Visveswariah Institute of Technology
Karnataka, India01.2007
Skills
- Informatica Powercenter 10X
- IICS - Cloud Data Integration
- Azure Databricks
- Microsoft SQL Server, Oracle
- SAP Business Objects
- Microsoft Power BI
- AWS S3
- Apache Airflow
- IBM Data Architect
- Python Beginner
Certification
Azure Databricks Associate Certification
CAREER HIGHLIGHTS
- Initiated and implemented the merger of the ETL & Reporting Teams which resulted in reduction of the overall team size from 16 to 12.
- Cost Saving : $125k during FY2018
- Appreciation : This project received appreciation from the Medtronic CIO.
- Encouraged and also implemented Continuous Process Improvement(CPI) initiatives which resulted in automating 30% of the manual work within the BI organisation.
- Cost Saving : $40k during financial year 2019
- Appreciation : This was appreciated by the VP, IT Shared Services
Timeline
IICS CDI/CAI LEAD
CAPGEMINI AUSTRALIA
07.2024 - Current
INFORMATICA DEVELOPER
LATITUDE FINANCIAL SERVICES
06.2023 - 07.2024
DATA ENGINEER
BFS - MACQUARIE GROUP
01.2022 - 05.2023
SENIOR DATA ENGINEER
ING AUSTRALIA
10.2019 - 01.2022
Principal IT Developer - Informatica (Project Lead)
ACCENTURE, MEDTRONIC
07.2007 - 08.2019
Bachelor's Degree - Electronics & Communication Engineering
Visveswariah Institute of Technology
Similar Profiles
Abdulrahman AldakheelAbdulrahman Aldakheel
Data Associate Manager at Capgemini AustraliaData Associate Manager at Capgemini Australia
Rakesh Kumar SudhanshuRakesh Kumar Sudhanshu
Lead Consultant at Capgemini AustraliaLead Consultant at Capgemini Australia
Vinod KomiriVinod Komiri
Adobe Experience Platform Solution Architect at Capgemini AustraliaAdobe Experience Platform Solution Architect at Capgemini Australia
Claris NgClaris Ng
Food Service Worker at Guzman Y GomezFood Service Worker at Guzman Y Gomez
Leeroy Thomas FinauLeeroy Thomas Finau
Stagehand at Seven West MediaStagehand at Seven West Media