SUMMARY

• Extensive global experience of over FIFTEEN years of Database Modelling, Architecture, Development, Performance Tuning, BI Reporting and Operations experience. With specific expertise in:
• Besides the above, have a considerable experience in designing and deploying Customer and Product Master Data Management solutions that reduces costs significantly by increase operating efficiency and provides 360 degree view of the Customer/Product/ Reference Data in Investment Banking/ Capital Markets and Insurance domains.
• Take pride in strong research and analytical skills. Gather and absorb information about unfamiliar subjects from a variety of areas, assimilate knowledge, integrate the key connecting concepts and people and produce value in very little time; always excited to start off understanding information strings from anywhere in the cycle, which gets noted first, trace them back to their source/roots and then match it up with the results completing the cycle, so as to identify the break points and areas to fix; share the lessons learnt to whoever would need it/be interested to learn. Document the connecting dots using knowledge revealed by parallels drawn from various subject areas and reflective patterns; document as a Story Teller, (and where required) variety of documentation from a variety of perspectives. A synthesizer between the Quants/Developers/Testers and the Management, and play as a Tester myself at times.
• Strong understanding and working experience of Eagle Pace Data Model around Transactions like Trades/Cash, Positions, Performance and Reference data.
• Strong understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
• A long - running record of providing exponential increases in throughput, accuracy and profitability.
• Been an Inspiring leader with an innate understanding of team dynamics and intrapersonal relationships, I build winning teams and that take pride in their accomplishments.
• An outstanding ability to define business functions as generalized metadata, enabling systems to provide long-term stability and reliability.
• A vast capacity for absorbing and synthesizing a wealth of detail into a unified, coherent vision and communicating that vision to a diverse audience.
• Build Data Architecture Design Strategy and guidelines including Data Convergence, Data Sourcing, Centralizations of Enrichments / Calculations and reduction of Persistent Data Stores.
• Strategy driven work practice.
• Continuous review of Business critical Database to proactively identify space issues, performance issues.
• Strong experience in Enterprise Data Modelling and implementing concepts such as Dimensional Modelling, BI Temporal Versioning, Hierarchy Implementations.
• Strong design experience in Dimensional and Normalized Data Modelling.
• Strong Microsoft Skills required for Data Analysis and BI Report Mockups like VBA Formula Functions and Pivot Table Features.
• Strong Experience in implementing Datawarehouse using Kimball and Inmon methodologies.
• Extensive Scripting experience for ingestion of External Data Feeds such as Market Data Elements.
• Sound understanding of Service Based Architecture.
• Strong hands on experience in BI Tools like Business Objects and Micro Strategy.
• Sound Exposure to Charles River Trading Compliance Engine.
• Strong understanding of Market Data in Financial Industry.
• Hands-on working experience in Leading Market product such as Charles River and Eagle Pace.
• Implementation experience in Fixed Income Asset Class especially in Treasury Bonds and Derivatives Interest Rate Swaps and Credit Default Swaps module for investment banking client.
• Fundamental understanding of various financial risks including Market Risk, Credit Risk, Liquidity Risk and Operational Risk.
• Sound understanding of Compliance area in Investment Banking domain through project experience.
• Expert level experience in developing generic API programs for Database Maintenance Operations such as Partitioning, Index Re-build, Analyze /Gather stats on Objects.
• Sound knowledge and experience of XSD Design for XML Parsing and Transformation
• Developing Performance Optimization dashboards baselining existing performance metrices and reporting future Performance trends.

TECHNICAL SKILLS

Database Development: Oracle PL/SQL, Sybase T-SQL.

Business Intelligence Tools: Oracle OBIEE, Business Objects, Crystal Reports.

Data Integration and ETL Tools: Informatica Powercenter, IBM DataStage.

Data Modelling: ERWIN, Oracle SQL Developer Data Modeler.

Scripting: UNIX Shell (Corn, Bash, C), Perl.

Agile Method Tools: JIRA.

Scheduling Tools: Control M, Autosys.

Version Control: Subversion, Perforce, GiT.

Business Modeling Tools: MS Visio, Rational Requisite Pro Microsoft Office tools: Access, Excel, PowerPoint, Word, Access, MS Project, MS SharePoint, MS Excel: Pivot Tables.

Project Methodologies: Software Development Life Cycle (SDLC), Agile (Scrum), Waterfall.

Bug Tracking/Testing Tools: HP Quality Center.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City

Senior Data Architect and Modeler (ETL and Performance Optimization Lead)

Responsibilities:

• Responsible for Design of ETL Metadata Data Model.
• Using Database Workload Repository and do analysis accordingly.
• Provide and implement performance tuning recommendations of all components in Exadata database machine.
• Evaluate ETL tools based on Scalability, Maintainability, Performance and Time-to-Market criterion.
• Environment stability control like designing Optimizer Query Plan flip monitoring for pointing out any adversely impacting plan flips and recommend SPM based baseline to lock down the optimum plan to reduce troubleshooting time in Production environment.
• Advice, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.
• Devise strategy and baseline performance matrices for Exadata Migration including process runtimes and database performance statistics.
• Detail review of Database Configuration and recommendation for changes for Optimal Performance.
• Leading Performance Tuning efforts at various levels including Batch, ETL and Database.
• Design and Implement Oracle best practices like Gathering Database Statistics, setting up Resource Manager plans for Shared concurrent applications.
• Design, Develop and implement housekeeping routines to purge older data.
• Device strategy to do Regression and Performance testing for Optimization related changes and publish success criteria based on improved run times, Resource usages and consistent Query Plans.
• Working on Long term Design changes to processes and Database infrastructure to improve Performance. For instance Partitioning high volume data tables, remove scheduling dependency between functionally independent processes such as processing Valid Trades and Cancelled trades.
• Extensive Database Performance tuning on ExaData to analyze bottlenecks and take remedial actions. Put necessary Proactive Controls in place for monitoring Performance.
• Put up Technical Design and Architecture Document and reviewed it with Architecture Review Committee.
• Analyzing change request whether Defect or Change Request, Prioritize, Allocate and Track status to completion using Microsoft Project.
• Troubleshoot critical Production incidents analysing Stats Pack/AWR reports proactively for Oracle Wait Events, Time Consuming SQL Queries, tablespace growth and Database Growth.

Confidential, Boston, NYC

Senior Oracle/OBIEE Data warehousing Data Modeler and ETL Architect and Developer (Technical Lead)

Responsibilities:

• Responsible for Development, Management and Enhancements of Conceptual, Logical and Physical Data Model.
• Functional and Technical Design of new IHC Third Party Exposure Control check Variance reports for IHC Consolidated and US Operations reporting for summarized data.
• Leading Functional, Technical design and implementation Project for Liquidity 5G IHC reporting.
• Developed Defect Template for CFO Change Management to report issues effectively during UAT for IHC Implementation.
• Worked on building detail Functional and Technical Design Document for various aspects of FED 5G reporting including Core enrichments for Reference Data, Legal Entity Hierarchy, IHC Consolidation, Submission Process including Top Side Adjustments and rule Engine for Generic Aggregation.
• Worked closely with Business to build FRD document using BRD provided by them.
• Create Functional and Technical Data mapping Documents to describe Attribute Mappings.
• Built a Database Rule Engine to do Post Load Processing of above mentioned rules.
• Designed and Developed end-to-end ETL mappings for Development team to follow as standard.
• Review of Database and ETL code by Development team and give recommendations for Performance and Scalability point of view.

Environment: Oracle 11gR2 with RAC ExaData X2-2, OBIEE, Subversion, Control M, Informatica Powercenter 9.x, SQL Developer Data Modeler.

Confidential

Senior Oracle Enterprise Data warehousing Data Modeler and BI Architect (Project Lead)

Responsibilities:

• Requirement Specification document for Big Data Integration.
• High Level Data Integration design using Spark Transformations and PIG Scripts to write onto Vertica Cluster using HDFS. Hadoop Installation was Cloudera.
• Involved in Performance Tuning of existing Legacy Reports.
• Involved in Design and Development of Custom Business Intelligence solution (Dashboards and Adhoc Reports )using OBIEE
• Provided tuning Recommendations to Primary DBA Team.
• Act as a Story Lead by understanding and reviewing requirements, for designing new Data Domain ingestion process and track development of various integration components including Services, Agents, Switch, ETL and Database.
• Supervise Development of each Data Domain Ingestion Routines and REST based Services.
• Extensive Data Analysis and Data Profiling on Source Data to enable in Data Modelling and ETL Design Efforts.
• Designed Data Quality Rules for Data Domains.
• Designed and Implement Release Management Process for Database code using GiT Source Control.
• Designing Data Model for Hierarchical Reference Data Taxonomies.
• Maintain Downstream and Upstream Data Mappings and give directions to ETL and Service team for usage of it.
• XSD Design for building ETL XML Parsers for ingesting Source Data.
• Creating Data Mapping Validation views in the Database based on Oracle XML API to validate incoming XML messages.
• Designed Data Flow Diagram as part of Process Modelling to depict how Processes interact with Information Stores and External Agents.
• Driving the effort to migrate and test ETL Oracle 11g to Oracle 11g ExaData for legacy as well as strategic Data warehouse.
• Query tuning to make them Smart Scan Enabled for ExaData.
• Create and Manage Conceptual, Logical and Relational Model (3NF and Star Schema) and their Sub Views or Subject Areas along with Domains.
• Use Case Scenario Document for Read and Write Service APIs for data in CIM.
• Define and Maintain list of naming standards for Physical Data Model.
• Create and Maintain Data Dictionary for Logical and Relational Data Models.
• Data Modelling for BiTemporal Versioning and Dimensional Modelling.
• Implement Database Deployment infrastructure including Release Shell Scripts, Batch scripts, Build All and Upgrade SQL Scripts along with maintainable SVN folder structure to store Database Objects, DML scripts and Release scripts mentioned above.
• Identify and create new domains as necessary across each subject area.
• Data Model Design enhancements for Data Consistency for Revisions of Incoming Source Data.
• Designed Application level Entitlements Data Model.
• Cross Message Transaction Data Model for data sourced from XML Message in Source Data.
• Develop Generic PL/SQL interface to serve the data to downstream Analytics system.
• Designed PL/SQL API for Dynamic Query Interface.

Environment: Oracle 11gR2 with RAC and ExaData, Business Objects XI Web Intelligence, Subversion, Control M, Spring JDBC, JQuery, Hibernate OAM Framework, Informatica Powercenter 9.x, SQL Developer Data Modeler, GiT, OBIEE 11g

Confidential, Jersey City, NJ & Manhattan, NY & Brooklyn, NY

Senior Oracle Data warehousing Oracle and OBIEE Architect

Responsibilities:

• Developed Metadata Repository (.rpd) that consists of Physical, BMM and Presentation Layer and repository level calculations using Oracle BI Administration Tool.
• Improved analytics response time using Optimization Techniques such as Aggregate Tables.
• Validate Query performances in Production environment to make sure it has ExaData Smart Scan Access Paths.
• Work on Data Model for Application Auditing and Exception Handling Framework and developing PL/SQL interfaces.
• Data Modelling for BiTemporal Versioning and Dimensional Modelling for Reporting Dashboard.
• Performance tuning of reporting Database views as necessary.
• Estimate, Design and Develop Offline Data Migration Strategy from Legacy SQL Server Database to Oracle and develop a customized ETL framework to enable that including tools like BCP,SQL Loader and Oracle PL/SQL .Devloped Functional Requirement Document for the same.
• Involved in Master Data Management effort to understand inconsistencies, redundancies and gaps in existing Reference data.
• Implement Database Deployment infrastructure including Release Shell Scripts, Batch scripts, Build All and Upgrade SQL Scripts along with maintainable SVN folder structure to store Database Objects, DML scripts and Release scripts mentioned above.
• Build generic PL/SQL interfaces for Data Cleansing, Validation and Transformations.
• Build dynamic Stored Procedure interfaces to source the data to Business Objects
• Do performance benchmarking for existing legacy processes.
• Design, Develop and maintain ETL framework with atomic jobs for loading data from multiple sources flat file data each for Staging, ODS and Fact loads using Informatica Powercenter

Environment: Oracle 11gR2 with RAC and ExaData, Business Objects XI Web Intelligence, Perforce, Control M, Spring JDBC, JQuery, Hibernate OAM Framework, SQL Server 2008 R2, Informatica Powercenter 9.x, ERWIN 7.x, OBIEE 11g

Confidential, Jersey City, NJ

Senior Oracle Data warehousing Data Architect/Developer/Data Modeler

Responsibilities:

• Efficiently developed many dashboards using different Analytic Views (Pivot Table, Chart View Selector and Column Selector) Dynamic/Interactive Dashboards with Drill Down Capabilities.
• Implemented Groups and Hierarchy Levels based security to Dashboards based on Role.
• Performance tuning of resource intensive queries by configuring for Auto Degree of Parallelism in ExaData.
• Develop Conceptual and Logical Data Model for Compliance Risk Assessment Practice area which includes Subject Areas such as Risk Assessment Units and Survey Questionnaires
• Develop generic Workflow Data Model used across all Global Compliance Practice areas.
• Designing Data Model for Hierarchical Reference Data Taxonomies such as Legal Entities, Line of Business etc.
• Design Application level Entitlements Data Model

Environment: Oracle 11gR2 with RAC and ExaData, Business Objects XI Web Intelligence, Perforce, Autosys, Microsoft .Net based RFPF framework for reporting, Informatica Powercenter 9, OBIEE 11g

Confidential, New York, NY

Senior Oracle Data warehousing ETL Developer and Data Modeler

Responsibilities:

