PROFESSIONAL SUMMARY:

• Over 13 years of experience in IT with solid experience designing and creating data visualizations using Tableau.
• Worked on (Tableau 10.5/10.4/10.3/10.2/10.1/10.0/9.3/9.2/9.1/8.0/7.0 ), Tableau server, Tableau online, Tableau public, Tableau reader.
• Experienced in Analysis, Development, Design and Maintenance of Business Intelligence applications, creating dashboards, designing Universes, Full Client/Web reports etc.
• Used Tableau Cmd for various Dashboard migrations from one environment to another.
• Used efficient load balancing techniques to manage the load on the server for concurrent user logins.
• Created automated scripts for tableau workbook refresh when not using live connections
• Experience with Tableau maintenance tools and Tableau server monitor to start/stop services and maintain statuses.
• Worked as a Tableau Developer. Created visualizations and dashboards as per the user requirements.
• Worked in data preparation, data transformation and reports.
• Good understanding of Business Intelligence concepts. Worked with Dimensions and Fact tables.
• Extensive experience and expertise in creating and analyzing data using MS Excel pivot tables and charts.
• Strong Understanding on the phases of Software Development Life Cycle (SDLC) and models including Waterfall and Agile.

TECHNICAL SKILLS:

Solution tools: Tableau, Business Objects XIR3/XIR2/XIR1/,BI 4.2/4.0, Xcelcius 2008, Dashboard Manager, Designer, Supervisor, Desktop Intelligence, Web - Intelligence, Info View, Broadcast Agent, CMC Performance Management, Report Conversion tool and Import Wizard, Life Cycle Management.

ETL Tools: Data Integrator 11.7,Informatica Power Center 9.0 (Designer, Workflow Manager, Workflow Monitor)

RDBMS / Database: Oracle 11G/10G/9i/8i/7.x,DB2 v8.1, MS SQL Server 8.0, MS Access

Data Modeling Tools: Erwin 4.1, Microsoft Visio

Development Tools: Toad, SQL Navigator, Rapid SQL, Enterprise ManagerMS Excel, MS Visual Studio, Microsoft Project Professional

Languages/ Scripting: SQL, PL/SQL, C++

Operating Systems: Windows XP/2000/98/95/NT, MS-DOS, Linux, UNIX Sun Solaris

Others: Credit Loss Management (CLM), Concurrent Versioning System (CVS), MVS (Multiple Virtual Storage), JCL (Job Control Language)

WORK EXPERIENCE:

Confidential, Lansing, MI

Sr. Tableau developer

Responsibilities:

• Worked as a dashboard developer for the Pharmaceutical Company. The project involved creating multiple dashboards, conversion from IBM Cognos reports to Tableau dashboards and enhancements.
• Worked on the dashboards to Track the Number of Calls made to the prescriber, financial dashboards, resource allocation on various products.
• Worked on analyzing the requirements and the source data. Worked on a mapping document to map the required columns from the data sources.
• Worked with excel and CSV files. Created extract files and live data. Worked on data preparation. Published the data source to the server for the power user.
• Created Maps to provide the count of providers in different geographic locations. Created drill down capability using the Action filters.
• Created parameters to make the dashboards HIPPA compliant. Created different visualizations, such as bar chart, heat maps, combo charts and so on.
• Deployed dashboards on the server.
• Involved in Tableau upgrade from 9.2 to 10.1

Environment: Tableau desktop 9/10.1, Tableau server, Tableau Reader, TDE, MS excel

Tableau developer

Confidential, Bellevue, WA

Responsibilities:

• As part of the Business Intelligence (BI) team involved in requirement gathering discussions with the business community. Analyzed data to be presented in the dashboards. Helped users in data preparation.
• Worked on report and dashboard mock-ups. Provided demo to the users on the various functionalities of Tableau.
• Coordinated with the Business Analyst, and Project Manager to get the requirements and deliverables.
• Created multiple dashboards, such as financial dashboard, Travel intensity and so on. The dashboards tracked the Actuals and Budgeted amounts for the enterprise. It also tracked the frequent travelers by month and region. Created multiple worksheets and dashboards.
• Extracted data from xls, CSV and database tables. Used data as live and extract. Created data source level filters. Performed data transformation in the data layer. Created hierarchy, groups and calculations.
• Created different visualizations like trend charts, Maps, bar chart,s etc. Created data stories for ease of navigation.
• Created user filters and action filters. Created parameters and used them in the calculations.
• Worked with excel and database queries to test the dashboard.
• Also involved in helping users in creating and executing test cases. Supported the UAT effort. Provided guidance, reviews, updates and defect status.
• Worked in data analysis. Used excel and database tables.
• Deployed Dashboards and sheets on the Tableau server. Provided security to different dashboards.
• Environment: Tableau desktop 9.x, Tableau server, Tableau Reader, TDE, SQL Server 2005 management studio, MS excel

Confidential, Lansing, MI

Sr. SAP Business Objects Consultant/Lead

Responsibilities:

• Designed and implemented Business Objects architecture, including hardware and software requirements, CMS information, security, and migration from XIR2 to XIR3.1
• Setup and initial configuration of XI R3 on Windows platform using Oracle11g as the repository database.
• Used the import wizard to import existing user accounts, groups, categories, Webi documents, universes, connections and universe restrictions to BOXI R3 environment.
• Involved in Conversion of Deski reports to Webi reports using Report Conversion Tool.
• Performed Administrative tasks like Setting up user profiles, assigning rights and privileges for groups, setting up categories using CMC, and maintain Bo servers
• Built a new security model with the BOE environment to support the Accident Fund real-time and historical dashboards.
• Modified existing client analyst universes and creating new universes as per the business requirements using @Aggregate Awareness, @prompt, and @BOUSER functions
• Developed real time and historical dashboards within Xcelsius 2008 utilizing Query As A Web Service and Live Office.
• Scheduling of the report on a successful event and save on specific servers using FTP/File System Configuration in Business Objects XI 3.1.
• Promotion of Universes, Reports, Users, Groups, User Rights and Privileges from different environments Dev, QA, UAT and Production.
• Created Standard WebI reports with client customizations and formatting to serve as templates for the canned and ad hoc reporting.
• Documented all the changes made to the Universes and Reports for future s.

Environment: Business Objects XI 3.1/R2,SQL, Oracle 11g, Sybase, Web Intelligence, Crystal Reports, Import Wizard, Xcelcius 2008, QAaWS, Live Office, Web services, Apache Tomcat, SQL Developer, Windows 2008, Weblogic 5.1/6.1, Shell scripting

Confidential, Herndon, VA

Sr. SAP Business Objects Administrator/Developer

Responsibilities:

• Responsible for Administration, development and troubleshooting of different agency reports through Business Objects XI R2/3.1 and development of dashboards through Crystal Xcelcius.
• Migrated Business Objects XI R2 content in to Business Objects XI R3 environment using the Import Wizard.
• Managed all the BO Servers and Clusters through CCM and CMC.
• Installed & Configured BO Enterprise XI R2 SP2 on Windows 2003 server.
• Resolved slow down issues and improved the performance of production servers.
• Responsible for the administration of transactional and analytical data constructs/structures.
• Integrated Business Objects reports into corporate portal using java SDK.
• Configured .war files on BOXI server to receive authentication.
• Responsible for the design and development of Business Objects Crystal Reports & Business views, Universes and analytical data constructs/structures.
• Created access Restrictions to secure data based on users’ access levels.
• Prepared Business/Technical Requirements, Design Templates, Development Standards document and Detailed Design documents.
• Used SAP BEX Query Designer to make modify queries: Restricted Key Figures, Calculated Key Figures
• Created various Reports by pulling the OLAP data from Data Warehouse of SAP BI 7.0
• Modified the BEX Query using Query Designer to suite the reporting requirements.
• Designed and developed Universes and reports according to the user requirements.
• Created hyperlink reports using open doc functionality.
• Migration of Canned Reports/Universe/Personal Documents/Inbox.
• Created Analytics and Dashboards using Performance Management tools to enable executives get a bird’s eye view of the business performance.
• Accessing data from the database using SQL Developer (running on Oracle 10g) to cross check the data accuracy and creating reports on the same if needed by the business.
• Implemented and conducted session to train Power Users/Managers in BO functionality and to use the reports in Web Intelligence.
• Documented all the changes made to the Universes and Reports for future s.

Environment: Business Objects XI 3.1/R2/6.5, Crystal Reports XI, SQL, Oracle 9i/10G, Sybase, Windows 2003 Server, Web Intelligence, Xcelcius, SAP BI 7.0, SAP BEX Query Designer, SAP BEX Report Designer, CVS, Apache Tomcat, SQL Developer, Sun Solaris (UNIX), Weblogic 5.1/6.1, Shell scripting, Clear Quest.