We provide IT Staff Augmentation Services!

Data Solutions Architect Resume

Dallas, TX

SUMMARY:

  • Comprehend convoluted business processes and architect IT solutions to streamline them. (15 yrs)
  • Model Transactional and Dimensional Data in multiple business domains.
  • Data Warehouse and Data Mart architecture, ETL design, Source System analysis.
  • Decipher, abstract and aggregate complex CRM/ERP schemas for Business Intelligence.
  • Cloud solution (AWS, Azure) architecture, design and implementation.
  • Scope assessment, engagement, delivery and mentoring (KT) - technical vendor negotiation;

EXPERIENCE:

Confidential, Dallas, TX

Data Solutions Architect

Tools: SQL Server 2014, SSAS, SSIS, Power BI, ProClarity

Responsibilities:

  • Solution architecture including under-the-hood XML techniques to migrate existing cubes with incremental ETL, schema and cube re-design.
  • Cube extension design (DSV, DIMs) for incremental features added during migration.
  • Exhaustive validation against legacy cube outputs and deployment.
  • Performance tuning of legacy overnight SQL batch job sourcing from BST ERP.
  • Batch time reduction from 5 hours to 30 minutes - mission critical.
  • Analysis of layers that were bandaged over last 10+ years to accommodate evolving business processes
  • Build new sql logic, schema re-design and ETL sequencing from ground up.
  • Validation and deployment of refactored processes.

Confidential, Redmond, WA

Data Solutions Architect

Tools: SQL Server 2014, SSDT 2013, Power BI, Excel

Responsibilities:

  • Architect BI solutions (star schema and ETL design) sourced from Dynamics AX (customized to manage the Confidential Consulting Services planning and operations).
  • Architect different approaches to tabular model design for small business functions that depend on them such as Actual and Forecast Revenue, Resource utilization, Engagement validation, etc. to help in Tabular SSAS migration.
  • Refactor data model based on legacy report and self-service requirements.
  • Mentor offshore development team on design, implementation and best practices.

Confidential, Greater Dallas, TX

Data Solutions Architect

Tools: SQL Server 2012/2014, VS Ultimate 2012, Vertica, SSIS

Responsibilities:

  • Architect and draft a data migration specification to facilitate the migration of Enterprise Data to SnapLogic on a Hadoop (HDFS) platform using an ELT/ETL approach into a new Enterprise Data Hub.
  • Analyze the 700+ SSIS packages, stored procedures, schemas spread across multiple SQL servers, Tidal enterprise scheduler jobs, Vertica schemas, Cognos dependencies (frameworks)…
  • Draft solution architecture specification which details the new data interfaces, target data models, data element mapping, schedules….

Confidential, Greater Dallas, TX

Data Solutions Architect

Tools: MySQL 5.6, Talend 5.4, NDBCluster 7.2

Responsibilities:

  • Architect a usage metering solution for Billing/Monitoring features while extending the SDN based Cloud Management platform, built on Xen, Hadoop and open source components.
  • Analyze and map data elements from Hypervisors to map metrics for CPU, Memory, Network traffic, Uptime, metering analytics, appliance vs VM traffic across multi-tenant systems;
  • Model metering/billing transactional and analytic/aggregated data elements; design/tune large datasets to render aggregations across multiple granularities.
  • Design incremental ETL (delta loads) between InnoDB and NdbCluster storage engines to handle daily and hourly jobs for minute, hourly, daily and monthly aggregated charts.
  • Crunch data for monitoring charts to identify cloud optimization opportunities; correlate events to root cause analysis, etc.

Confidential, Tulsa, OK

Data Solutions Architect

Tools: SQL Server 2012, VS Ultimate 2012, Visio 2010, SSAS, SSIS, TFS

Responsibilities:

  • Design Staging, DW and DM schemas; Design ETL to load data between them; mapping specs.
  • SAP OIU data elements; Cost/Profit centers and their hierarchies, JVAs, WBS Elements, Customer/Vendor, Master Data, etc.
  • Implement BizTalk Adapter to pull data from SAP ECC via SSIS.
  • Implement Open Hub based data source to extract data from SAP BW via SSIS.

Confidential, Chandler, AZ

Data Solutions Architect

Tools: SQL Server 2012, 2008R2, BI Dev Studio 2010, SSAS, SSIS, TFS

Responsibilities:

  • Design SSAS Data Mart; MDM Modeling.
  • Computation of Space Utilization at Confidential facilities globally to optimize real estate utilization.
  • Medians and 85th Percentiles calculations for the utilization metrics across Organization, Geography and Employee Type dimensions for Assigned and Mobile workspaces.
  • Distribute the computational load between DB Engine (stored procedures), SSIS and Analysis services, while delivering dashboards in PPS (Performance Point Server).

Confidential, Spokane, WA

Data Solutions Architect

Tools: SQL Server 2012, BI Dev Studio 2010, SSAS, SSIS, TFS

