Data Warehouse Analyst
CurrentDesigned, developed, and debugged hundreds of one-time data feeds and reports.Documented and trained others to populate and support the reports, infrastructure, and data warehouse.Assisted architecture of new enterprise data warehouse. Lead team for Clinical Data requirements and reportsAdvised BI team using nursing qualificationsDesigned, developed, and administered hundreds of corporate reports allowing any report to be populated based on any rules at any time… Show more Designed, developed, and debugged hundreds of one-time data feeds and reports.Documented and trained others to populate and support the reports, infrastructure, and data warehouse.Assisted architecture of new enterprise data warehouse. Lead team for Clinical Data requirements and reportsAdvised BI team using nursing qualificationsDesigned, developed, and administered hundreds of corporate reports allowing any report to be populated based on any rules at any time past.Designed complex queries within various tools, including T-SQL, PL/SQL, and InformaticaExperienced with data warehouse concepts, capabilities and limitationsExpert knowledge of relational and dimensional databases especially for warehousing and business intelligenceProvided adhoc data subsets to meet critical business needs, including those used in lawsuits and governmental investigationsMonitored, understood, and reported data quality levels and developed ETLs to proactively record the errors and correct the data quality issuesConsulted with corporate leadership to determine allowable variances for reportsModeled data processes (conceptual and logical) for multiple projects using Erwin and VisioMonitored and corrected system and ETL failures in T-SQL, Informatica, and PL/SQL Provided leadership for data requirements of a major data mergerCreated and populated meta-data to allow for increased functionality of reports and logs Show less
