SUMMARY:

• An enthusiastic, confident, reliable Information Technology professional experienced in architecture and full life cycle software development of enterprise - wide business applications with particular expertise in ETL tools and solutions.
• Demonstrate expertise in planning, implementing and supporting corporate information systems with a focus on strategies that deliver efficiencies, cost savings and organizational competitiveness. Looking to joina company with unmatched commitment to customer success to work on challenging and interesting projects.
• Ten plus years hands-on experience in Data Warehousing, Data conversion, Data integration/ETL solutions and Business Intelligence domain. Experience to follow Agile methodology in application development
• Excellent expertise in integration of various data sources like Oracle, SQL Server, Flat Files, XML and binary files (Cobol copy books) into the data warehouse
• Good understanding of data governance principals and strong experience on data quality development, issue management and remediation
• Special emphasis on regulatory responses to Dodd-Frank, Basel and EMIR initiatives
• Strong knowledge in Global Markets Listed Derivatives utilizing SUNGARD GMI
• In depth understanding of Equities, Futures, OTC Trading and Regulatory reporting

TECHNICAL SKILLS:

Technical Domains: Data Warehousing, Business Intelligence, Data Modeling, ETL/ELT, Systems Integration, SUNGARD GMI software(AS/400 ), COBOL and IBM Mainframe Systems

Business Domains: Financial Services, Investment Banking, Derivatives, Equities

Databases/DB tools: Oracle, DB2, Sybase (UDB), SQL, PL/SQL, MS SQL, SQL*Plus

Documentation: Visio, MS Office, JIRA, INFOMAN, SDLC

Languages: UNIX Shell Script, SQL, XML, COBOL ||

ETL Tools: Informatica Power Center, IDQ, MDM, AB Initio

Dev Tools: PowerCenter Client, Eclipse, AB Initio GDE, Autosys, Windows/Linux OSMainframe Technologies: OS/ 390, ISPF, VS COBOL II, DB2/SQL/QMF/SPUFI, JCL, VSAM, Easytrieve, File Aid, Xpeditor, InterTest, Endevor, BMC, DB2, IBM Utilities, IBM MQ

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

ETL Technical Lead

Responsibilities:

• Designed and developed Informatica ETL process to integrate data from over 80 sources into IHC Enterprise Data Warehouse, composed of the OFSAA and Moody’s Analytics Data Mart. The covered Data Domains includes General Ledger, Loans, Security, Derivatives and Referential. Source data was a mix of Oracle database, flat and XML files
• Performed Data cleansing, Data Quality checks, and Business validations to improve decision-making capabilities and support transactional systems and master data processes
• Conducted business and technical analysis to gather functional requirements, identified business rules and transformation associated with relevant data domains, designed a Data Integration Hub to facilitate data movement across all environments
• Developed Unix Framework Architecture to facilitate pre and post ETL processing requirements and provide logging mechanism for ETL processes scheduled using Autosys job scheduling tool
• Performed SIT and end to end Integration testing, troubleshot and resolved issues
• Managed a team of offshore contractors for both development and testing to deliver projects

Environment: Informatica PowerCenter, IDQ, MDM, Oracle, SQL, UNIX Shell Scripting, Autosys, PL/SQL, SQL Developer, ERWIN, OFSAA

Confidential, New York, NY

Vice President / ETL Technical Lead

Responsibilities:

• Developed Global Online Listed Derivatives data warehouse platform to be a one stop shop ETD analysis with an effective combination of the near real time and historical transactions with retention of 3 years
• Rebuilt data services platform that helped increase revenue and generated new revenue stream; designed and developed robust ETL approach to process Futures, Future Options, Swaps, and other OTC trades seamlessly
• Implemented various enterprise-wide ETL projects for the ETD platform. Most of the work has been towards Position, Cash and Collateral management for various operations teams such Trade Management System, Credit Risk, Treasury, Prime Brokerage Repository and Data Consolidator
• Built ETL process for Regulatory reporting projects, such as Dodd-Frank, Basel and EMIR to provide more controls of trading processes. Project was critical to meet deadlines for Regulatory compliance
• Developed and implemented a novel automated structure for reports to replace manual data entry
• Managed a team of offshore contractors for both development and testing
• Conducted weekly nightly-batch production support
• Worked directly with business users to gather and document requirements, establish technical specifications and set deadlines and milestones

Environment: Informatica PowerCenter, IDQ, Sybase, DB2, Oracle, SQL, UNIX Shell Scripting, Autosys, PL/SQL, SQL*Plus, Business Objects, IBM AS/400

Confidential

Assistant Vice President/ ETL Technical Specialist

Responsibilities:

• Fully involved in decommission of in-house mainframe CPS application
• Acted as technical lead in designing, mapping and development of ETL process utilizing AB Initio tool
• Responsible for creating and executing data mapping, conversion scripts, numerous reports that reduced human needed hours for processes
• Built UNIX shell scripts for ETL execution, Batch processing and file verifications and validation
• Involved in the Code review Team that suggests the best way so that the product is stable and is implemented with the best performance and efficiency

Environment: Informatica PowerCenter, AB Initio, Sybase, Oracle, SQL, UNIX Shell Scripting, Autosys, PL/SQL, SQuirrel SQL, Business Objects, SUNGARD GMI(IBM AS/400), COBOL||, CICS, DB2, JCL

Confidential

Senior Programmer Analyst

Responsibilities:

• Developed Citibank Intranet website to support Depositary Receipts Operations System; improved turnaround times by extending processing cut off times
• Created and maintained tables, triggers and procedures
• Built stored procedures and queries

Environment: CICS Web Support (CWS), COBOL||, CICS, DB2/SQL, JavaScript, HTML

Confidential

Senior Programmer Analyst

Responsibilities:

• Implemented a top focus of Futures Back-Office Systems project -CPS Core Rewrite
• Developed, implemented and maintained several Futures Back-Office programming-related business processes, such as FX MOS, GAINS, Prime Brokerage, Commodity Cash Journals System, Commodity Funds, NextGen Futures Trading, IBAN, OFAC, SWIFT, VEC, Commodity Real-time Cash available
• Created SDLC documents and user manuals

Environment: COBOL||, CICS, DB2/SQL, SPUFI, VSAM, JCL, TSO/ISPF, FTP, INTERTESTSenior Programmer Analyst, ( )