SUMMARY:

• 20+ years of full life - cycle software development project experience in USA.
• 12+ years of design/development experience in Oracle PL/SQL, UNIX and Data warehousing projects.
• 6+ years of project development experience using Sybase / MS SQL Server Databases.
• Oracle 10g RAC Replication development and support experience.
• Extensively worked on building complex SQL queries, complex business rules and SQL performance tuning.
• Experience with Options Trading Application Systems.
• Experience with Federal Banking Projects CCAR, ODS and Regulatory Projects.
• Experience with Basel II and Credit Risk Data Warehouse projects.
• Experience with Investments Trading Systems development and production support.
• Experience with Publisher Subscriber Messaging Interface Applications.
• Experience with Data Vault, Data Mart, Data Warehousing and ETL projects.
• Experience with Logical, Physical, Relational and Fact/Dimensional Model.
• Experience with Hub, Satellite and Link tables based Data Vault Design and Development.
• Experience with Waterfall and Agile type SDLC projects..
• Experience with software integration and package applications like MAXIMIS, Charles River and Principia.
• 24/7 - On site and On-call production job schedule support experience for critical Investment Systems.
• Ability to work independently and accomplish assigned objectives, while under significant pressure.
• Superior communication, organizational and interpersonal skills.

TECHNICAL SKILLS:

Databases: Oracle 11g, 10g, 9i, 8 & 7x, Oracle 10g RAC, Netezza 7.1.0.2, Sybase System 11.0.2,10 & 4.9.2, SQL Server 2008, 2005 & 4.2, INGRES 6.2, SIBAS, DB2 and Terra data.

Languages: SQL, PL/SQL, T-SQL, NetezzaSQL, UNIX Shell Scripts and COBOL.

Tools: Experience: Aginity Workbench 4.3, Control-M, UC4 9.0, BMC Remedy, Oracle Data Mart Builder, Oracle Discoverer, Oracle Data Designer, TOAD 11.0.0.116 and 8.6.10, Squirrel SQL 3.5.0, Data Studio 4.1.0, SQL Developer, Business Objects, Erwin, Visio, VSS, PVCS, Power Designer 11, HP Quality Center, Check free Recon System 6.0, Lotus Notes, MS Access, Excel, Risk Frontier, INFORMATICA Data Explorer 8.6, Prism Warehouse Enterprise, Prism Warehouse Manager 4.5, Cast Workbench, Crystal Reports, SQL Builder, Power Builder 3.0-5.0, DB Artisan 2.56, Brio, Rapid SQL 7.2.1, Platinum Desktop DBA 3.2.4, Ingres and 4GL.

Hardware Platform: HP 9000-H50, HP 9000-800, SUN-E10K, Sun Sparc10.

Operating Systems: HP UX 10.0 & 9.04, SUN Solaris 10, 5.8 & 2.3, AIX-Unix and MS-Windows.

Scheduling Tools: UC4 Automation Engine V9, Control-M, IBM Tivoli Workload Scheduler 8.3 and CA Unicenter Workload Manager.

PROFESSIONAL EXPERIENCE:

Confidential

IT Consultant

Responsibilities:

• Performed production tasks to remediate monthly production design and data quality edit checks issues for Retail CCAR FR Y-14M/Q First Lien, Home Equity, Auto, Cards and Retail Commercial Systems.
• Design process to automate team monthly process to improve data quality to reduce team work load.
• Design and development of CCAR Retail team key projects FRB Home Equity Historical Resubmission project, FRB US Auto Schedule Historical Resubmission projects, Auto LLR Charge-off Project, Retail Missing Loans Project and Automation of Attestation Modules.
• Performed data analysis and prepared ad hoc SQL queries and reports for CCAR Y14-M/Q systems.

Software and Tools: NetezzaSQL, Aginity Workbench 4.3, Netezza 7.1.0.2, CCAR QCT, Business Objects, SAP Power Designer, SQL and Excel.

Confidential

IT Consultant

Responsibilities:

• Performed tasks to collect business requirements, data analysis, create complex business rules SQL, create job batch scripts for production jobs, preparation of approach, design and support documents, perform unit and integration test and production implementation tasks for OCC corporate project Widening Options Bid Ask Spread.
• Design process to create, publish and archive Encore Price Repository LRP data fields Delta, Vega, Trade Volume, Final Best Bid and Final Best Ask data from price repository object.
• Developed process to create data load extract from price repository object and perform data quality validation checks on source data for OCC products.

