SUMMARY

• Over 18 years of experience as a Business IntelligenceSolution Architect and Data Analytics Architect.
• Extensive experience designing and implementing enterprise data warehouse (EDW). Strong data modeling skills, specializing in design and optimization, and logical and physical data modeling.
• Implemented many complex BI solutions and data warehouse in Oracle Database,and converted from on - premises Oracle database to Azure cloud platform Data Lake.
• Worked extensively with many different enterprise applicationsincludingOracle EBS (Enterprise Business System), SalesforceCRM/CPQ (Customer Relationship Management /Configure Price Quote), RevPro and Workdays as data sources.
• Strong technical and functional skills in Oracle EBS and Salesforce CRM/CPQ.
• Broad experience with customers. Worked for multiple Fortune 500 customers.
• Experience withdata governance, focusing on maintaining data quality, data security, anda single source of truthdata warehouse.
• Implemented many KPI dashboards such as Revenue Analytics, FP&A (Financial Planning and Analysis) CPQ Quote ARR (Annually Return Rate), RMA ARR (Return Material Authorization Average Return Rate) and more in Tableau, Power BI and OBIEE.
• Broad knowledge and experience implementing best practices, data lifecycles, and business analysis processes.
• Strongtechnical project management skills, and long experience working remotely with business end-users and development teams onshore and offshore.
• Proven ability to work independently and work on multiple projects in a high-pressure, mission-critical, and high-availability environment.
• Eighteen years Design/Architect and implementing Enterprise Data Warehouse,data modeling mainly in Oracle database, and accomplished many complex KPI analytics dashboards.
• One year experience with Azure Data platform - Azure Data Lake, Data factory, Azure SQL, Azure Storage and security.
• Ten years professional experience as technical project lead and manager. Led onshore and offshore development teams in India.
• Provided professional services to these clients: AECOM, Aramark,Western Union, Metrolink, Iron Port (Cisco), GE, CH2MHILL,Owin& Minor, Acadis, FlowServe, Welch’s, Graco, Oxy, Saba, CBS, Prologis.
• Five years of experience implementing and customizing BI solutions, OBIA/OBIEE, data warehouse /Informatica ETL solutions with Informatica and DAC.
• Built hundreds of dashboards and reports with various query tools including: Tableau, Power BI, OBIEE.
• Ten years technical andfunctional experience in major Oracle EBS modules such as Finance, Service Contract, InstallBase, Projects, HR, Order Management, Inventory,BOM and Manufacturing.
• Created KPI Revenue Analytics, FP&A (Financial planning and Analysis) ARR dashboards.
• Four years of experience in SalesforceCRM/CPQ function and data backendand SFDC object tables.

TECHNICAL SKILLS

• Tableau, Power BI and OBIEE.
• Oracle database and Azure platform MS-SQL and Data Lake.
• Technical lead and project manager onmany complex projects using both Waterfall and Agile methodologies.
• Informatica ETL and Azure Data Factory.
• Oracle Store procedures and MS-SQL Store Procedure, SQL, JAVA, C++, Python, DAX.
• SQL, PL*SQL, C, C++,JAVA, MS-SQL, Oracle/MS-SQL

PROFESSIONAL EXPERIENCE

Confidential

Senior Business Intelligent Solution and Data Analytics Architect

Responsibilities:

• As a Business Intelligent solution architect, I also a project manager to lead the technical team implementing and developinga data warehouse and data modeling withvarious data sources mainly coming from the Oracle EBS,RevPro, Workdays and Salesforce CRM/CPQ.
• I’ve leadedfrom offshore technical team from India to create data model for these Oracle EBS data modules: Financials, Order Management, Manufacturing, Inventory,Service Contract, Install Base, and RevPro.
• Extended data warehouse to include Salesforce CRM and CPQ and Workday.
• Created many KPI dashboards and reports for Finance, Order Management, QA Engineer and Manufacturing teams. For example: Financial Revenue Analytics dashboard: is including all the data movement from Booking Pinelineto Backlogto Corporate booking to Invoicing to Revenuein Azure platform and using Power BI, and some other major dashboards are FP&A (Financial planning and Analysis), Corporate booking, CPQ QuoteARR Annually Return Rate), and ARR (Average Return Rate) for RMA (Return Material Authorization) and more.
• Worked closely with Oracle EBS developer, Salesforce developerteam, and key business usersto gather requirements and developed solutions and created specifications.
• Converteddata on-premise warehouse to Azure MS-SQL and Azure Data Lake using Power BI for visualization.
• Implemented and maintained the OBIA data warehouse using OBIEE and Tableau for visualization.
• Provide technical support.

Confidential

Senior BI Solution Architect Consultant

Responsibilities:

• Providing consultant service to Prologis. Implementing a Real Estate data warehouse, OBIEE repository architect and dashboards/reports development.
• Provide consulting services to CH2MHILL: Implemented and customized a data warehouse OBIA/OBIEE repository, Dashboards/reports development mainly in Finance, HR and Projects.
• Customized Informatica mappings and DAC
• Provided consulting services to Owin&Minor: completed upgrading OBIEE from 10g to 11g (OBIA 7.9.6)
• Customization OBIEE repository, Informatica (9i) mapping and DAC.
• Providing consulting services toAcadis: Data warehouse implementation and Tableau 7x dashboard/report development.

Confidential

Sr. Application and Data Warehouse Developer

Responsibilities:

• Developed and architect a Call Center Data warehouse.
• Developed dashboards/Business intelligent reports using MicroStrategy.
• Gathered requirements and built the ETL processes to extend the Call Center data warehouse from many difference data sources such as Oracle ERP, JIRA, Dynamics, some from MS Sharepoint applications.
• MicroStrategy: MSTR architect, MSTR administering, and Reports/Dashboards development.
• Maintenance/Customize NetSuite using Java Scripts.

Confidential

Senior BI Consultant

Responsibilities:

• Provided consulting services to major companies such as Aramark, FlowServe, AECOM, Welch’s, Graco, Oxy, Saba, Western Union, CBS, Metrolink, Iron Port (Cisco), GE and more.
• Implemented and customized data warehouses/data marts, ODW, OLAP and designed and implemented dashboards/reports using OBIEE 10g, Informatica 8i.
• Customized Noetix Informatica mappings/workflows and ETL processes from Oracle ERP as the data source.
• Chosen as lead developer to implement custom solution for global engineering firm utilizing full suite of Noetix technologies (customized NoetixViews, customized matrix security model, Noetix data marts and custom “mini-marts”, Noetix Platform, Noetix Dashboards, and Noetix WebQuery). At AECOM I implemented the security model from the Oracle Apps HR employee hierarchy tie down to project and task levels, and used PL/SQL and Oracle EBS concurrent programs as the ETL processes (2 years at AECOM).

Confidential

Senior Oracle ERP/Siebel, Data Warehouse Developer / Data Analyst

Responsibilities:

• Demonstrated exemplary team-building and leadership talents toward directing, motivating and mentoring developers and analysts.
• Led testing, implementation and support of Oracle ERP/Siebel, data warehouse and data conversion.
• Created Business Objects Universal, dashboards and reports
• Implemented Gentran EDI mappings.
• Implemented and automated the Post of Sales application using PL/SQL to insert clean data from Distributors and Value Added Reseller (VAR) to Oracle data warehouse.