SAP BODS ETL/BI Developer Resume Chicago, IL - Hire IT People

SUMMARY:

Seeking a position of SAP BODS ETL Developer utilizing my practical experience developing ETL jobs in a data warehouse environment.

TECHNICAL SYNOPSYS:

SAP BODS ETL Jobs
Developing Jobs, Workflows, Dataflows
Source Data Profiling.
Creating Job variables for producing dynamic filters in Query Transforms
Monitoring execution and Workflow/Dataflow dependencies
Check out and check in from the Central Repository.
Universe Design
Xcelsius 2008 Dashboards
Web Intelligence (WebI):
Crystal 2008
Creating SQL code for multiple analysis scenarios using Joins, Sub - queries, Row Restriction, Grouping.
MS SQL Server 2005/2008 - creation of tables, views, SQL queries
SQL code manipulation
TOAD for Data Analysis 3.0
Creating Tables and Views
MS Excel 2010
Charting reports
Formulas
Connection to external Data Sources

WORK EXPERIENCE:

SAP BODS ETL/BI Developer

Confidential, Chicago, IL

Responsibilities:

Creating, analyzing, and modifying SAP BODS Jobs to support the Enterprise dashboards and reporting database.
Performing complex analysis of data impact and lineage that links dashboard data metrics to the database sources including complex SAP BODS Jobs, Workflows, and Dataflows.
Developing and modifying two major Xcelsius dashboards that display KPI of the organization.
Creating and implementing modifications of SAP BOE Universe to support changes of dashboard requirements

SAP Business Objects Developer

Confidential, Evanston, IL

Responsibilities:

Working as a consultant developing basic SAP BODS Jobs to support customer requirements.
Working as a consultant developing a variety of SAP BOE 3.x Universe, Web Intelligence reports in commercial, and marketing areas.
Crystal Reports 2008 - working knowledge
Xcelsius 2008 - created and enhanced dashboards
Requirements gathering and documentation
SAP BOE Universe creation, enhancements, and maintenance
SAP BOE WebI reports creation and modification
SAP BOE Central Management Console administrative functions
Database analysis and documentation
Database design and modification

Chemist

Confidential, IL

Responsibilities:

Empower reporting - full cycle of creating customized reports using data collected from chemical processing equipment
Empower acquisition, integration, processing, and presenting data
Test analysis following US and European Pharmacopoeia standards

In-Process Chemist

Confidential, St.Louis, MO

Responsibilities:

Overall responsibility for the in-process area of the peptides analytical lab
Programming of instrumentation (HPLC, IC)
Final reporting presentation of data from the qualitative and quantitative analysis.