SUMMARY:

• 8 years of Information Technology, software solution design, systems analysis and process enhancements experience in Banking and Financial domain. Highly effective and efficient Software Professional to implement complicated solutions and scenarios to enhance system performance and capabilities. Professional services are provided to Confidential, Confidential Confidential .
• Diversified experience in the area of Requirement gathering and data Analysis, Systems and impact analysis, Application Design/solutions, Technical solution Development and enhancements, Anti Money Laundering oracle MANTAS hands - on, PEP Sanctions screening hands-on using FircoSoft suite, Functional and regression Testing, Troubleshooting, Implementation, Post install support. Well versed and successfully implemented solutions based on Waterfall and Agile SDLC models.
• Possess expertise on below areas of software solutions, Development, Support and consulting-
• Senior systems analyst, Oracle RDBMS specialist, Data mining in Anti money laundering (AML)/Fraud and suspicious transaction detection using Oracle MANTAS, PEP sanctions screening Fircosoft.
• Enterprise Data warehousing, OLTP/OLAP/DSS systems, Data modeling, Data load flows, ETL, Informatica 8.X,9.X, Oracle PLSQL, Application Reporting, Unix/Linux shell scripting.
• Systems analyst for Global Securities Lending (GSL) program.
• Specialist for Anti money laundering Oracle MANTAS solution Implementation, Mantas scenario tuning to reduce false positives, optimize alert scoring, fine tune threshold limits, analyze and test existing money laundering scenarios and create new scenarios, add new business products for monitoring. Also implement Fircosoft suit (FML, FUM, FMM, Fircosoft classic etc) for PEP/AML transactions screening incompliance with OFAC, FinCEN, world check rules
• Excellent understanding of relational database management systems (RDBMS), VLDB, Star schema, snow flake schema, Normalizations, Fact tables, Dimensions, slowly changing dimensions, SQL, PLSQL (cursors, ref cursors, collections/array, procedures, functions, packages, dynamic sql etc), Indexes, Table Partitioning’s, materialized views, Query Tuning Optimization and performance improvements, Query execution Explain plans etc.
• Excellent experience in development and designing of ETL methodology for supporting and creating data transformations using Informatica Power Center 8.x/9.x client tools by connecting to Oracle 10g, 11g R2 RDBMS, AIX Unix, Sun Solaris Unix, RedHat Linux, Flat Files, mainframe GDG datasets, VSAM/Cobol files, SQL Server etc and extensively implemented Informatica mappings using various active Transformations, mapping, session, workflow performance improvements, Session partioning’s, PDO approach etc.
• Worked extensively on IBM AIX UNIX, Sun Solaris UNIX and Red Hat LINUX to Design, Develop, Implement, Test, Migrate, Data warehouse and AML solutions using Informatica workflows, Oracle SQL/PLSQL (Packages, Procedures, Functions, cursors, collections etc), UNIX/Linux Shell scripts, Environment variable files, configuration files, File System Permissions, Sudo capabilities, Perl Scripts, report generations and formatting, Automate scheduling activities using Cron tabs. Extensively used and configured file transfer protocols like FTP, SFTP, SSH, SCP, IBM Connect Direct/Network Data mover (NDM) for large volume of data.
• Developed re-usable UNIX shell scripts using .ksh, .bash to use config files, pmcmd, email protocols, various looping concepts, notifying Server usage, declaring and using global and local variables, define $PATH and environment variables, cluster techniques (Active- Active, Active-Passive) and best coding practices. Expert with VI editor, Understands Background, Foreground, Defunct, Orphan, init, Kernel processes. Well versed with .profile, file system permissions, Server clusters, Shared file system, troubleshooting, standard I/O, pattern search using grep/egrep, file editing using sed, awk, file links, ssh protocols using RSA, DSA key generation, PGP file encryptions. Knows methodology of process creation, resource allocation, memory statistics, pmap, vmstat, top, truss, PPID, PID, kill on unix environment.
• Extensively worked closely with Project managers, business Analysts, Front end/product users, Data Modelers, system architects, DBA, in analyzing business requirements and translating requirements into functional and technical design specifications, defining requirement goals and objectives, prioritizing tasks, developing project and resource plans, cost estimates and providing framework. Has effective communication while maximizing responsiveness to change.
• Possess leadership qualities (6 Years of Tech/Module Lead Experience), good at problem solving abilities, good analytical skills, excellent verbal and written communication and good interpersonal skills. Can manage multiple tasks effectively and master innovative software & tools. Thrive in high pressure situations requiring focused decision making during production failures and job abends.

TECHNICAL SKILLS:

Technical expertise: Senior Systems analyst, AML Oracle MANTAS implementation hands-on, PEP Fircosoft implementation hands-on, Data modeling, Data analyst, Data Warehouse, Oracle PLSQL, SQL, ETL, Informatica power center, UNIX shell scripting, PGP file encryption, Connect Direct (NDM), SCP/SSH/ FTP/SFTP, Perl scripting, PowerShell/Batch Scripting, C++, C

