Data Manager

Ishtiaq Ahmed

Email address *****.**********@*****.***

Phone# 732-***-****

SUMMARY

• 7+ years Experience in Business Objects XI R3.1/R2/ 6.5.

• Strong experience in designing and developing Dashboard using Crystal Xcelsius.

• Excellent experience with Universe design and development and developing complex reports using DeskI , WebI, WebI Rich Client, Crystal Report 2008.

• Strong experience using SQL,PL/SQL, Strong working experience with RDBMS, Complex Queries, joins, Grouping, from condition to projection, expertise in all clauses and PL/SQL blocks, Stored Procedures, Triggers, Functions, customizing exceptions, selecting a perfect loop for optimization of Stored Procedures, working with the cursors, variable, sub blocks, creating stored procedures on iSQL or TOAD environment.

• Expertise in gathering the Business Requirement and building Universes, free hand SQL methods and creating complex ad-doc and Canned Reports.

• Sound knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, migrating, administrating, security management and production supporting. Migrating universes, reports, users, categories from old version to Business Objects XI environment.

• Experience in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness using Business Objects Designer.

• Created Drilldown Reports, Sub Reports, On-Demand Sub Reports, Label Reports, Chart Reports, Dash Boards.

• Expertise in retrieving data using Business Objects Universes, Personal data files, stored procedures and free hand SQL methods.

• Experience using Microsoft Excel, PowerPoint, PDFs interaction with Business Objects.

TECHNICAL SKILLS

Data Warehousing Tools Business Objects XI R3.1,R2,R1,6.5, Dashboards Manager,

Crystal Report2008, Crystal Xcelsius2008, 4.5, QaaWS, Live Office.

Programming Languages SQL, PL/SQL.

DBMS Oracle 10g/9i / 8i,SQL Server 2000, 2005.

Operating Systems Windows 2000, NT, XP.

EDUCATION:

Queens College, Flushing, NY

BA in Accounting

Graduated: Dec 2010

EXPERIENCE

Abbott Laboratories, Abbott Park Illinois Mar 2009 – Present

Business Intelligence/Business Objects Developer

Responsibilities:

• Responsible for 24x7 production support of Business Objects clustered environment, Business Objects reports, Universes

• Performed successful deployment of BOXIR3.0 environment

• Converted several existing Legacy Reports in to the Business Objects Webi Reports

• Handled scheduled job maintenance and monitored nightly ETL jobs and addressed any ETL related issues

• Migrated legacy reports and universes from BOXIR2 to BOXIR3

• Created Dynamic Reports using a Main report

• Granted users access to Business objects environment and applied restrictions on groups and users

• Performed migration of reports and universes between different environments

• Assisted users with Adhoc reporting and handled ticketing system on priority basis

• Performed data analysis using SQL in Sql server and oracle to address the missing data issue and fixed queries

• Converted several DeskI reports to WebI and then published those reports on InfoView

• Created over 100 canned reports and successfully designed over 6 universes to capture different business model

• Designed universes over relational database schemas

• Well versed with dimensional modeling concept and implemented star and snow flake schemas in universes

• Created Hyperlinks from master reports to detail reports

• Created Business Objects Web Intelligence reports and published on the INFOVIEW.

• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill down, Cross tab, Master detail and Formulae.

• Developed complex Reports using Web Intelligence Rich Client, Web intelligence Info View, graphs, pie-charts and multiple data providers running on daily, weekly, monthly and quarterly basis.

• Created monthly contract based bills for wholesale distributors and vendors using Crystal Reports 2008

• Created annual and quarterly finance reports for the Client

• Generated the Oracle Reports using different data providers like XML data

• Provided technical data that include MS Excel spreadsheet and MS Access

Environment: Windows XP, Business Objects XI R3.1, Oracle 10g, PL/SQL, Crystal Report 2008.

Costco Issaquah, WA May 2007 – Feb 2009 Business Objects & Dashboard Developer

