PROFESSIONAL SUMMARY:

• Over 8 years of IT experience in Business Analysis, Design, Development, and Implementation of Business Intelligence tools like Business Objects XIR3.1/XIR2/6.x/5.x, Crystal Reports 2008/XI/10/9/8.5.
• In Depth knowledge in Data Warehousing & Business Intelligence concepts with emphasis on ETL and Life Cycle Development including requirement analysis, design, development, testing and implementation
• Expertise in dimensional data modeling, Star and Snow Flake schema, fact and dimensional table design, slowly changing dimensions, physical and logical data modeling.
• Expertise in Physical and Logical Data Modeling concepts.
• Expertise in using Database tools like TOAD and ERWIN (data modeler)
• Excellent grasp over the Data ware housing concepts, in Extraction, Transformation and Loading in the Data ware housing process for successful building and deploying corporate data ware houses.
• Involved in Installation and configuration of Business Objects 3.1/XIR2/6.x.
• Expertise in creating Customized Objects, @prompts and Cascading List of Values.
• Experience in building Universes, retrieving data using Universes and Personal Data Files, Stored Procedures and Free Hand SQL methods and creating Ad - Hoc reports using Business Objects & Web Intelligence Tools.
• Expertise in Data Warehouse development working with Data Migration, Data Conversion, and (ETL) Extraction/Transformation/Loading using Business Objects Data Services/Integrator with DB2 UDB, Oracle, and SQL Server.
• Experience in using Data Quality transforms such as Global Address Cleansing, Match, Data Cleansing, etc.
• Analysis and delivered strong documentation of solutions.
• Converted full client report DESKI (.rep) to Web Intelligence (.wid) using Report Conversion Tool.
• Experience in creating Metrics and Analytics to create Corporate Dash boards.
• Test the report by getting the Data provider SQL and running it against the DB to check whether the report and the DB give the same data.
• Exposure with Business Objects Voyager analytical services, BW integration with Voyager, SAP Integration Kit, LCM and Federation concepts
• Used Qaaws connection for building dashboards from various data sources
• Experience in creating Dash boards, Metrics, Rules, Alerts and Goals using Xcelsius for user analysis based on user requirement.
• Good Experience in Oracle 10G/9i/8i, SQL Server 2000 and Ms-Access.
• Experience with Unix Shell Scripting (KSH - Korn Shell Scripting).
• Automated UNIX shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables in order to check for the consistency
• Involved in supporting end users in resolving issues related to Business Objects.
• Extensive experiences in developing Stored Procedures, Views, Triggers and Complex Queries on SQL Server 2008/2005.
• Hands on experience in Troubleshooting database issues.
• Ability to work in-groups as well as independently and initiative to learn new technologies, tools quickly, easily adapts to various environments and very effective communication, interpersonal skills and able to handle multiple tasks and projects simultaneously.

TECHNICAL SKILLS:

ETL Tools: Business Objects Data Services 4.0/3.2/3.1, Business Objects, Data Integrator 11.5/11.7,Informatica 8.x/7.x, Data Stage 8.0/8.1

OLAP Tools: SAP Business Objects 4.0/3.1/XIR2,/6.5 with CMC, CMS, Desktop Intelligence, InfoView, Web Intelligence XI, Rich Client XI3.1, SAP BI 7.0/BW 3.5, Voyager, Dashboard Manager, QAAWS, Voyager, Live Office, Crystal Reports 2008/XI, Xcelsius 2008

Data Modeling: Erwin 7.x and Visio 14/12

Languages: SQL, PL/SQL, Unix Shell Scripting, MDX, HTML, CSS, JavaScript, T-SQL

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2008/2005, DB2, MS-AccessTeradata V2R5/R6

Servers: Web Logic Application Server 6.1 / 5.1, TOMCAT 3.2.1, IIS 6.0

Operating Systems: Windows XP/2003/2000, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. SAP Business Objects/ Data Services Consultant

Responsibilities:

• Working as BI/BO consultant and gathered business requirements and deliverables for report requirements along with functional end users in the business areas. And analyzed to identify business content data sources for Enterprise Data warehouse.
• Designed Universes using BI and R/3 data sources and developed reports in WebI, Xcelsius and Crystal Reports.
• Created mappings using Designer and designed workflows using Workflows to build DW as per business rules
• Created WebI-rich reports using Flat files and Web services.
• Extracted Transformed and Loaded data as per the business requirements.
• Created Data Integrator mappings to extract tables from multiple sources to Staging area then load to Data warehouse Generated various reports on Daily, Weekly, Monthly and Yearly basis.
• Used various @Functions for generating reports like @Prompt, @Where, @Variable, and @Select
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Created Variables, substitution Parameters
• Created Workflows, Data flows using Designer Worked extensively with the major functionality of BO like Breaks, sections, Group values, Sorts, Pre-defined conditions, Calculations and Ranking.
• Applied Performance tuning and best practices techniques in Universe Design.
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Performed data migration using batch jobs which involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc in Data flows.
• Built jobs with Validation, Error handling and Reconciliation capabilities
• Worked extensively in Data Profiling, Data Validation and data reconciliation Reports
• Involved in Data Cleansing, De-duplication, Data Enhancement activities to enrich the Master and Transactional data
• Worked with Delta records by using CDC (Change Data Capture) on both the source level and target for SCD (slowly changing dimension) of Type 1, Type 2 and Type 3
• Created complex source to target data mappings as a part of building the design according to the mapping requirements
• Built and Unit tested the jobs for migrating objects using SAP Business Objects Data Services following the AIO best practices
• Extensively used Lookup ext, Lookup seq and also created custom functions where repetitive code is required.
• Used Global variables, Local Variables and Parameters between Work flow and Data flow as per mapping requirements
• Scheduled the Jobs in Management Console.
• Automated UNIX shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables in order to check for the consistency.
• Migrated the Universes/Reports from Development to Quality to Production Environments using Import Wizard.
• Maintaining Work History for all the tickets until it is closed down.

Environment: SAP Business Objects Data Services 4.0, Information Steward, Rapid Marts, JD Edwards, Flat Files, Business Objects XI 3.1, Crystal XCelsius 2008, SAP BI/BO integration kit, UNIX shell scripts, Oracle 11g, SQL Server 2008.Oracle.

Confidential, Troy, MI

Sr. SAP Business Objects/Data Services Consultant

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements.
• Managed Repositories using administrator console as per business requirements.
• Reviewing the code and assisting technically.
• Created mappings using Designer and designed workflows using Workflows to build DW as per business rules.
• Most of the transforms used were like the Source Lookup, Case, Merge, and Sequence Generator.
• Prepared data Extract from legacy system and populating SQL Database on which data store for BO has been created.
• Designed Material Master, Vendor Master, Customer Master Jobs in DS from Legacy to create IDOC Load Files
• Worked extensively on Data Profiling to assess the Data Quality and formulate the Data Cleansing strategy.
• Designed templates to transform Legacy Master and Transactional data compatible to target SAP ERP system
• Developing and modifying changes in data flows according to the business logic.
• Creating Variables, substitution Parameters
• Creating Workflows, Data flows using Designer.
• Used SAP AIO templates for generating IDOCS and applied SAP best practices in development.
• Worked extensively with IDOCS and LSMW for loading data into SAP ECC 6.0
• Coding & Debugging, Sorting out their time-to-time technical problems.
• Analyze the types of business tools and transforms to be applied.
• Automated UNIX shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables in order to check for the consistency.
• Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
• Tuned performance for large data files by increasing block size, cache size and target based commit interval.
• Implemented performance tuning logic on sources, workflows, data flow’s and targets in order to provide maximum efficiency and performance.
• Involved in writing the Unit Test Cases.
• Involved in migrating the jobs from Dev QA and to Production.
• Dealt with Unit Testing of all the mappings end to end and also with UAT.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Business Objects Data Services 4.0/3.2, Business Objects XI 4.0/3.2, SAP ECC 6.0, Crystal XCelsius 2008, SAP BI/BO integration kit, UNIX shell scripts, Oracle 11g, SQL Server 2008.Oracle.

Confidential, Bentonville, AR

SAP Business Objects/Data Services Consultant

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements about the financial system and prepared functional and technical specification documents for Business Objects Universes and Reports.
• Gathered User requirements from end users. PerformedBusinessAnalysis and developed detail requirements in the areas of financial instruments.
• Involved in Installation and Configuration of all products of Business Objects.
• Used Derived tables to create the universe for best performance, and used context to solve the loops in Universe.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters),@Variable, and @Select.
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Created Reports as per user requirements using BO XI R2 and tested the reports.
• Designed, developed and tested the reports based upon data generated by financial, and customer information systems.
• Used Live Office and QAAWS(Query as a Web Service) to feed live data into Xcelsius 2008 (both Dashboards & Scorecards)
• Testing pre-defined filters, universe level grouping objects, joins at universe level to make sure they are working fine. Reports testing and documenting them as per the company standards.
• Worked extensively with the major functionality of BO like Breaks, sections, Group values, Sorts, Pre-defined conditions, Calculations and Ranking.
• Created complex reports using multiple queries and involved in tuning the reports in order to increase the accessing speed.
• Automated UNIX shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables in order to check for the consistency.
• Scheduled the reports on daily wise, monthly wise and weekly by using Scheduler in B.O.XI R2.
• DevelopedWebIntelligence reports making use of several Queries (Union, Intersection, Minus).
• Developed reports by linking different data providers in a single report, and made all possible incompatibleobjectsas compatible by merging the commonobjects.
• Provided training for end users for generating their own reports including complex reports. Created reports using Oracle database.

