Support Customer

Vyshnavi Chigubally

Email: ********@*****.***

Ph No: 845-***-****

Summary

Over 10+ years of experience in SWIFT, PERL, UNIX, Shell programming.

Worked as a SWIFT BA and Administrator in Swift Alliance Access environment.

Worked on Flexcube (a core banking product- Payment and collections module) which processes various transactions such as Notice of change(from royal bank of Canada), returns, reversals,CEO-ACH receipts and rejects.

Have extensively worked on time deposit module in Flexcube which handles the direct deposits as part of ACH service for electronic transfer of funds into the account of payee.

Very strong in CGI & DBI DBD programming in Perl using Java Script and HTML

Extensive experience in analysis, design, development and maintenance of Oracle 9i/10g database objects.

Broad experience in SQL,PL/SQL programming, including effective use of oracle packages, stored procedures, data base triggers and tools like SQL* plus.

Strong in oracle query optimization and tuning.

Extensive experience in developing applications in UNIX and Windows NT/2000 environments.

Well versed in shell scripts and batch programming.

Experienced in working in financial industry including trading and banking and security trading related applications.

Exceptional skills in developing, supporting and maintaining multiple production systems.

Good experience in providing quick fixes as production application support in 24X7.

Experience in batch processing, QA, production.

Has provided full application support with customers and also with the development team.

Hard working individual, team player with excellent oral and written skills and good communication skills.

Technical Skills

Languages: PL/SQL, PERL, KSH, HTML, DHTML, Java Script, AWK, C, Perl, UNIX Shell, ANSI-SQL, CGI

Message System: Society for World Wide Inter Bank financial telecommunications (SWIFT), Swift Messaging Hub(SMH).

Tools: DBI/DBD, CVS, Visual Source Safe, VISIO, CRONTAB, UML, FTP, MS-Excel, Erwin, FIX Protocol, SWIFT

Operating Systems: Windows NT, 2000, Sun Solaris 2.X, Red Hat Linux, HP UNIX

Web Server: Apache, Netscape Enterprise Server, IS (4.0)

Professional Experience

March 2015 to November 2015

Wells Fargo, Charlotte, North Carolina

System Support Analyst

Responsibilities:

Worked on Flexcube for Non Urgent payments to send transactions (ACH ) to Royal Bank of Canada as part of dispatch process.

Performed business and feasibility analysis based on the requirement from the CEO-ACH business partners and also from FX related to non urgent payments and deposits.

Have tracked and updated the tasks on day to day basis for specific projects as part of project management.

Have scheduled high level meetings with the product managers and user community to discuss and explained the process/ work flow of the projects.

Have created high level documentation for the team and also for various back office partners of the bank.

Also performed SIT/UAT testing by inputting the transactions and validated the outcome in the common payment gateway in Flexcube.

Extensively worked on payments and collections module to input the transactions to process through STP rules which goes through the GAMS (Middleware system), GABS and GSMOS (scanning system for payments) process.

Validation of Intellimatch, non urgent history files as part of end of the day process.

Worked with FX and GFX operations for cross currency transactions.

Worked on Flexcube (a core banking product- Payment and collections module) which processes various transactions such as Notice of change(from royal bank of Canada), returns, reversals,CEO-ACH receipts and rejects.

Worked on ODFI (originating depository financial institution) which initiates ACH entries as per the request and agreement with the customers.

Used RDFI (Receiving Depository Financial Institution) to receive the ACH entries.

Created various CEO-ACH batch files for credit and debit origination of files.

Worked on On US transactions for USD and CAD batches/ transactions.

Created various credit, debit and customer initiated returns of debit/credit and verified the DE entries in journal entry screen .

Worked closely with business operations to fix the failures of transactions to fetch and validate the new FX rate.

Actively involved with electronic window (EW) team and TIR (reporting team) to validate the business reports related to the credit/debit indicators and also the transaction codes related to the customers.

Created high level documents to explain the business flow and scheduled high level meetings with the stake holders to explain about the new products introduced by Oracle as part of Event 11 release.

Worked closely with the developers on TIBCO application and to create routing rules in the smart router(middleware).

Used SQL queries to fetch the date based on the view given by Midas application.

Provided 24/7 support after hours and weekends for any production issues and installations.

Validated the below statement files/notices as part of end of the day process across all environments:

1, Intellimatch Statement files for Canada branch

2, Intellimatch Statement files for Singapore branch

3, ACH history statement files for Canada

4, SRPL files (General ledger, AU code and company name) – Singapore branch

5, SRPL files ( AU code/company name) – Canada Branch

6, Returns/Reversals/IVE rejects Files against the DSD – Canada

7, Notice of Change file from Royal bank of Canada

8, Electronic window statement files with the TIR reporting team.

Environment: Flexcube, Microsoft Visio, ALM

May 2012 to January 2015

Wells Fargo, Charlotte, North Carolina

SWIFT ADMINISTRATOR/System Support Analyst

Responsibilities:

Worked as a SWIFT BA on various projects by writing FSD (functional system Design).

Created various routing rules in SAA(swift alliance access) to route the sender and receiver BIC’s in Inbound, Outbound, output dispatch etc in order to route messages to the Great Britain/European market/Hong Kong customers .

Also performed message clean up, message archive(7 days live messages), MX system messages in both inbound/outbound production environments .

Created RMA authorizations to the correspondent depending on the requests.

Notified various customers for the failure of messages from SWIFT to foreign exchange London/ Hong Kong, money market, FX payments(Opics, PEGA back office applications), International implementation,International Communications, Hong Kong Support etc.

Created new routing rules for inbound MT 910’s received into PNBPIE2D% by creating a message copy and routing it to EW (application given by business group in Hong Kong).

Created new inbound routing rules for WFBIUS6S BIC where the Trade Works Naks are routed to Communications Printer, Mod text queue and Trade Works applications as well.

Cleared all messages which are live in local SWIFT Acks/ Naks, rejected locally messages without RMA(XRMA), MP authorizations, MP_mod_text etc in production environments.

Created the LT A, B and C (PNBPGB20,PNBPHKH0, PNBPKRS0,WFBIUS60, PNBPUS30) schedule and logged the LT’s as per the LT schedule.

Created complex routing criteria for MT103 REMIT/STP,MT103 +,MT202 COV to restrict the messages (other then MT101/103/202) from getting into Cayman Smart Router(middleware application used for granular routing of messages to back office ).

Logged the LTs in Future mode for the SWIFT Standards 2012 and 2013.

Performed the build out for new swift Alliance Gateway (SAG) and created new message partners, Endpoints, Virtual Swift Net Users, Operators/Profiles.

Exported the configuration parameters from the existing alliance gateway and imported it to the new SAG GUI.

Performed failover testing for both primary/secondary SAGs in Swift Alliance Access (including test and Production environments) .

Validated the certificates on SAG associated with all the BICs as part of the new build out for the alliance gateway environment.(SAG)

Gave access to the browse users (London Middle office, Hong Kong Users) for the new SAG environements.

Performed/validated the LDAP authentication servers for all the SAG environments.

Worked as a technical lead for all Foreign Exchange projects and performed feasibility analysis for the routing of messages .

Designed high level diagrams (Visio diagrams) and communicated to the business users in the meetings to discuss the routing logic.

Performed the unit testing in SIT environment to test the routing rule created/modified.

Created the DEV/SIT hand off forms to the QA to perform the testing .

Supported SIT testing to resolve issues reported by the QA.

Performed the SIT/UAT build out in test environments.

Supported UAT testing for the issues raised with the business groups depending on the traffic of the messages.

Resolved all issues in UAT to make sure messages are drained from TIBCO to the back office applications.

Conducted meetings with our SWIFT user community to validate messages.

Created implementation plans and performed it in production on Saturday depending on the traffic.

Participated in verification plan meetings as well.

Conducted the post implementation analysis.

Performed many implementations during the weekend and also supported the verification issues as well.

Worked on the SWIFT product provided by the vendor (Arkelis)SWIFT Messaging Hub/Arkelis Messaging Hub, SWIFT File Act Solution(Package 1)

Created internal and external requestor channels are created in case of SCP/SEPA channels.

Created Incoming selection table from the workflow rules.(using unique sequence number)

Created Distribution rule criteria table as well from the work flow rules.

Created customer Information rules (customer rule criteria) from the workflow rules navigation.

Created Outgoing selection table from the workflow rules.(using unique sequence number)

Addressed it to the new customer for sending the file in SIT/UAT.

Trouble shooted the issues with support for any failed files.

Cleared the cache by putting back in housekeeping mode.

Created work order in the CR for the middleware group to restart SMH from both PRD1 and PRD2 nodes to clear the issues.

Also addressed some issues with SAFET as well to resend the files.

Disabled the auto switch(Cluster settings) before sending the loop back transmission

After confirmation of file successfully, enabled the auto switch (cluster settings).

Also created the profiles using SWIFT parameters (requestor/responder) on SAG –file act depending on the information given in the SWIFT forms from the customers such as (RBC)ROYAL BANK OF CANADA, bulk and generic payments,Campbell’s, Deutsche Bank, BRISTOL MYERS,Google etc.

Performed various build outs for inbound/outbound customers in SMH(SWIFT MESSAGING HUB)

Created the Address Book in SMH for all required customers in PHASE 1, 2 and 3 implementations and activated the services.

Monitored various communication wizards, outbound configurations, protocol instance configurations in SMH.

Started services for the SAFET-Incoming (PAY&SCRIPT) and SAFET-Outgoing (PAY&REQ) channels.

