KAVINILAVU VINOTHA RAJAN
Mississauga,ON
Summary
With over 7 years of experience as a .NET application developer, I have extensive experience leveraging Python within SSIS ETL processes, enhancing my ability to extract, transform, and load data with efficiency and precision. I have a proven track record of working autonomously and proactively, ensuring meticulous attention to detail and delivering high-quality results aligned with project requirements. My adept problem-solving abilities enable me to tackle technical hurdles with innovation, particularly within the .NET development landscape, while seamlessly integrating Python into SSIS workflows to optimize data processing and analysis.
Overview
13
13
years of professional experience
Work History
ETL Developer (SSIS | Python | Mirth Connect))
Cognizant Technology Solutions Canada Inc.
Mississauga, ON
02.2022 - Current
- Utilize Python within SSIS Script Task to transform healthcare claim data, including parsing, cleansing, and standardizing claim information for accurate processing.
- Implement Python Script Component in SSIS Data Flow to integrate provider and member data from various sources into the target system, ensuring consistency and completeness of information.
- Leverage specialized Python libraries for healthcare data processing, such as pandas for handling structured data and numpy for numerical computations, to enhance the accuracy and efficiency of ETL processes.
- Develop Python scripts to perform custom data cleansing and enrichment tasks within SSIS packages, ensuring the quality and integrity of healthcare claim, provider, and member information throughout the ETL pipeline.
- Integrate Python's advanced analytics capabilities into SSIS workflows to analyze healthcare claims data, including trend analysis, cost forecasting, and outlier detection, providing valuable insights for decision-making and risk management.
- Implement Python-based logging and error handling mechanisms within SSIS packages to ensure compliance with healthcare regulations and standards, such as HIPAA, by maintaining detailed audit trails and managing exceptions effectively.
- Utilize Python scripts to integrate healthcare systems and external APIs with SSIS, enabling seamless data exchange and interoperability between different healthcare IT systems, such as EMRs and payer portals.
- Harness Python's multi-threading or multiprocessing capabilities to parallelize data processing tasks within SSIS packages, optimizing the performance and scalability of healthcare claim and provider/member file loads, especially for large datasets.
- Customize SSIS ETL processes using Python to accommodate healthcare-specific data models and requirements, such as HL7 for interoperability or ICD-10 coding standards, ensuring compatibility and consistency across systems.
.NET Applications Developer
Cognizant Technology Solutions India Pvt Ltd.,
Chennai, Tamil Nadu
07.2011 - 05.2016
- Developed landing pages, dashboards, and web applications utilizing ASP .NET, C#, HTML, and XML programming languages.
- Demonstrated proficiency in SQL Server Database, including T-SQL queries, stored procedures, triggers, views, and job management within SQL Server 2008.
- Proficient in programming and testing web applications, SSIS packages, and distributed applications.
- Conducted troubleshooting, testing, and resolution of issues prior to software deployment.
- Generated comprehensive documentation throughout the software development lifecycle.
- Provided technical design impact assessment documentation for proposed software projects, including detailed analyses of cost, time-to-completion, and ROI metrics.
- Possessed proficient knowledge of ticket tracking tools for issue management.
- Possess good work ethics with excellent communication and interpersonal skills and ability to succeed individually and as a team.
Education
Master of Engineering - Applied Electronics
SSN College of Engineering
06.2011
Bachelor of Engineering - Electronics and Communication
Sengunthar Engineering College
05.2009
Skills
- SSIS, Mirth Connect, SQL
- Python, NumPy, Pandas
- ASP NET, ADO NET
- C#, HTML, XML, CSS, jQuery
- GitHub, Team City, Octopus Deploy
- Database development, database design
- Data mapping, ETL processes
- Performance tuning, troubleshooting, debugging
- Strong problem-solving skills, attention to detail, and ability to work independently or as part of a team
Timeline
ETL Developer (SSIS | Python | Mirth Connect))
Cognizant Technology Solutions Canada Inc.
02.2022 - Current
.NET Applications Developer
Cognizant Technology Solutions India Pvt Ltd.,
07.2011 - 05.2016
Master of Engineering - Applied Electronics
SSN College of Engineering
Bachelor of Engineering - Electronics and Communication
Sengunthar Engineering College
Similar Profiles
Agnibha RoyAgnibha Roy
Lead System Architect at Cognizant Technology Solutions- CANADALead System Architect at Cognizant Technology Solutions- CANADA
Manojkumar BalamuruganManojkumar Balamurugan
Senior Associate at Cognizant Technology Solutions Canada Inc.Senior Associate at Cognizant Technology Solutions Canada Inc.
AARTHI KANNAIAH PAULRAJAARTHI KANNAIAH PAULRAJ
Service Desk Team Lead at Cognizant Technology Solutions Canada IncService Desk Team Lead at Cognizant Technology Solutions Canada Inc