Bo Developer Email & Phone Number

 Over 8+ years of experience in providing Business Intelligence solutions using Sap Business Objects 4.0XI/R3/XIR2/XIR1/6.5, Crystal Reports 2008/2011/XI, dash boards using Xcelsius 2008  Over 8 years of experience in Crystal Reports, reports generation, migrate reports using Info View, Web Intelligence (WEBI), Central Management Console (CMC),  Experience with Software Development Life Cycle (SDLC) including analysis, design, development, testing, implementation and maintenance of application software in the client/server and web based documents Proficient with data Modeling methodologies (Star schema, Snow-flake) and data mining Database experience using Oracle 11g/10g/9i, SQL server 2008/2005 and MS Access  Managed complex security settings; user/group/application/data row level/object level security  Experience with migration of Business Objects XI to XI R2, Crystal Reports 2008/2011/XI Sound knowledge of relational database (OLTP) and data warehousing systems (OLAP) Good knowledge in star schema modeling and knowledge of snowflake dimensional modeling  Expertise in gathering business requirements and preparation documents such as of Business Requirements Documents (BRD), Functional Specification Documents (FSD), Report Requirement Document, Project Specification Document, Technical Specification Document, and Requirements Traceability Matrix Involved in Unit testing includes data validation using SQL scripts, data integrity, functional testing, integration testing, regression testing and system testing, post production support  Experience with SQL and PL/SQL, functions, triggers, stored procedures. Project Management; prepared project status reports, and impact analysis Scheduled and distributed Web Intelligence, Crystal reports using Central Management Console

• 

  Bo Developer

  Sonoco

  2011 - Present - Hartsville, Sc

  • Hands on experience working on the new BO 4.0 Environment • Worked on Performance tuning for BI 4.0• Designed .UNX(IDT) as well as .UNV(UDT) universe. Created derived tables for some of the universes.• Designed various Sales and Inventory reports including Order To Cash, Inventory Management, Procurement etc. in Webi 3.1 as well as 4.0.• Delivered Webi XI reports based on Derived tables using free hand SQL which utilized PL\SQL functions.• Created Complex and Multi Dimensional reports using, Cross Tab, Slice and Dice, and Sub Queries.• Created local variables with complex logics in the reports for calculating the metrics in the canned report• Used functionalities like conditional formatting, prompts, Hyper-linking, and Drill Down functionality to optimize report analysis• Installed and configured Crystal 2008/11 client tool• Migrated the reports from existing legacy systems using Crystal 8 into Crystal 2008 format• Migrated around 600 reports including reports for the 12 Sonoco Mills and 30 Corporate reports• Extensively used the Crystal functions including formulae, selection criteria, groups, parameters, Date, time functions, formatting the reports• Extensively worked on the Dynamic LOVs on all the reports, changed the parameters• Worked on modifying the existing sub-reports for the Sonoco Mills • Implemented the ODBC settings and created the system DSN for each mill in SQL Server 2008• Used the CMC in BI launch pad and mapped the created DSN with the individual database/schema of all 12 mills for each report• Performed unit testing on all the reports and checked the functionality and matched the data with the source• Created change requests for migrating the reports from DEV to PROD• After migrating the reports into PROD, worked on the assigned issues in the bug tracker tool, fixed them and created change requests for re migrating the report into PROD