PROFESSIONAL SUMMARY:

• 12 + years of IT experience including BI Financial & Federal Government Reporting Solutions, System Development Life Cycle implementation (SDLC), Agile methodology, OLAP, System Integration of Portals, Java, Unix, Linux, J2EE, exposure to PeopleSoft, cloud computing architectures, authentication providers and other program application developments (project budget exceeding $10 million)
• Expertise in Snowflake, Star Schemas, ETL and Data Integration experience, design, documentation, development, testing, meta data management strategies, installation and support in complex data extract transformation and loads (ETL) (SQL, PL/SQL, Unix scripts, IBM Data Stage, Informatica (8.6)), Amazon AWS
• Architected, Configured, Administered OBIEE 11g, OBIA 11g:12c, Weblogic, OHS, conducted ad hoc reporting using OBIEE 10g, OBIEE 11g, Cognos 8.4, Cognos 10, Business Objects, MicroStrategy, Power View - SSRS, Power BI, Toad & SQL (MYSQL, Sybase, Teradata, SQL Server-2005, 2008, 2012, Oracle: 9i, 10g, 11g) to query the Data Warehouse for data
• Conducted Performance testing, unit testing and tuning on various SQL scripts on multiple database platforms: Oracle, Sybase, DB2, SQL Server, NoSQL and Teradata.
• Project Management experience with budgets over $9 million in the logistical sector
• Software Development Method Experience with projects exceeding $20 million: System Development Life Cycles: Agile, Waterfall and Spiral methods
• 4 + years of Quality Assurance experience writing and testing Use Cases (UML), designing ERD’s, technical documentation, and implementing agile and process improvements (PDCA)
• Served 10 years with United States Army; 7 years as a Logistics & Signal (Information Technology) Officer
• Confidential the acquisitions experience, Army components & processes experience

TECHNICAL SKILLS:

• OBIEE 10g, OBIEE 11g: 12c, OBIA, OAM, OID 11g-12c, OIM, Oracle EBS, Oracle E-Business Suite R12, BI Admin, BI Publisher, BI Analytics, BI Answers, Spend Analytics, Oracle Discoverer, WebLogic, Enterprise Manager, ODI, Oracle Fusion Middleware applications
• Oracle IDM 10g & 11g, OID 10g & 11g, Oracle Application Server 10g & 11g, Oracle HTTP Server, Oracle Process MGT, Dist. (OPM) Configuration MGT, OBIEE Security Interfaces (LDAP), DAC, Oracle E Business Suite, Oracle Forms, Oracle Reports, Oracle Federal Financials, Siebel Analytics, Endeca R12
• Tableau, Cognos 8.4, 10, Cognos framework MGR, Metric Studio, Events Studio, Report Studio, Query Studio, Analysis Studios, Power Transformer, Metric Studio, Business Insight, TM1, Cognos Real Time Monitoring, Cognos Admin, Cube data
• MicroStrategy, SharePoint, Power View-SSRS, SSRS 2008
• Business Objects, Business Objects Universe Design, Xcelsius, Business Objects Dashboard Design, Crystal Reports, Tableau, Toad, Oracle, Oracle grid control, RMAN, SQL & PL/SQL, MYSQL, Windows 98, 2000, XP, NT, DOS, Microsoft Project, Visio, Windows Server 2008, Microsoft Office
• Linux, Mandrake, UNIX, HTML, DHTML, CSS, PERL, PHP, CGI, C++, Python, JAVA, Visual Basic, SQL, MYSQL, XML, Java Script, Pearl, Oracle, XHTML, XML and jQuery, Windows Server 2008, Web Services
• Dream weaver, Flash, Photoshop, Illustrator, Fireworks, Front Page, Radio Propagation Software, Microsoft Office, Flowcharting, Toad

PROFESSIONAL EXPERIENCE:

Confidential

Senior OBIEE Engineer OBIEE-OBIA /WebLogic/EM/ODI/SOA/AWS/Peoplesoft

Responsibilities:

