SUMMARY:

• Business Intelligence/ Informatica/BO production support specialist with over ten (10) years of experience using business intelligence tools/Business Objects (BOBJ) tools in various versions, including BI4 (BOBJ 4) BO XI 3.1/R2/R1/6.5.1/5.1, and SAP BW in Windows and UNIX environments
• Experience in analysis, design and development of various data warehousing projects using SAP Business Objects Data Services 4.0/XI3.2/3.1 and Data Integrator XIR2/11.7/11.5
• Extensive experience with Tableau Business Intelligence/Business Analytics software. In - depth knowledge of Tableau Desktop, Tableau Reader and Tableau Server, and Tableau Online
• In depth knowledge of Tableau advanced analysis features like actions, calculations, forecasting, parameters and trend lines
• Created complex Jobs, Work Flows, Data Flows and scripts using various Transforms (Integrator, Quality and Platform) to successfully load the data from multiple sources into a desired target
• Proficiency in data warehousing techniques for Slowly Changing Dimensions, surrogate key assignment and change data capture
• Used Data Services management console to schedule and execute jobs, manage repositories and perform metadata reporting
• Experienced in developing complex reports using business objects Webi Rich Client and Crystal reports enterprise with parameter/formula fields and selection formulas, grouping and sub reports
• Proficient in designing and building universes by selecting and Joining Tables, setting cardinalities and resolving loops by using aliases and contexts and checking the integrity of the universes
• Extensive experience in Oracle development using dynamic SQL, PL/SQL, Views, Indexes, Triggers, Stored Procedures and Nested Tables
• Managed repositories, connections, created and managed users/groups, assigned resources to the users and importing/exporting users

TECHNICAL SKILLS:

Business Intelligence: Business Objects 4.1/4.0/3.1/3.0/ XI R1/R2/6.5.1/6.1b/5.0x, Central Management Console, Tableau 10.2/9.2/8.2 , Central Configuration Manager, Platform InfoView, Web/Desktop/OLAP Intelligence, SDK, Data Integrator, Set Analysis, Designer, Supervisor, Administrator, Application Foundation, Enterprise Performance/Information Manager, Dashboard Manager

ETL Tools: SAP BO Data Services 4.0/XI3.2/3.1/3.0 (Designer, Data Services Repository Manager, Data Services Server Manager, Management Console), SAP BO Data Integrator XIR2/11.7/11.5, Informatica Power Center 9.5/9.1/8.6/8.5 , Informatica Data Quality

Reporting & Analysis Tools: Crystal Reports XI/10/9/8/7/6, Crystal Enterprise XI/10/9/8, Crystal Reports 2008, Business Objects XI, Crystal Management Console, Crystal Migration Wizard, Crystal Import Wizard, BO Web intelligence, BO Dashboard Builder, Xcelsius 2008

RDBMS: Oracle 11g/10g/9i/8i, MS Access 2003, SQL Server 2000/2005

Data Modeling Tools: Erwin r7.1/7.2, ER Studio V8.0.1 and Oracle Designer

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

Programming Languages: SQL, PL/SQL, T: SQL, C, C++, .Net, HTML, XML

Application Server: Tomcat 4.1

GUI: Visual Basic 6.0, Visual C ++ 6.0

Operating Systems: WINDOWS XP/NT/00/98/95, UNIX

Web Server: Apache 2.0, IIS 6.0

Others: TOAD, SOAP, SQL NavigatorTeradata SQL Assistant, SQL Loader

EXPERIENCE:

BI Developer (Tableau/BO)

Confidential, Austin, TX

Responsibilities:

• Interacted with project managers, business analysts and team members to analyze business requirements and outline the proposed solution
• Interacted with users to analyze their views while gathering the report requirements and provided Several Report Mock-ups to finalize the requirements
• Converted business requirements in to business/technical requirement documents
• Developed Tableau visualizations and dashboards using Tableau Desktop
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Created Business Objects technical design specifications for universes and reports, developed universes and reports, and performed testing
• Maintained written documentation of programs and databases
• Modified database programs to increase processing performance, referred to as performance tuning
• Performed logical database activities such as table design, creating/modifying stored procedures and triggers
• Reported activity status to the Project Manager and/or Technical Manager
• Participating in daily Scrum meetings and weekly Sprint meetings
• Created Data Mapping Documents by working closely with ETL and database developers
• Designed and built Universes for new components
• Created Universe, Classes, Measure Objects, Dimension Objects, and Detail Objects and applied Hierarchies based on Business logic
• Used various techniques like Sectioning, Ranking, Filtering, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc. to develop the reports
• Created Web Intelligence reports with multiple data providers and synchronized the data using the merge dimensions option
• Created Reports with graphical representation such as Bar charts, Pie charts for multidimensional analysis
• Implemented security features of Business Objects like row level, object level and report level to make the data secure
• Involved in production Support and gave training to the users

Environment: Business Objects 4.1 SP6, Business Objects Data Services 4.0 SP1, Tableau Desktop 9.2, Tableau Server 9.2, SQL Server 2012, and Oracle 12c

Tableau/Business Objects Developer

Confidential, Johnston, IA

Responsibilities:

• Upgraded the existing system to support new enhancements and additional business volume. Completed the first level upgrade of system to support immediate needs. Planned additional upgrades to support the reporting capabilities on mobile devices and iPads
• Created adhoc reports for users in Tableau by connecting various data sources
• Generated Tableau dashboards for sales with forecasts and reference lines and a combination of charts
• Responsible for developing new reporting applications and enhancements of the existing applications. These applications were built using SAP Business Objects, Business Objects Data Services and Tableau
• Provided input for upcoming conversion projects. Confidential of Iowa developed their own system so they could convert all data from the existing application to the new system for supporting new reporting requirements
• Responsible for migrating data from the old system to the new system using Business Objects Data Services
• Developed Tableau visualizations and dashboards using Tableau Desktop
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Responsible for effective communication between the technical and business teams to preserve data security
• Created SAP Data Services mappings to load the data warehouse
• Used simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, Lookup etc. in data flows
• Data analysis for reports which includes data cleansing and data transformation etc.
• Developed the universe to provide adhoc capabilities to the users. This would help the business users in building their own reports making faster decisions
• As a Business Objects Administrator, I was responsible for different administrative activities like managing user accounts, managing user groups and managing Business Objects jobs etc.

Environment: Tableau Desktop 9.2, Tableau Server 9.2, Business Objects 4.1 SP6, Business Objects Data Services 4.0 SP1, SQL Server 2012, and Oracle 12c

Business Intelligence/BO Developer

Confidential, Des Moines, IA

Responsibilities:

• Installed and configured BODS XI 4.0 SP1 in development and on the production server
• Configured and managed repositories using the administrator console as per the business requirements
• Used various Transforms like Map Operation, Table Comparisons, Row-Generation, Query History Generation, Key Generation, Pivot, Reverse Pivot and functions like Lookup and Index search for transforming data
• Configured the mappings to handle updates to preserve the existing records using History Preserve Transformation and (Slowly Changing Dimensions Type-2)
• Created the Universe requirement documents to document the business elements that had to be added to the universe
• Created a data foundation layer based on the servicing data using information design tool in BO 4.1 SP5
• Created many business layers based on the data foundation to meet the user requirements
• Used the shared projects concept to save the data foundation and business layers which could be used by other developers to modify using the latest copy
• Developed reports and dashboards in Tableau
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Mastered the ability to design and deploy rich graphic visualizations with Drill Down and Drop down menu options, Parameterized using Tableau
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to the deliverable specifications
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau Desktop and published them to the server
• Experience in Tableau report developing, testing and deployed report solutions using Tableau Server
• Defined row level security at universe levels as per the user entitlements, enabling IT to create one report and make it available to global users based on their rights
• Created new and modified existing Hierarchies in the universes to meet Drill analysis of the user’s reporting needs
• Involved in performance tuning and optimization of Business Objects universes by creating Aggregate Tables

Environment: Business Objects Data Services 4.1, Business Objects 4.1 SP5, Tableau 9.2, Teradata 14, Teradata SQL Assistant 14.01, Oracle 11g