Allan Verissimo Souza
(c) 773-***-**** • ***********@*****.*** • http://www.linkedin.com/pub/allan-souza/11/11/9bb
PROFESSIONAL EXPERIENCE
Enterprise Application Solution Architect Consultant
State Farm Insurance – Bloomington, IL
July 2013 – Present
Provide the Enterprise Performance Management & Analytics (EPMA) group advisory services, and serve as the escalation point
for application architecture (including BI data delivery capabilities).
As a part of Architecture and design team involved in creating and developing POC's to finalize and approve design
decisions.
Responsible for reviewing Architectural Decision Documents (ADDs) and participate in creation as appropriate.
Participated in horizontal business efforts to define logical business function/process across all lines and access points
of State Farm and align work between multiple po rtfolios.
Performed project cost/benefit estimation, budgeting and resource allocation for multiple efforts across State Farm .
Created the reporting road map for the large ARM (Asset Risk Management) program to provide State Farm the
capability to report on the asset inventory and related asset information; executive dashboards, management and
operational level reports were provided using IBM Cognos and Qlikview.
Performed As-Is and To-Be artifacts using Mega Enterprise Architecture tool for analysis and system development
efforts which supported various functional groups across State Farm.
Led architecture solutions, recommendations and BI data services on Hadoop, IBM Cognos & TM1, Qlikview, etc.
Architecture methodologies, frameworks, standards and tools used (TOGAF, MEGA, ITIL, UML and MS Visio).
Business Intelligence Architect Consultant
Northern Trust Bank
February 2013 – July 2013 (6 month contract)
Worked with Northern Trust to identify gaps in their Cognos reporting environment; provided solutions to enhance reporting
experience, and supported the migration from Cognos BI 10.1 to 10.2.
Leaded the migrating of existing PowerPlay cubes, prompted, bursting and drill through reports from IBM Cognos
10.1 to 10.2 environment.
Coordinated offshore BI support\development team and serve as technical project manager for all Cognos migration
issues and develop solutions for new or unknown issues.
Launched an IBM Cognos TM1 environment from the ground up
Business Intelligence Analyst Lead
Groupon
June 2012 – February 2013
Coordinated activities of cross-functional teams in order to achieve goals of BI and DW projects, including work plans,
system design, complex Teradata data queries, data modelling and mapping along with testing of solutions.
Created dashboards and reports to support Marketing, CS and Finance teams and provided on-going analytical
support using Tableau for Data Discovery, Teradata and MicroStrategy.
Senior Business Intelligence Consultant
BrightStar Partners – IBM
February 2011 – May 2012
Client: Astellas Pharma – Deerfield, IL
Lead position responsible for providing support and management to the Cognos reporting team for the Market
Intelligence department.
Developed and revised existing Framework Manager Models to improve performance and accuracy.
Developed market share, product share and waterfall graph, as well as complex report dashboards.
Client: PartsNow - Middleton, WI
Developed several dashboards to support management team and improved performance and design of existing
reports.
Provided on-going technical support for Cognos 8 applications including report analysis, development, maintenance,
and report migration.
Allan Verissimo Souza
(c) 773-***-**** • ***********@*****.*** • http://www.linkedin.com/pub/allan-souza/11/11/9bb
Client: AT&T – Greensboro, NC
Assisted NICE with developing their Call Center dashboard BI solution to be delivered to AT&T. This engagement involved
providing more effective means for displaying complex data sets using a variety of charts to quickly convey Call Center
representative effectiveness (Cognos Report Studio, Framework Manager and Oracle) .
Senior Business Intelligence Consultant
Tahoe Partners (4-month project)
Client: Cengage Learning – Cincinnati, OH
Responsibilities included planning and implementing the migration of IBM Cognos Series 7 to IBM Cognos 8.4. Evaluating
different migration options and analysing impact of the migration process on business processes, user community and support
structure.
Re-development of 250 power cubes and over 1000 reports (Report Studio, Analysis Studio, and PowerPlay Studio).
Performed quality assurance testing to validate Cognos reports and cubes.
Business Intelligence Developer
AMCOR Flexibles
November 2006 – October 2010
Responsibilities included delivering Enterprise Data Warehousing and BI solutions for 4 different locations in US; managed all
aspects of the BI lifecycle from assessments to gathering requirements and delivering to end user solutions.
Improved Sales/Finance reports and released a new reporting and analytic environ ment within six months of hire,
which eliminated Business Intelligence consulting cost within one year.
Managed the daily Extract, Transform and Load (ETL) processes that manage the synchronization of data betw een the
AS/400 ERP and BI tools.
Launched a BI environment from the ground up using SQL Server and Cognos. This solution utilized data from many
disparate sources including Great Plains and AS/400.
Designed and supported various Performance Management solutions such as Cognos Planning Rolling Forecast,
Budgeting, Functional Support Costs Plan and Allocations.
Information Technology Coordinator
SunGard Higher Education
October 2005 – November 2006
Primary responsibility was implementing IT-related policies and procedures and ensuring the availability o f necessary technical
resources; managed both internal systems and resources as well as outsourced ven dor support.
• Supported all IT issues, ensuring system reliability
• Responsible for training and coaching of new IT coordinators
• Resolved customer calls regarding software and hardware issues
4 years of IT consulting experience prior to this date - per request
EDUCATION & CERTIFICATIONS
DePaul University
MS, Business Information Technology
2012-Present
Loyola University of Chicago - Graduate School of Business
Executive Education, Mini MBA Management Program
2014 – 2014
University of the State of Rio de Janeiro - UERJ
Bachelor of Science, Computer Science (1996-2000)
LANGUANGES
Fluent in Portuguese, English and Spanish