We provide IT Staff Augmentation Services!

Enterprise Technology Functions, Data Architect Resume

SUMMARY

  • Enterprise and Application Solution Data Architecture using TOGAF framework and TROUX: Living Target State Architecture, System Architecture Specifications, Transition to Target State Roadmaps, Technology Standards and Guidelines, Context Reference Architecture, Information Chains, Technology Options Comparative Analysis
  • Seasoned BI development expertise with leading reporting tools: Microsoft, Tableau, MicroStrategy, SAS Web Report Studio, Crystal Reports, BRIO, WebFocus 7x, Spotfire, Business Objects XI on enterprise level
  • Leading knowledge of data modeling and relational database design (3d Normal, Star, Snowflake) techniques. Designed relational, reporting and data warehouse databases for MS SQL Server, SAS, DB2, Oracle platforms utilizing conceptual, logical and physical design phases for BI, Data Warehouse, Reporting, OLAP, OLTP systems
  • Expert knowledge of the Microsoft Business Intelligence Suite of Tools
  • Owner of best practices to deliver all components of Data Warehousing Architecture: Database, Data Integration, ETL, Semantic Layer, MDM, OLAP and Presentation Layer using various of Data Warehousing frameworks such as: Traditional Kimball, Inmon frameworks, Semantic Layers and Virtualization, LDW, Hub - And-Spoke, Data Lake
  • Expert knowledge of ETL components, methodology and ETL life cycle for data warehouses and reporting solutions
  • Expert knowledge of leading Data Movement and Integration products (Informatica, AB Initio, SSIS, GoldenGate)
  • 7 Years formal technical leadership as part of Technology Managers group
  • Highly experienced in leadership, design and implementation of the large scale migration, conversion and upgrade data migration projects including that included ETL components across different database platforms, database physical design migrations, data conversion, SQL Server release conversions 2000 to 2005, 2008 to 2012
  • Extensive experience and knowledge in database disaster recovery methodologies such as database mirroring, replication and log shipping. Performed numerous of projects to combine these methods for both hardware and software DR replication solutions on various levels: Data Center, Application Farms, Database Servers Groups
  • Expert knowledge in Data Quality frameworks and implementation with various tools and technologies
  • Expert knowledge of database programming using TSQL for OLTP, ETL, OLAP and reporting systems
  • Solid knowledge in administration and proactive monitoring of the large scale database production sites. Performed production support for 100+ SQL servers resolving time critical issues for wide range of technical aspects
  • Experienced in leadership of the database version control in complex development environment
  • Performed technical justification, and evaluation of hardware and software recourses for IT budget, IT workload planning and ROI analysis of IT solutions and automation of business processes
  • Experienced in management of IT project life cycle leveraging waterfall and agile frameworks (scrum and kanban)
  • Technical leadership with solid techniques for mediation of opposing technical viewpoints and collective input to produce optimal solution that fits budget, skills and timelines

TECHNICAL SKILLS

Database Platforms: MS SQL Server 2012+, Sybase 11.0, Oracle 7/8/9/11g, DB2, Teradata 13.0. Familiar with UniData (IBM), SAS 9.2, Hadoop 3/HIVE, Mango DB

ETL Platforms: Ab Initio, Informatica, Talend

Programming Languages: Transact SQL, Windows Scripting, ASP, Java Script, VB Script, .NET, MDX, XML, Map R

OS and Servers: DOS, Unix, MS Windows NT 4.0 - x - 2007, Professional, XP, Vista

Tools: Ab Initio GDE, Ab Initio Express-IT, Ab Initio Acquire-IT, Ab Initio Enterprise Metadata Hub, Teradata Studio Microsoft SharePoint 2010 reporting tools, Microsoft PowerPivot 2010/2012, ISQL, SQLCMD, PowerShell, SQL Profiler, Replication Manager, Embarcadero DBA Solution Pack (ER/Studio, Rapid SQL 5x, DBArtisan), Visual Studio, Erwin, Crystal Reports and Crystal Info Web,Business Objects XI, Microsoft Project, Visio, IDE, VSS, CVS, Subversion, Control-M, Hyperion Brio, RedGate SQL Toolkit, Microsoft BIDS 2012+, Tableau 6.0 Professional, SAS 9.2 BI Suite, MicroStrategy, WebFocus 7x, Spotfire, RALLY Agile Development Tool, Rochade, Informatica Metadata Manager, Informatica PowerCenter, Informatica DQ, Power Designer and ER/Studio data modeling tools

PROFESSIONAL EXPERIENCE

Confidential

Enterprise Technology Functions, Data Architect

