EXECUTIVE SUMMARY

• Senior finance systems architect wif emphasis on real - time analytics and decision management systems, delivering a whole spectrum of services including process modeling, data modeling, MDM, EAI, ETL, web services, OLAP, data mining, and live dashboard systems. As a business intelligence leader wif an extensive experience in the financial industry, me deliver algorithmic frameworks dat enable predictive and decision-support platforms using hub+spoke and bus data warehousing architecture dat is maintained via a verity of ETL / web services EAI integration methodologies.
• Expert data architect wif long experience developing metadata master repository, enterprise security master, brokerage reference data models, rule base repository, and data governance architecture. These frameworks feed into several data quality solutions me developed using proprietary apps (such as probabilistic correction) and 3rd party verification solutions
• Senior process modeler and workflow architect wif extensive experience producing hierarchical reciprocal entity dependency representation based n the seniority and emphasis of objects participating in the said process model. Upon completing such frameworks, me forward engineer these diagrams into computing workflow models servicing such areas as compliance, Risk, AML, market volatility, predictive marketing,, relationship re-structuring impact, employee competitiveness, business delivery construct effectiveness discovery, service pricing tuning, and delivery vehicle coupling.
• Experienced middleware architect wif many in-production systems developed using 3rd party software (e.g. IBM systems engineer) wif notable achievements in developing multi-threaded and shared nothing enterprise platforms. As well, deeply versed in EDI (enterprise data integration) using offline ETL as well as real-time middleware solutions.

TECHNICAL SKILLS

ETL: Informatica, Ab Initio, MS-SSIS,, Ascential, Datastage

EAI (Middleware): Websphere Message Broker, TIBCO Rendezvous

Reporting: QlikView, Tableau, Splunk, Business Objects, Microstrategy

Programming languages: C, C++, VISUAL BASIC, PL/SQL, Perl

Statistical & Quantitative software: SAS, SPSS, STATISTICA

Database: ORACLE, SYBASE, DB2, MS-SQL Server

OO CASE: Rational Rose, Eclipse UML2, Enterprise Architect

Data modeling: ER/Win, ER-Studio, Modelmart

Data Quality: Trillium, First Logic

PROFESSIONAL EXPERIENCE

Confidential

Enterprise Data Integration Architect

Responsibilities:

• Design and manage the enterprise security master data model. Initially hosting ERDs (Entity Relationship Diagrams) for simple financial products (such as Stocks, Munis, and other bonds), me gradually expanded this ERD to encompass vanilla products (e.g. options) and more complex products such as CDS (Credit Default Swap) and CMO(Collateralized Mortgage Obligation). In addition, me have since expanded the model to support homonymous entities from 3rd party vendors such as Bloomberg, Reuters, and IDC.
• Manage an expansive ETL / EAI set of platforms dat replaced error-prone java processes Applications used to enable my ETL processes include Informatica SOA-based services (wif Metadata management), while my EAI tools include Websphere and TIBCO.
• Manage an ICC (Integration Competency Center) framework to sustain tight process engineering control while interfacing to non-structured hard-coded scripts into ETL / EAI applications.
• Manage real-time SOA-based (Service-Oriented Architecture) message services using Websphere message broker and TIBCO Rendezvous and Informatica Power Exchange, shutting down non-confirming scripts dat quite often disabled entire trading flows due to simple network packet loses.
• Manage a multi-tier implementation of a rules-based engine to aggregate inbound correlating entities into a single Gold Copy master database for securities.
• Utilize a wide array of Ab Initio modules to streamline rule-engine workflow by automatically receiving new security requests from trading and risk applications and posting the required security terms and conditions back to each downstream application using a synchronous, real-time posting architecture.
• Implemented my Ab Initio architecture using GDE Designer.
• Developed various Ab Initio Transform, Partition, De-partition, Dataset and Database components.
• Developed various Ab Initio graphs to process sales data in multiple currencies for loading into data warehouse.
• As part of the ODS (operational Data Store) implementation, designed a reference data store, including clients, instruments, and business functions, and built its necessary Informatica workflows.
• It also includes several presentation servers (data marts for real-time reporting, in MS-SQL) and a OLTP (online transaction processing, Sybase currently) databases, for which me wrote Informatica ETL.
• Manage a large-scale ETL planet for the entire corporate compliance team using a combination of middleware (Websphere / Tibco) and ETL (Informatica / IBM Datastage):
• Design parallel job streams using various operands like join, merge, Lookup, CDC, remove duplicates, filter, modify, aggregator, peek and funnel stages.
• Work on different types of file conversions along wif COBOL files extracted from different sources and use of CFF stage for job processing.
• Develop sequencer jobs to run the extract and load jobs on schedule basis.
• Manage data quality modules, Quality Stages, such as Match, Investigate, and Survive.
• Used Transformer stages wif stage variables to map data create expressions and constraints to match the business transformations.

Confidential

Enterprise Data Architect

Responsibilities:

• Designed a comprehensive hub-spokes based enterprise data warehouse ERD to collect data from many heterogeneous data sources.
• Designed a bus-based ODS (Operational Data Store) ERD for prime services real-time data collection, data massaging, and ETL-based reproduction.
• Utilized a variety of middleware and ETL tools to cross-publish prime services reference and trading data, including MDM, time series derivation, virtual OLAP cubes, and PL reports.
• Developed several physical and simulated OLAP cubes to service end of day finance, wat-if portfolio assessment, vanilla / exotic product risk ends, compliance, and risk.
• Developed logical and physical to host MDM (Master Data Management) framework including data governance rules ERD, data dictionary, cross-entity translation, inheritance hierarchy, ETL flow stats, element cardinality ...etc.
• Designed UML workflows (state-transition, CASE, Sequence diagram, ..) to guide business requirements-to-live systems implementation. Subsequently publishing PRD (Process Relationship Diagrams).
• Developed a simulated OLAP metadata cubes to enable our IT organization to access important data metrics, including slice and dice capabilities.
• Implemented a QA platform (Test Director) specifically for the data warehouse environment.
• Redesigned the Security Master (financial instrument reference data model) database based on FTI and other foundation models.
• Developed OLAP cubes as well as presentation apps for such analytical areas as execution performance, P&L, portfolio risk, operational risk, and marketing projections.
• Developed separate ETL / EAI frameworks to integrate data marts servicing compliance, risk, finance, marketing, margin activity, order flow and operations.
• Managed the relationship wif representatives of business units, financial controllers, compliance lead, and other executive management personnel.
• Created a culture of motivation in my team by assigning rotating leadership roles in my projects wifin my team members.
• Wrote several quantitative algorithms to analyze the performance of our financial analysts against market conditions.