Environment: Business Objects XIR2, Info View, Designer, Web Intelligence Rich Client, QAAWS, Live Office, UNIX shell scripts, Windows Vista, Windows 2003 Server, Oracle, Sybase.

Confidential, CA

Business Objects Developer

Responsibilities:

• Linked reports using Open Document syntax to link master report to a detail report by creating hyperlink objects in the Universes and Reports.
• Installed Business Objects Clients and Teradata Clients and made ODBC connections to database.
• Used Designer Module to implement Universe, Creating Tables, Joining the Tables, Defining the Cardinalities, parsing the Objects, applying Contexts and Alias Tables to resolve join problems like Loops, Fan Traps and Chasm Traps.
• Created Classes, Sub Classes, Objects, Conditioned Objects, Cascaded Objects, Prompts and queries for Business Analysis and Report Generation.
• Used the functionality of linking universes so as to have the flexibility to use the objects defined in one universe in another.
• Generated Custom LOV’s (List of Values) and Custom Hierarchies for drilling down Reports.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters),@Variable, and @Select.
• Developed various Complex Ad hoc and Complex Canned Reports using Universe as the main Data Provider, create and Test contexts by running ad-hoc queries using objects from various tables in a context.
• Involved with the migration and report development activity on XIR3version of BO for the client.
• Created Web I reports with multiple data providers and synchronized the data using merge dimension option in BO XIR3
• Created reports using Business Objects functionalities such as Drill down reporting, Slice/Dice, Master Detail reporting using Hyperlinks, Alerter, Sorting, Ranking, Breaks, Sections, Cross tabs, Formulae, etc. using the BO XIR3
• Used shell scripts to control the ETL process.
• Worked on SQL performance tuning to fix slow running reports.
• Tested business objects reports for data validation and compared results and query run time in bank-end i.e., Teradata SQL Assistant and Business Objects.
• Supported end users during UAT phase and worked on tracking fixing the bugs during this phase

Environment: Business Objects3.1, Info View, Designer, Web Intelligence Rich Client, shell scripts, Windows Vista, Windows 2003 Server, Db2.

Confidential, NY

Business Objects Developer

Responsibilities:

• Involved in the design and implementation of Universe using the Business Objects Designer.
• Use of Designer module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Managing security by Adding, Enabling, Disabling and Deleting of User/Groups and granting of privileges using Supervisor.
• The universe supported the creation of both pre-defined as well as ad-hoc reports.
• Created Hierarchies and predefined conditions using Business Objects.
• Created User Objects including Dimensions, Details and Measures.
• Reports were formatted to the users according to the user requirements using Business Objects functionality’s like slice and dice, Drill Down, @Functions and Formulas etc.
• Created Master Detail and Cross Tab reports to view the data for analysis.
• Extensively used Calculations, Variables, Break points, and Sorted inputs, Drill down, Slice and Dice and Alerts for creating Business Objects reports.
• Involved in creating various reports by extracting data from Data Marts to include Sales of Power Supplies.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers.

Environment: Business Objects 5.x/6.5, Business Objects Designer, Supervisor, Broadcast Agent, Oracle 8i,PL/SQL, SQL Server 2000, Windows NT 4.0 and UNIX.

Confidential

Sr Programmer

Responsibilities:

• Interacted with end users for gathering requirements
• As a part of 3-member team, was involved in design, development and implementation of the module
• Tuned stored procedures and triggers identified for better performance
• Creating Tables, indexes constraints and improved database performance
• Involved tuning and applying the SQL statements and PL/SQL processes
• Creation of different kinds of reports about Tables, Views, Synonyms etc from the Oracle Database.
• Involved in complete documentation using MS Office
• Understanding Client requirements.
• Developing complex crosstab Reports.
• Reviewing Reports developed by team mates to ensure quality of deliverables.
• Preparing templates for Report documentation, Test Cases.
• Documenting the Reports developed.
• Unit testing the reports.

Environment: Oracle 8i, SQL, PL/SQL, UNIX