Data Management

Henry Lotsu Senior

BI Developer

Tel: 862-***-****

E-mail: ******@*******.***

PROFESSIONAL SUMMARY

. SDLC: 5+ years of total IT experience in Analysis, Design, Development

and Implementation of Data Warehousing and other applications using

Object Oriented Analysis, Design and Methodologies.

. Business Objects: 4 years of Business Intelligence experience with

complete life cycle Implementations using Business Objects

BI4.0/XIR3.1/XIR2 (IDT, Supervisor, Universe Designer, InfoView, Business

Objects Reporting, Business Objects SDK, XCelsius, Web-Intelligence,

QaaWS, BI Widgets), Life Cycle Manager, Live Office. Experience in

installation and configuration of Business Objects Enterprise editions.

Support for Mid-size and Large businesses in Development, testing and

Production environments. Created complex reports by linking data from

multiple sources, using functionalities like OpenDocument, Combined

Queries, @Functions, Scope of Analysis, Slice and Dice, Drill Down,

Master Detail, etc.

. ETL: 2+ years experience in loading huge amount of data into data

warehouse using ETL tools like Informatica, Ab Initio and IBM DataStage.

Development of mappings in IBM Datastage to load the data from various

sources using different transformations like Source Qualifier, ODBC,

Change Data Capture(CDC), Expression, Look up (connected and

unconnected), aggregate, Update Strategy, Joiner, Filter and Router

Experience in Creating, Testing and Executing Data Integrator jobs.

. Data Modeling: 4 years experience in analyzing, designing and modeling

data warehouse(EDW), operational data store(ODS), and star schema data

marts for various business verticals like Retail sales, Financial,

Structured finance, Payroll Accounting and Entertainment . Good at

Database Design, conceptual, logical and physical Data Modeling, Star

Schema, Snowflake; FACT and Dimensions tables, uneven Hierarchies,

multidimensional and slowly changing dimensions (SCDs).

. Databases: 5 years of solid database experience in Oracle 10g/9i/8.0/7.x,

MS SQL Server 2000, 2005, 2008 (database triggers, materialized views, In-

line views, Packages, stored procedures, functions, and database

constraints), Sybase IQ 12.7, Sybase IQ 15.4 Multiplex, SQL Loader,

Greenplum DB 8.4, PostgreSQL, PL/SQL and oracle DBMS Packages, oracle

supplied utilities, TOAD, Rapid SQL, MS ACCESS 2000/2003.

TECHNICAL SUMMARY

O/S: Windows NT/2000/98/95/XP/Vista/7, UNIX, Linux

RDBMS: SYBASE IQ 12.7/15.4 Multiplex, Oracle 10g/9i/8i/7.x, SQL Server

2000/7.0, MySQL, MS Access 2000/2003, Greenplum DB

8.4

Data Modeling Tools: ERwin 9.2/8.0, Visio2002.

ETL Tools: Ab Initio, IBM Data stage 8.7/9.1.2, SSIS

Database Tools: TOAD 10.5, SQL Navigator, SQL Server

(Management Studio Express)

BI Tools: SAP Business objects 4.0 sp2/sp4, Business Objects

XIR2/R3.1

Web Intelligence XIR2/XIR3, Dashboard Design 2011,

Xcelsius 2008, Crystal Reports 2008/2011/Enterprise,

Live Office, MS Excel 2003/2007

Languages: HTML, PL/SQL, SQL, Java, CSS

GUI: Oracle Developer 2000, Visual Basic 5.0/6.0

Professional Experience

Union Bank (MUFG), Monterey Park, CA Aug' 14

- Present

Lead BO Solution Architect

MUFG Union Bank is an American full-service bank with 398 branches in

California, Washington and Oregon which is wholly owned by Japanese Tokyo-

Mitsubishi Bank. This project involved the migration of the Data Quality

management data warehouse and reports from Oracle to GreenPlum database

application and system modifications to support data from multiple streams

of Business into a single repository.

Responsibilities:

. Interacted with the Data Management team (DMO) to identify business

requirements and co-operatively document reporting requirements into a

