Manager Data
Resume:
Shyam Babu
Ph: 205-***-**** Email: *******@*****.***
Professional Summary:
7+ years of Business Objects Experience
. SDLC: 7+ years of IT experience in Analysis, Design, Development and
Implementation of Data Warehousing
. Business Intelligence: Business Intelligence experience with complete
life cycle Implementations using Business Objects XI
4.0/XIR3/XIR2/6.5/6.1/6.0/5.1 (Supervisor, Designer, Info view, Business
Objects Reporting Business Objects SDK, Xcelsius, Web-Intelligence
3.2/2.7/2.6/2.5, Web-I SDK, Broadcast Agent, Publisher, BO Set Analyzer,
Data Integrator, Application Foundation & Dashboard Manager)
. Business Objects: 7 years of Extensive experience in installation and
configuration of Business Objects full client & thin client environment.
Created complex reports by, using functionalities like Combined Queries,
Slice and Dice, Drill Down, Master Detail, etc. Extensive experience in
Business Objects Enterprise products namely Business Objects Designer,
Business Objects Reporting, Business Objects Supervisor, Web
Intelligence, Info View and scheduling the reports using Broadcast Agent
Publisher (BCA), Crystal Xcelsius. Set up Broad Cast Agent and Configured
the Broad Cast Agent.
. ETL: Experience in loading huge amount of data into data warehouse using
ETL tools like DTS and SSIS.
. Data Modeling: Experience in analyzing, designing and modeling data
warehouses and star schema data marts for various business verticals like
Retail sales, Health Care (Pharmacy), Financial and Insurance,. Good at
Database Design, conceptual, logical and physical Data Modeling, Star
Schema, Snowflake; FACT and Dimensions tables, slowly changing dimensions
(SCDs).
. Databases: 7 years of solid database experience in Oracle
11g/10g/9i/8i/8.0/7.x, Teradata V2R5/V2R4, DB2 8.0/7.0/6.0, MS SQL Server
2000/05/08, (database triggers, materialized views, In-line views,
Packages, stored procedures, functions, and database constraints), SQL
Loader, SQL*Plus, PL/SQL and oracle DBMS Packages, oracle supplied
utilities, Developer 2000 (Forms 6i/5.0, Reports 3.0/2.5), TOAD, Rapid
SQL.
Education:
Bachelor Degree in Computer Science
Technical Skills:
Business Intelligence
Business Objects XI 4.0/R3/R2/6.5/6.1/6.0/5.1 (Supervisor, Designer,
Info view, Web-Intelligence, Data Integrator, Xcelsius, Web-I SDK,
Broadcast Agent, Publisher, Designer, Supervisor, Auditor, Application
Foundation Dashboard Manager, Report Writer, BO Set Analyzer, Application
Foundation & Dashboard Manager),
Business Analysis
Functional Requirements Gathering, User Interviews, Business
Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, Data
Analysis, Requirements Analysis, Design, Data Modeling, Data Architecture,
Data Flow, Data Cleansing
Dimensional Data Modeling Dimensional Data Modeling, Data Modeling, Star
Join Schema Modeling, Snowflake schema, FACT and Dimensions Tables,
Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2, Oracle Designer,
Visio and Sybase Power Designer.
ETL Informatica Power Center 8.1/8.0/7.1.2, Power Mart 6.2/5.1.1, Data
Services, Workflow Manager, Work flow Monitor, ETL, ETI, Data mart, OLAP,
OLTP, Mapplet, Transformations, SQL*Plus, SQL*Loader
Databases Oracle 10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server
2008/2005/2000/7.0/6.0, Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x, MS
Access.
Programming
Unix Shell Scripting, Kernel Programming, Perl Programming, SQL, PL/SQL,
SQL Plus, Transact SQL, ANSI SQL, VB, Java, C, C++
Environment:
Sun Solaris 2.6/2.7, HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Novell
NetWare 4.11/3.61, Win 3.x/95/98, Win NT, Red Hat Linux, Sun-Ultra, Sun-
Spark, Sun Classic, SCO Unix, HP9000, RS6000, Win 3.x/95/98, Win 2000, Win
XP. MS-Dos
Client: Medidata Solutions, New York, NY
April 2012-Present
Sr. Business Objects Developer
Medidata provides customers with a competitive advantage by facilitating
operational excellence in their clinical research processes eliminating
redundant and error-prone processes, fostering collaboration via dynamic
information flow between traditional trial design, planning, execution and
analysis silos, increasing study execution agility through insightful
decision-making and maximizing value to sites and sponsors by supporting a
best-in-class solution approach.
Responsibilities
. Involved in report requirement gathering.
. Actively involved in the creation and modification of user/user groups
and maintained user profiles using Supervisor.
. Designed and maintained Universes and exported them to the repository.
. Created Classes and Objects (Measure, dimension and detail) in the
universe.
. Did the Tasks like setting auditing for business objects
. Used Designer Module to implement Universes, Joins between Tables, and
created prompts and queries, parsing of Universes, and created
Contexts and Alias Tables to remove cyclic dependencies.
. Developed Complex Reports (Used multiple data providers, Union,
Intersection, minus and Master/Detail, cross tab, Charts).
. Created reports using standard company templates. A few of them were
created based on the Department requirements.
. Extensive use of Business Objects functionalities in formatting
reports. Created user Prompts, conditions and Filters to improve the
report generation. Also used Alerts to improve the readability of the
report.
Environment:
Business Objects (Designer, Business Objects, Supervisor), Windows NT BOBJ
XI 4.0/XIR 2, WEBI, Crystal reports 2011, Crystal reports for enterprise 4,
Rally.
Client: Sivic Solution Group, Utica, NY
Sep 2011-Mar 2012
Sr. Business Objects Developer
A web based intranet financial system developed for Ohio Department of Job
& Family Services, and the County Agencies that work with PA, PCSA, CSEA
and WIA agencies. This application deals with the Budget Allocation, Budget
Distribution, Draws, Cost, allocations, Expenditures and other tools to
post the data to OAKS in periodic intervals. And also, system will provide
a series of reports; dashboards and analytical tools to help the state and
the counties mange the process effectively..
Responsibilities
. Involved in report requirement gathering.
. Actively involved in the creation and modification of user/user groups
and maintained user profiles using Supervisor.
. Designed and maintained Universes and exported them to the repository.
. Created Classes and Objects (Measure, dimension and detail) in the
universe.
. Did tasks like setting up new Users, Groups and assigning security at
Folder level and I did LDAP/AD authentication for the business objects
. Used Designer Module to implement Universes, Joins between Tables, and
created prompts and queries, parsing of Universes, and created
Contexts and Alias Tables to remove cyclic dependencies.
. Developed Complex Reports (Used multiple data providers, Union,
Intersection, minus and Master/Detail, cross tab, Charts).
. Created reports using standard company templates. A few of them were
created based on the Department requirements.
. Extensive use of Business Objects functionalities in formatting
reports.
. Created user Prompts, conditions and Filters to improve the report
generation. Also used Alerts to improve the readability of the report.
. Creating the reports in Web Intelligence using WebI Java Report Panel.
Environment:
Business Objects (Designer, Business Objects, Supervisor) 5.1, ZABO, Oracle
8, Windows NT BOBJ XI 4.0/BOXI R3.1/XIR 2, WEBI, BEx Reports Xcelsius, CVS,
Clear Quest, PCRS.
BMO Financial Group, New York City, NY
Date Oct'09 - Aug'11
Business Objects Developer
BMO Financial Group has one of the richest histories of any financial
institution in North America. BMO Financial Group continues as one of
Canada's pre-eminent financial institutions, with a significant presence in
United States and world markets. This project was involved in delivering
financial reporting system
Responsibilities:
. Requirements Gathering and Business analysis.
. Created Universes incorporating with various classes and objects, pre-
defined filters.
. Created summary and details reports, Cross Tab reports with prompts
and filters using Business Objects.
. Familiarized the business, its strategy and implementation.
. Performed Server Management Tasks, using Central Configuration Manager
(CCM) and Central Management Console (CMC).
. Gathered Customer, User and Owner requirements; analyzed and
documented them.
. Implemented Best Practices for Using Business Objects Suite of
Products.
. Created Dev and Test and Prod environments as per the best practices.
. Implemented Security with CMC for single sign on for end user
activity.
. Implemented Import wizard & publisher for migrating reports &
universes.
. Designed and customizing data models for Data warehouse supporting
data from multiple sources on real time.
. Migrated reports from BO 6.5 to BO XI2.
. Performed all tasks like setting up new Users, Groups and assigning
security at Folder level.
. Creation of reports like Reports by Product, Reports by Customer,
Reports by Period, Demographic reports and Comparative reports,
Working with database connections, SQL joins, cardinalities, loops,
aliases, views, aggregate conditions, parsing of objects and
hierarchies
. Setup hierarchies in the Universe for providing drill down options in
the reporting environment.
. Helped manage risk analysis and mitigation plans, status reports, and
client presentations; prepared business process models, defined
milestone deliverables, and established critical success factors.
. Gathered requirements during inception phase, documented and delivered
functional specification documents, and assisted architecture analysis
and design using UML and Rational tools.
. Experience in cleansing data in DI using proper data types and
mappings and to create Workflows using object library and tool palette
to execute data flows.
. Created multiple universes and resolved Loops by creating table
aliases and contexts.
. Worked with database connections, SQL joins, cardinalities, loops,
aliases, materialized views, views, aggregate conditions, parsing of
objects, LOVs, and hierarchies.
. The universes were frequently tested for validity and correctness of
inferred SQL.
. Created reports on development data to test the functionality of
universes with a group of power users.
. Assisted the Application team in data modeling and T- SQL coding in
Oracle.
. Knowledge of Crystal Reports reporting system including Crystal Server
reports distribution infrastructure.
. Developed Internal control reports to validate the ETL load and
scheduled it.
. Performed Server tasks, including Manage Services - Starting -
Stopping Server Services,
. Publishing, Migrating, Importing etc.
. Created, refined and delivered functional test materials collaborated
with test cases, set up test plans, schedules and scenarios.
. Optimized database performance by using shortcut joins. Shortcut joins
provide an alternative path between two tables. Shortcut joins can
improve query performance by using shorter paths and bypassing
intermediate tables.
Environment: Business Objects XIR2/6.5/6.1, Data Integrator, Dashboard
Manager, Xcelsius, Web I 6.1, DESKI, JSP, SQL, PL/SQL, Erwin, SQL*Loader,
UNIX Shell Script, Windows 2000/NT, Teradata
State Farm Insurance, Bloomington, IL
OCT'08 - Sep'09
Role: Business Objects Developer
State Farm Insurance is a group of insurance and financial services
companies. It is the largest automobile insurer in the United States and
insures more cars and homes in the United States than any other insurer.
The project is developed for the sales and Insurance division.
Responsibilities:
. Requirements Gathering and Business analysis.
. Created Universes incorporating with various classes and objects, pre-
defined filters.
. Created summary and details reports, Cross Tab reports with prompts
and filters using Business Objects.
. Familiarized the business, its strategy and implementation.
. Gathered Customer, User and Owner requirements analyzed and documented
them.
. Worked on Installation and Configuration of Business Objects XI.
. Worked in a production support role where in typical issues have been
intelligently resolved.
. Experienced in configuring security in BOE 3.1 Sp3.Experienced in
using Tomcat with BOE.
. Responsible for the Administration of the tools such as CMC, LCM.
. BOBJ Security settings and setting up user, user groups and
application security.
. Created reports using SAP data source.
. Designed and customizing data models for Data warehouse supporting
data from multiple sources on real time.
. Actively involved in creating SSIS packages to transform data from
OLTP database to a data warehouse
. Scheduling the SSIS packages and jobs.
. Migrated reports from BO 6.5 to BO XI2.
. Setup hierarchies in the Universe for providing drill down options in
the reporting environment.
. Created Sets, Metrics, Rules, using Set Analyzer and Dashboard
Manager.
. Created and customized application dashboards using Application
Foundation and used balanced score cards and speedometers.
. Experience in cleansing data in DI using proper data types and
mappings and to create Workflows using object library and tool palette
to execute data flows.
. Linked two universes sales and customer using kernel approach.
. Created multiple universes and resolved Loops by creating table
aliases and contexts.
. Worked with database connections, SQL joins, cardinalities, loops,
aliases, materialized views, views, aggregate conditions, parsing of
objects, LOVs, and hierarchies.
. The universes were frequently tested for validity and correctness of
inferred SQL.
. Created reports on development data to test the functionality of
universes with a group of power users.
. Scheduled reports to business users and owners using Broadcast Agent.
. Exported the Business Objects reports to Web I to be viewed by all
users on the Intranet using Web I; SDK with JSP plug-in.
. Extensively worked on OLAP cubes for building universes.
. Performance tuned Business Objects Data Integrator XI jobs to ensure
optimal performance.
. Extensively used Data Integrator to cleanse and populate target
database.
. Developed Internal control reports to validate the ETL load and
scheduled it.
. Created reports using WEBI, DESKI, full client.
. Created reports using the business object functionality like queries,
Slice and Dice, Drill down, functions and formulae.
. Knowledge of Crystal Reports reporting system including Crystal Server
reports distribution infrastructure.
. Experience with Crystal Xcelsius dynamic data presentation software.
. Created the stores procedures and functions at the back end.
. Fine-tune the existing universes to enhance their performance.
. Created graphs/charts for the reports, Created Master Detail and Cross
Tab Reports.
. Enabled/Disabled different servers in Central Configuration Manager
and Central Management Console.
. Performed Server Management Tasks, using Central Configuration Manager
(CCM) and Central Management Console (CMC).
TVS Group, INDIA
July 2005 - Sep 2007
Role : Business Objects Developer
TVS is a diversified industrial conglomerate with principal base in
Chennai, India. The largest and the most visible company is TVS motors, one
of the top three two wheeler manufacturers in India. Metrics were created
and reports were generated.
Responsibities:
. Created Universes incorporating with various classes and objects, pre-
defined filters.
. Created summary and details reports, Cross Tab reports with prompts
and filters using Business Objects.
. Used various features like Customized sort, Highlighting, Page break
etc.
. Published existing reports to corporate using Broadcast Agent
. Interacted with the users to analyze the changes for improvement they
need in existing reports and developed the reports to satisfy their
needs and requirements
. Environment: Oracle 8i, Crystal Reports, Business Objects 6.5, SQL,
PL/SQL, Windows 2000
Environment:
Crystal reports 8.5, Crystal Enterprise 8.0, Oracle 8i/9i, PL/SQL, SQL*Plus
MS Excel, ASP, HTML/DHTML, VBScript, IIS Server, Web component server,
Windows 2000, UNIX.
Contact this candidate