Director - Data Architect, Operations & Reporting

• Mar 2022 - Present

Enterprise Data Architect

• Sep 2014 - Mar 2022

Sr. Oracle Architect & Informatica Consultant

• Dec 2006 - Sep 2014

Worked as Sr. Oracle Architect & Informatica Developer, Working as DA / DBA for various Projects under Alternative Investment Services & Broker Dealer Division at Bank of New York Mellon Client Since 2006 onwards. Worked in different BNYM projects for:- 1) Hedge Funds / Fund of Hedge Funds. 2) Transfer Accounting / Partnership Accounting. 3) Asset & Wealth Management. 4) Broker Dealer Service. 5) Broker Dealer Clearance. 6) Centralize Security Services. Experience… Show more Worked as Sr. Oracle Architect & Informatica Developer, Working as DA / DBA for various Projects under Alternative Investment Services & Broker Dealer Division at Bank of New York Mellon Client Since 2006 onwards. Worked in different BNYM projects for:- 1) Hedge Funds / Fund of Hedge Funds. 2) Transfer Accounting / Partnership Accounting. 3) Asset & Wealth Management. 4) Broker Dealer Service. 5) Broker Dealer Clearance. 6) Centralize Security Services. Experience Summary & Specialties:- Work with Client Leadership team, Client Business Partners, BNYM - Data Architects team & BNYM - DBA Support Group, Enterprise Informatica Support Group, 3rd Party Vendors & Developers, Implemented Technical & Business Solutions. Good understanding- Clearing & Settlement of Fed/DTCC Securities, Reference Data Mgt, Fixed Income Securities, Sedol, Repos, Options. Show less Worked as Sr. Oracle Architect & Informatica Developer, Working as DA / DBA for various Projects under Alternative Investment Services & Broker Dealer Division at Bank of New York Mellon Client Since 2006 onwards. Worked in different BNYM projects for:- 1) Hedge Funds / Fund of Hedge Funds. 2) Transfer Accounting / Partnership Accounting. 3) Asset & Wealth Management. 4) Broker Dealer Service. 5) Broker Dealer Clearance. 6) Centralize Security Services. Experience… Show more Worked as Sr. Oracle Architect & Informatica Developer, Working as DA / DBA for various Projects under Alternative Investment Services & Broker Dealer Division at Bank of New York Mellon Client Since 2006 onwards. Worked in different BNYM projects for:- 1) Hedge Funds / Fund of Hedge Funds. 2) Transfer Accounting / Partnership Accounting. 3) Asset & Wealth Management. 4) Broker Dealer Service. 5) Broker Dealer Clearance. 6) Centralize Security Services. Experience Summary & Specialties:- Work with Client Leadership team, Client Business Partners, BNYM - Data Architects team & BNYM - DBA Support Group, Enterprise Informatica Support Group, 3rd Party Vendors & Developers, Implemented Technical & Business Solutions. Good understanding- Clearing & Settlement of Fed/DTCC Securities, Reference Data Mgt, Fixed Income Securities, Sedol, Repos, Options. Show less

Sr. Oracle Consultant

• Jul 2006 - Dec 2006

Worked on OCVR Project - Using the Technologies :- Oracle 9i, Oracle Warehouse builder, PL/SQL, Oracle 9iDs-Developer suit, Forms & Reports, TOAD 8.1. This project involves loading voter registration data for all counties in Oregon State from text files into Oracle database to identify the potential duplicates. This involves designing common database tables and writing procedures and Oracle Warehouse builder to populate data in the Oracle tables from text files. Project also involves… Show more Worked on OCVR Project - Using the Technologies :- Oracle 9i, Oracle Warehouse builder, PL/SQL, Oracle 9iDs-Developer suit, Forms & Reports, TOAD 8.1. This project involves loading voter registration data for all counties in Oregon State from text files into Oracle database to identify the potential duplicates. This involves designing common database tables and writing procedures and Oracle Warehouse builder to populate data in the Oracle tables from text files. Project also involves designing and developing duplicate voters reports using Oracle forms and reports to identify duplicate voters registered in multiple counties. • Requirement gathering from the Counties. • Logical and Physical Database design. • Loading Data from Text files to Oracle Database using OWB. • Designing and developing Duplicate Voters reports using Oracle Forms and Reports. • Created a standard template for all the reports to be used by team members. • OWB for Mapping of all the counties. • Testing of standardized mapping using the PL/SQL Procedures & Packages. Show less Worked on OCVR Project - Using the Technologies :- Oracle 9i, Oracle Warehouse builder, PL/SQL, Oracle 9iDs-Developer suit, Forms & Reports, TOAD 8.1. This project involves loading voter registration data for all counties in Oregon State from text files into Oracle database to identify the potential duplicates. This involves designing common database tables and writing procedures and Oracle Warehouse builder to populate data in the Oracle tables from text files. Project also involves… Show more Worked on OCVR Project - Using the Technologies :- Oracle 9i, Oracle Warehouse builder, PL/SQL, Oracle 9iDs-Developer suit, Forms & Reports, TOAD 8.1. This project involves loading voter registration data for all counties in Oregon State from text files into Oracle database to identify the potential duplicates. This involves designing common database tables and writing procedures and Oracle Warehouse builder to populate data in the Oracle tables from text files. Project also involves designing and developing duplicate voters reports using Oracle forms and reports to identify duplicate voters registered in multiple counties. • Requirement gathering from the Counties. • Logical and Physical Database design. • Loading Data from Text files to Oracle Database using OWB. • Designing and developing Duplicate Voters reports using Oracle Forms and Reports. • Created a standard template for all the reports to be used by team members. • OWB for Mapping of all the counties. • Testing of standardized mapping using the PL/SQL Procedures & Packages. Show less

Sr. Oracle Consultant

• Jun 2005 - Aug 2006

Worked for AT&T Project as Data Analyst & DBA, Worked upon Oracle 9i, SQL*Plus, Oracle Warehouse builder, PL/SQL, Oracle 9iDs-Developer suits, Forms & Reports, TOAD 7.5, HTML, Java Scripts and SCO Unix. Project Synopsis :- The Federal Universal Service Fund (FUSF) was established on January 1, 1998 to provide rate discounts to eligible Schools & Libraries and Health Care Provides for their telecommunication services. The fund was created by assessing the intrastate and interstate… Show more Worked for AT&T Project as Data Analyst & DBA, Worked upon Oracle 9i, SQL*Plus, Oracle Warehouse builder, PL/SQL, Oracle 9iDs-Developer suits, Forms & Reports, TOAD 7.5, HTML, Java Scripts and SCO Unix. Project Synopsis :- The Federal Universal Service Fund (FUSF) was established on January 1, 1998 to provide rate discounts to eligible Schools & Libraries and Health Care Provides for their telecommunication services. The fund was created by assessing the intrastate and interstate revenues of providers of interstate telecommunication services. The New FAST system provides support to SBC Pacific Bell, SBC Nevada Bell, SBC SNET, SBC SWBT and SBC AIT organizations responsible for the administration of FUSF/E-Rate program. The yearly SBC Discounts for E-Rate exceed $300M. This program offers significant sales opportunities for schools and libraries. • Requirement gathering for the enhancement of project. • As a Sr. Member of the project, participate in the client meeting for enhancement of project. • Database tuning & performance tuning, Query optimization, Table partitioning and redesigning of Indexes. • Develop stored procedure & packages, functions to load & to extract the data. • Created a standard template for all the reports to be used by team members. • Allocate the resource for the development / sustenance & testing of code module. • Single point of contact between off-shore and on-shore team coordination. • Oracle warehouse builder for loading the data & procedure to generate the invoice reports to business group. • Unit Tested the PL/SQL Procedures, Reports, Test the integration of project and check the quality of the deliverable. Show less Worked for AT&T Project as Data Analyst & DBA, Worked upon Oracle 9i, SQL*Plus, Oracle Warehouse builder, PL/SQL, Oracle 9iDs-Developer suits, Forms & Reports, TOAD 7.5, HTML, Java Scripts and SCO Unix. Project Synopsis :- The Federal Universal Service Fund (FUSF) was established on January 1, 1998 to provide rate discounts to eligible Schools & Libraries and Health Care Provides for their telecommunication services. The fund was created by assessing the intrastate and interstate… Show more Worked for AT&T Project as Data Analyst & DBA, Worked upon Oracle 9i, SQL*Plus, Oracle Warehouse builder, PL/SQL, Oracle 9iDs-Developer suits, Forms & Reports, TOAD 7.5, HTML, Java Scripts and SCO Unix. Project Synopsis :- The Federal Universal Service Fund (FUSF) was established on January 1, 1998 to provide rate discounts to eligible Schools & Libraries and Health Care Provides for their telecommunication services. The fund was created by assessing the intrastate and interstate revenues of providers of interstate telecommunication services. The New FAST system provides support to SBC Pacific Bell, SBC Nevada Bell, SBC SNET, SBC SWBT and SBC AIT organizations responsible for the administration of FUSF/E-Rate program. The yearly SBC Discounts for E-Rate exceed $300M. This program offers significant sales opportunities for schools and libraries. • Requirement gathering for the enhancement of project. • As a Sr. Member of the project, participate in the client meeting for enhancement of project. • Database tuning & performance tuning, Query optimization, Table partitioning and redesigning of Indexes. • Develop stored procedure & packages, functions to load & to extract the data. • Created a standard template for all the reports to be used by team members. • Allocate the resource for the development / sustenance & testing of code module. • Single point of contact between off-shore and on-shore team coordination. • Oracle warehouse builder for loading the data & procedure to generate the invoice reports to business group. • Unit Tested the PL/SQL Procedures, Reports, Test the integration of project and check the quality of the deliverable. Show less

Oracle Developer Lead

• Oct 2004 - Jun 2005

Olayan Food Services (Burger King) Oct 2004 to Jun 2005 Project Name: OFS Project Description: Customer, Olayan Food Services in Saudi Arabia is the largest importer and distributor of food & consumer products in the Middle East. Across the Middle East & America, they have more than 500 stores & restaurants operations and Burger-King fast food chain is the part of their business operations. In Saudi Arabia & Dubai they have 39 & 26 stores respectively. For this project, complex Pl/Sql… Show more Olayan Food Services (Burger King) Oct 2004 to Jun 2005 Project Name: OFS Project Description: Customer, Olayan Food Services in Saudi Arabia is the largest importer and distributor of food & consumer products in the Middle East. Across the Middle East & America, they have more than 500 stores & restaurants operations and Burger-King fast food chain is the part of their business operations. In Saudi Arabia & Dubai they have 39 & 26 stores respectively. For this project, complex Pl/Sql code was used to get the data centralized. All the stores are having small access based software, which provide data as in a flat file. Then all the store data is loaded into builder at the end of day i.e. at 23:59 minutes. After that backend level procedure is executed to insert the relevant data into the fact table. The key objective of project was to extract the data from access and load them into a centralized Oracle9i database and from that database, management level reports is to be develop, using discoverer and PL/SQL reporting tool. The database used Oracle 9i Release-2. During this project I got a chance to deploy the application at the client location in Saudi Arabia & Dubai. This project is web-enabled and developed using Oracle9iAS, Oracle9i Developer Suite and HTML & JAVA Scripts. The primary objective of the BKOFS system is to create the new application system. Environment: Java, HTML, Oracle 9i Developer 6i – Form/Reports, TOAD 7.5, Oracle 9iAS Responsibilities: • Developed Stored Packages, Procedures & Functions using Html, JavaScript. • Testing the PL/SQL Procedures, Triggers, Forms and Reports. • As a member of the Project Team involved in interacting with Clients and gathering Business Requirements. • Used HTML and JavaScript in PL/SQL throughout the application. • Oracle Warehouse builder is used for Online Executive Reporting System. • Developed Forms & Reports in Oracle Developer Suits 9ids. • Responsible for Unit testing according to the Testing Standards. Show less Olayan Food Services (Burger King) Oct 2004 to Jun 2005 Project Name: OFS Project Description: Customer, Olayan Food Services in Saudi Arabia is the largest importer and distributor of food & consumer products in the Middle East. Across the Middle East & America, they have more than 500 stores & restaurants operations and Burger-King fast food chain is the part of their business operations. In Saudi Arabia & Dubai they have 39 & 26 stores respectively. For this project, complex Pl/Sql… Show more Olayan Food Services (Burger King) Oct 2004 to Jun 2005 Project Name: OFS Project Description: Customer, Olayan Food Services in Saudi Arabia is the largest importer and distributor of food & consumer products in the Middle East. Across the Middle East & America, they have more than 500 stores & restaurants operations and Burger-King fast food chain is the part of their business operations. In Saudi Arabia & Dubai they have 39 & 26 stores respectively. For this project, complex Pl/Sql code was used to get the data centralized. All the stores are having small access based software, which provide data as in a flat file. Then all the store data is loaded into builder at the end of day i.e. at 23:59 minutes. After that backend level procedure is executed to insert the relevant data into the fact table. The key objective of project was to extract the data from access and load them into a centralized Oracle9i database and from that database, management level reports is to be develop, using discoverer and PL/SQL reporting tool. The database used Oracle 9i Release-2. During this project I got a chance to deploy the application at the client location in Saudi Arabia & Dubai. This project is web-enabled and developed using Oracle9iAS, Oracle9i Developer Suite and HTML & JAVA Scripts. The primary objective of the BKOFS system is to create the new application system. Environment: Java, HTML, Oracle 9i Developer 6i – Form/Reports, TOAD 7.5, Oracle 9iAS Responsibilities: • Developed Stored Packages, Procedures & Functions using Html, JavaScript. • Testing the PL/SQL Procedures, Triggers, Forms and Reports. • As a member of the Project Team involved in interacting with Clients and gathering Business Requirements. • Used HTML and JavaScript in PL/SQL throughout the application. • Oracle Warehouse builder is used for Online Executive Reporting System. • Developed Forms & Reports in Oracle Developer Suits 9ids. • Responsible for Unit testing according to the Testing Standards. Show less