• Primary role as Senior Software OBIEE-OBIA Engineer (duties) includes: Architecture, Administration, Development, Compiles & Implementations
• Architect & Configured OBIEE 11g:12c, OBIA for Test, Development & Production environments
• Configuration of HCM, Financial, Marketing analytics and configuration of DVD in a MUDE environment
• Provide installation, configuration, patching support Oracle Middleware-SOA, BPM & OSB
• API & Forms integration utilizing SOAP & REST
• Manage & Develop a strategy / migration plan from OBIEE 11g to OBIEE 12c to Cloud
• Configure Security Apps with OBIEE-OBIA: OID, OAM, SSO, IAM
• Configured and Update rpd., catalog files, reports & security requirements within OBIA
• Created ERDs, white papers, requirement docs. and DFDs to assist during sprints and code implementations
• Created and Tested over 100 OBIA Analytic reports & dashboards inside the platform
• Managed Teams & Sprints for production code implementations
• OBIEE/OBIA report development type includes: Dashboards, Analytics, Views, Pivot tables, Graphs/Charts, Gauges, Funnels, Map View. View Selectors etc.
• Created the Physical, BMM, and Presentational Layer inside the rpd for an Enterprise OBIEE Architecture
• Over 5 yrs. Creating variables, roles, groups, filters, views, hierarchies, BMM & Presentational implementations and applying security within the rpd
• Implemented GROUPS, ROLE BASED ACCESS CONTROL in OBIA, OBIEE, EM, WebLogic
• LOADED Users, Updated Users via OID Interface
• Configuring Weblogic Admin Server, Node Manager and Managed Server for SSL
• Enabling Oracle OBIEE Internal SSL for OBIEE
• Generating the required certificates and key stores for SSL communication
• Successfully patched all 12 WebLogic managed servers with critical patches every quarter
• Successfully upgraded WebLogic to most current version with 0 % down time
• Created multiple ODI jobs, objects, workflows and configuration of projects
• Compile multiple jobs, add users and modify permissions
• Troubleshoot ODI errors, Analyzed job performance and scheduled jobs
• Created & troubleshoot multiple workflows
• Imported & Exported ODI jobs
• Troubleshoot multiple crashed jobs
• Updated User ‘s permissions to access jobs and workflows

Confidential

Senior OBIEE Engineer

Responsibilities:

• Architect & Configured OBIEE 11g for Patch, Test, Development & Production environments
• Implemented High Availability & Disaster Recovery architecture to supported OBIEE 11g
• Converting Salesforce analytics within OBIEE
• Extracting & Retrieving data to fuel OBIEE Developmental requirements
• Upgraded OBIEE 11.1.1.6 to 11.1.1.7 on all servers
• Administered Technical Deployments that supported over 8 subcomponents of Confidential
• Applied patches, added new functionality and features to OBIEE
• Created multiple variables: Static, Dynamic & Session to support the deployment process
• Created variables, roles, groups, filters, views, hierarchies and security within the rpd
• Merged multiple repositories and catalogs weekly for each subcomponent of Confidential
• Trouble shoot multiple admin and reporting issues that arose from multiple deployments
• Edited multiple configuration files and skins to the OBIEE 11g platform
• Designed, Edited & Test multiple reports & analytics for Confidential ’s executives to fuel operations
• Conducted Unit testing, Quality Assurance and User Testing on various user requirements, reports, dashboards and the OBIEE repository
• Created over 100 Analytics reports, Dashboards & BI Publisher reports
• OBIEE 11g reports included: Views, Pivot tables, Graphs/Charts, Gauges, Funnel, Map View, View Selectors and etc.
• Troubleshoot Logical SQL generated from views, tables and other physical elements

Confidential

Senior OBIEE E Architect

Responsibilities:

• Constructed the Architecture design for OBIEE 11g
• Troubleshoot errors that arisen after the migration from 10g to 11g
• LOADED Users, Updated Users via OIM Interface and OID Interface
• Installed, Configured, and Administered Oracle Identity Management
• Architected AUTHENTICATION and AUTHORIZATION Mechanism for all Applications
• Applied patches to fix bugs, added new functionality and features
• Performance tuned OBIEE 11g Application Tier as well as the Database Backend.
• Created Informational Dashboards, Subject Areas, and other Analytics using OBIEE
• Created Mapping Rules using Informatica for Transformations.
• Develop a migration plan from OBIEE 10g to OBIEE 11g
• Created variables, roles, groups, filters, views, hierarchies and security in rpd
• Created & tested over 175 reports & dashboards
• Created multiple Informatica jobs, objects, workflows and configuration of projects
• Compile multiple Informatica jobs, add users and modify permissions
• Created & troubleshoot multiple workflows
• Imported & Exported hundreds of jobs
• Troubleshoot multiple crashed jobs
• Updated User ‘s permissions to access jobs and workflows
• Conduct documentation, use cases, KPIs, report requirement specifications, QA reports, conducting testing and database designs to support reporting requirements
• Prepare qualitative and quantitative metrics as well as KPI’s for senior management and others using OBIEE 11g

