SUMMARY:

• 19 years USA IT experience with 15 years Business Intelligence and Reporting.
• Technical Project management - Project Lead, Management of users, Technical SME, POC, Customer liaison, Trainer. Strong hands on experience with every aspect of BI, while being team player.
• Multi roles/responsibility - BI Lead, Developer, Architect, Functional Analyst, Project Manager, Business Analyst, System Engineering.
• Specializing in EBS with BI Solution. Handling all aspects of BI - Datawarehouse, OBIA, OBIEE, Informatica, ODI, DAC, Bipublisher.
• Custom and EBS datawarehouse implementation with data modeling expertise.
• High customer satisfaction through knowledge well proven strategies.
• Requirement gathering for functional/technical specification.

TECHNICAL SKILLS:

Big Data: - Splunk 6

BI: - OBIEE 11, OBIA, BIpublisher 11, QlikView, Business Objects, Crystal Reports

Reports: - Oracle APEX, Oracle Forms/Reports, Crystal Reports 2008, SQL Server SSRS

Middleware: - Weblogic, Enterprise Manager

ETL: - Informatica 9.x, Pentaho PDI, Oracle Data Integrator 12/11

Databases: - Oracle 12c/11g, SQL Server 2008, MySql, Teradata 14

ERP: - EBS 11.x/12.x, Maximo v7.5

OS: - Windows, Linux, Unix

Data Modeling: Erwin, Oracle Data Modeler, Embarcadero 16

Others: Sentinel NetIQ, Sphera HMMS v4

PROFESSIONAL EXPERIENCE:

Confidential - San Diego, CA

Data Modeler/BI/ETL

Responsibilities:

• BOE universe creation for data warehouse. BOE report creation - transferring old reports to new data warehouse reports. Informatica ETL utilized to create new data warehouse. Data Modeling via Erwin for new data warehouse - Maximo and HMMS Full data model Logical and physical layers. Workflows for ETL population of data warehouse. BOE report creation for new data warehouse. Reports were based on old OLTP model and re-written for data warehouse. Maintaining existing Crystal Reports. Installation of PowerBI Desktop and Server. Creation of Reports in PowerBi, based on new data warehouse.

Environment: Business Objects, Erwin, Maximo v7.5, Informatica, Power BI, Crystal Reports, Sphera HMMS v4

Confidential - Santa Clarita, CA

Senior BI Developer/ETL

Responsibilities:

• Oracle CRM system related BI system migration/Consolidation from one org to another. Detail source information gathering - Web interface, OBIEE repository and database. Mapping of fields of source to target system Kimball Datawarehouse. Marketing Analytics modification of existing OBIEE repository.
• Maintenance of existing BI system per new user requirements. Modification of Oracle DB on target system to align with source system. Gathering user requirements database objects and BI reports. Detail source information gathering - Web interface, OBIEE repository and database. Enterprise Architecture investigation for migration. Completing Production ticket, working with users. Modification of Informatica flows to Kimball data warehouse. Writing test case for new database fixes, Power BI utilized for in house data. Modification to existing reports and columns. Maintaining reports in Tableau

Environment: Oracle CRM Innovation Pack 2013, OBIEE/bipublisher, Weblogic, Oracle DB 11g, Informatica 9.51, Power BI, Tableau

Confidential - Norfolk, VA

Data Architect

Responsibilities:

• Create new Data Dictionary for all tables in Enterprise System in Oracle and TeraData. Data modeling with Embarcardero Suite. Analyze Sentinel Server query export. Follow all Informatica ETL flows from Oracle to Teradata . Running reports in Splunk. All DB fields are matched to SPLUNK CIM. APEX front end created for entry of data.

Environment: Embarcardero, Splunk, APEX

Confidential - Chicago, Ill

Senior BI Lead

Responsibilities:

• New Implementation of OBIA with ODI on Exalytics/Exadata. Production monitoring of legacy OBIA with Informatica. BIpublisher report modification for production change requests. Oracle EBS Suite reporting to OBIEE. EBS modules - Financials, Procurement, HR, Enterprise Asset Management of Kimball Datawarehouse. Teradata queries to match ETL process.

Environment: OBIEE/bipublisher 11G,OBIA, Exalytics/Exadata, EBS R12, Weblogic 11G, Oracle DB 12c, Teradata/SQL Assistant v14, Sentinel NetIQ v6, Splunk v6, Splunk CIM, Embarcadero ER/Studio v2016, SQL Server 2008, Oracle APEX

Confidential - Carlsbad,CA

Senior BI Lead

Responsibilities:

