We provide IT Staff Augmentation Services!

Senior Data Architect Resume

Framingham, MA

SUMMARY

  • Decisive and multi - faceted IT professional with eighteen years of experience delivering projects with in project constraints. Expertise in the data architecture, design, data modeling phases for very large enterprise data warehouse projects.
  • Big data-data, enterprise data warehousing architecture, data modeling, canonical data model, master data management, data migration, service oriented architecture, IT strategy, information governance, standards and process engineering, software development and deployment, project management and mentoring.
  • Proficient in translating strategic requirements into a usable enterprise information architecture, which may include an enterprise data model, associated meta model, common business vocabulary for consistence between various design layers of applications.
  • Facilitated the mapping and auditability of information assets as they flow from upstream legacy, package, or custom development and interfaces to downstream analytical applications, thus ensuring optimal transparency, quality, consistency and controlled redundancy across the enterprise.
  • Facilitated the definition of integrative and canonical views of data or information across multiple content types (structured, semi structured, XML or unstructured) to support convergence of information asset migration planning or impact analysis.
  • Participated in workshops for definition of technical standards and guidelines that pertain to data and information use, security, access and governance (including defining accountabilities in support of data quality mandates).
  • Confirmed existing data/information assets are identified, stewarded and leveraged across the enterprise.
  • Ensured data is sourced from system of record.
  • Overlooked the construction, refinement and maintenance of information models, as needed, to meet business requirements.
  • Developed a model management strategy in support of the enterprise reuse and data-sharing objectives.
  • Analyzed information to evaluate the effectiveness of controls, determined the accuracy of reports, and monitored the efficiency and security of the operations.
  • Assessed the BW current data architecture; provided options and recommendations for future state scenarios, especially in data modeling, sourcing of data, and data capture techniques.
  • Performed gap analysis of current architecture including data models, data flows and their implementations against the strategic roadmap.
  • Performed code reviews and mentoring for junior engineers regarding data modeling, ETL and OLAP designs.
  • Delivered data model designs using both Agile and Waterfall methodologies for several projects in the past.
  • Organized and floated data architecture and data modeling competency teams for several clients to sustain EDW and BIE projects

TECHNICAL SKILLS

  • Data Modeling Erwin7.x, Power Designer 16, IBM InfoSphere Data Architect and MS Visio
  • Modeling Practices Corporate Factory, Enterprise Bus Matrix and Canonical
  • Databases SQL Server, Oracle11g, DB2, Netezza and Teradata,Sybase
  • Data Integration Tools Informatica9,8,7, SSIS
  • BIE Tools Qlik View, SpotFire, Cognos and SSRS,OBIEE
  • Data Quality IBM Information Analyzer, Informatica Data Quality
  • MDM Tools Oracle DRM and SiteHub, IBM InfoSphere MDM,
  • Retail Domain Apps RPAS and RMS
  • Framework TOGAF9,, SOA
  • Scripting UNIX, Perl, HTML and XML
  • Messaging MQ
  • C++, C, COBOL and Java
  • APPWORX,AUTOSYS
  • MS-DOS, MS-Windows 3.1,95,NT/2000,XP, UNIX, LINUX
  • HP, SUN, NT, IBM, COMPAQ

PROFESSIONAL EXPERIENCE

Senior Data Architect

Confidential, Framingham, MA

Responsibilities:

  • Modeled and migrated very complex ladder planning (planning application) and unit control transactions (inventory) systems into EDW.
  • Worked on IDS canonical data models in terms of logical and physical models along with EDW data model.
  • Worked with the integration team to guide how IDS data is structured.
  • IDS model is based on ARTS, Retail Enterprise Data Model (EDM).
  • Gathered and analyzed source systems Meta data in terms of source data volumes, growth, job details, data quality issues and complexity in data structures.
  • Conducted workshops for business users for conceptual and logical data models.
  • Performed data profile activity for source systems, ODS, ADL and Mart level and generated profile reports.
  • Modeled EDW to accommodate Multi Country, Multi Banners, Multi Currency and Multi Language
  • Created Interface Diagrams right from Source Systems to Target Systems via EDW.
  • Developed 10 Marts as part of EDW Inventory, Allocation and Distribution.
  • Developed Normalized Schema for various projects into SQL environment (data migrated from existing legacy system like Falcon, APT and Retail Lease application)
  • Developed migration frame work and approach for sunset applications / source systems.
  • Worked on BIE requirements and involved in History and Archiving data from various projects with in IA.
  • Provided solution for various non-functional requirements like Historical, Incremental, Archival and Disconnected Phase of Project.
  • Developed Detail Data Architect document consisting of design decisions for Transaction, Snapshot and accumulated Fact tables
  • Developed Conceptual, Logical and Physical modeling by using Erwin7.
  • Assist to write low level Source To Target Mapping documents
  • Developed many SQL Scripts and Views on Netezza database for project needs.
  • Used Netezza analytical functions to simply complex aggregations and audit process.
  • Introduced many process improvements to create Project Assets.

Environment: Erwin7, MS Visio, Mainframe, Oracle MDM, RMS, Oracle, Oracle DRM/Site Hub, MS SQL Server, Netezza data warehouse appliance, IBM InfoSphere Information Server 8.7, TOAD, MKS, MS EXCEL and Erwin Macros

Confidential

Sr. Data Warehouse Architect

