Skills:

Data modelling and design using Erwin. OLAP OLTP.

MS SQL Server to v. 2008 Inc. 10 years . Including TSQL, SSIS/DTS, SSAS with MDX, SSRS.

Oracle to v. 11g 5 Years inluding PL/SQL with TOAD and UNIX shell scripts. ODI OBIEE.

Cognos. 5 years. Business Objects. Teradata. C .Net programming 1 Year.

Professional Experience: BI Consultant: Confidential 9/2014 Current

Using MS Sql Server MS BI Stack, SSIS SSAS TSql. Performing enhancements to existing ETL Processes OLAP Cubes.

BI Consultant:

Confidential

• BI Consultant, using Oracle with OBIEE Sql Server with SSIS SSAS.
• Client- Cablevision. Designed and built data warehouse in Oracle 11g to contain financial reporting data. Built ETL processes to transform mainframe data to relational data for import into Data warehouse star schema.
• DB Architect/Developer Using Oracle 10g. Sql Server. Responsible for all aspects of Saks direct website databases, including maintenance of processes involved in updating the data warehouse, and consulting on processes running on the retail web site database. Tools used include TOAD, UNIX with shell scripts, SSAS, SSIS, Oracle Data integrator ,Cognos Teradata.
• BI Database Architect: Confidential 10/2008-11/2013
• Designed Data models for BI conforming to Kimball star schema methodology, and wrote and built the ETL processes to populate the schemas using pl/sql and Oracle Data Integrator ODI . Adapted data models to allow for Omni Channel Initiatives, allowing for reporting on 'ship from store' as well as Internet orders.

• Built Cognos frameworks for reporting, and Sql Server Analysis services cubes for ad-hoc analysis. Along with the new data schemas this transformed reporting for the business, who had been used to reports taking hours to run against a poorly designed 'reporting' database, and now had reports coming back in seconds, and true analytic capability with Excel pivot tables connecting directly to SSAS cubes, with calculated MDX measures. Cubes auto- populated with SSIS Packages.
• Played a large part in transforming the scalability of the web site data operations. Major achievement was to convert the product array data operation from sql server 2000 to Oracle. Converted to Oracle a database which was in sql server and updated via ms Access and was a major bottleneck in getting new product on to the web site.
• Converted other database processes from Sql Server to Oracle for the staging database for Blue Martini, enabling a needed upgrade of the Blue Martini software.
• Worked on data extract process for web site search engine. Cut the processing time from 8 hours to 1, enabling Saks to break sales more rapidly in response to retail competitors.
• Worked on switching all ETL processes involved with the web site to source new data servers.
• Performed Ad-hoc data analysis with Teradata for physical stores reporting.

Database Architect:

Confidential

DB architect/developer DBA using Sql Server 2005. Responsible for design development of application databases OLAP cubes, project development using transact Sql, Stored procedures triggers plus replication. Projects include client server ms .Net projects using C Sql Server, data warehousing projects using OLAP with SSAS SSIS, SSRS and Business Objects.

• Built and maintained Customer Reservations Data Warehouse, part of team of 6.
• Built Analysis Services 2005 cube data mart to measure activity on jetblue.com website.
• Business Objects MS Reporting Services Architecture report development. Including BO Universe builds.
• Built data mart to measure check in volume at Airports, Analysis Services 2000.
• Built performance data mart from data used to log aircraft take off and landing times. Used for on time performance analysis.
• Designed and built data model for Amex rewards transfer to 'Trueblue' frequent flier points project. 2 Million in revenue.
• Designed built database for CompanyBlue Application, DB is an OLAP Data mart built from reservations Data warehouse. Application allows corporations to view their booking and spend activity via the Internet. 5 million in revenue to date.
• Built several On time performance reporting applications using C .Net and Sql Server.
• Built Database and implemented document communications for USPS Mail project, utilizing Biztalk 2000 and Covast EDI.

Sql Consultant

Sql Server Developer

Confidential

• Sql Server Developer using Sql 2000 Crystal Reports, ad hoc reporting and data migration duties.
• Data Warehousing Consultant 10/2002 1/2003 Sql Server Data Warehousing assignment Uniqu Confidential
• Built a Data Warehouse in Sql 2000 for a commercial website. Designed star schema data model. Built DTS packages for data extraction from production server, transaction tables contained up to 5 million rows . Wrote transact Sql Stored procedures to produce summary reports on user activity Revenue from warehouse.
• Database Architect 6/1997 1/2002 Confidential
• DBA Support and enhancements, including performance monitoring and tuning, backup procedures and replication. Application development, including scripting, stored procedures triggers, data conversion from Access, Excel text files to Sql Server using DTS, Data modelling in Erwin.
• Designed and built a Data warehouse for reporting in Sql 2000 to Integrate Plural applications with Lawson ERP software, Wrote stored procedures used to produce financial reports, front ended by Excel VBA.
• Designed and built a Data warehouse for MIS Data, MS SQL Server 7.0. , DTS and Analysis Services.
• Developed Intranet applications using ASP/HTML and VBScript, VB COM objects And Sql Server. Using Visual Interdev, and COM objects using VB 6.0. Built Sql Server tables and stored procedures.
• Built various MIS applications including Project Management, Finance and HR client server systems. Using VB 5,6.0 and Sql Server 6.5, involving Analysis design, plus the use of Stored procedures, Replication and Triggers in Sql Server, and COM objects development in VB.

Consultant Applications Developer

Confidential

• Applications development, using MS Visual Basic 5.0, MS SQL Server 6.5 MS Access.
• Insurance Reservations System, 'AIStart' with VB and DB2 / SQL Server. Development in Visual Basic 4.0, and set up of a test DB environment migrated from MS Access using SQL Server 6.5. DBArtisan.

Analyst/Programmer

Confidential

• Developer/DBA, using Visual Basic, SQL Server Access, on marketing data applications.
• UK-wide customer loyalty Client/Server system for Texaco UK, using VB 3.0 SQL server 4.2. Team of 5. VB Sql Server Development.
• Analyst/Programmer 9/1981 10/1995
• Confidential Applications development support, using MS Access, MS Visual Basic, and MS SQL Server. Support of applications produced in previous roles in PRS, which were written using Clipper and Dbase 3.
• Members access to data system, using SQL Server 4.2 Visual Basic 3.0/ DB Library.
• Joint Notified Works System, written in Access, including Import Export of data from Mainframe files Aug. 94.
• Applications development, using Clipper/Dbase 3 Sycero DB Clipper 4GL , and from August 1993.
• Network support installation MS Lan Manager Technical support, some desktop support.