Elice Das
Bangalore
Summary
Professional Senior Data analyst with overall 6 years of working experience with ETL concepts, building ETL solutions and Data Integration. Pursuing Masters in Business analytics from Bits Pilani under a Work intergrated learning programme. Experience in developing data ingestion, data processing and analytical pipelines for big data, relational databases and data warehouse solutions. Experience in Developing workflows using Knime analytics tool - SQL for data extraction, python for generating Output files transformation and aggregation from multiple file formats , excel formulas for analyzing & transforming the data to uncover insights into the customer usage patterns. Expertise in supporting PROD and UAT testing and development scenarios Expertise in various phases of project life cycles (Design, Analysis, Implementation and testing). Excellent communication skills with excellent work ethics and a proactive team player with a positive attitude Created Project in Microsoft Power BI determining the cost of products with different visualizations charts
Overview
7
7
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
Infosys
Bangalore
07.2023 - Current
- Remediate regulatory reports in KNIME using Native knime nodes, Config file approach, Python and configuration approaches.
- Handle complex excel logics such as pivots, iferror, data validation, graphs, vlookups, hlookups, joins, average, Index Match, Variable output file name, Dynamic reports generation, file-name extension , Multi-stage task using single workflow .
- Develop User controlled workflows in Knime based on flow variable or widgets
- Develop statistical insights regarding the bulk dataset and other data mining concepts.
- Develop graph using Knime and paste it in Excel format for view
- Create automated KNIME workflows to streamline processes and improve efficiency.
- Provide users with Excel output tailored to business logic and requirements.
- Develop and execute comprehensive test plans and strategies, ensuring alignment with business and technical requirements.
- Collaborate with business analysts and stakeholders to translate requirements into testable scenarios and document them effectively.
- Coordinate and facilitate ST, SIT, and UAT activities, managing defects and risks to ensure timely resolution and validation.
- Lead automation efforts to streamline testing processes, increase coverage, and reduce manual effort.
- Communicate testing status, progress, and risks to stakeholders, providing insights on the impact of technology changes on business operations.
- Integrated Knime workflow with Appian(ACS) tool and scheduling workflows and running it on appian server .
Knime Developer
Global Market Ltd
Mumbai
12.2020 - 04.2022
- Project Name - LRR TRANSISTION - SYBASE EXIT
- Start date - 01/12/2020
- End date – 01/04/2022
- Role – Knime Developer - Global Market Ltd Banking and Financial firm.
- Key Responsibilities - The role required in this project is to analyze the requirement from the Client and code in the Oracle SQl server with the existing DATA and Frontend sybase server.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Maintained complex SQL queries, views and stored procedures in multi-database environment with little supervision.
- Developed, implemented and optimized stored procedures and mapping functions using SQL and Knime analytics tool.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
- Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing.
Data Engineer
LTI
Mumbai
07.2018 - 03.2022
- Project Name - CTO Finance Reginsight - EMEA
- Start date - 01/11/2018
- End date - 02/02/2022
- Role – Rules Writer Client – Banking Global Market Ltd (CGML) -
- Description: Local Regulatory Reporting Initiative also called as Reginsight is aimed at establishing global standardized platform for CITI's Regulatory Reporting
- It is based on product wise Data Models that derive the input feeds from Genesis Source which receives Product Processor data
- The purpose of the Project is to automate these reports submitted by CGML to EBA
- The reports mainly involve area of Capital Adequacy, Credit Risk, Large Exposure, Leverage Ratios and Market Risk on its financial products.
- The medium of creating reports is Strategic Reginsight Application.
- Created procedures for system monitoring, recovery, backup and optimization.
- Reviewed project specifications and designed technology solutions that met or exceeded performance expectations.
Senior Data Engineer
LTI
Mumbai
02.2022
- Project Name - LRR TRANSISTION - SYBASE EXIT
- Start date – 01/04/2022
- End date - Till date
- Role – Knime ETL Developer – Banking and Financial Firm
- LTI, Mumbai, Maharashtra
- Designed compliance frameworks and workflows for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines using Knime analytics tool
- Developed workflows as per the business logic integrating transactional data through Oracle sql database and incorporating business logic through stored procedures.
- Develop visualization graphs and charts as per the business data and requirement.
- Developed, implemented and maintained data analytics protocols, standards and documentation.
- Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
- Analyzed Prod and Uat issues through Jira process
Education
Masters - Msc in Business analytics
Birla Institute of Technology, Pilani
Pilani05-2025
Bachelor of Technology - Electrical And Electronics Engineering
CMR Institute Of Technology
07.2018
Skills
- Knime analytics tool
- Oracle SQL
- Python
- R
- Power BI
- Tableau
- Statistics
- Predictive analytics
- Orange Software
- Appian( ACS)
- Data transformation
- Jira
- ETL
Certification
- L1- Basic proficiency in Knime analytics tool
- L2- Advanced proficiency in Knime analytics tool
- Brainbench in SQL
Personal Information
Title: Senior Data Engineer
Timeline
Senior Data Analyst
Infosys
07.2023 - Current
Senior Data Engineer
LTI
02.2022
Knime Developer
Global Market Ltd
12.2020 - 04.2022
Data Engineer
LTI
07.2018 - 03.2022
Masters - Msc in Business analytics
Birla Institute of Technology, Pilani
Bachelor of Technology - Electrical And Electronics Engineering
CMR Institute Of Technology
Similar Profiles
Ved ShuklaVed Shukla
Senior System Engineer at InfosysSenior System Engineer at Infosys
ASMITA KULKARNIASMITA KULKARNI
Consultant at InfosysConsultant at Infosys
Akshat YadavAkshat Yadav
Technology Lead-US at InfosysTechnology Lead-US at Infosys