Responsibilities:

  • Application solution design and architecture on Enterprise Data Lake Environment following data ingestion standard design principals and standard practices approved for Confidential Data Technology Blueprint Big Data strategy using Big Data technology frameworks and tools (Hadoop, Spark, Parquet, HIVE, Kafka, JSON)
  • Definition of strategic vision in the product solution architecture and technology capabilities aligned with business architecture of the credit risk group and enterprise architecture standards
  • Strategic direction and thought leadership to create the multi-year capabilities of the Credit Risk products roadmap. The alignment with Enterprise and Home Lending Architecture
  • End to end system architecture and components design for a large complex data warehousing solutions
  • The critical path projects re-alignment and execution delivery planning for efficient implementation of the strategic technology objectives within current body of work and priorities of the Credit Risk business group
  • Impact assessment of the new projects with delivery of Conceptual Architecture Design (CAD) and SDD (Solution Design Document) consisting of all aspects of end to end solution architecture: Data, ETL, Data Quality, Metadata Management
  • Evaluation of emerging technology trends imposed by Enterprise Technology transitions / innovations required to support the desired list of new capabilities. POC and PILOT projects leading small team of developers
  • Architecture review of the product releases to insure the conformance to best practices and established technology standards with emphasis on the technical aspects of the implementation
  • Communication of technology improvements value to business partners to gain the approval and support of advancement of technical capabilities. Simplify complex technical concepts for business partners
  • Partner with Agile Scrum teams in implementation delivery phases to ensure the proposed design and architecture realized accurately, timely and with highest quality possible
  • Evaluated of Spark, Kafka and Mango DB tools to address current scalability problem with data replication of mass amounts of data across multiple operational data environments for CARE application
  • Implemented Address Standardization and Mastering Residential Collateral multi-component complex application on Enterprise Data Lake Environment using Hadoop 3, HIVE Extended tables and Ab Initio
  • Current state analysis of CARE application that supports Confidential Home Lending loan approval and decision process. Completed the technical assessment of core architectural components: ETL, Data Design, Data Quality, Metadata Strategy and defined the set of improvements required to bring the system into target state
  • The design of CLRTY application conversion from legacy SQL technology and sources to a target state architecture using the incremental delivery in parallel with existing design patterns. This 3 years project was composed of 5 major releases co-existing with data conversion programs which included the migration of mortgage servicing data to the go-forward CLRTY data model, as well as reduction of upstream sources and multiple ETL tools. Advocated reduction of complexity, data sources and tools to reduce the operational cost and decommission surplus components used prior.
  • Ab Initio ETL migration from SQL Server Integration Services including Ab Initio infrastructure build
  • Ab Initio Data Quality applications design and implementation to create the baseline for Data Quality framework integrated with ETL and aligned with Data Governance requirements. DQE rules design, metrics definition, automation and EMH scorecards publishing using single Ab Initio platforms and suite of tools
  • Ab Initio Metadata Management implementation for CLRTY application. Successful integration of metadata support and lineage capabilities to Confidential Ab Initio Enterprise Metadata Hub solution
  • Agile Scrum methodology implementation, training and transition management for the team of 50 fitted to the standard of Confidential SDLC policy
  • Definition and implementation of Architecture Governance practice in CLRTY team to achieve the integrity of the product design and best standards in implementation delivery for 50+ the cross-functional team
  • Data Modeling of STAR schema and management of the migration from legacy to the target state data model
  • BI tools evaluation for Credit Risk business unit with practical suggestions and cost-benefit options analysis of MicroStrategy, Business Objects, Tableau and SAS Visual Analytics

Technology Stack: Ab Initio Graphs & Express IT, SQL Server 2008-2014, Teradata, SAS, Tableau, HIVE, Hadoop, Mango DB

Confidential

Strategic Architecture Financial Advisory Services

Responsibilities:

  • Align technical solution designs with guiding principles of Enterprise Data Architecture for building consistent integrated Enterprise Data Repository (EDR) in scope of new 2013-2015 Data Program Initiative
  • Define vendor agnostic design patterns for main components of Enterprise Data Warehouse: Data Movement, Data Integration and Data Delivery channels using combination of traditional data warehousing methods and Service Oriented Architecture (SOA)
  • Classify data domains across functional business capabilities to create Information Value Chain matrix for building Enterprise Logical Data Model conforming to financial industry standard
  • Deliver recommendations for sourcing, integration and vending of data, end-to-end data lifecycle, data quality, standards, patterns and guidelines to support data governance policies, Enterprise Metadata Repository solution implementation, MDM implementation, Enterprise Reference Data Solution Architecture, Business Intelligence Solutions Architecture and implementation and incubation of Big Data Technologies

Technology Stack Used: Oracle 11g, Informatica Data Integration Suite, Informatica Metadata Manager, Golden Gate, ABInitio, Tableau, Spotfire, Business Objects XI, Data Virtualization Platforms, BIG Data Platforms: Hadoop and Mango DB

Hire Now