Responsibilities:

• Provided 24 hrs production support to Business Objects environment and performed ongoing server maintenance including service pack and hot fixes

• Closely monitored Business Objects services and resolved server related issues

• Contacted appropriate Network-Attached Storage(NAS) team to address any flat file and File input repository and file output repository related issues

• Gathered Requirements from end users to create Universes and Reports

• Detected Joins and checked the Cardinalities. Resolved Universe problems like Loops, chasm trap fan trap using Alias and Context. Developed and created classes with Dimension, Detail & Measure objects. Developed Custom hierarchies to support drill down reports

• Communicated with end users and addressed their concerns in resolving issues in their reports

• Wrote Stored Procedures to retrieve data from oracle data sources as per the requirement

• Created Derived tables in the Designer to enhance the capabilities and performance of the universe.

• Implemented cascading prompts in universe.

• Worked extensively with @functions (@select, @prompt, @where) to overcome the problems with database when integrating with business objects.

• Generated List of Values (LOV’s) from lookup tables.

• Check the integrity of the Universes, and export the universes to Repository for making available to users. Involved in Unit testing and UAT.

• Build Queries on Universe using QaaWS and Publishing of WSDLs.

• Created different sets of Complex Dashboards using QaaWS, Live Office, Column Chart, Pie Chart, Dynamic visibility, Drill Down Dashboards, Summarized Large Amount of Data into Small Dashboards using Vlookup, Mapping, Massaging the Data.

• Created Reports as per user requirements using BO XI R2 and Oracle Report Builder.

• Create defect mapping report using MS Excel.

• Wrote SQL statements to manipulate Oracle (v9.x) database tables and to query data

Environment: Windows XP, Business Objects XIR 3.1/ R2, Oracle 9i, Crystal Xcelsius 2008, QaaWS, Live Office.

Wachovia Bank , San Francisco CA Oct 2006 - May 2007

Business Objects & Dashboard Developer

Responsibilities:

• Assisted users with Adhoc reporting requirments and developed several canned reports

• 24x7 on call support to end users

• Created Cross tab, Master/Detail Reports for Sales, Operations and Corporate.

• Created reports using different formula, extended context, Breaks and variables.

• Create Dashboards using Performance Manager for Corporate MIS.

• Created Complex reports with SQL views in Crystal Report.

• Converted existing reports in Actuate to Crystal Reports

• Wrote SQL queries in PL/SQL Developer to extract the data from database

• Created several WebI reports, DeskI reports and Dashboard reports for graphical presentation.

• Used VBA Macros to open the document with raw data when end user clicks on Summary Report.

• Created Report using the Data Providers Linking across multiple data providers.

• Create Reports from Free Hand SQL Data Provider.

• Provide Power point presentation of webi, deski reports that deals with the audit reports.

Environment: Business Objects XIR2, Oracle 9i, Windows XP, Crystal Xcelsius 4.5.

Sears Hoffman Estates, Illinois Jun 2005 - Oct 2006

Business Objects Developer

Responsibilities:

• Gathered reporting requirements from users and developed several reports and universes

• Created Universe, Classes, Objects and measures.

• Created joins, cardinalities, resolved loops and checked Integrity.

• Created aliases and contexts. Created Reports using Desktop Intelligence, Web Intelligence,

• Created Reports in cross tab, master/detail, drill down, created variables format reports for better presentation. Transformed Reports into 2-D,3-D column and pie charts for better view while analyzing. Optimized Queries for better performance, Reduce run time of Reports.

• Created Yearly, Quarterly, Monthly, Weekly Reports.

• Created Ad-hoc according to user requirements.

• Created Canned Reports for end user and document step by step all the work.

• Created Reports using @Functions, (@prompt, @aggregate, @where).

Environment: Windows XP, Business Objects 6.5(Designer and Business Object-Reporter), Oracle 9i.

Contact this candidate