Andrew Berdak Email & Phone Number

Herndon, Virginia, Us

Arlington, Virginia, Us

• Technical manager of enterprise data warehouse and reporting for a large government implementation, requiring functional and technical expertise in business intelligence, data warehouses, data analytics, enterprise performance management, master data management, and financial management. • Manage BI team through architecture, design, and implementation of a large enterprise data warehouse and reporting capability, combining sources from legacy systems and the new transaction system built on Oracle Data Relationship and Oracle Hyperion. • Contribute to Definitive Logic organizational goals and company growth through efforts including recruiting, improving internal processes, assisting with RFIs, creating a BI training course, and creating content for business development demonstrations.

Arlington, Virginia, Us

• Technical lead for government client requiring functional and technical expertise in business intelligence, data analytics, data warehouses, master data management, and financial management. • Work closely with clients across functional directorates through all stages of BI lifecycle in order to develop technical, user-focused BI dashboard and reporting solutions to aid financial management across government agencies.

Falls Church, Virginia, Us

• Project lead for GDIT on numerous projects that required knowledge of a variety of BI/EPM applications across several General Dynamics (GD) business units. • Managed BI life cycle process, including gathering requirements from application users, designing and developing solutions, providing M&S support, and training user communities.• Led deliveries of Oracle Business Intelligence Enterprise Edition (OBIEE) 11g dashboard solutions independently for several GD business units. Constructed data models, RPD, generated analyses, and created dashboards for hundreds of financial analysts and executives. • Performed all life cycle functions on multiple Hyperion Planning/Essbase applications in order to better meet user financial planning, budgeting, forecasting, and reporting needs.

Falls Church, Va, Us

• Supported the U.S. Army Planning, Programming, and Budgeting Business Operating System (PPB BOS) by developing and maintaining Army BI systems, including a set of about 200 Oracle Hyperion Interactive Reports (IR), sourcing from a large data warehouse, with approximately 2,000 users and 140,000 query processes per month. • Led a reporting team of developers through entire BI life cycle, including production support, in time sensitive delivery efforts to support Army financial data management. Participated in daily management and daily customer schedule/status meetings. • Utilized Hyperion IR, SQL, and Javascript functions to build queries and dashboards to satisfy Army G8 reporting requirements.• Imported metadata from relational schemas and Essbase in order to build data models for OBIEE RPD repository. Created analyses and dashboards to demonstrate capabilities to Army clients. • Performed master data management by migrating data from SQL Server to Oracle using SQL script files, Windows batch scripts, and Hyperion Data Relationship Management (DRM) functions.• Administered applications and validated data in Hyperion Planning and reports. • Updated ETL mappings using Oracle Warehouse Builder in order to load financials to the Army data warehouse.

Falls Church, Va, Us

• Performed testing and evaluation on legacy systems and BI capabilities for the U.S. Army PPB BOS. • Wrote and executed test plans, test procedures, test cases, test traceability, test logs and summaries. Utilized HP Quality Center, JIRA, and SQL for test procedures. Coordinated peer review process and fixes.

Falls Church, Va, Us

• Supported the Transportation Security Administration (TSA) by conducting research, data collection, analysis, testing, evaluation, and reporting to determine and recommend potential improvements to TSA’s security equipment, processes, and procedures. • Consulted regularly with TSA customers to gather requirements, analyze processes, deliver reports, and present briefings.

M.S., Information Technology

B.S., Information Systems