Trupti Mehta Email & Phone Number

United States

United States

New Jersey, Usa

Pune Area, India

Worked as a team member in the SAS enterprise fraud management projectAnalyzed, designed and developed solution to integrate a new Anti-Money Laundering (AML) functionality into the existing process using PL/SQL and Unix shell scriptingCreated shell scripts to check the input file, validate it as per business rules and create new file in desired format to send as input to alert batch processing Implemented functionality to create files containing rejected records and log files and backup of old input filesAnalyzed and validated existing configuration files to implement changes required for running the new functionalityWrote SQL queries to validate input data submitted through GUI with the actual data in the Database.Prepared detailed design document for the samePrepared test case document and thoroughly tested the whole functionality on test as well as UAT environments to ascertain there is no impact on other modulesReceived timely appreciation from senior team members for the quality of work delivered.

Pune Area, India

Associate - Projects, March 2013 – October 2014• Worked as Team lead responsible for development, enhancement and maintenance of ETL processes as well as creation of exception reports for the customer• Responsible for entire software development cycle including requirement gathering, design analysis, development, testing, documentation and production deployment• Designed and developed various database functions, procedures, packages, etc. required for the project• Creation, maintenance and enhancement of UNIX batches using control files and shell scripts on all environments• Implemented numerous innovative ideas to automate/improve certain processes in the project• Helped reduce the maintenance cost to the client as well as the processing time by automating existing manual processes• Document reviews, Process improvement, Task allocation and distribution, Creation of Weekly reports• Process and Delivery Audits of the project• Plan and provide knowledge transition sessions to new joinersProgrammer Analyst - Projects, September 2010 - February 2012• • Creation, Testing and Execution of Database scripts on all environments using PL/SQL• Creation of UNIX batches for various modules using Shell scripting • Creating and maintaining release wise database scripts and UNIX kit distribution along with production deployments• Developed, tested and executed database scripts as well as UNIX kit on all environments for each release• Unit testing, Integration testing, bug fixing and documentation• Carried out all the production implementations (releases) of KIOSK as well as provided support for ticket solving Awards and Recognition• Three Cognizant KUDOS awards for client appreciation on the quality of work delivered• One Cognizant ACE award for outstanding work within short span of joining the KIOSK team