• Developed Feature Dashboards for each of Metrics by embedding Reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Analyzed reporting requirements for dashboard reports and Adhoc reports
• Performance tuning of resource intensive queries by configuring for Auto Degree of Parallelism in ExaData
• Designing Data Model for Hierarchical Reference Data Taxonomies such as Legal Entities, Line of Business etc.
• Design Application level Entitlements Data Model
• Develop data Model which includes new FACT tables with version id and run id to support Intraday Versioning initiated by Business Workflows as mentioned above.
• Designed Security Override process for overriding Static Security Attributes using ISIN, CUSIP, and SEDOL etc.
• Designed Optimized Load Processes to load FACT tables which will cater to Base load and subsequent intraday runs.
• Developed Database Performance Diagnostic Utility to troubleshoot Performance issues and identify bottlenecks.
• Designed Autosys jobs considering upstream and downstream dependencies and concurrent processing for Optimized Batch timings.

Confidential, Jersey City, NJ

Senior Oracle Data warehousing and ETL Developer

Responsibilities:

• Worked in conjunction with System Administrators for Migration, Deployment and Performance Tuning of OBIEE infrastructure.
• Repository Refactoring by eliminating redundant repositories and merging required functionality in one single Repository.
• Design Flexible ETL framework with atomic jobs for each of Staging, ODS and Fact loads.
• Develop, Enhance, Tune and Maintain ETL processes to load external source data into Star Schema
• Historical data correction by customizing existing ETL jobs.

Environment: Oracle 11gR2 ExaData, Datastage 8.5, Business Objects 3.1, Perforce, TIDAL Enterprise Scheduler, OBIEE 11g

Confidential, Stamford, CT and Manhattan, NY

Senior Oracle Data warehousing and ETL Developer

Responsibilities:

• Develop Asynchronous Multi-Threading processing Framework to process and send data downstream received from upstream systems using PL/SQL DBMS SCHEDULER API.
• Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.
• Design and Develop Recon Process for static and transaction data from Upstream Source systems.
• Working on Designing and development of Dimensional Hierarchies.
• Design and Develop reports FX Exposure Reports for Investment Accounting.
• Provide Design Pattern documents for new development Book of Work.

Environment: Oracle 11gR2 ExaData, Informatica, MS Team Foundation Server, OBIEE 11g

Confidential, Manhattan, NY

Senior Oracle Developer and Subject Matter Expert

Responsibilities:

• Write Technical Specifications for PL Attribution Report Systems for Product Control.
• Created Repositories, Physical Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool.
• Installed and Configured OBIEE11g server on UNIX server.
• Designed Star Schema Data Models for P/L Trial Balance and Reconciliation gaps.
• Designed and Developed generic ETL framework using Perl.

Confidential, NYC, NY

Senior ETL and Oracle Datawarehousing Developer

Responsibilities:

• Configured Interactive Dashboards with Drill Cross Capabilities using Filters and Dashboard prompts.
• Designed Informatica workflows to send data downstream to Product Control Datawarehouse.
• Working on Design and Development for new CRO (Credit Risk Office) Regulatory project to add new Risk Scenarios to system.
• Developed Perl script to automate Data discrepancies between Production and QA environments.

Environment: Oracle 10g 11g, Pl/SQL, Perl and UNIX Shell Scripts, OEM 10g, ERWIN, OBIEE 11g

Confidential, Jersey City, NJ

Senior Oracle Consultant and Analyst

Responsibilities:

• Implement Data Masking routines using Informatica to hide Sensitive Business data in Test environment using Encryption methodology.
• Performance Evaluation and Benchmarking of Dashboards using OBIEE 11g in order to include it into Strategic BI Reporting infrastructure.
• Designed and developed new consolidated FICC Datamart which will have both Fixed Income and FX data for Business reporting.
• Developed new Data Masking process to mask critical client data using PL/SQL for Swiss UAT environment.
• Modifying existing Shell infrastructure to accommodate new data masking process.
• Peer code reviews.
• Coordinating application build and deployment in liaison with other teams such as UI and Service team.

Environment: Oracle 10g, Pl/SQL, Java J2EE, Solaris, Perl and UNIX Shell Scripts, Sybase Adaptive Server Enterprise 12.5.3, OEM 10g, ERWIN,OBIEE 11g

Confidential, Raleigh, NC

Senior Oracle Consultant

Responsibilities:

• Involved in extensive SQL Query Tuning and provided Tuning recommendations to ETL team for time and CPU consuming queries.
• Developed the testing Shell script to bypass environment dependent sourcing of Environmental variables.
• Worked closely with SCM to migrate Source Code base from Clearcase to Subversion and verified the correctness of the migration.
• Evaluated various client tools which can be used for Subversion based on the features provided and efficiency of their use.
• Worked on complex BAU enhancement which requires using Oracle Collections.
• Worked on extensive database performance tuning for Equity Intelligence reports developed using Business Objects executing in less than 10 seconds rather than over 2 hours and saved additional USD 5000 in cost for inviting Vendor side consultant.
• Designed and developed efficient ETL processes for end-to-end loading of the data using Oracle.

Environment: Oracle 10g, PL/SQL, UNIX Shell Scripts, Clearcase, Subversion, Informatica Powercenter.