Oregon Secretary of State, Salem – OR

• Dec 2003 - Oct 2004

Project Name: OCVR Role: Oracle Developer Project Description: Elections Management & Centralized Voter Registration practice has been developed from the grounds up to assist states in implementing the Help America Vote Act (HAVA), especially section 303 (central voter registration) of the Act. Saber solution encompasses a highly customizable HAVA compliant election management & centralized voter registration system, a world class fault-tolerant, scalable and secure architecture, and a… Show more Project Name: OCVR Role: Oracle Developer Project Description: Elections Management & Centralized Voter Registration practice has been developed from the grounds up to assist states in implementing the Help America Vote Act (HAVA), especially section 303 (central voter registration) of the Act. Saber solution encompasses a highly customizable HAVA compliant election management & centralized voter registration system, a world class fault-tolerant, scalable and secure architecture, and a support program that provides dedicated onsite application and end-user (countries & towns) support. This project is basically developed to get correct information of voters at any given point of time. In Oregon State, Voting is done by postal mailing system. This system helps the voter to choose his representative by signing it and returning the ballots to county in charge. Project tenure is 31st Dec 2020 and to integrate this application to all the states of America, Starting from Oregon, Missouri and on. During the project I learned the electoral system of American state’s county level and state level. Environment: Oracle 9i PL/SQL, Developer Forms 6i / Reports 6i. Responsibilities: • Involved in Requirement analysis, Planning and Design. • Responsible for Unit Testing and Integrated Testing. • Performance Tuning of Application. • Simplification of Complex Business logic and Application Business Redesign • Responsible for Database Activities like Export, Import Utilities, Creating and maintaining Schemas. • Database Design and Tuning. • Maintenance of the System.

Senior Oracle Developer

• Aug 2003 - Dec 2003

