SUMMARY:

• Energetic, driven, and accomplished IT/project management professional with a track record of successful project delivery for federal/non - federal client. Strong ability to engage business/IT teams, analyze data, and develop solutions.
• IT leader who bridges the gap between business and technology driving solutions from inception to execution. Thrives on challenge and works well under pressure, with technical expertise to learn new environments quickly, and solve business problems.
• Pursued learning of AWS, Hadoop ecosystem and Splunk.
• Budgeting & Financing Planning Business Operations
• Consulting Project Management Team Building/Leadership
• Data Warehousing Business Intelligence (BI) Data Analysis/Modelling
• OLAP/ETL Requirements Gathering & Analysis Data Architecture

TECHNICAL SKILLS:

Methodology: Agile, Rational Unified Process (RUP), Unified Modeling Language (UML), System Development Life Cycle (SDLC)

Databases & Related Tools: DB2, Toad (DB2, MySQL, Oracle), Oracle 10g, Oracle SQL Developer, MS SQL Server/Enterprise Manager, SQL Server DTS, Query Analyzer, T-SQL, Sybase, Teradata, MS Access, Informix, Oracle 9i Designer, Erwin, DataStage, SQL, Oracle PL/SQL, SQL*Plus, SQL Scripts, SQL Loader, MS Query, SQL Navigator, Rapid SQL, Command Center, and SQL Advantage

Business Intelligence Tools: Pentaho BI, Pentaho Report Designer, Pentaho Data Integration, MicroStrategy Application Suite 9.4 (I-Server, Desktop, Web, Report Services, Office, Architect, Object Manager, Enterprise Manager, Narrowcast), SAS (Base SAS, OLAP Cube Studio, Information Map Studio, Web Report Studio, Enterprise Guide), WebFOCUS (Developer Studio, Managed Reporting, Business Intelligence Dashboard, Reporting Server, ReportCaster/Library), Business Objects XI (Central Management Console (CMC), InfoView, Web Intelligence (Webi), Crystal Reports Server XI, Crystal Reports 10 & XI), JasperSoft tools, Cognos PowerPlay & Impromptu, and Oracle Discoverer

Platforms: Linux; Windows, TomCat, Windows 2000/2003 Server & IIS, and UNIX

Applications: Putty; WinSCP; JIRA; MS Team Foundation Server, VMware vSphere, DOORS, TestDirector for Quality Center, Rational ClearQuest, MS Office, Visio, MS Project, QuickBooks, SharePoint, and MS FrontPage

Languages: XML, Java, HTML, ASP, VBA, and C++

PROFESSIONAL EXPERIENCE:

Confidential, VA

BI Analytics/ETL Developer

Responsibilities:

• Used Pentaho Business Analytics and Data Integration tools, DB2, and MySQL to support the Budget Review Division (BRD) in preparation of the President’s Federal Budget.
• Supported development of Max.gov capabilities for government-wide data collection and analytics applications.
• Met with business partners to gather requirements, transformed business requirements to technical requirements, performed data analysis and data modeling, developed work estimates and set priorities, defined Mondrian schema/cubes, created ETL and reports/dashboards. Delivered critical reporting for Navy Bureau of Medicine Portal for Readiness and Emergency Preparedness. Additional worked with internal clients to support budget activities, and with SBA, and DHS Agencies.

Confidential

Architect/developer

Responsibilities:

• Supported Public and Indian Housing (PIH) Real Estate Assessment Center (REAC) to provide users with access to information for assessing the condition of Confidential ’s housing portfolio. Worked hand-in-hand with iNtegrated Assessment Subsystem (NASS) business stakeholders to understand their reporting needs.
• Led a collaborative team, provided technical guidance, and prioritized work to meet task order deliverables. Worked with various business areas to collect requirements and then architected/designed technical reporting solutions.
• Created reports/dashboards for Next Generation Management System (NGMS) Portfolio Risk Management Tool (PRMT) and Public Housing Assessment System (PHAS) scoring. Information presented was based on the financial, management, physical and capital fund data. The dashboards utilized various visualizations, grids/graphs and provided users with interactivity to view their data. In addition, users had the ability to navigate from dashboard to dashboard to view different levels of data. Responsible for project design and metadata definition, provided ad-hoc reports, data visualizations and dashboards for various business areas, performed data analysis, unit testing of reports, training and documentation.

Confidential

MicroStrategy Architect/Developer

Responsibilities:

• Agile development of dashboards/reports for Service Performance Measurement (SPM)project which enabled USPS to measure and analyze performance of commercial mail delivery. Responsibilities included data analysis, data modeling, schema definition/design, project metadata creation, report/dashboard development, and testing.

Confidential

MicroStrategy Architect/Developer

Responsibilities:

• Supported Cyber Analytical Workbench System (CAWS) project for DIA's Office of Cyber Threat Analysis (CTA) - purpose was to analyze information from all available intelligence sources and perform trend/predictive threat analysis of cyber threats to DoD information systems and infrastructures.
• Constructed MicroStrategy project and dashboard/reports to aid cyber analysts. Maintained customized MicroStrategy security module (using SDK) to access reports/dashboards from an application portal. Devised table and SQL scripts to load test data into Oracle tables. Developed documentation for CAWS MicroStrategy Design.

Confidential

MicroStrategy Developer

Responsibilities:

• Supported MHA-C Loan File Staging project to develop reporting solution using MicroStrategy. Created report mockups in Excel.

Confidential

MicroStrategy Architect/Developer

Responsibilities:

• Supported USPS Phoenix Reporting project to develop reporting solution using MicroStrategy - designed reporting data model, created data warehouse tables in MS Access and developed prototype reports

Confidential

BI Architect/Developer

Responsibilities:

• Technical consultant for the Office of Evaluation within the U.S. Department of Housing and Urban Development ( Confidential ) - supported a BI effort for their multi-billion-dollar multifamily portfolio. Developed business requirements for the data mart and the data model. Created project metadata using MicroStrategy Architect and delivered MicroStrategy prototype reports.
• Created dashboard/reports using SAS suite of tools.
• Additional tasks included maintenance of MS SQL Server scripts; monitored/ran data load jobs, fulfilled ad-hoc data requests, performed data analysis, and assisted business users with reports.

Confidential, VA

BI Systems Engineer

Responsibilities:

• Partnered with the sales team to provide WebFOCUS BI reporting support to federal customers. Developed customized product demos and concept-solutions, addressing key performance indicators (KPI) with various product solutions including interactive analytical reports, score-cards and dashboards.
• Focused on building relationships with key customer contacts, worked to increase customer satisfaction and ROI of their applications.

Confidential

Data Analyst

Responsibilities:

• Developed project schedules, managed team progress, facilitated requirements gathering, and delivered interface specifications. Key contributor for integrating/staging of sub-ledger data for all structured transactions that required consolidation. This data was consumed by down-stream systems for critical financial disclosures.

Confidential

BI Consultant

Responsibilities:

• Collaborated with ETL/Data Architects on report analysis and developed strategies for Web deployment. Designed and developed reports for GSA’s Public Building Service’s (PBS) Rent Estimate data warehousing project using JasperSoft tools.
• Delivered on-demand reporting system with dynamic what-if scenario analysis, and revenue forecasting.

Confidential

MicroStrategy Architect/Developer

Responsibilities:

• Created metadata repository and reports using MicroStrategy tools for Mineral Management Service data warehousing project.

Confidential

Senior IT Analyst

Responsibilities:

• Supported project to design/develop a system that allowed the business to identify, track, and prioritize multi-million-dollar long-term federal business development opportunities. Participated in requirements definition process with business team.
• Supported COTS application, called WinAward - a business development management tool used by federal sales.
• Developed reports in Crystal Reports XI and served as administrator for Crystal Reports Server XI; set-up users, managed objects in repository, created business views, and installed patches/fixes. Oversaw user/configuration management and installation/setup of Web application using IIS. Enabled users to access and execute reports using InfoView.

Confidential, McLean, VA

Senior Technical Analyst /Project Lead

Responsibilities:

• Assisted project managers with project charters, provided estimates for project schedules, determined resource requirements, and set goals/objectives for deliverables.
• Planned, designed, developed, and deployed data marts for: counterparty and portfolio risk management, financial reporting, time reporting, multi-family portfolio analytics. Held requirements meeting with business project sponsors and produced requirements documents using KPI matrix method or captured in DOORS.
• Led MicroStrategy team to deliver critical financial reporting with short project deadlines. Responsibilities included requirements & data analysis, data modeling & architecture design, delivering implementation of dimensional models, architect project metadata, developed reports/dashboards, performed project/user administration and worked with ETL team to load and verify data.
• Enabled business users to easily analyze debt, derivative, and mortgage transactions. Provided guidance/assisted users with report development.
• Ensured compliance to SOX control requirements for project level change management processes. Trained in the Rational Unified Process and requirements capture with Use Cases.

Confidential

MicroStrategy Architect/Developer

Responsibilities:

• Met with key stakeholders to understand business process and document requirements; performed data analysis to integrate data from multiple sources (external and internal) and designed data architecture to develop requirements for data mart that allowed financial users to perform analysis of debt and derivative-related data.
• Lead end-to-end (SDLC) - design, development, implementation, test/data validation, and deployment of data mart to support capital markets. Architected MicroStrategy projects, delivering critical reporting and analysis environment to users, troubleshoot issues, and develop ETL scripts, performed MicroStrategy user administration and reports/dashboard development.