Data Architect Resume Profile

Summary of experience:

Senior data architect focused on building interactive slice-and-dice reporting stacks on top of VLDBs Very Large DataBases , as well as delivering fast MOLAP dashboard in Cognos.
Lead business intelligence solutions architect / developer, designing master business rule blueprints then converting these blueprints int functional analytical systems, including with VLDB back ends.
Experienced finance systems specialist. Delivered multi-tiered reporting and data mining solutions servicing portfoli accounting, profitability, operational risk, VAR, and momentum analytics
Lead data modeler. Designed large logical ERDs for both analytical Data Warehouse / Data Mart and transaction data models. In addition, migrate logical ERDs int Physical models and deliver associated data dictionaries.
Lead developer: wrote data bus servicing APIs that seamlessly pulls data from a set of heterogeneous sources, apply statistical, operational, semantic, and other operations t the flow, then broadcast results int several recipient data stores.
Metadata specialist, responsible for the design, implementation, and support of a large MDM Master Data Management repository that als collects via ETL tools such as Informatica profiling data for core entities.
Senior integration architect, delivering large scale automated transformations workflows of data residing in repositories servicing transaction grade systems int analytical databases, an exercise that includes massive amount of type inheritance modeling and casting.
Experienced project manager, regularly transforming exchanges with business personnel int detailed business flows, business mappings, and project plans for teams of resources in the US and India,
Senior Big data specialist, with several deliveries in Hadoop, Mongo, and other platforms.

Experience:

OLAP : Splunk, MicroStrategy, Cognos.
Database : MS-SQL Server, Sybase, DB2, Oracle.
Coding : PHP, Java, Python.
Big Data : NoSQL, Hadoop, Mongo, MapReduce,
Data Warehousing : Ab Initio, DataStage, Informatica
Data Modeling : ER/Win, ER/Studio

Wor k Experience:

Confidential

Senior Analytics Data Architect

Develop advanced analytical dashboards that address the following areas: finance audit, portfoli accounting, risk metrics, VAR reporting, portfoli performance, hedging performance, and system resource consumption
In addition t live interactive dashboards, I delivered several canned report sets t structure statistics and graphs of accounts, hedge pools, and portfoli based on user-defined rules obtained through my business analysis efforts. These canned reports continue t underg extensive on-going customization. Core analysis focused on:
Mark- to-market derivatives analysis.
Materializing linkage between specific assets / liabilities and hedging instruments
Abstracting hedging relationships int executive documentation.
Compliance reporting
Income statement volatility management via hypothesis formulation and testing
Continue t deliver several dashboard out of own advanced Option reporting framework that was primarily developed for compliance reporting. In this platform, the NPV of an option is split int tw components, allowing limited reporting of Time value only in the Income statement.
Deliver end-to-end analytical solutions including:
Reverse-engineer transaction systems int physical models
Draw logical models out of these physical models
Develop star-schema based EDW enterprise data warehouse ERD entity relationship diagram from the said logical models
Snowflake the said EDW ERDs
Superimpose partition schemes on the EDW ERD, delivering subject-specific data mart ERDs
Forward engineer EDW and data mart ERDs int physical databases
Design and implement many OLAP physical and soft cubes, with the former utilizing a third layer of extraction int a dense, fast proprietary data set
Architect responsible for delivering an SOA Service oriented architecture -grade data consumption model that offers on-demand consistent schema views.
Act as a lead business analyst, collecting often vague requirements from business partners, transforming them int structured system flows, and then transform all int a detailed project plan with resources, timelines, and phased deliveries
Develop large, multi-phase, multi-mapping ETL graphs that automate data transformation from production transaction sources int T 1 analytical data warehousing schemas. Tools used are Informatica, Ab Initio, and DataStage
Responsible for enterprise MDM Master Data Management repository, which contains several schemas covering reference data, operational metadata, functional metadata, financial instrument reference, and index reference.
Publish several types of data dictionary grade reference data and metadata including:
Type encapsulation, inheritance, sub-typing, and cross-typing
Homonyms, synonyms, and antonyms.
Pass-through entities and attributes a.k.a. cross-link attributes / entities .
Business-label defining attribute set e.g. attributes defining a Household .

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship