We provide IT Staff Augmentation Services!

Manager Of Edw Resume Profile

4.00/5 (Submit Your Rating)

A computer science graduate who worked three years for a financial firm ... Worked four years for Teradata as a Senior Systems Analyst. Worked as a Senior IT Consultant/Project Lead on Multi Million Dollar Data Warehouse projects for IBM Global Services. Worked as a Project Manager/ Team Lead at Warner Brothers implementing a Large Scale Teradata Data Warehouse. Worked for the World's Largest Bank leading the Data Warehouse Team in North America. Went on to work at eBay as a Senior Business Analyst providing solutions on their Teradata Data Warehouse. Joined a Consulting Company on the East Coast and worked as a Senior Data Warehouse Lead on three various projects. Went on to join the Data Warehouse Team at Frontier Communications and assist them in the implementation of their new Teradata Data Warehouse environment. Served as a Sr. BI Data Warehouse Lead for an MDM project with IBM Global Services in Denver. Took over as Director of Data Warehouse for Hyundai Corp. North America. Excellent in Information Systems, database development/management, Data Warehousing, and Business Analysis, with respect to problem solving. Communicates effectively with clients and users regarding their needs, possibilities and solutions to various complex problems. Seeking a position to lead a team as a Data Warehouse Manager, Data Warehouse Director, BI Manager, or similar position.

COMPUTER RELATED KNOWLEDGE EXPERIENCE

  • Hardware: INTEL FAMILY, IBM RISC 6000, TERADATA, AT T/NCR 3600/5100M UNIX SYSTEMS,
  • SUN 5000/6500/10,000, SMP MACHINES, AS 400, EMC SYMMETRIX RAID V
  • DISK ARRAYS.
  • Networks: TCP/IP, DHCP, SNA 6.2, NOVELL, WINDOWS SERVER 2003/2008.
  • Operating Systems: WINDOWS 3.1/95/98/2000/NT/XP/VISTA, DOS Vs.5.X/6.2, IBM AIX 4.2/4.3, HP-UX
  • 9.0/10.20, SUN SOLARIS 2.51/2.60/8.0/9.0/10.0, AT T UNIX 2.02/3.XX, MP-RAS
  • 3.00.XX, SYSTEM V.
  • Databases: Teradata V2R5/V2R6/TD 12.0/TD 13.1, RDBMS, DB2 UDB EEE, Informix,
  • Oracle 8.i/9i/10.x/11.x,/12.x, Sybase, SQL Server 2000/2005/2008, MS Access.
  • Software: Microsoft Word/Excel/Access, Crystal, Business Objects XIR2, Informatica 8.6.1/9.5.x, Cognos 8.x,
  • MicroStrategy 9.3.1/9.5.x, Brio, Data Stage 7.5,. PL/SQL, SQL, Toad 7.x, Erwin 3.5, Control-M, TNG,
  • Reporting Tools: Cognos 8.x, Micro Strategy, BRIO/Hyperion Intelligence v6/8.2/8.5, Essbase 7.x, OBIEE, Business
  • Objects XIR2, Crystal.
  • Languages: UNIX Shell Scripting, C, C , SQL, PL/SQL.

EMPLOYMENT HISTORY

Confidential

Recruited to take over role as Manager of EDW Enterprise Data Warehouse. Directed the EDW Dept and reported directly to the CIO of Hyundai North American Operations. Evaluated the EDW North American Operations for HQ, provided enhancements, and recommendations for improving North American Operations. Developed strategic plans, policies, and procedures for the Data Warehouse Dept. Successfully conducted several major high profile projects for HQ/EDW. Worked with Multi-National operations in implementing proven EDW enhancements for the organization. Advised senior management on strategic decisions with the Data Warehouse Dept. on how to meet business goals and objectives for the North American organization. Recruited, trained, supervised and lead the EDW Dept.

Responsibilities:

  • Lead the EDW team in major projects, development and support.
  • Performed project oversight for independent review and analysis.
  • Applied project management knowledge and expertise to gauge system performance and assess risk.
  • Provided stakeholders with project status and outlook for success, and recommend project improvements
  • Prepared 8.2M departmental budget for Data Warehouse Dept. Included Data Warehouse operations, existing projects, facilities, and new organizational changes.
  • Co-developed root cause analysis process to get beyond symptoms of mission critical services.
  • Identified underlying source of problems. Recommended solutions that were approved by CFO/CIO, successfully implemented, and highly effective.
  • Involved in corporate HQ project planning, architecture, and design for Global Dashboard Reporting.
  • Interacted with the business users, Analysts, Data Warehouse Developers on major projects.
  • Created a supportive team environment that was defined by collaboration and knowledge sharing within the North American IT organization.
  • Active member of Enterprise Change Control Advisory Board that established and implemented structured change review process for new technology and application changes affecting production systems.
  • Proficient in understanding business processes/requirements and translating them into technical requirements.
  • Developed best design concepts of Data Warehouses and data base to meet BI solutions.
  • Perform investigations and made appropriate suggestions on various services to meet the Data Warehouse development efforts.
  • Managed the tasks of directing, organizing and leading projects, as well as in the implementation of new BI software tools and systems.
  • Responsible for evaluating and selecting database/data warehouse components like ETL software, reporting tools, relational database management systems, and database design solutions.
  • Proficient in building BI environments according to specifications. In-depth knowledge of relational database structures, theories, principles and practices.
  • Additional experience in SDLC system development life cycle and business systems development methodology.

Confidential

Confidential

  • Worked as part of an initial project with the IBM Tiger Team to put together a 20 Million soultion document proposal for the client. Composed high level requirements for the Teradata Data Warehouse. Responsibilities included delivering a solution strategy, and implementation road map for the Data Warehouse, including enforcement of MDM Master Data Management for the clients Finance HR
  • functions. Additional responsibilities included leading a Data Warehouse team to provide the Reporting/BI strategy in the implementation process and be the primary person of contact for this function. Front end included MicroStrategy implementation.

Confidential

Worked as a Senior Data Warehouse Consultant SME on a 7.5M project pertaining to leading the migration from the existing Teradata Data Warehouse and ODS to a new Teradata data platform. Lead the Data Warehouse team in research and analysis of migrating the existing ODS/DW to the new environment. Tasks included analysis of the client's data, ETL's, applications, reports, and processes from the previous environment, and implementing into the new Teradata Data Warehouse. After successful migration of the new Data Warehouse completed, provided the Data Warehouse team with specific recommendations in migrating several additional Oracle environments in the ODS to the new Teradata environment. Successfully implemented recommendations, retired several existing applications in the ODS, and saved the client a significant amount by implementing the solutions.

Confidential

Worked for a Consulting company leading a team on several various Data Warehouse projects. Responsibilities include analyzing business requirements, developing and implementing ETL feeds, and designing new features into the Large Scale Data Warehouses. Tasks include reviewing the data model structures, gathering data requirements, and BI reporting using Business Objects and Micro Strategy. Additional responsibilities included Project Management, developing new business processes and integrating the new processes into the existing Data Warehouse, as well as giving the organization strategic direction for future implementation pertaining to the Data Warehouse. Clients included USDA, FIMA, and Telecomm.

Confidential

  • Worked for a Multi-Million Dollar Teradata Data Warehouse Project analyzing, developing and implementing the ETL's feeding into a Large Scale VLDB Teradata Data Warehouse. Responsibilities include project management of developing and implementing procedures for a Large Scale Terabyte Databases using Teradata. Tasks included reviewing the data model structures using ERWIN, developing
  • new ETL procedures using PL/SQL. Additional responsibilities included Project Management, developing new business processes and integrating the processes into the existing Data Warehouse, as well as giving
  • the organization strategic direction for future implementation pertaining to the Data Warehouse. Front end reporting tool included MicroStrategy.

Confidential

  • Worked for a Multi-Million Dollar international company developing and implementing a Large Scale VLDB Data Warehouse project. Responsibilities included project management of developing and
  • implementing procedures for a Large Scale Terabyte Databases using Oracle. Tasks included reviewing the data model structures using ERWIN, developing new ETL procedures using PL/SQL and SQL loader.
  • Additional responsibilities included Project Management of a team composed of nine people managing
  • business processes, integration, database design, and IT analysis, along with future planning of life cycles. Project Management implementation included proposing, developing, and reviewing of current procedures, as well as giving the organization strategic direction for future implementation.

Confidential

Worked for a Fortune 100 company developing and implementing a Multi-Million Dollar Data Warehouse project. Responsibilities include developing/implementing Large Scale Terabyte Databases using, Teradata, Oracle, and DB2 UDB EEE. Tasks include reviewing the data model structures using ERWIN, cleansing, migrating, and transformation of client data from various sources into the newly developed Large Scale Data Warehouse. Additional responsibilities included developing business processes, integration, networking, database design, IT analysis, along with future planning of life cycles and Project Management implementation which includes proposing, developing, reviewing and delivering of new solutions and procedures, as well as giving the organization strategic direction for future implementation. Reporting tools included MicroStrategy, Informatica and Business Objects.

Confidential

Managed a team of IT personnel for the US Navy. Project pertained to operations, implementing infra-structure strategies, in addition to providing decisions in meeting objectives for the US Navy. Additional duties included communicating and working closely with the client in coordinating the test and production systems, as well as reporting to the Project Director of IT.

Confidential

  • Worked with clients as a Senior Level Project Lead for IBM Global Services with Fortune 100 companies facilitating Data Warehouse projects/contracts. Responsibilities include developing and implementing
  • Large Scale Terabyte Databases using ORACLE, DB2 UDB EEE, and Teradata on 100M dollar systems. Tasks included developing new data model structures, cleansing, migrating, and transformation of client
  • data by importing data into newly developed Large Scale Data Warehouses. Additional responsibilities included software/hardware integration, networking, database design, IT analysis, fallback, along with future planning of life cycles and implementation. This included developing new automated processes and
  • procedures, as well as giving clients strategic direction for future implementations.

Confidential

  • Extensive experience in integrated systems implementation and maintenance.
  • Excellent problem solving and communications skills pertaining to technical problems.
  • Experience in data mapping/architecture, decision support systems, PL/SQL, Informatica, Erwin, Oracle, SQL, and Siebel.
  • Essential Function: Implementation of Large Scale Data Warehouse infrastructures for Fortune 100 companies to meet their goals and objectives.
  • 5 years of experience in preparing and presenting basic software training information for clients.
  • Personally have supervised a team of up to 16 people. Team included Systems Analysts, DBA's.
  • Integration Engineers, etc. Tasks included developing and support of Large Scale Data
  • Warehouse environments. Developing front-end applications for CRM/ERP environments.
  • Personally participated in the business process of re-engineering client's front end applications.
  • Supervised the Data Warehouse team in developing new data models pertaining to Siebel/Oracle
  • database.
  • Developed and submitted SOW's Statement of Work and RFP's for clients pertaining to project
  • specifications and system requirements.
  • Facilitated the end-user procedures and development.
  • Managed change control pertaining to the Data Warehouse.
  • Provided ad-hoc and formal application training for the client pertaining to Siebel CRM/ERP.
  • Documented all tasks and procedures related to project.
  • Developed and maintained Production and Test environments for the client.

Confidential

  • Served as a Senior Systems Analyst providing solutions regarding highly integrated SUN 10,000
  • systems over a 475M network. Function of the network was to provide the customer with peer-to-peer
  • IP/ATM communications. Installed, configured and managed multiple Sybase databases for the integration/testing team on several Sun 10,000 machines as well as for the production teams. Implemented
  • Client/Server technology and provided solutions. Tasks included hardware integration, networking, data communications, database analysis, data fallback, along with implementing RAID V technology

Confidential

  • Served as a Systems Analyst providing solutions regarding highly integrated parallel processing systems. Solutions provided included hardware integration, networking, data communications, database analysis,
  • and data fallback using RAID V disk array technology. Responsibilities included providing customers with solutions to highly complex integrated parallel processing systems. Problems included system hardware/software, operating systems, networks, data communications, and database resolution. Additional duties included remote and onsite support assisting customers with applying solutions to their systems and networks.

Confidential

  • Served as a Systems Engineer, operating and maintaining an IBM RISC 6000 token ring network, a PRIME 4150, along with a Novell network. Provided solutions for highly integrated problems regarding hardware/ software, operating systems, data communications and networking.
  • Responsibilities included systems operation, data communications, and technical support in maintaining the systems hardware and networks. Additional duties included software/hardware integration, networking, and technical support in providing solutions to customers with their needs.

We'd love your feedback!