SUMMARY:

• Over 17 years of experience as Project /Team /Technical Lead and Senior Software Developer in Requirements Analysis, Design, Development, Testing, Implementation, Migration and post implementation support of mission critical applications using Oracle 6.0/7.0/7.3/8/8 i/9i/10g/11g, Java and Object Oriented Methodology.
• Extensive experience and solid understanding of OLTP Applications, Data Warehousing, Data Marts, Star Schema/Snowflake Schema Modeling, Dimensional Modeling, Entity - Relationship Modeling and OLAP concepts.
• Worked closely with Developers for Capacity planning based on Business Requirements, Baseline and Percentage of Increase in data volume.
• Extensive Experience in Implementing, Delivering and Maintaining Federal Remediation Regulatory Projects.
• Designed and Developed Oracle/Java based Business Processing and Workflow Tool for Master Agreements Functionality of Ginnie Mae.
• Designed and Developed Standardized Client Risk Model Tool for Confidential Group.
• Extensive Experience in Implementing, Delivering and Maintaining Federal Remediation Regulatory

SKILL:

Databases: Oracle Exadata,12c,11g,10g, 9i, 8.x, 7.x, 6.0.

Languages: SQL, PL/SQL, Java 2, J2EE - EJB, Servlets, JSP, XML, XPath, Xquery HTML, JavaScript, DHTML, Pro*C, C, COBOL, UNIX Shell, JDK 1.2, RMI, AWT, FoxPro.

OS: UNIX- HP, Sun Solaris, Windows Vista/XP/NT/2000/98, RHEL LINUX.

Products: Forms Builder - Forms 9i/6i, Reports 9i/6i/2.5, Graphics 6i/3.0, Designer, SQL*Plus, SQL*Loader, SQL*Navigator, Oracle Portal,, ExplainPlan, TKProf, TOAD, ClearCase, PVCS, LiveLink, Developer/2000, Dreamweaver, ELITE Package (used in Automobile industry.) AMARTA TOOL 6.5 (Oracle based Business Process Implementation Tool for Insurance industry), MS Word, MS Excel, MS PowerPoint, Oxygen, Eclipse. Informatica Power Center/Power Mart 7.1.4, COGNOS7.4, MQ-Series, MANTAS, Actimize, OFSAA.

Case Tools: Oracle CDE - Designer 2000 6i/6/2.1, Erwin 4.5.

Web Servers: IBM Websphere Application Server 5.1, Oracle 9iAS, Web Logic 4.5, Apache Tomcat.

EXPERIENCE:

Confidential, New York, NY

Data Analyst, Senior Oracle Developer

Responsibilities:

• Undertook data assessment, data gap analysis between MarketIntelligence SNL and Arrow Global.
• Identifying Gaps for Global Banks by comparing process of Data Point capture between SNL and Arrow Global.
• Defining Universe for the Data Analysis.
• Liaised with cross-functional teams (Business groups, IT organizations) in defining Acceptance Criteria for the Analysis.
• Identifying Gaps related to Data Collection process of SNL and Arrow Global for Data Points of Balance Statement, Income Statement section
• Developing 10+ SQL statements.

Confidential, New York, NY

Business Analyst

Responsibilities:

• Fine Tune Application and Automated Gather Stats process for Partitioned tables having more than 250 Trillion Rows.
• Implement Automated Jobs with Oracle Compression Techniques to compress tables having more than 250 Trillion Rows.
• Develop Disaster Recovery functionality for the CRM/IRC Application on RAC Architecture.
• Implement EHCC based on Compression Techniques to archive database records.
• Document Migrating Current Application based on External Tables and Unix shell scripts architecture On Oracle Exadata 11g to Oracle 12c on ZFS.
• Fine Tune Application Workflow process of loading Referential Data Counterparties, Instruments.
• Document current Business process of Loading Cash Balance files received from FINMAN for each Region.
• Resolve Code Defect tickets and Deploy these changes to QA, UAT and PRODUCTION.
• Develop and Modify existing Shell scripts to resolve Code Defects.
• Develop New Workflow for Housekeep process of Tail Feed and Path Feed process.
• Analyze migrating Risk application from Oracle Exadata 11g using DBFS to Oracle Exadata 12c on Sun ZFS.

Confidential, NJ

Business Analyst, Senior Oracle PL/SQL Developer, Application DBA & Application Specialist

Responsibilities:

