Business Analyst Resume Dulles, VA - Hire IT People

SUMMARY

9 years working experience in Crystal reports develop (Crystal Reports 8.5/9/XI/2008/2011), 7 years’ experience in Business Object Web intelligent reporting (BO XIR3/4.0).
Strong experience in database management systems (DBMS), 8 years’ experience in Oracle, SQL Server databases, and 2 years’ experience in Sybase, Access, data warehouse, etc. databases.
Over six - year of experience working in the Government IT sector and twelve years in IT sector overall

PROFESSIONAL EXPERIENCE

Confidential, Dulles, VA

Business Analyst

Responsibilities:

Supporting the Confidential Flight Standards Service AIPO customers, review, analyze and evaluate business systems and user needs, and implement required database modifications, analytical subsystem per contract requirements, helping Managers, Flight standards aviation safety inspectors (ASIs), Operations Research Analysts to make right decisions.
Developing SQL scripts, creating tables, views, indexes, producing SQL Query statements in SQL Server 2008 management studio, Oracle, Sybase, and MS Excel, MS Access 2010 environment.
Designing and developing complicate ad-hoc reports including dynamic parameters, charts, cross-tabs sub reports, etc. using Web intelligent Reporting (BO Enterprise 4.0) and Crystal Reports 2008/2011 against Oracle, SQL Server, BO Universe, Sybase, MS Excel, MS Access data sources. Using Business Objects InfoView to manage and scheduling reports and design and create Business View in Business Object Enterprise Repository, etc.

Confidential, Alexandria, VA

Business Systems Analyst

Responsibilities:

Structure designing and creating complicate reports. Worked with Reporting Team members capture business rules, define requirements/supporting database and a variety of front and back end technical specifications; structure designing and creating, maintaining, optimizing and support new and existing complex ad hoc reports using Web Intelligent Reporting, Crystal Reports in Business Object Enterprise XIR3, Crystal Reports XI/2008 and Oracle 10g/11g, MS Access environment;
Produced PL/SQL, SQL statements, analysis and support database, star schema, data warehouse design, creating tables, views, data manipulation, transformation, etc. in oracle 10g/11g environment based on reports needs;
Converting old COBOL reports into Crystal Reports. Worked with HQ ACPERS Reporting team members to support analysis of COBOL program specifications, advanced selection criteria and converting old COBOL reports in to Crystal Reports, including significant enhancements such as structure redesign, dynamic parameters, drill down functionalities, sub reports, charts, cross-tabs etc. Created Report templates, step by step how to create report documents, training and assisting other team members using Crystal Reports XI/2008/2011.

Confidential, Columbia, MD

Business Intelligence / Crystal Report Developer

Responsibilities:

Created and saved Business Views in Business Object Enterprise XI Repository, created dynamic parameters and Cascading pick lists, navigating and maintaining Business views based on dynamic reports needs;
Produced customer functions, complicate SQL commands in Business Object Enterprise XIR2 and Oracle 10g, Crystal Reports XI environments;
Achieved as Outstanding Service Award - by Confidential for superior teamwork and performance in the development and management of the first phase of the Premarket Monetization Project CARS Version 1.0 and Version 2.0 as a member of the Center as hoc Reporting System (CARS)

Confidential, Herndon, VA

Business Analyst

Responsibilities:

Worked directly with the Business Team to capture and analyze business operations, data warehousing and define information processing requirements, designing, creating, managing, and fulfill requests for reports and information to assist in decision making;
Worked with business users and database team for GGSG data warehouse analysis and integration;
Created Business Views and Business Analysis reports, automating the generation of quarterly reports from MS Excel, Access and Oracle Database include Data Warehouse;
Designed Cross Tabs, Charts, Advanced Charting, Sub Reports, Drill Down Reports ad-hoc business analysis reports as requested by Business Operations;
Used Business Objects XI Info View to manage, analyze and schedule run Crystal reports quarterly.