Updated various storage configurations to incoming and outgoing FA.

Restart/stop of the signals under the business groups in SMH are made once the files were ready to send.

Supported the customers in Asia and Europe even after hours.

Performed the primary/secondary on call after hours as well.

Communicated with the business group to get enough functional requirements to route the messages with various BIC’s.

Also performed some SWIFT BA tasks as well for SLA with the vendors.

Created flow diagrams in the FSD which identifies the flow of messages (Message types) to the back office applications.

Gave access to the users for SIT/UAT and SAG environments by performing Level 1 tasks.

Gave presentation for the SWIFT user community about SWIFT BIC and Logical terminal.

Trained various teams on Logical Terminals, Message Partners, MQ queues, Message Search, Tibco tools/Dashboard, Back office applications, Message injection, Message Scrubber for MTs, Maintenance Tasks for message archive in production, Future mode for Logical terminals.

Provided 24/7 support after hours and weekends for any production issues and installations.

Projects:

Trade Works SWIFT Message Routing (Package 5,6 & 7)

Trade Works Nak Messages Routing rules for WFBIUS6S

Wells Fargo Securities OTC Cleared Derivatives Intra-day Reconciliation

SWIFT new routing rule for Incoming SWIFT messages to Eximbills Instance for SICOKHPP, SICOTHBK, HNBNKRSE and HNBNIDJA R1.12

Local SWIFT Ack Queue Routing Rules Update

Trade Insourcing Eximbills Reissuance Build for Israel Discount Bank, New York

GEMINI PORTAL SYSTEM

RMB Chatts

SAG Configuration for File Act(Silas SAG,Wec SAG & Oxmo SAG)

Final Migration from SAG to SMH(Wells Fargo has new business with customers Allianz world Access, Itron and Varde)

SAG (Message Partners & End points)

Core FX Multi- Branch Integration Package 2

WHSL MT101/MT102/Reverse MT103 to Midas+ Cayman Project

Commercial Card European Expansion (C3P)

Trade Insourcing Eximbills Reissuance Build for State bank of India

RMA MX Handling

MT 900/910 Routing Rule changes

IntelliTRACS Remove ITX from Message Bus

Swift Messaging Hub – JCI Compression

Hong Kong FX Printer Relocate

Trade Works 1.1 Swift Routing

Swift Messaging Hub – SAG Reconnect Interval

Updating SAG Connections – 1SNG(Swift Net Gateway)

Trade Works 2.1 Swift Message Routing

Risk Based Remediation Package 6&8(Build out for new Swift Alliance Gateway SAG)

SWIFT 2013 Standards Package 2 File Act Store-and –Forward

Parameters update on the SAG for store and forward

Swift Tibco Additional Drain Time

SMH New file Act customers

Google/Varde Decomission

IACH Removal of Routing Rules

SEPA(DTS Incoming & outgoing Channels)

SMH system parameter updates

2014 Standards Package 8 – Future Mode

2014 Standards Package 1 (SNL upgrade)

Trade Works Vanilla In sourcing Project

Trade Works Eximbills( Eximbills decommission Project)

FCM Cash Management Project(MT950 Routing)

Met West BIC Decommission Project(MT300)

Wells Fargo Securities

GFI Claims /Package Package 2

MQ4U Project( Migration for the Queue Manager)

Virtual Private Network (VPN) and HSM Migrations(HSMs)

Enviornment: SWIFT Alliance Access (7.0) work station, web station, AMH /SMH (Arkelis messaging Hub), SAG (Swift Alliance Gateway).

May 2009 to April 2012

Swift Solutions Inc

First Data Funds Xpress, Austin, TX

UDAP Statements

Senior SYSTEM ANALYST

Responsibilities:

Has provided application support for multiple projects simultaneously on daily basis.

Provided the second level of support working with the developers in order to make changes to the application depending on the customer requirement.

Responsible for matching the banking statements given by the customers to make changes in the account holder’s information.

Worked with the users for the MT’s messages going to SWIFT.

Used the case reviews with the BA’s,wrote design approach documents and provided support and also has tracked the status using the status reporting tool on weekly basis.

Frequently checked the bank E-statements including all savings/checking/DDA accounts on the customer request to fix the issues.

Participated in production support.

Took part in testing and documentation

Identified the source files which have to be fixed according to the generated reports using PERL scripts.

Used SQL to write queries in order to extract the data from the customer table.

Monitored the changes in requirement and constantly made changes to the code and generated the text and E-statements.

Fixed many broken statements given by the bank and performed many re-runs to see how many Savings, DDA,CD and IRA accounts have been processed from the import files.

Used PERL regular expressions to parse the data from the text files.

Worked on Vi Editor environment to write the Perl scripts and to run the exporter.

Used the statement exporter and regular exporter to create a new bank information text and BASH/PERL scripts in order to transform the encrypted data into the test environment.

