Home

Sravan - Sr . Data Engineer

[email protected]

Location: Seatonville, Illinois, USA

Relocation:

Visa: H1B

Sravan Kumar Puli SR Data Engineer Email : [email protected] Phone : +1 630-228-9396 Linkedin : linkedin.com/in/ramasai-jannu-ba30b724a Professional Summary Experienced data engineer with 8 years of expertise in data engineering and data management. Proficient in designing and implementing robust ETL solutions, data integration, and database development. Skilled in programming languages such as SQL, Scala, and Python, with expertise in RDBMS and distributed data systems. Adept at building direct interfaces to healthcare systems and ensuring compliance with industry standards, including HL7, C-CDA, and FHIR. Proven track record in improving process efficiency, enhancing data quality, and driving customer satisfaction. Committed to maintaining data privacy and governance standards while delivering innovative solutions. Collaborative team player in Agile/Scrum environments. Master's degree in information technology with a strong foundation in engineering. Technical Skills Database Technologies : SQL Server, PostgreSQL, MySQL, AWS S3, Azure Blob Storage, ArangoDB Programming Languages : C#, SQL, Scala, Python, Java Data Analytics Tools : Power BI, SSRS, SSAS Distributed Data Systems : Hadoop, Hive, Apache Spark, NiFi, HBase Academic Qualifications: Master of Science in Information Technology, Arkansas Tech University. Bachelor of Technology in Engineering. PROFESSIONAL EXPERIENCE Role : SR Data Engineer Location : Ann Arbor, MI Client : ArborMetrix, Inc. June 2021 Present Key Responsibilities: Participating in the design, implementation, and validation of a scalable Data Integration Engine, ensuring the production-quality, real-time interfaces. Collaborated closely with data scientists to design and implement data pipelines for predictive analytics. And worked in cross-functional teams, including product owners and customer success managers, to gather requirements and deliver data-driven solutions. Developed and maintained robust ETL solutions to seamlessly integrate diverse healthcare data feeds, utilizing Apache NiFi, PostgreSQL, YAML, and Python. Implemented direct interfaces for hospitals and EMR vendors, adhering to industry standards (HL7 2.x, C-CDA, FHIR), and creating custom interfaces for various data formats (XML, JSON, delimited). Supported interfaces between ArborMetrix and EMR systems like Valant and Medent, employing FHIR-based data structures. Proactively monitored and managed ETL processes to consistently meet SLAs, resolving issues promptly. Wrote SQL functions and packages to automate workflows in a Postgres environment, tightly integrated with web technologies. Contributed to infrastructure management, capacity planning, and data retention policy implementation. Ensured strict compliance with data standards, including HIPAA, while documenting work processes and driving product and process improvements. Environment: PostgreSQL, AWS S3, Apache NiFi, YAML, Python, FHIR. Role : Data Conversation Specialist Location : Elgin, IL Client : HEF Solutions - Acquired by MediQuant, LLC. Arp 2019 May 2021 Key Responsibilities: Led the maintenance and implementation of Data Conversions, Integrations, and ETL Development for EMR/EHR Systems. Extracted, transformed, and loaded discrete clinical and practice management data from diverse EMR systems into MS SQL Server databases, supporting the PatientArchive web application. Independently managed over 30 EMR/EHR data conversion projects, meticulously ensuring data integrity and format compliance. Oversaw the deployment and maintenance of Azure Blob Storage accounts to securely store clinical and patient documents, as well as scanned images. Skillfully identified, converted, and reviewed data from more than 20 different legacy EMR/EHR system databases, including Allscripts SCM, Clarus, eCW, Greenway Prime suite, and others. Created HL7 and CCD messages/files for the seamless integration of clinical and practice management data across various EMR systems, including EPIC. Successfully executed the merging of patient data from multiple EMR systems, guaranteeing data consistency and accuracy. Established the archive and environment setup for EMR data conversions and integrations. Developed high-level SQL queries to perform data conversions and ETL processes with high performance. Conducted thorough reviews of completed conversions, analyzed data, and ran data integrity checks. Offered expert support to clients and users in addressing any conversion-related issues, both before and after the final conversion load. Consistently identified and implemented opportunities for process enhancements, leading to improved work performance and heightened customer satisfaction. Designed and executed a quality enhancement process, resulting in a remarkable 75% efficiency boost. Environment: Azure SQL, Azure Blob Storage, EMR/EHR, HL7, CCD, Healthcare IT, Data Conversions, Integrations. Role : Information services Intern Location : Lowell, AR Client : J. B. Hunt Transport Services, Inc. Dec 2017 Apr 2019 Key Responsibilities: Facilitated the organization's Information Governance efforts by overseeing day-to-day database operations, including maintenance, monitoring, backup, and recovery. Collaborated with compliance and legal teams to define data masking and retention policies and executed retirement procedures, ensuring the protection of sensitive fields and data. Implemented security best practices to secure, maintain, and provide controlled access to archived and test data. Coordinated with cross-functional teams to ensure the successful execution of backup, archiving, and data retrieval processes. Synchronized database catalogs with the information governance system, leveraging agile methodologies to design data archives, purge procedures, and test data processes within Optim Designer for production databases. Conducted comprehensive data analysis to identify Personally Identifiable Information (PII), Protected Health Information (PHI), and financial data, facilitating the implementation of data masking techniques. Efficiently extracted subsets of production data and loaded them into test/dev environments, simplifying test data management. Environment: MS SQL Server 2014/2016, SSIS, IBM Infosphere Optim 11.3.0, MS Excel, SSRS, TFS. Role : Graduate Assistance Location : Russellville, AR Client : Arkansas Tech University Jan 2016 Jan 2017 Key Responsibilities: Provided input in the development of system wide programs that enables students to use the latest technology as learning tools. Installed and trained the employees on new technologies and electronic devices. Offered technical support for audio, video, networking devices, and software tools. Keywords: cprogramm csharp business intelligence sthree information technology microsoft Arkansas Illinois Michigan