data warehouse strategy resulting in both operational and analytical

reporting.

. Lead Data model analysis and design sessions to provide a solution that

supports multiple Business Groups of the Bank with multiple Data Control

Points (DCP) to meet reporting needs.

. Installed and tested various ODBC and JDBC drivers to support GreenPlum

Database connectivity to Business Objects.

. Converted Oracle based universe to GreenPlum based universe including SQL

conversion to PostgreSql. Unit and System Integration testing of reports

and dashboards.

. Supported ETL team during design and analysis of requirements and SQL

scripting to support monthly and quarterly snapshot of fact tables and

aggregated tables to support Dashboard QaaWS and BIWS.

. Enhanced Business object reporting schema moving complex formulas and

calculations in semantic and reporting layer to Database for Data Quality

data mart.

. Responsible for knowledge transfer to end-users and trained them on

various functionality using Infoview and Designer.

Environment:

Business Objects XIR3.1/4.1 (IDT/Designer, WEBI, Web Rich Client,

XCelsius), Pivotal GreenPlum DB 8.4.2, Oracle 11g, Informatica 9.5 HF2/HF4,

HPQC, pgAdmin III, TOAD for Oracle 11g, MKS Integrity.

Entertainment Partners, Burbank, CA

Dec '12 - July' 14

Senior Reports Developer

Entertainment Partners' (EP) mission is to WOW! It's clients by delivering

personalized client service and innovative, reliable solutions. EP becomes

an integral part of your crew by providing more than 30 years of experience

and expertise in the most important aspects of your production. This

project involved the creation of a Data warehouse to consolidate Client

Production Cost data from multiple legacy applications and data sources and

create a reporting system for it.

Responsibilities:

. Documenting & Delivery of the validated-reports for the Go-Live purposes.

. Designed, developed & maintained universes using BO designer.

. Deployed BO Universes and Reports in a Secure Environment from one server

to other server using Import Wizard and BIAR file methodology.

. Set up groups and users and managed application security using CMC.

. Wrote SQL views and stored procedures for ETL load, Crystal Reports and

WebI reports.

. Tuned and Enhanced Universes with SQL Queries for the Report Performance

. Worked with team closely with Functional Architect, DBA and Analysts in

analyzing the data requirements and then designing and developing

universe enhancements required.

. Gathered, analyzed, and documented business requirements, HLD & LLD,

functional requirements and data specifications for BO universes &

reports.

. Involved in requirements gathering for ETL solution including mapping

document, data modeling, view and staging table creation and ETL job

design and testing.

. Created / Modified Universes, Reports from the underlying Databases for

business modules.

. Created derived tables at the Universe level to reduce the complexity of

the Universes.

. Performed Warehouse Star Schema and created new extensions to Existing

Fact - Dimension tables including migration of data and adding indexes

and constraints to improve performance.

. Assist with user testing of systems, developing and maintaining quality

procedures, and ensure that appropriate documentation is in place.

Responsible for all project documentations.

. Developed test plans for data accuracy, analysis and ETL load validation.

. Responsible for knowledge transfer to end-users and trained them on

various functionality using Infoview and Designer.

Environment:

Business Objects XIR3.1/4.1 (IDT/Designer, WEBI, Web Rich Client, XCelsius,

Crystal 2008), Microsft SQL Server 2008/ Enterprise, Oracle 11g, IBM Data

Stage 8.7/9.1.2, Erwin data modeler 9.2, IBM ClearCase, Mingle, BO SDK,

Adobe Flex, XML.

Citibank, Tampa, FL March

'11 - Nov '12

Application Developer

Global Functions Technology Services Organization provides application

development and other technology services for global functions, including

Compliance, Enterprise Risk, Finance, Human Resources, Legal, Real Estate,

IT Risk, Procurement, and General Services. The goal of this project was to

address performance and functionality issues and introduce new tools into

the Finance Management reporting Application. My role in this project was

to provide expertise on data modeling for new universes, reports and

dashboards and also provide recommendations of appropriate SAP Business

Objects tools and integration strategy with allied software. Conduct and

publish results of Proof-Of-Concept (POC) for various requirements based on

Business needs.

Responsibilities:

. Worked with GFTS Finance Directors / Functional Managers / Business

Analyst's / DBA's/ End Users to gather Universe Design and Reporting

requirements to implement business logic for successful implementation

of reporting system with new SAP BI4 suite of tools, HANA, Netezza and

Sybase IQ 15.4 Multiplex.

. Performed Proof-Of-Concept for integration of In-Memory Analytics

tools and Parallel query execution tools like Netezza and SAP HANA.

. Worked with ETL, PeopleSoft EPM, DBA and Financial Reporting

Operations team to redesign the Database to incorporate

multidimensional and complex ratios into reporting layer.

. Designed and implemented the New Universes (.unv and .unx) and several

Dashboards for Business needs using tools like Information Design Tool

(IDT), QaaWS, Dashboard design 2011, Crystal reports

2008/2011/Enterprise, Live Office, BI Widgets and Rich Client.

. Resolved universe issues like loops, traps, joins, hierarchy, LOV,

parameters and connection issues.

. Incorporated the Citi Group rugged/uneven Hierarchy to track

performance of Individuals and life cycle of application components of

Data segments, geography, Business units, Accounts and Global

Operating Codes.

. Setup the row level security for better management of users' data

access and elaborate folder level security for BI Launch Pad

(Infoview) management.

. Responsible for Universe Design and reporting issues.

. Worked on Creating Metric Reports using web Intelligence and developed

report packaging and distribution application using PeopleSoft

integration, SharePoint and BO Java SDK.

. Worked on Developing Standard & Multi-Dimensional Web Intelligence

Reports using features like Drills, filters, Sort, Rank, Sections,

Breaks, Alerts, merge Dimensions, Sub Quires and Multiple Data

Providers.

. Worked on creating stored procedure for Business Objects Reporting.

. Developed stored procedures in WATCOM SQL, T/SQL, PL/SQL and Unix

Shell Scripts for automated execution of jobs.

. Developed workflow for performing Database and report performance

benchmarking using Load Runner (LR) coding.

. Extensive use of Microsoft Excel and PowerPoint to present test

findings and analysis.

. Worked with DBA and UI Team for migration of flex Dashboards to

Business Objects XIR2 Environment.

Environment: BI4.0 SP4/SP2, Business Objects XIR3.1, SAP HANA,Oracle

PeopleSoft EPM, Share point 2007, SYBASE IQ 15.4 Multiplex, Sybase IQ

v12.7 simplex, Oracle 10g/11, SQL Server 2005, SQL and PL SQL, BO SDK,

Netezza, Qlikview, Ab Initio, JSP, Servlets, XML, Tomcat, Unix, MS Word

2007, MS Excel 2007, Adobe Acrobat 8.

Anoder Spirit Inc, Accra, Ghana Feb '07

- Dec '08

Role: Administrator/Developer

ASI is a multimedia and technology service company delivering technology

solutions to its clients. Services provided include LAN/WAN services,

Oracle 8i/7, MS Access and MS SQL database administration and custom

software development.

Responsibilities:

. Administered Oracle 8i/7 and MS SQL 2000 databases of clients. With

requirement gathering and report generation.

. Set up database connectivity and wrote custom web-based programs to enter

and retrieve data from databases using Java, VB Script and PHP.

. Interacted with the Business Analysts to gather the requirements and

developed prototypes in the form of PDF's or Power Point Slides for the

initial presentation to the users.

. Coordinating with the team for quality data and analysis.

. Developed test plans for data accuracy, analysis and load validation.

. Worked on the post-production activities for the enhancement purpose.

. Undertook LAN/WAN wiring and configuration.

. Involved in management of multimedia team and coordination of inter-

departmental activities.

Environment: Oracle 8i/7, TCP/IP Protocols, UML, HTML, Crystal Reports,

Java, MS Office,MS Access 2003/2000, MS SQL 2000, PHP, HTML, VB Script,

UML, TCP/IP Protocol Suite.

Contact this candidate