PROFESSIONAL SUMMARY

• 12 years of IT experience including BI Logistical / Financial Federal / State Government Reporting Solutions, Online charging system OCS Implementation, System Development Life Cycle implementation SDLC , Cohort Analysis, RUP methodology, PMP methodology, System Integration of Portals, Java, Unix, Linux, J2EE, exposure to PeopleSoft, cloud computing architectures and other program application developments project budget exceeding 10 million
• Expertise in Snow flake Star Schema, ETL and Data Integration experience, design, documentation, development, testing, meta data management strategies, installation and support in complex data extract transformation and loads ETL using SQL, PL/SQL and Unix scripts Informatica 8.6
• Conducted ad hoc reporting using ETL, 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, and Teradata.
• Project Management experience with budgets over 9 million in the Technical Logistical sector
• Software Development Method Experience with projects exceeding 20 million: System Development Life Cycle, 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

TECHNICAL SKILLS

• OBIEE 10g, 11g, Oracle EBS E-Business Suite 11.5 R12, BI Admin, BI Publisher, BI Analytics, BI Answers, Spend Analytics, Oracle Discoverer, Weblogic, Enterprise Manager, Oracle Fusion Middleware applications, Oracle IDM 10g 11g, OID 10g 11g, Oracle Application Server 10g 11g, OBIEE Security Interfaces LDAP , Oracle E Business Suite, Oracle Federal Financials
• 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, Xcelcius, Business Objects Dash Board Design, Crystal Reports
• Toad, Oracle 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 , JAVA, Visual Basic, SQL, MYSQL, XML, Java Script, Pearl, Oracle, XHTML, XML and JQuery, Windows Server 2008
• Dream weaver, Flash, Photoshop, Illustrator, Fireworks, Front Page, Radio Propagation Software, Microsoft Office, Flowcharting, Toad,

PROFESSIONAL EXPERIENCE

Confidential

Department of Homeland Security DHS

• Business Intelligence Consultant: Oracle EBS / OBIEE Architect/ Admin
• Installed Configured OBIEE 11g for Patch, Test, Development Production environments, which included over 9 Linux servers
• Created BI and analytics reports dashboards
• Troubleshoot errors that occur inside BI Publisher Analytics reports dashboards during deployments
• Configured OBIEE 11g for DAC use
• Implemented High Availability Disaster Recovery architecture to supported OBIEE 11g
• Upgraded OBIEE 11.1.1.6 to 11.1.1.7 on all servers
• Administered Technical Deployments that supported over 8 subcomponents of DHS
• Applied patches to fix bugs, added new functionality and features, and installed maintenance releases
• Created multiple variables: Static, Dynamic Session to support the deployment process
• Technical Deployments consisted of merging multiple repositories and catalogs weekly, for each subcomponent of DHS
• Trouble shoot multiple admin and reporting issues that arose from multiple deployments on a weekly basis to support DHS and all its' multiple lines of business for over 10 tenants using the same OBIEE platform
• Edited multiple configuration files and skins to the OBIEE 11g platform
• Designed Edited multiple reports for DHS's executives to fuel operations
• Conducted Unit testing, Quality Assurance and User Testing on various user requirements, reports, dashboards and the OBIEE repository
• GSA 14424 Albemarle Point Place, Chantilly, VA 20151 Business Intelligence Consultant: Oracle EBS / OBIEE Architect/ Admin
• Conducted Performance testing, unit testing and tuning on various SQL scripts on multiple database platforms
• Created Interactive Dashboards that supported management metrics and KPIs
• Designed models using query builder or adhoc SQL, which joined multiple tables, sub queries, views and etc.
• Created multiple variables: Static, Dynamic Session to support the deployment process
• Applied patches to fix bugs, added new functionality and features, and installed maintenance releases
• Accessed Implemented a migration strategy and migrated over 175 reports from OBIEE 10, Cognos, Business Objects, People Soft Financials to OBIEE 11g platform
• Designed multiple repositories that supported 175 OBIEE 11g reports
• Created designed the physical, business and presentation layer inside BI Admin that supported over 175 OBIEE 11g reports
• Constructed the Architecture design for OBIEE 11g, Web logic. and Oracle 11g that supports over 100 million rows of data
• Created designed over 175 reports, dashboards, bar charts and other metrics inside OBIEE 11g using BI Publisher, BI Analytics and adhoc SQL.
• 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
• 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.
• Installed and Configured OBIEE 10g, 11g, and upgraded 10g to 11g.
• Troubleshoot errors that arisen after the migration from 10g to 11g and sustainment of 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

Confidential

Business Intelligence Consultant: OBIEE Architect / Admin

