SUMMARY:

• Over 9 years of extensive IT industry experience in creating and implementing effective strategies/solutions for developing Business Intelligence/Data Warehousing (BI/DW), Client/Server applications, aspects of Database Management Systems, development and complete Project Life Cycle in Data Warehousing.
• Expert in dashboards and visualizations using Xcelsius 2008, SAP Dashboards and Tableau 8.0
• Strong experience in Core SAP Business Objects 4.x/5.x/ 6.0/6.1/6.5.1/ XI R2/XI R3/4.0 with Web Intelligence 2.6/2.7/6.5/XI,4.0, Crystal Reports XI.
• Highly experienced in the Business Objects XI R2/ XI R3/4.0 suite including Central Management Server (CMS), Central Management Console (CMC), Designer, Web Intelligence and migration from previous versions.
• Sound Knowledge and experience in ETL data management tools like Data Integrator XI R2, Informatica 5.1/6.1/7.1/8.0
• Expertise in creating and fine - tuning Complex and Adhoc Reports.
• Experienced in Data modeling for logical and physical databases including designing OLTP and OLAP databases.
• Proficiency in SQL and PL/SQL programming to develop Stored Procedures/Functions in Oracle, Teradata and SQL Server.
• Good analytical strengths, successfully working through problems and implementing solutions in time.

TECHNICAL SKILLS:

ETL Tools: Data Integrator XI R2, Informatica 7.x/6.x/5.x, PowerCenter, PowerMart

OLAP Tools: SAP Business Objects 4.0/XI R3.1/XI R2/ 6.X/ 5.X (CMC/Supervisor, Designer, InfoView, Web-Intelligence, Scheduler/Broadcast Agent Server), Performance Management (Dashboard Manager, scorecards), Crystal Reports XI, Xcelsius 2008, QAAWS, Live Office.

RDBMS: Oracle 10g/9i/8x, MS SQL Server 2000/6.5, Teradata, DB2, MS Access

Oracle Tools/Utilities: Toad, SQL plus, SQL Developer, SQL Loader, IMPORT, EXPORT, Oracle Enterprise Manager, DBA Studio, Net8, FLEXCUBE

Data Modeling Tools: ERWin 4.0

Data Visualization Tools: Xcelsius 2008, Tableau 8.0

GUI: Visual Basic 6.0/ 5.0

Languages: SQL, PLSQL, Java 2.0, C++, C

Web Technologies: Servlets, JSP, ASP3.0, HTML, XML, JavaScript, VBScript

Operating Systems: Win 2008/NT/XP/2K/98/95, W2K Adv Server, SCO/HP Unix, NetWare 4.11

Hardware: IBM Compatible PCs/Servers like Compaq Proliant 7000 Series, HP9000 series JFDISOFIDS

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

Sr. Tableau Architect/Developer

Responsibilities:

• Responsible for Tableau Environment, Security, Architecture setup.
• Interacted with business users in gathering, analyzing and documenting the business requirements and translate them into technical specifications.
• Involved in Tableau Server Installation and Configuration, creating users, groups, and projects and assigning access levels.
• Worked on Proof of Concepts to decide Tableau as Confidential BI strategy for enterprise reporting.
• Created technical specification documents related to Tableau design and architecture.
• Created several Tableau data extracts with prebuilt calculations, parameters and sets to enable end users to easily utilize the extracts as semantic layer to create their own workbooks.
• Created various highly interactive dashboards and data visualizations reports for Ad Sales and Program Finance departments.
• Developed multiple reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
• Created Server Monitoring workbook views and Confidential custom workbook to see ‘My activity’ on Tableau Server using Tableau Server Repository Database (Postgresql).
• Actively involved in creating Confidential custom portal design hosting Tableau workbooks using JavaScript API.
• Created responsive workbooks for Ipad /PC orientation views.
• Worked with end users in creating complex dashboards in an iterative process.
• Created several automated scripts to backup, restore and auto sync Windows AD users.
• Extensively used tabcmd and tabadmin for various Tableau server maintenance activities.
• Performed tuning of tableau workbooks and extracts to make them functional with large sets of data.
• Conducted training sessions for Tableau Power users to use it as Confidential Self-service BI tool.
• Managed and coordinated with offshore team on deliverables.

Environment: Tableau 8.2/8.3, Server and Desktop, Postgresql, SQL Server 2012, Oracle 11g, SQL/PLSQL, Windows Server 2012, VISIO.

Confidential, Richmond, VA

Senior Business Objects/Tableau Developer

Responsibilities:

• Good understanding of the customer business and implementing the same over to the reporting needs.
• Involved in report and dashboard requirement gathering from the end users to define accurate requirements.
• Created complex Webi reports with multiple queries, custom sql, complex functions, merge dimensions, drill down/up/across/through, complex filters etc.
• Implemented new universes using IDT and modified existing ones according to requirements and performed cadinality checks, resolving traps, using contexts, aggregate awareness, hierarchies and derived tables.
• Performed report/universe optimizations in greatly reducing the run time of reports.
• Performed Admin tasks such as monitoring DB services, BO Server running with optimal performance, monitoring licenses, monitoring user activity/sessions, consulting SAP to define bugs in patches etc.
• Migrated reports/universes from Dev to Qa to Prod using import wizard.
• Created Dashboards and visualizations using Tableau for several teams and delivered demo sessions to expand the tools reach in the IT environment.
• Created users, users groups and maintained user access rights in Tableau.
• Created Architecture Design documents and Technical Specifications Documents.
• Connected Tableau to various databases and performed Live data connections, query auto updates on data refresh etc.
• Implemented Tableau Mobile across several lines of businesses.
• Implemented Tableau BI application creation, Tableau Administration, Installs and Server side functionalities
• Provided technical support to all team members during project execution
• Performed reports/dashboards performance optimization
• Involved in User Training of Tableau dashboards.
• Created intuitive ways in Dashboards to implement multi-level drill through's, Ranking, Dual Axis, Geo Coded Mapped views, Histograms etc.
• Helped in testing and impact assessment on dashboards with changes to the data warehouse.
• Created test documents that help in validating reports and dashboards in QA.
• Utilized Knowledge Link of Confidential to create and update logs for project maintenance.

Environment: SAP Business Objects BI 4.0 (CMC, Information Design Tool (IDT), Web I), Tableau 7.0/8.1 Server and Desktop, Oracle 10g and 11g, SQL Server 2012, Teradata, SQL/PLSQL, Windows Server/professional, VISIO.

Confidential, Arlington, VA

BI Architect

Responsibilities:

• Successfully completed testing and migration of Business Objects from XIR2 to XIR3.1 and XIR3.1 to 4.0 in DEV and PROD environments.
• Implemented custom Infoview portal pages in development and production to enhance and improve splash screen view of the Infoview portal.
• Created new Xcelsius Dashboards for FSA using the congressional district and state data from Satori.
• Maintained and delivered several weekly dashboards to FSA as part of the maintenance plan.
• Created and maintained Universes, Web intelligence and Rich Client reports.
• Aided our teams by greatly reducing the manual process of creating reports in excel for each site location and aggregating them.
• Created Dashboards and visualizations using Tableau for several teams and delivered demo sessions to expand the tools reach in the IT environment.
• Created users, users groups and maintained user access rights for Business Objects universes and reports using Central Management Console.
• Fixed problems with DEV servers for problems with scheduling and routine maintenance.
• Analyzed and improved performance of several ad-hoc reports (bug fixing) using Oracle SQL/PLSQL in SQL Developer.
• Created several pilot dashboards for user sampling. Created intuitive ways in Dashboards to implement multi-level drill through's, Ranking etc that were not offered from the core software package.
• Helped in testing, impact assessment and implementation of several patches and packages for BOXI Enterprise R3 and 4.0., Live Office and Xcelsius releases which occur every few months.
• Trained users and demoed the Front End Business Integration BI Architecture, Business Intelligence Enterprise Platform and Infoview portals.
• Created test documents that help in validating reports and dashboards in QA.
• Created or modified Detail Design and HLD documents for Universe and Reporting changes during maintenance.
• Created and maintained several FS, Design documents and Code related to reports, universes and dashboards in Version Manager.
• Utilized Team Track to create and update logs for project maintenance.
• Implementation of Wid-Scanner database in XIR2 Sandbox, its universe and reports to analyze impact assessment for migration to XIR3.1.
• Integrate Microsoft SharePoint Web Parts with Business Objects to display dashboards on SharePoint.
• Conversion of Deski reports to Webi reports.
• Automation of Xcelsius Dashboards and Scorecards using Live Office.
• Adding third party Xcomponents to the already existing components in Xcelsius 2008 to utilize more features.
• Identification and testing of other Dashboarding tools such as Tableau.
• Created and Maintained dashboards for Consumer Financial Protection Bureau (CFPB).

Environment: SAP Business Objects XI R3/ SAP BI 4.0 (CMC, Designer, Web I, Deski), Informatica 7.x, Crystal Reports XI, Xcelsius 2008/ Dashboards, Tableau 7.0 and 8.0, Oracle 10g and 11g, MS Project, TOAD, FLEXCUBE, PL/SQL, Windows 2000 Server/professional, Tomcat 4.0, Apache Server 1.3.

Confidential, Baltimore, MD

Sr. Business Intelligence Developer / Business Analyst

Responsibilities:

• Set up business user meetings to define, design and document the reports as per user expectations. Specs have been designed based on business needs.
• Responsible to manage and assign work load to offshore team of BO developers.
• MAXIMO interface functional experience in inventory, supply chain and work management.
• Created users, users groups and maintained user access rights for Business Objects universes and reports using Central Management Console.
• Designed an archived universe from scratch which was extracting pieces of data from different archived data stores.
• Modified and updated current universes working on the OLTP data architecture for various business changes using Designer.
• Created several Business Objects reports and scheduled them via Infoview.
• Worked on various reports crucial to supply chain such as Item master, Inventory Item, Item reconciliation, Purchase Orders, Purchase requisitions etc.
• Worked on work management reports such as Work order, Actual dose projection, Work week man hours reports etc.
• Used Oracle warehouse builder tool to enact some ETL processes required as per data architecture and mappings.
• Created hierarchies, prompts, aggregate awareness, solved for loops and checked for integrity of the universe in Designer.
• Created queries to extract data from database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
• Tested reports for query optimization and performance before posting them to the repository.
• Cleared for defects in the reports and monitored them using HP Quality Center.
• Utilized Crystal XI to develop few reports based on functional user requirement using the same universe in the BO repository.
• Used SQL Developer to analyze SQL/ PLSQL queries to make fixes in the reports.
• Used Performance Management to create dashboards and scorecards.
• Trained the users to use reporting interface in Infoview and to create ad-hoc reports based on their needs.

Environment: Business Objects XI R2 (CMC, Designer, Web Intelligence), Crystal Reports XI, Oracle 9i and 10g, SQL Developer, TOAD, MAXIMO, HP quality center, Oracle Warehouse Builder, PL/SQL and MS Excel, Outlook, Windows XP, Windows 2000 Server/professional, Tomcat 4.0, Apache Server 1.3, Microsoft Communicator.

Confidential, NYC, NY

Sr. Business Objects Developer/ Business Analyst

Responsibilities:

• Responsible for the System Study, SDLC, Zero level and 1st level estimations for projects, Business Requirements Analysis & Documentation.
• Worked as Confidential liaison between the business and the IT department in getting the requirements and/or altercations in design and development of reports.
• Created users, users groups and maintained user access rights for Business Objects universes and reports using CMC.
• Created Universes and maintained them using Business Objects Designer.
• Followed and checked for best practices at the enterprise level for the design of universes and reports.
• Modified the existing Universes by merging different Classes and resolving the Loops and Chasm Traps by contexts.
• Created hierarchies to facilitate Drilling in the reports and checked for integrity of the universes.
• Developed and fixed many issues in complex reports using free hand SQL in BO Deski.
• Creating various UDF’s in the database for data retrieval in complex reports.
• Worked on various corporate banking reports such as LD, Customer detail, Account transactions etc.
• Created reports using Business Objects functionalities like Slice and Dice, Drill up/down, @Functions, Cross Tab, Master/Detail, Formulae etc.
• Developed few reports based on Crystal XI.
• Worked on Dashboard and analytics using Dashboard Manager to develop business driven solutions which drive the decision processes in various departments of the bank.
• Extensively performed QA on the reports before migrating them from DEV to Production.
• Supported the requirements from Lloyds Corporate Bank in NYC and Lloyds International Private Banking in Miami to fix any ad-hoc issues throughout the project.
• Mentored the business of the functionalities in Business Objects and instructed them to apply those features to ad-hoc reports.
• Worked with the managers in preparing the documentation for the next phases of the project, its scope and its goals. Used MS Project in this process.

Environment: Business Objects XI R2 (CMC, Designer, Web I, Deski), Crystal Reports XI, Oracle 9i and 10g, MS Project, TOAD, FLEXCUBE, ALLOY 5.0, PL/SQL and Excel, Outlook, Windows XP, Windows 2000 Server/professional, Tomcat 4.0, Apache Server 1.3.

Confidential, Lyndhurst, NJ

Business Intelligence Developer / Business Analyst

Responsibilities:

• Interacted with users as part of Business Analysis to collect requirements, analyze and transform them into technical specifications via documentation.
• Defined data model requirements to meet reporting, analysis & specific Business Intelligence needs.
• Created users, users groups and maintained user access rights for Business Objects universes and reports.
• Involved in creating data models and building data marts. Used business objects data integrator tool to load tables and run the batch process.
• Various kinds of the transformations were used to implement simple and complex business logic to load the tables in staging area using data integrator.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Designed, developed, implemented and maintained two Universes from scratch using Business Objects Designer utilized to develop canned and ad-hoc reports.
• Developed those complex universes by using advanced features in Business Objects like Aggregate Awareness and prompts.
• Resolved loops using Aliases and Contexts in universes. Defined and created hierarchies; checked for integrity of the universe; created new objects for business needs using @ functions.
• Generated various complex confidential and non-confidential HR reports as per the Business oriented technical requirements.
• Created reports using Business Objects functionalities like Slice and Dice, Drill up/down, @Functions, Cross Tab, Master/Detail, Formulas etc. Generated pictorial views in the form of 2D, 3D & Pie Charts from existing Reports and Chart Wizard etc.
• Extensively performed UAT on reports before migrating them from DEV to Production.
• Implemented and given Confidential one week training session to train Power Users/Managers to functionally use the current reports in Web Intelligence.
• Provided on-going production support for Business Objects End Users in the final stages of the project.

Environment: Business Objects XI R2 (CMC, Designer, Web I), Business Objects 6.5, Crystal Reports XI R2, Data Integrator XI R2, Oracle 9i and 10g, MS Access 2000, MS Project, PL/SQL and Excel, LOTUS Notes, Windows XP, Windows 2000 Server/professional, Tomcat 4.0, Apache Server 1.3,Unix, Sun Solaris.