Software and Tools: IBM DB2, SQL, UNIX Scripts, UC4, Visio, Squirrel SQL, HP ALM v12 and Excel.

Confidential

IT Consultant

Responsibilities:

• Collected Business Requirements, Designed and Analyzed Origination Data Systems, Prepared Data Mapping, Process Flow Diagrams and Design Documents, Developed SQL test scripts validate data between source and target business rules for Federal Banking Project CCAR FR Y-14M / FR Y-14Q.
• Performed tasks to collect requirements, source system data analysis, design, development of complex business rules and queries, preparation of design documents, testing and balancing tasks for CRIS Credit Risk Data Warehousing project.
• Performed business gathering, design and development work for BEC (Credit Risk Economic Capital Replacement and Reporting Project) to allow users to update data in PRE STAGING SQL Server database before importing into STAGING and ultimately CORE Risk Frontier Moody Database. BEC provides trigger based audit trail, change history and final backup of pre staging database.
• Performed design and development work for Pillar III Credit Risk Reporting System.
• Developed data profile test condition rules to identify pattern analysis, length analysis, null analysis or value analysis rules to identify source data issues and perform business related test cases to prevent data issues related to ALGO RWA calculation process to help data fit for Basel II Credit Risk Data warehouse System.
• Design and development of data quality framework to identify source systems data quality issues.
• Developed Data Quality Dashboard and Scorecard process to monitor all defects, priorities and status.
• Performed application migration tasks between Oracle 9i and Oracle 10g databases.
• Designed and developed GIN code and data migration tasks between Sybase and Oracle10g database.
• Studied the performance of database procedures to improve overall process execution time (NPF/IDP).
• Tuning of PL-SQL queries using statement level optimizer hints, handling of indexes and run parallel process to improve database performance and reduce response time of critical production jobs.
• Responsible for supporting Oracle ref cursor procedures, external tables, global temporary tables, pipe lined functions and data collection procedures.
• Designed and developed database tables, indexes, packages, stored procedures, triggers, views, functions, control scripts and database automation scripts.
• Developed UNIX batch scripts to support automation of data load process.
• Documented the nightly Control-M production jobs, process flow and data feeds.

Software and Tools: Oracle 11g / 10g / Oracle 9i, SQL Server 2008, Sybase 11.0.2, PL-SQL, T-SQL, Rapid SQL 7.2.1, SQL Developer, Solaris 5.8, UNIX Scripts, BCP, Data Explorer 8.6, Remedy, Visio, Lotus Notes, Erwin, Power Designer, Control - M, PVCS, Access and Excel.

Confidential

IT Consultant

Responsibilities:

• Performed tasks to collect business requirements, source system data analysis, design, Oracle PL-SQL and UNIX Scripts development, Preparation of design and support documents, performance testing and production support tasks for CBOE Data Warehousing projects.
• Performed design, development and production support tasks for high volume intraday node clustered DWS Oracle 10g RAC Replication Database Projects.
• Developed application projects to support IPD, MEMBERSHIP, STOCKS, QUOTES, RIO, CSTATS, DTCC, OCC and CDB application data and feeds. Designed and documented Control-M production job, process flow, test plan and external data feeds.

Software and Tools: Oracle 11g, PL-SQL, Solaris 10, UNIX Scripts, BMC Remedy, Visio, Control - M, Clear case and Excel.

Confidential

IT Consultant

Responsibilities:

• Elicited and verified business requirements to promote full understanding of the scope and scale of business needs. Designed relational database objects to support the proposed database design and architecture.
• Data analysis, design, data migrations from Terra data legacy systems, development and Unit and integration testing work for CNA Data warehouse project SBMIS and Oracle FRS Retool system.
• Prism tools to capture and maintain FRS Meta data information.
• Application code/data migration from Prism Warehouse Manager (PWM) to Prism Workbench (PWE) for FRS Retool Data Warehouse / Data Marts application.
• Sybase on a HP-UX platform, DB Artisan, Rapid SQL, Erwin and Power builder.
• Oracle 7.3.2 on a HP-UX platform, PWM 4.5, PWE, COBOL, Unix Scripts, Visio and DB Artisan.

Confidential

Programmer Analyst

Responsibilities:

• Performed Application Development, Production Support, UNIX Administration (HP-UX, SUN Solaris) and Sybase Database Administration for International Accounting Settlement System (IAS).
• Sybase on HP-UX, SUN Solaris, SQL Windows, Erwin and MS-SQL Server on Windows NT platform.