SUMMARY:

• Over 6 years of experience in Analysis, Design, development and implementation of Business Intelligence Applications using Business Objects Analytical tools (6.5/XIR2/R3/R3.1/4.0/4.2).
• Strong IT experience in Data warehousing, Data architecture, Data modeling, Decision Support Systems, using MicroStrategy Platform,Business Objects, Universe Designer, Tableau, Informatica, SQL Server, SQL Developer for over 6 years.
• Experienced in Designing/Developing BO Universes, Canned/Ad - hoc Reports, Scheduling the BO processes
• Extensive Tableau Experience in Enterprise Environment and Tableau Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Extensive experience in dealing with a variety of Relational Databases like Teradata, Oracle, and SQL server.
• End to end experience in designing and deploying data visualizations with full range of BI Skills with Tableau 7x,8x,9x, 10x using Tableau Desktop, Tableau Viewer and Tableau Server.
• Expertise in Tableau BI reporting tools & Tableau Dashboards Developments & Server Administration.
• Hands on experience and conceptually sound in the creation and application of Data Warehouses, Datamarts, Star and Snow flake Schema modeling, Physical and Logical data modeling, creation of Fact and Dimension tables, Extraction Transformation and Loading (ETL) processes and other OLTP and OLAP related tasks.
• Automated Data load from MS Sql Server to Teradata usimg import wizard and Informatica.
• Started a project based on users requirement with secure file transfer protocol weekly (FileZilla - SFTP-client for Windows) into Teradata Studio landing and Staging with Informatica with Indirect Load.
• Experienced in Full Life Cycle (SDLC) development of software applications. Good knowledge of understanding business logic and converting functional requirements to technical requirements. Thorough knowledge of multiple RDBMS & ODBC concepts
• Extensively worked in creating and integrating Business Objects reports (Interactive reports, Dashboards, Data Marts) and objects (Attributes, Filters, Metrics, Facts, Prompts and Hierarchies) with the Datawarehouse.
• Expertise creating complex Reports in MicroStrategy Desktop using features like Templates, Custom groups and Consolidations.
• Strong experience in: SAP Crystal Dashboard Design (Xcelsius) to create interactive dashboards by using QaaWS and Live Office.
• Excellent communication and interpersonal skills with ability to work independently and good team player.

TECHNICAL SKILLS:

BI Tools: Business Objects  4.0,XI3.1-R2/6X, Reporter, Universe Designer, WEBI, Crystal Xcelsius, BW, MicroStrategy Desktop 8.x, MicroStrategy Architect, Administrator, Report Srvices, Command Manager, Object manager,, Import Wizard, Tableau Desktop 7, 8,8.2,9,9.1

RDBMS: Oracle 8i/9i/10g/11g, MS Access, MS SQL Server 2005/2000/2008 R2, Teradata 14/13/12/V2R6

Languages: SQL, MS SQL. PL/SQL, VB, HTML, XML.

ETL: Informatica 10x/ 9x/8x/ Designer,PowerCenter Workflow Manager and Workflow Monitor,SQL Loader, DataStage, Talend, Alteryx

Operating Systems: Windows XP/2000/98/NT, UNIX

Other Tools & S/w: TOAD, MS Project, WinSCP, Putty

PROFESSIONAL EXPERIENCE:

Confidential, Livonia, MI

Tableau Software Developer

Responsibilities:

• Over 4 years of extensive Tableau Experience in Enterprise Environment, in Tableau 7x,8.x,9.x and 10.x as a Developer and Analyst.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Primary Person responsible for Tableau Connection for Creating ODBC and Variables to your local, installing Drivers, Connection Properties,etc. to help connect Developers across Trinity to their corresponding Database.
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• Created Row Level Security using (users) function to grant them access to View/Compare Doctors within their R.H.M's.
• In-depth knowledge on Tableau Desktop, Tableau Public, Tableau Reader and Tableau Server.  
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Thru, Drill Down and Drop down menu option and Parameterized using Tableau.
• Productionionized and Supported Various Dashboards for Clients in IDW team and ERM.
• Preparing Dashboards using calculations, parameters, LOD's in Tableau
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau Desktop.
• Built dashboards with floating objects and capitalizing the various dashboard actions features like URL, images, web integrations, etc.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Developed various Metrics, Filters, Consolidations, Custom Groups and Prompts to give decision makers a handy tool to choose the criteria for reports and view information from different perspectives.
• End to end experience in Data Analysis, designing and deploying data visualizations using Tableau
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, SAP BW, MS Access and client/server applications.
• Created Row Level Security using (users) function to grant them access to View/Compare Doctors within their R.H.M's.
• If the User has R.H.M level Access as their rights in Database, the user can view all the physicians for their assigned R.H.M's in the Dashboard.
• Imported over 100 Million records(.csv flie) from Unix Server into Teradata manually using Informatica for Yearly Medicare Data.
• Exporetd Large Files from Queries (up to 30 Gigs) from MS Sql Server to Teradata using Fast Load process by using TPT Maintenance Store Procedure in Informatica.
• Created conversion, created Distinct Keys, look up functions for Data coming from (.csv and .txt) files in Expression transformation, Sequence generator transformation, etc. to exporting into Teradata.
• Navigated Multiple Dashboards using Action with Drilldown based on Hierarchy
• Formed Donut Chart Using Dual Axis to compare Current year to Prior Years Measures
• Converted Measures into Maps by using Latitude and Longitude for Region, RHM and Facility
• Operated and Created Dshboards such as Physician Metrics Dashboard, VBK, New Patient, Sepsis, Ortho, Heart Failure,etc. for different Clients.
• Used Container to Hide Multiple sheets in Dasboard using Radio Button using Parameters based upon users preference.
• Created Bubble Chart using Different Parameters and Hierarchy to switch sizes and Measures
• Embedded "No Tabs" in Tableau server through URL Parameters for Actions using Drill
• Configured data extraction by schedule, every business day at 6 am to enhance performance
• Produced Metrics for CMIO's condition into PMD (Physician Metric Dashboard) using ETL Processes such as Informatica PowerCenter Designer and PowerCenter Workflow Manager to Load Data.
• Involved in implementing optimization techniques to enhance the performance of queries dynamically generated by Business Objects by interacting with DBAs and designers.
• Added Sessions and Workflows to the existing Worklet for additional Data to be added to the Fact Table.
• Relegated the file of Tableau Version 9.1, 9.3 to 9.0 and 10.2, 10.3 to 10.0 by Hacking the code in HTML by saving the Tableau file in Notepad++ so the Developers can publish their Dashboards to the server.
• Experienced in tuning Long running SQL queries for better performance by Pivoting Tables.
• Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.

Environment: Business Objects 4.0, 4.2, Tableau Desktop 8x,9x,10x, Tableau Server, QlickView, Architect, Object Manager, Teradata, Informatica9x,10x, Windows XP, Oracle 10g,11g, SQL 2014 Management Studio, Teradata SQL Assistant, Teradata Studio.

Confidential, Pittsburgh, PA

ETL Developer

Responsibilities:

• Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 8.6 to extract the data from multiple source systems that comprise databases like Oracle 10g, SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.
• Generated reports from Excel to Business objects and vice versa.
• Create mappings using reusable components like worklets, mapplets using other reusable transformations.
• Assisted in building the ETL source to Target specification documents by understanding the business requirements
• Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings
• Generated reports from various data providers and tested data fetched in Business objects against open SQL result sets.
• Created reports in cross tab, master detail format and transformed them in 2-D,3- D column, line, area and pie charts for graphical analysis
• Responsible for scheduling and batch processing of Business objects and reports various formats PDF, rich text format (RTF) using the Business objects prower center .
• Formatted the reports as per the users requirements using all the facilities in Business objects like slice and dice, drill down, @functions and formulae to analyze the data.
• Generated the reports for the web users using the Web Intelligence Info View.
• Reports were created using the Business objects Power play Reporter modules Support.
• Tested the changed components under new environment.
• Handled ad-hoc user queries and providing status reports to management.

Environment: Informatica 6.0, BUSINESS OBJECTS, Crystal Reports, Oracle 9x, SQL Server and UNIX Shell Scripting.

Confidential, New York, NY

Business Objects Developer

Responsibilities:

• Created Cardinalities, Contexts, Joins, Aliases for resolving Loops and checked the Integrity of the Universes.
• Exported the Universes to the Repository to make resources available to the users.
• Created reports for various Portfolios using the Universes as the main Data Providers.
• Created Derived tables in the Universe in order to do complex calculation.
• Created Universes by retrieving the data from various data sources, defining the connections necessary.
• Designed and Developed WebI Reports using the features like Master/Detail, Charts, Cross Tabs, Slice and Dice, Drill Down, @Functions and Formulae to analyze the data.
• Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report
• Extensively Designed & Deployed System Reports, Custom Reports, User Report, Ad Hoc Queries by incorporating the functionalities of Sort and Drill Down.
• Developed and deployed complex Webi reports
• Used various Webi functions for eg. ForceMerge, Foreach, In operators etc.
• Created links between Master and detail report for Drilling purpose using Opendoc function.
• Used Alerter in order to highlight the rows dynamically upon changes in the data.
• Interacted regularly with BA's and ETL team to develop Universe and reports.
• Worked under pressure and resolved UAT issues from power users in no time.
• Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change
• to ensure that the views and dashboards were displaying the changed data accurately.
• Used Import Wizard to move the Universe and Reports from Dev to Test.
• Regularly took back up of all the Universe and Reports by using Import Wizard.

Environment: Business Objects XIR 3.1,4.0 Webi, Deski, Tableau Desktop 7 & 8.1, Infoview Portal (Administrator, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Sql Server, Windows XP, Oracle 10g.

Confidential, New York, NY

Business Objects Developer

Responsibilities:

• Involved in the designing and building of Universes, Classes and Objects for various projects.
• Created Derived tables in the Universe in order to do complex calculation.
• Conducted Weekly Meetings to inform members from the team to meet deadlines based upon Clients needs.
• Extensively worked with alerts, filters and conditions in Business Objects.
• Created templates to generate different styles of reports, which are not, belong to Business Objects
• standard documents.
• Created Aliases and Context to resolve loops, defined the cardinalities as defined in data model.
• Worked extensively with @functions (@select, @prompt, @where) to overcome the problems with database when integrating with business objects.
• Involved in Moving Universes and report from Dev to UAT and UAT to Pre-Prod using Import Wizard.
• Provided intensive training to the onsite developers on Designer and Webi Infoview in XI R2.
• Used subqueries and analytical functions in the Universe objects to bring the required data.

Environment: MicroStrategy 8.1/8.0/9.0 (Administrator, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, MDX Adapter) Oracle,Unix.