We provide IT Staff Augmentation Services!

Data Architect Resume

5.00/5 (Submit Your Rating)

Atlanta, GA

PROFESSIONAL EXPERIENCE:

Confidential

Atlanta, GA

Contract Consulting

Responsibilities:
  • Technology Management ( 15 yrs )
  • Onshore Teams Project definition and execution
  • Offshore Teams Development team task delivery and issue resolution
  • SaaS Dot Com Software provider overall management for MS Azure platform delivery
  • Enterprise Data Warehouse project delivery
  • Business Intelligence and Database Integration project delivery
  • Enterprise Data Architecture and Modeling ( 11 yrs )
  • EDW Management & ETL Data Integration, SQL Prototyping & Optimization
  • MDM Requirements Gathering and Data Lineage discovery
  • Logical and Physical Data Modeling with Metadata management
  • Enterprise Application Integration and Architecture (16 yrs - 2 yrs since 2013 )
  • SOA - Architecture Blueprint & Business Process Automation
  • Leveraging Cloud infrastructure and PaaS development ecosystems
 Confidential

Atlanta, GA

Data Architect

Responsibilities:
  • Research for ABI Sandbox operations support team. Resovled issues such as connecting MS SQL Server to Teradata Aster, MS SQL Server Monitoring and Activity Report design consulting.
 Confidential

Atlanta, GA

Data Architect

Responsibilities:
  • Designing data structures for ETL and Teradata supporting Customer Profitability analysis.
  • Forward engineering DDL for Teradata from ERWin.
  • Data Modeling completed in ErWin on Teradata.
  • Data source lineage for Customer, Product, and Invoicing from GL.
 Confidential

Atlanta, GA\

CTO / Architect

Responsibilities:
  • Azure Migration and Performance Tuning while migrating and launching Dental Office software as a service to cloud computing.
  • Managing a Dental Office management software as a service targeting Microsoft Azure cloud computing services.
  • Migrated live site from older ISP platform to Azure cloud based environment, this activity allowed for reduction of user execution times from 5+ minutes to sub second response times via IIS Virtual Machine resizing.
  • Steered the startup to become a Microsoft BizSpark member.
  • Establishing standards and architecture to match growth and demand within a maturing software development life cycle; standards such as source code control, automatic deployment within the cloud environment.
  • Defining the Virtual Network environment utilizing Azure s Application Gateway, Load balancer, Scaling Sets, IIS Virtual Machine sizing, and MS SQL database Virtual Machine sizing.
  • Additional environments for DevOps, including Test and Demonstrations also built within the Azure cloud.
  • The code base is Microsoft C# model view controller with master pages.
  • Azure Infrastructure Management, MSDN, Visual Studio, SQL Server, IIS.
  • Data Modeling completed in ErWin on MS SQL Server.
 Confidential

Atlanta, GA

Interface Architect

Responsibilities:
  • Defining Enterprise Application Integration architecture blueprint targeting a Service Oriented Architecture implementation in a private equity services financial environment. Developing architecture documents, database design, building estimation calculators for business process development level of effort.
  • Working directly with C - level to facilitate business process reengineering and automation of new interfaces eliminating manual process, my role on the team focuses on data management across the enterprise.
  • Prototyping the use of OData as a data connector for ESB support within Mulesoft.
  • Enterprise Architecture, SOA, Mulesoft Anypoint Studio 5.4.0, Mule Runtime 3.7.3, Java, Eclipse, Linux.
 Confidential

Atlanta, GA

Data Architect

Responsibilities:
  • Providing data architecture modeling logical and physical layers of multi - terabyte home loan data store.
  • Leveraging standard query based technologies as the reporting platform for very large data volumes on a Teradata platform. Requirements gathering, ETL development, optimizations, new standard data updates to history, data structure reviews, basically the entire data warehouse development, maintenance, and production support cycles and performance optimizations.
  • Data Modeling completed in ErWin. Teradata utilities used for ETL and data movement. Data source lineage for Customer, Product, and reference data.
 Confidential

Atlanta, GA 

Senior Architect

