SUMMARY

• Technically sophisticated and accomplishment professional with experience deploying data reporting and analysis solutions across diverse industries including the federal government, education, legal, nonprofit, insurance forensics, and public health.
• 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.
• Demonstrated 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.

CORE COMPETENCIES

• Database Design/Development
• Requirements Analysts
• Report Automation
• Data Warehouse Infrastructure
• Business Intelligence
• Agile/Scrum Methodologies
• Project Management
• Data Management and Assessment

TECHNICAL SKILLS

Analytical and Process: Database Design and Development, Data Flow Diagrams, Normalization, Report Automation, SQL Reporting, Requirements Analysis, SAP Business Objects Analysis, Data Quality Assurance, Data Modeling, ER Studio, Data Warehousing, MDM, Web Intelligence, TOAD for Data Analyst, Agile/Scrum, OLAP, OLTP, Multidimensional Databases, KPIs, Tableau

Software Applications and Programming: Oracle, OBIEE, TOAD for MySQL, Oracle BI, Access, JavaScript, Business Objects, Shell Scripting, QuickBase, T - SQL, Informatica, IBM Data Stage, TOAD for Oracle, SSRS/SSIS/SSAS, SQL Server, SAP Crystal Reports, PERL, C#, Hive, Hadoop, HDFS

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Sr. Business Intelligence Analyst

Responsibilities:

• Work closely with the OSE to design and implement a new intervention targeted at increasing immunization compliance among schools and daycare centers
• Create report cards for principals and Licensed Childcare Development Center (LCDC) directors to report on their organization’s compliance rates relative to city average and top performing schools using Tableau
• 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 tasks and updates for the DC Immunization Information System
• Work closely with vendor for setting up and monitoring sensors for the Vaccination for Children unit

Confidential, Chevy Chase, MD

Sr. Business Intelligence Analyst

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, Chevy Vienna, VA

Sr. Business Intelligence Analyst

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, Chevy Chase, MD

Sr. Business Intelligence Analyst

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
• Reviewed and analyzed system documentation to identify data integrity issues
• 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
• Created, scheduled and monitored various jobs running from multiple servers
• Primary production support for all the jobs running in different frequencies on both sales, services and reports servers

Confidential, Arlington, Virginia

Business Intelligence Consultant

Responsibilities:

• 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
• 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
• Trained and mentored junior analyst and developers

Confidential, Washington, DC

BI Report Writer

Responsibilities:

• 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
• Worked closely with SME’s and analyst to ensure completeness and clarity of the requirements provided
• Perform gap analysis on the data and data sets being pulled from the back end database

Confidential, Rockville, Maryland

Data Analyst

Responsibilities:

• 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

Confidential, Washington, DC

Database Associate

Responsibilities:

• Spearheaded administration and support of event management systems, providing registration reporting across global network of over 500 centers, foundation, and student organization
• Designed and developed reports from scratch using SAP Crystal Reports, Business Objects and SQL