We provide IT Staff Augmentation Services!

Analytical Engineer Resume

0/5 (Submit Your Rating)

SUMMARY:

  • 4 Years as analytics engineer on a team to design and implement Alteryx workflow solutions to simplify Confidential data preparation activities with Tax department. The goal is to provide a comprehensive analytics solution that embraces the data blending of Alteryx and merges the outputs into a dashboarding system like Tableau.
  • Database administrator with experience across large - scale enterprise systems ranging from Sony Electronic’s global inventory data warehouse to Confidential Communications’ tax data warehouse as well as numerous OTP systems. Managing both in-house and third-party applications, and logical and physical modeling. Expert in back-up recovery, pro-active monitoring and tuning, optimization and sizing. Partnered with developers to design relational models to optimize database performance.

TECHNICAL SKILLS:

Technology and Tools: Alteryx Oracle Microsoft SQL Server DB2 CICS IDMS SQL - BackTrack Quest products Sybase EMC Storage UNIX DOS Installing, configuring, customizing Alteryx Server. Designing Alteryx workflows. Installing, configuring, sizing, and maintaining database servers: Oracle 12c,11G, 10G (most Oracle versions since 6), OFA, Partitioning, Parallel Processing, interMedia, OEM, RMAN, DataPump Microsoft SQL Server 2008,2012,2014,2016 SSIS, Replication, Partitioning, DBA Management Studio Supporting a variety of enterprise hardware systems: Windows Server 2019,2016,2012 IBM P595 IBM RS/6000 IBM SP/2 SUN Solaris IBM PC & Compatible

PROFESSIONAL EXPERIENCE:

Analytical Engineer

Confidential

Responsibilities:

  • Responsible for Alteryx Server installation, upgrades, configuration, backups ( 2018.x-2021.4)
  • Responsible for Gallery setup, configuration, creating Collections, creating Data connections with SQL Server, Teradata, Oracle, Alteryx DB, Excel. Responsible for IN-Db connections setup, User security.
  • Assisted in / helping users with Alteryx Designer, Developing workflows, publishing to the Gallery, Establishing correct data connections, Tuning
  • Created in-depth Alteryx tax Workflows, Analytical Apps, Chained App processes.

Database Administrator

Confidential

Responsibilities:

  • Serving as an Oracle DBA in Confidential Tax IT Group. Responsible for multiple Oracle 12c environments, running on Windows Server 2016 .
  • Responsibilities include Oracle software installation, version upgrades, security patches, user security, backup and recovery, database proactive monitoring and performance tuning.
  • Serving as Microsoft SQL Server DBA, Responsible for multiple SQLServer 2008/2012/2014/2016 environments.
  • Responsibilities include SQL Server installation, configuration, upgrades, security patches, user security, backup and recovery, database monitoring, extensive use of Management Studio.
  • Installed and configured SSIS Server, extensive experience with Microsoft Visual Studio and ETL Packages, SQL Server Job Agent.
  • Serving as Data Architect in Master Data Consolidation project . Project includes 7 systems feeding the Tax Data Warehouse and sharing the Data in different forms . Responsible for establishing process of mapping and transformations.

Senior Database Administrator

Confidential

Responsibilities:

  • Served as an Oracle / DB2 DBA in a group that was developed to provide a core team of expert technicians, which would provide the experience to effectively consolidate over 5 existing GL systems into one Corporate GL system.

Manager Database Administration Group, Senior Oracle DBA

Confidential

Responsibilities:

  • Served as a leader of the Corporate Unix and Database Administration CUDA ( Corporate Unix and Database Administration ) group.
  • Responsible for completing the process of consolidation of two parts of the group EAST & West.

We'd love your feedback!