BI Data Architect Resume

TECHNICAL SKILLS:

Business Skills: Six Sigma Methodology, Dashboarding & Metrics, PMP trained, Marketing, Accounting, Operations Management, HR Management, Business Analyst, Data Analyst, Data Architect

Programming Languages: TSQL, Crystal Syntax, VB

Operating Systems: DOS, Windows/NT, OS/2, UNIX

Other Skills: Corporate Information Factory methodologies (Inmon), Dimensional datamart methods (Kimball), Technical Speaking, Technical Trainer, Working Knowledge of Spanish, Tech Writing, Software Instruction, Computer System Design, Computer Architecture, TCP/IPX networks, Relational Database Design, SQL Server and Network Administration, Database/GUI interface design

Software: SQL Server (admin/SQL/SSIS), Crystal Reports Designer, XCelsius, Report2Web, Sharepoint, Minitab, MS Access, MS Excel (including analysis toolpack), MS Word, Lotus 123, Lotus Notes

WORK EXPERIENCE:

Confidential

BI Data Architect

Responsibilities:

Moved into the BI team as a SME from prior business unit
Currently working in the DW SaaS initiative, using Big Data solutions - Hive
Primary developer for MRI (natl Market Rate index data used for apps like truckloadrate.com)
Primary focus on SQL Server, Hadoop with Hue/Hive/Ambari
Hive developer
DW Kimball design and wide tables
Hortonworks Confidential

Confidential, Chapel Hill, NC

Lead SQL Developer

Responsibilities:

Primary resource for SQL coding for BI outputs including SSRS and other internal reporting applications/metrics
Heavy TSQL coding and optimization - stored procedures, functions, triggers
Key player in Custom KPI designs for Professional Services group
Developed and implemented ETL (SSIS) solutions for internal/external clients
Assisted with DBA activities (code promotion, DB design, DBA backup)

Confidential, Raleigh, NC

Datawarehouse Developer

Responsibilities:

Primary resource for Confidential Datawarehouse
Developed, maintained, and supported Confidential DW components
SQL Server platform using SQL and Salesforce inputs/outputs.
Responsibilities include DW ETL (SSIS, SSAS) and usage such as SSRS reports

Confidential, Morrisville, NC

Senior Database Analyst/Developer

Responsibilities:

Senior SQL Server developer for Data Services group
Project Lead for SSIS conversion project
Leading design in new PSA (Personal Securities Administration) segment interfaces (Business Analyst role, Data Architect role, Developer)
Backup DBA
Responsibilities include data ETLS with 3rd party financial companies (interfacing with external clients, specs, status meetings, etc), client onboarding (manage projects to a deadline, work with client custom requests), database tuning/optimization, and Crystal reporting

Confidential, RTP, NC

Software Support Analyst

Responsibilities:

Lead report developer for Confidential Crystal Reports, XCelsius)
PM and BA roles for Siebel to MS CRM data migration
Multiple Six Sigma Black and Green belt level PM projects, including dashboarding, legacy and current data reporting consolidation, consolidated reporting, SLA-Finance reporting. Six Sigma focus around statistical dpmo for check accuracy, call center volume analytics.
Lead on Enterprise datawarehousing initiatives, including MDM activities - data normalization, ETLs (via SSIS), data consolidation, fact/attribute modeling, creation and design of datamarts (star/snowflake) for high volume high response querying. BA and Architect roles.
Implemented Confidential Reporting solutions in a “one stop shop” approach - focus on call center metrics reporting, with HR/Payroll minor topics
Performed cross application data processes with various 3rd party applications, including Lawson, Peoplesoft, SAP, Cybershift, and others.
Performed DBA role for internal Confidential IT group
Originated improvement projects including automated data health reporting, automated Interface Processing, Executive widgets, and proactive application issues reporting
Multiple Star Performer awards

Confidential, RTP, NC

Data Analyst

Responsibilities:

Lead reporting developer for Confidential ’s OnSite Picture division
Responsible for national development, support, testing, and publication of reporting for all internal groups via Crystal Reports and Report2Web with internal and external client interaction
Managed over 1000 real-time Crystal Reports
Migrated over 300 reports from Legacy systems, including Lawson and Powerbuilder

Confidential, Cary, NC

Switched Network Engineer

Responsibilities:

Supported Confidential domestic switches and international database routing
Trained Confidential group on international ticket procedures

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship