We provide IT Staff Augmentation Services!

Data Systems Coordinator Resume

Washington, DC

SUMMARY:

  • Technically sophisticated and accomplishment professional with experience deploying data reporting and analysis solutions across diverse industries including federal and local government, education, legal, nonprofit, financial banking, forensics, public health and insurance.
  • Extensive knowledge pulling data from relational database backend such as SLQ Server and Oracle. Expertise working with SAP Crystal reports accessing data source through ODBC connection and create reports and visualization.
  • Exceptional ability to manage expectations of internal and external clients while lending expertise in data extraction, master data management, systems integration, and data warehouse infrastructure.
  • Demonstrate expertise working in multiple database environments, developing advanced SQL queries, and designing comprehensive reports. Committed to improving a team’s ability to collaborate and deliver excellent customer service while mentoring junior staff.
  • Skill in Database Design and Development, Data Flow Diagrams, Normalization, Report Automation, SQL Reporting, Requirements Analysis, Data Quality Assurance, Data Modeling, Data Warehousing, Web Intelligence, Data Analysis, Agile/Scrum, OLAP, OLTP, Multidimensional Databases, KPIs
  • Provide inspirational team leadership and counseling to subordinates that increases morale and raises performance and productivity levels. Strong decision - making skills, judgment, and outstanding initiative. Exceptional skill demonstrated when working under high pressure.
  • Extremely focused and motivated to achieve in a demanding environment that promotes teamwork but can identify and resolve issues independently. Known for exceptional service and completion rates.
  • Goal-oriented self-starter with highest levels of personal initiative, integrity, and work ethic.

TECHNICAL SKILLS:

  • Oracle
  • OBIEE
  • TOAD for MySQL
  • Oracle BI
  • Access
  • Excel
  • SAS
  • Business Objects
  • Tableau
  • Tableau Command Line
  • R Programming
  • T-SQL
  • Informatica
  • IBM Data Stage
  • TOAD for Oracle
  • SSRS/SSIS/SSAS
  • SQL Server
  • SAP Crystal Reports
  • PERL
  • Hive
  • Hadoop
  • HDFS
  • JusticeTrax LIMS
  • Active Directory
  • Salesforce

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Data Systems Coordinator

Responsibilities:

  • Work closely with the OSE to design and implement a new intervention targeted at increasing immunization compliance among schools and daycare centers
  • Help create report cards to be provided to principals and Licensed Childcare Development Center (LCDC) directors to report on their organization’s compliance rates relative to city average and top performing schools.
  • Manage accounts for users, groups and organizational units using Active Directory Users and Computers
  • Query databases and other data sources. Perform analysis of data sources and processes to ensure data integrity, completeness and accuracy. Create and maintain management and CDC reporting needs
  • Manage providers incidents, requests, etc. on Self Service Portal using Salesforce platform
  • Develop IT project plan identifying updates or improvements for the DC Immunization Information System
  • Develop a communication plan for stakeholders and users for the DC Immunization Information System
  • Help develop a Bidirectional Health Information Exchange to enhance immunization activities between EHR systems and the District of Columbia Immunization Information Systems
  • Work closely with PharmaWatch for setting up and monitoring sensors for the Vaccination for Children unit

Confidential, Chevy Chase, MD

Sr. Programmer Analyst II - Business Intelligence

Responsibilities:

  • Developed, analyzed, and deployed SSIS packages and SSRS reports using both Microsoft Visual and Management Studio.
  • Created, scheduled, and monitored various jobs running from multiple servers
  • Provided primary production support for all the jobs running in different frequencies on both sales, services, and reports servers.

Confidential, Vienna, VA

Sr. Business Analyst III

Responsibilities:

  • Helped manage and coordinate the organizational approach to DFS reporting requirements.
  • Developed and analyzed performance reports for management to have clear visibility of data stored in LIMS.
  • Worked closely with the PHL (Public Health Laboratory) division for collection and testing. Exposed and involved with both Actuate Reporting and Horizon System.
  • Developed and analyzed result worksheets for various units within the agency for data collections.
  • Developed SQL scripts to pull data from LIMS backend database for units to perform data analysis.
  • Developed ad hoc reports from scratch using both Crystal Reports and SQL Server and perform analysis.