Confidential

Senior OBIEE Engineer

Responsibilities:

• Installed & severed as OBIEE 10g & 11g Architect
• Conducted report Migration of OBIEE 10g to 11g
• Managed User Authorization within OID for all users
• Implemented GROUPS, ROLE BASED ACCESS CONTROL in OBIEE.
• Migrated over 100 reports, dashboards and metrics from 10g to 11g
• Troubleshoot multiple reporting errors because of the 10g to 11g migration within BI Publisher
• Constructed the Architecture design for OBIEE 11g,
• Designed the physical, business and presentation layer inside OBIEE BI Admin
• Creating variables, roles, groups, filters, views, hierarchies and applying security within the rpd
• Experience with OBIEE: BI Publish, Answers, Analytics, BI Interactive Dashboards, Performance MGT, BI Server, Web logic, Fusion MGR, Metrics & KPIs
• Created Interactive Dashboards that supported management metrics and KPIs
• Implemented session variables and other variables within the rpd
• Conducted Performance testing, unit testing and tuning on various SQL scripts on multiple database platforms
• Integration of Siebel and OBIEE

Confidential

Business Intelligence Consultant

Responsibilities:

• Created multiple views and Data Marts using ETL to store aggregated data and OLAP data within the Data Warehouse
• Created multiple framework models (data modeling) and OBIEE repositories that pulled data from Data Marts, tables and views which consisted of millions of rows of data
• Conduct ad hoc reporting using Teradata Studio Express, SQL assistant and Teradata to query millions of rows of data from the Data Warehouse
• Created hundreds of dashboard reports and metrics inside OBIEE-Analytics, Publisher and Cognos-Report Studio & Metric Design
• Construct various SQL statements using multiple joins, sub queries, views, tables and other complex queries
• Conducted Performance testing, unit testing and tuning on various SQL scripts on multiple database platforms
• Conduct documentation, use cases, KPIs, report requirement specifications, QA reports, conducting testing and database designs to support reporting requirements
• Prepare qualitative and quantitative metrics as well as KPI’s for senior management and others using OBIEE & Cognos
• Reporting experience: dashboard, drill down, date prompts, joining multiple queries to retrieve different data items from multiple sources, working with cube data, Cognos scripting as a work around without having framework access, List reports, crosstabs, charts, financial etc. to achieve management’s desired reporting metrics
• Served as OBIEE /Cognos Administrator, TM1
• Installed and configured Cognos reporting platform.
• Modeled multiple models for both cubes and reports that were required of JET reporting.
• Administered and managed the development, test and production environments for multiple projects and clients which included over 25 application servers.
• Build Framework model and reports.
• Created and analyzed sophisticated budgeting models and forecasts

Confidential

Business Intelligence Consultant

Responsibilities:

• Prepared qualitative & quantitative metrics & KPI’s for senior management and others using, OBIEE 10g, 11g, BI Admin, Cognos, Framework Manager, Business Insight Advance, Analysis Studios, Excel, Toad, Access, DB2
• Conducted ad hoc reporting using Toad & SQL (DB2) to query the Data Warehouse for millions of rows of data
• Conducted Performance testing, unit testing and tuning on various SQL scripts on multiple database platforms
• Implemented Cognos security standards, experience with Cognos Portal, SSO and Studio customization
• Prepared documentation use cases, KPIs, report specifications, QA reports, conducted testing and database designs to support reporting requirements
• Developed numerous Cognos reports using the company’s ERP software for improving strategies and operations, enhancing productivity, auditing, systems performance dashboards, and providing overall insight of the business
• Reporting experience included: drill down, date prompts, joining multiple queries to retrieve different data items or objects from multiple sources, working with cube data, Cognos scripting as a work around without having framework access, List reports, crosstabs, charts, financial etc. to achieve management’s desired reporting metrics
• Served as OBIEE /Cognos Administrator, TM1
• Installed and configured Cognos reporting platform.
• Build Framework model, repositories and reports.

