Etl/oracle Developer Resume
3.00/5 (Submit Your Rating)
OBJECTIVE
- To obtain a position within a technology - driven company where I can utilize my experience to enhance the company’s overall success.
TECHNICAL SKILLS
- Advanced Microsoft Excel Skills
- Data Blending & Database Management
- Mac, Linux and PC Experience
- Tableau Reporting
- Process Automation Alteryx Designer Proficiency
- Proficient in multiple versions of SQL Predictive Analytics Experience
- Salesforce API experience Advanced REGEX Skills
- Geospatial Analytics Experience Report Dashboarding
- Familiar with Python, Ruby, Unix terminal, HTML, CSS, Windows Command Line, VBA
PROFESSIONAL EXPERIENCE
Confidential
ETL/Oracle Developer
Responsibilities:
- Alteryx Development
- Oracle SQL query development
- Apache Impala Development
- Customer Tracking through Experian Data
- Geospatial analytics utilizing CASS data
- Agile/Scrum
- Client Facing Documentation writing
- Data Prep for Qlik Development
- Testing and Data Validation
Confidential
Senior Architect
Responsibilities:
- Analytical Process Development using Alteryx
- Oracle SQL querying
- Handled International Tax data
- Oversaw the automation of previously manual processes
- Trained employees on coding SQL queries in an Oracle environment
- Trained employees on Data blending and process development
Confidential
Business Intelligence Analyst
Responsibilities:
- Analytical Process Development using Alteryx
- Utilizing a process scheduler built and maintained by our team
- Maintaining a windows server virtual machine dedicated to process scheduling.
- SQL querying and database design.
- Database development and Stored Procedures using Microsoft SQL Server - TSQL
- Data Querying using IBM Data Studio from a database of over 20 million customers and hundreds of tables - DB2SQL
- Built and implemented large scale data auditing processes which evaluated congruency between government databases and our client’s data.
- Built and implemented PDF data extraction tool that saved an estimated 1000 hours of labor a year.
- Built database to bring out of house operations into the organization saving the company the yearly costs of having a cloud server.
- Assisted in the transition from a Legacy database to an updated datamart, including replicating old processes into new systems.
- Received Next Generation Champion Award (2018) for my work in automation and creating a system that audited accuracy across multiple databases.
Confidential
Data Manager
Responsibilities:
- Import, manage, modify, and export databases in agreement with the United States Postal Service formats and regulations
- Extract, Transform, Load (ETL)
- Operating within a Borland Database
- Created targeted mailing lists using customer demographics
