TECHNICAL SKILLS:

Ab Initio Data Integration Suite

MS Office Suite

Abra HR (HRIS)

MS SQL Server Enterprise Manager

Agile/Scrum Project Management Methodology

MS SQL Server Management Studio

IBM IAA/IIW (Enterprise Data Warehouse)

MS Team Foundation Server (TFS)

Confluence Team Collaboration

MS Visio

Crystal Reports

MS Visual Basic

DataStage ETL

Oracle SQL Developer

Embarcadero ER Studio

Power Designer Data Modeler

ERWin Data Modeler

SharePoint Document Management System

Hyperion BRIO Explorer

Trillium Data Discovery

IBM Cognos Reporting

XML (ACORD and custom)

Informatica ETL

SDLC Project Management Methodology

JIRA Issue/Project Tracking

WORK EXPERIENCE:

Senior Data Architect / Data Engineer (Information Technology)

Confidential, Sunrise, FL

Responsibilities:

• Created accurate, extensible and flexible data models
• Interacted with business partners to share and direct architecture practices that affected business solutions
• Identified and analyzed data discrepancies and worked with stakeholders to ensure data consistency
• Researched data architecture technology industry trends

Senior Data and Research Analyst

Confidential, Boca Raton, FL

Responsibilities:

• Collected, maintained and interpreted statistics
• Investigated data issues and identified improvement opportunities
• Researched and identified patterns, errors and inconsistencies in the data
• Monitored and verified data integrity
• Designed, implemented and QA reviewed Business Intelligence/ Data Integration projects

Business Analyst / Project Coordinator

Confidential, Boca Raton, FL

Responsibilities:

• Managed Software Development and Support teams to deliver on Client reporting requirements
• Coordinated work efforts of geographically distributed teams
• Analyzed complex cross functional business processes and defined integrated requirements
• Drove definition, testing, training, and implementation of functional requirements
• Promoted adoption of designed processes and solutions with stakeholders

Senior Business Intelligence Business Analyst (Project Management Office)

Confidential, Juno Beach, FL

Responsibilities:

• Led Data Architecture and Business Intelligence teams in designing optimum data warehousing and business intelligence information delivery solutions; from legacy source systems to cutting edge reporting and analytics
• Collaborated with business partners to establish desirable and effective data presentations
• Constructed diagrams of as - is technical landscape that showed previously unknown redundancy and conflicts
• Built trusted relationships with stakeholders to ensure open, honest and transparent lines of communication

Business Intelligence Business Analyst (Risk Management)

Confidential, Omaha, NE

Responsibilities:

• Core team member that planned, designed, developed, tested, implemented and maintained new Data Warehouse and Business Intelligence architecture and programs
• Acted as project manager (scrum leader) to help facilitate software development in an Agile environment
• Promoted metadata management principles to ensure data control, consistency and correctness

Senior Data Analyst

Confidential, Minneapolis, MN

Responsibilities:

• Performed source-to-target mapping for dimensional and normalized database structures for new data program
• Worked closely with data modelers, business analysts, and developers, serving as the subject matter expert
• Actively participated in data validation during QA activities
• Acted as team representative for data model review sessions

Lead Data Analyst (Strategy and Technology)

Confidential, Madison, WI

Responsibilities:

• Collaboratively planned, designed, and implemented best practice architecture
• Planned and designed overall data management program
• Planned and designed data quality assessment program (DQA) to profile, cleanse, and integrate data

Data Analyst (Information Services)

Confidential, Omaha, NE

Responsibilities:

• Designed logical/conceptual data models and worked with data warehouse personnel to establish loading protocols and physical databases - both normalized and dimensional structures
• Authored technical specification documents used by various project stakeholders
• Performed and documented source-to-target maps including business rules, data rules, and ETL specifications

Data Analyst

Confidential, Omaha, NE

Responsibilities:

• Co-produced data profiling, cleansing, and integration process for large-scale data warehouse project
• Led small to large project(s) and group(s) to ensure successful communication and project completion
• Designed data models to ensure proper collection, integration, and reporting of business information
• Performed source data analysis (SDA) including source-to-target mapping and data discovery

Senior Decision Support Analyst (Business Intelligence)

Confidential, Omaha, NE

Responsibilities:

• Worked with third party administrator(s) (TPA) to ensure successful data transmission
• Created and executed test scripts - including regression analyses - to validate data quality and resolve defects
• Provided data mart platform(s) for customer analytics

Business Data Analyst (Marketing)

Confidential, Omaha, NE

Responsibilities:

• Acted as liaison between business and IS departments to satisfy business needs
• Gathered and documented business requirements
• Provided project management
• Provided training where needed
• Created queries/reports in response to corporate officer requests
• Facilitated meetings with business and technical teammates