Post Job Free
Sign in

Data Sql Server

Location:
Atlanta, GA
Posted:
March 03, 2015

Contact this candidate

Resume:

David Cohn

Atlanta, GA ***** Mobile: +1-314-***-**** ********@***.***

*****.****@*****.***

Professional Profile

Accomplished Senior IT professional with a background in business

intelligence, software design and full life-cycle development. Capable of

managing numerous projects while leading cross-functional teams to meet and

exceed overall IT initiatives. Demonstrated consultative process skills

with emphasis on written and relationship development skills. Highlights

of skills:

. Business Intelligence

. Data Warehousing

. Process Improvement

. Team Leadership & Effectiveness

. Strategic Planning and & Analysis

. Reporting Systems Architecture

. Process Implementation

. Software Design & Development

Technical Expertise

. Tools: Business Objects 4, XI r3, r2, r1, 6.5, WebIntelligence 4,

XI, 6.5, UDT/IDT; Data Integrator 6; Data Services 4, XI 3.2, 4;

SSIS; SSAS; Ab Initio; BEx Query Designer; Sagent; BrioQuery; Cognos;

Genio; Erwin; Crystal Reports 2011, XI, 8.5; Xcelsius 2008 / Dashboard

Designer; IIS; SQL Loader; Visio; PVCS.

. Languages: Visual Basic 6; PL/SQL; SQL; Transact-SQL; Active Server Pages

(ASP); JavaScript; VBScript; HTML; DHTML; Ajax; JQuery; CSS; XML; eBay

API; SAS; Cobol.

. Databases: SQL Server 2008, 2005, 2000, 7.0, 6.5; Oracle 11I, 10I, 9I,

8I, 7; Teradata; Hyperion Essbase; Netezza; MySQL; MS Access; UDB; DB2;

Sybase; FoxPro; Filemaker.

. Business Applications: SAP (ECC 4.7, 6.0 -- HCM, SCM, SD, Material

Master, Vendor Master, iDocs, LSMW, Salesforce; Oracle Financials.

. OS: Windows Server 2008/2003/7/Vista/XP/2000/NT/98/95/NT; Mac OS;

Mainframe.

. Other: OLTP; OLAP; ODBC, ADO; OLE DB; Inmon; Kimball; Forecasting; Trend

Analysis; Full Life-Cycle Development; Star and Snowflake Schemas;

Executive Dashboards; 3-Tier Programming.

. Industries: Commodities, Defense, Consumer Products, Investments,

Pharmaceuticals, Clinical Trials, Finance, Leasing, Mining, Health Care,

Insurance, Telecommunications, Energy, Legal, and Manufacturing.

. Certifications: Teradata Certified Professional, Teradata Certified SQL

Specialist.

Professional Experience

Georgia-Pacific, Atlanta, GA, 07/2014 to Present

Data Services Expert

. Successful and rapid conversion of multiple Ab Initio processes to Data

Services, implementing methodologies to increase maintainability,

including simplification, logging, and inline documentation.

. Data analysis, modeling, and profiling using SQL Server and Data

Services, to provide new and improved data structures related to

conversion efforts. Included both inline and offline documentation of

table structures.

. Cost savings through replacement of scheduler with scripting involving

file watcher loops and, or database flag checks, moving files to staging

and production folders, and emailing of results, including attachments.

. Executed technical leadership on the use of the technology platform and

tools, mentoring in optimal use of BODS in a SQL Server, SAP, and Unix

environment.

Environment: Data Services (BODS) 4, SQL Server 2008, Oracle, SAP, Ab

Initio, Acorn, Win 7, Unix.

Baker & McKenzie, Chicago, IL, 05/2014 to 07/2014

Data Services Specialist

. Helped spearhead conversion from existing to new financial system,

providing ideas on best practices and standards.

. Cleaned up local and global data using address cleansing transforms in

BODS.

. Implemented processes with AIO methodology to speed development and

provide consistency.

. Developed processes within BODS that generated LSMW's and iDocs for

consumption by SAP.

Environment: Data Services (BODS) 4, SQL Server 2008, SAP, Win 7.

Kimberly Clark, Atlanta, GA, 03/2012 to 03/2013, 06/2013 to 05/2014

Data Services and Xcelsius Lead Developer

. Constructed reusable templates to speed ETL development in BODS and

provide auditing functionality. Led training sessions explaining usage

of templates and gathering ideas for improvement.

. Created and optimized executive summary, operating information, gross

margin, and framework (Xcelsius) dashboards, including hierarchical

selectors, flash variables (linking to dashboards), and dynamic sales and

marketing information based on live SAP BPC data.

. Significant contributions to dashboard and ETL architecture and design,

including best practices.

. Built Crystal Reports detail reports connected to BI services pointed at

Web Intelligence blocks containing BEx query details. Reports launched by

and received prompts from Xcelsius dashboard.

. Acted as go-to for the team for technical concerns and idea development.

Environment: Data Services (BODS) 4, Dashboard Designer (Xcelsius),

Business Objects 4 (WebI, UDT, IDT), Crystal Reports 4, SQL Server 2008,

Neteeza, SAP BPC, Win 7.

CP Kelco, Atlanta, GA, 02/2013 to 06/2013

Data Services and Business Objects Enterprise Developer

. Converted data conversion processes from BW to ECC sources, using Data

Services integrated with SAP.

. Created reporting system, including data model and dictionary, ETL, and

WebI reports, based off SAP ECC material master information. Involved

frequent discussions with offshore team members and business analysts.

. Troubleshooting of reporting, universe, and ETL issues with onshore and

offshore engineers.

Environment: Data Services (BODS) 4, Business Objects 4 (WebI, UDT),

Oracle, SAP BW and ECC, Win 7.

US Navy (Contract), Remote, 10/2011 to 06/2012

Business Objects Admin / Architect

. Acted as systems/software engineer for system architecture planning,

technical design, software development and test, and software, hardware,

and interface integration.

. Installation and configuration of Business Objects Enterprise and Data

Services, including Data Quality.

. Creation, improvement, and documentation of HR reports and related

universe, including standardization and applying best practices.

Environment: Data Services XI r3.2, Business Objects XI r3.2, SQL Server

2008; Win Server 2008.

UCB, Atlanta, GA, 02/2011 to 11/2011

SAP Data Services Architect

. Engineered conversion projects, using a self-designed standardized

process, for migrating information between SAP 4.7 and 6.0. Trained other

resources in process usage.

. Converted information from SAP modules, including manufacturing, material

master, basic data, fico, general plant, mdm, mrp, purchasing, qm, sales

data, units of measure, warehouse mgmt, and work scheduling.

. Built and implemented validation projects to ensure quality data

migration.

. Frequent daily interaction with SAP functional analysts and business to

review requirements and results and provide time estimates.

Environment: Data Services XI r3.2, Oracle 9i; SQL Server 2008; SAP ECC

4.7, 6.0; Win XP.

Westinghouse, Pittsburgh, PA, 11/2010 to 02/2011

SAP Business Objects Specialist

. Converted and enhanced Cognos into WebI, Crystal, and Xcelsius reports

with SAP data (HCM and SCM).

. Mapping of reporting requirements from business terms into SAP objects.

. Creation and maintenance of OLAP universes source from BEx queries.

. Writing and editing of SAP BEx queries using Query Designer.

. Writing of test scripts for accuracy, formatting, and performance.

Environment: Business Objects XI r3.2; SAP ECC 4.7 - HCM, SCM, SD; Cognos;

SQL Server 2008; Win XP.

American Safety Insurance, Atlanta, GA, 06/2010 to 11/2010

Business Objects Architect

. Guided and played key role in design document production, including ETL

field mappings for 500+ fields in four systems (2000+ fields total), data

dictionary, universe and report documents, and DDL scripts.

. Designed centralized data warehouse and subject specific data marts,

following Inmon methodology.

. Led report development effort, including creation of many Web

Intelligence reports and universes.

. Designed and implemented Business Objects architecture, including

hardware and software requirements, CMS information, security, and

migration from XIr2 to XIr3.

. Coordinated offshore ETL efforts, including meetings and answering of

daily questions.

Environment: Business Objects XI r3.2; SQL Server 2008; Inmon; Crystal

Enterprise SDK, Win XP.

Convergence Consulting Group, Tampa, FL (Remote) 07/2010 to 10/2011

ETL Architect

. Designed, created, implemented, and tested dataflows, workflows, scripts,

and jobs for multiple projects.

. Troubleshooting and performance tuning which reduced several jobs from

several hours to less than one.

. Full lifecycle project focusing on surveys, including Data Services and

Designer (universe) components.

. Migrated dataflows, workflows, scripts, and jobs between repositories.

Environment: Data Services XI r3.2, Business Objects XI r3.2; SQL Server

2008; Windows Server 2008, XP.

Black Watch Data, Atlanta, GA, 01/2010 to 07/2010

Data Quality Expert with Focus on ETL and Dashboards

. Created and ran ETL jobs to load and manipulate Material Master and

Vendor SAP information.

. Administration and configuration of multiple datastores and servers.

. Upgrade of First Logic / Data Quality to Data Services, with data and

multiple country address cleansing.

. Developed, published, and scheduled batch and real-time jobs.

. Produced contact duplicate checking ETL project, including match

transforms and adjustable parameters.

Environment: Data Services XI r3.1, 3.2; SQL Server 2005; SAP (extracts);

Xcelsius 2008; Windows XP.

AT&T, Atlanta, GA, 2007 to 2009

Business Objects Technical Lead/Architect

. Directed and coordinated organizational strategies of employees

responsible for conceptualizing, designing, constructing, testing and

implementing business and technical solutions for telecommunications data.

. Partnered with software and architectural teams to plan and build out new

systems, understand scalability and constraints of software, and manage

disaster recovery and business continuity planning.

. Acted as key developer, leading a team of four (mostly remote) developers

in the creation of Webi reports, universes, and Xcelsius dashboards

consisting of proprietary telecommunications information.

. Modeled and integrated several data marts using Kimball methodology.

. Held weekly training sessions with business users, analysts, management,

and other developers explaining how to use and edit reports and explaining

related business concepts.

. Full lifecycle development in multiple projects, all reaching sign off on

schedule.

. Reverse engineering of SAS reports using ETL (SSIS) and Business Objects

universes and reports.

. Created tables, synonyms, views (particularly with analytic functions),

and sequences in Netezza.

. Guided and developed the Business Objects teams, including providing

hiring recommendations, training, mentoring and monitoring staff

performance to effectively adhere to company's "best practice"

initiatives.

. Recipient of the "Employee of the Quarter" Award (Q4 2007).

Environment: Business Objects XI r2 (Webi, Designer, CMS, Admin); Crystal

Reports XI; Crystal Xcelsius 2008; SQL Server 2005; Teradata; SAS; SSIS;

Netezza; Kimball and Agile methodology; SAS; Windows XP.

Rho, Chapel Hill, NC (Remote) 2008

Senior Business Objects Developer

. Responsible for creating Business Objects universes and reports to

provide information on clinical trials.

. Successfully migrated universes and reports from development to test to

production.

. Created Oracle functions and stored procedures to supply comma-delimited

lists and date information.

. Created functional and technical documentation for all reports and

universes.

Environment: BusinessObjects XI r2; Oracle 9i; ARISg; Windows XP.

Oldcastle, Atlanta, GA, 2007

Lead ETL Developer

. Led efforts in the successful extraction and transformation of

information from Excel to SQL Server database, designing a database geared

towards OLAP reporting and later Essbase loading.

. Created >2,000 transformations to alter information extracted from Excel.

. Developed ETL program using VB with features for types of processes to

display and run, status lists, storing metrics, HTML help, and options to

skip process with errors to convert text values to zero's.

Environment: SQL Server 2005; Visual Basic 6; Hyperion Essbase; OLAP;

Windows XP.

Intercontinental Exchange, Atlanta, GA, 2006 to 2007

Lead Developer/Administrator - Business Objects/Crystal Reports

. Responsible for gathering customer requirements, architecting

prototypical solutions, acquiring customer acceptance, and managing

software processes from initial design to final implementation and

deployment.

. Primarily responsible for migrating Sybase, Business Objects (6.x), and

Oracle Sagent data warehouses to provide commodities-related financial

information to client and internal business users.

. Key Projects:

o Migrated three reporting systems to Business Objects XI and Crystal

Reports XI, with Oracle 9i.

o Administration using Central Management Console to schedule reports,

configure user and group security, and manage categories, folders,

universes, and licensing.

o Created and tested reports and universes with information about

commodities, futures, and options.

o Installed, tested, and maintained Business Objects XI (including

Crystal) client and server software.

Environment: Oracle 9i; Business Objects XI r2 (Webi, Crystal Reports,

Performance Management, SDK); Sagent; Visual Basic 6; Scripting (VB, Java,

batch); ASP; HTML; XML; CSS; SDLC; Cisco VPN; Windows XP.

IT Consultant 1995 to 2006

Key Clients: LeasePlan, Lockheed Martin, WPAFB (Air Force), Haworth, HPFS,

AT&T, Travelers, CIT, Cigna, Anheuser-Busch, Peabody Group, MasterCard,

Ralston Purina, Maritz, Davis Interactive

. Client: LeasePlan, Atlanta, GA - Business Objects Expert (2005 to 2006)

o Created a Business Objects data warehouse to provide leasing

information to >100 key clients.

o Designed and rolled out an innovative reporting system using Webi,

including linked reports.

o Created conversion utility supporting improved (Excel) and

unavailable formats (Word and HTML).

. Client: Lockheed Martin (US Navy, SPAWAR), New Orleans, LA - Bus. Objects

Expert (2004 to 2005)

o Gained acceptance of a conversion of an Access reporting system

into Business Objects.

o Developed, documented, and performance tuned thirteen reports and

associated universes.

o Conducted qualitative and quantitative analysis to define project

scopes and technical criteria.

o Collaborated with key internal and external decision makers to

recommend process enhancements.

o Recipient of the "Lockheed Martin Outstanding Performer" Award

(2004).

. Client: WPAFB (US Air Force), Dayton, OH - Bus. Objects Technical Support

Analyst (2003 to 2004)

o Provided expert analysis and assistance for the Air Force Knowledge

System application, supporting over 450 tickets arising from over

300 users.

o Tested and troubleshot WIS and INF errors, training, and network,

database and universe issues.

o Troubleshot invalid data resulting from universe and database

problems.

. Client: Halworth, Holland, MI - ETL Developer (2003)

o Gathered specifications and developed, tested, and rolled out

transformations and universes for AP, PO, and FA segments of Oracle

Financials using Business Objects Data Integrator and Designer.

. Client: HFPS, Murray Hill, NJ - Business Objects Expert (2003)

o Served as financial reporting analyst, balancing data related to a

conversion of a loan system.

o Provided support to users for report requests and maintenance,

creating and testing >30 reports.

o Analyzed, documented, and implemented recommendations for SQL

Server DTS scripts.

. Client: AT&T, Bedminster, NJ - Business Objects Expert (2003)

o Reporting analyst assigned to analyze and improve call center

performance and processes.

o Responded to daily maintenance requests, streamlining processes

through the installation, administration and configuration of

Business Objects, including Publisher.

. Client: Travelers, Hartford, CT - Business Analyst (2002 to 2003)

o Main point of contact in a Focus mainframe, SAS to client-server

(Business Objects, Crystal Reports) migration and conversion of the

Annuity Reporting System.

o Collaborated with cross-functional teams to develop 42 reports

including prototype creation, testing, documentation, performance

tuning, and requirements gathering and design.

. Client: CIT, Livingston, NJ - Business Objects Expert (2002)

o Served as lead financial reporting analyst in a Citation mainframe

to client-server (ALS) Business Objects implementation of a data

warehouse (Oracle, Sybase) for leasing.

o Partnered with end-users and key internal decision makers on

requirements gathering.

o Full life-cycle development and performance tuning of 54 flawless

reports using Business Objects Reporter, Designer, Supervisor, and

Broadcast Agent.

o Trained, mentored and monitored new and existing developers,

instilling "best practices" to adhere to internal protocols and

procedures.

. Client: Cigna, Hartford, CT - Data Warehousing Consultant (2001 to 2002)

o Responsible for the enhancement and maintenance of a customized

Brio data warehouse reporting application for investment data,

including transforming source data (Genio).

o Gathered scopes and specifications to test and provide daily

support of Brio and Genio.

o Taught end users on the capabilities, enhancements, and limitations

of Brio.

. Client: Anheuser-Busch, Inc., St. Louis, MO - Senior Business Objects

Developer (1999 to 2001)

o Implemented full lifecycle design of a 60 report data warehouse for

pricing and promotions, that aided retailer sales tracking and

marketing applications.

o Administered Business Objects repository, security, setup,

universes, and report scheduling, including an upgrade from version

4 to 5.

o Constructed automated universe and report documentation with

Business Objects SDK.

o Participated in Oracle ETL (transformation) related efforts,

including creation of PL/SQL functions, packages, stored

procedures, views, tables, indexes, explain plans, and types.

. Client: Peabody Group, St. Louis, MO - Business Objects Developer (1999)

o Production included report creation, design, and prototyping

security, universe maintenance and origination, data definition and

manipulation, testing and layout.

. Client: MasterCard, St. Louis, MO - Consultant (1998 to 1999)

o Accountable for the conception of financial reporting system and

associated graphical user interface, generating financial reports

using Crystal Reports, VB, and Oracle.

. Client: Davis Interactive (Interchange Technologies) St. Louis, MO -

Consultant (1995 to 1999)

o Responsible for design and support of multimedia projects with

Macromedia Director and VB.

Maritz, St. Louis, MO 1997 to 1998

Programmer/Analyst

. Designed, developed, and tested reports and associated interface using

Visual Basic and Crystal Reports.

Education

. Bachelors of Science Degree in Accounting, Minor in Business Management -

Maryville University; Recipient of Academic Scholarship. Graduated

December 1996.



Contact this candidate