SUMMARY:

20 years of extensive experience in software design, development and system analysis. Extensive knowledge of cross - platform integrated solutions and data warehousing techniques: Experienced in all phases of Software Development Life Cycle with good communication and interpersonal skills.

TECHNICAL SKILLS:

BI & ETL: Ab-Initio, Aqua-Data Studio, Business-Objects, Cognos, Data-Stage, Informatica, Oracle E-Business Suite (Forms/Reports), Oracle Data Integrator (ODI), Pentaho (Kettle PDI), SQL Server BI Suite (SSAS/SSIS/SSRS)DBMS & File Systems: DB2, Drill, Hbase, HDFS (Hadoop), Informix, Oracle, SQL Server, SYBASE, Teradata, UDB, VSAM.

Languages: 4GL, COBOL, EGL, HTML, JCL, PL/SQL, Confidential -SQL, UNIX Shells (C/B/K).

Working Knowledge: ABAP, ASP, C, JAVA/J2EE, JSON, MDX, Natural, Perl, Python, RPG, VBA, Visual Basic, XML.

Tools: & Utilities: AutoSys, Control-M, Erwin, GitHub, Horton-Works, MQ Series, NDM, SQL-Developer, SQL*PLUS, SPUFI, SQL Server Management Studio, SVN, Sybase Power Designer, Tibco, TOAD, Ultra-Edit.

PROFESSIONAL EXPERIENCE:

Confidential

Database Solution Engineer, New York City, NY

Business Environment: Capital Markets, Equity Trading & Settlement, Finance and Regulatory Reporting.

Technologies: Oracle 12c RAC, Linux, HDFS (Hadoop), Hive, Drill, Impala, AutoSys, Python, Sybase, Tableau 10.0, Erwin.

Responsibilities:

• Responsible for design development and deployment of Equity Derivatives Data Warehouse ( Confidential ) which is a fully integrated operational data platform that has been designated for analytical/reporting support of multi-regional Cash Securities and Listed Derivatives Trading Desks as well as Middle Office technology and business units including: Order Management Systems, Product Control, Finance & Treasuries, Regulatory & Compliance.
• Research and evaluate alternative database solutions for collecting, processing and reporting data from various sources (Fidessa/Flextrade/Broadridge/Bloomberg/ SunGard/IDC) and recommending the most efficient and cost-effective solution for the project, ensuring consistency with enterprise direction.
• Create data models, deployment scripts and data profiling SQL queries utilizing Erwin and Aqua-Data Studio.
• Developed distributed ETL process utilizing Python conversion programs in conjunction with PL/SQL packages for converting and downloading execution orders, trades and allocation transactions into Oracle-RAC staging databases.
• Setup daily feed utilizing Pentaho and native utilities to extract product and account reference data from Sybase and Impala databases. Designed Type-2 dimensions and metadata extensions to truck and manage historical changes.
• Designed and developed ETL processes for loading historical trades and positions into Hadoop cluster (HDFS/Hive).
• Created distributed reporting model consolidating data from various sources into reporting views and aggregations.
• Setup BI extensions and analytical queries to support drill-down analysis and multi-views for Tableau users.

Confidential

Sr. Data Modeler / Database Developer, New York City, NY

Business Environment: Credit Risk and Finance: Regulatory-Reporting, Product-Control.

Technologies: Oracle 12c (Exadata), Java, Linux, Hadoop Ecosystem (HDFS/Hbase/Hive/Sqoop), Pentaho 6.0.

Responsibilities:

• Sr. Database Developer for Data Service Layer ( Confidential ) distributed data platform. The Data Service Layer for Risk and Finance IT is a component delivering a data abstraction/virtualization service for large volumes of data across multiple physical data sources. The solution is currently based around Java/Oracle technologies, with the need to expand its capabilities by using more cutting edge technologies such as Vertica, Hadoop and other Big Data solutions.
• Design and deploy distributed Data Ingestion Framework to export 2.5 billion sensitivity transactions from Credit Risk Information System (CRIS) data warehouse (Oracle 12C/Exadata) for parallel loading into Hadoop HDFS/HBASE cluster utilizing Sqoop and Pentaho ETL tools.
• Setup logical and physical data models (Power Designer) and functional components (PL/SQL Procedures and Packages) for loading CCAR-14Q reportable data into RDS (Regulatory Data Services) data mart.
• Tuned-up several PL/SQL processes to optimize performance and to cut down execution time by 40%.
• Translate high level BRD/FSD documentation and conceptual data models into detailed technical specifications.
• Review daily tasks (SCRUM) and projected deliverables with distributed off-shore development team (Poland/India).
• Coordinated production deployments and provided dedicated and reliable 24/7 L3 support as needed.

Confidential

Lead Developer / Technical Analyst: New York City, NY

Business Environment: Financial and Regulatory Reporting, Global Settlement Systems, Master Data Management (MDM).

Technologies: Oracle 12c, SQL Server 2012, Teradata v15, Informatica (9.1/B2B), AutoSys, Linux, PeopleSoft, Business Objects XI 3.1, Tableau 8.3, SSIS, WPF, Sybase Power-Designer, Oracle Golden-Gate, ADABAS/NATURAL.

Responsibilities:

• Sr. Data Modeler and Technical Lead - for the development and support of Nomura Common Data Infrastructure (NCDI), which is a Data Warehousing platform and related applications that have been designated to capture the full scope of Trading and Settlement activities across multi-regional Trading Desks (Fixed Income, Equities, Derivatives) for the support of global Financial and Regulatory reporting.
• Responsible for design, development and deployment of regional database components and ETL solutions for global Price Valuation system (IPV); which has been a designated Nomura price valuation engine to recalculate and validate Front-Office prices against global markets security pricing sources such as Bloomberg, Reuters and IDC.
• Actively participated in Nomura Back-Office Restructure project (BOAR - iMPACT) - preparing functional specifications data models, and ETL frameworks for the extracting and loading conversion data from Mainframe into Oracle and SQL Server replication databases. The key objective for this project was to replace Fixed-Income functional components of heavily outdated Mainframe-Based settlement system with newly developed third-party system (iMPACT) that's been delivered and installed by Broadridge. The goal of this project was to in corporate reporting components of the new system into the Data Warehouse design and ETL framework with minimal changes and less impact on reporting side.
• Designed Operational Data Store for Global Payment Reporting System to house all income events received from source systems, together with the results from tax processing, for downstream management and IRS/FATCA reporting.
• Designed and implement the structural enhancements for the Data Warehouse and peripheral applications.
• Coordinated development activities for global offshore technical teams utilizing agile methodologies.
• Actively Interacted with Business Stakeholders and BAs to define, agree, and document Functional Specifications.
• Collaborated with DBAs and Sys-Admins to achieve the highest level of database optimization and ETL performance.
• Implemented data integrity checkpoint and alerts utilizing Integrity Check Engine (ICE) reconciliation tools.
• Designed and setup Informatica mappings and workflows to load transactional and master data into the Warehouse.
• Optimized numerous Informatica processes by transforming complex mapping rules into PL/SQL Stored Procedures.
• Setup several ETL processes to extract/load customer and product updates into Global Reference Management System; utilizing Informatica PDO components in conjunction with Teradata BTEQ and FASTLOAD utilities.
• Created multi-query views and aggregated tables to support Tableau dash-boarding and visualization components.
• Prepared data sources, functional views and metadata extensions for Business Objects and Tableau reporting.
• Deployed miscellaneous PL/SQL procedures to enhance functionality of the ETL framework (Informatica/SSIS).
• Setup AutoSys jobs, Linux scripts. Coordinate monthly deployment releases. Provide Level-2 production support.
• Maintained physical and logical data models utilizing Sybase Power Designer modeling suite.

Confidential

Lead Database Developer/Architect, New York City, NY

Business Environment: Electronic Media, E-Commerce, Sales & Marketing, CRM

Technologies: Oracle 11g RAC, SQL-Server 2008, Java/JDBC, SSIS/SSRS/SSAS, Linux, Perl, Oracle WebLogic, CMS.

Responsibilities:

• Designed and implemented backend extensions to total access Entertainment and Publishing web portals including: Billboard, Brand-week, Hollywood - Reporter, Backstage and other Nielsen’s brands.
• Created enterprise data models and functional enhancements for direct sourcing of content management systems.
• Provided expertise on database deployment process, ETL design and tuning based on E-commerce platforms.
• Migrated several product fulfillment data sources from SQL/Server to Oracle utilizing DTS and SSIS packages.
• Created CRM reporting model utilizing SSAS (MDX) Cubes in conjunction with SSRS control reports.
• Setup functional specs and led development activities for a team of 5 off-shore developers based on agile approach.
• Assisted DBAs and system administrators with integration of several CDC channels utilizing Oracle Golden Gate replicators allowing near-real-time data exchange across various remote databases and Web-Services.

Confidential

Data Modeler/Application Developer, New York City, NY.

Business Environment: Health Insurance, Claims, Corporate Reporting.

Technologies: COBOL, Oracle 10G, UNIX, SQL Server 2005, TM1, ER/Studio, Informatica Power-Exchange, SSIS.

Responsibilities:

• Assisted Claims Management group with strategical migration from outdated mainframe system to distributed platform.
• Developed various conversion processes extracting data from Cobol/DB2/VSAM data sources for loading into Oracle.
• Setup distributed process to retrieve coordination of benefits information from SQL Server utilizing SSIS packages.
• Developed Informatica workflows and PL/SQL procedures to load essential claims information into conversion tables.
• Designed logical and physical data-models normalizing unstructured mainframe data into OLTP schema.
• Resolved performance issues within PL/SQL procedures using explain plan, TKPROF and dbms profiler.
• Produced and distributed several complex analytical reports utilizing Cognos (TM1 component).

Confidential

Database Developer, Mahwah, NJ

Business Environment: Transportation, Logistics, Package Delivery Information Acquisition.

Technologies: DB2, COBOL, CICS, Teradata, Linux, Oracle XML-DB, Siebel Business Analytics, IBM Data Stage.

Responsibilities:

• Provided dedicated technical and analytical support for DIR (DIAD Information Repository) data warehouse system:
• Developed data structures and functional components to extract and load external data into Teradata warehouse.
• Created generic Data-Stage jobs to download reference data from Mainframe into Teradata staging layer.
• Developed service modules (FTP/MQ/Linux/Oracle XMLDB) to parse XML transactions into DBMS acceptable formats.
• Setup integrated OLAP/BI reporting model to provide users with drill-down/roll-up capabilities thru Siebel interface.
• Maintained metadata extensions and setup deployment scripts including: FastLoad, Export, MultiLoad and BTEQ.
• Performance tuned numerous ETL jobs utilizing standard optimization techniques: Indexes, Partitions, and Hints etc.

Confidential I

Sr. Application Developer, East Hanover, NJ

Business Environment: Pharmaceuticals, Commercial Contract Management, Government Pricing.

Technologies: UNIX, SAP-R3, MF-COBOL, Oracle 10G, SQL-Server 2005, Cognos, EDI, Informatica PowerCenter 7.1

Responsibilities:

• Involved in design, development and support for CPCC System (Contract Pricing and Chargeback Component);
• Participated in design, development and deployment of Oracle/SAP based Chargeback Resubmission Module.
• Setup ETL routines (Cobol/PLSQL/Informatica) to enable automated acceptance of inbound EDI transactions.
• Wrote profiling programs for validating and formatting flat files into the standard SAP/R3 format (IDOCS).
• Setup several generic processes to extract Medicare & Medicaid rebates for loading into GP/CARS repository.
• Created analytical reports (Cognos) and dashboards to allow business users near-real-time view to resubmission data
• Developed conversion programs and database objects to support legacy migration to iMany and Model-N.
• Utilized replicators, DTS and Confidential -SQL triggers to support migration from outdated SQL Server database to Oracle 10g.
• Coordinated production deployments with off-shore teams and provided 24/7 Level-3 support.

Confidential

Lead Application Developer, Montvale, NJ

Business Environment: Auto Manufacturing, Sales & Marketing, CRM.

Technologies: Oracle 9I, Informix/4GL, DB2/UDB, Erwin, AutoSys, Cognos, Oracle Data Integrator (ODI), COBOL, JCL.

Responsibilities:

• Assisted CRM business team with design and development of several analytical and reporting data-marts.
• Created ETL distributed framework utilizing ODI tools to extract marketing data from various sources (Informix/DB2).
• Deployed consolidated OLAP cubes, and tabular SQL to support Cognos analytical and reporting components.
• Performed multidimensional data modeling and generated deployment scripts for tables and views utilizing Erwin.
• Wrote technical specifications prioritizing deliverables and maintaining workload distribution within development team.
• Setup several conversion processes to migrate functionality from Informix 4GL utilities to PL/SQL and ODI.

Confidential

Application Developer, Piscataway, NJ

Business Environment: Telecommunications, Billing Operations, Marketing, CRM.

Technologies: DB2, COBOL, Oracle 8i, Control-M, Ab-Initio, Informatica (PowerMart 6.2), Teradata, Cognos Report Studio.

Responsibilities:

• Developed ETL solutions for conversion of legacy ODS databases into newly developed analytical data platform.
• Setup logical and physical data models, technical specifications, functional diagrams, and control reports.
• Developed consolidated reporting model: including several Cognos reports in conjunction with CRM data components.
• Setup AbInitio graphs and Informatica mappings to streamline data exchange across multiple sources and targets.
• Created and maintained data structures and functional components (PLSQL/BTEQ/FastLoad) for Oracle and Teradata.

Confidential

Data Modeler/Database Developer, Franklin Lakes, NJ

Business Environment: Healthcare, Pharmacy Benefits Management, Financial Analysis, Corporate Reporting.

Technologies: IBM Mainframe, COBOL, DB2, MQ Series, UNIX, Oracle 8i, SQL Server 2000, Informix, Teradata (DW), Erwin.

Responsibilities:

• Enhanced various functional modules (COBOL/DB2/TERADATA) to accommodate HIPPA requirements
• Setup functional specifications, data models and test plans to streamline reference data into TERADATA warehouse.
• Created ETL processes to extract and load essential order-execution information from various corporate databases.
• Wrote PL/SQL packages to convert Teradata functionality (BTEQ, FastLoad) to equivalent Oracle PL/SQL blocks.
• Modified and tested various mainframe modules (CICS/COBOL/DB2/IMS/MQ) to comply with HIPAA requirements.
• Created stored procedures and functions to support daily data feeds from SQL Server to Oracle reporting system.
• Developed and tuned SQL*Loader control scripts and Teradata utilities to optimize data loads into staging databases.