TECHNICAL SKILLS:

Applications / Modules: Oracle Application Server Pages

Databases: Oracle, Teradata, BD2, MS SQL Server, Sybase

Languages: SQL, HTML, Java, C++, Job Control Language (JCL)

Methodologies: Agile Analytics, Scrum, Rational Unified Process (RUP/UML), Zachman Framework, Inmon (Data Warehousing), Kimball (Data Warehousing), Bachman, Software Development Life Cycle (SDLC), Waterfall, Information Engineering, Finkelstein, Object Oriented, IDEF, Yourdon and Demarko (Structured Analysis)

Operating Systems: MS Windows, UNIX

Software: Microsoft Office Suite, including MS Project, XML, Microsoft SSIS/SSRS/Power BI, Oracle Business Intelligence Enterprise Edition (OBIEE), Informatica Power Center/Exchange, MDM, IDD and Spherion, Oracle Enterprise One, Oracle Application Server (Suite), CA All Fusion, Popkin System Architect. Rational Clear Case, Rational Rose, Oracle Warehouse Builder, ETI *Extract, Informatica (Power Center/Mart and Power Exchange), DataStage, Pentaho, Ab Initio, Cognos, Powerplay, MicroStrategy, ActaWorks, Tableau, Qlik, Cognos Framework, Business Objects, Hyperion - Brio, SAP, Erwin/Model Mart, ER Studio, Data Cruncher, Net Commerce, Multi Load/Fast Load, Web Sphere, MQ Series, Cool Gen, ADW, Power Designer, Red Brick, Popkin, ARC GIS (Geospatial), SAS/BI, Cloudera/Hadoop/Big Data

PROFESSIONAL EXPERIENCE:

Confidential, MD

Technical Business Intelligence Manager

Responsibilities:

• Create a Business Intelligence Roadmap to define a process for implementation data and analytics solutions.
• Review Statement of Work for potential task orders and proposal for implementation of solution.
• Design/develop Phase 1 dashboard for analysis of enterprise centric data artifacts.
• Interface with customer and development teams to mitigate risk, ensure delivery of solutions are completed on time and within budget, and maintain current status of assigned tasks

Confidential, VA

Technical Business Intelligence Manager

Responsibilities:

• Manage Business Intelligence (Data Warehousing) initiative.
• Determine Return on Investment for Marketing Activity initiatives.
• Migration of Legacy IT applications.
• Design and implement data and analytics entry portal ((dashboard) by performing requirements gathering and system analysis, performing data analysis, create data models (logical/physical), develop ETL data mapping, design star schema data models, discover data anomalies, and recommend/implement data quality transformations. Lead data architect
• Work with business analyst and stakeholders to design a phased approach for the implementation of a Data Warehousing/Business Intelligence solution that fosters a platform for data and analytics.
• Design and implement Master Data Management via Hub and Spoke methodology utilizing Informatica MDM tool
• Development environment consist of MS SQL Server and utilizes SSIS, SSRS, and Power BI, and SQL Programming for dashboard implementation
• Design and implement management reporting utilizing OBIEE and front end tool with Informatica Power Center as Data Integration tool. Include statistical analysis utilizing R for data manipulation, calculation, and graphical display (with Shiny/SAS), and initiate Big Data via Cloudera
• Data integrated with upstream extract from source systems and downstream data generated via data integration

Confidential, VA

Business Intelligence Technical Manager

Responsibilities:

• Technical manager allocated to the Business Intelligence practice.
• Migrate legacy mainframe, flat file, and other source data files into a single architecture for data analytics and analysis
• Manage a team of data architects and ETL developers to analyze source data that will be aligned to existing EDW operational data store.
• Lead data architect/modeler with over fifteen years of Enterprise data architectures expertise with Big Data, NIEM, and Master Data Management (hub and spoke)
• Perform requirements gathering and system analysis, data analysis, data mapping, logical data modeling, functional design, discover data anomalies, and recommend/implement data quality transformations.
• Extensive knowledge and experience in understanding logical mapping and data model to build Physical Design characteristics. Once the data is analyzed and system of record is determined, it is moved to staging database via ETL mappings and workflows.
• Create Integrated Data Dictionary and Master Data structures, utilizing Informatica MDM and IDD tools.
• Recommend ETL strategy identified load frequency and designed /developed ETL mappings and workflows. The long range goal is to build independent and dependent data marts. The data marts were multidimensional data structures that were star schema or galaxies. The data marts were built as Type 2 slowly changing dimensions that were also conformed for the organization.
• Tools utilized included Erwin, Informatica 9.5, INFA MDM, IDD, and Spehrion, OBIEE, and Agile Scrum, and SQL Programming for dashboard implementation and data analysis and SELC methodology deliverable documentation.
• Expertise with product and product installation into technical environment commercial and government environment, with emphasis on Case Management application.

Confidential, CO

Business Intelligence Practitioner

Responsibilities:

• Covance Pharmaceutical, the Technical Lead for the creation of the Investigator Data Warehouse and Master Data Management Solution ( Confidential ).
• Performed requirements gathering and system analysis, data analysis, data mapping, logical data modeling, functional design, discover data anomalies, and recommend/implement data quality transformations.
• Created the Naming and Security Standards document to establish guideline for creation of business intelligence solution artifacts.
• Created an ETL Framework to establish technical guidelines for creation of the data warehouse/business intelligence solution.
• Created with corresponding Source to Target Mappings for Source to Staging, Staging to Master Data Management (MDM), Staging to Data Warehouse, and ETL Mapping and Integrated Data Dictionary.
• Sales Force Automation solution was developed to automate the business tasks of sales, including order processing, contact management, information sharing, inventory monitoring and control, order tracking, customer management, sales forecast analysis.
• Tools utilized to performs these tasks included Informatica Power Center 8.6, Business Objects, MicroStrategy, Microsoft BI, SQL Programming for dashboard implementation, TIBCO-CIM Master Data Management, and Oracle 11g. Methodologies included Agile Scrum.

Confidential, VA

Senior Architectural Specialist

Responsibilities:

• Lead for Data Population Team which is responsible for the extraction, transformation and load (ETL) for source systems data. The tool utilized to performs these tasks, Informatica Power Center 8.6.
• Included team is also tasked with performing Change Data Capture of data updates capture database logs and mainframe database journal, the tool used to perform these tasks, Informatica Power Exchange.
• The overall goal of the development team is to build an Operation Data Store ( Confidential ), Enterprise Data Warehouse, and independent Data Marts.
• Created dashboard and reports with MicroStrategy BI tool and OBIEE and SQL scripting for data profiling and analysis

Confidential, VA

Data Warehouse Project Manager

Responsibilities:

• Project manager for Data Warehousing/Data Quality initiative for Confidential Pharmaceuticals (R&D).
• Responsible for performing data quality audits (Trillium), update/maintenance of the Enterprise Data Architecture Model (logical), and the development of Confidential /data warehouse.
• Duties included design/architecture of logical/physical Operational Data Store ( Confidential ), Multidimensional data structures, design and development of ETL mappings for data transformation/load and development of BI front-end and SAS reports.
• The tool used to develop logical/physical Data models - Confidential .
• Responsible for completing data quality audits utilizing Trillium. (Oracle 10g, Oracle Warehouse Builder, Cognos Framework).

Confidential, VA

Data Warehouse Architect

Responsibilities:

• Principal Consultant/Data Architect, Air Force Integrated Logistics Support System, (Supply Chain Management).
• Assisted in componentized, e-development and data warehousing initiative ( Confidential ), utilizing an iterative approach to the Rational Unified Process (RUP/UML) and Open Application Group ( Confidential ) XML Business Object Documents ( Confidential ).
• Also participated in the design of a geospatial Confidential for the Environmental Protection Agency.
• Responsible for the creation of relational (logical and physical) and object relational (multidimensional) database structures (data models).
• Also responsible for correct application of data types, domain, validation, and valid values (reference tables). In the creation of these structure the techniques of data normalization (3NF), forward/reverse engineering, and data standardization were utilized.
• The approach used in the development of the data marts included determination of user requirements (including hardware/software, full scope of business intelligence needs, determination of “solution” required.
• The logical e-development framework was built with WebSphere as the web server with Broad Vision gateway, Broad Vision Enterprise 6.0 Portal Interaction manager, and Oracle 9iAS as the database, and IBM WebSphere application server.
• Other technologies utilized include Confidential, DB2, SAS BI, Informatica Power Center, Business Objects, Oracle 9iAS (Web Builder), Enterprise Java Beans, J2EE and XML.

Confidential, IL

Data Warehouse Architect

Responsibilities:

• Principal, Data Warehouse ( Confidential ) Manager/Lead Data Architect for Confidential, Data Services, Center of Excellence, as a Data Warehouse Architect/Project Manager.
• As Business Intelligence experts for the Center of Excellence, team established the Confidential Data Warehousing Methodology and prepared the Business Case (data warehouse assessment) documentation for Consumer Healthcare, Research and Development, and Clinical Trials Division(s).
• The assessment(s) began by conducting interviews with executive level management (president/vice presidents) to ascertain business visions, goals, and objectives and sponsorship.
• These findings we used to develop and an executive background, understand business risks, benefits analysis, business readiness and determine scope of entire data warehouse initiative, and gave insight into key bottlenecks of management reporting process, which is a key element in business intelligence.
• In the technology phase we interviewed business analyst and IT staff to determine Data Analysis & Requirements, which is the basis for constructing logical/physical Operational Data Store (data models), Multidimensional design, and doing data source mapping/analysis.
• ETL Tool is Infomatica Power Center, Modeling tool Confidential, Oracle 8I database and MicroStrategy BI tool. Data sources SAP, Microsoft SQLServer, DB2, Sybase, and Informix.

Confidential, MA

Data Warehouse Project Manager

Responsibilities:

• Project Manager on contract to Confidential (South America).
• Responsible for the development of Customer Relationship Management data warehouse/ Confidential, within Marketing Management section of bank.
• The Information Technology architecture consisted of Host/Source data (Mainframe and SQL Server) that was transformed/loaded (Sagent Confidential ) into and Operational Data Store (Teradata and MultiLoad).
• A multidimensional DBMS (snow-flakes and galaxies on Teradata) is then accessed via and OLAP (Micro Strategy).
• As an added dimension to project knowledge discovery development was deployed to increase marketing, segmentation, and campaign management.
• Technical lead, on contract to design an Electronic Commerce website.
• Hosting Confidential is Confidential RS 6000 with AIX designed logical and physical data models with Erwin for an Oracle 8 database.
• The Application Component was Net Commerce and Application Server WebSphere with MQ Series Middle.

Confidential, VA

Project Manager

Responsibilities:

• Technical Manager, this position required both technical and managerial responsibilities.
• Migration of legacy disparate application data into Operational Data Store ( Confidential )
• Lead team of data warehouse architects in the creation/modification of logical/ physical database designs and data warehouse ( Confidential ) database designs (determining user requirements, utilizing star schema methodology, to develop facts, dimensions and hierarchies in a multidimensional database structure).
• Client base included Defense Finance Accounting Service (DFAS), Campbell’s Soup International, and Vlasic Foods International.
• Tools utilized include Oracle Designer 2000/ Confidential Suite/Discover, SAS, Confidential, Business Objects, and various other modeling and ETL (Extract/Transfer/Load) tools.

Confidential, VA

Consultant

Responsibilities:

• Data Administrator/Modeler, assigned to Confidential, Servicer Division.
• This project dealt with inception through deployment phases of database application design ( Confidential ) and maintenance within the Mortgage Servicing division.
• Duties consist of (but are not limited to) creation of logical and physical data models, creation/modification of physical databases, performance tuning, and optimization of physical database.
• The database software used in this project is Sybase 10 and the CASE tool(s): Sterling Software Application Development Workshop (ADW object-oriented development) and ERWIN 2.5 SQL Windows.
• The application GUI uses SQL GUPTA Windows.
• Operations partitioned with both Windows and OS2 WARP.
• Methodology used in the creation of applications: Object Oriented.