VIVEK SRINIVASAMOORTHY

V

Finance & Banking - Senior Automation Lead

Validus

Mar 2022 - Current (4 years 3 months)

• Deployment of RPA bot in production through on-site collaboration with clients. • Completion of development for over 80 complex reports (General Ledger, Regulatory, Financial, and Credit Risk) in MySQL and Microsoft Azure SQL Server DB. • Design, prototype, and develop new features, enhancements, and applications. Work on DB queries and performance improvements for existing & new queries for MySQL and Azure SQL DB. • Worked with SQL performance tuning, defragmentation, DBA activities, and Elastic Agent Job and Logic App creation with Azure Portal. • Explored and created new ways to resolve problems with processes, technology, or team members, to improve efficiency. • Collaboration with stakeholders to identify automation opportuniti

Finance - Database Engineer

doodleblue Innovations

Apr 2021 - Feb 2022 (11 months)

• Engineered RPA bots manage complete data migration processes. • Automated analysis of market share using RPA (A360) integrated with MS Excel. • Engineered and executed complex SQL queries that enhanced data retrieval efficiency, resulting in a 40% reduction in query processing time, while ensuring seamless integration with Hana for real-time analytics. • Transformed legacy data systems by migrating 5 million records from COBOL to MySQL tables, utilizing Python. • Maintained data integrity through diligent database design and development, eliminating errors and risks.

R

Digital Marketing - SQL Developer

Resulticks

Jan 2020 - Mar 2021 (1 year 3 months)

• Designed and implemented a new report module, leveraging the latest features of MySQL 8.0. • Engaged in shaping database architecture with an emphasis on performance efficiency. • Experience in creating RPA bots to automate the product deployment process using A360. • Wrote Python scripts to automate build processes for client deployment. • Developed data models and database designs to plan projects.

Senior Software Engineer

TVS Next

Nov 2018 - Dec 2019 (1 year 2 months)

• Leveraged DB2 CL commands like STRLMI and STRSQL for optimized results. • Migrated RPG programs to DB2 SQL PL format • Transitioned database system from DB2 AS400 into MS SQL Server • Developed SQL queries for patient medical reports (https://ecqi.healthit.gov/) • Completed more than 100+ eCQM complex user stories • Develop over 100+ T-SQL & DB2 SQL complex queries for ED & Inpatient reports to stakeholders • Led a team of software developers in designing, implementing, and maintaining complex software solutions, enhancing product functionality and user experience. • Collaborated with cross-functional teams to identify and translate business requirements into technical specifications.

M

SQL Developer

Mage Data

Jul 2015 - Oct 2018 (3 years 4 months)

• Developed Data Security Modules for a major bank in the Dominican Republic on-site • Deployed database protection systems for a top insurance firm based in Paris, France – Offshore • Implemented Database Security Modules for a leading Bank in Zurich, Switzerland – Offshore • Developed Data Anonymization products like Sensitive Data Discovery, Data Masking, Data Scramble & Data Monitor in MS SQL Server, DB2 (LUW, ZOS, iSeries), Teradata Database • Well versed in creating and killing DBMS_JOBS, Agent Jobs, DBMS_JOB.SUBMIT (), SBMJOB • Executed table partitioning, index creation, schema dumps, backups and restores • Transferred data across various databases utilizing the SSIS tool

VIVEK SRINIVASAMOORTHY

About

Detail

Timeline

Résumé