Business Analyst/solutions Engineer Resume
SUMMARY
- Seasoned Solutions Engineer with extensive experience in architecting, conducting high - level design strategies for implementing Enterprise Resource Planning (ERP), Siebel Customer Relationship Management (CRM), Analytics and Oracle Business Intelligence.
- Experience using Hadoop - (Installations, Upgrades and Patching) on multiple Operating Systems and environments (DEV, UAT and Production).
- Lead for IT solutions and installed software relative to those solutions, patched environments, and provided support for multiple environments.
- Additionally, he has constructed a complete upgrade strategy that covered the upgrade of Oracle Technology Stack based on Oracle's Best Practices.
- Has used the Oracle AIM, Agile, LEAN and other guiding methodologies for project governance and controls.
- Very well versed in analyzing and documenting solutions around the Oracle Technology Stack.
- Implemented ERP products like Oracle Financials now called Oracle E-Business Suite, CRM products such as Siebel and SalesForce.com, JDE, Siebel Call Center, Siebel Partner Relationship Management, Siebel Professional Services Automation etc.
- Exposures to Oracle RDBMS several releases, ODI and WebCenter Sites Content Management Systems.
- Has several full cycle implementations with Oracle RDBMS and others, WebCenter Sites, Agile, Ajax, Apache, HTML, J2EE, Java, JavaScript, WebSphere and XML
- Has been involved in constructing and coordinating system architecture design documents and refining them into clear and concise design documents that will satisfy client’s functional requirements.
- Experienced as Project Manager and Program Manager responsible for GAP analysis and facilitating solutions.
- Leads requirements gathering sessions for obtaining requirements and documenting solutions for the implementation and enhancement of IT Solutions.
- Eddie has excellent communication and documentation skills, is local to the Atlanta area, available for an immediate start.
PROFESSIONAL EXPERIENCE
Confidential
Business Analyst/Solutions Engineer
Responsibilities:
- Business analyst for Customer Connections a large, multi-year program that will implement an advanced customer experience solution and consolidate legacy billing systems and edge solutions leveraging CRM and Oracle’s technology stack to deliver the universal experience customers expect. Zachman, TOGAF are the guiding methodology used on engagements.
- Portions of the Customer Engagement & Commerce scope of Customer Connections will be delivered early in the program lifecycle to accelerate value to the customers and the company.
- The analyst plays a critical role in this program by developing subject matter expertise on specific functions related to reporting under the following customer related domains - Marketing, SAP Financials, Avaya, Siebel CRM, Azure, Java, Commerce, Billing, Oracle Cloud ERP technology systems for Customers.
- They support the development of the reporting solution from a functional and technical perspective on behalf of the program’s leadership and business unit stakeholders. Functional analysis includes defining business processes across jurisdictions, defining detailed business requirements, creating functional designs of new software components, configuring the software, defining testing scenarios, and executing test scripts.
- Technical development includes creating technical design documents, building, testing, and validating the reports/dashboards on the Oracle platform. Informatica is the tool used to move data into the new environment. All project related artifacts are stored using SharePoint.
Confidential, Charlotte, NC
Reports BI/Team Lead
Responsibilities:
- We are building a Siebel CRM Talent Management Systems (TMS) for one of the world leaders in banking. Data sources include legacy systems and sourced data from today's Human Resources demands.
- Hadoop, Confidential DB2, MYSQL and SAP Financials, Java. Oracle are a few of the sources that we get information from. (Installations, Upgrades and Patching) on multiple Operating Systems and environments (Siebel CRM, DEV (Linux), UAT (Unix) and Production (Unix)).
- My role as Team Lead for Business Intelligent reporting requires knowledge of current reporting needs and future reporting requests. OBIEE, OBIA, BI Publisher, Avaya, Tableau are a few of the tools being used. Mobile Applications and Search Engine Optimization are a few of the features build into the application.
- The reporting request cover a wide variety of visuals ranging from static reports to interactive Map type visuals.
Confidential, Charlotte, NC
Siebel CRM Senior Software Systems Engineer
Responsibilities:
- An initiative is under way to move the portions of the source data transport for the overall business intelligence program for the company from Siebel CRM, Web Sphere to Oracle Data Integrator as the overall ETL tool. This requires a translation of the Load strategy by helping to determine what needs to be inserted or updated by comparing aggregated information with the data from the statistics system.
- Oracle database requirements-collection and design and MYSQL. Java, Avaya, and Hadoop data store are a few of the original sources.
- Installations and Patching of Hadoop on multiple Operating Systems and environments (DEV (Linux), UAT (Unix) and Production (Unix)).
- Assist and support Project Management functions
Confidential
Siebel CRM Software Engineer
Responsibilities:
- Position required providing day-to-day support for the data warehouse for the Siebel CRM, Oracle Business Intelligence Enterprise Edition (OBIEE) Solution.
- Advanced technical knowledge of Siebel CRM, OBIEE, OBIA, ODI, WebLogic, Java. Oracle WebCenter, Administrative and Metadata tools, Security.
- User Interface designs, development and deployment of dashboards, analytics and performance management reports and experience with Siebel CRM, Oracle DBMS including Oracle 11g and 12C instances.
- Implemented OBIEE custom data warehouse solutions and pre-built BI analytics (OBIA release 9.6.1) for Oracle eBS, Avaya, PeopleSoft and Siebel CRM with the extensive use of the Open UI. Siebel EIM, Siebel Tools, and E-Scripting are components used to produce solutions that met client requirements
- Implemented Oracle WebCenter 11g for internal and external portals to applications features and functionality.
- Maintaining a fundamental comprehension across all areas of OBIEE (technical and functional) to define vision and strategies for OBIEE. Responsible for application and user security settings. Produced reports using BI publisher.
- Responsible for transitioning data from transactional applications to STAR schema format.
Confidential, Atlanta, GA
Lead Developer
Responsibilities:
- Team Lead responsible for the architecture and design for an OBIEE release 10.1.3.4. OBIA 7.9.x, Business Intelligence solutions for the world’s leading specialist in air transportation communications and information technology.
- This roll works directly in the Development team, DBA group and the business to gather requirements from the business and write HLD documents used to assist with building solutions that meet the needs of the business.
- The Oracle Identity Management module is used to control users’ access to the solution.
- Oracle RDBMS release 10.2.0.4.0, 11.1.0.7.0 and 11.2.0.2.0 and MYSQL are the databases.
- Oracle Data Integrator 10.1.3 is the middleware used.
- We have also upgraded ODI from release 10.1.3 to release 11.1.1.6.3 in preparation for moving the entire Oracle Technology Stack to release 11. Produced reports using BI Publisher.
- Installed and configured Weblogic in the Development, Test, and Pre Production and Production environment.
- The Agile Methodology is being used to coordinate all project related artifacts.
Confidential
Consultant
Responsibilities:
- Team Lead responsible for the construction of design documentations for an OBIEE 10G Business Intelligence solutions for a major utilities company.
- This roll coordinated directly with the business to gather requirements and write documents that developers used to generate or code solutions that met needs of the business. Oracle 11G is the database.
- An initiative is under way to move the portions of the source data transport for the overall business intelligence program for the utilities company from Avaya with Web Sphere to Informatica as the overall ETL tool. Standardized reports were produced using BI Publisher.
Confidential
Confidential Engineer
Responsibilities:
- Responsible for the construction of High-Level Design and Applications Design documentation for solutions relative to the CRM systems for a major telecommunication company. This roll coordinated directly with the business to gather requirements and write documents that developers used to generate or code solutions that met needs of the business. Additionally, responsible for the Security Architecture portion of the overall solution.
- These systems manage Orders from both internal employees and Partners of the telecom company.
- The environments consist of Siebel 7.8 with Partner Relationship Management interfacing with multiple critical systems Oracle 10G is the database. Systems above provide portions of the source data for the overall business intelligence program for the telecom company with Informatica as the ETL tool.
Confidential
Senior Principal Consultant / Architect / Project Manager
Responsibilities:
- Responsible for the design and implementation of a Visual Presentation solution for a large telecommunications company.
- The environment consisted of OBIEE 11g, Map Viewer, NAVTEQ, Informatica and the 11G Oracle Database. Source systems included Oracle Transportation Management, Oracle Inventory Management, Oracle Order Management, and Oracle Warehouse Management with a Fleet Management systems used for Vehicle data.
- The objective of the systems is to track the movement of inventory or assets through the lifecycle of the asset showing its value visually on a map with drill down capabilities showing various geographical levels or locations through to the actual asset itself providing its current location and value. This solution is targeted to upper management to provide a snapshot in time view of telecom assets.
- Additionally, supported the pre-sales efforts for the BI practice. As the Technical Architect assigned to describe the Oracle Business Intelligence Applications Solution for PeopleSoft and Oracle eBusiness Suite offerings to prospective clients and communicate the mapping and implementation and upgrade process to the account managers. Preparing and completing Request for Information, Request for Proposals, and participating in the sales process for all Business Intelligence offerings.
Confidential
Senior Consultant / Project Manager
Responsibilities:
- Project Manager for the building of an ESSBASE 11 Proof of Concept and the implementation of OBIEE 10.1.3.4 with the Oracle Business Intelligence Applications.
- The Siebel Applications and PeopleSoft Financials are in production and provide its details to the data warehouse via Informatica mappings and coordinated through the Data Warehouse Console.
- The Data Warehouse is hosted on an Oracle Exadata Database Machine. The Data Warehouse is constructed from several sources including the Siebel Applications, PeopleSoft Financials and many MFG Pro data sources from manufacturing plants around the world and supporting data sources internal to headquarters.
- We have decided to move the ESSBASE POC through the SDLC into production using Informatica ETL jobs to move data from the Data Warehouse into ESSBASE Cubes for pricing analysis to support a pricing analyst as they do an account review.
- We also have established an OBIEE 11 sandbox environment to explore the new features of the product and the more seamless integration of ESSBASE with release 11g of OBIEE.
Confidential
OBIEE Architect
Responsibilities:
- We were able to deliver an Oracle Business Intelligence Dashboards solution for the Mortgage Division of a Financial Services company. I am tasked with managing the activities of the OBI development team, participation in the technical architecture definition and writing the Security Architecture for the OBI portion of the solution.
- I am a member of the Leadership Team responsible for reporting daily progress for the OBI Team and resolving any issues that occur relative to OBI.
- Additionally, I maintain the project plan for the implementation of reports and dashboards. The source environments include PeopleSoft Financials, ESSBASE, and SQL Server, a Customer Data Store built on Oracle8.2 and DB2 as source systems. Each source system is hosted on a different operation system.
- The ETL strategy uses Informatica to control the movement and timing of source to target data movements. The target environment is an Enterprise Data Warehouse hosted on an Oracle10g database. OBIEE 10.1.3.4 is used to build reports and construct dashboards. BI Publishers is configured to delivers reports to end users.
Confidential
Siebel / OBIEE Solutions Engineer
Responsibilities:
- As a member of the solutions delivery team for the Confidential Integrated Technology Delivery, Server Systems Operations group.
- I was tasked with providing Siebel Application, Fusion Middleware and OBIEE installation and administration support for multiple environments (DEV, TEST, TRAINING, STAGE and PRODUCTION).
- Responsible for the installation software relative to the solution, patching strategy environments, and providing support for environments.
- The environments consist of Confidential AIX, Oracle10G databases with Siebel8 and Oracle E-Business Suite R12 as the applications. Oracle Fusion Middleware with Oracle Application Integration Architecture provides the integration layer for the solution.
- The OBIEE infrastructure consists of the BI Server, BI Presentation Serve and BI Scheduler. The BI Cluster Controller is configured in (PROD ONLY and manages Load Balancing of the BI Servers and Scheduler).
- The BI Web Server Components, Siebel Analytics, the DAC Server, Informatica Server, BI Data Warehouse, BI Answers, BI Interactive Dashboards, BI Delivers are all available in the DEV environment.
- The BI Publisher is configured in the (DEV environment only and is used to generate reports using - MS Word, MS Excel, Adobe Acrobat etc.), Site Minder is used to handle Single Site Sign for environments other than DEV.
Confidential
Technical Architect
Responsibilities:
- Solutions Engineer for several Siebel Analytics / OBIEE projects for Confidential Professional Services. Responsible for architecture solutions, the installation software relative to those solutions, patching strategy for environments, and providing support for environments.
- Additionally, responsible for the functional and technical design and documentation of client solutions. The role required a wide range of product exposures and knowledge of best of breed product sets and best practices. This role included shared responsibility for staffing projects and the overall success of operational projects within the practice.
- Additionally, responsible for developing reports and dashboards including hands on configuration of the administrative layer within the OBIEE product, BI data modeling and designing the overall ETL process, addressing security concerns and Identity Management with components such as Oracle Identity Management, LDAP and Oracle Internet Directory.
- Also collaborated with internal client groups or departments to address performance issues that may occur on a given engagement. Source environments included JDE E1, Mainframe Data Sources, Legacy Oracle data and various user defined lookup data. BI Publishers is configured to delivers reports to end users.
- Additionally, responsible for preparing and completing Request for Information, Request for Proposals, and participating in the sales process for all Business Intelligence offerings.
Confidential, Charlotte, NC
Architect / Project Manager / Lead Data Architect
Responsibilities:
- Project Manager / Lead Data Architect for the Data Center Proximity Relocation program.
- Responsibilities were to technically
- advise the DCPR analysis team on all (Oracle, Sybase, SQL Server, DB2, IMS and Teradata) database platforms associated with the operations of the Corporate and Investment Banking data center. The programs’ purpose is to relocate the corporate Disaster Recovery Center to a more robust location.
Confidential
Siebel Analytics / Oracle Business Intelligence Developer
Responsibilities:
- Project Manager / Business Analytics / Lead Developer for the implementation of Oracle Business Intelligence Enterprise Edition release 10.1.3.
- Responsible for the installation and administration of the environment(s). Including establishing the Physical Layer for multiple data sources, the Business Modeling and Mapping Layer for complex multi-fact objects and the Presentation Layers of the environment.
- Additionally, responsible for the development of Reports and Dashboards and mentoring developers that are less experienced in the OBIEE space. Also responsible for reporting on the overall project progress to management.
- The environments consist of Windows 2003 Server, Oracle Business Intelligence version 10.1.3, Siebel Analytics 7.8 with SQL Server as the backend database.
- The demo environment constructed by the Oracle Corporation was upgraded from Siebel Analytics version 7.8 to Oracle Business Intelligence version 10.1.3. The ETL process is handled by a partner company who has a product specific to the insurance industry.
Confidential
Manager Applications Support and Development
Responsibilities:
- Data Team Lead for the Phase 0 or Discovery Stage (requirements gathering) implementation of Siebel SFA 7.8.2.3 and Siebel Analytics for a manufacturing company. This role required the construction of Functional Design Documents for the proposed solution.
- The proposed environments consisted of Sun equipment running Solaris 9 with Oracle10g as the database platform. Data is imported from a variety of sources including a mainframe via Informatica and Siebel EIM.
- The integration strategy called for 36 integration points including Oracle tables, Flat Files and JDE Enterprise One data. Real Time integration was handled via WebMethods and Siebel eAI. Batch type interfaces are being handled by Informatica and Siebel EIM and Scripts. LDAP was selected as the security or access control mechanism.
- Data Team Lead for the implementation of Siebel 7.8.2.2 and Siebel Analytics for a Large Information Publications company. Participated in the data design sessions as the Data Expert for their Total Source Program.
- The environment began as Siebel 7.5 and was fully upgraded to Siebel 7.8. Source data included mainframe data, JDE Enterprise One data various user defined lookup tables.
Confidential, Charlotte, North Carolina
Siebel Subject Matter Expert
Responsibilities:
- Participated in the initial design sessions as the Siebel Subject Matter Expert for a client managements system.
- Responsible for the completeness of the Functional Design Documentation.
- This role flowed into a Technical Architecture / Developers role for the Generation 1 build of the Client Connections System.
- The environment consists of an external data file provided by the systems of record, imported via EIM on a monthly basis. The external feeds provide the Customer records to support core functionality of this system.
Confidential
Siebel Solutions Team
Responsibilities:
- The Siebel Solutions Architect for an implementation of Siebel 7.5.3 responsible for an EIM data loading strategy and Project / Program Management.
- The environment consisted of Windows2000 with an Oracle 8 database.
- The Oracle 9 client tools and TOAD were used for data analysis and to establish a connection agent for then Siebel Thick Client Applications. Data sources include spreadsheets, JD Edwards’s data and Oracle tables.
Confidential, Atlanta, Georgia
Siebel SOSI eAI Team
Responsibilities:
- A member of the Siebel eAI Team on SOSI Project Confidential The Confidential .
- Serving as the liaison between the eAI Team and the Infrastructure team responsible for generating the Build Notes for moving development objects into the testing areas, participating in the defect meetings held by the testing groups.
- Also participating in the Smoke and Shakeout testing for many builds to verify completeness of the environments.
- The environments consist of Siebel 7.5, EAI, Confidential AIX, DB2, Informatica, Windows 2000, and a variety of interface and integration sources.
Confidential
Siebel Consultant
Responsibilities:
- A member of the Data Change Control Team on the largest Siebel Implementation in the world for Confidential .
- Responsible for solving data related issues globally.
- The related task included the coordination of change request from the user community.
- Translating the users requests into clear concise design requirements (the proposed solution document) and participation in the executions of proposed solutions.
- The environments consisted of Siebel 7, EAI, Confidential AIX, DB2, Windows XP, EIM and a host of interface and integration sources.
Confidential
Business Systems Team Lead
Responsibilities:
- As a Domain Expert in the areas of CRM and Project Management on a Proposal preparation team for SAIC evaluated SAP, PeopleSoft, Oracle Applications and Siebel eBusiness Applications for features and functionality and an integration platform such as Oracle 9iAS, MQ-Series, Web Methods, Tibco and Vitria to comprise the most flexible solution to accommodate functional areas of Human Resources, Financials, Customer Relationship Management, Project/Program Management and Document Management seamlessly integrated and incorporated with wide area workflow.
- Responsibilities included product and vendor evaluation, construction and delivery of the written proposal, the oral presentations and the demonstration of the solutions capabilities.
- We installed and evaluated software in order to comprise a fit gap analysis based on provided business requirements.
Confidential
Principal Consultant, Global Services
Responsibilities:
- Responsible for multiple upgrades of Siebel running against Oracle, DB2 and SQL Server databases with Siebel 99.x, Siebel 2000 and Siebel 7 applications.
- Deployment Lead / Architect for the implementation of Siebel Call Center 99.6. Responsible for conducting JAD sessions and completing the Functional Design Documents for the project. A Proof of Concepts (POC) for the real time interface of a legacy system into the Siebel environment was done for a large telecommunications company.
- Enterprise Integration Management Specialist for the Rapid Implementation of Siebel SFA. Accomplishments included the review of the Interface requirements, EIM Mapping and the documentation of the Import Scheme and the EIM process. The consolidation of 12 data sources into 3 input sources and working with Data Analyst to cleanse data. Building a Quality Assurance plan to validate and verify data completeness. Installing Oracle components SQL*Net, SQL*Loader and other Oracle Client Software.
- Architect / Team Lead responsible for facilitating requirements gathering sessions and producing Functional Design documents and Technical Design documents for the implementation of Siebel Call Center 99.5 installation with Computer Telephony Integration Confidential the Network Control Center for a global communications equipment manufacturer.
Confidential
Technical Lead
Responsibilities:
- As Technical Lead in the Package Solutions Division responsible for the Installation and Administration of Oracle Applications 10.6, release 11 and release 11i, Oracle Business Intelligence Tools, Oracle Reporting Tools, Third Party Software packages in a multi-instance reusable environments.
- As a member of the Oracle Financials implementation team responsible for providing Functional and Technical support for the implementation of the Oracle Payable, Oracle Receivable, Oracle Assets and Oracle Projects modules in a mixed database repository environment (Oracle 7.3.4, Oracle 8, Oracle 8i). Responsibilities included interfacing data from external system(s) into the Oracle repositories.
Confidential
Director of Applications Development
Responsibilities:
- Project Manager for all BSEs Oracle based projects. Responsible for the Project Accounting Module in the Enterprise Resource Planning (ERP) Solution consisting of Oracle Financials, Human Resources & Payroll, including the gathering of business requirements and future process flows, for Chicago Public Schools. The above named module interfaces with Oracle Human Resources, Oracle Payroll, Oracle Accounts Payable, Oracle Accounts Receivable, Oracle Assets, Oracle General Ledger, and Microsoft Projects.
- Oracle Projects encompassed the functional areas of Telecommunications, Transportation, Food Services, Operations, Facilities Management and Energy Management. This endeavor requires the coordination of approximately 25 to 30 persons.
Confidential
Assistant Director of Programming
Responsibilities:
- Director for the conversion of Confidential, a medical record tracking system, from a Limited user Visual Basic/Microsoft Access based product to a Visual Basic Client /Oracle database server product. Lead the conversion of the vendor database schema from a non-relational schema to a relational schema.
- Evaluated Request for Product Inclusion from vendors for viability and applicability and effectiveness. Installed the Oracle RDBMS versions 7.2 & 7.3 and Administered several instances between versions for the purpose of migration and re-hosting the Confidential application code, unit testing and acceptance testing.
