Lathish Kulal

Project 1 -Pull Non Owned Data from Onprem to AWS(Raw Zone)

• As part of this Project I had to build data pipeline to pull the data from mainframe DB to Cloud Environment
• Data fetched from Mainframe DB is stored as CSV file's by Encrypting the PII attributes and exposed as table to Consumer Account

Technology Used: AWS Glue,Transit Gateway, S3,KMS ,Secrets Manager,AWS Lake Formation,Crawlers

Project 2 -Build the Data products for Advisory Business-SEI(Curation Zone)

• Scope of this project is to ingest the data that's sent from source and curate data as per business needs and expose it to consumer account for generation of Power BI Reports
• This is Daily advisory files and Hence had to maintain the historical data and Produce Account,Balance,Holding and Transactional Data products
• PII attributes were encrypted using KMS

Technology Used: S3, Crawlers, Lambda,KMS,AWS Glue,AWS Lake Formation,Step Function

Project 3-Build the Data products for Retirement Business-WSRS(Curation Zone)

• Scope of this projects is to build out account,balances,holding and transaction data products. Source is used push the files to Raw Account using FTP protocol, source files gets split into multiple different files and parsed as per business needs and exposed table to consecutive consumer accounts

Technology Used: S3,AWS Lambda,KMS,Step Function,Crawlers, Lake Formation,SQS ,Crawlers,AWS Lake Formation

Exposure of Business Data to Power BI(Consumption Layer)

• Scope of this Project is to Expose the data that is shared from Raw and Curate zone and Build Athena Views on top of these exposed data and Share it to Power BI
• Build Infrastructure to connect Power BI to AWS environment and Build Dataflow for the Exposed View

Technology Used: EC2, S3, SSM,AWS Lake Formation,Power BI,IAM user,Athena Views and Tables

Client - National Australia Bank

Responsibilities :

• Worked on Project that has Strict agile methodology, followed sprints and performed deployment automation and production deployments of application
• Built and developed multiple features for conformance and ingestion layer as per customer requirement
• Worked With customers, internal staff to determine planning , implementation and integration of system oriented project
• Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
• Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.
• Explained data results clearly and discussed how it can be utilized to support project objectives.
• Assisted with deployment issues by clarifying user questions and identifying problems
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Technology Used: AWS S3, Redshift,SQL,Python,Spark,Airflow,Glue,EC2,Jenkins,Github

Client - Catalina

Responsibilities :

• Managed and monitored all installed systems for highest level of availability.
• Installed, configured and maintained operating systems, application software and system management tools.
• Built and maintained network infrastructure consisting of Windows and Linux Environments
• Using TFS (Team Foundation Server) to perform build and deployments to production environment
• Provided 2nd level technical support and troubleshooting to clients.
• Increased customer satisfaction by resolving production issues.
• Well versed with process of Service request ,incident and Change Management
• Technology Used: AWS S3, Redshift,SQL,Python,EC2,ECS,Developer Tools,ECS,Linux,VPC,AWS Lamda