EXPERIENCE

• Confidential provides hands-on services and leadership in data warehouse design, development and deployment, including: ETL, Dimensional 3NF Data Modeling, SQL/View/Semantic Layers and Business Intelligence.
• Advanced Teradata Certified Professional under Teradata version 12 and VR25. Spent 8 years of last fourteen years architecting and building data warehouse solutions on the Teradata platform and 5 years on Oracle. Also, spent the twelve of those years designing and creating Business Objects' universes and Web Intelligent reports.
• Confidential is an accomplished Senior IT professional with a background in data warehousing, business intelligence, software design and full life-cycle development. He excels at translating business requirements from all levels in the organization into proven technical solutions that generate value and drive costs lower. He adapts easily to a client's business culture and technical infrastructure to provide strategic solutions at the right time with the right fit. He leverages over twenty years of successful experience with application design, creation, implementation, and support. He has participated in all phases of application development including analysis, design, prototyping, construction, testing and rollout.

KEY SKILLS

• Experience in designing logical and physical data models.
• Experience in Data Governance, Information Management, and related tools.
• Expert skills in Business Intelligence tools and technology Able to design, build, and support robust reporting solutions and Teradata semantic layers.
• Expert proficiency in SQL development, maintenance, and support.
• Skilled in development and use of Fastload, Multiload, TPump, Teradata SQL and BTEQ Teradata utilities.
• Experience interfacing with business users to understand business requirements, technical specifications, and ETL mapping specifications
• Proven track record of successful implementation of all project life cycle stages from requirements gathering through implementation and enhancements.
• Proven leadership skills in roles including Project Management, Team Coordinator, and Technical Oversight. Experience involving planning, resource allocation, and risk control.
• Deep experience in the Business Objects software product line including Business Objects XI R2 CMC and Administration.
• Skilled in various database environments, including Teradata, Oracle, Microsoft Access, MS SQL Server, and SAP BW.
• Strong inter-personal, analytical, and problem solving skills.
• John is a dedicated team player with the ability to get results in the appropriate time frames he can also work independently and is resilient and determined.

Confidential

• Helping to establish a data governance program.
• Designing/implementing data governance policies and procedures.
• Establishing rules and standards for data definitions, terms, and fields.
• Providing guidance during the selection of Business Glossary and Data Dictionary tools technologies.
• Helping the team to identify all existing data repositories.
• Inspecting and documenting vital aspects of the current data structures.
• Partnering with the development team members to learn about existing systems
• Started a logical Erwin 9.5 model of all existing data repositories. Validating, refining, and expanding the model after verifying assumptions and partnering with subject matter experts in order to improve the model and to further define it.
• Helping to develop project plans, scope work of documents, business cases, and charters.
• Collaborating with business and information technology personnel at all levels including the senior management team and technology resources along with the CIO to identify requirements and resolve issues.

Confidential

Selected Accomplishments:

• Managed the Enterprise Data Model and related processes, so that improvements are applied correctly and the model remains accurate current.
• Applied changes to the Enterprise Data Model.
• Created Logical Models and 3rd Normal Physical Models using Erwin 7.x
• Translated Physical Models into Physical Structures.
• Collaborated with business and technology resources to identify business requirements
• Developed Unix-based tool that will automatically walk through huge volumes of data and profile it. This is a mission critical need, so the end-users will know what is available.
• Created and provided reports from the model
• Investigated and determined needed steps to upgrade the model to Erwin 9.x
• Reviewed and analyzed SQL and Tables to identify improvements to indexes, partitioning and joins. Built and Implemented improvements.
• Environment: Erwin 7.x, Teradata Tools and RDMS V14 , Unix, Windows 7 with Office 2010

Confidential

Selected Accomplishments:

• Collaborated with business and technology resources to identify business requirements
• Profiled the data
• Helped to design and produce ETL mapping specifications and resolve ETL roadblocks
• Involve in Unit testing, Integration testing, System testing and code reviews
• Created one conceptual model, four Logical Models and two 3rd Normal Physical Models using Erwin 8.x
• Used Erwin Model Mart to share, organize, and version control the models
• Resolved with modeling challenges using techniques like Inversion Entry Keys, Alternative Indexes, and Secondary Indexes.
• One of the logical models is a prototype for more flexible entities such as super-type/sub-types.
• Used a standard development life cycle that included learning about business flows processes and then profiling data during the effort to build the conceptual and logical models.
• Conducted brain storming session to develop out of the box solutions.
• Involved in the creation and maintenance of the logical and physical data models
• Involved in the development of standard Teradata Erwin Template
• Reversed engineered SQL Server source database into Erwin to better understand the data relationships and model.
• Translated Physical Models into Physical Structures.
• Reviewed and analyzed Teradata SQL and Table, identify improvements to indexes, partitioning and joins. Build and Implemented improvements.
• Helped the team to build standard domains and name glossary
• Created two Semantic models.
• Did Dimensional Data Modeling Logical and Physical
• Creating views that provided a virtual Star schemas
• Designed and created aggregate tables for dashboard applications
• Transformed Erwin models into Business Object's universes. This allows for efficient knowledge transfer to the Business Intelligence team.
• Developed efficient Teradata SQL code to obtain data from the data warehouse
• Re-designed over 30 reporting views in short time frame to ensure that a revised ETL process could be delivered on time to the business.
• Translated business requirements into technical specifications
• Analyzed the source systems to find the required tables and elements.
• Assisted the team in the design and implementation of database solutions
• Performed impact, problem, and root cause analysis
• Provided backup DBA support
• Created tables and views
• Collected Statistics for better performance of the queries.
• Used Teradata Explain to analyze and improve query performance
• Granted and Revoked Roles Profiles
• Teradata ETL Development
• Used Putty to access the Unix environment
• Wrote BTEQ load scripts
• Used Teradata Utilities to load data from Flat Files to Teradata
• Provided guidance on the Teradata platform and architect.
• Identified the process improvement areas.

Environment: Business Objects XI 4.x, Erwin 8.1, SQL Server 2008, Teradata Tools and RDMS V13 , Windows XP with Office 2010, and UNIX.

Confidential

Selected Accomplishments:

Data Modeling

• Created 5 Logical Models, 5 Physical Models, and 3 subject areas using Erwin 7.x
• Resolved with physical implementation challenges using techniques like Aggregate Join Index, which was used to provide yearly tax totals by county.
• Organization all existing data models into a Metadata Repository.
• Trained employees on how to use Erwin and do perform data modeling.
• Analysis.
• Conducted work sessions with business users to understand business requirements.
• Translate business requirements into technical specifications
• Analyzed the data warehouse to find the required tables and elements.
• Performed Source to target data mapping on over 20 different subject areas
• Performed impact, problem, and root cause analysis
• Database Administration
• Created and tuned around 100 tables including indexes
• ETL Development
• Used Teradata BTEQ, FastExport, Mload, and Oleload to load hundreds of tables.
• Revised and supported an ETL stream containing MLOAD and BTEQ code that loaded Federal IRS EFILE data to over 300 tables.
• Business intelligence
• Provided technical oversight on Business Objects applications.
• Developed efficient Teradata SQL code to obtain data from the data warehouse
• Designed and developed over 200 Business Objects' Web Intelligence reports along with 10 universes.
• Designed and implemented Business Objects architecture, including hardware and software requirements, CMS information and security
• Mentoring
• Provided hundreds of hours of training and coaching.
• Environment: Business Objects XI 3.x XIR2, Teradata Tools and RDMS V2R5 and V12 , Windows 2003 with Office 2003, Windows 2003 servers with IIS, and UNIX.

Manager of Business Intelligence at MEDecision a provider of software, services and clinical data content to health care payer organizations .

Selected Accomplishments:

• Key Achievement. Worked as outside consultant then hired to manage their Business Intelligence effort.
• Project management. Overall end-to-end project responsibility. Participated in project starting with a feasibility study, to completion. Obtain and manage resources, including people, software, hardware, and funding.
• Team management. Hired 3 staff members. Transformed the staff into a team of top-notch BI gurus.
• Leadership: Provide leadership during the full project development cycle from feasibility study to implementation. Obtained and manage the required resources, which included people, software, and hardware.
• Worked with external clients to build custom business intelligence solutions within given time frames and resource constraints.
• Designed and managed a business intelligence environment that produced applications that were sold to external customers.
• Handled a conversion effort from BO 6.5 to XIr2.
• Documentation: Help to develop a user manual.
• Environment: Business Objects 6.x XIR2, Oracle 9 10g, RDMS, Oracle Pl-SQL, and Windows 2003 with Office 2003.

Technical BI Lead Consultant at Basell manufacturer of plastic raw materials .

Selected Accomplishments:

• Key Achievement. Hired to do Business Objects development then utilized to design and deliver a completed data warehouse implementation.
• Developed architect a Brio 6.x reporting system using a MS SQL Server Data Mart with data being extracted from a SAP BW OLAP data warehouse. The project team was focused on building a Global SAP system.
• Gather client requirements and perform gap analysis.
• Review business processes.
• Involved in designing and developing a complete reporting system, data mart, and ETL functions.
• Designing and creating SAP Bex reports.
• Working closely with the technical team and decision-makers to understand the business and technical requirements.
• Help to resolve and manage issues, problems, and challenges to keep the project on track.
• Leadership. Supervise the work of one Brio developer and ETL coder.
• Environment: Brio 6.x, MS SQL Server 7.0, SAP BW and Windows NT/98/2000.

Senior Business Intelligence Consultant on a Teradata project at U.S. Navy as a Developer/Architect.

Selected Accomplishments:

• Key Achievement. Drafted to help start-up this project based on the work done on the Air Force project.
• Data analysis/architecture. Translated business requirements into technical specifications. Analyzed the current databases to find the required tables and elements.
• Designed, implement, and supported a business intelligence environment.
• Leadership. Oversaw and coordinated the front-end definition phase.
• Environment: Business Objects 5.i, Cognos 6.6, Informatica 5.1, Oracle 8i, Teradata Tools and RDMS, Windows 2000 with Office 2000, and a Windows 2000 server with IIS.