Cloud Bi Architect, Tableau Resume
Chicago, IL
SUMMARY
- She is a senior Business Intelligence - BI-ELT-ETL Architect/ DWH Managing consultant/techno/ functional ERP specialist/MDM expert with over Twenty (20) + years of hands-on technical experience in Confidential implementing multiple ERP/Business Intelligence projects.
- She is an expert in BI Implementations using ER Studio, ERWIN, SQL Modeler as data modeling tools, ODI, Informatica ETL tools, OBIEE OAC, (12C. 11G), Visual Analyzer, Tableau Power BI and BI Publisher.
- Participated in several reporting conversion projects from Discoverer to OBIEE.
- She has worked with Oracle ERP implementations (11i, R12) Financial Modules, Procurement, Accounting, FAH, Manufacturing modules, Supply Chain, Human Resources (HR), Projects, Grants, Treasury, Transport module (OTM), Oracle FSM Cloud, HCM Cloud Fusion, ERP Custom Development, Oracle Fusion Middleware, SOA platform, Amazon Web Services(AWS), JDeveloper web service development, Integration of multi Org/Multi Currencies within EBS, ERP release upgrades and Oracle ERP Expert witness consulting.
TECHNICAL SKILLS
Web Tools: Oracle Forms, Oracle Reports, APEX, Web DB, Oracle Workflow, Flow Builder, HTML, Oracle Web Application Server Installation, Configuration and Administration, Cartridge implementation of Forms Server, Report Server, Java, JDeveloper, XML, XMLDB, XQuery
Methodologies: Application Implementation Methodology (AIM) on RICE and CEMLI (Configurations /Customization, Extension, Modification, Localization, and Integration), Custom Development Methodology (CDM), Agile (Jira, Trello), QA methodologies (HPQC), IBM Process.
SDLC: Statement of work, Project Scope, Business Requirements, High Level Requirements Document HLRD, High Level System Design Documents HLSD, Functional Modeling, Logical/Physical Database Design, Unit and integration Testing, End User Training and Development, Easy Path Migration Method (EMM), End User Training/Mentor.
Databases: Oracle RDBMS 10G, 11G, 12C, Teradata, AWS Redshift, SQL Server
Products: ERWIN, ER Studio, SQL Modeler, HTML, Java, C++, C, Pascal, COBOL, Unix Scripts
OS: UNIX, LINUX, LAN, MS-DOS, Windows, MVS (IBM)
Hardware: DEC Alpha Server 8400(Turbo Laser), Dec 2100, Sun Solaris, IBM Mainframe, PC
PROFESSIONAL EXPERIENCE
Confidential, Chicago, IL
Cloud BI Architect, Tableau
Tools: OBIEE 12C, ODI, SQL, RPD, PL/SQL, Informatica, Tableau
Responsibilities:
- Client has many third-party systems and client had a custom data warehouse.
- I'm working as an OBIEE, Tableau/BI Architect helping to maintain/enhance the current OBIEE components and assisting the client to migrate existing reports to Tableau in an as needed basis.
- Build POCs connecting to Redshift and Snowflake data models from OBIEE. Also, I maintain the web logic security and administrator model in OBIEE and Tableau.
- I manage the test/prod instances of OBIEE. Interacted with business leaders for requirements gathering, performed data analysis, conducted system study on the existing data issues, data modeling and finally decision-making analysis/dashboards building.
- Assisted the client to re-design the in consistent data models. Analyze and build new subject areas in OBIEE for new business reporting.
- Created an inhouse web application using Oracle APEX/ORDS to maintain the incident and claim data.
- Created reports and screens in APEX to assist the data flow.
Confidential, Chicago, IL
BI Architect, Data Modeler
Tools: OBIEE 12C, ODI, BI Apps, SQL, RPD, PL/SQL, Informatica, Tableau, ER Studio
Responsibilities:
- Client has Oracle ERP Fusion modules (Financial & HRMS) implemented.
- I worked as an ERP Analyst/BI Architect assisting and fixing the OBIA BI Apps/OBIEE mapping/reporting issues.
- Created the road mapping for the OBIEE development. I have created the best practices for the team and build OBIEE/BI Publisher report templates so that other reporting team can follow the process.
- I have also created a process to manage the business to facilitate requirements and gap analysis for the reporting needs. Reviewed and changed the BI Apps ODI mappings.
- I’d developed and managed the reporting in OBIEE and conducted UAT sessions with the business users.
- Worked as a Data Modeler and used ER Studio to reverse engineer the DB and document the data model.
- Created packages/Procedures in PL/SQL and invoked them in ODI.