Siddharth Singh
Khatauli
Summary
Adept Technical Lead with a proven track record at Citiustech Healthcare Pvt Ltd, specializing in HL7 CCDA Clinical Data Integration and Data Warehousing. Excelled in optimizing ETL operations and developing complex SQL queries, showcasing strong problem-solving skills and a logical approach. Recognized for rapid relationship building and achieving significant project efficiencies.
Overview
6
6
years of professional experience
Work History
Technical Lead
Citiustech Healthcare Pvt Ltd
Bengaluru,Noida
05.2022 - Current
- Led the HL7 CCDA Clinical Data Integration (CDI) project, managing ETL operations and development with Netezza DB.
- Developed complex SQL queries, executed Linux commands, and created Datastage ETL jobs to streamline data processing.
- Extracted and transformed data from structured CCDA files (XML), flat files, and various databases for diverse project needs.
SYSTEM ENGINEER
TATA CONSULTANCY SERVICES
06.2019 - Current
- Company Overview: Working on a Data warehousing project as a Developer
- The client of this project is one of the Indian Largest Banks
- Working on a Data warehousing project as a Developer
- The technology used in the project are IBM DataStage, IBM DB2, SQL, SAP BO, SAP BI, SAP BW
- Designed DataStage series, server and parallel jobs to extract, transform and load data from various sources and archive systems like Oracle, Text files, CSV, IBM DB2 and MS SQL server into Data Warehouses
- DataStage Designer and Director to schedule and monitoring, involved in development of Job Sequencing using the DataStage Sequencer
- Optimized the existing jobs for better performance and implemented new business logic in the production environment
- Created and optimized PL/SQL queries
- Have excellent inter-personal and client interfacing skills
- Received client Appreciation for quick problem analysis and resolution
- Working on a Data warehousing project as a Developer
- The client of this project is one of the Indian Largest Banks
Education
Bachelor of Technology - Electronic and Communication Engineering
Meerut Institute of Engineering and Technology
Meerut, Uttar Pradesh01.2019
Intermediate -
Golden Heart Academy
Khatauli, Uttar Pradesh01.2015
High School -
Golden Heart Academy
Khatauli, Uttar Pradesh01.2013
Skills
- PL/SQL
- UNIX scripting
- IBM Netezza and DB2 database
- IBM Infosphere DataStage
- SVN Tortoise
- JIRA
- SAP reporting Tools
- SAP LogOn
- Logical approach
- Problem-Solving skill
- Good Decision-Making ability
- Ability to rapidly build relationship
- Setup trust
Disclaimer
I hereby declare that all the above information is true to best of my knowledge and belief.
Timeline
Technical Lead
Citiustech Healthcare Pvt Ltd
05.2022 - Current
SYSTEM ENGINEER
TATA CONSULTANCY SERVICES
06.2019 - Current
Bachelor of Technology - Electronic and Communication Engineering
Meerut Institute of Engineering and Technology
Intermediate -
Golden Heart Academy
High School -
Golden Heart Academy
Similar Profiles
SWATI S SHELARSWATI S SHELAR
Sr. Executive at CitiusTech Healthcare Pvt. Ltd.Sr. Executive at CitiusTech Healthcare Pvt. Ltd.
Yogita MoharirYogita Moharir
Software Engineer at CitiusTech Healthcare Pvt LtdSoftware Engineer at CitiusTech Healthcare Pvt Ltd
Muzammil PeerzadeMuzammil Peerzade
Senior Technical Engineer at CitiusTech Healthcare Pvt LtdSenior Technical Engineer at CitiusTech Healthcare Pvt Ltd