• Full implementation of Discoverer/Noetix reports to OBIEE/Noetix migration. Map Gap Analysis of Discover/OBIEE reports. Standardization of processes and security. Weblogic/OBIEE Administration. End user on OBIEE.

Environment: OBIEE/bipublisher 11G, EBS R12, Weblogic 11G, Oracle DB 12c, Noetix Views, PL/SQL, Oracle Application Server 10g

Confidential - Los Angeles, CA

Senior BI/ETL Developer

Responsibilities:

• Maintenance of existing BI system. Source to target modifications per new requirements. Gathering user requirements and updating PL-SQL, database objects and BI reports. New Informatica flows implemented for existing PL/SQL coding. Conceptualization of new OBIEE/DW implementation, utilizing Kimball methodology

Environment: OBIEE/bipublisher 11G, Weblogic 11G, Oracle DB 11g, Informatica 9.51, PL/SQL

Confidential - San Diego, CA

Senior BI Lead

Responsibilities:

• EBS 12i analytics in OBIEE Kimball data warehouse via Informatica/DAC (OBIA). Implementation of new OBIA 7.9.6.4 multi-tier environment. Security configuration with LDAP. Weblogic Administrator for whole BI Environment. OBIA reports and Dashboard fixes per business requirements. Report Creation in qlikview. Agile Analytics (Oracle Product Lifecycle Analytics) - Dashboard/reports. Oracle Data Integrator ETL to OPLA DW. SQL Server Report creation/modification for users - SSRS, Crystal Report modification for users.

Environment: EBS 12x,OBIEE/bipublisher 11G, Weblogic 11G, Oracle DB 11g, Linux, EBS 12i, DAC 11G, Informatica 9x, ODI 11x, OBIA 7.9.6.4, OPLA 3.3.1.1.0, qlikview, SQL Server 2008, Crystal Report 2008

Confidential - San Diego, CA

Senior BI Developer

Responsibilities:

• Maintenance of existing government computers. E-Business Suite 12i analytics in OBIEE Kimball data warehouse. Monitoring and Debug of DAC load process - day or night. DAC task modification as needed for extraction. Informatica ETL/OBIA modified according to new user requirements. EBS, OBIEE, db object created/modified as needed. OBIEE performance tuning Confidential repository and database layers in data warehouse.

Environment: OBIEE 11G, Fusion Middleware 11G, SOA Suite, Weblogic 11G, Oracle DB 11g, Real Application Clusters, Solaris 5.10, Ebusiness Suite 12i, DAC 10x, Informatica 8.x, Oracle Data Modeler, OBIA

Confidential - Rockville, MD

Senior BI Lead

Responsibilities:

• Project entailed building new Kimall datawarehouse for DOT. OBIEE used to analyze USA border trucking data related to truck entry, type of cargo, port utilization, among many more analytics. New federal government UNIX computer procured, OS installed, Kimball DataWarehouse implemented. Oracle 11G with
• Real Application Cluster installed in environment. Worked on all facets of implementation - Solaris System Administration, ETL, Fusion Middleware 11G with Weblogic. 11G RAC database on Solaris, Informatica ETL. Monitored DAC loads on EBS for another team. Modified OBIA structure for report requirements. Performance tuning of reports. SAS comparison done against OBIEE as alternative. Very low budget project and took on many roles.

Environment: OBIEE 11G, Oracle Data Integrator (ODI), Fusion Middleware 11G,SOA Suite, Enterprise Service Bus, Weblogic 11G, Oracle DB 11g, Real Application Clusters, Solaris 5.10, Informatica 8.x, Oracle Data Modeler, EBS 12x, DAC 10x, OBIA 10x, SAS 9.2, SAS Enterprise Guide

Confidential - Newport, RI

Senior BI Lead

Responsibilities:

• New Kimall datawarehouse implemented. OBIEE analytics done on casino gaming customer trends. Customer visits to casinos, demographics, tier levels, age categories, among other analytics. Newly designed product was featured in Indian gaming magazine for customer purchasing. Creation of OBIEE Dashboards, Reports and Repository. Informatica ETL utilized for creation of Kimball data warehouse.. MySQL Database with MySql Workbench used. Cognos solution for possible alternative. Cognos Query Studio, Report Studio.

Environment: OBIEE on Vmware, Informatica 8.x, Windows 2003, Informatica PowerCenter 8.1.1, MySQL 5.1, MySQL Workbench 5.2, Cognos 8.4, Oracle Data Modeler

Confidential - RidgeField, CT

Senior BI Developer

Responsibilities:

