Data Manager

DANTE M. MACIEL

*** ***** **** *****

Fort Worth, TX 76131

www.linkedin.com/in/dante-maciel537

*****.*.******@*****.*** 817-***-****

Data Management professional with proven ability to address project risks, thoroughly analyze and quickly resolve technical systems/data issues.

Excellent contributor with over 23+ year’s in multi-platform Data Delivery, Environment Management, Platform Administration and Configuration Management.

A proven track record of Application Support in Financial Services and Information Technology Divisions.

EDUCATION/CERTIFICATION

Bachelor of Science in Computer Information Systems, DeVry University, Chicago, IL

Oracle 10g RDBMS Certificate, Institute for Professional Development DePaul University,

Expert Level I CELIC-20190128, Expert Level II CELIC-201*****-***, Expert Level III CCE03-20190131-556

TECHNICAL SKILLS

Applications: Global IDs Data Quality Tool Administration (Web/Client), Autosys Scheduling Administration (JIL), Remedy Change Control, Forte Applications Administration, IBM-Rational ClearCase, ClearQuest, Quality Center, WebSphere 6.1, FTP/SFTP, NDM (Connect Direct), SSH, HTTP, HTTPS, VIP, Firewalls, Tortoise Client, JIL, ANT, COBOL, JCL, VB

Operating Systems: AIX/HP/SUN Solaris UNIX, Red Hat Linux, Korn Shell Scripting, Windows NT, MVS, ZOS USS, TSO/ISPF

Databases: Oracle 11g, Cache SQL, DB2, SQL Server

Familiar with: Data Governance Best Practices, Collibra, Adaptive Metadata, Data Glossary management, Microsoft Visio, SharePoint, Excel (VLOOKUP, Pivot Tables), Informatica ETL, AWK Reporting, Mainframe SAS, SFTP, ConnctDirect (NDM), Perl, Python, Make, File-Aid, Easytrieve, Spufi, QMF, SyncSort, Oracle Enterprise Manager, Data Pump, Import/Export, PL/SQL, DML, DDL, SED, Visio Data Flow Diagramming, Subversion Administration

Soft skills: Data Delivery & Management, Platform Administration, Change Control & Release Management, Building Data Pipelines, Builds & Deployments, ETL Job Scheduling & Monitoring, Mainframe Support, Environment, WEB and SOA application support

Actively working on my Hortonworks Hadoop Administration Certification

PROFESSIONAL EXPERIENCE

Signature Consultants/Bank of America Plano, TX Oct 2018 – Feb 2018

Senior Data Analyst

Responsibilities:

●Researched application Lifecycle Lineage information by Application Tracking Identifier (AIT Number) to report on new and retired SOO’s and SOR’s data elements (system of origin, system of records)

●Performed quality control reviews of asset flow information for documents, feeds, tables, transformation and data object asset information via the Collibra Data Catalog

Insight Global/53RD Bank, Cincinnati, OH Dec 2017 – Jun 2018

Data Workflow Administrator

Responsibilities:

Managed web portal access and provided updated plans of data discovery and profiling in Global Ids Data Quality V9 for end-users such as Data Stewards, Data Architects and Data Quality Analysts

Managed the Data Discovery of Metadata and Data Profiling results in a HIVE data lake

Reported and Overseen that fixes get implemented for vendor bug fixes and configuration changes to operate and optimize system performance on the Hadoop Cluster

Created semantic Domain Profiling of all ingested data on the banks HIVE Data Lake for business stake holders.

TD AMERITRADE, Fort Worth, TX Jun 2012 – Oct 2017

Description:

Key contributor to successful establishment of firm’s Enterprise Data Quality program via GlobalIDs. Responsible for architecture, server build-out and frameworks while implementing Global IDs and data feed conversions using Python and Tidal for EBX5 (Reference Master Data Tool).

Data Quality Analyst / Platform Engineering

Responsibilities:

Hands-on experience in writing and reviewing business requirements, architecture diagrams, test plans and Technical Runbooks for Data quality analysis and helping with the software release process.

