SUMMARY:

Several years of strong Technical Leadership, Business Analysis, Data Modeling, Business Intelligence, ETL, Data Warehouse Architecture, Data Integration and Development experience. Strong Data Modeling & Design (Logical & Physical). Good Communication, analytical skills and versatile working individually as well as within a team.

CORE COMPETENCIES:

• Technical Leadership
• Data Modeling
• Business Intelligence
• ETL Design & Development
• DW Architecture
• MDM
• Dimensional Modeling
• Data Integration
• FI Instrument Reference
• Data Management
• CDS Reference Data
• FI Ratings
• SDLC
• Version Management
• Project Management
• Agile Methodology

EXPERIENCE:

Confidential, Redwood City, CA

Sr. ETL Consultant

Responsibilities:

• Hands - on involvement in analysis of the Confidential data sources - for example, NetSuite, Workday and Salesforce to acquire, transform and load data into a set of repositories on the cloud using Snaplogic cloud based ETL integration tool.
• Setting standards, ETL architecture and providing technical leadership and guidance to the ETL developers and integrators in the US and in Europe.
• Requirement Analysis, Business Process Flow Design and Scheduling. Design and development of re-usable components.
• Data Modeling at individual tenant database level, based on specific business process requirements.
• Instrumental in the process of migrating the company from using Snaplogic 3.x to the cloud based version 4.x. This involved developing re-usable components for developers/partners, providing feedback to Snaplogic for tool enhancements, training developers/partners and enabling the Confidential application to adopt the new Snaplogic version 4.x

Environment: Snaplogic 3.7,/4.x, AWS RDS, Postgres 9.4/9.5, UNIX Shell Scripting, Python, AWS S3, Git, Hadoop 2 CDH4/5, Redshift

Confidential, Stamford CT

Associate Director

Responsibilities:

• Responsibilities involving design, development and maintenance of feeds from the Confidential external sources including MarkIT, CME, ICE, Confidential 's, S&P & Fitch.
• Providing technical leadership to outsourced team members, writing technical specifications, data architecture diagramming, suggesting best practices to outsourced team members.
• Data Model Design and development of ETL extensively using SQL, PL/SQL, packages, procedures, materialized views, analytical functions, SQL*Loader.
• Performance tuning of ETL jobs and SQL queries used in data distribution.
• Extensive use of optimized SQL to replace PL/SQL as far as possible thereby reducing a lot of the context switching.
• Development of unix shells script and wrappers for the ETL modules.
• Investigation of the use of Informatica as an ETL tool for future feeds.

Environment: Oracle 11g, SQL, PL/SQL, UNIX Shell Scripting, Tortoise SVN, Autosys, TOAD, Informatica 7.1.2, 9.1.0, PVCS

Confidential, Brooklyn, NY

Sr. Oracle Developer/Consultant

Responsibilities:

• Used Kimball methodology to design and model the ODS & DW schemas.
• Data Model Design and development of ETL processes to transform data from daily/weekly flat files to the ODS and eventually into to a dimensional modeled data warehouse.
• Extensively used SQL, PL/SQL, analytical functions to write packages, procedures, materialized views using Oracle 10g.
• Sqlldr used to stage data. Shell scripting used as wrappers for the ETL modules.
• Extensively used DataStage to create sequences for the ETL modules.

Environment: Oracle 10g, SQL, PL/SQL, IBM DataStage 7.5.2, UNIX Shell Scripting, Tortoise SVN

Confidential, Stamford, CT

Sr. Oracle Developer

Responsibilities:

• Data Architecture Design and development of a Central Data Repository of Static Reference Content for Syndicated Loans business. Liaison with the Syndicated Loans team as well as down stream clients in the bank to define scope and requirements.
• Design and development of ETL interfaces to a central data warehouse housing fixed income reference data including static, pricing and rating information.Worked as part of a global team. Analysis, design, coding and mentoring developers, advising/setting standards and best practices, interfacing with business users globally as well as within the US.
• Extensively involved in diagnosing performance bottlenecks in code and advising the team on best practices with regards to SQL tuning, code optimization and alternative strategies for moving away from the legacy system (SYBASE) onto ORACLE solely.
• Extensively used PL/SQL packages, procedures, functions, pipelined functions, materialized views, collections etc. Used JavaCC to create a parser for the ratings feeds. JDBC was also used to create reports for downstream clients.
• Designed and developed a chat bot using Confidential MDK. Enables the user to derive real time status and schedule information about Autosys scheduled jobs.

Environment: ERWin, Oracle 9i, 10g, Sybase, SQL, PL/SQL, Oracle AQ, SQLJ, Toad, Unix Shell Scripting, Awk, Sed, lex, yacc, Java, JavaCC, Autosys, Clear Case, MS Project

Confidential, Trumbull CT

Technical Lead

Responsibilities:

• Responsible for architecture, design, development & project management of the Provider Sub-System .
• Tech Leading & managing a team of 3-4 programmers. Usually multitasking on simultaneous projects.
• Lead numerous projects involving the migration of ancillary applications to Oracle, in particular the provider credentialing system, from early requirements analysis, logical modeling to physical modeling, building new front-ends, reports and processes, making modifications to the current system and enhancing the current functionality of the Provider System, as well as keeping the enterprise logical and physical models in sync with new developments.
• Involved in the architecture and design of an Operational Data Store being fed from the OLTP database. Lead the project to data model the logical and physical design for the providers system.
• Architected, designed and developed a Centralized Code Set Repository for enterprise-wide use.
• Involved in re-platforming and enhancing the Code Set Repository from iPlanet to WebSphere.
• Responsibilities include database design and modeling, code design and reviews, adherence to System Development Life Cycle (SDLC) standards and writing technical specifications.
• Extensively involved in creating PL/SQL stored procedures and functions, database triggers and development of batch processes using Pro*C, development of UNIX Shell scripts and lex parsers. Have extensively used SQL Tuning methods for the rule based optimizer.

Environment: Oracle Designer6i, Oracle 7.x, 8i, SQL, PL/SQL, Pro*C, Oracle Forms/Reports, UNIX Shell Scripting, Awk, Sed, lex, yacc, Java, JavaScript, HTML, JSP, XML, WebSphere Studio 5.1.1, JBuilder, PCVS, Lotus Notes, Visio, MS Project

Confidential

Systems Engineer

Responsibilities:

• Responsibilities entailed logical and physical data modeling, design and coding of Oracle forms, reports & PL/SQL modules using DESIGNER/2000
• Involved in DBA and ORACLE support activities on ORACLE 6.x, 7.x for Confidential clients.
• DBA activities involving general administration, performance tuning, database backup and recovery procedures.

Environment: Oracle Designer2000, Oracle 5, 6, 7.x SQL, PL/SQL, Oracle Forms/Reports, Pro*C, UNIX Shell Scripting