About Me
11 years of experience as a Data Warehouse and Data Migration lead. Experience consists of understanding the requirement and changes in the application and implementing them as per business needs. Good interpersonal and …
11 years of experience as a Data Warehouse and Data Migration lead. Experience consists of understanding the requirement and changes in the application and implementing them as per business needs. Good interpersonal and communicational skills.
Experience
<p>Worked on client locations (UK, Dubai and France) for 1 year each while working with Infosys for 11 years.</p>
Technology Analyst
<p>Part of BI team that analyzes, designs, and implements snowflake/Star schema in the target database.<br>
Translating business requirements into technical solution.<br>
Configuring and customizing data-store connections<br>
Optimizing SAP BODS jobs and also making sure that the existing jobs are efficient enough.<br>
Developing necessary modifications to the existing objects.<br>
Managing the support team.<br>
Proactively learning new BI technologies.<br>
Client facing role and had regular meetings to understand the requirements and update on the status.<br>
Monitoring of BODS jobs and taking action based on the error status.</p>
Technology Lead
<p>Analyzed functional design documents for technical feasibility.<br>
Understanding business process and draft technical design documents based on the functional documents.<br>
Develop, test and support customer facing Documents/Mappings using BODS.<br>
Code walkthrough with the team lead on a regular basis.<br>
Test, review code and documentation for the deliverables designed and developed by the team.</p>
Technology Lead
<p>Migration of database from MySQL to Snowflake data warehouse.<br>
Extraction code was written in Python.<br>
Transformations were performed using DBT</p>
Technology Lead
<p>Creating data pipeline using AWS<br>
Extracting data from SAP HANA.<br>
Loading the source data into S3 buckets and then performing transformations using AWS Glue.<br>
Loading target data into Redshift and performing reports in Tableau.</p>
Technology Lead
<p>Creating Calculation Views on top of SAP HANA tables.<br>
Accessing SAP HANA CVs in SAP Analytics cloud<br>
Creating connection<br>
Creating Models in SAC to perform Dashboard and Planning capabilities.</p>
Technology Lead
<p>Loading data from Oracle into Snowflake using DBT<br>
Managing Load pipelines<br>
Loading extract from Oracle into S3 bucket.<br>
Loading files from S3 into Snowflake<br>
Maintaining DBT code based on issues raised by customer<br>
Ensuring data compatibility.</p>
Lead Data Analyst
Working with multiple clients to ensure end to end delivery of ETL / Data Warehouse/ Data Migration projects., Leading a team of technical resources to validate and support deliveries., Ensuring timely delivery and getting all the issues resolved.