Kalyan

6 years of professional experience in developing, designing, and deploying ETL programming and analytics solutions for multiple biotech pharmacal Proficient in SQL Server, ETL tool Mapper and Qlik sense with expertise in data mappings, data modeling’s, data integration and report generation. Expertise in developing SDTM/CDA mappings to CDISC Standards, effectively meeting the FDA approval requirements. Proficient in generating data management metric reports at study, subject, and site levels to deliver comprehensive insights and analysis. Designed, developed, and maintained complex SQL queries, stored procedures, and functions for high-performance database systems. Expertise in Elluminate tool for data mappings as per the specifications. Worked on Elluminate modules like Data sources, Importer, Mapper, Exporter, Data Central & Analytics. Strong expertise in designing and implementing SDTM domains and datasets for clinical trial data analysis and reporting. Proficient in utilizing SSMS (SQL Server Management Studio) for data mapping and manipulation. Continuously staying updated with the latest trends and advancements in data modeling and mapping technologies. Proficient in writing SQL code and optimizing database performance using techniques such as indexing, partitioning, and query optimization. Experience in working with clinical trial data management systems and software tools to facilitate data transformation and mapping to SDTM standards. Good knowledge on Dimensional Data Modeling with Snowflake and Star Schema for FACT and Dimensions Tables using identifying the trends in the data and Analysis Services. Involved in Phase 1 to phase 4 studies and delivered efficient results to clients Proficient in deploying, configuring, and managing relational databases using Amazon RDS, including popular engines such as MySQL, PostgreSQL, Oracle, SQL Server, and MariaDB. Conducted comprehensive testing of software applications, performing functional, regression, performance, and usability testing to ensure high-quality and defect-free products. Collaborated closely with cross-functional teams, including developers, business analysts, and project managers, to clarify requirements, resolve issues, and ensure smooth testing processes. Collaborated closely with internal teams, including sales, product, and customer support, to ensure alignment and seamless delivery of solutions and services to key accounts. Working experience on Software development lifecycle & Agile and Waterfall environments. Actively participated in test case review sessions, providing valuable feedback and suggestions to improve test coverage and effectiveness.