Confidential, Franklin, TN

BI Independent Contractor

Responsibilities:

  • Worked with AAJ Technologies and Confidential Hyperion Reports Migration Project to migrate Legacy Hyperion Reports to SQL Server Reporting Services. Worked as a consultant to perform migration.

Confidential, Chevy Chase, MD

Sr. Programmer Analyst II - Business Intelligence

Responsibilities:

  • Worked closely with source systems owners, infrastructure team and DBAs to understand requirements such as access privileges, Firewall Request, and DDL changes.
  • Developed SQL scripts to capture data change, analyzed table sizes and data types from source systems.
  • Developed and analyzed data type mapping between source systems and Hive.
  • Worked closely with other analyst and BI developers during functional and integration testing.
  • Developed jobs and streams to load tables from source to target location using Spring XD.
  • Developed, analyzed, and deployed SSIS packages using both Microsoft Visual and Management Studio.
  • Primary production support for jobs running in different frequencies on both sales, services, and reports servers.
  • Assisted with server migration by performing package inventory, tables, and server connection set ups.
  • Migrated Legacy Hyperion Reports into SSRS to improve and streamline the company’s reporting needs.

Confidential, Binghamton, NY

Business Intelligence Consultant

  • Fulfilled the business objects development needs for summer camp and performed day to day admin task using Crystal Reports and SQL Server 2008.
  • Worked very closely with the IT Director to develop strategy and make recommendations for reporting tools such as Business Objects and OBIEE.

Confidential, Arlington, VA

Business Intelligence Consultant

Responsibilities:

  • Performed assessment of the Financial Management Information Systems and interfacing systems to help develop a holistic and actionable strategy for the US Senate.
  • Held FMIS systems overview meetings and strategy sessions with system leaders.
  • Collected relevant FMIS system documentation from client’s repository.
  • Identified potential interview areas and questions for the questionnaire.
  • Brainstormed on the initial diagrammatic representation of the current system architecture.
  • Assisted in the design, review and refinement of the initial Current State Assessment for client review.
  • Carried out further analysis of the US Senate’s current FMIS Data Dictionary to determine the current optimization potential using Enterprise Data Discovery tool.
  • Developed and analyzed BI reports using Web Intelligence and Business Objects 4.0 for client.
  • Developed universes and deployed to secured repository for Web Intelligence reporting needs using (Information Design Tool) IDT and BI Launch Pad.

Confidential, Washington, DC

BI Report Writer, Office of Data and Strategy

Responsibilities:

  • Developed comprehensive ad hoc reports from scratch, using Web Intelligence, SQL, SSRS, SAP Business Objects, TOAD for Oracle, Oracle SQL, Developer and TOAD for MySQL;
  • Identified and documented system/process specifications for our data reporting tool; Created and maintained data dictionary Marts within the DW; Created diagrams of data flow processes within the Data Warehouse.
  • Developed universes and deployed to secured repository for Web Intelligence reporting and Dashboard
  • Developed packages and cubes using both SSIS and SSAS as reporting tools.
  • Developed and maintained a self-service reporting tool which reduced the total number of ad hoc reports significantly.

Confidential, Vienna, VA

Business Analyst (Contractor)

Responsibilities:

  • Conducted and participated in the analysis of business processes and functional requirements and in the preparation of developing a data reporting tool.
  • Oversaw and maintained all automated reports, using Crystal Reports and Business Intelligence.

Confidential, Rockville, Maryland

Data Analyst

Responsibilities:

  • Generated and managed automated reports which ran daily, weekly and monthly, using Business Objects, Crystal Reports Distribution and TOAD for data analyst.
  • Cooperated with Analytical team to create Daily Metrics Report for managers using both SQL and TOAD for Data Analyst for daily tracking of collections, legal activities, and Call Center data.
  • Developed and maintained ETL packages and analysis using both SSIS and SSAS tools.
  • Converted all Crystal Reports to Oracle SQL scripts to significantly reduce reporting issues.

Hire Now