Sql Server Data
Resume:
Kamran
Qureshi
************@*****.***
SUMMARY:
* ***** ** ************ ********** in Information Technology with in-depth
knowledge of system design, data modeling, development, and testing of
client/server applications using Oracle 10g, SQL Server 2005.
5 years experience of data warehousing experience in Business Objects XI
3.1/R2/6.5 including, Central Management Console (CMC), Desktop and Web
intelligence, XCelsius, Dashboard, and Universe Designer.
Expert in user-information gathering, drafting, planning, designing,
developing, and maintaining Universe.
Created and managed folder structures, setting up folder priorities, access
controls like full control, view only, schedule, and view on demand to
users and used folder filters settings based on rights
(assigned/unassigned, granted), and sort by type and name, using limits
based on maximum instance object count per user and per day
Publishing reports and other forms of reports on CMC/BO repository
Experience in Designing and Linking Universes for query, reporting, and
analysis using Designer and created complex Ad Hoc reports using Web
Intelligence
Good conceptual knowledge in designing Star Schema, Snow-flaked Schema and
Multi-Star Schema, and designing Fact tables, Dimension tables
and summary tables.
Created various financial graphs and charts using Xcelsius for interactive
presentation of data in Dashboard and used multiple selectors, dials etc
from Excel, live office, BOE reports
Good knowledge in SQL, PL/SQL, stored procedures, tables, views, joins.
Worked with Oracle 10g/9i, MS SQL Server 2000, DB2, Teradata, and MS Access
2003.
Worked with SQL Developer, SQL*Plus, Embarcardero Rapid SQL, and TOAD
Expertise in defining queries, testing queries, performance tuning and
query optimization
Participated in all phases of system life cycle in
OLTP/OLAP/ETL/Datawarehousing.
TECHNICAL SKILLS:
Databases: Sybase IQ, Sybase ASE, Oracle 11g/10g/9i, My SQL 2005, SQL
Server 2005, Teradata, DB2, MS-Access
Reporting/ETL Tools: Business Object Enterprise XI 3.1/R2/6.5, XCelsius
2008, Crystal Reports Enterprise 10, Crystal Reports 2008/XI R2/XI/10.0/9.0
Software Tools: Embarcadero
Rapid SQL, TOAD, SQL Developer, Adobe Acrobat, MS Front
Page, MS Office 2003, Open Office.Org, MS Visual Source
Safe 5.0
Network: MS Windows NT
Management Tools: MS Project 2003/2002
Languages: Visual Basic 6.0/5.0
Operating Systems: Windows Vista/XP/2003/2000/NT/98
Education: Bachelor's in Finance & Investments, Baruch College, NY.
Nimbo Technologies, New York, NY Aug 2012-
February 2013
SAP Business Objects Consultant
Responsibilities:
. Created various EDI Dashboards using Xcelsius 2008 for the Finance
Managers and Directors.
. Used QAAWS and different sources to retrieve data from universes and
databases into Dashboards
. Developed interactive charts using Filters, List View, table, Line,
Column and Pie charts (combination bar graphs, combination bar and
line graphs, which were used to display metrics.)
. Interacted with the End Users, Business Analysts and responsible for
Involved in training sessions to impart knowledge on designed
universes and published reports.
. Created Webi reports with functionalities like Queries, Drill down,
Cross Tab, Master/Detail and Formulas
. Responsible for tuning and testing existing Universes to resolve
loops, chasm and fan traps
. Created Derived Tables according to end user requirements to develop
multiple SQL queries
. Worked as an Admin to add as well as assign security to different
applications in Central Management Console
. Created Open doc Webi reports to facilitate users with drill down
abilities on analytical reports
. Deployed various dashboards and reports to different environments
(Development, Testing, Production)
. Developed complex queries and reports using different data providers
in the same report
. Used Designer to create Dimensional, Detail, and Measure objects
Environment: SAP Business Object XI 3.1 (Designer, Web Intelligence, CMC,
QAAWS, Xcelsius (2008), Infoview), Crystal Reports 2008, Oracle 11g,
Sharepoint 2010, Citrix Client, MS Office 2007, Windows XP/2003 Server
Fidelis Care New York, Rego Park, NY Nov 2011-
June 2012
Business Objects Analyst
Responsibilities:
. Interacted with Business Users and Business Analysts to gather the
Requirements and Business logics
. Involved in Writing Detailed Level Documentation for reports and
Universe design
. Created Adhoc Claim reports on Sybase IQ server and ran them in Web
Intelligence
. Communicated with the Users to get feedback and provide further
modifications to the existing reports
. Developed and created classes with Dimension, Detail & Measure Objects
and specified the hierarchies.
Specified the Joins and checked the cardinalities.
. Worked extensively with Business Objects functionalities like Alerts,
Filters, Sorts, Drill filters and integrity check on Universes and
exported to the repository.
. Created Full client and WebI reports. Modified the existing by adding
new columns based on the result set.
. Created reports in crystal reports and published reports back to BO
and scheduled the reports.
. Ran SQL Queries against the database to see the accuracy of the data.
. Used Web Intelligence and Crystal Reports to create and edit web
reports.
. Created user Prompts, Conditions and Filters for various reports to
specify the reporting parameters as per the business rules and the
requirements of the end users.
. Performed Integrity Checks to Universes to detect loops, cardinalities
and joins.
. Resolving join path Problems like Chasm Trap and Fan Trap and Loops by
creating Context and Aliases.
. Involved in performance tuning existing reports.
Environment: SAP Business Object XI 3.1/ R2 (Designer, Web & desktop
intelligence, CMC, Xcelsius (2008), Infoview), Crystal Reports 2008,
Sybase IQ/ASE Server, SQL Server 2005, Embarcardero Rapid SQL,
Sharepoint 2010, Citrix Client, MS Office 2003,Windows XP/2000 Server
First American Financial Corporation, Santa Ana CA May 2010 - Oct
2011
SAP Business Objects Consultant
Responsibilities:
. Gathered user information and developing webi reports based on the
gathered requirement and creating templates and involved in report
documentation
. Created risk reports, price-curve analysis, forecasting energy
procurement costs, administrative reports, ad hoc, daily, weekly and
month price analysis reports.
. Involved in interviewing end-users and gathering report information
and creating mock up reports for final design and development of
reports
. Analyzed data warehouse in designing and building of complex BO
Universe by creating classes and objects from Database Structure.
. Involved in deploying and modifying Universes and reports from
Development Environment to Test into Production Environment
. Worked in designing Star Schema, Snow Flake Schema, and Dimension
modeling.
. Created Derived Tables according to end user requirements to develop
multiple SQL queries
. Worked extensively with Business Objects functionalities like Alerts,
Filters, Sorts, Drill filters and integrity check on Universes and
exported to the repository
. Migrating Repositories, Users/Groups across databases, migrating
Universes and Reports across repositories both in Full Client and Web
Intelligence
. Created cascading dynamic parameters in Universe to allow the end-user
to select prompt-filtered data
. Used multi-grouping, running totals, with conditional formatting
. Extensively used features like drill-down, hide and new page after.
. Customized data by adding Filters Calculations, Prompts, Summaries and
Functions
. Worked with multi-level, multi-chart display to show summarize fields
and used multiple pie chart, stacked bar graph, line graph, XY scatter
plot and others to represent data figuratively and represented graphs
as groups. Also used dual axis charts
. Exported reports into various formats like PDF, HTML, EXCEL, and WORD
. Extensively queried with SQL, PL/SQL and SQL databases. Created
consolidated reports for stored procedures, views
. Involved in performance tuning existing reports
Environment: SAP Business Object XI 3.1/ R2 (Designer, Web & desktop
intelligence, CMC, Xcelsius (2008), Infoview), Oracle 9i/10g, SQL Server
2005/2000, DB2, .NET 2005, MS Office 2000,Windows XP/2000 Server
MEGA Life and Health Insurance Company, North Richland Hills, TX
Dec 2008-Apr 2010
Title: Business Objects Developer
Responsibilities:
. Involved in migrating Universes and reports from Business Objects R2
to XI 3.1
. Created daily, weekly and monthly- administrative reports, client
information reports, financial reports, billing reports, AR reports,
employer reports, client-specific business reports, global services
reports using Web intelligence and integrated data from SQL Server.
. Worked liaising with Database Admin, Business Analyst and end-users in
development and designing of Universes and end-user reports generation
using BO (Desktop/Web Intelligence) XI 3.1 Suite
. Iinvolved in documentation for troubleshooting Business Objects XI 3.1
installations, administration, upgrading and applications that are
required prior/after the installation process
. Worked on BO XI 3.1 application architecture to Design, Deploy, and
Support business Intelligence architecture and worked on cross-
functional ad hoc report generation with OLAP and strategy analysis
and designed multi-dimensional star-schemas with OLAP objects for
large scale database
. Managed Business Objects application components, including users,
groups, folders, and repository objects, and implementing row-level
security in Universe
. Experience in Designing, Building and Maintaining Universes and versed
in resolving loops and traps (Chasm and Fan trap) using alias and
context, filters on queries, format tables, designing complex objects
using @prompt, perform tuning & performance analysis using @aggregate
aware and related built-in functions and also created list of values
(LOV) for custom hierarchy settings, and used slice-dice with drill
down.
. Created and formatted charts for visual representation
. Scheduling daily, weekly and monthly reports, adding users and folders
and assigning security rights in CMC
. Formatted, summarized, filtered, sorted and grouped data in WebI
Reports and organized fields into sections and merged and suppressed
sections within a report. Applied concepts such as queries, functions,
parameters and formulas
. Created reports using various features like cross-tabs, Graphs, drill-
down and hyperlinks.
. Created graphical representation of reports such as bar charts, pie
charts, and line charts as per client requirements to set the tab
values in data, axes, options, color highlight and text tabs.
. Worked as a Subject Matter Expert, showcasing product functionality
and acted in an advisory capacity when needed
Environment: Business Objects XI-3.1 (Designer, Webi, deski, XCelsius),
Crystal Reports XI-3.1/2008, Crystal Oracle10g/11g, DB2, SAP R/3, Erwin
R7.3, TOAD 9.7, MY SQL, MS Access 2003, MS Excel 2003, MS PowerPoint 2003,
MS Word 2003, Windows Vista/XP/2003
Forest Laboratories, New York NY
Jan 2008-Nov 2008
Title: Business Objects Developer
Responsibilities:
. Interacted with Business Users and Business Analysts to gather the
Requirements and Business logics.
. Involved in Writing Detailed Level Documentation for reports and
Universe design.
. Involved in the designing and Building of Universes from different
data sources like Oracle/SQL Server.
. Created reports using multiple data providers such as Universes and
personal data files in generating reports.
. Resolving join path Problems like Chasm Trap and Fan Trap and Loops by
creating Context and Aliases.
. Created Cardinalities and checked the Integrity of the Universes.
. Worked extensively with @Functions (@Select, @Prompt, @Where) to
filter the data.
. Modified Universes with pre-calculated aggregates from summary tables.
. Created user Prompts, Conditions and Filters for various reports to
specify the reporting parameters as per the business rules and the
requirements of the end users.
. Responsible for designing the reports according to clients requirement
using Business Objects 6.5/XI R2.
. Extensively used various techniques like Sectioning, Ranking,
Filtering, Slice and Dice to develop the reports.
. Generated reports using free-hand SQL which had complex Business
Logics.
. Designed, developed and tested the reports based upon data generated
by enterprise transaction, financial, and customer information systems
using Business Objects connected to Oracle 9i data sources.
. Involved in fixing the defects in universes and reports in the BO XIR2
Environment.
. Created, modified, and maintained the business complex Reports using
Business Objects Reports module.
. Tuned the queries to improve the Performance of the existing Reports
for various functional areas.
. Extensively used calculations, variables, filters, breaks, drill down
and slice and dice for developing web intelligence Reports.
. Created Master/Detail, Cross Tab and Charts using conditions, sort,
Alerter and breaks.
. Created hyperlinks in BO reports to link summary and detail reports
using open document syntax.
. Developed Hierarchies to support drill down reports which allows the
users to analyze the data.
. Applied security features of Business Objects like report level &
object level security in the universe so as to make the sensitive data
secure.
. Involved in post production Support and gave training to the end users
to create Adhoc reports.
. Created Full client and WebI reports. Modified the existing by adding
new columns based on the result set.
. Created cascading list of values to enable cascading prompting in the
reports using Designer.
. Migrated the Universes/ Reports from Development environment to Test,
and then to Production Environments.
. Responsible for Migration of the Universes/Reports Business Objects
6.5 to Business Objects X1R2 across the Servers/Repositories
(Development to Production Servers).
. Experience working with XCelsius to display summary-level business
data in a rich and intuitive format.
. Developed Detail report Design documentation review, analysis and
modification.
. Participated in documentation and user training.
Environment: Business Objects 6.5 (Supervisor, Designer, Reporter), Crystal
XCelsius 4.5, Oracle 9i, Teradata, MS SQL Server 2000, TOAD, PL/SQL,
Windows 2003 Server, Sun Solaris.
METRO Group Inc., Long Island City NY
Sept 06-Oct 07
Title: Business Object Developer
Responsibilities:
. Understanding of client requirements & preparation a functional
requirements document
. Created Contexts and Aliases to resolve chasm and fan traps in
Universes.
. Customized LOVs in Universes for quicker performance of reports.
. Created Joins, Contexts, and Aliases for resolving Loops and Universe
Tuning and checked the Integrity of the Universes.
. Created the joins strategies to avoid loops and traps while designing
the universes.
. Converting all existing DTS package of MS SQL 2000 to 2005 by adding
extra SSIS task.
. Scheduled the DTS package for migration of data from old system to MS
SQL 2005.
. Responsible for developing/enhancing reporting functionality
incorporate new business requirements.
. Checked Performance Tuning, Indexing, Query Optimization.
. Responsible for implementing change management controls to efficiently
and accurately tracking defects and enhancements.
. Created reports in crystal reports and published reports back to BO
and scheduled the reports.
. Exported the Reports to the Broadcast Agent and used the Broadcast
Agent server to Schedule and Monitor the Reports.
. Created Master/Detail, Cross Tab and Charts using conditions, sort,
Alerter and breaks.
. Created hyperlinks in BO reports to link summary and detail reports
using open document syntax.
. Developed Hierarchies to support drill down reports which allows the
users to analyze the data.
. Applied security features of Business Objects like report level &
object level security in the universe so as to make the sensitive data
secure.
. Involved in post production Support and gave training to the end users
to create Adhoc reports.
. Created Full client and WebI reports. Modified the existing by adding
new columns based on the result set.
. Created cascading list of values to enable cascading prompting in the
reports using Designer.
. Migrated the Universes/ Reports from Development environment to Test,
and then to Production Environments.
Environment: Business Objects 6.5 (Supervisor, Designer, Reporter),Crystal
XCelsius 4.5, Oracle 9i, Teradata, MS SQL Server 2000, TOAD, PL/SQL,
Windows 2003 Server, Sun Solaris.
Contact this candidate