Confidential

Business Intelligence Consultant

Responsibilities:

• Performed Data Analysis, Data mining, Code Review, Quality Assurance and Reporting on millions of rows of data to ensure consistency, integrity and stability of reporting data
• Report development with OBIEE, BI Admin, MicroStrategy and Power View-SSRS metadata
• Conducted Performance testing, unit testing and tuning on various SQL scripts on multiple database platforms
• Migrated data from a test to production environment using SQL & Unix export & import scripting
• Prepared qualitative & quantitative data using Excel and SQL (Oracle, Sybase, DB2, and SQL Server)
• Performed extensive analysis on data inside (JPAS) Joint Personnel Adjudication System database for the Confidential
• Worked with business users to determine and analyzed their reporting needs utilizing use / test cases, business flow processes, SQL, Excel and Access
• Developed complex queries in SQL (Sybase) using (ETL) temp tables, joins, views and sub queries

Confidential

Business Intelligence Consultant

Responsibilities:

• Prepared qualitative and quantitative metrics for senior management and other users using Cognos, Cognos Metric Designer, Cognos framework Manager, Excel, SQL plus, Access, Oracle, DML and Toad
• Prepared business logic flows, process flows, use and test cases for the development of application software and adhoc queries
• Worked with business users to determine and analyze their reporting needs utilizing Cognos, Toad and SQL
• Developed complex queries in SQL using joins and sub queries
• Performed data profiling within Toad and Framework Manager to ensure Data Integrity is maintained across the board.
• Designed ERD’s using Microsoft Visio to assist with data ware house development
• Extensive MMIS experience and analysis of various claims
• Experience working with various claim forms (HCFA, UB04)
• Experience working with various coding systems CPT, ICD-9, and UB04 Codes
• Used JAD to conduct implementations to the Cognos and aligned key technical, business and finance terms for hundreds of tables inside the Oracle Data Warehouse
• Developed numerous reports (Cognos, Excel, Access, SQL) using the company’s ERP software for improving strategies and operations, enhancing productivity and providing overall insight of the business
• Conducted ad hoc reporting using ETL, Toad and SQL (Oracle) to query millions of rows of data along with creating & updating temporary tables for Data Warehouse along with meeting quality assurance measures and SLA’s
• Conducted Performance testing, unit testing and tuning on various SQL scripts on multiple database platforms
• Data layout/design/format and functional process requirements, relational and dimensional models for report design.
• Built Cognos Score Cards & dashboard-style reports; combining list, cross-tabular, chart displays, drill-down/up and drill- through reports, detail list-style reports prompted reports and reports delivered in multiple formats (html, pdf, xls)
• Reporting experience included: drill down, date prompts, joining multiple queries to retrieve different data items from multiple sources, working with cube data, Cognos scripting as a work around without having frame work access, List reports, crosstabs, charts, financial etc. to achieve management’s desired reporting metrics
• Served as Cognos Administrator

Confidential

Business Intelligence Consultant

Responsibilities:

• Prepared qualitative & quantitative metrics for senior management and other users using Cognos, Business Objects XI, Dashboard Design, Crystal Reports, Excel, Toad, Access, Oracle, DML and Word
• Designed and managed a corporate dash board using Business Objects Dash Board design platform, which allowed top-level management to seamlessly account for newly activations, revenues and expenses in a corporate format while applying Six Sigma Methodologies
• Conducted ad hoc reporting using ETL, Toad & SQL (Oracle) to query the Data Warehouse for data
• Prepared business logic flows, process flows, use Cases and test Cases for the development of application software and adhoc queries
• Designed ERD’s using Microsoft Visio to assist with Data Warehouse development
• Analyzed, designed, reviewed metrics with senior management and assisted with meeting quality assurance measures and SLA’s
• Developed Business Object reports that allowed our marketing department to track newly subscribers, customer deactivations and monitor the results of new product launches
• Converted People Soft Financials to Business Objects Reports
• Performed adhoc analysis by reviewing our current reports and making recommendations to senior management on which marketing campaign was more advantageous to the company