AddThis Social Bookmark Button
Pierre Sula ( Available )
Cedar Falls, Iowa - 50613 USA
Expertise :OLAP, ETL, MDX
Job Type :
Contract - 1099,Corp-to-Corp
Position :Management Occupations, Business and Financial Operations, Computer and Mathematical

Resume
 
Summary




MBA and BS
in Computer Sciences-Math
Over 15 years of experience in IT
Expert level for business dimensional full lifecycle Development and Implementation Project planning, Business requirements definition, Multidimensional modeling, ETL design, Data Warehouse and cubes development, Multidimensional expressions-MDX and for delivering business intelligence with Microsoft technologies Sql Server 20002005/2008, SSIS, SSAS, SSRS, PROCLARITY, SHAREPOINT.
Very strong in numerical analysis and have lead teams in large and complex data warehouse projects in MS platform.
Graduate course work in International Business and Financial Management.
Experience on Telecommunication, Insurance, Health Care industries
Very effective in knowledge transfer and technical support
Asset to any BI project.
US citizen.


Employment

February, 2009 -  Present
Senior BI Architect

GAF Inc Wayne NJ
Business Intelligence Architecture and development Sql 2008, SSAS, SSIS, SSRS, MOSS 2007, PROCLARITY 6.3 using the full SDLC.
Project planning for OLAP and BI Front-End
Multidimensional Models and Business Intelligence development Star Schema, conformed dimensions, Cubes design
Building standard reports using MS SSRS 2008
Building analytical report using MS Proclarity 6.3 and Performance Point
Dashboard KPIs
Integrating Excel into Office Sharepoint 2007 Excel Services
Integrating Proclarity views into Office Sharepoint 2007
Integrating MS SSRS into MS Sharepoint 2007
SSAS cube security
Implementing SSAS stored procedures VB, #C for security
Knowledge transfer to client employees

Sept2008 - January 2009 : Senior BI Architect, Integrys Energy Services Inc, De Pere WI
Data Warehouse Architecture : Sql 2005/2008 platform SSAS, SSIS, SSRS
Full Life-Cycle Development and Implementation for Date warehouse and Business Intelligence
Project Planning, Business requirements, Technology assessment, Architecture design
ETL design and development using MS SSIS
Building Dimentional Models Star Schema, snowflake, conformed dimensions
Converting ER diagram to Relational tables using MS Visio
Data Staging, Operational Data Store, Data Marts
OLAP Cubes deployment
Building MS SSRS report from OLAP Datasources
Integrating SSRS and Proclarity views into MOSS 2003


March, 2008 -  September, 2008
SALEM ASSOCIATE

, Inc Des Moines IA
Business Intelligence application development in Windows 2003, Sql Server 2005/2008 SSIS, SSAS, SSRS environment.
Dimensional modeling : denormalization Star schema ; Snowflaking
Expressing logics as facts Measures stored in a Cube
Using MDX for calculated measures.
Using Action, T-SQL and SSAS stored procedures for displaying details data.
ETL packages using MS SSIS

Write instructional document for training
BI client tools : SMS, Report Portal, MS Proclarity, Performance Point, MS Excel


February, 2007 -  March, 2008
Senior BI Architect

AVANCED SYSTEM DESIGNS/ Microsoft
BI development and Consultancy for CAT Parts.
BI development for State Farm Insurance
BI full lifecycle implementation SDLC approach by Kimball
Project planning, Business requirement definitions, Technology assessment
Business Intelligence application development in Windows 2003, Sql Server 2005 SSIS, SSAS, SSRS environment.
Dimensional modeling : Denormalization Star schema ; Snowflaking
Building UDM Unified Dimensional Model
Multidimensional databases reporting Cube using XMLA and MDX, MOLAP storage.
ETL packages using MS SSIS
Application Integration : Hyperion SSAS for Property and Casualty Insurance
Data modeling ER diagram/logical model/ Physical model using MS Visio and ERWin

