Business Analyst Intelligence

GOMATHY JAYAKUMAR Mobile: 317-***-****

Fishers, IN-46038. Email:*************.**@*****.***

PROFESSIONAL SUMMARY

* ***** ** ********** ** a developer in Banking and financial domain.

Excellent analytical and programming skills with strong academic background and good communication.

Full end to end project experience in the health care domain on implementing automation using Automation Anywhere and Python.

Experience in designing and developing queries, stored procedures, complex joins in latest versions of SYBASE and ORACLE and responsible for performance tuning and optimizing SQL/PLSQL Queries using SQL Query Analyzer.

Experience in automation of monitoring Informatica environments using UNIX, Control M scheduler and command line language.

Experience in Visual Source Safe (VSS) and Git for the version control software.

Coordinate with Project Business Analyst, Data Modeler and Business Intelligence Lead to ensure that the end to end designs meet the business, data requirements and develop the task plan for ETL developers for a specific project and Responsible to understand the ETL specifications and build the ETL applications., Fetch the daily data from various sources like relational and flat file sources of OLTP systems, Create the mappings, sessions and Workflows as per business requirement using Informatica Power Center 10.2, Informatica Power Mart, Informatica Power Exchange, Informatica Power Center Connect,Informatica Power Channel, Informatica Metadata Exchange,Informatica Power Analyzer,Informatica Data quality, SQL Server 2012,Oracle 10g and Unix scripting. SKILLS

● Robotic Process Automation (RPA) tool- Automation Anywhere

● Python

● Informatica

● SQL PL/SQL ORACLE ORACLE TOAD SYBASE DB2

● UNIX Windows Client and Server OS

● Main frames - COBOL / CICS/ JCL/ REXX

● C and Java programming

CERTIFICATION AND TRAININGS

Completed the Robotic Process Automation Certifications.

● “Bot Developer (Automation 360)”

● Automation Anywhere Certified Advanced RPA Professional Prep. I have taken the below courses in Udemy Online learning platform and have obtained the course completion certificate successfully during 2023 - 2024 period.

● The Complete ORACLE SQL Certification Course.

● Informatica Tutorial: Beginner to Expert Level.

● Zero to Hero in Tableau: Data Visualization using Tableau. PROFESSIONAL EXPERIENCE:

Automation Developer Mar 2024 – Till date

Wissen Technologies Texas, USA

Technology Analyst. July 2007 – Jan 2013

INFOSYS LIMITED Bangalore & Chennai

During my tenure,

Received SPOT AWARD in recognition of excellent work at “Fidelity account”. Received INSTA AWARD at IBU (Banking and Finance Services) level for performance during Q3 2011. ENGAGEMENT OVERVIEW with WISSEN

Client: University of UTAH, Health (UUH) March 2024- till date Involved in all phases of the project to automate file preparation and movement - short-term project. UUH approached Automation-Anywhere to automate their process of collecting scanned documentation from around the organization and prepare it for ingestion into Epic. They also demanded image processing, barcode reading, and file type conversions. We (Wissen Technology) were allocated for this project and were able to achieve it using Automation Anywhere and Python scripts.

Roles and responsibilities include gathering the client requirements, designing, development of Bots and Python Scripts & testing, providing UAT, PROD and Warranty support.

ENGAGEMENT OVERVIEW of INFOSYS project:

Client: Bank of America May 2012 – January 2013

Provided support and maintenance of campaign launches in this marketing domain project. Roles and responsibilities include work elaboration, distribution, team management as a team leader. Designing, review, coding, and testing as a part of enhancement works. Job monitoring and issue resolution as part of maintenance tasks. Leading the team of 4 people from offshore. Worked in Informatica, UNIX and ORACLE TOAD. Client: Fidelity Investments May 2010 – March 2012 Developing a configurator tool for Fidelity PWI (Personal and Workspace Investments) to automate the process of data updation. Single point of contact from the Informatica side. Had done Work allocation, Requirement elicitation & elaboration, release management & support as a technology analyst and design, coding, reviews, testing as a senior software engineer. Responsibilities included,

Analyzing the requirement and providing estimates.

Preparing design documents and creating Informatica mappings, workflows, UNIX commands like ‘pmcmd’ to execute the mappings, Sybase & ORACLE Stored procedures.

Providing resolution for the issues faced by client as a part of everyday routine.

Giving transition for the on boarded new resources Worked in Informatica 8.6, VSS, Sybase, Oracle TOAD Played the role of Configuration Controller (Dec 2010- Mar 2012) where the responsibilities included Auditing project members desktop/ LAN folder and CM Plan, Scheduled deployment and ODC PM (Oct 2011 - Mar 2012) where responsibilities included maintaining project history, managing resource allocations, Maintaining ODPS (Offshore Development Partner System) for the project as well.

Client: JP Morgan Chase, Investment banking Dec 2008 – Apr 2010 Involved in maintenance of JPMC’s legacy systems offered by the JP Morgan’s Retirement Planning Services to its customers and enhancing its services offered.

Played the software engineer role here by analyzing the new requirements, preparing POCs, developing design documents, coding in COBOL /JCL, Unit testing and Independent Unit Testing (IUT) and tool creation using REXX. Client: Royal Bank of Scotland Dec 2007 – Oct 2008 Worked in Ulster Bank Integration projects with the RBS Bank which happened at multiple phases. Have prepared Component designs, coded new modules in COBOL & CICS mainframes. Also performed code review,unit testing, Independent Unit Testing, link testing and system testing. Also, supported the User Acceptance testing (UAT). Attended Generic and stream specific training in Infosys July 2007- Nov 2007 Cleared with the CGPA of 4.9/5

EDUCATION

Bachelor of Engineering (B.E) – Electronics and Communication April 2007 ANNA UNIVERSITY, TAMIL NADU, INDIA

Graduated with 85%

Pre-University – Biology, Math March 2003

TAMILNADU STATE BOARD

Marks secured: 93.9%.

10th standard April 2001

TAMILNADU STATE BOARD

Marks secured: 95.4%.

I hereby declare that the above-mentioned information is true to the best of my knowledge. Date:

Gomathy Jayakumar

Contact this candidate