• OBIEE reports for new drugs study. Global OBIEE implementation causing slowness in report. Modification done to OBIEE reports to increase the speed and database performance. All reports analyzed for areas of weakness and re-written to improve throughput. Report database object reviewed and optimized for performance. Dashboard, reports and Repository creation/modifications. Gathering user requirement for report modification. Informatica ETL to DataWarehouse. Data Modeling via Oracle data modeling tool.

Environment: OBIEE 10x, BI Publisher, Oracle Application Server, Informatica 8x, Oracle Data Modeler

Confidential - New York City, NY

Senior BI Developer

Responsibilities:

• Pilot program for integration/migration of 1980 Unisys Mainframe. Full life cycle implementation of OBIEE/BI publisher reports on Unix Environment - installation to deployment. OBIEE reports based on revenue, inspections, Fire inspector Activity, etc. Security implemented with authentication via SSO. Solaris v10 environment and OAS integrate OC4J component. Transforming data from mainframe to Oracle DB, Informatica ETL, SQL, and PL/SQL Software integration to mainframe via Interplex. Other software used - Click Scheduler Software, BPEL, SOA Suite, Clear case.

Environment: Sun Solaris, OBIEE 10x,BI Publisher, Informatica PowerCenter 8x, UNIX, Interplex, Oracle Application Server, BPEL, SOA suite, Click Scheduler, Rational Clear Case, SQL, PL/SQL, Oracle Data Modeling

Confidential - Mountainside, NJ

Senior BI Developer

Responsibilities:

• Oracle Applications 12i DBI implementation of financial modules, Payables, Receivables. EBS 12i was upgraded from 11i and various modules tested. Demonstration of BI Publisher and OBIEE answers, delivers, interactive dashboard. Presentation, BMM, Physical Layer of OBIEE where modified. Security modified to have access to new dashboards to users. OBIEE integration with BI Publisher and EBS. Maintenance of forms and reports 10G. Pentaho ETL extraction from database to local database. New Discoverer reports made for shipping and receiving, later migrated to OBIEE reports. Oracle Reports for new Custom Bill of Lading report, and later transferred to OBIEE reports.

Environment: Linux, Oracle Financials, Order Management, BI Publisher, OBIEE 10.x,EBS 12i, Forms & Reports 10G, Pentaho Data Integration

Confidential - Los Angeles, CA

Senior BI Developer

Responsibilities:

• Full implementation of DBI for Financials, Procurement, Payables and Supply Chain Management from installation to production. Full life cycle implementation of OBIEE & BI Publisher. BI Publisher was used instead of Discoverer to make report writing. Users were then trained on all the tools. Further, newly requested reports were implemented through BI publisher and OBIEE. All three layers of OBEE repository were modified. OBIEE was integrated with BI publisher and EBS. Pentaho ETL used to extract from database to local database to make primary reports.

Environment: Sun Solaris, OBIEE 10.1.3.x (Siebel Analytics), UNIX, Toad, Oracle Financials, A/P, DBI, Supply Chain, BI Publisher, Fusion Intelligence, Pentaho Data Integration

Confidential - Fond du Lac, WI

Senior BI Developer

Responsibilities:

• DBI 7.2 for Financials maintenance problems were resolved. There was large volume of DBI data and the tool was not working properly. Further debugging DBI for non-functionality in Financials, Procurement, Payables and Supply Chain Management. Debugging was done for request sets, materialized views, views, Tables, PL/SQL function. Additionally, there was a lot of interaction with DBA to resolve issues, due to volume of data errors. OBIEE proof of concept prototype for Discoverer Report Migration was put on test model.
• Discoverer and Forms & Reports 6i for Supply Chain, Order Management, Order to Cash (OTC) and Advanced Pricing. Different users had reporting requirements and transformation of business requirement and implemented to a reporting solution. The system could not handle seeded Discoverer business area, due to volume. SQL tuning was done to get deeper views and table level to generate the report. The query was further optimized for performance with time constraints. Pentaho ETL used to extract from database to future reporting data warehouse

Environment: DBI, Discoverer 10G, Linux - Red hat, Oracle Financials, Oracle A/R, Oracle A/P, Forms/Reports 6i, Fusion Intelligence, OBIEE (Siebel Analytics), Pentaho Data Integration.

Confidential - New York City, NYC

Senior BI Developer

Responsibilities:

• Full life cycle implementation of Financials, HRMS, Procurement DBI 7.2 and 7.3. Discoverer 4i implementation to reporting on Oracle Application A/R, A/P, G/L. Installing Discoverer Desktop/Administration-including security packs. Advising & DBA on installation procedures and configurations. new Discoverer end users in utilizing Desktop. end users on all DBI financials HRMS, Procurement dashboards. Advising DBA on installation and configurations of DBI. OBIEE configuration with DBI and Fusion Intelligence. Pentaho ETL used to extract from database to local database to make primary reports

Environment: DBI, Discoverer 4i, Linux - Red hat, Oracle Financials, Oracle A/R, Oracle A/P, OBIEE (Siebel Analytics), Fusion Intelligence, Pentaho Data Integration

Confidential - King of Prussia, PA

Senior BI Developer

Responsibilities:

• Migrated data from disparate systems, including Hierarchical databases, using Oracle warehouse builder. Extract, Transform, Load (ETL) data to central data warehouse repository via Pentaho ETL. Discoverer reports were made from data warehouse. After installation, automated process implemented of data feeds from disparate systems to data warehouse, via incremental loads utilizing Linux shell Scripts (Bash Shell). Pentaho ETL used to extract from temporary database to reporting Data warehouse

Environment: Forms/Reports 6i, Oracle Warehouse Builder 10G, Discoverer 4i/10G, PL/SQL, Oracle 10G, data warehouse, SQL Loader, UNIX/Linux Shell Script, Pentaho Data Integration

Confidential - Wash DC

BI Developer

Responsibilities:

• DOT was undergoing issues surrounding the Oracle Application General Ledger and Project Accounting data. PA data is retrieved through Discoverer and inserted into Oracle database warehouse, where reports are run using Forms/Reports 6i. G/L is retrieved and it goes to Oracle Database warehouse and reports are run using Oracle Forms/Reports. A side by side comparison is made between the two areas. The areas were not in agreement and therefore trouble spots needed to be recognized and corrected.
• EBS G/L reporting: standard reports, online inquiries, and FSG reports: Statement of Cash Flows, Trial Balance, Income statements and Company Balance Sheet. Extracting G/L data and running Financial Analyzer. Pentaho ETL used to extract from database to local database to make primary reports

Environment: Form/Reports 6i, Windows NT/2000, Access, SQL, PL/SQL, Oracle 9i, FSG, Financial Analyzer, Pentaho Data Integration

Confidential - Wash DC

BI Developer

Responsibilities:

• Responsible for doing BI work related to enumerators that were behind in performing their work. Example - enumerators that did not cover area assigned in the time assigned. I lead the BI group from being very dependent on my skills to becoming fully proficient and self-sustaining in the technical aspect of Oracle BI products. The primary tools used were XML publisher, XML Template Builder, all Discoverer Products (including Portlet). Migration of Discoverer from release 4i to the latest release - 10gR2. Developed and Published Discoverer reports in Oracle Portal 10g. Other responsibilities include - requirement gathering, end-user interactions and .
• Assisting in Data Modeling with Discoverer Designer. Pentaho ETL used to extract from database to local database to make primary reports

Environment: Portal, AS10G, Discover 10g, OID, SSO, XML Publisher Enterprise/Desktop, ClearCase, ClearQuest, Windows NT/2000, SQL, PL/SQL, Linux, Pentaho Data Integration

Confidential - Santa Clara - CA

BI Developer

Responsibilities:

• Responsible to implement Oracle Daily Business Intelligence (7.2) for Financials, Procurement and Supply Chain in a Test Environment for Product evaluation and . The Dashboards implemented and tested includes Profit and Loss, Profit and Loss by Manager, Expense Analysis, Expense Management, Procurement Status, Procurement Performance Management and Inventory Management. Chief HR Officer, Daily HR Intelligence, Workforce Budge manager and Benefits Manager. This includes documentation (BR100, TE130, etc), end-user and testing. Pentaho ETL used to extract from database to reporting data warehouse. Worked as Business Intelligence lead to build Reporting solution on Oracle Application environment using Oracle Discoverer 4.1.48 as the primary reporting tool. Project Lead and on-site coordinator for a team of 6 developers working remotely from offshore. Responsible for Technical Architect design of End User Layer and the supporting Data Model. Developed specifications to create load programs for EUL based schema. Developed several reports in General Ledger, Purchasing, Order Management, Receivables, etc. As Team lead, responsible for entire SDLC, from design, development, testing to implementation and team co-ordination.
• Also implemented out-of-the-box OLTP BIS environment for Financial Intelligence, Supply Chain Intelligence and Purchasing Intelligence. Custom developed discoverer reports from seeded OLTP EUL. Discoverer 10gR2 installation, documentation of implementation setups, Testing and Quality Assurance of seeded EUL implementation and custom developments. Form/Reports 6i reports for EBS. Pentaho ETL used to extract from database to reporting data warehouse

Environment: Daily Business Intelligence 7.2, Oracle Applications 11.5.10.2, AP, GL, AR, OM, INV and PO, Sun Solaris, Windows NT/2000, SQL, SQL plus, PL/SQL, Pentaho Data Integration. Oracle Discoverer 10gR2/4i, XML Publisher Enterprise/Desktop, Oracle Applications 11.5.10.2, AP, GL, AR, OM, INV and PO, Sun Solaris, Windows NT/2000, SQL, SQL plus, PL/SQL, Clear Case, Clear Quest, Form/Reports 6i, Pentaho Data Integration

Confidential -Arlington, VA

Senior Project Manager

Responsibilities:

• Work in heavily matrixed environment. Updating week statuses per project schedule. Cost proposal to client for project approval and acceptance. Change management approval for internal PMO team and client (SCCB). Release Management of pre-planned disparate teams into cohesive release team. Deployment/release plans and release schedule. PMO decision on issues and updates prior to release. Resolution of issue during project release and status of release - Go/No go call. Full life cycle development processes.

Confidential - Arlington, VA

Accountant

Responsibilities:

• Financial Reconciliation of Bank Branches for major Washington DC bank. Discoverer and Business Objects were used as reporting tools for reconciliation purposes.
• Extensive research and analysis of bank transaction that do not reconcile.
• Statistical analysis of daily Bank errors and advising branches on how to reduce errors. Creating user-friendly reports giving real-time analytical capabilities.

Confidential - Middletown, NJ

Project Manager

Responsibilities:

• Over 700 projects. 100 project releases
• Technical Skills
• Responsible as Project Manager / coordinator, including several Oracle Applications implementation projects. This includes co-ordination of onsite and offshore teams, quality assurance and on time delivery. The projects included Data Conversion, Application Customizations, and Reporting environment development.
• Project Management in various computer languages.
• C, C++, Java, Hyperion, Excel, UNIX, Visual Basic, Shell Scripting, Oracle, Informix.
• Completed major portion of 4000 line Microsoft project tasks.
• Management of Teams.
• Management of multiple projects and project teams - maximum of 13 different systems.
• Teams vary from 10-30 members per system.
• Domestic and international teams.
• Organize plans, and supervision of others, yielding a high level of productivity from subordinates.
• Client and Executive Relationship Management.
• Given a project situation, identify key issues for solution while utilizing optimal data gathering techniques, develop decision analysis approach, establish prioritized work plan, and understanding impact of recommendations on client organization.
• Political awareness within the client and executive management community.
• Compliance of Methodologies.
• Utilize Software Development Framework - a client methodology for project initiation, execution and completion.
• Implementation of SEI - CMM 2 and CMM 3.
• Analyze to develop issue policies, policy interpretation, regulations and guidelines of the organization. Ensure policy is consistent throughout organization
• Release Management.
• Synthesizing deployment plans and installs plans for production releases with in corporation of risk and contingency plans.
• Coordination of projects with synchronization of release dates. Working with other departments and client to re-do release dates to acceptable levels, if needed.
• Level 1 support for production release issues. Ensuring production issues are resolved to completion by task allocation and monitoring.
• Congregating all resources in a highly synchronized manner for project releases - Inclusion of but not limited to international, local, and back up teams. Other systems as needed for release are initiated for availability.
• Coordination of all internal and external teams on releases, accomplishing a highly successful team effort with an excellence in software implementation during release weekend.
• Maintain high level of professionalism during emergency and escalation proceedings.

Confidential - Herndon, VA

Project Manager/Tester

Responsibilities:

• Department outsourced from Confidential &T to Confidential . s under Confidential apply.
• Project Manager for team of 10 people
• Coordination of project release teams for project releases
• Testing Unix based application - both front end and backend.
• Help desk support for any issues on applications

Confidential - New Brunswick, NJ

Developer/Project Manager

Responsibilities:

• Managing team to implement Visual Basic projects
• Developing/writing code for Visual Basic projects
• Troubleshooting & Help Desk.

Confidential - New Brunswick, NJ

Computer Administrator

Responsibilities:

• Network troubleshooting
• Educating university students on computer concepts
• Computer Hardware/Software installation & troubleshooting

Confidential - Newark, NJ

Tester

Responsibilities:

• System Testing of Fox Pro Forms
• Help Desk for Fox Pro Users
• Troubleshooting and resolving Fox Pro software issues with team members

Confidential, Edison, NJ

Customer Service Representative

Responsibilities:

• Conduct customer transactions via Intra net technology.
• Advised customer on financial related matters. Educate new employees on bank
• Resolving customer issues professionally and thoroughly.