SUMMARY:

• Worked in data warehouses at Confidential and wrote complex procedures/functions to develop reports required by SEC and Federal Reserve.
• Migrated legacy PL/SQL code to Confidential SL Controller view.
• Used Confidential Controller view to develop CCAR 14Q, 14A, FRY9C reports.
• Created data sources, data models, modify models, shorthand, portfolios, Aggregations, workflows in Confidential controller view to generate freeform and tabular reports.
• Developed code to check data quality in Confidential . Generated exceptions for various data issues like missing DBP and Non - DBP contracts. Identified orphan records.
• Developed PL/SQL code to validated MDRMs.
• Interacted with users, analyzed business and operational rules for Trade Reporting and Compliance Engine (TRACE) for Securitized Products (SP) to comply with Confidential regulation.
• Developed applications to implement Sunshine Act. Designed and developed code for POINT, TRACS applications. Developed compliance reports.
• Tuned stored procedures to increase performance. Ran dbms profiler on stored procedures and analyzed the generated information to fine tune and increase the performance. Used explain plan utility to study execution plans.
• Worked in Online Transaction Processing (OLTP) systems characterized by high throughput, many users, and a mix of DML operations (insert, update, and delete) and queries. Wrote high speed queries using bulk collect and forall features of Oracle.
• Used oracle packages and hints to fine tune queries.
• Participated in requirement analysis, analyzed business and operational rules and translated them into functional specifications. Designed and developed code used by java based font-end application (SAMS).
• Migrated oracle tables/scripts to Netezza.
• Loaded data using NZ Load, ETL tools, SQL*Loader, Oracle import/export and external tables.
• Converted complex PL/SQL procedures into NZSQL queries to increase performance of modules.
• Participated in debugging of Netezza software and contributed for the development of Netezza.
• Used advanced PL/SQL concepts (VARRAYS, REF CURSORS, User defined OBJECTS) to create stored procedures, functions and packages.
• Created mappings and workflows in Informatica Power Center and OWB. Loaded data from various sources like flat files and tables.
• Created and used SAS data sets.
• Used Oracle analytic functions to process data and increase performance.
• Designed and developed MIS-reports for Real-time Transaction Reporting System (RTRS) to comply with MSRB rules.
• Designed and developed financial and research applications, interacted with users to know the requirements, analyzed business and operational rules.
• Worked with the Confidential Regulation, Market Surveillance department, to help systemically identify trading, market, rule violations and manipulations and package them with supporting information and forward to upstream systems for further study and analysis by the users. My tasks involved, understanding the business requirements and translating them into functional specifications, design and develop code for the detection of the violations and manipulations.
• Designed and developed applications for detection of market manipulations. Interacted with users to know the requirements, analyzed business and operational rules.
• Designed and developed databases for Market Surveillances.
• Experience in Data Warehousing, ETL (Extraction, Transformation, and Loading), Data Mapping and Data Loading techniques. Developed complex mappings and process-flows in OWB9i/OWB10g in Confidential ( Confidential ) project of Confidential ( Confidential ). Loaded data from flat files and external tables into staging and target tables. Added restart-ability to mappings. Loaded data using partition exchange.
• Wrote procedures and triggers for password security to enforce secure and standard norms throughout the database. Maintained database and monitored database security using Enterprise Manager Console. Wrote source code for procedures, functions, triggers and libraries.
• Configured the repository of Designer6i, Designer/2000. Reverse Engineered existing applications and database objects using Designer6i, Designer/2000. Set data presentation standards, defined table usages and maintained Application Database in Designer6i, Designer/2000.
• Developed modules using Netezza, Oracle 7.X, Oracle 8.X, Oracle8i, Oracle9i,Oracle 10g, Oracle 11g and Oracle tools such as Designer6i, Forms6i, Reports6i, Discoverer, Designer/2000,Oracle Jdeveloper, J2EE, Oracle9iAS, Developer/2000, Crystal Reports, Erwin, SQLJ, SQL*PLUS, SQL Developer PL/SQL,C++,XML, SQL*Loader, Perl, SAS.
• Designed, developed, modified, and tested modules for data entry, data retrieval and payroll processing.
• Participated in requirement analysis, created staging tables, archive tables, views, triggers for repository and created web based applications using Java and JDBC in J-BOSC project at Confidential .
• Worked in Grants Management System for NIH project at Confidential Inc. ..
• Experience includes qualitative and quantitative data analysis and interpretation of results through verbal and written reports

