PROFESSIONAL SUMMARY:

• Confidential has used Several Billing Tools like MetraNet and Revport, Oracle and Oracle Report Garden he is also experienced in Sieble as well as SQL.
• 10+ Years’ experience working as an Business Analyst & Developer & Project Manager
• 10+ Years’ experience using Oracle eBusiness Suite Modules & Siebel CRM Modules and Oracle Modules Cloud ERP technologies, OBIEE, & OBIA and Salesforce
• 10+ Years’ experience utilizing Oracle AIM, Agile, Waterfall
• 5+ Years’ experience working as a Project Manager or Program Manager

SKILL MATRIX:

• Business Analysis
• SQL
• SSRS and power BI
• Data Analytics
• Test case/Scripts

SELECTED PROFESSIONAL EXPERIENCE:

Confidential, Bloomfield Hills, Michigan

Business Analyst / Data Architect / Project Manager

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 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 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, Commerce, Billing, Tableau, Oracle Cloud ERP technology s ystems 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.

Confidential, Charlotte, NC

Business Analyst / Data Architect / Project Manager

Responsibilities:

• Built a Talent Management Systems (TMS) for one of the world leaders in banking
• Data sources were legacy systems and data entered from today's Human Resources demands
• Informatica was the tool used to move data into the Oracle environment for OBIEE and OBIA.
• Information was gathered from Confidential DB2 populated by a standalone SQR routine, Informatica for Oracle and a variety of other sources for lookup and supporting data
• Business Intelligence reporting required knowledge of current reporting needs and future reporting requests
• Utilized OBIEE, BI Publisher, Tableau, and a variety of other tools
• Reporting requests covered a variety of visuals from static reports to interactive Map type visuals

Confidential, Charlotte, NC

Business Analys / Data Architect / Project Manager

Responsibilities:

• Oracle database requirements-collection and design and data store were the backend sources
• Utilized many ETL methods and tools to gather information
• Java
• Python
• Mongo Database was the target output database
• Required a translation of the Load strategy by helping to determine what needed to be inserted or updated by comparing aggregated information with the data from the statistics system
• Assisted and supported Project Management functions

Confidential, Aiken, SC

Business Analyst / Data Architect

Responsibilities:

• Implemented OBIEE custom data warehouse solutions and pre-built BI analytics for Oracle EBS components used to produce solutions that met client requirements
• Provided day-to-day support for the data warehouse for the OBIEE Solution
• Responsible for User Interface designs, development and deployment of dashboards, analytics and performance management reports and utilized experience with Oracle DBMS including Oracle 11g and 12C instances
• Maintained a fundamental comprehension across all areas of OBIEE (technical and functional) to define vision and strategies for OBIEE
• Responsible for application/ user security settings and production of reports using BI publisher

Confidential, Atlanta, GA

Business Analyst / Oracle Developer / Project Manager

Responsibilities:

• Acted as Team Lead responsible for the architecture and design for an OBIEE release 10.1.3.4. Business Intelligence solution for the world’s leading specialist in air transportation communications and information technology
• Databases included Oracle RDBMS release 10.2.0.4.0 , 11.1.0.7.0 and 11.2.0.2.0
• Utilized Oracle Data Integrator 10.1.3 as the middleware
• 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
• Utilized the Agile Methodology to coordinate all project related artifacts

Confidential

Business Analyst / 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
• 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
• Systems managed orders from both internal employees and Partners of the telecom company
• Environments consisted of Siebel 7.8 with Partner Relationship Management interfacing with multiple critical systems
• Database utilized was Oracle 10G
• Systems above provided portions of the source data for the overall business intelligence program for the telecom company, having utilized Informatica as the ETL tool

Confidential

Business Analyst / Oracle Developer / Project Manager

Responsibilities:

• Responsible for the design and implementation of a Visual Presentation solution for a large telecommunications company
• 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 these systems was 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

Confidential, Dayton, OH / Pittsburgh, PA

Oracle Business Analyst

Responsibilities:

• Delivered an Oracle Business Intelligence Dashboards solution for the Mortgage Division of a Financial Services company
• Member of the Leadership Team responsible for reporting daily progress for the OBI Team and resolving any issues that occur relative to OBI
• The ETL strategy utilized Informatica to control the movement and timing of source to target data movements
• The target environment was an Enterprise Data Warehouse hosted on an Oracle10g database
• OBIEE 10.1.3.4 was used to build reports and construct dashboards
• BI Publisher was configured to deliver reports to end users

Confidential

Business Analyst / OBIEE Solutions Engineer

Responsibilities:

• Acted as a member of the solutions delivery team for the Confidential Integrated Technology Delivery, Server Systems Operations group
• Provided Siebel Application, Fusion Middleware and OBIEE installation and administration support for multiple environments (i.e. DEV, TEST,, STAGE and PRODUCTION)
• Responsible for the installation software relative to the solution, patching strategy environments, and providing support for environments
• Environments consisted of Confidential AIX, Oracle10G databases with Siebel8 and Oracle E-Business Suite R12 as the applications
• Oracle Fusion Middleware with Oracle Application Integration Architecture provided the integration layer for the solution
• The OBIEE infrastructure consisted of the BI Server, BI Presentation Serve and BI Scheduler
• The BI Cluster Controller was configured in PROD ONLY and manages Load Balancing of the BI Servers and Scheduler
• The BI Web Server Components, Siebel Analytics, DAC Server, Informatica Server, BI Data Warehouse/Answers/Interactive Dashboards/Delivers were all available in the DEV environment
• The BI Publisher was configured in the DEV environment only and was used to generate reports utilizing MS Word, MS Excel, Adobe Acrobat, etc.
• Site Minder was used to handle Single Site Sign for environments other than DEV

Confidential, New York NY

Business Analyst / Oracle Business Intelligence Developer

Responsibilities:

• Acted as 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)
• Established 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
• Responsible for the development of Reports and Dashboards and mentoring developers that were less experienced in the OBIEE space
• Responsible for reporting on the overall project progress to management
• The environments consisted 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 was handled by a partner company that had a product specific to the industry

Confidential, Midlothian, VA

Siebel Solutions Analyst

Responsibilities:

• Acted as 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 Windows 2000 with an Oracle 8 database
• Utilized the Oracle 9 client tools and TOAD for data analysis and to establish a connection agent for the Siebel Thick Client Applications
• Data sources included spreadsheets, JD Edwards’s data and Oracle tables

Confidential, Atlanta, GA

Siebel Business Analyst

Responsibilities:

• Acted as a member of the Siebel EAI Team on SOSI Project Confidential
• Served 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, and participating in the defect meetings held by the testing groups
• Participated in the Smoke and Shakeout testing for many builds to verify completeness of the environments
• The environments consisted of Siebel 7.5, EAI, Confidential AIX, DB2, Informatica, Windows 2000, and a variety of interface and integration sources

Confidential, Durham, NC

Business Analyst / Siebel Consultant

Responsibilities:

• Acted as 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 tasks included the coordination of change request from the user community
• Translated the user’s requests into clear concise design requirements (i.e. the proposed solution document) and participated 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, Durham, NC

Business Analyst / Siebel Developer

Responsibilities:

• Implemented Siebel 7.5 in an AIX and DB2 environment
• Utilized Siebel Tools, EAI, eScript and Siebel SmartScript to build an online version of the company’s enrollment application
• Acted as Team Lead and Developer for the development of the Medical Questionnaire portion of a Buy Online Strategic initiative

Confidential, Chicago, IL

Principal Consultant

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
• Acted as 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
• Created a Proof of Concepts (POC) for the real-time interface of a legacy system into the Siebel environment for a large telecommunications company
• Acted as the Enterprise Integration Management Specialist for the Rapid Implementation of Siebel SFA
• Reviewed the Interface requirements, EIM Mapping and the documentation of the Import Scheme and the EIM process
• Consolidated 12 data sources into 3 input sources and worked with Data Analyst to cleanse data
• Built a Quality Assurance plan to validate and verify data completeness
• Installed Oracle components SQL*Net, SQL*Loader and other Oracle Client Software
• Acted as the Architect/Team Lead responsible for facilitating requirements gathering sessions
• Produced 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