Analytical Engineer Resume
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.
