Latha Viswanathan Email & Phone Number

San Diego, CA, US

Dallas, Texas, US

• Developed, Maintained and Supported Database and infrastructure processes to support Avantax Management business applications.
• As a Production Support Team lead played a key role in maintaining and supporting the Advisor Compensation systems, CRM systems and the Books and Records applications.
• Administer, Maintain and Coach/mentor the Application Developers with the Job scheduling and Automation Tool- JAMS
• Played a key and instrumental role in the Data center migrations from the Irving to Cypress Waters Location.
• Proactively monitor and provide support for all the SQL server databases in the organization.
• Refresh monthly/ or an as needed basis the SQL database from production to test and development servers.

Chicago, IL, US

• Provide Application support for all help desk tickets related to Application Development team and help with speedier resolution to meet the SLA’s for the organization.
• Proactively monitor and provide support for all the SQL server databases in the organization.
• Refresh monthly/ or an as needed basis the Elite database from production to test and provide back office support for Elite Databases the primary application used by the entire organization.
• Provide Tier 2 application support for the IT development team.
• Experience with Change management process for production and non-production changes.
• Assist the System developers with database changes and provide performance tuning recommendations and optimizations related to SQL databases.

Coppell, Texas, US

• System admin, manage and maintain the CRM application used at 22 branch locations.
• Successfully lead, managed and implemented the upgrade of the CRM application with a new look and feel for the E business application.
• Team lead in effective ways to track and reduce the incident tickets and to provide support for the branches.
• Successfully managed the integrations of the background checking application with the HR hiring management Kronos application.
• Managed the project migration from the Microsoft Dynamics to SGA accounting and budgeting software.
• Generated new development ideas and automating procedures to streamline and direct Members to Online E-business application for program and membership purchases.

Grand Rapids, MI, US

• Responsible for creating a systems jobs environment where the development environment and production were identical. This was critical in ERP systems to run smoothly.
• Created a new module in the integration subsystem that interfaces between the websites and JD Edwards system. The subsystem uses Entity Framework and C# and SQL data.
• Designed and implemented an application using test driven development TDD.
• Implemented and automated process of extracting the files posted on our server and to process the files through our Integration systems.

Cranberry Township, PA, US

• Designed, developed and implemented Everything Parcel Tool /EP Tool) to receive EDI data from the major parcel carriers and import and rate the parcel invoices. Skills involved in this application development was.
• Created several Dashboard Reports and Key Reports for the external customers to track their parcel savings and to analyze the savings generated with the partnership.
• Instrumental in managing over 150 customer databases doing SQL installs, backup, recovery.
• Key player in developing a new data warehouse environment, to transfer the Parcel data to the third party logistics environment and providing a 360 view for the Customer base. Primarily used SSIS packages and Cognos.
• Developed a system to reduce and bring more efficiency of doing the regression testing during the release process to make sure the changes being done is working efficiently across all customers databases.

Minneapolis, MN, US

• Built, tested and deployed scalable, reporting systems to track the Customer Service and Claims department member's workflow.
• Developed key dashboard reports to track the customers, policy coverage's and their trending analysis.
• Developed reports and was instrumental for the EDI compliance data to be reported to the Department of motor Vehicles regarding Auto policy coverage's for 28 states.
• Instrumental in creating coding standards and compliance for Sox audits for the development team.

Green Bay, WI, US

• Core Languages/Skills used in this position include VB6.0, Sybase, Unix scripts, SQL.
• Developed and implemented the third party Pay project that reduced the manual invoices per month, a 90% reduction.
• Worked on consolidating 2 Hewlett-Packard Unix servers and consolidated them to a single server.
• Developed and implemented the Freight Pay risk management project, key sills used for this project was VB6, and SQL.
• Developed an interface between the freight payment system and the accounts payable system, to automate and create the EFT process to make carrier payments.
• Developed and integrated the systems between the then newly bought company for making carrier payments and the internal SNI developed Summit system.

Master Of Computer Applications (M.C.A.), Computer Ap

Bachelor'S Degree, Science