Prasanth Reddy Yerram Email and Phone Number
Prasanth Reddy Yerram is a distinguished Senior Software Development Engineer with over 10 years of IT experience across various domains, including Insurance and Healthcare. He possesses an extensive knowledge in software design, analysis, development, testing, and support, with a keen focus on coding, production support, testing, implementation, and the documentation of information systems. His understanding of data extraction, transformation, and loading from source to target systems like SQL server, excel files, and flat files using SQL Server 2008/2012/2016/2019 Integration Services, sets him apart.His tenure at Cigna and Molina Healthcare showcases his skills in various migration/upgrade projects, ranging from enterprise SQL Azure upgrade to QNXT/Networx Modeler version upgrade. Prasanth also has a strong foundation in SQL, with experience in writing SQL statements, complex queries, sub queries, joins, stored procedures, triggers, views, performance tuning, and functions in SQL Server.His work within the Healthcare sector, interacting with components such as QNXT, Networx Modeler, EDI Processes, Optum Easy Group, and Optum Rate Manager, has honed his domain-specific expertise. Prasanth's technical prowess is also displayed in his hands-on experience with Microsoft SQL Server, Microsoft SQL Server Management Studio, T-SQL, Microsoft Business Intelligence Tools (SSIS, SSRS, and SSAS), Microsoft Power BI, Qlik Business Intelligence, Autosys, Azure DevOps, GIT, TFS, Microsoft Visual Studio, Biztalk, C#.NET, ASP.NET, XML, HTML, CSS, JavaScript, Biztalk, MS Office 365, Snowflake, Azure Cloud, and Azure Databricks SQL.Prasanth's approach to problem-solving involves both proactive and reactive troubleshooting, ensuring seamless data interchange between companies and business partners. As a strategic team player, Prasanth is effective in providing support to other team members in issue resolution, stakeholder communication, and achieving support availability in accordance with SLAs.His work ethic is also demonstrated in his commitment to incident and problem management processes, with proven experience in performing root cause analyses to identify and solve processing problems, implement corrective actions, and communicate resolutions to end users and stakeholders.
-
Senior Software EngineerCigna HealthcarePhoenix, Az, Us -
Senior Software EngineerStrategic Staffing Solutions Oct 2022 - PresentDetroit, Mi, UsProject Names: AEP Support, Member Services• Gathering requirements from business for Member Enrollment changes and development, as well as data extraction from QNXT and other applications related to QNXT product.• Identifying the gaps, planning and prioritization of tickets, identifying any defects or enhancements and review of documentation by organizing discussion with the relevant user.• Extensively working in data Extraction, Transformation and Loading from source to target system like SQL server, excel files and flat files using SQL Server 2008/2012/2016/2019 Integration Services.• Respond to the assigned issues, conduct analysis of the issues, identify and evaluate different workarounds/ solution alternatives and implement the most optimal solution.• Provide support to other team members on issue resolution in areas of expertise as required, manage stakeholder communication and close the issues assigned to ensure support availability as per agreed SLAs.• Involved in analysis and ongoing enhancements, maintenance of the outbound system to increase processing efficiency.• Experienced in incident and problem management processes by performing root cause analysis to identify processing problems, implement corrective action and communicate resolution to end users and stakeholders.• Handle incidents reported via iServe tool within the SLA for any outbound extract related issues.• Setting up AUTOSYS Job in Development and testing the Job• Created Config files and batch files for executing packages in AutoSys jobs server.• Well communicated with the business and assist immediately with all the required reports.• Documenting process and procedure for the known and new upcoming issues, in order to have it updated on a shared knowledgebase for all other employees.• Working with GIT and Azure Devops for deployment, deployment, and version control. -
Software EngineerInfinite Computer Solutions Jan 2020 - Sep 2022Rockville, Maryland, UsProject Names: SSIS Azure Upgrade, Provider Services, Database Compatibility Upgrade, ODS Azure Migration, and Network Pricing and Analytics• Build and design powerful SSIS packages to load the data into data warehouse and ODS from various inbound files and databases.• Worked on many upgrade projects like QNXT, ODS and Networx Modeler etc.• Responsible for development and maintenance of SQL Server objects like stored procedures, views and tables.• Build and design interactive dashboards with key business metrics such as Top-20 hospitals pricing and Attach rate for internal stakeholders.• Support and upgrade the COTS (commercial off-the-shelf) like Cognizant Trizetto Networx Modeler application, QNXT and Optum webservices.• Responsible for development and maintenance of hospital comparison dashboard with above 3 billion records.• Lead offshore ETL team and guide them in designing the new analytics dashboards.• Perform gap and impact analysis to implement new requirements.• Responsible for Database optimization by creating indexes and improve the legacy databases processes.• Working experience with SSIS package deployment lifecycle in SSIS catalog.• Scheduling reports for monthly reports for executives and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).• Gathering requirements from business for Encounter outbound changes and development, as well as data extraction from QNXT and other applications related to QNXT product.• Identifying the gaps, planning and prioritization of tickets, identifying any defects or enhancements and review of documentation by organizing discussion with the relevant user.• Knowledge on SQL Queues and automation of the ETL jobs using the SQL Queues.• Worked on different EDI healthcare transactions like 274 for submitting provider related data on monthly bases. -
Lead Sql/ Bi EngineerInfosys Jun 2016 - Dec 2019Bangalore, Karnataka, InProject Names: SSIS Azure Upgrade, Provider Services, Database Compatibility Upgrade, ODS Azure Migration, and Network Pricing and Analytics• Build and design powerful SSIS packages to load the data into data warehouse and ODS from various inbound files and databases.• Worked on many upgrade projects like QNXT, ODS and Networx Modeler etc.• Responsible for development and maintenance of SQL Server objects like stored procedures, views and tables.• Build and design interactive dashboards with key business metrics such as Top-20 hospitals pricing and Attach rate for internal stakeholders.• Support and upgrade the COTS (commercial off-the-shelf) like Cognizant Trizetto Networx Modeler application, QNXT and Optum webservices.• Responsible for development and maintenance of hospital comparison dashboard with above 3 billion records.• Lead offshore ETL team and guide them in designing the new analytics dashboards.• Perform gap and impact analysis to implement new requirements.• Responsible for Database optimization by creating indexes and improve the legacy databases processes.• Working experience with SSIS package deployment lifecycle in SSIS catalog.• Scheduling reports for monthly reports for executives and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).• Gathering requirements from business for Encounter outbound changes and development, as well as data extraction from QNXT and other applications related to QNXT product.• Identifying the gaps, planning and prioritization of tickets, identifying any defects or enhancements and review of documentation by organizing discussion with the relevant user.• Knowledge on SQL Queues and automation of the ETL jobs using the SQL Queues.• Worked on different EDI healthcare transactions like 274 for submitting provider related data on monthly bases. -
Software EngineerIt America Inc Jan 2016 - May 2016Edison, Nj, Us• Developed web applications in ASP.NET, jQuery, HTML and CSS. Maintained legacy websites written in C#/VB.NET.• Developing, testing and deploying SSRS reports to production environments• Developed Data Express to move data/files/images around the company provided by customers.• Designed and wrote complex T-SQL scripts, stored procedures, functions, Triggers, Views and packages in SQL Server 2008 and indexes for optimum performances.• Migrated version control from on premise TFS to VS Team Services (VSTS)• Wrote Unit tests for all the applications developed to ensure code is bug free.• Performed peer-peer code reviews, advised code optimizations.• Worked with MVC architecture.• Working experience on SSAS cubes and determining the measures and dimensions.• Responsible for SSIS package development and support. -
Software EngineerData Pro Technologies Jun 2013 - Dec 2014• Analysis of the specifications provided by the clients.• Involved in requirement gathering, functional and technical specification.• Used N-tier architecture for presentation layer, Business and Data Access Layers using C#.• Coding and debugging using ASP.NET and C#.• Developed dynamic ASPX web pages using ASP.NET, C#, HTML5 and JavaScript.• Developed web forms using ASP.NET server controls and validated client side using Java Script.• Used ADO.NET objects such as Data Adapter, Data Reader and Dataset for consistent data access.• Writing Database routines, stored procedures and fixing up standard specifications.• Worked with SQL Server 2008 in creating tables, indexes and stored procedures.• Creating reports using the Crystal Report.• Identified researched, investigated, analyzed, defined and documented business processes.• Involved in enhancing the business layer to provide more interfaces and functions needed for the system.• Developed complex stored procedures, functions and view based on the business requirements.
Prasanth Reddy Yerram Education Details
-
University Of The Cumberlands Graduate And OnlineComputer Science -
University Of Central MissouriComputer Science
-
Jawaharlal Nehru Technological UniversityElectronics And Communications Engineering
Frequently Asked Questions about Prasanth Reddy Yerram
What company does Prasanth Reddy Yerram work for?
Prasanth Reddy Yerram works for Cigna Healthcare
What is Prasanth Reddy Yerram's role at the current company?
Prasanth Reddy Yerram's current role is Senior Software Engineer.
What schools did Prasanth Reddy Yerram attend?
Prasanth Reddy Yerram attended University Of The Cumberlands Graduate And Online, University Of Central Missouri, Jawaharlal Nehru Technological University.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial