BI Analyst, Oracle developer Resume

SUMMARY:

Over twenty years of Information Technology experience in both the Government and private industry, including experience in Business Intelligence
ETL, design, Metadata Architecting, Data Modeling, Data Conversion, Reporting (OLAP, Ad - Hoc), Infosphere Administration and Database Administration, Oracle, Python,SQL Server, MySql development.

PROFESSIONAL EXPERIENCE:

Confidential

BI Analyst, Oracle developer

Responsibilities:

Analysis of business requirements and documentation for different projects.
Lead team of consultants of BI development.
Data profiling and data mining.
Data modeler of several projects.
Design and map the Data Mart model (Fact tables and Dim tables) in star schemas.
Data Extract Design Document and Extract Specifications.
Use CFIA standards (RFC) to implement the new Databases or new changes in metadata or new databases design.
Lead the definition and documentation of descriptive, structural, administrative, metadata and privileges en collaboration wif the Systems Architects and partners.
Design and develop data conversion (extraction, transformation and load (ETL)) routines, using IBM Cognos DataManager, Datastage and PL/SQL, SQLLOADER, from source databases (Oracle, CRM, XML, Flat files) to the Data warehouse.
Design Relational Database Management Systems (RDBMS), developing Query Language (Oracle SQL).
Create FM Model and publish packages using Framework Manager
Create Cognos reports using Structured Query Report (SQR) in Report Studio
Write technical documentation for the ETL components (including data conversion components) and data access components;
Develop data architecture design specifications and dimensional data models (define and build Dimension and Fact data) in support of DW architecture and deploy data warehouse in new Oracle.
As team lead, me evaluate and acnoledge contributions and efforts of individual members wifin the team in an effort to foster team spirit, unity and cohesion.
Migration the existing Projects from DM to Datastage: My role assigned to bring this back on track, make and state any assumptions necessary regarding wat strategic will include so dat we can come up wif wat is necessary to carry out the appropriate visioning and alignment of those projects.
Install Application Server, Install Engine, Install Client on Engine Server
Configure and test different components (Datastage, Information Analyser, Governance Catalog
Security, Configure Engine Security, parallel processing environment
Governance Catalog, Configure Operations Console, IMAM and Information, Quality Stage, Governance Dashboard, Exception Console, Subscription Manager
Manual of Installation/Configuration on Individual Components
Manage Issues and Risk
Monitoring Progress
Plan and implement projects
Help define project scope, goals and deliverables
Define tasks and required resources

Confidential

BI Analyst

Responsibilities:

Analysis of business requirements and project documentation
Data Profiling Document of Web data Source (OZI).
Create BluePrint document and Matrix to meet the Business requirements.
Data modeling, Data Extract Design Document and Extract Specifications.
Worked wif Business Analysts and Partners to define the goal.
Install and configure Talend, Pentaho, Report Designer
Create and publish Schemas and Cubes using Petaho Workbech Designer.
Create Dashboard and OLAP, AD-Hoc reports using Saiku, Report Designer.
Create Static reports, AD-Hoc using Pentaho Report Designer.
Deliver documentation and Provide technical assistance.
Collect and manage project team and allocate project resources
Create schedule and project timeline
Track deliverables and support and direct team and Lead quality assurance
Monitor and report on project progress
Present to stakeholders reports on progress as well as problems and solutions
Implement and manage change when necessary to meet project outputs

Confidential

BI Analyst

Responsibilities:

Design and Develop of ETL Processes (Talend Enterprise Studio DI/TAC)
Design and Develop of OLAP Cubes and Reports (Talend Enterprise Studio for Data Quality -DQ)
Design and Develop of Business Models (Talend Enterprise for Master Data Management - MDM)
Develop of Interfaces (Talend Enterprise Studio for Enterprise Service Bus - ESB).
Data Governance and Stewardship (Data Management - MDM)
Data Quality Business Intelligence Analysis
Data profiling, masking Analysis
DWH System High Level Design (UML language)

Confidential

IT Analyst

Responsibilities:

Manage team internationally remote (50% remote) and on multiple sites
Design, architect and wrote build books for all Development and Test Servers, (Oracle RAC, VMware, Linux clusters).
Responsible for converting and writing over 100,000 lines of Oracle PLSQL and UNIX script for reports and various control jobs.
Create more than 100 forms and reports wif Oracle Forms/Reports.
Organize project plan and methodology, Charter, Scope and Deliverables
Coordinated wif other IT and user departments to manage requirements and timelines.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship