We provide IT Staff Augmentation Services!

Business Objects Specialist Resume

3.00/5 (Submit Your Rating)

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/2012

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

We'd love your feedback!