• Installed severed as OBIEE 10g 11g Architect
• Conducted report Migration of OBIEE 10g to 11g
• Migrated over 100 reports, dashboards and other metrics from 10g to 11g
• Troubleshoot multiple reporting errors as a result of the 10g to 11g migration within BI Publisher and Analytics
• Constructed the Architecture design for OBIEE 11g, Weblogic and Oracle 11g which supports over 100 million rows of data
• Designed the physical, business and presentation layer inside BI Admin that supported over 100 OBIEE 11g reports
• Designed multiple repositories that supported 100 OBIEE 11g 10g reports
• 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
• Managed User Authorization within OID for all users
• Conducted Performance testing, unit testing and tuning on various SQL scripts on multiple database platforms
• Implemented GROUPS, ROLE BASED ACCESS CONTROL in OBIEE.
• Implemented PASSWORD POLICIES based on the DOD DIACAP protocols both at Application levels and OS Levels
• LOADED Users, Updated Users via OID Interface

Confidential

Business Intelligence Consultant

• Reporting experience includes: 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 round without having framework access, List reports, crosstabs, charts, financial and etc. to achieve management's desired reporting metrics
• Prepare qualitative and quantitative metrics as well as KPI's for senior management and others using OBIEE Cognos
• Conducted Performance testing, unit testing and tuning on various SQL scripts on multiple database platforms
• Construct various SQL statements using multiple joins, sub queries, views, tables and other complex queries
• Created hundreds of dashboard reports and metrics inside OBIEE-Analytics, Publisher and Cognos-Report Studio Metric Design
• Conduct ad hoc reporting using Teradata Studio Express, SQL assistant and Teradata to query millions of rows of data from the Data Warehouse
• Create 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
• Create multiple views and Data Marts using ETL to store aggregated data and OLAP data within the Data Warehouse
• Conduct documentation, use cases, KPIs, report requirement specifications, QA reports, conducting testing and database designs to support reporting requirements
• 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 on large data sets using TM1
• Performed Complex modeling utilizing TM1 environment.

Department

Business Intelligence Consultant

• 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 round without having framework access, List reports, crosstabs, charts, financial and etc. to achieve management's desired reporting metrics
• 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
• Implemented Cognos security standards, experience with Cognos Portal, SSO and Studio customization
• Conducted Performance testing, unit testing and tuning on various SQL scripts on multiple database platforms
• Conducted ad hoc reporting using Toad SQL DB2 to query the Data Warehouse for millions of rows of data
• 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
• Prepared documentation, use cases, KPIs, report specifications, QA reports, conducted testing and database designs to support reporting requirements
• Served as OBIEE /Cognos Administrator,TM1
• Installed and configured Cognos reporting platform.
• Build Framework model, repositories and reports.

Confidential

Business Intelligence Consultant

• 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 Department of Defense
• 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

• Performs as the Mobile Primary System Administrator
• Interfaces with end users to deploy/migrate packages between environments, and implements package securities and user capabilities
• Serves as the primary contact for Business owners when addressing reported errors, issues, or concerns within the mobile environment
• Develops, tests, debugs, maintains and supports Microstrategy Dashboards, Documents and Reports
• Replicated available projects, and also merged them via project merger and users via user merger wizard and also executed and created scripts to various administrative tasks by using command manager, object manager
• Examined Server usage by enterprise manager
• Performed fine tuning of performance of SQL and of the MicroStrategy intelligencer server based on the workload performed
• Created narrowcast services for email sending from the directory in formats of report, PDF or excel files and grid reports
• Applied migration of narrowcast server objects from development to production
• Created and maintained the schema objects ie the attributes, the facts, and the hierarchy as well as the metrics
• Developed the free form SQL reports, reports, standard reports and Dashboard reports
• Applied report services for different banded report in order to satisfy the requirement of printing of the user
• Done quality analysis along with production migrations of the MicroStrategy objects and in the production environments using object manager and project duplication process
• Extensively used Metrics, Compound Metrics, Filters, Custom Groups and Consolidations.
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop and Architect.
• Created Transformations for comparative reports like sales this year-to-date, Month- to-date, Quarter-to-date etc.
• Worked extensively on creating Application Objects like Metrics and Compound metrics, Filters, Custom Groups and Consolidations for complex reports
• Extensively worked on Report Services to create performance dashboard reporting

Confidential

Business Intelligence Consultant

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
• 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
• Data layout/design/format and functional process requirements, relational and dimensional models for report design.
• Conducted Performance testing, unit testing and tuning on various SQL scripts on multiple database platforms
• 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
• 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 round without having frame work access, List reports, crosstabs, charts, financial and etc. to achieve management's desired reporting metrics
• Served as Cognos Administrator

Confidential

Business Intelligence Consultant

• 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

Confidential

Sr. Business Consultant Analyst

• Performed an exhaustive qualitative and quantitative analysis on various companies throughout the USA in various industries with annual sales ranging between 600,000 100,000,000 in revenues
• Analyzed the following: P L Statements, Balance sheets, Optimal Reporting , Quick Ratios, Current Ratios, Debt to Equity Ratios, Working Capital Ratios, Net Worth Ratios, Current Liabilities to Net Worth Ratios, Return on Assets Ratios ROA , Liquid Ratios, Profitability Ratios, Activity Ratios, Gross Profit and Operating Profit Margins, ROI, and Break Even Analysis
• Projected oral reports supported by charts and graphs to demonstrate how revenue opportunities were being loss
• itorious Service during Operation Iraqi Freedom III