We provide IT Staff Augmentation Services!

Data Analyst Consultant Resume

4.00/5 (Submit Your Rating)

LlC

Hire Now

OBJECTIVE: Seeking a challenging position in an IT department as a data analyst.

TECHNICAL SKILLS
Databases: SQL Server 2000/2005, Access 2003/2007

Applications: Microsoft Office 2003/2007 (Word, Excel, Access, PowerPoint)

Languages: T-SQL; Perl; XSLT; XML
Operating systems: Windows Server NT/2000/2003; Windows XP; Windows Vista


PROFESSIONAL EXPERIENCE: Data Analyst Consultant, Confidential,LLC. November 2008–Present
  • Converted proprietary data files using the XML, XSLT data conversion engine
  • Translated business rules into new XML and XSL scripts
  • Wrote and edited Perl, XSLT scripts and XML
  • Maintained data mapping databases in SQL, Access, Excel and other RDBMS
  • Remedied data anomalies
  • Worked closely with the administration team to verify data integrity
Senior Software Programmer, Confidential,July 2000–September 2008
  • Database development and implementation using SQL Server 2000/2005
    • Created tables, triggers, views, and stored procedures, indexes and DTS, SSIS packages
    • Designed data marts for different hospital departments such as payroll, finance, clinical and material management
    • Debugged and modified database objects for old applications
    • Planned and created SQL roles, logins and security on databases
    • Worked on SQL Replication, Physical and Logical database design
    • Used SQL profiler to optimize the stored procedure and server for best performance
    • Migrated SQL server 2000 to 2005 for existing databases
    • Designed and implemented complex data transformations using SSIS
    • Scheduled database jobs and SSIS packages through SQL server agent
    • Developed ETL for loading data into the data warehouse, including data acquisition, transformation, presentation and administration components rolled into one total warehousing and decision support solution
  • Database Integration Analysis between Meditech and Data Warehouse
    • Performed analysis of physical data model for ETL mapping and designed ETL process flow to get data from various sources
    • Updated ETL process after Meditech upgrades; wrote upgrade and exception fix reports; provided consulting on Meditech application to ensure data errors were handled properly
  • Information System Support
    • Provided 24/7 support on system outage or end-user application issues for a variety of clients within the health care industry

Interactive Video Technician, The University of Texas – Tyler, September 1996–May 2000

  • Operated the audio system for off-campus students
  • Maintained TVs and video cameras for professors’ lectures

EDUCATION
B.S. in Computer Information Systems.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship