SUMMARY:

• Senior Reports Developer with over 7 years of experience in Information System and Application Development. Extensive experience in developing reports using SAP BI/BO (BW7.x and BI4.x)Business Objects, BEX, Crystal Reports, Cognos Reporting Tool, Dashboards, Design Studio, web Intelligence rich client, Xcelsius, Tableau Reporting Tool.
• Experienced in BO Administration (CMC, CMS & CCM) and Expert in Business Objects Migration from Business Objects XIR2 and XI 3.1 and 4.0, 4.1
• Expertise in Tableau dashboards and Tableau Administration
• Worked with the whole spectrum of Software Development Life Cycle, including requirement gathering, system designing, data modeling, application development, enhancement, deployment, maintenance and support.
• Experience in designing Universes (IDT/UDT), creating complex Reports using Web Intelligence and Crystal.
• Expertise in Xcelsius Dashboards, BO Dashboards (4.0)
• Possess excellent communication, decision - making, problem solving, analytical, and interpersonal skills with result oriented dedication towards goals.
• Over 5 years of strong Business Analysis experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Knowledge on SQL server Reporting system (SSRS), SSIS and Microsoft Power BI

TECHNICAL SKILLS:

BI/OLAP Tools: Business Objects BI 4.0, 4.1, XI 3.1, XI R2, Import Wizard, Central Management Console (CMC), Designer, Information design tool, Web Intelligence, Desktop Intelligence, Cognos, BIRT,BO Dashboards, Crystal Reports XI/10, and Tableau 8/9 and SSRS.

ETL Tools: Informatica Power Center 9.x/7.x.

Databases: Oracle 10g/9i/8i, Vertica Database, MS SQL Server 2000, Oracle SQL developer 4.1.5

GUI Tools: TOAD, SQL Plus,XML

Languages: C/C++, SQL, PL\SQL, ABAP,JAVA,VB.NET.

Data visualization tools: BI tools, Excel, PowerPoint, Tableau and Xcelsius

Operating Systems: Windows 2000/XP, UNIX. 

PROFESSIONAL EXPERIENCE:

Confidential, Alexandria, VA

SAP Business Objects/ Data Analyst/ Tableau Developer

Responsibilities:

• Interacted with development and business teams to identify and define requirements for Business Objects software application and day-to-day management of assigned project plans, schedules and test requirements as it relates to Business Objects, Tableau, Excel and/or user reporting needs
• Performed the System Analyst role (BSA), End to End requirement analysis based on the user remedy ticket and provided the solutions.
• Worked on source to target data analysis and data flows to fix the reporting data discrepancy.
• Created technical specifications and design document as per the technical and business requirements.
• Worked in on-call production support team (EDW help desk) and available to end users in business hours to provide the solutions using Business objects.
• Wrote complex SQL to pull the custom queries for users and their needs.
• Designed universe for standard reporting and ad hoc reporting requirements from EDW FINANCIAL, PAYROLL, HR, PTAB, CPT, PATENTS systems.
• Implemented row level security, hierarchies, and Aggregate awareness functionalities in the universe.
• Updated the Business Objects universes, Tested, Migrated to Test and PROD environments.
• Created the user groups, users and assigned the securities and roles in CMC.
• Created well formatted web intelligence reports using the Webi functionalities like creating Variables, Drill down, charts, Graphs from multiple data providers.
• Worked with end users and schedule the BO reports to end users inbox on daily, weekly and monthly bases.
• Developed Tableau data visualization using Cross tabs, Heat maps, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed Tableau dashboards by using Oracle and Excel as data sources.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's.
• Utilized Tableau server to publish and share the reports with the business users.
• Worked with ETL team to resolve data discrepancy issues and monitored the ETL data loads.
• Provided the on-call and remedy system help desk support for the Confidential end users and Analyzed, solved and supported the users based on the priority tickets related to the Business Objects reports.
• Understand momentum source data and provided custom extractors, custom reports based on business requirements.
• Generate weekly EDW Technical and Functional Remedy ticket Statistics in Remedy for client meetings.

Environment: Business Objects 4.1, Universe design tools (UDT\IDT), Tableau, Oracle 10g, Data services, BMC remedy and Oracle SQL developer.

Confidential, VA

SAP Business Objects Developer

Responsibilities:

• Worked collaboratively with development and business teams to identify and define requirements for Business Objects software application and day-to-day management of assigned project plans, schedules and test requirements as it relates to Business Objects and/or user reporting needs.
• Created technical specifications and design document as per the technical and business requirements.
• Setup the BOXI 4.0 clustered environment and migrated the projects from XI R2 to 4.0 using BIAR files and UMT and resolved the migration issues, trained the end user on BOXI 4.0.
• Converted the UNV to UNX format, adapted the new BI 4.0 UNX technics.
• Created a New universe using the Information design tool (IDT).
• Implemented Business objects designer functionalities like Aggregate awareness, Row level securities, custom hierarchies, cascading prompts, contexts, etc...
• Designed the Webi standard reports and scheduled them periodically.
• Implemented the Hyperlink codes between summary and detail reports in Webi and crystal reports.
• Created Crystal Reports using Crystal reports Formulas, Grouping, hyperlink, Parameters and Static/Dynamic Cascading Prompts to handle the customer’s requests from Tables, Stored Procedures, and Views.
• Support the business users on the reporting needs based on the priority tickets.
• Developed Tableau dashboards by using Oracle, Vertica database and Excel as data sources.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic
• Worked with UAT team and Business users to get the sign off on the project releases in different phases and deployed the development in to the STG and PROD environments with the BIAR files.
• Worked with ETL (Informatica) and Data model team to resolve the data discrepancy issues.
• Trained the end users on using the standard reports from BI Launchpad, scheduling the reports and Tableau Dashboards.
• Documented each release to tack the implementations done and documented the entire project and migration effort.

Environment: Business Objects 4.0 /XIR2, Universe design tools ( UDT\IDT), Crystal Reports XIR2, BO Dashboards 4.0,Tableau,Oracle 10g, Informatica 9,Vertica Database and ALM.

Confidential, VA

Senior Report Developer

Responsibilities:

• Involved in requirement gathering and data analysis for reporting from various business users.
• Designed universe for standard reporting and ad hoc reporting requirements for call center DataMart and Marketing system.
• Participate in Agile Scrum model software development life cycle.
• Implemented aggregate awareness and created Derived tables at the Universe level to increase the performance of the reports.
• Implemented row level security in Universe according to the business needs.
• Extensive reporting was done using Business Objects functionality's like Drill Down, Cross Tab, Master Detail.
• Created different reports in the Genesys environment using CMS Avaya reporting tool.
• Involved in performing Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
• Created Indexes and materialized views for the better performance of the reports.
• Trained Power users/End users to use the tool and create Ad-hoc business objects reports.
• Involved in documenting the Requirements Specifications, Design Document, Project Unit testing documents, and System testing documents.

Environment: Business Objects XI 3.1/XIR2, Crystal Reports XIR2, Live Office, Xcelsius 2008, Oracle 10g, Informatica 9,Clear Quest, Genesis, CMS Avaya.

Confidential, Charlotte, NC

Business Objects Developer

Responsibilities:

• Assisted Business Analysts, Operation Analysts, Project Managers on different financial models and various spreadsheets.
• Performed the system analysis role and gather the requirements, well documented the analysis for the development process.
• Designed Universe for standard reporting and ad-hoc reporting requirements.
• Resolved loops by creating Aliases & Contexts and checked integrity of universes.
• Created derived tables at the Universe level and implemented the security based on user’s Profile.
• Extensive reporting was done using Business Objects functionality's like Drill Down, Cross Tab, Master Detail, Alerters, Variables etc...
• Migrated the release codes from one environment to other using Import Wizard.
• Interacted with Informatica Developers understanding the Data load process to resolve data quality issues.
• Write test-case scenarios, develop test plans and conduct user acceptance testing & training.
• Provided end user training for basic and advanced reporting skills like how to use templates and explained the hierarchy levels and incompatibility between the objects to make sure users can build their own reports
• Responsible for production support services and project development and implementations relative to Business Objects application.

Environment: Business Objects XIR2,WEBI, Deski, Crystal reports4.0/ XI r2, Import Wizard, Oracle10g, TOAD, Informatica 8.1.