Used the parsing techniques in PERL to make changes in the refunds section and overdraft section given by the banks.

Designed and developed many Oracle PL/SQL tables, stored procedures and triggers in order to update the customer information.

Worked in oracle for performance tuning using PL/SQL

Deployed PL/SQL codes for creating the Oracle Forms.

Worked on oracle for performance tuning using PL/SQL.

Designed and developed many PL/SQL tables, stored procedures and triggers.

Created many indexes, views using SQL.

Created a new code in order to process the text statements for many Credit Union Banks.

Created many patches and committed them to CVS repository.

Fixed many defects which got bounced back from the QA before it went to production.

Created many Hashes for all new sections which have been added in the bank statements to fix the broken once.

Used many UNIX/LINUX commands to Grep the files and also to Zip and to unzip them before it went into UAT to get approval from the bank.

Created/modified numerous web pages using XML/ HTML with java script validation.

Developed many SQL queries for ad-hoc reports.

Created many SQL /PERL scripts for data archiving and movement.

Analyzed production issues to ensure system availability.

The code was committed to CVS along with its new version and a new back up was given to the project implementation Engineers to check it in their import file OLB strip.

Created and generated numerous reports (daily, weekly and monthly), for various levels of support and auditing.

Used the developer tools to check thousands of E-statements given from the bank.

Fixed the performance bottlenecks identified by the QA team.

Environment: PERL, LINUX/UNIX, CVS, HTML, Java Script, CSS, PHP, MOD_PERL, XML, PL/SQL.

July 2008 to April 2009

Peri Software Solutions

Oppenheimer, New York, NY

Customer Messaging System

SYSTEM ANALYST

Responsibilities:

Analyzed the financial services provided by the customer.

Conducted other interviews with the customers and other groups for testing requirements and expected results.

Provided the first level of support for the application provided by the clients.

Analyzed the requirements of new interface with the budget feeder system.

Modified the financial stock report given by the customers.

Identified the area of process which is involved in order to make improvement and also has established effective and efficient process as well.

Has used FIX (Financial information Exchange) protocol in order to transmit the secured financial information given by the customer using the bash scripts.

Deploying changes in packages and code into production environment.

Supported the application by providing after hours support.

Performed the Extraction and publishing of data from the repository using COGNOS model.

Programmed the data management software and applications for quick and convenient data compilation and retrieval functions from several data warehouses.

Designed and developed many PERL modules.

Developed many PERL scripts for server side data processing.

Designed and maintained database schema and entity relationship diagrams.

Involved in design and implementation of data flow.

Developed many UNIX/LINUX shell scripts and KSH scripts.

Programmed CGI/PERL and to provide online forms, request forms, searches and queries.

Created many PL/SQL tables, stored procedures and triggers on oracle database using SQL.

Designed and developed reports using PERL, stored procedures with DBI/DBD connection to oracle.

Designed and developed many PL/SQL tables, stored procedures and triggers.

Generated unit test logs and unit tested the screens developed.

Fixed the performance bottlenecks identified by the QA team.

Created many indexes for performance.

Worked on PL/SQL stored procedures for performance tuning.

Created PERL scripts for data migration.

Used Perl, DBI/DBD for oracle connection.

Created documentation for performance testing.

Automated testing procedures with object oriented PERL scripting.

Automated unit testing for our projects with shell and PERL scripts.

Worked on bug fixing and supported the production applications.

Post production support.

Environment: PERL, C, KSH, HTML, java script, SQL, Oracle, Red Hat Linux, APACHE, WINDOWS NT/2000,SQL,AJAX,LINUX/UNIX,CSS,PL/SQL,COGNOS Report Net 1.1.

April 2005 to April 2006

Ranklin Solutions Limited Hyderabad, India

Accounting System

SYSTEM ANALYST

Responsibilities:

Performed the system analysis and testing for the financial information systems.

Has planned test schedules for completing the system operations given by the customers.

Created many ad-hoc reports depending on the user requirements.

Worked with end users and software developers to ensure technical compatibility and customer satisfaction.

Performed data handling and data archiving in flat files using UNIX shell scripts.

Developed e-mail modules in order to deliver to the upper management.

Performed data retrieval on the FTP server.

Designed and implemented PERL scripts for front ends and for order processing.

Involved in design, coding, regression testing and implementation.

Created UNIX/LINUX SHELL scripts in order to provide after hours support.

Created many tables and triggers on oracle database.

Designed and developed many indexes, views and stored procedures.

Participated in 24X7 production support.

Environment: PERL, C, KSH, HTML, Java Script, SQL, ORACLE, UNIX, APACHE, SQL, CSS.

Education

Bachelor of Technology in Electronics and Instrumentation.

Masters in Electrical Engineering at State University of New York, New Paltz

Contact this candidate