Systems Data Analyst/Data Warehouse Analyst Resume Omaha, NE - Hire IT People

SUMMARY:

Experienced Data Warehouse Analyst with a history of developing database solutions. Successfully supported team members, end users, and management, and has consistently been distinguished with awards recognizing timely and outstanding contributions to the team and company at Confidential .

TECNICAL SKILLS:

Python, SQL Dialects (Oracle, PostgreSQL, Microsoft SQL, Informix SQL), PL/SQL, Perl, Bourne / Korn Shell, Oracle 8i - 11g, SQL Plus, SQL Loader, Oracle Business Intelligence, Oracle Data Integrator, IBM DataStage, SSMS (Microsoft SQL Server Management Studio), Linux, Solaris, Informix, Greenplum, Postgres, regular expressions / regex, ssh

EXPERIENCE:

Confidential, Omaha, NE

Systems Data Analyst/Data Warehouse Analyst

Responsibilities:

As the senior member of the Business Intelligence team, was responsible for vetting new database tools and techniques to improve ETL and reporting performance and operational response time
Served as the Lead Administrator, responsible for adopting and operating the Oracle Business Intelligence Suite
Worked extensively with IBM DataStage to manage data workflow between data warehouses and application databases
Participated in project planning and data warehouse modeling to set up an optimal system for quick and accurate data retrieval per business requirements, closely working with client teams
Verified data integrity of production database contents using SQL*Plus & SQL Server Management Studio
Responsible for creating daily reports which assisted client managers and department heads in monitoring our clients’ actual versus expected usage level for the month, quarter, and year.
Authored numerous pieces of software to automate data flows from a wide variety of sources into internal resources
Wrote PL/SQL stored procedures to determine client locale information to be used in daily ETL, which was needed to comply with Confidential regulations on client communications
Regularly updated the internal documentation on current procedures, and authored finalized documentation which was released and distributed for internal consumption and training
Continuously tuned SQL used in ETL to increase reliability and improve success rate

Confidential, Columbus, OH

Contact Data Analyst/Systems Data Analyst

Responsibilities:

Developed solutions in Perl to retrieve data from a variety of clients’ servers using LDAP, (s)FTP, HTTP(S), and more, then standardize the data, producing local files for ingestion to the staging database
Developed reliable back - up and encryption scripts to keep the client’s data secure and quickly recoverable
Set up and maintained the Database team’s wiki space and ticketing system to keep essential information current and centrally located using Atlassian products Confluence and Jira.
Utilized PGP and OpenSSL to encrypt and decrypt client data
Updated Perl-based internal billing application to add new products and to improve scalability
Manually monitored multiple Oracle 10g resources and services to prevent errors and downtime until Infrastructure team implemented automated monitoring
Frequently called upon to debug, modify, or extend a wide array of software (typically Perl, occasionally C++)
Used SQL*Plus to update and correct billing filters under direction of DBA
Located and resolved billing issues and provided suggestions on how to resolve future issues
Configured Microsoft Access on Windows desktops to connect to internal database using Oracle’s ODBC drivers so client managers could verify clients’ data

Confidential , Dublin, OH

Front Line Analyst

Responsibilities:

Provided troubleshooting and telephone support to company employees regarding a variety of technical issues
Performed remote administration on end user PCs to correct various system and software settings
During performance reviews, consistently received exemplary scores with additional commendation for outstanding troubleshooting and focus in the performance of duties

We provide IT Staff Augmentation Services!

Systems Data Analyst/data Warehouse Analyst Resume

Omaha, NE

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship