TECHNICAL SKILLS

Dimensional Modeling: Kimball methodology

Other Analytics Tools: Tableau, JasperSoft, Pentaho, Crystal Reports, SAP BusinessObjects, Microstrategy (2 years)

ETL/Data Integration/Data Quality: Pentaho DI (Spoon/Kettle), Oracle Warehouse Builder, Talend, Informatica Powercenter Express (5 years)

Analytics Best Practices: Data Governance, Change Management

SQL Tools: Quest TOAD, Oracle SQL Developer, PLSQL Developer, Aginity (Actian Paraccel/Matrix)

Data Virtualization: Cisco Information Server (formerly known as Composite Software)

MS Office: MS Excel (Power BI), Access, Word, Powerpoint, Visio, Project Issue Tracking and Collaboration Atlassian JIRA, Atlassian Confluence, MS Sharepoint

Data/Text Mining: RapidMiner Studio 5 Javascript, PL/SQL, HTML5, CSS3, Python

Big Data (Hadoop): Cloudera distribution

PROFESSIONAL EXPERIENCE

Confidential, Centreville, VA

Lead Data Architect

Responsibilities:

• I Re - architect the Confidential enterprise information management (EIM) architecture to evolve data storage/preparation/access as well as ensure organizational SLAs and data latency requirements are met
• Assist the Confidential analytics team with stabilizing the current EIM architecture ( several source systems, Informatica, SnapLogic, Actian Matrix, Oracle, Cisco Information Server (data virtualization), Confidential, IBI WebFOCUS, Tableau, Zoomdata, Hadoop, BMC Control-M )
• Implement change management processes Thought leadership

Confidential, Fairfax, VA

Manager - Business Analytics

Responsibilities:

• Conducted trade study/market analysis (and follow up whitepapers, presentations) to align business requirements and best-of- breed analytics tools for new implementation in the cloud ( Confidential ) - customer chose Confidential (RDBMS - Oracle) Managed and mentored team of six staff members (senior analysts, statistician) Managed the following projects to ensure timely delivery and consistent quality: Data Support, Data Governance, Data Integrity, Compliance, Research Lead data governance effort (DG charter, regular meetings, standardized business definitions)
• Lead evaluation of data integration/ETL tools to build data warehouse (heterogeneous data repositories are currently being used for analysis) Created dimensional model (Kimball methodology) that maps business processes to a central data repository (EDW) to facilitate consistent analysis Created management and public-facing dashboards using Tableau Desktop and Tableau Server in AWS Created robust metadata models and sophisticated BI content (dynamic reports, cubes) for end user self-service using the Confidential 10 (v.10.2.2) software stack - installed/configured Cognos 11 for evaluation Leveraged the Pentaho Data Integration tool (Kettle/Spoon) to match disparate datasets using string similarity/distance algorithms (Jaro-Winkler, Damerau-Levenshtein) Leveraged Agile methodologies (Scrum, Kanban) for several projects/deliverables Assisted organizational recruiting efforts by creating, re-writing, and re-organizing disjointed data analytics job profiles under a common job family

Confidential, Fairfax, VA

Lead - Software Developer

Responsibilities:

• Lead data warehouse implementation project (assisted with client briefings, resource planning, project schedules)
• Created and performed troubleshooting on ETL mappings developed in Oracle Warehouse Builder (OWB)
• Developed complex drill through reports using Confidential Report Studio 10.1
• Redesigned current metadata models in Confidential 10.1 Framework Manager using best practices
• Assisted organization in increasing the visibility of the shared business intelligence solution among prospective clients (briefings, demos)

Confidential, Falls Church, VA

Sr. Consultant

Responsibilities:

• Lead Cognos admin for migrating Cognos content in secure subnet and server facility
• Lead report developer for Cognos Planning 8.2 project (using real-time connection between Report Studio and Contributor cubes)
• Assisted with the agency-wide migration from Cognos Series 7 (client/server) to Cognos 8 (web-based)
• Updated production monthly accounting and budget cubes using automated process (via batch script)
• Assisted primary ETL developer with creating and troubleshooting mappings for data warehouse developed using Oracle Warehouse Builder (OWB)
• Installed, configured Cognos 8.x (multi-tiered/distributed architecture - web, app, database server)

Confidential, Alexandria, VA

Sr. Cognos Developer

Responsibilities:

• Installed, configured Cognos 8 and Cognos ReportNet (single server architecture)
• Created metadata models and reports using Cognos 8 - Cognos Framework Manager, Report and Query Studios -I- Installed, configured Cognos Series 7 (Impromptu, Powerplay - web and client) on a multi-server architecture -I- Gathered requirements, developed and maintained Series 7 Powerplay cubes and Impromptu reports

Confidential, Falls Church, VA

Sr. Software Engineer

Responsibilities:

• Converted major publications/reports from MS Access to Impromptu and Powerplay
• Assisted in the organization-wide (51 immigration courts) migration from MS Access to Cognos Impromptu 7.0 -I- Created and maintained an Access database that tracked reporting issues during the migration

Confidential, Lanham, MD

Sr. Software Developer/Engineer

• I Created Powerplay cubes and Impromptu reports using marketing and customer purchasing data -I- Wrote and maintained technical specification documents

Confidential, Fairfax, VA

Sr. Technical Lead

Responsibilities:

• Served as technical lead for company-wide upgrade to current version of Cognos software
• Developed and maintained interactive MS Access application (database, form, reports) for Cognos licenses
• Development, administration and support of Impromptu, Powerplay and Crystal reporting tools (Oracle and Sybase database platforms - 10 servers, 11 service centers across the country)

Confidential, Richmond, VA

HR Lead Analyst

Responsibilities:

• Served as Business Intelligence Lead on Cognos Powerplay implementation
• Developed and maintained a custom Exit Interview Survey System (EISS) in Microsoft Access (database, queries, data entry form, automated front-end reports, etc.)
• Created interactive Microsoft Access form to capture management feedback on current reports -I- Created and distributed management reports using Seagate Crystal

Confidential, Baltimore, MD

Healthcare Analyst

Responsibilities:

• Created reports, developed test plans, coordinated with programmer in the creation of a Visual Basic front-end tool
• Assisted with analyzing Home Health Agency (HHA) data used to create a new database, corporate publication, and custom HHA reports

Confidential, Baltimore, MD

Healthcare Consultant

• Conducted detailed analysis of hospitals and health systems