BI Data Warehouse Manager / Director

An innovative and highly motivated BI Manager/Technical Lead with outstanding credentials and experience

SUMMARY OF QUALIFICATIONS

Strong communication and development experience in creating, upgrading, and integrating back-end systems including financial applications, business intelligence applications and web infrastructure applications for such clients as AT&T, Dillard’s, Citibank, CHASE, Disney, Lodgian, Holiday Inn, Wyndham Hotels, Ceridian, Abbot, Advanta, Microdyne, Ski.com, Kaplan University and University of Phoenix, RealPage Inc.

Over 15 years of experience Managing Databases and Developing New Databases for a wide variety of software applications and assuring the end of projects from concept to completion, plus 4 years of training and mentoring experience.

A visionary leader specializing in web technology for building back-end systems and taking part in Reporting Applications and web application by possessing extensive knowledge of all aspects (SDLC) of application development.

Solid experience with accounting and budgeting dynamics; very profit-minded and results-oriented with agile development practices for rapid development in an enterprise environment.

Firm experience with project management and workflow software applying critical path and risk management and uses innovative tools and metrics.

Energetic, responsive, and detail-oriented, with proven ability to find solutions to clients' needs using innovative methods for getting close to customers and achieving customer focus, customer loyalty, and customer satisfaction

Able to manage multiple projects and produce quality work under tight deadlines.

Good communication and people skills, including ability to work with both technical and non-technical people as well as under took measures for consensus building across multiple teams and departments.

Outgoing, friendly team player and takes job seriously ensuring 24/7 availability.

Maintained personal and company level Partnerships with great BI tools vendors such as IBM Corp., Microsoft Corp., and Computer Associates.

Always connected and in communication with the top leaders in the BI and DWH area such as Bill Inmon, and Ralph Kimball for BI and always engaged in the R&D world with different professors for Data Mining algorithms.

COMPUTER SKILLS

Internet Protocols / Networking Skills: TCP/IP, SOAP, UDP, SMTP, HTTP, HTTPD, and ICMP, Mobility.

Hardware: Dell Server, HP Servers, MAS Storage (SAN, NAS), Microsoft Appliances for CDC and DWH.

Server Tecnologies: Great Plains Dynamics, MS IIS (Load Balancing, Pooling, Host headers), COM+ (MTS), SSRS, MS TFS Server and MS Sharepoint Server and Dashboard, Image Editors (such as Photoshop and Image Ready), Image Processing, PM Body of Knowledge, WEB Services, .NET, Compact .NET, FTP, Exchange and SMTP Servers., SQL Server, Oracle, MySQL, Postgres

Development Tools and Programming Languages: MS Visio, MS Visual Studio (97-2010) .NET Frame Work (VB.NET, C#), Crystal Reports, VBScript, TSQL, MDX, SSRS, SSIS, SSAS, Source Control (TFS, SVN), MS Project, Cognos FrameWork, Cognos Transformer (PowerPlay), Cognos Reports.

Monitoring Tools: MOM, SCOM, Reliability and Performance Monitor, SQL 2008 Data Collection, SQL Solution (DeadLock Detector, Heartbeat, and Accelerator), RedGate (Monitor, Schema Compare, Data Compare etc.)

Database Development: Database Design (Physical and Logical) Transactional and Dimensional Modeling with Erwin 8.0, Case Studio for Engines such as MS SQL Server (Version 6,5, 7.0, 2000, 2005, 2008), and some Development Work in Oracle, MS Access, DB2, Informix, MySQL, PostGres, Analytics in Excel. DataMart and Cube Design SSAS, Cognos Transformer, Data Mining (KDDI), Web/Text Mining, Data Mart, IIS, ETL, Designed, OLTP (Operational data) and OLAP (data warehouse) databases using Erwin and Embarcadero for regular ER, DWH Design implementing both methodologies for Ralph Kimball (Bottom up) and Bill Inmon (Top Down) modeling.

Industries:

Supply Chain, Leisure Reservation Systems (Car, Air, Ski, Cruise packages etc.), Education, Real Estate, Call Center, Marketing (Educational, Apartments), General Accounting for those industries.

PROFESSIONAL BACKGROUND

REALPAGE, Carrollton, TX Feb 2011 – Present.

A leading provider of on demand (also referred to as Software-as-a-Service or SaaS) products and services to apartment communities and single family rentals across the United States

BI Development Manager and Lead Architect

Reporting to a senior VP, I am managing and leading a team of database architects for the data warehouse design and data mart designs (Cubes) for different business areas. My team has an ownership for creating and managing ETL logic and mapping documentation with prototype queries for ETL developers, report writers and dashboard developers. As a leader I manage people, processes and contribute to several technical areas in addition to performing final reviews to the architected models and development patterns. Our new Enterprise Data warehouse is designed using Bill Inmon’s approach. Several Cube design across different business areas including Real Estate Residential Rental management, Marketing, Finance (Accounting), Market Analysis, Candidate Screening, Call Center etc. Working with TFS (Project Tracking, Source Control, and Maintenance), SQL Server, Oracle, IBM Cognos, Microsoft OLAP.

EDUCATION CONNECTION, Boca Raton, FL Feb 2009 – Feb 2011.

A subsidiary of Kaplan University.

BI Manager and Database Manager.

Data Warehouse Development and Maintenance: (OLAP)

For Orginazation’s KPI undertook development of new data warehouse using Ralph Kimball’s approach with dimensional modeling with multiple data-marts. Most data marts used star schema and some snowflake schema using both DSV and RDBMS views. For data promotion to staging and data warehouse wrote and scheduled several ETL processes using SSIS (with .NET C#) that extracts data from different Operational data sources (ODS) available in the form of RDBMS, Flat Files, Excel, XML, Accounting (Great Plains). Worked with SSAS in VS 2008 and VS 2005 for creating, processing and scheduled processing of cubes from data warehouse. Created customized, MDX queries for the cubes and optimized MDX queries with a good knowledge of MDX queries. Handled, targeted dimensions against time series, geo boundaries’, and hierarchies in order to achieve an ultimate dashboard/score card experience. In addition, many cube reports with drill down feature were created with charts and graphs using SSRS and made available on the web server using Web Viewer Control. Secured the cubes with roles and membership.

SKI.COM, Aspen, CO April 2005 – Aug 2008.

Offers Ski Tours and Packages to Travellers annual sales of 70 Millions

BI Architect consulting (non-office hours) Datacenter Manager. Acted as Database Designer for OLTP and OLAP. Data warehouse design and MDX Cube Processing. Running Extensive Scheduled ETL from multiple sources to the warehouse using SSIS. Designed warehouse using the Ralph Kimball Approach using the Dimensional modeling mostly star schema. Created SSRS Reports using VS 2005, VS 2008 with back-end as SQL Server 2005. Model data warehouse using start schema. Wrote and Scheduled many ETL processing using third party data by utilizing web services to Stage. Created MDX Cubes and worked with MDX queries for proper reporting data. Managed and handled errors in Processing for Dimensions, Partition using Integration services. Modeling software CA (Formerly AllFusion*) Erwin data modeler. Achieved measuring many KPI’s for the company.

PARKER INTERNATIONAL, Miami, FL Apr2003–Feb 2009

Hospitality procurement firm with over $55 million in annual sales

Application Development Manager. Managed and programmed large scale web based application development projects from concept to completion. Main responsibility was to oversee and get engaged in all tiers of application ensuring the famous SDLC.

Deployed multiple applications in SQL Server 2000, 2005 on Mass Storage SAN.

Microsoft Clustering (Active/Active, Active/Passive) and for some applications SAN Array Mirroring as a fail over.

Provided Full Replication Support, Plus a Co-Location a Mirrored Site with Transaction Log shipping.

Most of the script was written by me to reduce overhead usually caused by third party software.

As a strong database Manager and Developer I got Involved in every phase of program coding that includes but not limited to .NET Component Coding (Web Services, XML), Database Modeling and Design using Erwin for a large scale data.

Proficiently coded Stored Procedure, Triggers, Views, complex queries for reports

Managed all aspects and overseeing all areas of disaster recovery, testing, patches, enhancements, maintenance, trouble shooting and ensuring application availability by monitoring network and application services.

Several scheduled self scripted database tasks for monitoring, optimization and performance tuning.

Configured restrictive permissions on SQL Server installation directories as well as role based database security model for proper threat detection/prevention plus validated many check list from Microsoft Security Developer Center.

Ensured suitable database server model for proper Back-ups/Restores from tape and disk media

Developers Stored Procedure Tuning, Index Tuning, Table Statistics Tuning, Database Versioning, DB Object Versioning

Integration Services (SSIS-DTS) and all phases of ETL (some with VB Scripting and some with T-SQL Scripts) from wide variety of sources.

RIGHTFORCE, Fort Lauderdale, FL May 2001 – Apr 2003

Leading provider of contact center, e-commerce and enterprise workforce management solutions

Database Developer (Lead) Architect. Manage the architecture and developed state of the art web-based N-Tier architecture application from writing requirements to completion, teaming with 5 Developers adhering to the Microsoft Solution Framework (MSF) using the .NET framework. Operational (OLTP) Database Design using Embarcadero. The web based application used both NT-Challenge Response Security and Form based Active Directory Security with multi tiered COM based model using the SQL Server as the back end and IIS for the front end. As a leading role my responsibility was not limited to architect and documentation, but I also involved in writing code and create templates and proof of concepts for the developer in all the tiers of application.

HOTELWORKS.COM, Coral Gables, FL Jan 1998 – April 2001

Hospitality procurement firm with over $200 million in annual sales

Software Development Manager . Manage and programmed application development projects from concept to completion, directing activities of 7 developers adhering to the Microsoft Solution Framework (MSF) and Windows DNA specifications. Specifically, conduct needs analysis with clients to understand the vision they want to see realized. Determine project scope and budget, and establish project’s technical and economic feasibility. Managed, designed and deployed new Database schemas, supervising content management and helping to develop technological solutions that completely meet client expectations. Involve in every phase of program coding that includes but not limited to Visual Basic Component Coding, Database Modeling and Design using Erwin, ASP Coding using VBScript and JavaScript, SQL Server (Stored Procedure, Triggers, Views, reports) Coding, as a senior programmer besides just being a manager. Cultivate existing accounts and help develop business by identifying potential clients and demonstrating the benefits of new media. Ensure that company remains up to date with new technologies.

ACXIOM CORPORATION, Conway, AR Aug 1996 – Jan 1998

A provider of business intelligence infrastructure; 1,500 employees and over $1 billion in sales

Sr. Software Engineer Associate in Database Marketing Solution.

• Designed client / server application life cycle and helped develop client / server applications using Microsoft development tools Visual FoxPro, VC++, VB, MS SQL Server, Visual SourceSafe, and MTS.

• Identified conflict areas and executed cost-cutting procedures, lowering operational costs by 8 percent.

• Integrated computer system with company’s IBM mainframe, increasing business unit’s production by 50 percent.

• Acquired experience with other technology tools, such as Crystal Reports, Citrix Thin Client, and mainframe companies’ proprietary integration tools.

• Earned “Associate of the Quarter” Award for spring 1998 for developing software that reduced company’s operational cost and increased production.

CERTIFICATION AND TRAINING

Trained in IBM Cognos Transformer

Trained IBM Cognos Framework Model

Microsoft Certified Professional (MCP)

Microsoft Certified Solution Developer (MCSD)

Microsoft Certified Database Administrator (MCDBA)

Trained in Microsoft Appliances for CDC (Dell and HP)

Trained in Microsoft Appliances for a DWH (Dell and HP)

Microsoft Certified Business Intelligence IT Professional (MCITP)

EDUCATION

M.S.E., Computer Systems Engineering, 1996.

University of Arkansas (http://www.engr.uark.edu/), Fayetteville, AR

Thesis included research on 3-D biomedical image processing for MRI images.

B.S., Computer Science, 1993.

University of Arkansas, Fayetteville, AR

Key Courses: Database Design and Management, LAN Architecture, OOP (C++)

Final project included dimensional database design for a data warehouse in an inventory control system.

M.S., Applied Mathematics, 1990.

University of Balochistan (http://www.engr.uark.edu/), Quetta, Pakistan

Fast Fourier Transform for Earth quack data mining

Contact this candidate