Seeking an I.T. Operations Analyst to optimize IT processes, Data Analysis, SQL, Oracle and SQL Server and MySQL Databases, Data Warehousing, ETL, Software development, Computer Repair, Communication and Customer Service.
This is a contract to hire role with one of Sacramento’s Best Places to Work.
Work with developers, database team and IT infrastructure team to deliver IT services to the organization and empower business personnel to make informed decisions.
Communicate with outside vendors and business partners to resolve IT related issues. Monitored and administered overall IT Operations such as IT processes, IT tickets and batch jobs, and ensured that all IT processes are in compliance with HIPAA law.
Create IT documentations, flowcharts, diagrams and workflow documents. Administered Managed File Transfer (MFT) processes. Perform file encryption/decryption using PGP techniques. Performed Data Profiling, Parsing, cleansing, and mapping for various structured/unstructured data and resolved data issues. Perform Data Analysis, data conversion, and created ad-hoc reports with data visualization and Pivot Tables.
Process EDI files such as 837 files, 834 files, and troubleshot errors in these files. Worked with EDI tools such as Liaison (Softshare) ECS, Delta and EDI Notepad. Load large volume of data files into database tables. Perform Data warehousing and run SQL queries against Oracle and SQL Server database tables.
Perform Extract Transform and Load (ETL) processes utilizing Informatica, SQL Navigator, and Excel. Performed Backup and restore of SQL Server database files.
Develop Microsoft Access interface application using Visual Basic and macros. Participated in daily sprint meetings as an Agile-Scrum team member.