Paul Vincent Lewis
Marina Del Rey Ca. 90292
ac5bqk@r.postjobfree.com
SUMMARY:
Paul has 15 years of experience as Project Professional including Analytical, Management, Sales and Technical.
Ability to define, communicate and fulfill the project’s goals and break complex issues into manageable parts.
Proficient at delivering a broad range of mission-critical business solutions, including data center consolidations / relocations and business continuity, architecture, and storage plans.
Results driven professional possessing BS and MBA (Honors Graduate 3.91 GPA), in-depth understanding of emerging technologies and their commercial applications.
Data Governance, Data Integration, Data Warehouse, Master Data Management, Data Modeler, Business Intelligence lead
Expertise in driving motivated teams to deliver complex systems Implementations and assessment projects on time and under budget.
Extensive experience in Business Intelligence and statistical analysis while, Designing, Developing and selling Infrastructure Management, Data Warehouses/Data Marts, Decision Support Systems, providing enterprise web application integration/development and implementation of projects involving heterogeneous platforms.
Excellent Electronic Data Capture skills along with strong Security and Identity and Access Management experience with in-depth MFA
Building relationships via sales and analysis. This experience has been used consistently to transform disorganized, inefficient, disparate application systems and data into a smooth running warehouse. These Fortune listed companies include Hewlett Packard, GE Aircraft Engines, Dell, Bank of America, Kaiser, WellPoint, UC Irvine Medical Center, USC Hospital, Arco and Nissan with others listed within my resume.
Extreme BI and data architect with strong experience in developing and designing scalable BI Architecture
AREAS OF EXPERTISE:
Pre and Post sales, Professional Services, Training
Cognos, Microstategy, Business Objects, Web Focus, Workday reporting
Software Sales – pre-sales, lead generation, prospecting, client relations
Infrastructure planning Architecture
EDI Development and standard Selection
Microsoft BI an, Office /SharePoint integration and development Project Management – Full systems project life cycle (SDLC), Object Oriented Methodology
PMO PWA, Microsoft Project, Niku, Clarity Work bench, PMI Candidate
Supply Chain Management, HIPAA Solutions-business Distribution, Manufacturing Systems & Location Based Services
EDUCATION/TRAINING
Hadoop/85IBM via HP Certification Candidate 2016
SAP Business Objects training 2013
Project Management Professional Certification Candidate 2012
University of Phoenix, September 2009-- MBA Masters Business Administration
California State University Long Beach, December 1985--Bachelor of Science
Mount Sierra College, October 1995--Diploma\Certification of Completion
Information Builders Inc. 1998-2000
Cognos Corp. 2000, Ottawa, Canada System Engineer/Architect Boot camp
Business Intelligence University 2001, 2006,2007,2008
HARDWARE /SOFTWARE EXPERIENCE
BI TOOLS: Hadoop, Map Reduce Enterprise Application Integration (EAI),MQ Series Integrator, NEON e-Biz Integrator Enterprise BizTalk Servers, MS Business Intelligence Services (EBI), Platform, Enterprise Data Access (EDA), Cognos Now, Cognos Studios ver 8, Cognos Power Play Enterprise Server, Impromptu Web Reports, Decision Stream (ETL), OLAP, ProClarity (PAS) Enterprise, Transformation Server, Cognos Query, Cognos Now,Microstetegy, SQL Integration Services, Finance, MS Share point, Nucleus Query, Brio Enterprise, Business Objects, Hyperion/Essbase, Actuate, Cactus, Maintain, Micro Strategy, Focus/Web Focus, Ramis, ProMed/SAS, CorVu, Crystal Reports, Cats web, QSD PPG,Tableau, Viewpoint, SQLLIMS Reporting Portals
ETL/Middleware/Services: Informatics (Power Center/Mart/Suite 6-9),Hadoop framework, Map Reduce, TOGAF, Zachman, Anaconda Navigator,ODBC/JDBC/OLEDB SmartMart/CM/IWAYETL, Ab Initio, Informix (DataStage), EDA/SQL, BEA WebLogic Server V8, BEA WebLogic Portal™, BEA WebLogic Integration, Activemq, JMS, Net, Ruby,J2EE, IBM WebSphere MQ Integrator, Modify, Data Junction, Hive, Pig, Hummingbird, Accelerator, Fusion, CoSort/ETL v. 7.5.3 Websphere, Information Analyzer, QualityStage and Datastage
Databases: SharePoint, OLTP/RDBMS, DB2/UDB, Oracle 7.3/8.0,9i, 10G, 11G,Sybase IQ Multiplex, Nucleus 3.0, IMS, Progress, SQL Server 2000, 2005, MS Access, SAP BW, Perforce, Documentum, Hadoop, SharePoint 200,7, Field Glass, eBuget, Jura, Agile Scrum, Waterfall
Hardware: IBM 30XX, 4381, 370,ES9000, AS/400/LPARS, PSMS, AS/400Query, MVS/XA, VM/CMS, Solaris v.2.6/7 TSO/ISPF, FileNet, CICS, Oracle, Epic, Cerner Hardware/software, Davox, HBOC, Cycare3000, Microsoft NT Windows 2000, Windows 98/95, Unix, Cygwin, Microsoft, Automotive Mobil apps, CO Visual Basic, JavaScript/Applets, .Net Framework, J2EE, HTML, Active X (Parlay), SDLC, WALDO (Year 2000 Compliance Remediation), UnixWare, DB2/SQL, Erwin, RAD, PowerBuilder, HCFA, HIPAA X12 EDI, ICD-9, JCAHO, Data Warehouse/Data Mart toolsets PowerPoint, MS Project, MS Access, FoxPro, TCP/IP, SPSS, Novell, Crystal Reports, FrontPage, GUI, ICD-9, Application System Development, MS Office/MS Project, Rough sets, Com/Dcom, ERP, Tools, AllFusion Irwin 4.x, Silk Central
ERP/CRM: Enterprise Application modules including: SAP BW/HRIS eSales, Web Marke including Best Practise in several ting, Forecasting, Call Center, HRIS and data quality. Siebel 7 / eBusiness 2000, (Call Center), PeopleSoft 8 (various modules), Great Plains, JD Edwards, Ultimate Pro HRIS
Financial Management
Asset Lifecycle Management Cash & Treasury
Credit-To-Cash Financial Control & Reporting
Financial Analytics Governance, Risk & Compliance
Lease and Finance Management Procure-T
Human Capital Management
Advanced Benefits HRMS Workbench
Labor Distribution Payroll Oracle EBS
WORK EXPERIENCE: Blue Cross Blue Shield of Alabama (Hoover) January 2016-Present
Senior Business Intelligence Analyst/Developer/Architect
As a Senior Project Manager I have a complex role which includes assessing business trends and requirements, developing appropriate technology solutions, leveraging existing technologies, meeting operational needs, and selecting the most cost-effective technological solutions.
Essential qualifications I possess for this role are include agile and waterfall methodologies, clinical and technical expertise, computer proficiency, project planning, analytical thinking, teamwork, attention to details and and strong communication skills both verbal and written
Two years’ experience managing and assisting in installing, configuring, testing Hadoop ecosystem components.
Capable of processing large sets of structured, semi-structured and unstructured data and supporting systems application architecture.
Developed Metacenter repository solution which is loosely coupled open architecture
Extensive sql complex query creation, using multiple sql types
Provide support in the development of OBIEE components and solutions
Understand project requirements and work towards design and development of the plan layout
Develop and deploy dashboards, analytics and reports properly
Design and develop data modeling concepts using various data modeling tools like star schema and dimensional modeling
Design and place data in layers varying to physical, business and presentation
Work with administrators, users and analysts to maintain exchange of reporting requirements
Use the best practices of business intelligence to meet project and company objectives
Identify production faults and critical issues followed and troubleshoot them
Provide remedial measures to the production issues or process failure
Data Governance Center of Excellence to provide greater visibility for the corporate data assets
Utilized Business Data Network Data Governance monitoring, Remediation and lineage
Train the administration team on new OBIEE, BI and ETL tools
Defining the business objectives of your MDR solution (regulatory compliance, metadata driven process, standards management & governance)
Proof of concept definition for Metadata repository
MDR solutions evaluation (MDR technologies, business domains knowledge, services)
MDR selection for your organization's needs System Development Life Cycle (Requirement, Design, Development, Validation and Deployment)
MDR integration with other systems (e.g., SAS and EDC) through REST API
Change Management
Able to assess business rules, collaborate with stakeholders and perform source-to-target data mapping, design and review.
Managed and designed MS SharePoint site as data and artifact repository
Directed concurrent projects for Medicare Advantage program installation. Implemented 14 electronic interfaces with HIPAA EDI transactions, fulfillment vendors, and third-party software and analysis tools.
Provided project schedule or implementing Member Interaction Center creating and integrating 20 KPI/s and 60 Health Management Measures
Managed the Design of Business Intelligence Center of Excellence in several key disciplines such as Data Modeling, Project Management and major Data Governance environment
Managed the Development of 20 Operational Dashboards to management Measures and KPI in tableau
Assisted in the Designed and implemented a financial dashboard to track company's performance against annual budget enabling the management to make better, faster and more informed business decisions.
Managed the Reengineering of business rules engine for all operational and financial measures
Developing Prototypes, mock-ups and Wireframes for dishoarding and reporting as part of our business process management developed reports for Acquire to Retire fixed assets Business Objects universe reporting, utilized the Report to record process for month end process closing all the periods and import all the journals in GL from other modules such as (Payables, Receivables, and Fixed Assets
Profound knowledge of project management documentation and artifacts
Integrated and reported against all Jive, BluCre MMS, CCDR, CUBD and DB2 tables
Used WDB2 to develop and customize over 25 customized reports using prompts, filters and custom groups.
Managed the building MDM and Data Governance initiatives and requirements.
Designed a complete Microsoft SharePoint intranets site for all document in progress and completed Artifacts
Leveraged and integrated Electronic Data Interchanged (EDI) (820) transmissions and remittances then integrated data into EDW.
Develop, executed and maintain test scripts; wrote and executed queries to interpret test results and create test data scripts, develop and submitted test reports and status to project teams and I.S. Management
Demonstrated partnership and leadership skills good troubleshooting and decision making skills with strong management skills to lead and direct a global project team, including onsite and offshore.
All BCBSAL BI training
Oversee Cost, Risk and Reporting Management
Lead multiple initiatives to improve configurations and setups for current modules such as compensation workbench, manager self-service and absence management.
Hewlett-Packard (Client State Farm), Bloomington IL August 2012-January 2016
Business Intelligence Analyst/Architect
Responsible for supervising staff of 5 Business Analyst, 2 Technical Developers and 1 Security Administrator.
Done other duties such as coordinating activities, providing directions and scheduling work commitments.
Also participated in quality assurance programs in assistance with quality committees.
Responsible for business partner satisfaction especially for training and testing cycles
Implementing SAP ERP and CRM applications, reengineered and prototyped over 800 Business Intelligence reports for several modules including OTC: for reporting and analysis and greatly assisted in the design and improvement of the SAP ERP.
Oversee GRC Cost, Risk and Reporting Management
Managed internal projects improving project planning, resource management, and time billing using MS Project, SharePoint, TeamTrack, and iEmployee for prototyping and process simplification.
Led projects using PMI, Scrum, and rapid application development methodologies from inception through product launch.
Extensive sql complex query development based on multiple development
Oversaw Hadoop Team Evaluator and Integration Consultant, Hadoop Distributed File System full integration process to ensure that various analytics tools were properly utilized for the purpose of integrating Map Reduce.
Two years’ experience supervising teams installing, configuring, testing Hadoop ecosystem components.
Reached project goals which were to reduce redundancy and rework 24% by streamlining business processes and creating new reporting solutions that dovetail with HR road map and other IT initiatives.
Hewlett-Packard (Client Proctor & Gamble) August 2011-Auustg 2012
Business Intelligence Developer/Analyst
Led onshore/offshore resource team to establish Integrated Oracle EBS CRM and ERP IT environment which included SAP SucessFactors FICO.
Responsibilities included evaluating potential new hires as part of the hiring process, performance appraisals on a semi yearly basis and standardized team guidelines as well as procedures.
Developed a career development path for Business Intelligence consultants.
Managed development efforts (including report changes) in accordance with established change management protocols, providing consistency, accuracy, and appropriate oversight.
Ensured that proper analysis, design, and construction of the metadata through continuous prototyping demonstrations amongst project team, subject matter experts and executives.
Demonstrated strong knowledge of cross-functional business processes including; marketing, sales, service, finance, supply chain and manufacturing.
Ensured that business analyst generated effective and efficient monthly Dynamic Dashboard Documents and workday reports.
Develop, implement and deploy data warehousing and business analytical solutions
Install, upgrade and configure database solutions through OBIEE tools
Develop data access queries through Oracle BI tools
Develop and design dashboards, reports, ad hoc queries and analysis
Work in collaboration with data analysts, business analysts, other technical teams and business teams
Involve in ETL applications, data feeding, cleansing, archiving and re-modeling
Prepare documentation and give project performance feedback to the clients and the senior management
Interacted with various business user groups for gathering the requirements for Salesforce implementation and documented the Business and Software Requirements. Configured the Salesforce.com environment.
Acted effectively as point-of-contact on status of EDI transactions from internal and external customers internationally and integrated and analyzed data with Business Intelligence tools
Conducted and performed analysis of EDI transactions, document and produced metric reports.
Proficiently participated in resolving EDI issues related to customer and supplier EDI requirements.
Manned for the efficient processing of incoming and outgoing EDI messages including customer and supplier connections. Monitoring and administered the EDI system/application.
Excellent ability to perform data analysis with working knowledge of data dictionary and data mapping schemes
Extensive experience (7-10 yrs.) in implementing multiple development projects, data consistency and data comprehensiveness.
BI tool development with sql coding standards basic sql, PLsql and transact sql
Strong interpersonal skills and ability to objectively communicate and also solicit input from others Great listening skills
Provided direct technical support to the IT staff and/or ensure such technical support is provided. Identified such gaps and fill them. Facilitated or made decisions where the team is uncertain or divided.
SpectraFocre Technologies/Abbott Vascular, Temecula, CA Jan 2010- July 2011
Senior BI Analyst/Architect
Primary responsibilities included delivering the initiative for Business Intelligence foundational processes. Performed business analysis for Quality services division, Performed Gap Analysis, requirements developments
Heavy use of Quality Management tools like SAP and IBM
SAP GRC for access governance and enterprise risk management
Application development using a number of open sources including ActiveMQ, JBoss, JMS, Hadoop and Map Reduce
Worked with HRIS, payroll, and operational teams to identify areas for increased efficiency and productivity using standard analysis techniques such as data flow and workflow analysis.
Impact: Improved compensation analysis and reduced processing time for bonuses and raises 50% by developing new interfaces, streamlining approval processes and working with the development team to capture performance data in appropriate flex fields.
Developed project plans and managed the deployment and implementation of Cognos Data Warehouse hands-on leveraging of Cognos 8.4.1 components including Framework Manager, Data Manager, Reporting Analysis, Query Analysis, Metric and Transformer/Power Play. Perform data collection, entry, and statistical analysis.
Develop, execute and maintain test scripts; wrote and executed queries to interpret test results and create test data scripts, develop and submitted test reports and status to project teams and I.S. Management
Developed test cases for CAPA and Catsweb reporting applications using Silk Central, CaliberRM
Designed Micro strategy reports from SAPA EDW repository
Performed the setup of EDI software, testing and documentation, maintenance and troubleshooting, prepared and maintained reports and all other functions that are related with the EDI system
Deploy and maintained enterprise reporting platform (Cognos) and the supporting data warehouse.
Utilized Business Objects functions like cross taband drill methodologies in linking multiple data providers. Monitored and evaluated PeopleSoft metadata to develop BO universe to generate ad-hoc reports. Updated and remediate existing Business Intelligence scripts and Teradata applications to reflect changing business data requirements.
Extensive experience in writing and executing scripts for validation and testing of the sessions, data integrity between source and target database and for report generation.
Interact with the client and end user to collect the list of requirements
Prepare project layout and provide technical guidance to the development team
Install and configure OBIEE tools across multiple tools and versions
Develop data across layers - physical, business models and mapping
Develop and design data modeling concepts using OBIEE tools
Develop enterprise dashboards and reports using OBIEE Plus tools
Identify critical issues and processing faults to optimize BI dashboards and reports
Perform testing sessions for reports and dashboards and resolve process issues
Involved in loading of data into Teradata from legacy systems and flat files using complex scripts.
Leads the planning, analysis, design, implementation, maintenance, and control of the organization’s server-class databases.
Extensive sql development complex queries
Conducted thorough research and analysis of software systems to enhance performance and efficiency.
Conducted complex testing of software and systems by proper investigation of significant matters.
Suggested processes for improvement in existing widgets to provide ingested Intel ink content.
Implemented procedures for data storage management and modeling using Cloud base technologies.
Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.
Mapped data from SQL 2005 and Oracle 10g databases distributed ODS to target reporting portal
Coordinated with third party company to complete thermal imaging of Abbott Vascular Data Center and determine hot spots within the data center to enhance dispersion of equipment, avoid hot spots, and develop a more efficient data center
Perform functional subject matter expert business analysis roles for user community. Develop solid metrics and supporting dashboards to help others view the business in the context of current operations.
Managed development efforts (including report changes) in accordance with established change management protocols, providing consistency, accuracy, and appropriate oversight.
Developed statistical analysis for data flowing into ODS, BI cubes and sales tracker portals
Vistage International, San Diego, CA Feb 09– Jan 10
Manager of Business Intelligence/BA
Primary responsibilities included developing actionable data, creating data correlations that provide relevant conclusions, using Cognos Report Studio, Analysis Studio, Metrics Studio, and Event studio.
Developed project plans and manage the deployment and implementation of Cognos Data Warehouse hands on leveraging of Cognos 8.4 components including Framework Manager, Data Manager, Re3port Query Analysis, Metric and Transformer/Power Play.
SharePoint, Salesforce and office integration.
Assisted the company in it developing the HR platform consisting of a combination of tools from Salesforce and its partners
Developed a new employee Journeys application for on-boarding and on-going management and HR Helpdesk software,
Developed on top of the Salesforce Service Cloud customer service software, to provide a digital channel for responding to specific issues or questions.
Implemented the core components of Salesforce which included cloud objects, workflows, communities, collaboration, and analytics which were applied to many areas of the enterprise.
Provided analysis for potential members by preforming demographic analysis utilizing SAS, Crystal and SPFF. Analysis was performed on data from social media sites like Eloqua
Manipulated, mapped and managed data table and SQL quires in SQL server 2005. Created star schema using Cognos data manager
Setup several EDI standards including ANSI, EDIFACT, TRADACOMS and ebXML including multiple versions e.g. 5010 or EDIFACT version D12, 810 and 812
Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc.
Unitized Hive (HQL) and PIG for query standard statement in JDBC. Analyzed the current ticketing system to identify documentation issues that hindered compliance with global labor laws.
Utilization of SAP GRC module for access governance and Fraud management
Within the business processes monthly closing cycle utilized Report to record. This is month end process in which basically user will close all the periods and import all the journals in GL from other modules the reporting would then be uploaded to the EDW
Primarily used Ruby to write cloud computing applications.
Worked with cutting edge cloud technology using and Hadoop.
Communicated any issues with supervisor and participated in weekly meetings.
Developed hybrid cloud delivery model allowing for customers to choose the mix of public and private clouds to meet their individual needs.
Integrated and reported against all SAP financial modules including FICO, TR, IM and EC for Business Objects and Cognos reporting. Utilized the SAP Quality Management Module for data mining
Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
Creating and modifying MULTI LOADS for Informatica using UNIX and Loading data into IDW.
Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI and USI and NUSI and JI etc.) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
Prepared and delivered presentations to all ranks of the organization, including executive staff
Deploy and maintain enterprise reporting platform (Cognos) and the supporting data warehouse. When not actively involved in the technical aspects of this responsibility, serve as the subject matter expert for user community. Develop solid metrics and supporting dashboards to help others view the business in the context of current operations
Sql query development
Developed data governance and data management methodology and initiative
Manage development efforts (including report changes) in accordance with established change management protocols, providing consistency, accuracy, and appropriate oversights.
Ensured consistent delivery of a strong customer service experience for the user community through performance and response-time metrics, including SLAs.
Manage and mentor senior analysts to further develop their proficiency
Blue Line Planning/IBM/Cognos Corp, Redwood City, CA Aug 07- Feb 09
Project Manager/Business Intelligence Developer
Blue Line Planning is a Gold Partner of Cognos corp. and is a leading designer and implementer of Business Objects for Financial and Operational Performance Management Systems from SAP, Cognos, Business Objects and Oracle.
Primary responsibilities were the delivery of E-Business applications including ERP, CRM and SCM implementation using BI tools like BO 5/6 and some XI, Cognos 8 suite of software products.
SAP GRC for enterprise risk management
Integrated and reported against all SAP financial modules including FICO, TR, IM and EC for Business Objects and Cognos and workday reporting
Office, SharePoint application integration
Led the implementation of the e-business tax module by performing a GAP analysis, gathering the requirements, overseeing the design, configuration and customization of the various components, data migration and providing testing, training and post go-live support. Impact: Saved thousands in labor by installing all three tax components, integrating them with the company’s tax partner, and developing a fully functional tax architecture. The end result was a simple tax model that makes use of default values without extensive processing.
Open source application development using Hadoop, Mapreduce and JMS
Integrated Cognos Now appliance with other business intelligence tools within the Cognos suite including Cognos 8 as well as Cognos Planning.
Primary responsibilities were to provide proof of concepts and deliver an infrastructure using RUP/UML project life cycle methodologies.
Developed workbench dynamics which includes events, views and context data, cubes which accessed a variety of data sources.
Developed dashboards and dashboards objects to provide rapid insight to Key Performance Indicators.
Responsibilities also consisted of hands on Project management and implementation, configuration and maintenance of security, metadata modeling, cube development, application support and end user training.
Project success highlights includes a trip to the People’s Republic of China (Shenzhen) to implement a Cognos Now/Cognos 8 project for Ping An Bank and Insurance Company; one the Largest Financial Institutions in the World.
Excellent at writing sql code
Implemented Business Intelligence reporting and analytics for new products such as loans and insurance products, leveraged reporting with product profitability
Implementation also included Dell computers, Johnson and Johnson, Walgreen’s and Orbitz.
Kaiser Permanente, Oakland, CA Apr 04 – Aug 07
Project Manager/Senior Solution Design Architect
Managed development of all aspects of information systems architecture for KP’s major enterprise, divisional, and business area systems.
Reviewed and approved architectural aspects of portfolio projects within the CDP framework including compliance structures, metrics and processes. Managed and Administered the Enterprise Data Warehouse (EDW) associated with the Application System Delivery (ASD) and Requirements Development Management divisions.
Integrated EDI 834 transaction sets required for Benefit Enrollment and Maintenance document. Created database to enroll members into Kaiser healthcare benefit plan. The 834 transactions were specified by HIPAA 5010 standards for the electronic exchange of member enrollment information, including benefits, plan subscription and employee demographic information all loaded into the KPIT EDW
Supported TCRM (Teradata Customer Relationship Management) application. Responsible for TCRM administration, maintenance and provided the first line of support to Business users. Also worked with Teradata CRM GSC team to report, analyze and resolve any incidents with the application. Worked on TCRM Communication, Analysis, personalization modules. Managed TCRM application security, Metadata mapping changes, coordinate new installations and upgrades, baseline and benchmark testing and acceptance.
Develops and plans for the introduction of new technology in support of business initiatives and plans the migration off older technologies.
Participated in the development and specification for the organization’s systems architecture plans and infrastructure required to support them.
Doubled as Cognos Administrator for several BAPs responsible for installation, testing and support of Cognos Reporting.
Sql coding
Developed reports and presentations on technology infrastructure and new technology for all levels of business and technical management and staff.
Coordinated the development and presentation of KP’s information systems architecture and new