CISRS – San Diego Workforce Partnership. Inc San Diego CA Aug 2003 to Dec 2003 Project Name: CISRS Role: Oracle Developer Project Description: (http://www.sandiegoatwork.com ) (http://www.workforce.org/cisrs/homeAction.do ) to get the background and details of the customer. The San Diego Workforce Partnership, Inc. (Workforce Partnership) is a 501(c) (3) tax-exempt organization that serves as the region’s Workforce broker, creating Workforce solutions for employers and a variety of… Show more CISRS – San Diego Workforce Partnership. Inc San Diego CA Aug 2003 to Dec 2003 Project Name: CISRS Role: Oracle Developer Project Description: (http://www.sandiegoatwork.com ) (http://www.workforce.org/cisrs/homeAction.do ) to get the background and details of the customer. The San Diego Workforce Partnership, Inc. (Workforce Partnership) is a 501(c) (3) tax-exempt organization that serves as the region’s Workforce broker, creating Workforce solutions for employers and a variety of Workforce development services to the region’s education and training providers, and to local residents. The CISRS system will be a complete Case management Tool for managing tracking and reporting on the activities of the Workforce Clients. The case manager will use CISRS to record and track all services provided to client. The main goal to be achieved through the CISRS application is to “Educate” and “Employ” the members. CISRS application is mainly concerned with three modules Workforce Investment Act (WIA), and Welfare-to-Work (WTW) administration. Environment: Java, HTML, JavaScripts, Oracle9iDS – Forms / Reports, TOAD 7.5, Oracle 9i PL/SQL. Responsibilities: • Involved in Requirement analysis, Planning and Design. • Setting up the Oracle Reports Server. • Developing Forms6i and Reports6i using Developer 9i, mod PL/SQL (PL/SQL, HTML, JavaScript). • Responsible for Unit Testing and Integrated Testing. • Performance Tuning of Application. • Simplification of Complex Business logic and Application Business Redesign. • Maintenance of the System. • Responsible for Unit Testing and Integrated Testing.

Oracle Developer

• Apr 2002 - Aug 2003

Project Name: ERP Role: Oracle Developer Project Description: Build ERP system for Neva Garments & Duke Fashions Ltd.. Environment: Oracle 8i – Developer 6i (Forms/Reports), TOAD 7.5, Oracle 8i (Rel-2), UNIX. Responsibilities: • Member of Development Staff. • Implementing ERP System, Oracle 8i and Forms6i. • Developed master & Transactions in Forms 6i. • Developed MIS reports for the existing system; system consists of 08 Modules. My roles is to develop End to End ERP… Show more Project Name: ERP Role: Oracle Developer Project Description: Build ERP system for Neva Garments & Duke Fashions Ltd.. Environment: Oracle 8i – Developer 6i (Forms/Reports), TOAD 7.5, Oracle 8i (Rel-2), UNIX. Responsibilities: • Member of Development Staff. • Implementing ERP System, Oracle 8i and Forms6i. • Developed master & Transactions in Forms 6i. • Developed MIS reports for the existing system; system consists of 08 Modules. My roles is to develop End to End ERP system, generating the reports. Show less Project Name: ERP Role: Oracle Developer Project Description: Build ERP system for Neva Garments & Duke Fashions Ltd.. Environment: Oracle 8i – Developer 6i (Forms/Reports), TOAD 7.5, Oracle 8i (Rel-2), UNIX. Responsibilities: • Member of Development Staff. • Implementing ERP System, Oracle 8i and Forms6i. • Developed master & Transactions in Forms 6i. • Developed MIS reports for the existing system; system consists of 08 Modules. My roles is to develop End to End ERP… Show more Project Name: ERP Role: Oracle Developer Project Description: Build ERP system for Neva Garments & Duke Fashions Ltd.. Environment: Oracle 8i – Developer 6i (Forms/Reports), TOAD 7.5, Oracle 8i (Rel-2), UNIX. Responsibilities: • Member of Development Staff. • Implementing ERP System, Oracle 8i and Forms6i. • Developed master & Transactions in Forms 6i. • Developed MIS reports for the existing system; system consists of 08 Modules. My roles is to develop End to End ERP system, generating the reports. Show less

Oracle Developer

• Jan 2000 - Apr 2002

Programmer and Worked on Oracle Forms/Reports Project Name: Raw-Material Management System Role: Oracle Developer Project Description: Worked on Sco-Unix Rel .5.0, Forms 3.0 & Reports, Oracle 7.0 PL/SQL as Backend & Pro*C as Language & worked as Sr. Programmer. Environment: Oracle 7.3, Oracle – Forms 3.0 & Reports, Sql*Plus, PL/SQL, SCO-UNIX – Pro*C Responsibilities: • Implementation of the new Modules and troubleshooting of existing modules. • Developed in house custom… Show more Programmer and Worked on Oracle Forms/Reports Project Name: Raw-Material Management System Role: Oracle Developer Project Description: Worked on Sco-Unix Rel .5.0, Forms 3.0 & Reports, Oracle 7.0 PL/SQL as Backend & Pro*C as Language & worked as Sr. Programmer. Environment: Oracle 7.3, Oracle – Forms 3.0 & Reports, Sql*Plus, PL/SQL, SCO-UNIX – Pro*C Responsibilities: • Implementation of the new Modules and troubleshooting of existing modules. • Developed in house custom application as per the users requirements. • Maintenance & upgrading the Existing System of Tata Consultancy Services i.e. Inventory, Payroll, Purchase, Production, Accounts, Raw Material, Packing and MIS. • Handling end users queries & their problems. Show less Programmer and Worked on Oracle Forms/Reports Project Name: Raw-Material Management System Role: Oracle Developer Project Description: Worked on Sco-Unix Rel .5.0, Forms 3.0 & Reports, Oracle 7.0 PL/SQL as Backend & Pro*C as Language & worked as Sr. Programmer. Environment: Oracle 7.3, Oracle – Forms 3.0 & Reports, Sql*Plus, PL/SQL, SCO-UNIX – Pro*C Responsibilities: • Implementation of the new Modules and troubleshooting of existing modules. • Developed in house custom… Show more Programmer and Worked on Oracle Forms/Reports Project Name: Raw-Material Management System Role: Oracle Developer Project Description: Worked on Sco-Unix Rel .5.0, Forms 3.0 & Reports, Oracle 7.0 PL/SQL as Backend & Pro*C as Language & worked as Sr. Programmer. Environment: Oracle 7.3, Oracle – Forms 3.0 & Reports, Sql*Plus, PL/SQL, SCO-UNIX – Pro*C Responsibilities: • Implementation of the new Modules and troubleshooting of existing modules. • Developed in house custom application as per the users requirements. • Maintenance & upgrading the Existing System of Tata Consultancy Services i.e. Inventory, Payroll, Purchase, Production, Accounts, Raw Material, Packing and MIS. • Handling end users queries & their problems. Show less