OBJECTIVE:
Seeking a challenging role in Business Intelligence field where I can utilize my current skills and experience with an opportunity to further growth and development.
| PROFESSIONAL EXPERIENCE: Confidential Business Objects Administrator/Architect - Installed Business Objects 4.0 on standalone and distributed Windows 2008 servers, configured SSO with Windows AD authentication.
- Migrated contents from Business Objects 3.1 to 4.0 using the Upgrade Management Tool.
- Created a script to deploy LCMBIAR files using command line utility.
- Responsible for production support of more than 5000 active users worldwide accessing 400 reports using Business Objects 3.1 Enterprise.
- Implemented universes using Shortcut joins, Aggregate Awareness and contexts according to user requirements.
- Created complex views in Oracle 10g databases to overcome loops and contexts.
- Responsible for users' seamless access of reports utilizing the contextual report linking.
- Created new reports, migrated Desktop Intelligence reports to Web Intelligence reports, and supported existing reporting system using Web Intelligence.
- Scheduled reports for nightly refresh and deliver to users' Inbox using CMC's Instance Manager.
- Installed specialized fonts, modified Business Object server configuration files to fit end-users need.
- Managed and coordinated all Business Objects deployments from development to test and production environment.
- Supported team members, provided guidance with Business Object errors and troubleshoot issues as needed
- Worked closely with the Program Manager and other technical teams to determine the client's needs and how to meet project goals.
- Standardized field mappings, data dictionary, and universe and report documentations.
- Strong written and oral communication skills and the ability to work effectively in a dynamic team environment.
Confidential Business Objects Architect/Developer - Gathered requirements by meeting with end-users and assisted the clients with refining and writing design documentations.
- Analyzed users' existing reports in Crystal Reports.
- Created reports and dashboard prototypes using the requirements gathered.
- Participated in the development of the universe, five reports and five dashboards using Business Objects XI 3.1 and Xcelsius 2008 within three months.
- Worked with end-users to unit test and validate data presented in reports and dashboards.
- Held group sessions with power users for knowledge transferring.
Confidential Business Objects Architect/Developer - Created universes, joins, classes, objects, contexts and aliases to resolve loops.
- Implemented complex condition objects to retrieve data based on different time periods.
- Utilized the Dashboard Manager to create analytics such as Interactive Trend Metrics, Speedometer and Metric Analytics.
- Designed various ad hoc and canned reports with extensive use of Functions like Prompts, Select, Variable, and Where.
- Established user groups, users and assign privileges using Central Management Console.
- Troubleshoot and resolved issues with reporting processes and data inconsistencies.
| Dd |
| Confidential Database Analyst - Identified and analyzed data elements from requirements.
- Designed and implemented data extraction, data load, and database synchronization routines.
- Performed and managed database schema changes including tables, views, indexes, integrity, security, and business rules using DDL, DCL, DML and PL/SQL functions, procedures, and packages.
- Developed stored procedures to validate and process data received from various different sources into an appropriate database schema for a network management application.
- Optimized queries, tuning of SQL-statements to improve enterprise application performance.
|
| Confidential |
Data Architect/Database Developer
- Designed, documented, and implemented logical and physical database schemas using ERWIN modeling tool.
- Built and administered Oracle 8i databases and upgraded to Oracle 9i on Windows, created database instances using NT batch files and Oracle utilities.
- Performed analysis of database statistics/metrics, data integrity and query optimization to improve performance tuning for operational systems.
- Utilized PL/SQL to manipulate data, which includes functions, groups, joins, sub-queries and view to run with Web applications, works with application Developers on requirement analysis and data definition.
- Used Active Perl to parse text files and upload into the relational tables using SQL Loader.
- Monitored and performed ongoing tuning of database instances, capacity planning and implement database security.
- Communicated with team members to perform system design, development, and enhancement activities.
- Contacted clients on a regular basis to obtain data extracts and policies information.
- Responsible for other development activities including: manage software bugs escalated from help desk, assign tasks to the appropriate software engineers and follow up to ensure the issues are resolved.
TECHNICAL SKILLS:
- Business Objects Enterprise 4.0/3.1/R2, Universe Designer, Dashboard, WebIntelligence, SQL, PL/SQL, Quest Software TOAD, ERWin, Oracle, Windows 7/XP/2000, Windows Server 2008/2003.
- Experience with building infrastructure for large, highly available databases.
- Possess strong data modeling skills and experienced in designing both normalized ERD and de-normalized dimensional data structures.
- Experience with application migration procedures and practices.
- Able to simultaneously manage multiple assignments and maintain clients' high expectations.