SUMMARY:

• Information Technology professional with 5 years of strong technical and leadership experience.
• Over 3 years of experience working on Business Objects 4.0, Information Design tool, Business Intelligence Consumer Services (BICS), Universe Design (Unv and Unx), Web Intelligence 4.0, Business Intelligence Web Services (BIWS), Report Conversion Tool, Crystal Reports 2013, Dashboard Design using Design Studio, BI Launch Pad (Publication/Scheduling and Bursting/Personalization), SAP Business Objects Explorer, Good understanding of BEX.
• Experience in Data Modeling, ETL Design and Development, Implementation, Deployment, maintenance of Business Intelligence applications.
• Excellent data - analysis skills and ability to translate specifications into a working Universe and/or Report.
• Excellent interpersonal, organizational, analytical and problem solving skills with experience leading projects independently and in team environment.

TECHNICAL SKILLS:

• Expert in developing OLAP and relational reporting systems.
• Strong Multi-Dimensional and Extended Star Schema data modeling skills on transactional and master data from SAP ECC, SAP CRM, Non-SAP (SQL Server, DB2, Oracle, Flat File).
• Expert in developing interactive reports using Business Objects tools such as WebI, Crystal Reports, Dashboard, Universe (IDT/UDT), Analysis Office, Explorer.
• Modified BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.
• Experience in performance tuning and troubleshooting of reports.
• Experience debugging, implementation, testing and supporting software applications.

TECHNOLOGIES:

SAP Business Objects (4.0), (WebI, Xcelsius/Dashboard, Design Studio, Crystal Reports, BO Explorer, SAP Lumira, Analysis Office, SAP BO Data Services (BODS), OLAP/OLTP, BI Launch Pad, Oracle, DB2, Access, SQL Server, C++, C#, VB.NET, Visual Studio, C, Prolog, Matlab/Octave, GitHub, ODBC, HTML, MS-Office, Microsoft Applications (Outlook, PowerPoint, Excel, Word, Visio),Windows, STL, QT-SPIM, LaTeX.

PROFESSIONAL EXPERIENCE:

Confidential

Research Student

Responsibilities:

• Gathered requirements for project scope and deliverables.
• Successfully compared two DNA sequence search and clustering software packages
• Suggested some techniques to improve the packages in terms of their speed.
• Primarily used STL, UNIX shell scripting, Boost libraries.

Confidential

SAP Business Objects Developer

Responsibilities:

• Interacted with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer.
• Experience in creating Universes using information design tool 4.0 and also connecting to multiple data sources.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities, responsible for creation of the universe with Classes, Objects and Condition Objects.
• Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps).
• Modified BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.
• Developed WEBI reports on SAP Bex Queries using BICS in Webi Rich client.
• Created monthly and summary reports in WEBI 4.0 for the different domains like Sales and Marketing domains.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Created WEBI reports & Crystal reports and deployed them through BI Launch Pad with BEX as source.
• Created complex Dashboards on BEX Queries using Query Browser in Dashboard designer 4.0
• Created Dynamic Dashboards using SAP BI data/ BEx Queries.
• Have Valuable Knowledge on Dashboard Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.
• Designed a questionnaire that helps in requirements elicitation from end-users which helps in Universe and Reports Design.
• Coordinated with end-users and business analysts to understand the scope of business requirements, user expectations, and ensure the accuracy of reporting specifications
• Involved in different phases of the project like analyzing requirement, planning, execution and maintenance.
• Responsible for defining the scope of the project, gathering business requirements, doing gap analysis and documents them textually or within models.
• Worked on Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, physical & logical data modeling.
• Created complex new Universes, linked with existing Universes from Data marts.
• Resolved loops and Traps, created complex Reports, Cross Tab and Master Detail reports by using BO Functionalities like Slice and Dice, Drill Down, Variables, Filters, Breaks, Alerters and other features.
• Developed various Reports for Area wise, Regional, National, and Response Analysis using Crystal Reports/Business Objects 4.0.
• Extensively used report conversion tool for converting desktop reports to web intelligence reports.
• Designed Crystal Reports with Crystal reports formulas, Grouping, Parameters, Selection criteria to handle the report requests.
• Responsible for developing thick/thin client canned reports using Business Objects and Web Intelligence.
• Generated and scheduled standard and Ad-hoc reports using BO and Crystal Reports.
• Participated in developing the Relational Model (logical & physical) and in documentation of technical methods of development as well as business related information regarding the design process.

Confidential

Responsibilities:

• Involved in Supporting & Maintenance of Project modules.
• Modified and maintained Universes using Designer module to include objects like Dimensions, Details and Measures according to the Functional specifications.
• Created new objects and classes in the Universe based on the report creation requirements.
• Created Aliases and Contexts for resolving Loops and checked the cardinality and Integrity.
• Resolved data mismatch issues that are raised from end users.
• Created Web Intelligence Documents by writing SQL Queries for Derived tables in the universe as per the Functional Specifications.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.
• Developed various Charts, Graphs and drill down reports in WEBI.
• Created bar charts, pie charts and exported them to power point, PDF and presented them in user meetings.
• Worked on creating conditions, filters, ranking in WEBI reports.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, Variables, Formulas, Filters, Sorts, Query prompt, Context Operators, Hyperlinks in Webi.
• Created various dashboards using XCelsius and Crystal Reports.

Confidential

Software Engineer

Responsibilities:

• Designed various intranet based applications using C++, Visual Basic and Prolog.
• Architected, Modeled databases using various RDBMS systems.
• Collaborated with functional experts to scope projects, gather, analyze and define business requirements and translate them into technical specifications.
• Extensive involvement in all stages of application development life cycle including requirements, logical and physical architecture modeling, design, development, implementation, and support.