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. • Provide support to the Development Team by Deploying the Database code to the UAT and Prod environments on a daily/weekly basis• Provide backup support for Tableau Administration.• Experience with Change management process for production and non-production changes and assist the Internal and external Auditing Team Members related to Compliance regarding Database changes.• Assist the Avantax Wealth management Developers providing support for Cloud Database Administration with AWS RDS and Aurora/Mysql and Postgres Databases.

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. • Experience in batch processes, import, export, backup, database monitoring tools.• Experience in identifying the I/O and memory bottlenecks, blocking and deadlocks using SQL activity monitor, SQL profiler and handling bottlenecks by better Query execution plans• Explicitly use Third Party Tools like IDERA and Solar Winds• Experience in backing up, restoring the database manually and also by scheduling jobs and maintenance plans• Migration experience from MS SQL server 2008 to MS SQL server 2012• Provide assistance with Share point 2007 administration and maintenance.

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.•Technical and system lead for upgrading the database and other application servers from SQL server 2008 to SQL server 2012.•Provided technical leadership and developed reports for branch compliance to Y-USA and Y-Seer.

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 VB .Net , SQL • 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 reporting tool.• 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