BUSINESS INTELLIGENCE ENGINEER Resume

SUMMARY:

Automated Reporting Ad - hoc / Self-Service Tools Interactive Dashboard Designs
Highly-organized and technically sophisticated IT specialist with 15+ years’ experience driving business growth and productivity using modern technologies and expert BI methods.
Talent for revealing opportunities and customizing solutions that align with corporate goals.
Collaborates with executive and IT business partners to troubleshoot issues and elevate user experiences that support business needs.
Outstanding communicator who translates complex technical data into valuable information for use in strategic planning, performance analysis, and business-critical decision making.
Owns and delegates planning, researching, analyzing, quality assurance (Q/A), testing, and deploying technical projects.
Champion end-to-end SSAS, SSRS, SSIS, and database development projects in OLTP/OLAP environments.

CORE COMPETENCIES:

Project Planning & Launch
Team Training & Coaching
Information Delivery Workflow
Research & Analysis
Design Project Life Cycle
Testing, Validating & Diagnosing
Facts & Dimension Tables
Documentation & Reporting
Functional & Technical Requirements

TECHNICAL SKILLS:

Operating Systems: Windows 98/00/03/XP/NT/Vista/7/10, Windows Server 2003, R2/2008, R2/2012

Enterprise Platforms: DEC, Digital UNIX and VMS, HP, IBM, AS400, RS6000, Stratus, VOS, Sun, Solaris, Tandem

Database Tools: MS SQL Server Management Studio (SSMS), SQL Profiler, Query Analyzer, Index Tuning Wizard, Tableau

GUI Tools: SQL Server Business Intelligence Development Studio, ER Studio, Visual Studio 2013/17

Applications: Microsoft Office, MS Access, MS Exchange, Tivoli/Formula, Peregrine Service Center, Active Directory (AD), WS FTP

Work Flow Tools: MS Visio, MS SharePoint

Languages: T-SQL, HTML/CSS

Source Control Tools: Team Foundation Server 2013

ETL Tools: SSIS, DTS, Import/Export Wizard

SQL Server Integration Services (SSIS) Components: Sequence Containers, Script, Loop Containers, Execute SQL/Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, Flat File Source and Destination, OLEDB Source and Destination, Data Transformations (Look Up, Multi-Cast, Script Components)

SQL Server Report Services Components: Sub, Drill-Down, Drill-Through, Parameterized, Cascading Parameter, Toggle, Chart, Gauge, Maps

SQL Server Analysis Services Components: Facts Measures Groups, Multiple Dimension Hierarchies, Dimensional Data Modeling, Cube Development

PROFESSIONAL EXPERIENCE:

BUSINESS INTELLIGENCE ENGINEER

Confidential

Responsibilities:

Create periodic, customized SSIS packages complete with SSRS modules and client dashboards to assist in important business and budgeting decisions.
Owns business models, data models, data sources, ETL tools, enterprise data warehouses, OLAP analyses, and reporting tools needed to add value to the BI environment.
Wrote SQL queries using MS SQL Server 2012/2014 to aggregate data such as premiums, tax costs per city, and exposures per county.
Utilized MS Visual Studio 2013 in order to create, implement and maintain a reporting suite of over 30+ statutory reports while also customizing many reports to meet individual client needs.
Formulated and documented the physical ETL process design based on business requirements and system specifications, including source to target mappings, transformations, lookups, aggregations and expressions.
Performed Data Profiling, Assessment, and Data Cleansing as required to meet data migration goals

SQL SERVER DEVELOPER & CONSULTANT

Confidential

Responsibilities:

Administered data backups, recovery, and database maintenance.
Applied Agile/SCRUM methodologies by hosting daily scrum meetings and bi-weekly sprints that achieved cohesive teamwork environments, open communications, and optimal productivity.

Confidential

SQL SSRS REPORT DEVELOPER

Responsibilities:

Developed a SSRS dashboard that tracked mortgage KPI metrics.
Linked muliple reports into one that eliminated repetition and duplication of data.
Utilized T-SQL to generate ad hoc reports and develop comprehensive storage procedures.

SQL SSIS ETL DEVELOPER

Confidential

Responsibilities:

Streamlined the transmission and duplication of database objects from one main server to corporate sub-servers using SSIS.
Analyzed data volumes and sources to assign task objects, connections, and workflows.

MIDRANGE / MIDFRAME SYSTEMS OPERATIONS ENGINEER

Confidential

Responsibilities:

Performed 1st and 2nd level helpdesk (Break/Fix) support in a large multi-vendor midrange and mainframe data center that housed varied enterprise networks, systems, and technical platforms.
Resolved issues using startup/shutdown procedures, checking hardware connectivity, and monitoring systems; scheduled routine data backups to allow for reimaging and recovery from critical failures. Documented troubleticket responses and solutions.
Recognized for superior performance, swift response, and resolution given when faced with major system defect that affected over 200 users.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship