Vijay Tripuraneni

Experience

• 

  V&K Software Technologies Corporation

  Jun 1996 - Jun 1999

  Programmer Analyst

  Designed and developed windows applications, reports and components for multiple clients using Visual Basic, SQL server, Oracle, RDO, DAO, T-SQL, PL-SQL, Crystal reports and COM\OLE servers.

• 

  Netsoft Technologies CORP INC

  Jun 1999 - Mar 2003

  Responsible for loading historic data for stocks, options and futures using SQL server BULK INSERT (from over 70,000 ASCII files). Responsible for performance tuning of the database for faster access of historic data and real time data access. Administered SQL Server(s) in development environment as stop gap solution till we permanent hired a SQL DBA. Received KT for an in-house trading application written in Visual C++, MFC, HyperFeed API, Win32 API, winsock API, window services and SQL server from the Korean team. Responsible for supporting the trading application. Show less Responsible for requirements gathering, analysis, complete design, architecture, communication protocol of the forex feed aggregation trading application and utilities written in Visual C++, MFC, Win32 API, SQL Server 2000, ADO, Visio, Visual Basic 6.0, EXCEL VBA and winsock API.Responsible for the development admin interface, integrating EXCEL based streaming forex feed into aggregated feed using SQL Server 2000, ADO, Visio, Visual Basic 6.0, EXCEL VBA and winsock visual basic control.Responsible for database modeling and physical database objects implementation. Show less Designed and developed the module that crawls content from the Web (economy.com, clearstation.com, pollingreport.com) and stores key financial indicators in the database using Java, swing, SQL server, T-SQL and JDBC-ODBC.Designed and developed a module that generates graphs for internal and external financial indicators using JClassServerChart, Java. Also maintained the financial web portal using ASP, Visual InterDev, IIS, ASP, JavaScript and DHTML.Responsible for creating a rule evaluation engine that scrapes customer card usage data from main frame IMS screens and evaluates the rules created by web-based rule engine to categorize them into appropriate campaigns using COM, Visual Basic 6.0, MS SQL Server 7.0, T-SQL, Extra sessions VBA. Responsible for design and development of COM components to interface with archive/queue-based imaging systems and intranet web portal using Unisys imaging API, Visual Basic 6.0, SQL Server and T-SQL, ASP, HTML and DHTML. Added new reports to existing ticketing system using crystal reports, SQL server, T-SQL.Responsible for the design, development, packaging, and deployment of the windows-based reporting system using Visual Basic, MS SQL Server 7.0, COM, T-SQL and Crystal Reports. Show less

  • Programmer Analyst, Bench Time (Training)

    Jan 2003 - Mar 2003

  • Programmer Analyst, Assignment at BBG Holdings

    Jul 2002 - Dec 2002

  • Programmer Analyst, Assignment at Direct Trading Group

    Jan 2002 - Jun 2002

  • Programmer Analyst, Bench Time (Training and certification)

    Sept 2001 - Dec 2001

  • Programmer Analyst, Assignment at American Express - Subcontract (via Vitaver & Associates)

    Jun 1999 - Aug 2001
• 

  RK Technical Services (RKTS), Inc

  Apr 2003 - Dec 2007

  Desgin, develop and support parts of the federal websites medicare.gov, cms.gov and internal web portal OESS using ASP, Visual Basic 6.0, MS SQL Server 2000, T-SQL, XML, COM, Java script, 508 Compliance, HTML/DHTML, CSS, eWebEditPro (Ektron), Repliweb, XML-HTTP and Persists ASP Upload 2.0.Responsible for building the 508 compliant version of the OESS webportal end to end from the ground up , including data modeling, site navigational menus, web admin interface for content management.Responsible for creating technology evaluation documents, Mockups, detailed release instructions and UAT/Production Packages with database backups for CMS installation and assist project manager with LOE for enhancements/change requests. Assist the configuration management team in creating a replica of CMS production environment to trouble shoot issues caused by Repliweb.Quickly filled in for a vendor(unavailability) by creating wireframes using HTML, css for medigap screens on medicare.gov. Show less Designed and developed a .NET based ETL interface that would transform a Excel spreadsheet uploaded by user into .NET objects and insert data into the underlying application tables using SQL Server 7.0/2000, T-SQL, DTS Packages, Visual Basic 6.0, ASP, COM, VB.NET, ADO.NET, Persists ASP Upload 2.0, Java script, HTML/DHTML and COM interop's.Designed and developed write-off worksheet, credit summary screens using ASP, server-side VBScript, java script for client-side validations and stored procedures for data access. Used XML-HTTP for dynamically generating drop downs.Resolved performance issues for multiple reports written using Asp, HTML and SQL Server stored procedures. Show less

  • Programmer Analyst, Assignment at Microsoft Subcontract (via EXCELL Data)

    Dec 2006 - Dec 2007

  • Programmer Analyst, Assignment at CGI-AMS/Fedral Subcontract (via ASCELLA Technologies)

    May 2005 - Nov 2006

  • Programmer Analyst, Assignment at MCI - Subcontract ( via Princeton Information)

    May 2004 - Apr 2005

  • Programmer Analyst, Assignment at KPMG

    Apr 2003 - Apr 2004
• 

  AETEA Information Technology

  Feb 2008 - Sept 2008

  Application Developer, contract to hire for Farmers Insurance

  Design and develop configurable agent second signing process using XML, C# and XML deserialization, which is invoked from the agent web portal.Add web methods to webservice written in C#, .NET, these web methods are invoked from maintenance mode utility with in the agent web portal written in ASP.NET, C#, .Net webforms, XML, CSS, HTML, Flash and Javascript.Created .NET unit tests using built in test framework.

• 

  Farmers Insurance

  Oct 2008 - Aug 2023

  FIUL3 – Phase2 As a tech lead, supported the team in successful delivery of the FIUL3 product (compliance) for the remaining three states. Created a POC with Mule 4 WSS module to process signed SOAP XML requests from C#/.NET based web clients. Resolved issues with certificate included in SOAP payload and C# client code. The team successfully ported the WSS module from POC to Mule Based Reproposals API. The same fixes have been applied to multiple Mule based API’s and SOAP clients/Vendor applications.AWS Cloud Adoption Joined the team during the digital estate planning phase and assisted in the rationalization of New Business processes. Created a design proposal to modernize the New Business process, replacing legacy state-based applications with event-driven using Amazon API Gateway/MuleSoft, AWS Lambda, Step Functions, EventBridge, SQS, and SNS. The design was approved by the manager, and a project intake request was submitted. Suggested mainframe modernization through replatforming applications using MicroFocus. Also advised to start with the replatforming of test regions.CPRAProvided system design (RFP supporting documentation) based on managers vision to create an enterprise level purge framework to be compliant with data retention and regulatory requirements.Dremio UpgradeFill in for another tech lead by upgrading Dremio, configuring NAS for reflections, S3 connectivity and resolve upgrade issues related to extended attributes. This enabled the development and Business teams to evaluate Dremio in POC environment as per schedule. Show less Provide end to end Data Integration solutions that are operations friendly using Informatica PowerCenter Advanced Edition, Power Center Clients tools, PowerExchange Navigator, PWX for IBM z/OS, PWX for IBM MQ, PWX for JMS, SQL Server, T-SQL, XML, XSD, Autosys.Provide post implementation warranty support for strategic projects and operational support for Life Data Foundation.Analyze, Troubleshoot ETL configuration and database related performance issues and provide appropriate resolution that includes configurational changes (ex. Buffer size, ETL Batch size for column store loads, turning on/OFF trace flags 4199 and 610) and data archival design patterns like sliding window partitioning for heaps. Create ETL unit test scripts using T-SQL and XQuery most of these scripts can be used to troubleshoot production ETL cycle failures.Participate in code reviews as per checklist and design reviews.Ensure team and self adhere to the Agile playbook by participating in all SCRUM ceremonies as appropriate. Recommend post implementation process improvements for non-strategic projects and DBE process improvements.Use MicroFocus, Service now, JAMA\TFS for deployment, change management and ALM.Create supporting documentation as per strategic project checklist.Create an Individual development plan that aligns with the company's future roadmap (IaaS, PaaS, CI/CD, IaC, DevOps) and learn related technologies like AWS, VPC, EC2, S3, block storage, Consul, Terraform, Vagrant, Chef, Jenkins, Docker, Kubernetes.Create a POC for a Linux container-based SQL Server read scale availability group using VM Ware workstation, RHEL 8.3 Linux, and Container/DevOps technologies like Vagrant/Terraform, Chef, Docker, Kubernetes, Metallb. Show less Collaborate with cross functional IT and vendor teams to install and configure Informatica Powercenter , PWX for HDFS(kerberos), PWX for Hive, PWX CDC for SQL server, Lumira, SAP Business objects in provisional development environment and or CIT\SIT\PROD environments.Collaborate with vendor teams to create smoke tests for the configured Informatica environments. Powercenter test workflows/sessions/mappings were created for each ETL load pattern as per the vendors development road map.Complete training of Big Data fundamentals, Hadoop fundamentals, Pig, MapReduce, Hive, HBase, Oozie, Zookeeper on Big Data University. Complete Linux training as per internal SDP.Collaborate with IT infrastructure teams (proxy server/site minder, DNS and WINTEL Ops) to configure multiple IIS websites (ASP.NET, C#), on a single web farm using host header in development environment and created a setup document for the infrastructure teams to deploy them in TEST and production environments.Design and develop new modules and enhance existing agent portal related websites, internal workflow manager tool, backend new business batch processes using ASP.NET, .NET web forms C#, XML, XSLT, SQL Server stored procedures, LINQ, .NET Web services (Microservices: decomposition by function), .NET WCF services, XQuery, .NET entity framework, jQuery, CSS, and HTML.On call support for Agent portal and related processes during normal, operational support hours, planned maintenance outages, changes to IT infrastructure, maintenance on related applications. Run preliminary diagnostics and collaborate with several IT infrastructure teams IP/DNS, network, reverse proxy/site minder, WINTEL ops etc. to resolve the outages. Participate in sprint ceremonies, sprint planning poker, daily stand ups, review, retrospectives etc. Collaborate with sprint team members to groom user stories by analyzing code of existing processes/ SILOS. Show less

  • IT Consultant (Tech Lead)

    Aug 2022 - Aug 2023

  • Application Developer III

    Apr 2019 - Aug 2022

  • Application Developer II

    Oct 2008 - Apr 2019
• 

  Resolution Life US

  Aug 2023 - now

  IT Consultant (Role transfer from Farmers Insurance)

  Enterprise Data Sourcing – Staging Domain Support the team in ingesting highly nested XML data into a data lake (Staging Domain) using AWS Glue, S3, Pyspark, Python, and the spark-xml library. Utilized spark-xml to convert XSD to a spark schema (JSON format). Offered multiple solutions (Crawler, UPDATE BEHAVIOR, and predefined AWS Glue catalog/Amazon Athena tables) to address schema evolution issues with the ingestion of highly nested and dynamic XML data. Collaborate with the team, Data Architect, product owner, and consumer teams to conduct a feasibility analysis of the above ingestion patterns. Assist in design of ETL process to ingest over 70,000 JSON files for the initial load. Develop POC using Notebooks for XML and JSON ingestion, POC code is ported into the existing event-driven framework (AWS Glue, Lambda, Step Functions, EventBridge). Resolve performance issues during processing of large XML files and programmatically renaming 5k+ unnested XML columns post relationalize. Created POC using AWS Glue, PySpark to resolve the performance issues. Created a python utility script to process large XML files and emulate glue relationalize. The same script was used to perform testing of ingested unnested XML data into the Exploratory zone.Life Data Foundation – LDF (Operations) Support migration of Informatica-based LDF to AWS S3 data lake within the Staging domain. Address issues during the migration planning of claims variable VSAM files data maps from Mainframe Informatica PWX listener to Windows-based listener on Informatica PowerCenter. Provide scripts to the infrastructure team to extend SQL Server partitions for archive tables until the decommissioning of LDF. Participate in the on-call rotation for LDF operations. Show less