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-Access, Teradata 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.