Manager Sales
Resume:
SREEKAR RAVI
Phone No: 937-***-****
Email Id: *******.****@*****.***
PROFESSIONAL PROFILE
. Business objects certified professional (BOCP) certified from Business
Objects.
. Teradata Certified Master (One of the 2000 Elite Group).
. Eight + years of experience in implementing Business intelligence with
Data Modeling, Data Analysis, Implementation of Data Warehousing and
Database Applications, which include platforms like Business
Objects,Crystal Reports, Qlikview, Informatica, SQL Server 2005/2000,Teradata,DB2,Oracle,, Sybase, Power Builder, Web and Client/Server
Application development.
. Worked extensively in developing Universe and implementing reports on
Business Objects XI R3.x,R2/R1/6.5/6/5.1, Universe Designer, XI
Architecture & Security, Web Intelligence, Desktop Intelligence, Business
Views,, SDK, Dashboard Manager, Performance Manager, Info view, Central
Management Server (CMS),Data Federator, Data Integrator, Crystal Reports
Enterprise 2008, XI R1, R2, 10, 9, 8.5.
. Three (3+) Years of experience in Data warehousing using ETL Informatica,
Abnitio, Informatica Power Mart/Center 8.1.1,6.2/5.1/4.7/1.7, Informatica
Power Connect, Fact Tables, Dimension Tables, Star Schema Modeling, OLTP,
OLAP, MS SQL Server 2000, MS Access 2000/97, Erwin 4/3.x, Windows
NT/2000, Windows 98/95.
. Strong understanding of Data Warehouse concepts, OLAP, Star Schema, Data
Modeling using Normalization, Business Process Analysis, Dimensional Data
Modeling, Fact & Dimensions tables, Physical & Logical Data Modeling.
. Advanced expertise in Oracle/SQL Server/Teradata SQL with nearly 5 years
of experience.
. Strong suite is in breaking down complex business/technical problems,
Architecture, XI R2 Migration, BO Security, Single Sign on, BO SDK and
customizing BO Enterprise for Customer needs.
. Experience with development tools such as Crystal Xcelsius and Corda
CenterView.
. Deployed the XI open Document /Web Intelligence features for URL
reporting and Report to report linking.
. Hands on experience in writing, testing and implementation of the
triggers, stored procedures, functions in Oracle/SQL Server/Teradata.
. Experience to manage multiple projects simultaneously.
TECHNICAL AND EDUCATIONAL BACKGROUND
BI & Reporting Business Objects XI R3.x,R2/R1/6.5/6/5.1,XI Architecture
Tools & Security, Web Intelligence, Desktop Intelligence,
Business Views, Universe Designer, SDK, Dashboard
Manager, Performance Manager, Crystal Reports Enterprise
2008, Crystal Reports XI with Service Pack 2, Crystal
Xcelsius.
Data Modeling, Erwin 7.1, Erwin 4/3.x, Informatica Power Mart/Center
ETL 8.1.1,6.2/5.1/4.7/1.7, Informatica Power Connect.
. Net VS.Net 2005, 2008 C#.Net, VB.Net, ADO.Net, ASP.Net, AJAX,
Technologies and NUnit,
Related Tools
RDBMS Teradata V2R12, V2R5,Oracle 10G,SQL Server
2005/2000/7.0.
Web Technologies ASP.Net, ASP, Dream weaver, HTML, DHTML, XML, SOAP, COM,
VBscript, JavaScript, CSS, Front Page, WCF,WWF.
Operating Systems MS WinNT4, UNIX, HP-UX, Win2K, AIX.
Scripting XML, HTML, DHTML, Java Script, VBScript, Unix Shell
Languages Script
Utility Tools MS- Office 2005, Macromedia Dream weaver.
Web Servers BEA Web Logic Server, Apache HTTP Server, IBM Web Sphere,
Tomcat, Oracle Application Server
Languages PL/SQL, SQL*Plus 8.0/3.3, TSQL, Java, C++, C, Visual
Basic/VB Script.
Professional Experience:
FEDEX SMART POST, New Berlin, WI
January 2010- Present
Business Objects/Crystal Reports Consultant.
FEDEX implemented a central data warehouse to streamline data sharing
across all levels of the organization. Data was integrated from different
departments like freight, ground, and the Smart Post department into one
central data warehouse. The motive of this project is to help business
executives to find the right software solutions and services.
Responsibilities:
. Designed Business Objects Universes for star schema & snow flake
schema data models.
. Created complex Web I,Desk I reports using Business Objects
functionality's like Drill Down, Cross Tab, Master Detail and
Formulae's, Predefined conditions, Filters, Prompts, Breaks, Sorts,
etc.
. Developed several Complex Reports (various features included multiple
groupings, drilldowns, parameter fields, formulae and conditional
formatting) using Crystal Reports.
. Created several reports using Business Views, Cross tabs, Top N,
Complex Views, Command Object, Functions and Stored Procedures in
Crystal Reports 2008.
. Fixed bugs in Crystal Reports and enhanced existing reports. Converted
reports that were created in earlier versions to Crystal Reports XI
with appropriate changes.
. Involved in all phases of migration from Crystal Enterprise XI R2 to
2008.
. Developed and Maintained Universe,Extensively worked on CMC (Central
management console) in maintaining objects, Universes, Connections,
Resources, Users, User Groups, and Categories in BO Xi.
. Worked on creating Aggregate tables at various level based on business
requirement and Created aggregate awareness on facts and dimensions
for faster performance of reports.
. Applied row level and object level securities to different
groups and users in the Universe designer wizard.
. Worked extensively on Import Wizard in Promoting the Universes/Reports
based on the SDLC Process(Dev( UAT( PROD)
. Recreated all the previous reports which were build in power builder
and migrated the reports in Business objects to BO XiR3.
. Maintaining universes and troubleshooting of universe schema with
Loops, Chasm and Fan traps, and Cardinality problems.
. Resolved loops by creating Aliases and Contexts.
. Worked on the Master, Kernel and Component approach during the linking
of universes.
. Expertise in working with Derived tables for improved query
performance.
. Given training to the Business Objects End users on BOE XI 3.1 new
features and the new tool Web Intelligence Rich Client..
Environment: Business objects XIR3.x(Webi,Rich Client,Designer,CMC),
Crystal Reports XI with Service Pack 2, QlikView, Xcelsius 2008,Live Office
Reports 2008, Teradata V2R6/V2R12,
Oracle 10g,SQL Server 2005.
SHIRE Pharmaceuticals, PA
Sep 2008-Dec2009
Business Objects/ Crystal Xcelsius Consultant
The company opted for Business Objects Enterprise deployment for generating
Activiy and Sales reports.
Responsibilities:
. Created complex Web I reports by linking objects from different data
providers and using Merge Dimension Option.
. Worked On universes(Activity,Sales and helped the team to go live
for there realeas.
. Designed and completed the entire overlay Reports with the concept of
merging detail objects.
. Worked on Security and Publication of the Overlay Reports.
. Worked with the share point team in getting the Data level security in
place for the Reps.
. Worked in creating Macros for different file formats like .CSV and
txt.
. Worked extensively with the major functionality of BO like Breaks,
Alerter, Filters, Sorts, and Query Prompt and Drill filters.
. Tuned sql & universes for trouble shooting of reports for data
accuracy and reports for better performance using SQL Explain plan.
. Worked extensively on Import Wizard in Promoting the Universes/Reports
based on the SDLC Process(Dev( UAT( PROD)
. Created Static and Dynamic Parameter fields for the filtering of the
data.
. Developed dashboards and data visualizations using Crystal Xcelsius
and connected dashboards to live data sources using web-services.
. Interacted with Business Analysts, Business Users and Managers in
gathering business requirements for XCelsius Dashboard.
. Expertise in developing static and Live Flash enabled Xcelsius
dashboards with dynamic refresh.
. Extensively used the various visual components of xcelsius to present
different outcomes on dashboards with what-if analysis using filters,
gauges etc.
. Worked with Xcelsius web-connectivity components such as Web-Service
Component, XML-Data Refresh, Live Office Connector, URL Link button
etc to establish live connectivity to the dashboards with the database
tables, views and BO universes.
. Developed various multi-chart models that connects to real-time
enterprise data using Query as a Web Service (QaaWS).
. Used Business Objects Performance Manager/ Dashboard Manager in
creating Customer sales Data Warehouse dashboards both in WEBI and
Xcelcius XIR2.
. Used Java Scripts for client side functions.
. Responsible to support the issues with reports on the crystal
enterprise environments ( Development, UAT, Test and Production )
Environment: Business objects XIR3(Webi,Designer,), Crystal Xcelsius, Live
Office Reports 2008,, Netezza,Jira.
MASTERBRAND CABINETS Inc, Jasper, IN
OCT 2007-SEP2008.
Sr Crystal Reports/BI Lead.
In order to better serve its customers and continue to grow its business,
Masterbrand Cabinets implemented a Sales data warehouse to streamline data
sharing across all levels of the organization. Data was integrated from
different departments like Omega, Kitchen Craft, Decora and Aristro Craft,
and the S/DK department into one central data warehouse. Business Objects
XI was used to track, understand, and manage detailed Revenue information
in order to help better manage costs.
Responsibilities:
. Creation of standard Crystal / Web I reports, involving both Ad-hoc and
Canned Reports for analysis.
. Responsible for implementing reporting solutions according to
specifications utilizing Business Objects XIR2.
. Exported reports into various formats like Editable RTF, XML, PDF, HTML,
Excel, and word using Crystal Reports for user.
. Developed formatted, complex reusable formula reports and reports with
advanced features such as conditional formatting, built-in/custom
functions usage, multiple grouping reports.
. Responsible for developing provisioning reports for various groups
and upper management.
. Various Report Formats developed include Sub Reports, Cross Tab Reports,
Standard Reports and Master/Detail Reports.
. User training and testing developed reports for final deployment.
. Involved in tuning of Crystal Reports for better performance and worked
with PL/SQL and TOAD designed by Quest software for query analysis.
. Developed various stored procedures and functions in Oracle to improve
the performance thus concealing complexity from the front-end
application.
. Deployed reports on the web and scheduled reports using Crystal
Management Console.
. Created various objects Attributes, Facts, Filters, Attribute element
Prompts and Metrics.
. Involved in developing the financial reports for the Financial services
Dept and successfully published the highly formatted reports and met with
the end user requirements.
. Created KPI reports like Supply Chain Management (SCM) data like Sales
Orders, Purchase Orders, Work Orders, Branch Plant, Products and Vendor
Balances, Invoices and Customer wise Sales.
. Created reports using Business Objects like Returns Activity, Orders and
Units, Shipment Activity, Orders and Units, Mfg Activity, Discs and
Sellable Units by Shipment date, Distribution SKU Delivery Confirmation,
Percent of Shipments with Proof of Delivery..
. Created Functional requirement document (FRD) and technical
specifications for universe and reports and prepared Test Cases.
. Exported universes to the Repository for making resources available to
the users and gave 24/7 Production Support.
. Tuned sql & universes for trouble shooting of reports for data accuracy
and reports for better performance using SQL Explain plan.
Environment: Crystal Enterprise 10.0, Crystal Reports 10.0, Oracle 9i,
SQL, PL/SQL, TOAD, Windows NT,
DB2, Rumba,ISeries, OnBase, Esker, Unix Solaris 8.
R.H DONNELLEY, Cary, NC
March 2007 - Oct 2007
BI Technical Lead
R.H. Donnelley, a leading print and online local search company, connects
businesses and consumers through its portfolio of print and interactive
marketing solutions. Small- and medium-sized businesses look to R.H.
Donnelley's experienced team of marketing consultants to help them grow
their companies and drive sales leads.
Responsibilities:
. Headed the team of Reports Developers, developed the reports as well
as got them done by team on time for the releases.
. Maintaining universes and troubleshooting of universe schema with
Loops, Chasm and Fan traps, and Cardinality problems.
. Resolved loops by creating Aliases and Contexts.
. Worked on the Master, Kernel and Component approach during the linking
of universes.
. Expertise in working with Derived tables for improved query
performance.
. Worked on creating Aggregate tables at various level based on business
requirement.
. Designed Business Objects Universes for star schema & snow flake
schema data models.
. Applied row level and object level securities to different
groups and users in the designer wizard
. Created Static and Dynamic Parameter fields for the filtering of the
data.
. Used XI open Document features for URL reporting and Report to report
linking
Environment: Business objects XI R2/R1,Oracle, SQL Server 2005, Live
Office, Informatica.
FEDEX SMART POST, New Berlin, WI
Jan 2007-March 2007
Business Objects Lead
The company opted for Business Objects Enterprise deployment for generating
Sales reports for different divisions of the company such as Accounts,
Finance, Inventory Management, etc. These reports were then distributed to
different countries through out the world using Infoburst.
Responsibilities:
. Provided assistance to development team in their complicated reporting
requirements by making Universe and Data Model suggestions. Assisted
the migration team in the usage of Import Wizard and reviewed Watson's
security requirements before creating a detailed Security Design
Document. Also provided performance improvement suggestions.
. Business Analysis and Requirements gathering.
. Converting high-level design specifications to detailed functional and
technical specifications.
. Designed, developed, modified and maintained Business Objects universe
using Designer 6.5 for ad hoc and canned reports.
. Created Hierarchies, complex objects using various @functions,
Aggregate objects in the universe.
. Designed cascading prompts in the universe to filter the list of
account names based on the business units.
. Created users, users groups and maintained user access rights for BO
universes and reports using supervisor.
. Scheduled pre-canned reports through Broad Cast Agent Server for
distribution and printing.
. Used stored procedures, Free Hand SQL, and excel files as data
provider for creating reports.
Environment: Business Objects XI R2/R1/6.5,Web Intelligence, Desktop
Intelligence, Business Views, Universe Designer, Java SDK, Dashboard
Manager, Performance Manager, Business Objects Enterprise Java Info view,
Central Management Server, Informatica 7.1.2, Oracle 9i, SQL*loader, VB6.0,
Power connect for SAP R/3,Citrix, Dollar Universe, ERWIN 4.0 and UNIX.
PRIME THERAPEUTICS, Eagan, MN
March 2005 - December 2006
Business Objects Consultant
In order to efficiently manage pharmacy benefits and continue to grow its
business, PRIME THERAPEUTICS used Business Objects as there Enterprise BI
Reporting tool.
Responsibilities:
. Headed the team of Reports Developers, developed the Universe/reports
as well as got them done by team on time for the releases.
. Designed new Universes and modified the existing Universes based on
the report requirements.
. Extensively implemented @functions like @prompt, @select, and @where
to increase user flexibility and ensure integrity of universe design.
. Allowed users to construct complex reports by creating predefined
conditions for them in the Universe.
. Created various classes and objects in the Universe.
. Built Powerful Queries by creating and applying complex conditions and
sorts, User Objects, LOV's, Combined Queries, Free Hand SQL and
Semantically dynamic calculations.
. Maintaining universes and troubleshooting of universe schema with
Loops, Chasm and Fan traps, and Cardinality problems.
. Resolved loops by creating Aliases and Contexts.
. Worked on the Master, Kernel and Component approach during the linking
of universes.
. Expertise in working with Derived tables for improved query
performance.
. Applied row level and object level securities to different
groups and users in the designer wizard
Environment: Business Objects Enterprise-XI, Desktop Intelligence,
Designer, SQL Server 2000. Info view, Web Intelligence, Dashboard Manager,
Performance Manager, Business View Manager, Publishing Wizard, Teradata,
Oracle 9i,
FORD MOTOR COMPANY, MI
Jan 2002- Jan 2005
Programmer/Consultant.
Ford Motor Company, a global automotive industry leader, manufactures and
distributes automobiles in 200 markets across six continents. The project
has been developed to standardize the reporting structure and to provide a
global platform for the Business Directors or the report users to access
and analyze the reports and make intelligent business decisions to compete
with their other competitors.
Responsibilities:
. Interviewing and Coordination with end users communities understand
their requirement
finalized the BI strategy.
. Gathered Reporting Requirements and arrived at the best Reporting
Model using Business Objects teams.
. Created Business Objects repository.
. Created users and groups in Supervisor.
. Designed and developed Universes .
. Checked for Cardinalities, Aliases and Contexts for resolving Loops
and Checked the Integrity of the Universes.
. Set up Aggregate Awareness to speed up the execution of SQL queries to
reduce the time required to generate a report.
. Imported and exported the universes to the Repository in order to make
the resources available to the end users.
. Involved in Extraction, transformation and loading (ETL) data from
various sources using Informatica
. Responsible for end user training.
Environment: Business Objects 5.1.8 (BO Designer, BO Supervisor, BO User,
Webintelligence2.5, Broadcast Agent), Informatica, Oracle8i, TeradataV2R3,
Pl/SQL, Windows NT and HP-UX.
Education: Masters in Electrical and Computer Science Engineering from
Wright State University, OH.
Bachelor of Science in Computer Science at JNTU University,
India.
Contact this candidate