Worked heavily with Security Admins, DBA’s, Network Admins and Windows Engineering to deliver appropriate security implementations in Kerberos, SSL, HTTPS, Windows Security Certs, LDAP and Firewalls.

Knowledge of HIVE Clusters, configurations and deployments of data nodes to the BIG Data Hadoop Clustered Environment.

Experience with Red Hat Linux, UNIX Shell Scripting, Java, RDBMS, NoSQL and ETL solutions.

Created and Maintained Python programs for incoming feed files from 8 different vendors and reformatted those files according to company standardized file formats

Built-out the Global Ids Data Quality infrastructures in DEV, UAT, PTE, PROD, HA and DR on Windows, Linux VMs and Web Clients.

Configured Connections to multiple data sources inside the Global Ids Environment to Oracle, MSSQL Server, PostgressSQL and HIVE Data ecosystems (DEV, UAT and PROD)

Performed and Scheduled Globalids Data Discovery and Profiling Workflows on 100+ TDA Enterprise data sources

Performed Table comparisons by using the Table Compare Manager between TDA Core systems and Netezza EDW Data Warehouse environments

Discovered, Evaluated and Established new data pipelines via Dashboards and ETL for Business Units, Data Stewards and Data Governance Analysts.

Technical lead for EBX5 throughout SDLC for projects requiring Reference Master Data at TDA throughout the enterprise

Contributed to product development lifecycle activities / System Administration and architectural specifications, development, test plans and technical Run books documentation for Globalids Data Quality and EBX5 Master Data Management Platforms

Senior Applications Cash Management Administrator II

Responsibilities:

Designed and Produced Daily Processing Transactions using DataQuik Reporting capabilities for TDA Clients and Business areas using OnBase

Provided 24/7 Production support on a rotation basis for Cash Profile Application Software (FIS)

Worked with Change Management to schedule release and patches for the FIS system in PROD, HA and DR

Performed database analysis, configurations and packaged software deployment for Cash Management Technology System.

Options Clearing Corporation, Keller, TX Jun 2006 – May 2012

Software Configuration Specialist

Responsibilities:

Provided System Support to 52 complex environments made up of 7 platforms.

Planned enterprise-level, multi-tiered platform Software and Hardware deployments.

Conducted environment and database build-outs for Quality Assurance and testing efforts.

Provided enterprise support and managed baseline procedures required by release process.

Conceptualized and built Java/C++ and.NET applications for multiple development branches and Release candidates found in SVN (Version Control)

Transunion, LLC, Chicago, IL Feb 1998 – Dec 2005

Senior Programmer Analyst/Data & Reporting Administrator

Responsibilities:

Perform data integrity checks by scheduling jobs and stored procedures

Performed weekly maintenance and quarterly database backups for the Mobius View Direct Report Repositories in development, UAT and production

Compiled periodic status reports and administered systems to maintain security profiles

Responsible for backup of system, batch process, report distribution and EDI transmissions

Billing & Data Coordinator/Applications Systems Administrator

Responsibilities:

Served as Lead Developer in re-engineering efforts and collaborated with other developers to transfer data feeds from clients using manual ETL processing from ZOS DB2 tables to Oracle tables on UNIX platforms

Developed ad hoc reports and made modifications to support Billing, Invoicing and Accounts Payable Systems on the Mainframe

Analyzed and developed Stored procedures, COBOL & Easytrieve programs

Enhanced the quality of data-handling programs and utilities using SAS and File-AID on mainframes

Developed packages, procedures and functions using PL/SQL and PL/SQL Developer in an Oracle 8i environment

Maintained database operations, Autosys scheduling systems and application load balancers

BlueCross BlueShield of Illinois, Chicago, IL Dec 1997 – Jan 1998

Programmer Analyst - Corporate Financial Reporting Systems

Responsibilities:

Managed special projects while overseeing program specifications and coding procedures

Initiated and maintained applications for a Financial Sales Data Warehouse system

Translated business rules into technical requirements and re-engineering reporting systems

Communicated effectively with colleagues and mentored 4 entry-level DB2/SQL programmers

Contact this candidate