Scheduling Tool: Mainframe CA7, Control M, Informatica Scheduler, CRON tab

IBM Mainframe Technologies: JCL, Endevor, Infoman, FileAid, CA7

Operating Systems: Sun Solaris 9, 10, AIX 5.2, 6.1, Red Hat Linux RHEL 4.x, 5.x and Windows 98/NT/2000/2003/XP/7, MF

Microsoft Office: MS Word, MS Excel, MS Access, MS PowerPoint, MS Outlook

Tools: Toad, Rapid SQL, Putty, WinSCP, CA7 Harvest (change control tool), HP ALM 11, IBM Rhapsody, Eclipse, Momentics IDE

WORK EXPERIENCE:

Confidential,Tampa, FL

Technologies and Tools Used:Oracle Mantas 5.7.2 and 5.9, SQL/PLSQL, Linux, SSH, SCP, SFTP, TOAD 11.6, SQL*Plus

Tech Lead

Responsibilities:

• Act as a liaison between business and technology team and entails significant client interaction for Requirements gathering, interpreting, analyzing, existing system gap analysis, existing system impact analysis, writing specifications and design documents to minimize potential money laundering risk for the CITI Bank.
• As an Oracle Mantas senior systems analyst for AML Optimization, will analyze and develop monitoring processes involving threshold tuning, data mining, calibration, segmentation and optimization of parameters for regulatory compliance requirement on Oracle MANTAS software. Responsible for developing foundation for future monitoring and calibration for changing regulations using advanced statistical techniques, regression analysis.
• As a senior analyst responsible to identify existing issues with the application and Mantas monitoring and creating detailed plans for scheduling of scenarios, tuning and testing relating to production and pre-production monitoring rules, utilizing visualization techniques to display data and results of analysis in straightforward presentation that can be understood by nontechnical readers. Also develop models for transactional monitoring and measure the success of existing client AML transaction monitoring, customer risk scoring and Office of Foreign Asset Control(OFAC)/sanctions screening models and escalate issues for under monitoring or over monitoring.
• Apply strong knowledge from the fields of Oracle MANTAS software, PL/SQL architecture, Anti money laundering concepts and showcase strong verbal and written communication skills to solve complex money laundering problems, propose solutions, apply strong analytical skills, analyze and evaluate data to meet the business requirement of alerting illicit money trails and activities at CITI bank.
• Apply knowledge and expertise of Oracle MANTAS software (version 5.7 and later) scenarios, threshold optimization, alert scoring, auto-close, watch list functionality, risk derivation and aggregation derivation workflows required. Apply experience of Oracle Financial services MANTAS software installation and upgrades on Unix / Linux platform by knowing complete product architecture and Financial System Data Model (FSDM).
• Analyze existing system and transactional data and recommend changes to MANTAS software parameters to meet regulatory needs, correcting errors, improve alert scoring, improve scenario performance, reduce false positives and find hidden money laundering patters to develop new scenario rules for effecting AML transaction monitoring to mitigate risks.
• Apply strong technical expertise on Oracle software, Informatica 9.5x and above, On-Line Transaction Process (OLTP) model, Unix/Linux shell scripting, use Autosys to schedule alert generation batches, develop new Oracle stored procedures, functions, triggers, packages, database objects, indexes and components to meet transaction screening requirement as per Financial System Data Model architecture (FSDM).
• Report day-to-day progress on deliverables to Application/Project Manager and ensure adherence to the CITI Bank Processes and regulations.

Confidential, Chicago

Technologies and Tools Used:Oracle 11g, 10g, SQL/PLSQL, Sun Solaris UNIX, SSH, SCP, SFTP, FTP, TOAD 11.6, SQL*Plus, PVCs, Mainframe, Control M

Tech Lead

Responsibilities:

• Understand and gather requirements in order to create, modify, correct the GSL managerial reports based on PL/SQL and unix logic.
• Provide cost estimates based on the Change requests received for the man-hour efforts. Define project plans, time line and resource allocations.
• Analyze, understand the existing PL/SQL and UNIX logics to define and quote the technical design and solution to build the new reports on PL/SQL and UNIX platform.
• Understand OLTP design of GSL application and build OLAP on Oracle RDBMS platform to build MR reporting functionality for GSL application.
• Analyze GSL MF code, UNIX, PL/SQL packages/procedures/functions to quote and define impact analysis, amount of efforts and solution design as per the existing schema design.
• Gather and load MF source files, test files from the GSL Mainframe team using SQL loader. Create PLSQL logics to build the Oracle Data warehouse using oracle External tables.
• Create reports using complex PL/SQL procedures/functions/packages, Develop UNIX shell scripts required to support the MR reporting and client’s requests.
• Translate client requirement document in high level and low level design documents.
• Attend Project meetings and discussions at onsite, propose estimates, design, solution approach, resource utilization plans and coordinate the business details with offshore as the onsite tech lead.
• Present coding changes, testing results and work with BA to seek for the approvals for the end user testing.
• Version management of code using PVCs tool and migration of UNIX, SQL scripts in multiple testing, QA and production environment.
• Responsible for deliverable, conducting reviews, creation of code documentation, timely approvals.
• Post deployment verification and validation.

Confidential, OH

Technologies and Tools Used:Oracle Mantas 5.8, Informatica Powercenter 9.x, FircoSoft Solution for pattern matching Oracle 11g, SQL/PLSQL, UNIX/Linux shell scripting, Connect Direct (NDM), SSH, SCP, SFTP, FTP, TOAD 11.6, Windows scripting, SQL*Plus, Harvest, Mainframe CA7, Microsoft Visio, Windows 7

Tech Lead

Responsibilities:

• Integrate Enterprise level day to day transactional data coming from various existing business LOB/products/ transactional systems as sources using solutions comprising of Informatica workflows, unix scripts, DB objects etc.
• Build the input interface for the new products, new LOB areas, new transactional services launched for the customers essential for the business by enterprise by gathering reference data, flat files, vsam files etc.
• Develop/Design/Create DIS (Data interface system) files using informatica and unix scripts.
• Create Mantas ingestion jobs and oversee ingestion, behavior detection (BD), augmentation, post processing process completion.
• Populate MANTAS stage area using DIS files by executing Oracle provided DP and DL process.
• Oversee and fine tune Mantas Informatica ingestion workflows.
• Improve performance of the existing AML scenarios to reduce the false positive, improve alert scoring and increase the accuracy of alerts generated by fine tuning the threshold limits, by adding the conditions of utmost important events which are rare and mandatory for AML activity to happen at the beginning of pattern/scenario to help reduce the records retrieved by mantas dataset query to improve scenario performance for data mining.
• Optimize already developed and implemented database objects for performance improvements by tuning for PL/SQL objects, table structures, indexes, informatica workflows, sessions, mapping tuning and improving overall batch time.
• Analyze the system and data to identify the new patterns and scenarios in the system to enforce effective AML and fraud detection techniques.
• Creation and testing of new behavior detection scenarios and rules as per the inputs and threshold limits provided by business users.
• Setup SSH, SCP, NDM protocols on UNIX clusters for source file transfers to and from Mainframe using UNIX shell scripts.
• STX system function as a most vital application to comply bank meet FinCEN, OFAC, OCC, Anti Money Laundering capabilities and nullify heavy fines and audit compliances from gov institutions.
• Help Gov. Report and track Suspicious, fraudulent, illicit transfer of money trails.
• Optimize Oracle mantas to meet LOB scenarios and special needs arising out of worldwide sanctions and norms.
• Raise and alert business user to track transactions, meet Audit demands, File SAR reports, FINRA rules.

Confidential

SQL Developer

Responsibilities:

• Understand and gather requirement (source files, test files, business logic) from the clients and business users for various client needs.
• Translate client requirement document in high level and low level design documents.
• Develop ETL mappings using informatica power center, sessions, workflows, UNIX shell scripts, SQL and PL/SQL scripts, Stored Procedures, packages, functions.
• Create, Integrate, transfer various source files required for FMM, FUM, FML, Fircosoft classic and Fircosoft suit utilities to support transaction scanning program
• Build and create extensive UNIX shell scripts to execute fircosoft scanning/pattern FFFSCAN matching algorithm to create the potential hits/matches
• Handle huge production data, integrate, Optimize Fircosoft system by utilizing Fircosoft classic, FML/FMM/FUM utilities for OFAC, FinCEN, wordcheck files to fine tune the alert generations with correct alert score and flags based on multiple names, territory/country, designation and activities by scanning against multiple transaction files
• Create unix shell scripts and load the Fircosoft generated matches using Feeding algorithm FFFFEED to Fircosoft tables to create alerts/matches for the day.
• Creation and execution of DDL, DML operations, creation of Indexes, table Partitions, new tables and integrity relations to support the Informatica mapping developments and reporting needs using UNIX shell scripts
• Analyzing and performance tuning for PL/SQL objects, table structures, indexes, data model, creating data loading strategy, informatica workflows, sessions, mapping tuning and improving overall batch time.
• Setup SSH, SCP, NDM protocols on UNIX clusters for source file transfers to and from Mainframe using UNIX shell scripts.
• Involvement in end to end code review, system/QA testing and UAT support. Analyze Test Results, bug fixed and Resolve issues if any
• Version management of code using HARVEST for traceability and migration of UNIX, SQL scripts in multiple testing, QA and production environment.
• Responsible for deliverables, conducting reviews, creation of code documentation. Uploading all the project documents and Test results into HP ALM 11.
• Create and review Endevor packages on mainframe for Scheduling Production Jobs through CA7 DOCs.
• Post deployment verification and validation.
• Prepare weekly status report and conduct weekly status meeting with client. Identification and reporting of value additions and system recommendations for better performance.