SUMMARY

• Ten Years of experience in Business Intelligence Environment using Business Objects, Crystal Reports, Xcelsius and Informatica on large scale enterprise projects involving complex business case solutions and web integration.
• Experienced in all the phases of SDLC: Requirements gathering, Analysis, Design, Implementation, Testing and maintenance of BI applications in the several domains like Banking & Financial Services, Manufacturing and Sales & Retail.
• Expert in using Business Objects tools such as Information Design Tool (IDT), Universe Designer Tool (UDT), Business View Manager, BI Launch Pad, Explorer, Web Intelligence & DeskI Reports, Xcelsius Dashboards, CMC, Infoview, Web I Rich Client, Import Wizard and Report Conversion Tool.
• Extensively worked on Universes Creation, developing complex solutions using both IDT and UDT and worked on creating Contexts, Resolving Join Path Problems( Loops, Chasm Trap, Fan Trap), Aggregate tables, Derived Tables, Aggregate awareness, Aggregate Navigation and @functions (@aggregate aware, @select, @prompt, @where and @variable)
• Extensively worked on setting up various Security Restrictions at both Universe Level (Connection, Row, Object, Table Access level Restrictions) and at CMC level (Groups, Folder/Category and Authentication Mode).
• Experienced in Business Objects Admin Tools like CMC, CCM, Import wizard, Life Cycle Manager, Upgrade Management Tool and exposure towards creating users/groups/schedulers, Server Maintenance, Code Migration, Setting up Access Restrictions and creating events (File Based & Schedule Based).
• Experienced in resolving Business Objects migration issues from V 3.1 to V 4.1 (BO BI) and XI R2 to 3.1
• Highly experienced in creating complex reports in Web Intelligence with Multiple data providers, Sub Queries, Hyper Linking, Data Tracking, Input Controls, Alerts, Drill, Sections, Breaks, Filters, Ranking, Sections, Breaks, Graphs and Extended Calculations etc.
• Developed several Crystal reports using PL/SQL Stored Producers, Universes, Business Views and custom SQL.
• Extensively designed complex formatted Crystal Reports using Sub Reports, Charts, Dynamic Section visibility and Running Totals.
• Created several Dashboards using Xcelsius QAAWS (Query as a Web Service) and Live Office connections and published the content on to the Infoview/BI Launch Pad
• Extensively worked on Informatica Power Center V9.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor) and jobs scheduling through Tidal Automation.
• Hands on experience in UNIX shell scripting and UNIX Commands. Working knowledge of Perl programming.
• Created several Informatica ETL mappings and workflows for both relational and Flat files and loaded the data into relational databases and generated the Flat files and SFTP based on client requirements
• Experienced in creating and supporting TIDAL (Job Scheduler) jobs and setup the dependencies.
• Strong SQL/PL SQL skills in writing functions, stored procedures, Packages, Views and Materialized Views.
• Worked on Data Modeling, E - R diagrams, Logical, Physical design, Star/Snow flake Schemas using ErwinTool
• Proficient in Business Process study, Gap Analysis, Testing Processes, Performance Tuning, Quality Analysis, End User Training and extensive documentation.

TECHNICAL SKILLS

RDBMS: Oracle 8i/9i/10g/11g, Sybase 12.5/15.0,SQL Server 2008/2014

RDBMS GUI Tools: Oracle SQL developer, Toad, PL/SQL Developer, Aqua Studio, SQL Server Management Studio.

BI Reporting Tools: SAP Business Objects 4.1 (IDT, IDT, BI Launch Pad, LCM, Upgrade Management Tool), Business Objects XI- R2/3(Designer, Web I Rich Client, Infoview, CMC, Import Wizard, Publishing Wizard, Report Conversion Tool, Business View Manager). Crystal Reports 2008/2011 and Microsoft SSRS (Report Builder) (Knowledge) Xcelsius Dashboards, Tableau (Knowledge)

BI ETL Tools: Informatica PowerCenter 9.1 (PowerCenter Designer, PowerCenter Repository Manager, PowerCenter Workflow Manager and PowerCenter Workflow Monitor)