TECHNICAL SKILLS:

Languages: SQL, SQLJ, PL/SQL, C++, Java, XML, ABAP4, Perl, SAS

Tools: OWB9.2/10g,Informatica PC, Designer6i, Discoverer, Dsigner2000, Forms6i, Reports6i, Developer2000, JDeveloper, Oracle9iAS, Oracle Enterprise Manager, SQL Developer, ODI/Sunopsis, SQL*Loader. Power Center 8.2, Confidential SL Controller view 9.6.6

RDBMS: ORACLE 6.X, ORACLE 7.X, ORACLE 8.X, ORACLE 8i, ORACLE 9i, ORACLE 10g, ORACLE 11g ORACLE 12c, Netezza.

Operating Systems: UNIX, Windows NT, Windows 2000, Windows XP, Windows 98, Linux.

Other: SAP, ERWIN, CRYSTAL REPORTS, PERL, XML, TOAD, PVCS, CLEARCASE.

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst/ Senior Oracle Programmer

Responsibilities:

• Used Confidential Controller view to develop CCAR 14Q, 14A, Y9C reports.
• Created data sources, data models, modify models, shorthand, portfolios, Aggregations, workflows in Confidential controller view to generate freeform and tabular reports.
• Planned and executed the migration of legacy PL/SQL code to Confidential SL Controller view. Has expert knowledge in migration of legacy code to Confidential .
• Wrote PL/SQL packages and procedures and called them from loader action tab to resolve complex business logic. Tuned stored procedures to increase performance. Used Oracle analytic functions to process data and increase performance.
• Developed code to check data quality in Confidential . Developed PL/SQL code to validated MDRMs.
• Analyzed business and operational rules by interacting with FAs and business users. Interacted with offshore and onsite teams on daily basis and participated in testing and deployment.
• Responsible for migrating database objects from environment to another.

Confidential

Senior Oracle Programmer/ Consultant

Responsibilities:

• Responsible for ETL of data into Oracle tables in the Tax Information Global Repository Database.
• Resolved production issues and supported frontend applications.
• Designed and developed schemas. Loaded data into tables using external tables.
• Tuned stored procedures and SQL queries to increase performance.
• Did mapping, migration and archiving of data using advanced PL/SQL concepts.

Confidential

Technical Analyst/Consultant

Responsibilities:

• Loaded data into tables in data warehouse using ETL tools and developed reports.
• Created mappings and workflows in Informatica Power Center. Loaded data from various sources like flat files and tables.
• Used different transformations.
• Used advanced PL/SQL concepts (VARRAYS, REF CURSORS, User defined OBJECTS) to create stored procedures, functions and packages. Did performance tuning. Used oracle dbms profiler and hints.

Confidential

Technical Analyst/Consultant

Responsibilities:

• Worked in Online Transaction Processing (OLTP) system characterized by high throughput, many users, and a mix of DML operations. Wrote high speed queries using bulk collect and FORALL features of Oracle.
• Used advanced PL/SQL concepts to create stored procedures, functions and packages.
• Tuned stored procedures to increase performance. Ran dbms profiler on stored procedures and analyzed the generated information to tune and increase the performance.
• Responsible for bulk loading of data into database tables ODI.
• Created mappings and workflows in Informatica Power Center. Loaded data from various sources like flat files and tables.

Confidential

Technical Analyst/ PM

Responsibilities:

• Used advanced PL/SQL concepts (VARRAYS, REF CURSORS, User defined OBJECTS) to create stored procedures, functions and packages.
• Worked in Online Transaction Processing (OLTP) system characterized by high throughput, many users, and a mix of DML operations (insert, update, and delete) and queries. Wrote high speed queries using bulk collect and FORALL features of Oracle. Loaded data into database tables using SQL*Loader, ODI.
• Used Oracle analytic functions to process data and increase performance
• Interacted with Confidential and Confidential to integrate Confidential TRACE dashboard with Computer to Computer Interface (CTCI) of Confidential .
• Designed and developed MIS-reports for RTRS (MSRB) to comply with MSRB rules. Wrote PL/SQL procedures and SQL scripts for trade reconciliation.
• Processed EDI inbound files, translated codes, and transferred data into tables. Generated outbound files for EDI.

Confidential

Technical Analyst/ Consultant

Responsibilities:

• Designed and developed source code for detection of market manipulations.
• Migrated oracle tables/scripts to Netezza. Loaded data using NZLoad.
• Loaded data using ODI/Sunopsis, SQL*Loader. Converted complex PL/SQL procedures into NZSQL queries to increase performance of modules.
• Created and used SAS data sets.
• Designed and developed databases for Market Surveillances.
• Resolved production issues. Tuned stored procedures to increase performance.
• Designing of programs included recreation of market conditions (post-trade), analyzing the broker’s behavior in comparison to established norms and generating exceptions, alerts, reports needed by SEC.
• Participated in requirement analysis, analyzed business and operational rules and did documentation.
• Developed complex mappings and process-flows for ETL (Extraction, Transformation, and Loading) using Informatica PC.
• Used advanced PL/SQL concepts (PL/SQL tables, cursors, user defined object types) in application development. Created external tables, staging table to load data from flat files.

Confidential, VA

Programmer

Responsibilities:

• Worked in data loads team of Confidential ( Confidential ) project of Confidential ( Confidential ).
• Participated in requirement analysis, analyzed business and operational rules and did documentation.
• Developed complex mappings and process-flows in OWB9i/OWB10g for ETL (Extraction, Transformation, and Loading).
• Used various transformations, pre and post mapping operators in mappings.
• Used advanced PL/SQL concepts (PL/SQL tables, cursors, user defined object types) in application development.
• Loaded data into tables using tools like SQL*Loader, Sunopsis. Generated flat files from database tables using Sunopsis.
• Loaded data into target tables from staging tables.
• Responsible for adding restart-ability to mappings to load data into database without errors. Used partition exchange.
• Used set-based, set-based failover to row-based, row-based modes depending on various situations.

Confidential, NYC

Programmer/Analyst

Responsibilities:

• Designed and developed financial applications at Confidential ( Confidential ). Wrote source code, analyzed business and operational rules. Developed reports from unrelated tables based on chronology. Wrote complex procedures/functions to develop reports required by SEC in the Data warehouse (VLDB) of Confidential .
• Wrote PL/SQL procedures, triggers, created views, temp tables in database.
• Used advanced PL/SQL concepts (Varrays, PL/SQL tables, cursors, user defined object types) in application development. Loaded data with SQL*Loader and PL/SQL Packages using shell scripts. Did tuning to enhance performance of database/application in Very Large Data Bases.

Confidential, Richmond, VA

Programmer

Responsibilities:

• Developed/Modified/Improved various user interface screens at Confidential Solutions using oracle tools such as Discoverer, Oracle Designer 6, Forms6, Reports6.
• Wrote PL/SQL source code/procedures/functions/packages and developed web based oracle application systems.

Confidential, Lanham, Maryland

Systems Analyst

Responsibilities:

• Interacted with users to know the requirements, analyzed business and operational rules for development of modules. Wrote source code for stored procedures, functions, triggers, and libraries.
• Wrote PL/SQL procedures for password security for enforcing secure and standard norms throughout the database in a client server environment. Maintained and monitored database security using Enterprise Manager Console.
• Designed, developed. Modified and tested modules for data entry, data retrieval and Payroll Processing in VMS and SPAN applications. Made several changes to payroll systems to enhance the application’s use in payroll processing. New modules were created in payroll system to automate the supplemental payments and payroll processing.
• Designed/developed Modules/Reports using Oracle and Oracle tools such as Designer6i, Forms6i, Reports6i, Discoverer, Designer/2000, Developer/2000, JDeveloper, SQL*PLUS, PL/SQL .Developed web applications and did performance tuning.
• Reverse Engineered existing applications and database objects using Designer6i, Designer/2000. Set data presentation standards, defined table usages and maintained Application Database in Designer6i, Designer/2000.
• Created tables, views, sequences using Designer6i, Designer/2000. Converted forms4.5 to forms6i.
• Procedures in the existing application were modified and new procedures were written. Participated in redesigning of modules and tables and conversion of data from VMS to CSPAN.
• Developed prototypes of web applications and reusable components like EJB, JSP using Oracle JDeveloper, and Oracle9iAS. Created BC4J in Integrated Development Environment (IDE).
• Existing modules were debugged in SPAN by modifying procedures, triggers, and functions. New modules were created to enhance the use of SPAN application. Loaded data with SQL*Loader and PL/SQL Packages. Changes were made to existing reports and new reports were created in SPAN. Actively involved in the maintenance of existing applications.