Responsibilities:

  • Primarily involved in a Architect/Technical/Business role at State Street Boston
  • Primarily involved with the Global Risk Management Enterprise Data warehouse group helping in an Architect/technical role for the Risk Management Data warehouse.
  • Involved in working with Workflow Manager, Workflow Monitor, Designer and Repository Manager, Source Analyzer and Warehouse Designer
  • Project responsibilities include
  • Overall technical strategy Data Modeling /ETL architecture and development.
  • Design & Develop projects on Oracle
  • Performance tuning of Long running queries
  • Helping on the BI Architecture for the Reports
  • Implemented Oracle GoldenGate for the Risk Databases

Confidential

Sr. Data Warehouse Architect/Developer

Responsibilities:

  • Primarily involved in a Architect/Technical role at Confidential Boston
  • Primarily involved with the Optimization Services group helping in an Architect/technical role for the Client’s Data warehouse.
  • Involved in working with Workflow Manager, Workflow Monitor, Designer and Repository Manager, Source Analyzer and Warehouse Designer
  • Designed and developed mapping using Source Qualifiers, Expressions, Routers, Sorter, Aggregator, Normalizer, Filters, Stored procedures and Update strategies.
  • Extracted Data from various sources including Cross Database data, Flat files and loaded data into the Data warehousing database using Informatica
  • Project responsibilities include
  • Overall technical strategy ETL architecture and development.
  • Design & Develop projects on Oracle/Informatica/Pervasive ETL Tool
  • Performance tuning of Long running queries

Confidential

Sr. Database/Data Warehouse Consultant

Responsibilities:

  • Primarily involved in a Technical role at Confidential Boston.
  • Primarily involved with the Equity Group helping in a technical role on Trading/Price Target, Market Data Applications
  • Project responsibilities include:
  • Overall technical strategy ETL architecture and development.
  • Design & Develop projects on Oracle/Informatica
  • Performance tuning of Long running queries
  • Migration of Databases from Oracle 10g to Oracle 11g
  • Experience with Oracle 10g / 11g migration
  • Experience in migration of different versions of Oracle Worked on RAC with Sun Solaris.
  • Experience with SQL* Loader for importing flat files.
  • Used ADDM and Sql analyzer to tune Sql queries to get best performance output.
  • Experience with EXPLAIN PLAN, SQLTRACE/TKPROF and SQL HINTS for query optimization.
  • Analyzed statistics of PLAN TABLE and DBMS XPLAN package.
  • Performance Tuning on long running queries
  • Experience on Logical & Physical Designing of databases, Data Modeling, Conceptual Design & Data Architecture using Power Designer as a modeling tool

Confidential

Sr. Data Warehouse Tech Lead

Responsibilities:

  • Overall technical strategy involving SAN configurations, Hardware Configurations, database administration, ETL architecture and development, Oracle Application Server (AS) administration.
  • Performance tuning of the data warehouse system.
  • Interact with business users to gather requirements for the system.
  • Define specifications and best practice approach for the project team.
  • Product Suite implemented involves Oracle 10G database with extensive use of Partitioning, Oracle Application Server for presenting data access using a Portal platform, Oracle Warehouse Builder (OWB) for ETL development & Oracle Discoverer for data access.
  • Currently working on OBIEE Implementation.
  • Installing & Configuring Business Intelligence Software
  • Configuring SSo for BI Server & BI Presentation Services
  • Administration of OBIEE BI Administrator
  • Setting up users/Groups/Roles & Configuring LDAP on BI Administrator
  • Handled multiuser development tasks, Merging of the RPDS, Catalog merger
  • Design & Architect & Development of Repository
  • Build Reports & Dashboards on BI Answers
  • Working on IBOTS
  • Administration of BI Answers
  • Experience with Oracle 10g / 9i installation and Configuration on UNIX environment.
  • Experience with Database Administration, Maintenance, Performance Tuning, Backup and Recovery and RMAN administration.
  • Experience with OEM to manage database.
  • Experience with SQL* Loader for importing flat files.
  • Used ADDM and Sql analyzer to tune Sql queries to get best performance output.
  • Extensive experience with tuning and maintaining SGA with init.ora parameters.
  • Experience of EXPLAIN PLAN, SQLTRACE/TKPROF and SQL HINTS for query optimization.
  • Extensive experience with creating and managing schemas, roles, constraints and privileges.
  • Experience on Logical & Physical Designing of databases, Data Modeling, Conceptual Design & Data Architecture using MS Visio, Erwin, Power Designer as a modeling tool
  • Performance Tuning on Large Data warehouse (4 Terabytes)

Confidential

Sr. Tech Lead /Database Developer

Responsibilities:

  • Transaction Life Cycle Management (TLM) - Reconciliation,
  • Helped in analyzing the database schema of the TLM for the Reporting,
  • Developed Database Views, Stored Procedure for the reporting for bank wide,
  • Developed Complex Control, Daily, Managerial Crystal reports for TLM System,
  • Developed and helped in developing 75 Reports,
  • Mentored Junior Developer on Crystal Reports,
  • Developed in Oracle 9i/Crystal Reports 8.0/PowerBuilder/Toad/Windows XP,
  • Used ADDM and Sql analyzer to tune Sql queries to get best performance output.
  • Experience on Logical & Physical Designing of databases, Data Modeling, Conceptual Design & Data Architecture using Power Designer as a modeling tool

Confidential

Sr. Database Developer

Responsibilities:

  • Developed in loading of the Trades from CRD to Portfolio System.
  • Developed various batch scripts to initiate the interfaces to various systems.
  • Helped in analyzing the database schema of the Charles River System.
  • Developed Reports for the investment management group on Crystal Reports (8.0).
  • Developed in Sql Server 2000/WINBATCH/PERL/VB6.0/Crystal Reports 8.0/WINDOWS 2000.

Hire Now