Bi Technical Engineer Resume Profile
PROFESSIONAL SUMMARY:
- Over 10 years of IT experience with expertise in Analysis, Design, Development and Implementation of Various Business Intelligence applications using SAP Business Objects 4.0/XI R3.1/R3.0/R2/6.x, Designer, Desktop Intelligence, Web Intelligence, Central Management Console CMC , Infoview, Tableau 7.0,Crystal reports, Xcelsius, ETL, Modeling and SQL Tuning.
- Experience in various industry sectors such as Utilities Public Sector, Retail Manufacture, Banking, Telecom, Oil and Gas and Pharmaceuticals.
- Experience in Business Requirement Gathering, Application Design, Development, Data Modeling, and Testing.
AREAS OF EXPERTISE:
- Exposure to Data Modeling, Normalization, Business Process Analysis, Reengineering and Logical Physical database designs using Erwin.
- Clear understanding of Business Intelligence and Data Warehousing Concepts with emphasis on System Development Life Cycle.
- Expertise in BOXI Web Intelligence Report Authoring, CMC, Infoview BO Designer, Crystal reports XI, and Xcelsius.
- Experience in upgrading resources from Business Objects 5.x and 6.x to XiR2/R3.0/R3.1 using Import wizard/Report wizard.
- Involved in the Administration to create users, permissions, managing the folders using Central Management Console CMC .
- Strong Experience in Developing Universes, Data Modeling, Using Star Schema and Snowflake Schemas.
- Experience in Building Dashboards in Designer Studio, Tableau, Dashboard 4.0,Xcelsius 2008, Crystal Xcelsius 4.5 using Query as Web Service, Live Office and BI Services.
- Experience in Developing and implementing Live office connectivity to BO Enterprise, Building Dashboards in Xcelsius 2008, Crystal Xcelsius 4.5 , Reports Query as Web Service , Performance Dashboards, Score cards and Metrics.
- Worked on BO Designer Functionalities like Derived Tables, Linked Universes, Aggregate Aware, Index aware, Contexts, Aliases, complex joins, Customized LOV's and Cascading Prompts.
- Extensive experience in Business Objects Full Client, Supervisor, Designer, Broadcast Agent Publisher, Info View, Web Intelligence Explorer, Web Intelligence Reporter, Business Query for Excel, Application Foundation, ZABO, WebI, SDK.
- Expertise in retrieving data using Business Objects Universes, personal data files, free hand SQL, QAAWS, Business Views etc.
- Expertise in creation of Web Intelligence Documents to create Master/Detail, Breaks, Filters, Drill, Calculations based on Contexts, 2D and 3D Pie Charts, Bar Charts and Line Charts reports.
- Experience in working on various RDBMS Oracle, SQL Server 2005/2000, DB2, and Teradata.
- knowledge in ETL Data warehousing using Informatica Power Mart 6.2/5.1, Informatica Power Center 6.2/5.1 Source Analyzer, Warehouse Designer, Transformation Developer Mapping Designer , Workflow Manager Workflow Monitor.
- Experience in educating and supporting end-user reporting needs using Business Objects.
- Highly organized, dedicated with a positive attitude and a quick learner.
- Excellent communication skills, Self-motivated, highly committed to responsibilities, ability to work independently and can perform well within cross-functional teams.
TECHNICAL SKILLS:
OALP Tools: Business Objects 4.0/XI 3.1/3.0/R2 /6.x , Crystal Reports XI/2008, Xcelsius 4.5, 2008, QAAWS, Live Office. Tableau 7.0
RDBMS: Oracle 10g/8i,7.x, SQL Server 2008/2005/2000, Teradata 13.0
ERP: SAP BW 3.5/7.0/7.1
Operating Systems: Sun Solaris 5.6/8.0, HP-UX, Aix 5.x, Redhat Linux 6.5, Windows 95/98/NT/2000, MS-DOS.
ETL Tools: Informatica PowerCenter 8.X/6.2/5.1, Data Stage
Data Base Tools: ERWin 3.5.2, Toad 7.1, AQT
Languages: Java 1.2 JSP, JDBC , XML, JavaScript, HTML, DHTML, PL/SQL, Perl, Korn/C/Bourne Shell Script C, Sun C .
Other Software: MS Office, Front Page, MS Visio, MS Project QlikView, Oracle Applications, Quality Center.
PROFESSIONAL EXPERIENCE:
Confidential
Role: BI Technical Engineer
Project Title: Smart Connect
Environment: Business Objects 4.0, Tableau 7.0, Web Intelligence, Information Designer Tool, Teradata 13.0, SAP BW 7.1