NITISH KUMAR
NEW DELHI
Summary
Dedicated and adaptable BI/ETL professional with a proactive attitude and the ability to learn quickly. Strong work ethic and effective communication skills. Eager to contribute to a dynamic team and support organizational goals.
Overview
2
2
years of professional experience
Work History
Intern
RIA ADVISORY LLP.
PUNE
02.2023 - 04.2023
- Completed ORMB functionality and basic reporting training, gaining proficiency in reporting SQLs, packages, and their applications.
- Conducted data mapping activities to analyze scripts, interpret data flows, and improve comprehension of underlying logic.
- Generated CSV files using ETL processes, ensuring accurate data extraction and formatting.
Junior Software Development Engineer (SDE-1)
RIA ADVISORY LLP.
Pune
07.2023 - Current
- Used reporting tools like Power BI and Cognos for data testing, resolving discrepancies, and ensuring data accuracy.
- Monitored and supported ETL processes for the Cigna project, troubleshooting SQL issues, and optimizing data workflows.
- Gained foundational shell scripting skills while supporting ETL operations.
- Updated and optimized ETL jobs using Talend Open Studio, implementing auto pick-up logic for month-end audit failures to enhance workflow automation and efficiency.
- Created and maintained documentation, such as Source-to-Target mappings, ensuring alignment with business requirements and data transformation clarity.
- Fine-tuned Source Qualifiers to enhance performance and testing efficiency.
- Developed index drop-and-rebuild logic for three critical fact tables, improving ETL job performance, and streamlining data processing.
- Learned and applied new tools such as Dremio (reflections for query optimization), Superset (dashboard creation), and DBT (data transformation).
Education
Higher Secondary - PCM
R. K. MEMORIAL SR. SEC. SCHOOL
SONIPAT, HR05-2019
Bachelor of Engineering - ELECTRONICS & TELECOMMUNICATIONS
ARMY INSTITUTE OF TECHNOLOGY
PUNE, MH07-2023
Skills
- COGNOS Reporting
- Superset Reporting
- PowerBI Report Builder
- Data warehousing concepts
- SQL proficiency
- Data integration
- Talend Open Studio
- Dreamio
- ETL development
- Social skills
Timeline
Junior Software Development Engineer (SDE-1)
RIA ADVISORY LLP.
07.2023 - Current
Intern
RIA ADVISORY LLP.
02.2023 - 04.2023
Higher Secondary - PCM
R. K. MEMORIAL SR. SEC. SCHOOL
Bachelor of Engineering - ELECTRONICS & TELECOMMUNICATIONS
ARMY INSTITUTE OF TECHNOLOGY
Similar Profiles
Shashank PandeyShashank Pandey
Principal Consultant at RIA Advisory LLPPrincipal Consultant at RIA Advisory LLP
Santosh IndeSantosh Inde
Principal Consultant- Treasury and Banking at RIA Advisory LLPPrincipal Consultant- Treasury and Banking at RIA Advisory LLP
Brent Timothy UtanaBrent Timothy Utana
Lead Software Support Analyst at RIA AdvisoryLead Software Support Analyst at RIA Advisory