Data Sales
Resume:
Name: Umair Ali
Email: ***********@*****.***
SUMMARY
• I am an IT professional with almost 6 years of experience in various industries including Financial, Pharmaceutical, Services and retail industry
• I have worked extensively on Business Objects Designer, Info View and Web Intelligence. I am well versed in Business Objects (6.X and XIR2, XIR3,3.1) with experience in Supervisor, Designer, Reporter, BCA (Publisher and Scheduler), Web Intelligence, Info View, Dashboards, Auditor and Schema Design. I have an in-depth knowledge in creation of WEBI reports and Dashboards using Crystal Xcelsius. My expertise includes Business Objects Universes, personal data files, stored procedures and free hand SQL methods.
• I have worked in all aspects of creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness using Business Objects Designer.
• Ability to transform powerful complex data into a comprehensive dashboard using Crystal Xcelsius.
• Extensive knowledge in all phases of Software Development Life Cycle (SDLC) with different methodology such as Waterfall and RUP. Strong Experience in interviewing End- Users, Stakeholder, Business Owners and Subject Matter Expertise.
• Excellent skills in developing Dataflow Diagram and UML diagrams such as Use Case diagram, Activity diagrams, Class diagrams and Sequence diagrams
TECHNICAL SKILLS
Operating Systems Windows 95/98/NT/2000/XP
RDBMS Oracle 10.2g,9i/8.i, MS SQL Server 2000,2005, MS Access, IBM DB2
Languages SQL, PL/SQL, XML, HTML
Application Server’s Web logic, OAS, Oracle 9IAS, Apache Tomcat, Webshpere
OLAP and Reporting Business Objects 6.x5, XI R2, XI R3.0 , Supervisor, CMC, Designer, Business Object Desktop Intelligence, Web Intelligence, Crystal Reports 2008, XI/9.0) , Xcelsius 2008.
Other Tools Toad, MS Visio
ETL Tool Data Integrator
EXPERIENCE
Kodak, Rochester, NY May 2010 – Present
Business Objects Developer,
Responsibilities
• Designed several Universes using Designer according to the requirements
• Created Classes, Dimension objects, Measure objects and Detail objects in the universe
• Resolved issues related to RDBMS flaws such as Fan Traps, Chasm Traps using BO multi parse SQL functionality
• Enable up-to-the-minute information for dashboard with live data using various connections
• Create and modify reports using SAP Business Objects Web Intelligence and Desktop Intelligence.
• Created repository and security domain with user groups and security implementation.
• Prepared different report layouts and blocks like Tables, Cross Tabs and Charts
• Used different functionalities like Breaks, Filter, Sorts, and Ranking to generate reports.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.
• Used aggregate awareness in universes. Involved in full life cycle of Business Objects reporting Application.
• Updated and maintained Universes based on changing user requirements and data source changes
• Checked Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Handled Embedded Functions like @Prompt, @Select, @Where in the Designer to handle User requests for report generators
• Interactive visualizations were made for executives to visually evaluate different scenarios by adjusting key variables.
• Conducting UAT (User Acceptance Test) and working with QA and QC Teams positive and negative, functionality, object, and regression
• Create documentation including data flow diagrams, batch and online system process flows
• Created work flows and data flows for different batch jobs created using data integrator
• wrote scripts for various procedures with in the batch jobs
• Populated Different Dimensions Using Various Transforms
• Using Data Integrator Loaded data to Destination Tables from Various Types of Data sources, such as Flat Files, Data Base Tables or XML Data Sources.
• Used various techniques such as interactive debugger to examine and modify data row by row for various transform with in a flow
Amcore Financial Inc. Rockford, IL Jan 2009 - Mar 2010
Business Objects Developer
• Gathering Requirements, Drafting specifications, Design, Development, User Acceptance Testing and Production Roll Over.
• Experienced in creating Business Objects universes. Installing and configuring Business Objects, Web Intelligence and other Components of Business Objects.
• Developed Reports with parameters, Sub-Reports, cross-tabs and charts based on Stored Procedures and Queries by using Crystal Reports.
• Generated reports by using Stored procedures and generated Parameterized, Drill down reports
• Create stunning presentations with exciting visual components using Crystal Xcelsius
• Developed Xcelsius presentations/visualizations for profitability Analysis, Distributor Sales Analysis, Monthly Sales Analysis, Forecasted Sales What if Analysis
• Created report templates, developed Ad-hoc reports, complex reports (e.g. reports from multiple data sources, drill down capabilities by using Crystal Reports).
• Scheduled and Distributed reports to different users by using CMC, Info View and Publisher
• Experienced in creating Star Schema for Multi-Dimensional modeling within an enterprise wide Data Warehousing effort.
• Responsible for designing and developing Universes for reporting purposes. Universes were created for post and pre–analysis of the marketing data through in-house Structure Business Objects methodology.
• Created new Business Objects users and User Groups using Business Objects CMC Module.
• Involved in designing and developing complex Web Intelligence, Client, and Ad Hoc reports for corporate data, which was stored in the Oracle database.
• Build the Universes for end user report generation using Designer module
• 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
• 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
• Implemented Data warehousing schemas like Star-Schema, Snow-Flake Schema.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill down, Cross tab, Master detail and Formulae
• Creating complex full client and Web intelligence reports using graphs, pie-charts and multiple data providers on daily, weekly, monthly and quarterly basis Reports using Business Objects XI R2.
Sanofi , Chattanooga, TN Mar 2007 – April 2008
Business Objects Consultant
Responsibilities
• Migrated Business Objects 6.5 to XI R2.
• Used Web intelligence to create, edit and set different options for the corporate documents.
• Created reports for various Portfolios using the Universes as the main Data Providers.
• Interaction with end users, regularly in order to generate the reports required, these reports were generated using Business Objects functionality such as Slice and Dice, Master/detail, User Responses and Formulas.
• Creation of Universes by retrieving the data from various data sources, defining the connections necessary. Generating various numbers of reports on a daily, weekly and monthly basis
• Actively involved in gathering end user requirements, User/System Documentation, User training and testing developed reports for final deployment.
• Involved in the designing and Building of Universes, Classes and Objects for investment management system.
• Exported the Universes to the Repository to make resources available to the users.
• Use of Designer Module to implement Universe, Linkages between Tables, create prompts and queries, parse the Universes, apply Contexts and Alias Tables to remove cyclic dependencies.
• Extensively used PL/SQL to implement cursors, triggers and packages.
• Exported the Universes to the Repository to make resources available to the users.
• Created reports for various Portfolios using the Universes as the main Data Providers.
• Interaction with end users, regularly in order to generate the reports required, these reports were generated using Business Objects functionality such as Slice and Dice, Master/detail, User Responses and Formulas.
NPower Brooklyn, NY Jan 2005 – Feb 2007
Junior Business Objects Developer
Responsibilities
• Assisted end users with adhoc reports in DeskI
• Gathered report requirement and build various DeskI and WebI reports
• Used MS Visio for Dataflow Diagram, process model and architectural design of the application.
• Reviewed Test Plans and Test Cases for proper implementation and execution.
• Participate in integration testing by developing US specific test cases and actual testing of system design and interfaces
• Conducted GUI and User Acceptance Testing (UAT) to make sure the solution is what clients want.
• Converted several Crystal reports into WebI and DeskI reports
• Trained end users on how to use Business Objects Reporting tools
• Provide on-call and scheduled support, troubleshooting and maintenance on a weekly basis
Contact this candidate