Business Objects Specialist Resume
OBJECTIVE
An insightful, result-driven IT professional with notable success, seeks a long term employment with a company that will entail using skills at systems analysis, comprehensive design, and full lifecycle project management. Hands-on experience in virtually all stages of system development and certain to become just the problem-solving team player the opening envisioned. A problem solver. A team player.
QUALIFICATIONS
- Over 15 years experience in Data Processing and Applications.
- Intensive experience in Software development using Oracle, SQL Server, Sybase, Visual Basic, VBA, Unix, Business Intelligence, Software Development life cycle.
- Strong programming, system analysis, software design, analytical, problem-solving and communicational skills.
SKILLS SUMMARY
Languages and Tools: C, UNIX shell scripting (Bourne, Korn), Visual Basic, VBA (MS Access, MS Excel, MS Word), .NET, Powersoft, Java, C#, SQL, T-SQL, Oracle Development tools (PL/SQL, Oracle Forms, SQL*PLUS, SQL*Loader, Oracle internals), HTML, XML, SyncSort, Informatica, BRIO, PowerBuilder, Crystal Reports, Business Objects, Hyperion, Oracle 7.0 11g, MS SQL Server, Sybase, PostgreSQL, DB2
System platforms: UNIX (AIX, HP-UX, Solaris), Linux, Windows 9x/NT/2000/XP/7
PROFESSIONAL EXPERIENCE
06/2011 04/2012Database Specialist,Confidential, NY
- Post Trading production support of the large (10 TB) transactional DB (Oracle 10g).
- Monitoring of the performance, analysis of the wait events.
- Tuning of the database, strategy of indexation, strategy of backup, compression, and space usage, creation of outlines.
- Tuning of separate queries, using hinting, rewriting, refactoring, analysis of explain plan, trace information, tkprof.
- Strategy of purging of database due to global indexes on partitioned tables.
- Reduction of index contention, creation of hash partitioned or reverse indexes, reduction of other kinds of contention.
- Debugging of Java code on backend using autonomous transactions.
- Creation of test plans and testing of Oracle 11 features.
- Configuration of Oracle Streams.
- Strategy of migration of Oracle 10g to Oracle 11g on another OS with different endian.
01/2011 - 03/2011
Business Objects Specialist,Confidential,NY
- Conceptual, logical, and physical data modeling of Renewal System on DB2 database.
- Development of universes and reports within Business Objects XIR3
- Building Universes using Universe Designer
- Defined of the source of data
- Building the universes
- Defined logical classes and objects
- Building of Business Objects reports
- Design and development of various WebI reports
- Defined of formulas for the complex calculations
- Migration of the existing reports to Business Objects environment
09/2009 08/2010
Developer,Confidential, NY
- Near real time loading of big amount of market data (1Tb per day) into Postgres database using C, Unix shell, psql.
- Creation of various market reports against Postgres DB using Unix shell, psql, SQL.
09/2000 01/2009
Developer Software,Confidential,NJ
- Conceptual data modeling. Logical relational data modeling normalization procedures, business rules modeling. Dimensional data modeling: facts, dimensions, star and snowflake schemas. Physical data modeling. Design of performance-oriented data models: de-normalization, indexing, materialization, other performance improving techniques. Implementation of constraints and business rules.
- Support of DataWarehouse and OLTP (Oracle 8.0-10g).
- Development, testing, and support of various stored procedures, triggers, ETL processes.
- Design, development of Informatica Mappings to load data to the DataWarehouse.
- Used Power Center/Mart to design the mappings with embedded business logic.
- Creation of Transformations like Lookup, Joiner, Rank, and Source Qualifier Transformations.
- Creation of complex mappings using Unconnected Lookup, Sorter, Aggregator for population of target tables.
- Reverse engineering of existing projects to extract the business rules.
- Justifying of business rules and coding using PL/SQL, Unix shell scripts, C programs, SyncSort, FTP.
- Proactively assigned resources to meet workflow needs.
- Created development plans, project documentation, and test cases.
- Performed unit test, string test, system test, pair test, end-to-end test of the applications and provided final approval for bug-free and fully functional commercial solutions.
- Analysis of the current environment to discover critical issues, to resolve the bottlenecks, and to improve performance.
- Production support of all applications.
- Tuning of the queries and optimization of various processes.
- Creation and scheduling of various reports using Unix features, Oracle features, Excel features, VBA, Crystal Reports, BRIO, and Business Objects XI.
- Creation of ad-hoc reports for top management.
- Development and production support of universes and reports for multiple users within Business Objects XIR2.
- Building Universes using Universe Designer
- Designing and building universes by Objects data model selecting/joining tables
- Creating of Derived tables using custom SQL statements
- Indicating cardinalities
- Resolving the loops creating aliases and contexts
- Defined logical classes, objects, and hierarchies for analysis and drilling
- Resolving the possible mistakes in case of the aggregation of the duplicated rows
- Building reports using Crystal Reports XIR2
- Administration of CR environment
- Created and maintained reports (including parameterized) with Standard, Summary, Charts, Cross Tabs, SQL, Selection Criteria, Grouping, Sub reports, Running Totals and custom formulas.
- Reviewed, promoted, and scheduled reports created by other developers.
- Performing of the administration jobs
- Creation of users
- Creation of groups
- Setting up rights to Business Objects Applications (Infoview, WebI, Designer, Dashboard Manager, Crystal reports, DeskI)for user groups in Central management console (CMC).
- Building reports using Business Objects Enterprise Java Infoview Web Intelligence reports or Desktop Intelligence
- design, development creating Simple, Complex and Ad hoc Reports
- creating of reports using one or multiple data providers, Merged Dimensions, Union queries
- creating fine-tuning the reports using Calculations, User Variables, multilevel Breaks, Sorting, Drill, Slice and Dice, custom Lists Of Values, and Alerts
- Used @Aggregate_Aware, @Where, @Select, @Variable, @Prompt functions when required.
- Applying Drill Filters, multiple Tab reports with charts, pivots,master/detail report.
9/1998 4/2000
Developer,Confidential,NJ
- Production support
- Development of new processes using Pro*C, PL/SQL, and Unix shell scripting (Oracle 7.3 under HP-UX)
- Creation of test plans
- Testing
- Population of test environment with test data.
- Creation and execution of test programs
- Analysis of test results and comparison with expected results according to business rules
EDUCATION
M.S. in Engineering.