Informatics Data Analyst Resume
5.00/5 (Submit Your Rating)
TECHNICAL SKILLS
- Oracle SQL
- Oracle PL/SQL
- Shell Scripting
- R
- AWS
- MS Office suite
- MicroStrategy
- Oracle BI
- TOAD
- SQL Developer
- SAS Data Integration Studio
- ER diagram
- Process Flow diagram
PROFESSIONAL EXPERIENCE
Confidential
Informatics Data Analyst
Responsibilities:
- Work with clinical research and quality data sets to help improve clinical care, population health, clinical research, and departmental operations.
- Write SQL, PL/SQL and other programming languages to create data report, and to perform maintained extract, transform, and load (ETL) tasks as requested and ensure the deliverables meet customer’s expectations.
- Design, develop, implement and maintain data warehouse and data mart; ensure data accuracy.
- Implement solutions to address root causes of data issues; provide ongoing maintenance and support to database objects, document and communicate database activities to stakeholders
Confidential
SAS Data Integration, Quality and Integrity Analyst
Responsibilities:
- Constructed and modified ETL routines in a centralized highly dimensional data warehouse.
- Integrated data using SAS Data Integration Studio and PL/SQL.
- Analyzed data quality and integrity issues in the KSU data warehouse with data profiling tools.
- Provided relational and dimensional data modeling and solutions to meet business requirements in the areas of enrollment services, retention, graduation, and scheduling/facilities optimization.
IT Application Support Team Lead
ConfidentialResponsibilities:
- Supervised and led Application Development Team in all phases of Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance.
- Supported intranet web applications for students, faculty and staff on campus; managed production issues via Track - it ticketing system.
- Developed packages, triggers, functions, stored procedures using PL/SQL in Ellucian Banner Student Information System.
- Created and maintained application design documentation; provided regular team update and report to higher management.