Responsibilities:
  • Directing data collection Solutions supporting data monitoring and control systems.
  • As an advisor implementing the integration of big data and remote data collection systems.
  • Providing professional services team s direction in building long term data management strategies leveraging emerging technologies as the reporting platform for very large data volumes utilizing an Enterprise Data centric approach supporting a Service Oriented Architecture. Environments for DevOps Production, Test, Development, and Demonstrations maintained within the Azure cloud.
  • Azure Data Management, SOA, Mulesoft Anypoint Studio 3.5, Mule Runtime 3.4.1, Java, Eclipse, Linux.
 Confidential

Atlanta, GA

Senior Manager

Business Information Management

Responsibilities:
  • Data Architect for Enterprise Data Warehouse projects supporting data modeling and reporting view layer entity relationship discovery and identification thru data lineage and source analysis.
  • Analysis supporting the definition of in - scope data elements required for harmonizing the equipment domain and integrating with other business entities across the enterprise.
  • Analysis of the ETL system to discover scheduling and transformation logic for sourcing data requirements.
  • ETL development utilizing BTEQ, FLOAD, MLOAD, and Teradata Parallel Transporter utilities.
  • ErWin, Teradata, Teradata Utilities, AIX, Maestro (Tivoli Workload Scheduler)
  • Full scale data warehousing solution including all phases of blueprint to cutover planning.
  • SAP data captured using data extractors. Teradata data loads using Business Objects Data Services, Teradata Parallel Transporter, BTEQ, FLOAD, and MLOAD to complete data lineage ETL requirements.
  • Development of high level documentation down to technical interfacing, and operational implementation of products IBM IDMS, Business Objects Data Services, Teradata Utilities, Teradata Data Models originating from Erwin, and Cognos reporting platform data delivery.
  • Professional Services Data Architect for Initial Enterprise Data Warehouse migration from IBM DB2.
  • This was the first step in expanding the existing data warehouse to handle more data and queries migrated the DB2 physical data design to Teradata, of course many subtle changes are required to take advantage of Teradata s architecture.
  • Point of Sale information combined with product display analysis by merchants and product management where top priorities.
  • Teradata provided standard reporting and adhoc query utilizing the IBM Cognos platform for Business Intelligence applications.
  • Informatica, Business Objects Data Services, and Teradata Parallel Transporter where used as ETL tools to load data on daily, weekly schedules.
Confidential

Atlanta, GA

Solution Architect

Responsibilities:
  • Integrated Data Warehouse design, development, and management utilizing professional services methodology on client engagements executing full data warehouse life cycle development and deployment technical management and lead development.
  • Technical Solution Sales to customers and providing technical expertise to pre - sales solutions.
  • Developing customer solutions and roadmaps for leveraging data as an asset.
  • Customers include Delta Airlines, FedEx, InterContinental Hotels Group, Habitat for Humanity Intl, Carmax, Starwoods, UPS, Hertz, and Airtran.
  • Development of proposals, statement of works, project plans, and staffing requirements as well as oversight of projects in execution.
  • Project Manager leading the professional services delivery and engagement development of the first Teradata appliance for an enterprise data warehouse project supporting the Marketing Data Platform.
  • Managed and directed a team of 12 consultants, 4 onshore and 8 offshore.
  • The Home Loan & Insurance Group s 8 MDP SQL Servers to Teradata Migration Project involved the conversion of the current MS SQL - based Server environment to a 15 node Teradata Appliance platform with a 9 node disaster recovery platform.
  • The MDP platform supports a multi-million target marketing campaign application supporting Unica, Siebel, SAS, and Oracle analytics.
  • Data loading accomplished with Teradata utilities BTEQ, FLOAD, MLOAD, and TPT.
  • Data Modeling in ERWin, Oracle and Teradata platforms.
  • This customer provided personnel and management new to Teradata.
  • Emphasis on mentoring and knowledge transfer was a significant need of the project.
  • Multiple platforms of data sources included SQL server, Oracle, and Teradata.
  • Challenges to overcome included the scoping of 2.4M lines of code down to a reasonable set of 150K.
  • Delivered a High Level and Low Level design along with guidance on integrating architecture, metadata, data quality, data lineage, governance, and managed services within the bank environment.
  • Project Manager / Solution Architect for managing the professional services delivery and engagement development of a new enterprise data warehouse project.
  • Managed and directed a team of 6 consultants to provide Informatica ETL and Teradata data management components.
  • This customer was new to Teradata, personnel and management.
  • Emphasis on mentoring and knowledge transfer was a significant need of the project.
  • Multiple platforms of data sources included SQL server, Oracle rdbms, and unstructured master data stored in spreadsheets.
  • Emphasis on leveraging Teradata utilities to load data from multiple types of data sources.
  • BTEQ, FLOAD, MLOAD, and TPT utilities fulfilled ETL requirements.
  • Data Modeling in ERWin, SQL Server and Teradata platforms.
  • Project Manager for Oracle to Teradata Migration project for new customer.
  • Managing the professional services delivery and engagement project.
  • Responsible for development of an Informatica, Teradata, Business Objects platform of products utilizing an onshore and offshore ADC development team.
  • Managed and directed a team of 16 consultants to provide ETL, Teradata data management, SAS, and Business Objects universe reporting components.
  • The project migrated world wide data from an existing oracle data warehouse to the Teradata platform resulting in a significant improvement in performance and in most cases actually completed complex queries in minutes rather than hours.
  • Some challenges included the management of Unicode based data and upgrading the Informatica platform to support this data during loading.
  • An incremental approach was taken to reduce the overall project risk by loading sets of subject areas in multiple iterations.
  • The ADC offshore team played a major role in the development and delivery of the ETL deliverables.
  • Data Modeling in ERWin, Oracle and Teradata platforms.
  • Mosaic Integrated Data Warehouse - Managing the engagement of professional services methodology supporting the Sabre20 component of the Mosaic engagement.
  • Responsible for operational data store consolidation of 10 data marts into the AA integrated data warehouse.
  • Leading the definition of source data elements, approx. 10,000, mapping the data entities to integrated data components, logical data modeling utilizing ERWin, Teradata physical data modeling, Data Stage ETL requirements and development, semantic view layer requirements and development, and user acceptance testing.
  • Managing and directing a team of 4 on-site and 4 off-shore, ADC resources.
  • Responsible for the Sabre20 data marts overall progress and success.
  • Directly influencing the customer s activities and facilitating agreements on development and delivery methodology.
  • Full data warehouse life cycle development and deployment.
  • Data Modeling in ERWin, SQL Server and Teradata platforms.
  • Strategic Air Reporting Project Manager for the professional services delivery and engagement project.
  • Responsible for development of a set of baseline Cognos - based air reporting capabilities for Sabre Airline Distribution & Marketing personnel.
  • The cubes and reports are based on data from the Enterprise Travelers Data Warehouse, Scorpion, and GDS Reporting Universe.
  • Also provided documentation, training, and technology transfer services.
  • Managed and directed a team of 6 consultants to provide Sunopsis ETL, Teradata data management, SAS, and Cognos cube reporting components.
  • Dual Active Requirements Definition and Solution Design Service - Determined the Business Continuity, Data Synchronization, Workload Management, and Systems Management requirements of the Teradata applications that Sabre utilizes for the Enterprise Travelers Data Warehouse, analyzed the requirements, and designed a Teradata Dual Active solution to satisfy the requirements.
  • Determined the data and source(s) associated with the applications.
  • Examined the current ETL for any revisions needed.
  • Designed and documented a solution capable of synchronizing this data between the two systems.
  • Developed a Data Synchronization implementation plan, including the number of tables to be synchronized and the synchronization methods used for each table.
Confidential

Master Data Management Product Manager

Responsibilities:
  • Managing the development of professional services methodology and engagement assets supporting Master Data Management engagements.
  • Responsible on a Global product deployment scope, interfacing with internal Marketing, Engineering, Training, Sales, and Professional Services resources to develop service offerings.
  • Driving cross - functional alignment, program management, global requirements capture, internal budgeting and business case development, 3rd party partnerships, development and delivery of tools and assets which become part of the MDM proposed offer.
  • Data Modeling in ERWin, Oracle and Teradata platforms.
 Confidential

Atlanta, GA

Enterprise Architect

Responsibilities:
  • Leading business development, marketing teams, and providing architectural assessments and recommendations to senior management on consulting services opportunities.
  • Responsible for supporting all technical aspects for Air Force Logistics enterprise architecture and major program acquisition strategies.
  • Full life cycle activities from Enterprise modeling, project sizing, technical road maps for development and deployment of application systems, portfolio management, legacy modernization, business justifications, and COTS integration projects ranging from $1M to $250M.
  • Developed teaming agreements with CSC to leverage the ECSS program win, $1.2B, providing the enterprise architecture and integration roadmap.
  • Delivering technical thought leadership in the incremental improvements required for sustaining long - term maintenance of program software solutions focusing on Enterprise Architecture Frameworks and Portfolio Management.
  • Creating and defining Enterprise Architecture Frameworks consisting of various approaches, models, and definitions for communicating and facilitating the presentation of key architecture components (i.e. architecture vision, governance, principles, guidance, products, etc.) required for the development and integration of business domain architectures.
  • Enterprise Architecture Frameworks establish a common foundation for understanding, comparing and integrating architectures and as such provide the overarching guidance for generating domain architectures.
  • The resulting artifacts document the linkages between business needs, information content, and information technology capabilities.
  • Developed integrated plans or roadmaps to conduct capability assessments, guide systems development, and define the associated investment plans as the basis for aligning resources.
  • Critical to the execution of enterprise architectures is the demonstration of visibility and management of the resources allocated to IT investments.
  • Portfolio management permits business units to assess, prioritize, and allocate funding for IT, as well as identify redundancies and opportunities for increased efficiencies.
  • Portfolio management ensures IT investments are synchronized with the Architectural Blueprints.
  • Advising and developing technical approach solutions involving Enterprise architecture technical tools and frameworks including Troux Metis modeling, Service Oriented Architectures, Global Combat Support Systems (GCSS-AF) integration framework, and Air Force Enterprise Information Technology Strategies core to the business solution.
  • Exercised a full understanding and training of the technical workings and various component/levels of the FEAF and DoDAF architectural frameworks supporting Government contract proposal development and program execution including government mandated requirements and compliance.
  • confidential realized in the GCSS-AF IF consists of Discovery, Mediation, Enterprise Storage, Enterprise Application Hosting, Information Assurance/Security, User Assistance, Enterprise Services Management, Collaboration, and Messaging.
Confidential

Proposal Manager

Responsibilities:
  • Managed bid and proposal life cycle for confidential's request for proposal to obtain services for the As - Is state for the State s email infrastructure requiring the preparation of a business case, using a planned methodology to provide alternative solutions for cost savings and efficiency as well as establishing standards for the confidential.
  • The confidential's enterprise architect initiatives govern themselves in accordance with the FEAF.
Confidential

Professional Services Architect

Responsibilities:
  • Responsible for supporting all technical aspects of the ARMS (Aviation Resource Management System) Modernization engagement, an aircrew member tracking information system initiative for the confidential.
  • Responsible for building the design, implementation, testing, and documentation for all areas of the project development.
  • Defining the technical solution for the full development life cycle integration directly with Air Force test systems by providing a full GCSS - AF compliant system that mirrors production-providing unit, string, integration, deployment, and functional unit testing.
  • Leveraging the Rational Unified Process methodology for design and analysis, construction, and deployment.
  • Technical aspects involved a standard Oracle J2EE development and target production environment utilizing JDeveloper, Oracle 9i Application Server, and Oracle 9i Database Server.
  • Integrated technologies include Jakarta Struts, Tivoli Access Manager, and compliance with the GCSS-AF Integration Framework.
 Confidential

Atlanta, GA

Senior Principal Consultant

Responsibilities:
  • Responsible for managing all technical aspects of the ILS - S (Integrated Logistics Systems Supply) Modernization engagement, an Enterprise supply chain initiative for the confidential.
  • Responsible for building the pre-sales prototype defining a real working solution for the Director of Supply for the Air Force to evaluate an incremental way ahead to integrate a future ERP solution which resulted in an 8 million dollar contract award.
  • Technical direction and oversight over subcontracting agents including Computer Sciences Corporation, ASD Global, and Integraph Solutions including Bid and Proposal, Sizing, and initial Project Plans.
  • Defining the technical architectural vision for an incremental implementation of a J2EE EJB component delivery based on EAI and application messaging.
  • The solution provides Legacy adapters to a Unisys platform and IBM 390 platform providing enterprise inventory visibility and aircraft supply ordering capabilities.
  • Directing the full development life cycle integration directly with Air Force test systems by providing a full GCSS-AF compliant system that mirrors production-providing unit, string, integration, deployment, and functional unit testing.
  • Leveraging the Rational Unified Process methodology for gathering requirements, design and analysis, construction, and deployment.
  • Technical aspects involved Commercial Off the Shelf evaluations and recommendations of Interplex, Attachmate, and Mitem Corporation for non-invasive legacy system connectivity solutions.
  • Tibco, SeeBeyond, and BizTalk for an EAI solution, and Cognos, Business Objects, and Hyperion for Business Intelligence solution for use with a Teradata Data Warehouse.
  • IBM Policy Director, IBM WebSphere, IBM MQ Series, Oracle 9i Application Server, and Oracle 9i Database Server where core framework technologies for delivery of services.
 Confidential

Atlanta, GA

Senior Principal Consultant

Responsibilities:
  • Provided eBusiness architecture and technical project consulting for confidential.
  • Directed clients integration teams through development, go live performance measurements, and optimizations.
  • Specialized in developing content migration systems using Java and C++.
  • Provided product version data and code migration, website product installation, site assessment reports, development strategy support, and performance monitoring and kernel tuning.
  • Performed at double the consultant billing target and produced $60,000 per month in revenue.
  • Project manager and architect for The Education Center s first online store.
  • Provided a user interface for business content team to design and create new web pages without the need to develop HTML coding.
  • Development utilized Javascript, Java, C++, and customization of BroadVision Enterprise and Commerce servers.
  • Developed custom CORBA real - time communication servers in Java and C++ for Home Depot focusing on credit card approval and online checkout integration.
  • CORBA server processes 182 credit card authorizations per second.
  • Eliminated the need for modification of core financial mainframe applications by customizing the online checkout procedure to interface the same as physical stores.
  • Re-wrote the online customer registration web pages.
  • Mentored Java and Javascript team developers on coding practices and implementations for the user interface. Assisted Verity engineers in the deployment of the K2 real-time search product developed in C++. Products used include Sun Solaris, HPUX, and MS Win2K operating systems.
  • Oracle, Informix, and SQL Server database systems. Iplanet, NES, and IIS HTTP server systems.
  • Large scale enterprise technologies include CORBA, Java, C++, Unix shell scripting, Perl, J2EE, JSP, ASP, MTS, DCOM, ISAPI, NSAPI, TCP/IP, BCD sockets, JavaScript, SQL, and custom multi-threaded high-speed transaction servers.
  • Object documentation utilized UML and Rational Rose.
  • J2EE Services built with IBM Websphere and Oracle Application Server.
  • Patents
  • System and Method to Provide a Custom Browser Interface for Communication Devices .
  • W. Allen Robinson, Jr. Convergence Corporation, Inc. U.S. Application Serial # 09/268,454, March 1999.
  • Purchased by Amazon, Inc. in September 1999.
 Confidential

Atlanta, GA

Software Manager

Responsibilities:
  • Managed the direction of software development to support the startup company s wireless initiatives.
  • The company sold a 10% share to Intel Corporation to join them in the Bluetooth short - range wireless research and development efforts. My development strategy as architect was to provide real demonstrations of the future value this new technology possesses through wireless application servers. Developed a patent and working wireless servers at the application level. The company sold to Amazon. Reviewed Intel Corporation s driver source code for design and analysis purposes which support the identification of functional business requirements leading to derivative works for redistribution licensing agreements targeting original equipment manufacturers.
  • Designed custom communication protocol implementations utilizing the wireless office concept allowing all computing devices to communicate implementing new wireless technology code name Bluetooth.
  • Directed the design and implementation of TeleBrowser a communications service enabling both wireless and wired transports to utilize the Internet. Designed an abstract bridge protocol interface for network computing devices to support the submission of data requests and return responses. Transported on these protocols are applications supporting the synchronization of email, alert messages, stored voice messages, stocks, flights, and weather. The synchronization process prototypes were demonstrated on HP Joronado, Palm Pilot, Bellsouth Interactive pager, and Skytel s two-way pagers.
  • Customers included MCI, Bellsouth Wireless, Telecom Wireless Services, Cognos, and Ericsson.
 Confidential

Atlanta, GA

Contract Software Engineer

Responsibilities:
  • Implemented signature - capture applications to support sales efforts enabling emerging hand-held hardware technologies. Developed multiple communication protocols supporting the gathering of information utilizing hand-held devices used in warehouse inventory systems. Developed applications supporting the on-board data collection systems for fleet trucking organizations integrating speed, GPS location, and messaging support for driver log tracking. LAN, WAN, and GPS wireless devices to implement real-time wireless communications.
  • Managed a team of 8 developers to implement core business processes for Business Management Systems division. Data modeling activities covered the customer service, billing support information, order entry, and premise equipment information domains. Lead object oriented design and implementation of distributed data warehouse objects stored in Versant s Object Orient Database system.
  • Rational Rose modeling the business definition; use case analysis, technical design, and n-tier client-server development based on IONA Orbix CORBA technologies. Built using Visual C++ and MFC.
 Confidential

Atlanta, GA

Software Engineer

Responsibilities:
  • Assigned to Concert Management, a joint venture with MCI. Designed & coded data collection agents & services for Concert's global switch network event management system.
  • Server development was Unix based multi - threaded server coding in C++.
  • The client monitoring stations where MS WinNT based, code was developed using Visual C++.
  • Publications
  • Add Serial I/O to Your MFC Applications . Allen Robinson, Visual C++ Developer, Pinnacle. May 1995
 Confidential

Atlanta, GA

Software Engineer

Responsibilities:
  • Enterprise Systems, Mobil Computing R&D department, developed wireless email and messaging applications.
  • Utilized object oriented architecture, design, and coding to complete delivery of a cross platform Communications Object Interface Library supporting wireless and wired transports for Coca - Cola s initiative to streamline the service and delivery business units of associate bottling companies.
  • Accomplished development using Visual C++, Visual Age C++ on MS WinNT and OS/2.
  • Handheld devices included the Apple Newton, LXE, and Symbol Technologies product line.
 Confidential

Atlanta, GA

Lead Programmer

Responsibilities:
  • Modeled, architect, designed, coded, released, and maintained the Automated Order Processing System.
  • Replaced a paper form based order entry process and reduced the circuit activation time by 21 days on average order, ultimately increasing revenue and saving the company a total 20 million dollars a month.
  • Lead a development team of 4 that grew to 16. Released the first version in 18 months in alignment with the laptop hardware deployment schedule. The software provides the field sales team with data collection, validation, and communication software to gather product order information. AOPS utilizes architecture separating the Presentation, Process, Communications, and Data components. The design separates data from process allowing a data dictionary to supply the system requirements defining data entry and the process to act as a separate executing system. Big Data database design implemented with only 2 fields a key and a value.
  • Accomplished development with MS Win32 API, Visual C++, and Borland C++ on MS Windows.
 Confidential

Atlanta, GA

Software Engineer

Responsibilities:

  • Developed Interactive Voice Response applications for the banking and education industries.
  • Coded applications utilizing a proprietary scripting language and c on a DEC VAX running Unix V.
  • Modeled data and business processes for bank account information and college registration systems.
  • Davox purchased the company and moved development to Boston, MA.

We'd love your feedback!