Automation Tools: Cisco Tidal, IBM Tivoli

Scripting: UNIX Shell Scripting, Perl (Knowledge)

Business Domain: Sales & Retail, Banking & Financial Services, Manufacturing and Healthcare

PROFESSIONAL EXPERIENCE

Sr. Business Intelligence Developer

Confidential, NJ

Responsibilities:

• Wrote several Unix Shell scripts to automate the process such as moving files, archival process, log file creations, index creation, daily/weekly/monthly partitioning, loading specific columns from Flat files of FIX Format Files into the target tables
• Extensively worked on Cisco Tidal (ETL Jobs Scheduler- created several jobs and set it up the Job Dependencies).
• Created several Business Objects Universes using UDT and IDT for various applications like Trade Surveillance, Associate Surveillance, Mantas AML Reporting and Legal Hold Reporting.
• Tested the ETL process for both before data validation and after data validation process.
• Analyzed the report performance and took required steps to improve the performance like Filtering out the unwanted data, creating/modifying the Indexes, Table Partitioning, usage of user Defined Functions for Complex logic Calculations, shortcut joins etc.
• Created several Business Objects Reports using Infoview/WebI Rich Client/BI Launch Pad in different formats like Tabular/Cross Tab/Charts and scheduled them using CMC/Infoview to the different recipients like email, Share Point Server/ Shared Drive/ Domino’s Server/FTP Locations in different formats based on File Based Events and Schedule Based Events
• Created highly formatted Crystal Reports featuring parameters, cross-tabs, Charts, graphs, sub reports, conditional formatting and complex formulas to implement complex business rules.
• Customized existing Crystal Reports for presentations using Cross-Tab reports, sub-reports, Running Totals, Sorting, Alerting, Visual Basic syntax to create formulas for the reports.
• Well versed in using Crystal Reports functionalities for Chart Expert, Section Expert, Group Expert, Group Sort Expert, Record Sort Expert, Highlight Expert and Template Expert.
• Implemented Ad-hoc reports using Crystal Reports like Drill Down, Cross Tab, Master Detail, charts, stored procedures, custom SQL, Formulas and Business Views.

Environment: Business Objects XI R4.1/3.1, Crystal Reports 2011/2008, Informatica PowerCenter 9.1, Cisco Tidal Automation, Oracle 11G, SQL, PL/SQL, TOAD.

Sr. Business Objects/Informatica Developer and Business Analyst

Confidential, TX

Responsibilities:

• Worked with several Business Users/Source Data Teams to understand/document the Data flow and reporting requirements
• Analyzed the existing data model and rebuilt the database objects such as tables, views, packages, procedures and functions to convert the data into the new system.
• Created several Mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, XML Transformation, Update Strategy and Joiner transformations and enhanced existing Mappings to update the KPI values based on the 445 Calendar instead of Gregorian calendar.
• Created several Mapplets to grab error logging information useful for process management and auditing.
• Created Documents such as Technical Systems Design, Source-To-Target Data mapping Document, Backroom Services Document and Metrics for ETL documents, Unit Test Cases and Migration Documents for Production support.
• Designed and developed UNIX shell script to Auto run the scheduled ETL jobs.
• Extensively involved in the Analysis, design and Data Modeling. Coordinated with Data modeler to create Star Schema data model design using Erwin.
• Converted the existing Repair Project from SQL Developer Database into the Oracle Database with major enhancements to the Data model, and reassure that data migration happened correctly through FIORANO Process and created many store reports out of the new system.
• Created the several Business Objects Universes for the new data model and resolved the loops, Chasm Traps and Fan Traps.
• Used several report optimization techniques such as creating indexes, dynamic partitioning, optimizing SQL with proper outer joins, eliminating existing 1 to 1 table joins.
• Created several Universes based on the Stored Procedure
• Set up Aggregate Awareness to enhance the performance of SQL in the reports.
• Created linked universes and developed Complex reports with multiple data providers, Master/Detail charts, cross tab charts and calculation contexts to create Sales and Store reports for Daily, Weekly, MTD and YTD Schedules.
• Responsible for Conversion of DeskI Reports into WebI Reports using Report Conversion Tool

Environment: Business Objects XI R3.1, Informatica 9.1, Oracle 11G, SQL Server 2014 and JIRA.

Confidential, NJ

Responsibilities:

• Responsible for all phases of the project life cycle starting from business requirement gathering, analysis, design and implementation and testing
• Documented the requirements and translated them into reporting needs.
• Designed, developed, and tested stored procedures, views and complex queries for report distribution.
• Responsible for setting various levels of Security Restrictions at both Universe Level (Connection Level, Row Level, Object Level, Table Access Level Restrictions) and at CMC level.
• Created highly formatted reports in Crystal Reports featuring parameters, cross-tabs, graphs, sub reports, conditional formatting and complex formulas to implement complex business rules.
• Improved the performance of many reports by re-writing the Select Expert criteria and re-formatting
• Customized existing Crystal Reports for presentations using Cross-Tab reports, sub-reports, Running Totals, Sorting, Alerting, Visual Basic syntax to create formulas for the reports.
• Developed test plans and test cases at various interfaces of the project.
• Production Support to the Legacy Excel VBA Macro Reports and recreated them in Business Objects.

Environment: Business Objects XI R3.1, Crystal Reports 2008, Oracle 11G, HP Quality Center and VBA Excel Macros.

Confidential, NJ

Responsibilities:

• Designed, developed, and tested stored procedures, views and complex queries for report distribution.
• Created Database Connections and designed Business Objects Universes using BO Designer.
• Responsible for deploying the reports from lower to higher environment using Import Wizard.
• Responsible for monitoring Business Objects Servers to ensure they are up and running on regular basis.
• Created several Dashboards using Xcelsius Live Office and Qaaws Connections.
• Extensively worked on Query As A Web Service (WSDL's) while getting the query data from Business Objects Enterprise to Xcelsius
• Responsible for maintaining the reports, universes, users, groups and folders in Central Management Console.

Environment: Business Objects XI R3, Xcelsius 2008, Oracle 11G, PL/SQL, TOAD, HP Quality Center.

Confidential, NJ

Responsibilities:

• Played a major role in development of the complex reports for the entire project by using BO Reporting techniques and Static Reporting Techniques.
• Involved in the mapping document preparation, Report development, creation of database views, updating of the existing views, updating the existing Universes to meet the expectations.
• Creation of the Business Objects Universe based on the Database Views to avoid the difficulties in dealing with OLTP System.
• Involved in both Unit Testing and SIT Testing of the both Business Objects Reports and Crystal reports against the GMI Statement and Sybase Database.
• Performance tuning to optimize SQL queries by analyzing Execution Plan in Oracle SQL Developer tool.
• Customized reports by adding new features such as report alerts, cross-tabs, running total, sub-reports and drill-down fields.

Confidential, OH

Responsibilities:

• Monitored and solved the issues encountered in Universes and reports and tested before moving to production.
• Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Mode, Cross Tab, and Master Detail.
• Created several Dashboards using Xcelsius
• Created the reports by using Extended Calculation Contexts.
• Monitored Remedy system to track Help Desk tickets and resolved any problem tickets.

Confidential

Responsibilities:

• Designed, developed and managed Universes in the Designer for report generation.
• Defined Aliases and Contexts to resolve the join problem in the Universe.
• Created the different types Master/Detail, Cross Tab and Chart Reports as per the user’s requirements.
• Used Calculations, Variables, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Created several Universe conditions to automate report prompt generation.

Business Objects Developer

Responsibilities:

• Created Standard reports, Cross-tab, Sub reports, drill down reports, on demand reports using Web Intelligence.
• Created User conditions, Filters to improve report generation& readability of report and displayed the summary of data by creating Charts.
• Created Hierarchies and predefined conditions using Business Objects.
• Used Calculations, Variables, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Built and performed user acceptance testing on new and modified reports.