Responsibilities:

  • Design SSAS Data Mart; Tabular Modeling; Data Mapping; Role-based security implementation, cube partitions & loading (a (>1.5B records/fact table), SQL performance tuning; Agile, SCRUM.
  • Re-factor DW to streamline the DB objects for Data Mart; create abstraction layer for cube src.
  • Identity and draft mapping between Data Warehouse, Data Mart, cube and reporting data elements
  • Cube performance tuning wrt memory management, using DMVs, Profiler, XMLA, DAX tuning...

Confidential, Irving, TX

Data Solutions Architect

Tools: Data Architect 9.0, SQL Server 2008, BI Dev Studio, SSIS, T-SQL, SSAS, UC4

Responsibilities:

  • Design Rx Invoice/Contract/Pricing Data Mart, Dimensional Data Modeling; Data Mapping; Spend Analysis, Month over Month Comparisons, contracted vs Non-contracted vendors; Spend logic and compute potential savings opportunities; ETL Design using SSIS; TFS integration; scheduling, UC4 orchestration.

Confidential

Data Solutions Architect

Tools: SQL Server 2008/2005, BI Dev Studio, SSIS, T-SQL, SSAS, SSRS

Responsibilities:

  • Design an end-to-end Business Intelligence solution for a mission-critical Confidential program using SQL 2008's DB Engine, SSAS, SSIS and SSRS, dimensional modeling and OLAP cubes.
  • Study the source OLTP application and model a star schema with relevant facts and dimension attributes, and aggregations, to facilitate cube based canned and ad hoc reporting requirement specification.
  • Optimal schema design using parent-child dimensions for extendable hierarchy levels, many-to-many and recursive relationships for security implementation downstream.
  • Implement dynamic security through a combination of schema design and cube MDX expressions, SSAS roles & domain names; SCDs, SSIS Script Tasks to automate role member loading and Active Directory lookup.
  • Establish a weekly build cycle subsequent to proofing unknowns, review drops, semi-automated deployment;
  • Institute best practices including package configuration, VSS automation, central logging, error handling

Confidential

Data Solutions Architect

Tools: SQL Server 2005, C#, ASP.NET, Visual Studio, SSRS, SSIS, Visio-Architect.

Responsibilities:

  • Architected/implemented the transformation of a legacy process into a completely automated information system to facilitate network site conversion to MPLS at the rate of over 10 Kinkos sites per night.
  • Negotiate/define/design inbound & outbound data interfaces after deciphering vendor systems.
  • Established team communication and process by defining functional and technical specifications.
  • Build a data repository to house data from vendors and internal ERP/CRM systems.
  • Implement the reusable n-tier Confidential framework (a custom layer over Enterprise Library Application Blocks) for rapid development of the workflow functionality such as work-order processing (HP Global Deploy), purchase order approval (PeopleSoft Financials), trouble ticketing (Salesforce CRM), Customer Service Records (CSR) verification, telecom orders and response, inventory management, financial reconciliation.
  • Tiers include ASPX.Net/C#, page classes, C# Business Logic Layer, Data Access Layer, and DB Objects (T-SQL Stored Procedures/Views/Tables)
  • Draft deployment scripts and documentation for Confidential IT personnel to guide configuration management between environments.

Confidential

Data Solutions Architect

Tools: SQL Server 2008, Visio-Architect, BI Dev Studio, SSIS, SSAS

Responsibilities:

  • Design Data Warehouse data model upon analyzing source systems, conceptual models and business requirements to warehouse mutating Confidential Marketing transactional data and BI specifications.
  • Established Data Warehouse and ETL best practices, standards, processes and mentoring, within the team.
  • Inculcate target systems’ star schema design for BI processing.
  • Streamlined process to generate physical schema and updates, after overcoming discrepancies between Visio Architect and SQL 2008.
  • Design/Implement complex ETLs with selective data retaining over a 10 year sliding window, by incorporating partitioning schemes and functions, spanning over 250 million records

Confidential

Data Solutions Architect

Tools: SQL Server 2005, Integration Services (SSIS), SSAS, BI Dev Studio, Visio-Architect

Responsibilities:

  • Design a data warehouse schema to house relational data from three different data sources containing consumer generated media (CGM) type data, weighing half a terabyte.
  • Designed to accommodate initial data load as well as incremental extraction.
  • Utilization of ETL components for Incremental Extraction such as Slowly Changing Dimension and custom Incremental Reference and Package Log tables.
  • Design package configuration to centralize common data/ parent package variables to transmit data to child packages.

Confidential

Data Solutions Architect

Tools: SQL Server 2005, SSIS/SSRS, C#, ASP.Net, XML, XSL, DotNetNuke

Responsibilities:

  • Design a data mart to populate data from an existing OLTP schema and proofing SQL Integration/ Reporting Services to aggregate/generate summarized usage metrics across various demographics.
  • Extend web application features over the DotNetNuke platform.
  • Co-ordinate with Set-Top Box team to design the core architecture using WPF, XAML to drive the display station and capture video simultaneously.
  • Analyze bulk upload of large files via HTTP and other transport protocols.

Hire Now