We provide IT Staff Augmentation Services!

Sr. Data Architect/ba Resume

New York, NY


  • Data Warehouse Architecture, BI evaluation, planning, development, MDM standards & maintenance
  • Project Management/Lead, Data & Business Analysis, Requirements gathering, QA, Database design
  • SQL Queries, ETL, QA tests, Load and Reports development for Data Mining, Reporting and Analysis
  • Work effectively on multiple task and with proper understanding of business user goals and priorities
  • Master degree in Computer Science, e - MBA in Finance and Accounting, BA in Physics/Electronics Analytical & presentation software & experience:
  • Erwin, Embarcadero, Oracle, MS SQL, DB2, Access, MS Project, Power Point, Visio
  • SQL, SQL Loader, PL/SQL, T-SQL, SPSS (data profiling, statistics), UNIX/shell, MatLab
  • Excel, Cognos Express (BI), Spot Fire (BI), Toad, Informatica, Crystal Reports, MSRS


SOFTWARE: Oracle 11g/10g/9i, Informatica, Erwin, Embarcadero, MS SQL Server, PL/SQL, SSIS, UNIX Shell, VB, HTML, JSP, PERL, C, XML, Load Runner, Java, SUN Packaging, My SQL, MS Office, VISIO, Crystal Reports, Windows batch scripts, PVCS, SVN



Consulting for Confidential, New York, NY, Data Warehousing

Sr. Data Architect/BA (MS SQL, DB2/UDB, Oracle; UNIX, WINDOWS)

  • Compensation Data Mart, conceptual, logical and physical: Dimensional &3NF
  • Data profiling and BRDs match with BO reports, inbound and outbound feeds
  • Muster Data Standards, QA/ETL design Data Governance in Distribution IT

Consulting for Confidential, NY, for CFO & PC IT group; Oracle 11g and 10g

Data Architect / Data & Business Analysis Erwin, Informatica, SQL

  • Data Flow & Architecture, BRD/FS, Requirements negotiation, Standards and Data Modeling for DW Refactoring and QA projects (Erwin / Informatica)
  • 4-layers Refactoring Data model for Loans, TRS, Equities, swaps (trading, FOBO reconciliation and portfolio control at CFO Product Control)
  • MDM/QA, ETL design for P&L, GL, TB, NAV, Reference, Futures report
  • Dimensional Models, 3NF; Business Analysis for FOBO, ODS; OLTP Trade
  • ad-hock projects and BA tasks; OBIEE tests and middle-layer models
  • Front-to-Back Office data flow integrity control for intraday adjustments;
  • Some work on Data models for Systems Reconciliation and Managed Interface
  • Coordination and knowledge transfer to offshore team in Agile environment

Confidential, Sr. Data Analyst/BA, SME for Legal and Compliance Data Team

  • Information Architecture, BA, Data Modeling &Profiling,DB2/Sybase (Erwin)
  • Data Architecture and Data Modeling Standards: development & maintenance
  • Tech Lead for PWM (Wealth Management) platforms integration project
  • Project planning, Requirements negotiation & review, Functional Specification
  • Data Flow design, transformation and mapping for Informatica ETL developers
  • Integration of Institutional and Retail systems at OLTP (transactions) information level: fast rollup, merger of dimensions, domains, metrics, types
  • Product support for complex issues; Technology base: Oracle 11g, 10g, IBM

Consulting for Confidential NY; Business Intelligence Analyst & Data Modeling/DBA

  • Represent DBA group at “Spotfire” BI implementation project on Oracle 11g
  • Wide spectrum of BI implementation activities (all in RUP/Agile), such as:
  • Reference data (MDM) and Repository databases
  • Adjusted Database / BI policies and standards
  • Developed specific QA tests and took part in rollout planning

Confidential, Consulting assignment at Barclays Capital (Compliance, QA/Data Analyst)

  • Developed the QA Test plan
  • Designed QA test cases and performed testing for different models (Informatica/Actimize/DB2)

Confidential, NY; DW Development, DW/BI Sr. Data Analyst

  • Muster Data Management/design; Data Architecture, Sources and Modeling
  • BA, Data Warehouse planning & prototype development (tables, procedures)
  • QA policies, MDM standards, Data Flow development (SQL, PLSQL, T-SQL, ETL ) for reporting, statistical analysis and other Data Warehouse needs
  • BI tools evaluation and selection per business needs, changing strategy and budget limitations (Cognos, Microstrategy, Oracle 11g and 10g, Teradata)
  • Development, Analysis & data mining in Oracle 11g and MS SQL databases
  • Financial reporting with SQL tools, ETL /PLSQL processes, AS, MSRS, Crystal, third-party tools; system performance, structure & Data Flow analysis
  • Database planning for growth and performance; physical and logical design
  • Cross-functional Business Requirements gathering and Analysis; RUP/Agile
  • Batch scripting, job scheduling, SQL Loader, automation of file management

Confidential ., employee, Sr./Pr Consultant assignment at Goldman Sachs, NY;

GS Investment Banking Division : IBD Reporting and Data Warehousing

  • Data Warehouse (IBD DW) Migration Project Management (multiple servers)
  • Technical Lead, Data Modeling, implementation plan and back-step strategy
  • Stored procedure development, adjustment and validation per database changes
  • Planning IBD DW changes in code & database objects for multiple world-wide teams of developers, business users, DBAs, Data Owners and Reporting teams
  • Reports Data & Process analysis; SQL, PLSQL, T-SQL development & tuning
  • Database objects Development, Data Analysis & Architecture: Crystal Reports, MS SQL, Oracle 10g/9, Cubes (AS), SQL/PLSQL, DTS, SSIS, Erwin, etc.
  • Master Data Management/Architecture, Data Flow design; ETL performance
  • QA planning and process development; Reports development (MSRS);
  • Business requirements gathering for applications

 Confidential, NY; acquired the Confidential , Old Greenwich, CT (employee)

Responsibilities at Confidential : DBA, Data Warehousing, processing, Data Analysis

  • Data Warehouse design, SQL / PLSQL & performance tuning in Oracle 11g/10
  • Modeling, QA process development; specifications, Data & Business Analysis
  • Requirements gathering & analysis; Dimensional Models; DW/Power Center
  • ETL/SQL-PLSQL/ SQL Loading, processing and integration;
  • Process Development for new data mining models and financial / stat analysis

Confidential: DBA, Data Warehouse development, Business Analyst

Software: Erwin, Unix shell, Oracle 9i/10g, PL/SQL Developer, MS Office, Visio, VB

Financial Information services for Banking and Insurance. My responsibilities include:

  • BA, Data Warehouse & applications design (logical, physical, business model)
  • Data and Business Model Analysis, development and conversion: year-model, sales/employee model, wallet, risk; PLSQL procedure, packages; Shell scripts
  • BA, Quality Assurance (QA) System design for the entire PLC;
  • Stored procedures development (PLSQL), SQL Loader and shell scripting
  • Estimation of the workload, timelines, preparation of Model diagrams, reports
  • DBA responsibilities: database creation, copying, backup, tuning, recovery, etc
  • Architecture design for Data Marts / Warehouse development.
  • Financial analysis: Costing, P&L trends to identify new financial service need
  • Conversion of My SQL, VB and FoxPro processes into Oracle environment

Hire Now