Provide training to customers ZIEGLER, Minneapolis
Deployment and maintenance
BI client tools : Proclarity, Report Portal, Performance Point, MS Excel
Provide training/ Knowledge transfer


October, 2005 -  February, 2007
DATAWAREHOUSE-SQL-OLAP developer

SPRINT Engineering Campus Kansas City
Technology assessment and Database Management.
Database application development in a Windows 2003 and Sql SERVER 2005 SSIS, SSAS environment.
Cube building MOLAP, ROLAP and HOLAP Storage
BI development and multidimensional databases reporting Cube using XMLA and MDX.
Implementing SSAS stored procedures VB.net
Partitioning, processing and deploying Cubes > 2 billions of rows in multiples facts tables
Dimensional modeling and Cube design of complex cubes Correlation analysis
Job scheduling ; backup and restoring cubes.
ETL tasks using SSIS
Data modeling ER diagrams, Logical design/physical using MS Visio.
Performance monitoring, tuning and optimization using Sql profiler and System Monitor
Job scheduling
Installation and troubleshooting Sql 2000 and MS SQL2005 32 - bit and 64 - bit platforms, Standard and Enterprise Edition

Performance monitoring and troubleshooting.
Client tool : Proclarity, Panorama, Report Portal, MS Excel
Knowledge transfer


July, 2003 -  November, 2005
DATAWAREHOUSE/OLAP Architect

4 AEA 267 STATE OF IOWA Cedar Falls , IA
Database application development and management using MS technologies Sql 2000/2005
Data warehouse/Business intelligence assessment, development and management
ETL packages using DTS
Multidimensional databases reporting Cube : MOLAP, ROLAP strategies for Student assessment ITBS/ITED, BRI, DIBELS, NWEA, etc with trending capability
Dimensional modeling
Joint Application Design JAD
Swift Knowledge applications, Development and management of web and windows applications
Reporting using MDX, ProClarity Pro, Business Objects.
Data modeling Entity Relationship Logical design/physical schema using ERWin 4.0
Performance monitoring and troubleshooting.


November, 2001 -  June, 2003
Consultant

5 CONGONET Kinshasa D.R. Congo

Representation of the Company interests to customers
Cost analysis, test and purchase software products.
Database and data warehouse development, technology assessment : Sql 2000, MS Analysis Services/OLAP, MDX, ETL Tasks, COM, COM+, Oracle 9i, PL/SQL and XML.
Data Modeling : Entity Relationship ER using Visio


May, 2000 -  November, 2001
Lead Analyst

6 GRINNELL REINSURANCE Co Grinnell , IA USA
Data Transformation Service packages DTS/ETL.
Visual Studio 6 VB6.0, JavaScript, VBScript, ADO, COM, DCOM, T-SQL, stored procedures, SQL-DMO, XML, Visual SourceSafe
OLAP.
Database design ER diagrams, logical schema, l physical design
Technology assessment for Property and Casualty Insurance

Installation and troubleshooting : Windows 98, Win NT4, Windows 2000, IIS4, IIS5, MS SQL7, Sql 2000


July, 1996 -  June, 1999
Director

7 ONPTC-PTT Kinshasa DRC

Management : Product Development department and computer training centers.
Application development project : Database and web application C++, Java, Sql, VB, JavaScript, HTML, data modeling
Mailing list Administrator.


July, 1993 -  June, 1996
Mail-list administrator

8 : The University of Iowa IA




Education

1 Saint Ambrose University Davenport , IA , USA
MBA/Information Systems , April 1996 .
GPA 3.40

2 The University of Iowa City , IA , USA
Grad level : Special courses in Numerical Analysis 08 CRD August 1994 - May 1995
Under Grad level : BS Comp . Sciences/Mathematics , . August 1990 - May 1994



Skills

1 Managerial : Strong interpersonal skills with the experience of working in a multi-cultural environment as a Manager and an Instructor former Teacher and Certified on People Skills 2 Analytical : Business analysis, numerical analysis, statistical analysis, Finance 3 Computer Programming : Multiples Languages, Web programming, Database programming, BI development.