Business Intelligence Architect Resume

TECHNICAL SKILLS

Operating Systems: Windows 98, NT, XP, 2000, 2003, 2008

Databases: MS Access, SQL Server 7, 2000, 2005, 2008 & 2012 Oracle 8i & 9i, DB2

Software: SQL Server, Integration Services, Analysis Services (Dim & Tab), Reporting Services, PerformancePoint Services, PowerPivot Power View Power BI Business Object Data Integrator, Business Scorecard Manager, SharePoint Portal, Microsoft Office, Visio, Project

Programming Languages: C++, Visual Basic, Java, T - SQL, PL-SQL, HTML, ASP.NET UMMARY

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Architect

Responsibilities:

Administer and Support all Confidential Business Intelligence Applications (ETL, Data Warehouse, Reporting, SSAS Cube and Tabular and Power BI)
Architected, designed and built a data integration application using SSIS for data migration between Great Plains and Warehouse Management System (AGI)
Built an ETL application to load Confidential ’s Enterprise Data Warehouse
Designed and Implemented Confidential ’s Enterprise Data Warehouse to support data analysis applications
Designed and implemented data analysis application using Analysis Services (OLAP Cubes, Tabular Model, Key Performance Indicators)
Designed Pivot tables in Excel for deep data analysis
Designed Power BI Dashboards
Designed and implemented decision support applications using Reporting Services, Power View and Performance Point (dashboard, scorecards, reports, charts) hosted on SharePoint
Provide technical support for logistic application VISISHIP
Provide technical support for forecasting application DSX (Demand Solutions)
Liaise the modification and configuration of Great Plains modules between end users and development team.
Designed and implemented a proof of concept with iDashboards to show real time and active chocolate manufacturing process details on LCD screens.

Confidential

Sr. Business Intelligence Developer

Responsibilities:

Migrated Data Warehouse from SQL server 2000 to 2008
Migrated and redesigned DTS packages to SSIS packages
Designed and Implemented data mart to support data analysis applications
Designed and implemented data analysis application using Analysis Services (OLAP Cubes, Key Performance Indicators)
Implemented a date tool that provides date comparison and aggregation for any measure in the cube (YTD, MTD, Previous Year, Last Six Months…)
Implemented Dynamic Security on Dimensions
Designed and implemented decision support applications using Reporting Services and Performance Point (dashboard, scorecards, reports, charts)
Administered, maintained and supported Data warehouse and cube
Performed query performance tuning SQL Profiler, Execution Plans and Database Tuning Advisor.
Participated in requirement gathering sessions
Translated business process into functional specifications
Provided documentation for all objects and applications created

Confidential

Business Intelligence Consultant

Responsibilities:

Designed and implemented data analysis application using Analysis Services (OLAP Cubes, Key Performance Indicators)
Implemented E.T.L. processes using Integration Services packages
Identified and troubleshot slow running reports using SQL Profiler and applicable tables from ReportServer database.

Confidential

Technical Consultant/Business Intelligence Developer

Responsibilities:

Translated business processes into functional specifications
Designed and implemented business intelligence applications (Data Warehouse, Data Marts, Reports, Scorecards)
Implemented E.T.L. processes using DTS and Integration Services packages
Designed and implemented data analysis application using Analysis Services (OLAP Cubes, Key Performance Indicators)
Designed and implemented decision support applications using Reporting Services and Performance Point (dashboard, scorecards, reports, charts, Pivot Tables)

Confidential

Technical Support Associate

Responsibilities:

Installed and configured software
Upgraded Exchange Server 5.5 to 2003

Confidential

Database Specialist

Responsibilities:

Generated reports for management using Transact - SQL
Managed database security
Involved in client server application development using Visual Basic

Confidential

Database Analyst

Responsibilities:

Performed daily backup and monitored/tuned database performance
Managed database security
Generated reports for management using Transact-SQL

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship