Trung Tran

Experience

• 

  Independence Blue Cross

  Mar 2008 - Sept 2008

  Programmer Analyst

  • Worked with the Provider IS department team in the design, development, and testing of new or existing Mainframe batch programs and applications.• Performed analysis of functional specifications for complex programs.• Responsible for coding, debugging, and maintaining complex programs using detail specification. • Experience with DB2, SPUFI, UNLOAD, and COBOL programs with embedded SQL.• Participated in writing JCL with symbolic parameters.

• 

  Independence Blue Cross

  Mar 2009 - Mar 2010

  Enterprise Architect

  • Worked with the Enterprise Architecture SharePoint team in the development, testing and maintenance the ongoing organization’s web site, department site, team sites, and other SharePoint projects.• Experimented with SharePoint latest collaboration design tools, ASP.NET, C#.Net to enhance the site’s design, structure and content.• Participated in writing Web Services, Workflows and developing complex corporate forms using InfoPath and SharePoint Designer tools, C#.Net,VBScript, XML, CSS, and HTML. • Participated in developing and maintaining Virtual Supply Store project to save the company over $400,000 in the first six months. • Consulted for other departments to convert their old technology (Domino) to SharePoint. Show less

• 

  Lincoln Investment

  Jun 2010 - now

  • Assisted in the analysis of business processes and identified opportunities for automation using the Appian platform.• Collaborated with Appian developers to define clear and comprehensive requirements for Appian applications.• Experience in developing, integrating, and debugging Appian objects; writing validation tests against existing baselines to ensure the integrity of the code during Agile development• Create integrations with other enterprise systems using REST APIs.• Assisted in the development of Appian best practices and governance standards.• Worked with business stakeholders to gather feedback and make continuous improvements to Appian applications.• Possess strong Microsoft SQL experience in writing Joins, Views, Subqueries, Stored Procedures, Functions, SQL Server Agent Job.• Experience in IBM DB2 writing Joins and queries. Show less • Responsible for all project lifecycle phases, from specifications and coding through different phases of deployment, testing, debugging, documentation, fixing bugs, and production support.• Knowledgeable of mass data transfers including importing and exporting data between applications or files.• Designed, developed, and implemented Blue Prism RPA solutions to automate repetitive tasks and streamline workflows.• Collaborated with cross-functional teams to gather requirements, analyze processes, and identify automation opportunities.• Created and maintained process documentation, including process maps, design specifications, and test cases.• Ensured the scalability and reliability of RPA solutions while adhering to best practices and industry standards.• Participated in RPA project planning, estimation, and prioritization to meet business objectives and timelines.• Experience in integrating various Web API Services using Blue Prism Platform for Bot.• Possess strong Microsoft SQL experience in writing Joins, Views, Subqueries, Stored Procedures, Functions, SQL Server Agent Job.• Experience in IBM DB2 writing Joins and queries.• Expertise in creating flows using Power Automate• Expertise in MS Excel/Access VBA (Forms/Reports/Macros/Modules) Show less • Responsible for analysis, design, development, test, and maintenance of Access, Excel, Workflows Application and developing complex Web Application using SharePoint Designer tools, Access Service, Excel Service, VBA, XML, and HTML.• Working with SharePoint's latest collaboration design tool in the development, testing, and maintenance of the ongoing department’s website, sub-sites, and other SharePoint web applications.• Responsible for the creation of productivity reports to assist sales professionals in identifying areas of opportunity and vulnerability.• Experience with complex query design, stored procedures, views, and functions. Show less • Performed analysis of functional specifications for complex legacy programs. • Responsible for the creation of production various dashboards to assist the home office in identifying areas of opportunity and vulnerability.• Assisted with automation of various departments’ manual processes by writing VBA code and using macros and formulas to speed processes and remove human error.• Running ad-hoc queries against the different database and environment platforms to answer business questions Show less

  • IT Software Engineer

    Feb 2023 - now

  • Developer, Technology Product Owner

    Dec 2019 - Feb 2023

  • Research Development and Implementation Developer

    Oct 2013 - Dec 2019

  • Research Development and Implementation Analyst

    Jun 2010 - Oct 2013