Summary
Overview
Work History
Education
Skills
Professional Highlights
Technologies
Training
Timeline
Generic

Venkata Naga Turlapati

Senior Software Engineer
Warrington,PA

Summary

Seasoned Senior Software Engineer adept at talented at providing customized and optimized solutions for all needs. Remarkable relationship building, decision making and communication skills. Known for best-in-class development and applying agile development strategies.

Overview

12
12
years of professional experience
5
5
years of post-secondary education

Work History

Senior Software Engineer

Optum (United Health Group)
3 2019 - Current
  • Demonstrated expert proficiency in Cognos Analytics Suite (11x/10x/8x), including Transformer, Framework Manager, Report Studio, Query/Analysis Studio, Workspace Advanced, Data Modules, and Dashboards.
  • Designed intricate financial reports with drill-down capabilities for thorough financial analysis. Automated report FTP processes with Linux/Unix shell scripts, integrating seamlessly with Cognos Analytics.
  • Managed diverse databases like Oracle, IBM DB2, and MS SQL Server proficiently. Led successful end-to-end R12 upgrade, customizing modules and interfaces for improved functionality.

EBS Functional Developer

Optum (United Health Group)
12.2017 - 3 2019
  • Designed, developed, tested, deployed, and supported Oracle Applications and Web Applications using SQL, PL/SQL, Adobe Flex, Unix, and Java/JSP.
  • Evaluated requirements, provided LOE estimates, contributed to design proposals, and troubleshooted data integrity and production defects. Enhanced and supported Sales Loads, Billing Gateway, and Gift card processes using web methods, UNIX scripts, and Pl/SQL. Conducted a walkthrough on the Treasury Report of Receivables and prepared Functional Design documents for the IPAC process.
  • Regularly interacted with functional teams and clients to resolve critical AR, AP, PO, GL, and Fed Admin issues. Enhanced and maintained production processes, supported day-to-day issues related to the Contact center form in Oracle applications service contracts module, and managed registration of Concurrent programs.

System Integration Specialist

Optum (United Health Group)
03.2015 - 12.2017
  • Designed and developed a custom report to identify discrepancies in Purchase Orders, requisitions, and invoices between the third-party system (CPSS) and Oracle Applications (FMSS), enhancing data accuracy and reconciliation processes.
  • Developed scripts in AP, PO, and GL modules to rectify discrepancies in production data caused by user actions and customizations, maintaining data integrity and system accuracy.
  • Customized and developed reports and forms, including the Award Financial History Report and vendor 1099 form, tailored to meet specific financial reporting requirements.
  • Utilized FND_LOAD for migrating concurrent programs, value sets, Concurrent Managers, Context-Sensitive DFF, Profile Options, and Form Personalization’s, ensuring smooth system transitions and configurations.

Migration Analyst

ConocoPhillips
2 2014 - 3 2015
  • Lead Migration Analyst spearheading the transition from SharePoint 2003 to 2013, ensuring a smooth and efficient migration process.
  • Developed intricate SQL scripts leveraging Oracle functions to validate backend data and collaborated closely with the ETL group to understand mappings for dimensions and facts, ensuring data accuracy and completeness.
  • Setup and configured SharePoint services on servers, performed maintenance on web front-end servers, indexing servers, and database servers to ensure system stability and performance.

SharePoint Administrator

State Farm Insurance
06.2012 - 12.2013
  • Managed and maintained SharePoint sites/servers and permissions for proper access control and system stability. Oversaw capacity planning and performance control for optimal service level.
  • Tested Informatica mapping logic for data integrity in ETL processes.
    Utilized Oracle SQL developer tools for efficient querying in Informatica and Teradata. Conducted Crystal Reports testing to validate report accuracy against data warehouse.
  • Configured load balancers and conducted backups for system reliability. Implemented ECM workflows and document management for content organization.


SharePoint Developer

Zurich North America
02.2012 - 05.2012
  • Played a pivotal role in the full Software Development Life Cycle (SDLC), ensuring seamless project execution from inception to deployment. Led the migration from MOSS 2007 to SharePoint 2010, ensuring data compatibility and smooth transition.
  • Designed and implemented UNIX shell scripts for efficient data loading and testing in the ETL process. Contributed to agile development using Scrum methodology, aiding rapid project delivery.
  • Developed complex SQL queries and PL/SQL procedures for Cognos Reports validation, ensuring data accuracy. Utilized Informatica tools extensively for data extraction and loading into a centralized repository.

Education

Master of Science - Computer And Information Sciences

Texas A&M University - Commerce
Commerce, TX
08.2010 - 12.2011

Bachelor of Science - Computer Engineering

JNT University
Hyderabad, India
06.2005 - 05.2009

Skills

    Problem-solving mindset

undefined

Professional Highlights

Highly competent Senior Software Engineer with a strong dive, boasting 12 years of experience spearheading the design, development of large-scale software solutions and deploying intuitive solutions to meet enterprise-wide business needs. Proficient in a diverse range of programming languages, tools, and technologies, with advanced problem-solving capabilities to lead the delivery of top-notch products. Strong proponent of innovative and constructive collaborative approaches to work with cross-functional teams, fostering healthy communication to drive successful outcomes and changes that are in line with business goals. Successful demonstration and consistent track record of using agile methodologies, actively contributing to iterative development cycles, sprint planning, and efficient project delivery while ensuring the highest quality standards. Exceptional skills in managing intricate projects involving large and complex data juggling multiple timelines. Strong believer of continuous learning to proactively initiate and direct business changes to streamline processes.

Technologies

SharePoint 2013, SharePoint Server 2010, MOSS 2007, SharePoint Portal Server 2003, Microsoft SharePoint Foundation 2010/WSS3.0/WSS2.0, Microsoft SharePoint Designer 2010/2007, Microsoft InfoPath 2007/2010, Windows NT/98/2000/7,10, MS-DOS, Windows Server 2008 R2, Oracle 11g/10g/9i/8i, SQL Server 2005, Teradata, MySQL, Informatica 9.1.0/8.5.1/8.1/7.1/6, TOAD 11/10, SQL Developer, Visual Basic 6.0, SQL, PL/SQL, C, C++, Java, HTML, VB Script, JavaScript, C#.Net, VB.Net, ASP.net, Web Services, Internet Information Server (IIS), Microsoft Office SharePoint Designer, MS Visual Studio 2012/2010/2008, Adobe Dreamweaver, Oracle R11i, Oracle R12i, JD Edwards & Hyperion, IBM Cognos Suite 8, 10, 11/Analytics

Training

AWS Certified Solutions Architect-Associate

Timeline

EBS Functional Developer

Optum (United Health Group)
12.2017 - 3 2019

System Integration Specialist

Optum (United Health Group)
03.2015 - 12.2017

SharePoint Administrator

State Farm Insurance
06.2012 - 12.2013

SharePoint Developer

Zurich North America
02.2012 - 05.2012

Master of Science - Computer And Information Sciences

Texas A&M University - Commerce
08.2010 - 12.2011

Bachelor of Science - Computer Engineering

JNT University
06.2005 - 05.2009

Senior Software Engineer

Optum (United Health Group)
3 2019 - Current

Migration Analyst

ConocoPhillips
2 2014 - 3 2015
Venkata Naga TurlapatiSenior Software Engineer