Experience

Doran Jones Inc.

• Software Engineer

  • Apr 2018 - Present

  As a Techno-Functional Analyst, I have been working on a US Banking Client's forecasting platform which enables the lines of business units to onboard their financial forecasting models namely baseline and CCAR stress from excel based tool to a more, innovative, controlled and workflow-enabled platform. The platform provides the capabilities to perform trend analysis, sensitivity analysis, scenario-based analysis, posting to GL, reporting and documentation. The in-house data visualization and… As a Techno-Functional Analyst, I have been working on a US Banking Client's forecasting platform which enables the lines of business units to onboard their financial forecasting models namely baseline and CCAR stress from excel based tool to a more, innovative, controlled and workflow-enabled platform. The platform provides the capabilities to perform trend analysis, sensitivity analysis, scenario-based analysis, posting to GL, reporting and documentation. The in-house data visualization and reporting tool incorporates the best of features from Excel, Tableau and other market-preferred visualization tools.• Primarily involved in the functional and technical solution design and assisting the team to implement the same.• Worked on creating the ETL framework for loading user data from disparate source systems into Oracle tables.• Functioning closely with the teams of Consumer Business to translate their 700+ forecasting models/calculation from excel to the newly integrated platform.• Designing solutions for the in-house data visualization tool which provides dashboarding, charting, documentation and drill down capabilities on the output data of the forecasting platform.• Designed and wrote database views on the forecasting output which can be utilized by the visualization tool.• Have written SQL scripts which have been utilized in the automation of data reconciliations between the forecasting output in Oracle and the reporting platform data in Mongo DB.• Participated in building the sensitivity analysis module, which helps the users to perform the what-if analysis on their forecasting model in a controlled environment.• Worked on the design and execution of the Overlays/Adjustment framework, capturing every overlay/adjustment applied by the analyst with sufficient audit details, leading to good governance. • Worked with the third-party UX design team to create user personas and align the process workflows based on the usage of the tool. Show more Show less



CGI

• Lead Analyst

  • Apr 2012 - Apr 2018

  As a Techno-Functional Analyst, I worked on building the Core Collateral Clearing platform for the Cleared OTC derivative products. The platform was built for the exposure and collateral management for the client and regulatory reporting. This enabled the banking client to conform to the Dodd-Frank Act with regards to the trading of OTC derivatives.• Worked on the onboarding of all major CCPs in US & Europe - CME, LCH and ICE, along with onboarding of OTC products such as Rates, Credit… As a Techno-Functional Analyst, I worked on building the Core Collateral Clearing platform for the Cleared OTC derivative products. The platform was built for the exposure and collateral management for the client and regulatory reporting. This enabled the banking client to conform to the Dodd-Frank Act with regards to the trading of OTC derivatives.• Worked on the onboarding of all major CCPs in US & Europe - CME, LCH and ICE, along with onboarding of OTC products such as Rates, Credit & FX NDF for client and dealer clearing business.• Worked on the ETL code which would take the trade data coming from CCPs and load it into fact and dimension tables.• In order to make the platform scalable with the addition of new CCPs and products, I worked on redesigning the ETL code to bring down the batch processing time from 4 hours to 1 hour by eliminating the redundant processes.• Wrote views and PL/SQL code for the Client statements and US Regulatory reporting.• Worked closely with the upstream systems on enabling daily or monthly Fees and Commissions reporting to the client’s statements and including it in the sub-ledger postings.• Developed reporting suite for the US Regulators, including reports such as Summary Equity run, Collateral summary, Risk-based summary, Debit deficit report, Margin call aging and LSOC Margin deficiency reports.• Extended the offerings of Cleared OTC platform to support Single currency margining, Convenience margining and Settlement at Sub-account level to clients.• Worked on record retention project to ensure compliance to the Dodd-Frank Act. by retaining all the files/data ingested into and files/reports produced out of the Cleared OTC platform, along with the metadata of the files/reports, in the WORM (Write Once Read Multiple) repository.• Participated in BOW planning & prioritization for each release, following the waterfall model for the SDLC. Show more Show less



Wipro Technologies

• Project Engineer

  • Sep 2008 - Apr 2012

  As an ETL, PL/SQL Developer, I worked on this project which was to develop a supply chain management data warehouse for the healthcare client. This was to help them analyze the data/reports for making management decisions related to the orders, inventory, materials etc.• Developed the ETL code to extract data using Informatica from SAP SCM system and flat files and loading it into Oracle data warehouse.• Used Informatica Data Explorer to profile the data before applying the ETL… As an ETL, PL/SQL Developer, I worked on this project which was to develop a supply chain management data warehouse for the healthcare client. This was to help them analyze the data/reports for making management decisions related to the orders, inventory, materials etc.• Developed the ETL code to extract data using Informatica from SAP SCM system and flat files and loading it into Oracle data warehouse.• Used Informatica Data Explorer to profile the data before applying the ETL process.• Worked on writing PL/SQL procedures for summarizing the data for reporting and switching synonyms for high data availability with no system down time during batch runs.• Responsible for ensuring the end-to-end batch processing in UAT & Production environments. Show more Show less