Sangeetha Bashiam Email & Phone Number

New Jersey

This project is based out of JP Morgan Chase New York City and New Jersey facility. The project involves maintenance activity for the existing data warehouse and creating new data mart for Counterparty. Involved in Primarily involved in designing the counterparty exposure data mart and streamlining the existing ETL processes. Extensively involved in data analysis, data reporting and reconciliation of products - Cleared Derivatives (OTC Bilateral, OTC Cleared, Futures and Options), Repo, FXForwards, Bank Loans, Prime Brokerage and TBA by closely working with Business group and technical group for data feed and closing the gap with operations data and making NEWTON data usable for weekly statistics. Involved in onboarding new feeds for counterparty exposure based on data analysis and reporting by closely working with business and operations team to understand the business requirements and the data availability to NEWTON. Involved in converting the manual user tool maintained by business group for Counterparty risk reporting by onboarding the data and report generation in NEWTON Counterparty and eliminated the manual report generation process. Involved in designing the ETL process, maintenance and defect fixing of the currently implemented ETL process. Involved in migrating the reporting data from Oracle database to Green Plum database and creating of statistical report in Tableau and exposing the report to users. Involved in modeling of database tables and views to have unique source from Tableau reporting. Tuning the SQL queries written in the Informatica and utilize these queries to process the data, transform and transpose by applying business logic. Using the Control-M scheduling tool design/manage the scheduling of the Informatica workflows. Heading the deployment activity for this project into Production and UAT environments.

Worked for Abbott Laboratories/ AbbVie Inc. project from Jan 2011 as a senior developer. Abbott’s Supply chain management (SCM) used Manugistics application for Demand Forecasting and Fulfillment. I have been invloved in Phase 2 and Phase 3 enhancements of Demand Forecasting and Fulfillment load process.I have worked on different phases of implementation from Requirement Analysis, Project Design, Project Development, Unit Testing, Integration Testing and Production Support.Involved in coordinating with offshore team for ECC Enhancement project.Worked on Autosys job scheduling process.Involved in performance improvement.

I worked for Citi-Nait GDS as a developer. Citi-Nait provides maintenance and enhancements for Citibank Online services developed on the Java Financial Platform (JFP) for U.S Business. The JFP framework is a proprietary framework developed, in-house by Citi and is used as presentation layer to achieve a consistent look and feel of its banking applications related to retail consumers.The project involves many sub-teams revolving around supporting the following applications.•Banking Apps application •Account Opening •Citibank Online (CBOL) MISI have worked in the all above mentioned applications of Citibank Online