SUMMARY:

Professional with 15+ years of financial industry experience in design, development and implementation of complex IT projects across Risk and Finance domains. Well - honed communication, analytical and data analysis skills allied with experience of building data analytics and business Intelligence solutions using Big Data Stack, Qlikview and Tableau. Formal education in Computer Science and completed advanced degree in Financial Risk Management (FRM) to learn about design, development and execution of Risk management strategies and systems.

EXPERTISE INCLUDES:

• Functional and Technical Architecture
• Strong PL/SQL and Performance Tuning skills
• Front to back system analysis, design and development
• Data Warehousing and ETL Technologies including Oracle, MS SQL Server, Informatica, Python and Perl
• Data Analytics and BI Reporting using Tableau on Hadoop environment
• Advanced data analysis, modeling and reconciliation skills
• Project and Team Management
• Agile Development Methodologies (SCRUM)

TECHNICAL SKILLS:

Data Mart/Reporting: Oracle 9 /8 /10/11g, MS SQL Server 2008/2012, Tableau 10, Qlikview 11, Informatica 5/6/7/9, PL/SQL, MS Office Suite

Languages/Scripting: Python, Perl, R, VBA, Unix Shell Scripting, Autosys JIL

Collaboration Tools: Subversion, GitHub, Source Tree, JIRA, Confluence, Maven

PROFESSIONAL EXPERIENCE:

Vice President

Confidential, New York, NY

Responsibilities:

• Part of Chief Investment Office ( Confidential ) and Treasury technology division that performs asset-liability management for Confidential ’s LOB’s and legal entities.
• Business group helps manage firm’s liquidity risk, interest rate risk and Confidential risk.
• Scrum Master for agile team focused on building Analytics engine and reporting framework for understanding and explaining period over period variances for Confidential ’s Gross Interest Income (GII).

Environment: Spark 1.6, Scala, Hive, Cloudera Impala, Tableau 10

Confidential

Responsibilities:

• Interest Income projections performed by this engine are used to gauge impact of changes in market environment on firm’s income statement and balance sheet. Accurate projections help make informed decisions on managing firm’s interest rate risk and liquidity.
• Financial reporting solution for Long Term and Short Term debt products issued by Treasury division to ensure appropriate funding as a function of Confidential ’s liability management.

Environment: MS SQL Server 2008/12, Python 2.7, Qlikview 11, Autosys 4.5

Director - Finance and Risk IT

Confidential, Stamford, CT

Responsibilities:

• Part of Group Finance and Risk IT division responsible for design and development of various financial reporting solutions geared towards delivering Risk, Balance Sheet, Profit and Loss (PnL) and Regulatory reporting requirements.
• My role required heavy user interaction to translate business and user requirement into technical specifications along with performing hands on development and production support as required.

Confidential

Director

Responsibilities:

• Created physical and logical database design to feed new PnL datamart from Global General Ledger
• Designed Cognos BI DMR based reports to satisfy reporting requirements for Fixed Income and Equities user group
• Designed and implemented data strategy to source reference data and currency rates for PnL reporting
• Line management for IBM offshore resources and development lead for Legacy PnL reporting applications

Environment: Oracle 10/11g, Cognos BI 8, Perl 5.8, Informatica 9.1, Windows Server 2008, Linux, Autosys 4.5

Confidential

Director

Responsibilities:

• Implemented a consistent and standard third party tool ( Confidential ) to comply with Balance sheet substantiation and sign-off across the Confidential, Wealth Management and Global Asset Management divisions.
• My role was of a development manager often performing hands on development.
• Implementation addressed key operational risk for Confidential .

Environment: Oracle 11g, Windows Server 2008, Linux, Autosys 4.5, Perl 5.8

Global Development Manager, Associate Director

Confidential

Responsibilities:

• Led Global team of 10+ permanent and offshore Oracle/ETL developers based in London, India and Singapore.

Lead Developer

Confidential

Responsibilities:

• Designed and developed financial data warehouse ( Confidential ) for Finance IT.
• On-time delivery of regulatory reports was critical, so the system was designed to scale with unpredictable volume fluctuation and be resilient to a variety of local or regional hardware outages that guaranteed business continuity.

Environment: Informatica 6.2.2, Oracle 9.2.0.6, Linux, JSP, Autosys 4.5, Perl 5.8

Confidential

Non-Officer

Responsibilities:

• Technical lead on two projects initiated in order to comply with Confidential data control, reporting and auditing requirements.
• Project Mousetrap was a reconciliation engine and Project Life-To-Date V alidation was aimed to perform data validations upstream before data is fed to downstream reporting systems.

Environment: Informatica 6.2.2, Oracle 9.2.0.6, Linux, JSP, Autosys 4.5, Perl 5.8

Confidential

Non-Officer

Responsibilities:

• Developer for regulatory reporting application called H3. H3 incorporated Basel I and Basel II accounting principles, settlement reporting, collateral/facility allocation and local currency calculations.

Environment: Informatica 6.2.2, Oracle 9.2.0.4, Perl 5.8, Linux, Solaris, Autosys 4.5