Summary

WORK EXPERIENCE

CONFIDENTIAL

Business Analyst/Crystal Reports Developer in supporting of FAA Analyst Information Program Office

• Supporting the FAA 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

Business Systems Analyst in supporting of Army AG1-CISD Civilian Personnel

• 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

Business Intelligence / Crystal Report Developer in supporting of FDA CDRH IT

• 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 FDA 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

Business Analyst / Crystal Reports Developer in supporting of Cisco Systems - GGSG

• 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.

CONFIDENTIAL

VB.Net / Crystal Reports Developer in supporting of Army Strategic Readiness System

• Developed web based Strategic Readiness System in analyzing user requirements, worked with back-end and front-end teams in identifying business rules and user reporting needs
• Responsible for all aspects of reports design, development, enhancement, testing, and modification, coding and generating reports from Oracle database using VB.NET, IIS, JavaScript, CSS, HTML, Crystal Report ,Visual Studio .NET etc.

CONFIDENTIAL

• Crystal Reports Developer in supporting of local Government
• Developed web based reports using Crystal Report 9.0/10.0
• Worked with web based milt application for local government, using both SQL Server 2000, Oracle 8i, MS Access database developer, troubleshooting, enhancement for both develop and production sites, used, ASP, ADO, FTP, HTML, VB Script, JavaScript, CSS, ODBC, etc, wrote PL/SQL, T-SQL, and Crystal formula to create complex reports.

CONFIDENTIAL

Database Analyst /Crystal Report Writer in supporting of National Association of Home Builder

• Identified and developed reporting requirements, data source, validated reporting results by ad-hoc queries on source data, installed reports in reporting package describing functionality, data sources and purpose of reporting
• Produced complex SQL statements, Sub Queries, created temp tables, and used Aggregate functions perform a calculation on a set of values and return a single value in selected statements and computer clauses
• Designed complicate ad-hoc reports including Sub reports, Charts, Cross-tabs and multi-sections, etc.
• Supported the Director in the management of access of some reports posted to NAHB's internal Report Portal. In Crystal Reports 9.0, HTML, JavaScript, ASP.NET in web reporting and SQL Server 2000 environment .

CONFIDENTIAL

System Specialist/Crystal Reports Programmer in supporting of DOJ Civil Rights Division - FMIS

• Designed flexible, feature-rich reports on financial management service
• Produced SQL statements, complex formulas, Integrated of sub-reports, analyzing with advanced selection criteria, used multiple sections, produced complex reports in Crystal Reports 8.5/9.0 ASP, JavaScript, HTML and Oracle 8i database environment.

CONFIDENTIAL

Application Developer for web-based applications in supporting of DOD assignments

• Employed HTML, Java Script, and VB Script languages, to create the ASPs
• Created an administration tool for maintaining content in the website, providing system-wide and system specific messaging and emailing
• Created a function for uploading/downloading documents into the system
• Used SQL Server 2000 to write stored procedures, SQL statements
• Produced Crystal Reports to provide State managers and other Army National Guard ARNG personnel with the abilities to compute the actual costs of activities.

CONFIDENTIAL

Web Database Developer for e-commerce web applications

• Used BCP Bulk Copy Program load large quantity of data to the system and from Acceptance to Production
• Used SQL Server 7 developed SQL queries to manipulate and maintenance databases
• Uploaded data via MS Access using ODBC capabilities to access external databases to the database system SQL Server 6.5/7.0
• E-Commerce working experience with web-based database application and web catalog data consistency checking, quality assurance.
• Operating Systems: Windows 7/2000/XP/Vista/7, UNIX environment
• Applications: Business Objects, Crystal Reports, MS Visual SourceSafe, Visual Studio.NET, Visual InterDev, IIS,
• MS Office 2000/2003/2007/2010, MS Access, MS Excel, MS FrontPage, MS Outlook, MS Word, etc.
• Databases: Oracle 9i/10g/11g, MS SQL Server 2003/2008/2014, MS Access