• Liaised between Business and Technology for functional design, specification and deployment of Finance Systems Initiatives at the Finance Project Office (FPO).
• Undertook data assessment, data gap analysis, system sourcing, remediation and transformation efforts for FR Y-9C, FR Y-14A/Q.
• Liaised with cross-functional teams (Business groups, IT organizations) in Several Global Locations.
• Supported the end-to-end process, Enterprise and Basel DW integration, including feasibility proof, Gap analysis, data mapping.
• Investigated and performed elements mapping for Specific Market Risk, Counterparty Credit Risk.
• Defined, designed, reviewed and documented maps, attributes, data types, cardinality, and data quality standards for both Banking and trading books.
• Worked with different exposures / assets pools: Trade Products, Loans, Securities, and Derivatives.
• Assisted project management team with evaluation of different process and technology solutions.
• Provided Solution Architecture for Automated consumption of Deltas(Adjustments) processed in HFM Application into OFSAA.
• Single Point of Contact for OFSAA and Risk functionality.
• Validated OFSAA Data Model for FRY-14Q requirements.
• Created business analysis document for integration between OFSAA - Risk Staging - Moody’ Confidential RAY based on Risk FRD’ Confidential .
• Re-Designed T2T process to populate FX Exchange Rate table and Historical table.
• As member of IHC Transversal Functional team worked on Integrating OFSAA and Moody’ Confidential Risk Authority (RAY) for RWA calculations.
• Performed Impact analysis of OFSAA changes on Risk calculation in Moody’ Confidential Risk Authority.
• Validated SQL’ Confidential used for extracting dataset from T CDR, T MR tables of Moody’ Confidential Ray for CCAR.
• Designed Data Quality (DQ) checks in OFSAA Framework.
• Developed 2000+ SQL’ Confidential to validate Line Items of FRY-14Q PPNR reports based on Business requirement in Excel sheet.
• Performed Data analysis for LAP and Oracle GL Accounts, Counterparty, Instrument data.
• Developed R17 Reconciliation process between OFSAA and Moody’ Confidential Risk Data.
• SPOC for Set-Up of UAT environment with GL data and Referential Dataset required for the Risk Functionality Testing.
• Worked data acquisition, classification, and enrichment processes and data flows inbound / outbound feeds to and from source systems / product processors.
• Prepared Data Lineage document from Feed File to OFSAA and Downstream Applications.

Confidential, NJ

Data Analyst, Senior MANTAS Oracle PL/SQL Developer, Application DBA & Application Specialist

Responsibilities:

• Prepared Data Lineage document from Feed File to MANTAS tables.
• Understood business requirements and transformed business needs into Technical Application Functionality and Design documents for backend programs.
• Designed new tables and Implemented changes to consume AMLRC Customer Risk rating.
• Analyzed Risk changes impact on scenario alerts.
• Designed and Developed Reconciliation process for Wire-Transactions, MT103 and MT202, MT110, Checks, ACH.
• Generated Transaction and HRG feed files for Risk Calculation.
• Analyzed user requirements and transformed business needs into Technical Application Functionality and Design documents for backend programs.
• End-End Implementation of MT110 functionality.
• Mapped Analysis for MT110 Transaction into Monetary Instruments and Wire Transaction tables of Mantas.
• Implemented Business Validation for BIC code, Payee, Amount for MT110 Feed File.
• Designed and Developed Interface between AML Correspondent Banking Mantas and Risk Model Integration.
• Analyze Newly created Alerts and Lost Alerts after executing Scenario Runs.
• Imported scenario XML into Mantas.
• Executed Batch Process to Extract, Transform and Load Customer, Accounts, Risk Rating and MT110 data from Staging into Mantas.
• Designed & developed efficient error handling using PL/ SQL procedures & triggers for different exceptions like multiple rows, no records found.
• Infrastructure setup of SIT, UAT and Production environments.
• Developed Unix Shell script to process MT110 Feed File into Collection tables and Validation of the Feed File.
• Developed Unix Shell script to Automated Reports for Production Support team and Development Support Team.
• Set up infrastructure for sending BSA files and Receiving Customer Risk feed file.
• Developed Reconciliation process between Feed File received from upstream source system and Transaction process through ETL Business Rules and loaded into Mantas.

Confidential, NYC, NY

Data Analyst, Senior Oracle PL/SQL Developer & Application Specialist

Responsibilities:

• Streamlined the returned check deposit function to automate the lookup and key entering of check information.
• Tracked and Recorded fund transfers between Confidential Operations Unclaimed Fund account and P&I account.
• Tracked and Recorded the transfer of aged funds from Confidential to Ginnie Mae.
• Automated submission requests for Unclaimed Funds.
• Automated the communication for aged funds due to Ginnie Mae.
• Involved End-to-End Solution and Implementation of MAMS application and validation of MAMS Forms business statuses in Legacy systems.
• Designed and Developed Workflow based Java/Oracle Business Processing Tool to capture and process Master Agreements.
• Designed and Developed Data Access Layers (DAL) to store the data captured through Java based UI.
• Designed and Developed Oracle based Workflow for complex process flow paths of MAMS FORMS.
• Mapped UI screen fields to Entity attribute and table columns based on Data dictionary.
• Involved in Logical/Physical model integration with UI.
• Developed Stored Procedures for Business validations.
• Developed and tested 250+ complicated database procedures using PL/SQL Cursors, REF Cursors, Pipelined Functions, Object Types.
• Involved in Application Deployment in DEV, SIT and UAT environments.
• Provided validation scripts for Production deployment of the Application.

Confidential, NYC, NY

Data Analyst, Senior Oracle PL/SQL Developer

Responsibilities:

• Designed and Developed Standardized Client Risk Model for Confidential Group.
• Automated generation of Risk Model based on fine tuning done by Compliance through the Configuration Tool.
• Developed Java based Risk Model Generator Tool as Proof of Concept.
• Developed Shell Scripts for auto generation of Risk Model.
• Automated Compilation of Risk Model into the Database using Shell Scripts.
• Developed Shell Script for Generation of Metric Report and Audit Log reports and automated Notifications.
• Involved in Analysis of AML Risk Score Calculations with PWC for Risk Model.
• Involved End-to-End Solution and Implementation of Risk Model and Validation of CitiKYC AML Risk Score with Risk Score calculated in SAS Risk Management Tool.
• Auto Generated PL/SQL Wrapper package to Calculating Risk Score for 1 million records in 15 min using Bulk Collection.
• Involved in Logical/Physical model integration with UI.
• Demonstrated capability of distilling details from complex business requirements into accurate and precisely specified functional, technical specifications and use cases capable of interpretation by both technical and non-technical readers.
• Replication Strategy of Global and Regional databases for various use cases using Golden Gate.
• Defined data types required (tables, fields, values, Picklist), how the data would be used, who would use the data, and how the data would flow internally and externally, including communications with other entities based on Compliance Forms.
• Built and managed a data dictionary to improve interoperability, validity and reliability of data across enterprise wide systems.
• Identified Performance bottlenecks, tuned applications by analyzing differences in Explain*Plan between RBO and CBO, Tweaking SQL statements to choose best execution path thus drastically reducing processing time in a Clustered environment.
• Implemented Risk Model in SIT and UAT environments.
• Performed Data Element mapping for BSU Case Management Tool in MS-Access Database.
• Developed Risk Model Metric Report and Audit Log Report using Oracle Analytic functions.
• Automated Report generation and Notification process using Mail and Shell Scripts.

Data Analyst, Senior Oracle PL/SQL Developer & Application DBA

Confidential

Responsibilities:

• Worked closely with Project One/OneSource in implementing and validating Pershing changes for Confidential Accounts and SSB accounts.
• Data Analysis on the feed received from Project One for Pershing changes for Confidential Accounts and SSB accounts.
• Coordinated with Project One for Pershing feed based on Project plan.
• Set up new environment for the Business users of Actimize application.
• Designed and Created required tablespaces, tables and views.
• Created required roles and provided grants for these roles.
• Loaded Pershing flat files using SQL*Loader.
• Point person for Production release of Pershing changes of Actimize application.
• Developed and tested 50+ complicated database procedures using PL/SQL Cursors, REF Cursors.
• Tuned backend PL/SQL Programs using indexes, BULK collections.
• Developed Reports using Analytical functions ROLLUP, CUBE, RANK, DENSE RANK and Inline Views.
• Worked closely with Developers for Capacity planning based on Business Requirements, Baseline and Percentage of Increase in data volume.

Data Analyst, Senior Oracle PL/SQL Developer & Application DBA

Confidential

Responsibilities:

• Performed Data Analysis for Confidential Models (HAM, Annual Review and Suitability scenarios).
• Worked with Mantas team in data mapping based on business functionality.
• Validated Confidential alerts based on BRD, FRD and TSD documents and identified the root cause.
• Worked with Mantas in fixing the root cause logs in Alert generation.
• Set up Autosys jobs for Confidential models.
• Worked with Project One in identifying new fields for Mantas application based on Business requirements.
• Performed Data Analysis on the feed received from Project One for Mantas changes.
• Worked with Ab-Intio team in generating DIS files.
• Developed and tested 15+ complicated database procedures using PL/SQL and cursors.