We provide IT Staff Augmentation Services!

Sr. Data Architect/ba Resume

New York, NY

SUMMARY:

  • 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
 

TECHNICAL SKILLS

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

OPERATING SYSTEMS: UNIX (HP, Solaris), Windows

EXPERIENCE:

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