Suriyanarayanan Sekar

Experience

• 

  Prodapt

  May 2015 - Sept 2019

   Installation, Configuration, Troubleshooting and Maintenance of Web Logic Server 10.3 and Apache servers. Provide support to Production, UAT, Development environments. Configured JDBC Connection pools, data sources using Oracle and BEA Type 4 drivers. Production support – Bug analysis and resolution. Patch installation to applications, and application server. Work closely with vendors to facilitate appropriate changes when needed. Identifying root causes for the outages and applying appropriate fixes of application team or Oracle Support. Deploying applications to various production environment using deployment tools. Automated various tasks using Shell scripts. Involved in 24/7 on-call support for production environment and UAT environment. Preparing RCA for Major incidents. Unit test cases preparation and testing. Worked effectively on WSDLs. Analyzing and effectively fixing the data issues on the XML payload using SOAP UI. Monitoring long running queries and analyzing them in order to effectively monitor the resource usage. Debugged procedures to find the root cause and provided resolutions for issues related to carrier portal that were not in sync with the MSS functionality. Creation of clustered domain, setting up data sources, configuration of a proxy server for internal load balancing.  Deployment of application on the application server. Performed load testing on the application server using Jmeter. Map the database changes provided by Oracle and verify the functionality. Merge the Customizations and make sure that the impact and working remains intact. Provided data and Code (SQL) fixes for any change requests in MetaSolv. Provided extended support to Oracle for fixes on critical defects in MetaSolvIssues related to the EQUIPMENT INVENTORY module of the Metasolv Application.  Conducted training on the basics of ISR ordering module, Equipments module. Unit test cases preparation and testing. Show less

  • Senior Software Engineer

    May 2018 - Sept 2019

  • Software Engineer

    May 2015 - Apr 2018
• 

  Fidelity Investments

  Sept 2019 - Apr 2022

  Business Analyst

  Data Analysis• Deploying quantitative analysis & data mining/visualization to present data on user interaction with the DBCS (Workplace Investment) product.• Identifying and analyzing the impact of calculation types, Flag analysis to better understand on customer behavior and operational blockers.Data Processing & Transformation• Organizing huge data sets effectively via advanced querying, visualization, and analytics tools• Performing data analysis & creating dashboards to identify In/Out population trends, Calculation and projection volumes at specific intervals.• Integrated python scripts with Power BI and automated reports which reduced 30 man hours per week (Excel and SQL script work)• Evaluating and formulating enhancement strategies to boost KPIs across all business units.Requirement Gathering and Enhancements:• Worked closely with technical architects to understand the existing design and been part of data modelling on features for flagship clients like Truist, DOS ISE and DOS DTE.• Wrote and maintained technical and functional specifications to document database intentions and requirements.• Generalized existing scripts and improved its reusability and hence reduced scripting work by 35% Show less

• 

  Altimetrik

  Apr 2022 - now

  • Staff Engineer - Product Analytics

    Mar 2024 - now

  • Senior Engineer - Business Data Analytics

    Apr 2022 - Mar 2024