| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLEEMAIL AVAILABLESUMMARY14+ years of IT experience, quick learner, easily adapts to various environments and very effective communication and interpersonal skills.7+ years of data visualization experience using Tableau.Expertise in Tableau 7, 8, 8.3 & 9.0, 2018.1, 2018.2 & 2019.2, 2020.4Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau ServerInvolved in trouble shooting of performance issues which were associated with Tableau reports.Involved in admin activities as setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau ServerDesign Dashboards with best practices for optimum performance.Proficient in publishing and distribution of Tableau content at enterprise levelExperience creating sites and security folders and user management with Windows AD groups.Config Salesforce.com, sparkler for Tableau Integration, via SAML authenticationIdentified all reports/Dashboards on SAP Business Objects and replicated the same on Tableau 9.08+ years of experience in Business Objects XI 4.2/4.1/4.0/XI R3/R2/6.X, Business Objects IDT, Universe Designer, Reporter, Central Management Console, BI Launchpad, InfoView and Web-Intelligence Rich Client.Strong knowledge in overall BO XIRPHONE NUMBER AVAILABLE application architecture and able to Design, Deploy, Support the application architecture.Good Understanding of Process Flows within the Enterprise Architecture for different user request.Experience in installation, administration and upgrading versions of BO both desktop and server products on both Windows and UNIX environments.Experience working with Single Sign On (SSO) for Business Objects Enterprise.Involved in designing Universe and creating reports web intelligence and Desktop Intelligence report.Experienced in migration of Business Objects 6.5.1 Enterprise to XI R2/3.1.4.0.Well versed in Business Objects with experience in Supervisor, Designer, Reporter, BCA (Publisher and Scheduler), Web Intelligence 2.5/2.6.1/6.0, Info view, Dashboards, Auditor and Schema Design.Good knowledge and experience in using Querying and Reporting modules of Business Objects Enterprise XI and Crystal Reports.Developed Databricks notebooks using Python (PySpark) and SparkSQL for transforming data stored in Azure Data Lake Storage Gen2 across various zones.In-depth knowledge in creation of Dashboards using Crystal Xcelsius and Dashboard manager.Good understanding on Apache Zookeeper and Kafka for monitoring and managing Hadoop jobs and using Cloudera CDH4, and CDH5 for monitoring and managing Hadoop clusters.Good working experience on Spark (Spark Core Component, Spark SQL, Spark Streaming, Spark MLlib, Spark GraphX, SparkR) with Scala and Kafka.Integrated DBT with data warehouse technologies such as Snowflake, Big Query, or Redshift to leverage their capabilities for efficient data processing and storage.Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures, and free hand SQL methods. Solid knowledge of SQL and PL/SQL.Good knowledge and experience in using Oracle 9i/10g/11g/12c/RAC, Teradata, MS SQL Server 2000/2005, Cloudera Hadoop, Impala, Hive, Amazon Redshift, DataBricks, Snowflake, Data LakeTechnical Skills:Cloud TechnologiesAmazon Web Services, Azure Data Factory (ADF), Azure DatabricksToolsMySQL, MS Access, DB2, Azure SQL Server, Azure Synapse, SQL server, MS SQL Server 2016-2008 R2, PuTTYBig Data TechnologiesHDFS, Sqoop, PySpark, Data Lake, Redshift, Spark, Hive, ImpalaData Modeling ToolsToad Data Modeler, SQL Server Management Studio, MS Visio, SAP Power designerDatabasesMySQL, Oracle, MS Access 2016/2010, Hive, MS SQL Server, Amazon Redshift, Azure SQL Database, snowflake, PostgreSQL, TeradataReporting ToolsTableau, SAP Business Objects, PowerBILanguagesSparkSQL, SQL, PySpark, R, Spark, Scala, Bash, PowerShellOperating SystemsWindows Server 2012 R2/2016, UNIXData WarehousingSnowflake, Redshift, TeradataVersion ControlGIT, GitHubData VisualizationPower Bi, Tableau.WORK EXPERIENCEBCBSM (Blue Cross Blue Shield of Michigan), Detroit. MI July 2019 CurrentSr. Software Engineer (BI Architect & SME)Designed and developed data models needed for the Dashboards in Hive/ImpalaDeveloped Dashboards involving lot of calculated fields derived from Data SourcesDeveloped Clinical Quality Dashboards for Performance and Improvements scorecards of Physicians offices.Extensively worked on migrating the Tableau Dashboards from Cloudera to Amazon Redshift/DataBricksCreated the tables that are used in Dashboards as data sources in Redshift/DataBricksInvolved in the creation of ODH (Operational Data Hub for DataBricks) & ADH (Analytical Data Hub for Redshift) Data ModelsCreated the Data Models in Redshift/DataBricks as part of the Project requirement for Dashboards.Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.Developed Tableau visualizations and dashboards using Tableau Desktop.Developed Tableau workbooks from multiple data sources using Data Blending.Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.Interacted with the existing database developers and DBA to understand the existing schema.Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server.Conducted presentations to other lines of business as a meta role to show value of Tableau as a BI toolKept track of own work effort with lean project management on Kanban boardDesigning data model from scratch to aid team in data collection to be used for Tableau visualsBuild Hospital, Clinical Region and System related information with advanced VizsConsult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.Developed Data Modelling/Tableau Dashboards on Hadoop for Senior Health ServicesDesigned and managed ETL pipelines leveraging tools such as Logic Apps, Python, Spark, DBTDeveloped Notebooks in Databricks for data extraction, transformation, and loading (ETL) of various file formats into Azure Data Lake and external data warehouses.Healthcare & Family Services (State of Illinois), Springfield. IL Feb 2015 June 2019Sr. BI Architect (Tableau & Business Objects)Have good exposure to EPIC tool.Integrating Tableau with SFDC, with sparkler configurationBuilding Tableau dashboards and setting up user securityAbility to convert SAP BOBJ reports to Tableau environment.Moving code across Tableau Landscape and create Tableau DataSource to cater for all generic needs.Experience working with users to discuss/understand KPI data for reporting requirements.Gathering Visualization requirements from Business user communitySecurity setup of Roles and AD groups in TableauAdmin Tasks- Debug, performance tuning, upgrades and patchesCreating Projects and user groups and managing Tableau contentAbility to design Data sources from SAP HANA sources to give self-service ability to users.Propose SAP HANA modelling changing as per Tableau reporting requirements.Build Hospital, Clinical Region and System related information with advanced Vizs.Interact with SAP HANA and SFDC teams for Data Integration testing.Integrating Tableau Viz with SFDC pagesExperience with Tableau configuration and System setup and Tableau security integration with SAMLAbility to create Visualforce Pages, Custom Links and Canvas in Salesforce, and embed Tableau VizExperience with Load testing of Tableau server with huge Data volumesImplemented Automation of Business Objects report scheduling using Publications.Updates to Business Objects Universes, which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.Effectively administered and supervised the Business Objects (SAP BI) environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.Worked on Business Objects Security Model and Business Objects Security Implementation (Row level, Object level, Command level).Worked on Informatica PowerCenter for creating mappings, sessions & workflows to load the data into reporting tables.Data connections to the dashboards were accomplished through BI Web Services.Tuned the reports for better performance using SQL.Scheduling of different WEBI Reports and showing the reports in different format e.g., Microsoft Excel, PDF and Web Intelligence.Created Complex Reports in Webi4.2Created Web Intelligence reports with multiple data providers like Universes, Excel FilesManually performed System Testing, Regression Testing and Functional Testing. Generated Test data for identifying valid data, Invalid data, Partial data, and Bad data using SQL in Teradata.Developed SQL programs on Teradata SQL Assistant to perform Unit test on WebI Reports.Department of Agriculture, Kansas City, MO Oct 2014 Jan 2015Sr. Business Objects DeveloperInvolved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Crystal Reports.Design and Development of Business Objects Universes, which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.Used the Functionality of Sections and Breaks in most of the reports.Created Reports that required Folding and Unfolding.Use of Input Controls was also used in every report.Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.Implemented Row level and Object Level security as per the user requirement.Data connections to the dashboards were accomplished through BI Web Services.Created Interactive Dashboard using Dashboard Designer4.0.Created templates to generate different styles of reports, which are not, belong to Business Objects standard documents.Tuned the reports for better performance using SQL.Created various 3D pie charts, Pie charts, Bar Charts, Line Charts.Scheduling of different WEBI Reports and showing the reports in different format e.g. Microsoft Excel, PDF and Web Intelligence as per the Mockup Requirement.Regression Testing of the reports in Dev and Test environment and Scheduling of reports in info view.Check the integrity of the Universes and export the universes to Repository for making available to users.Regularly took back of reports and Universe using Import Wizard and creating BIAR files.Interacted with Business Objects technical team to get the resolution of problems / bugs in Business Objects.Involved in making PAD (Physical Application Document), and also SRD (System Required Document) while working with Data Analyst.Created Complex Reports in Webi4.0Involved in transferring the data between Flat Files into Database TablesUsed multi value components like line charts, bar charts, stacked column charts and combination charts, and single value components like gauge, slider, dial and progress bars in the development of the Dashboards.Installed Web intelligence on the server and configured the IIS console to define the paths & aliases necessary to run WEBI.Debugged issues which resulted from Migration. Provided support in enhancement and maintenance of the Reports and UniversesCreated new Universes and fine-tuned existing ones by resolving join problems, setting up aggregate awareness, defining hierarchies, cascading LOV, @Functions and more.Created universe on top of views build in composite coming from multiple data sources.Created Multiple Custom Hierarchies for several groups to provide drill across functionality.Converted reports from desktop Intelligence to web intelligence using Report conversion tool and manual conversion method.Extensively Designed & Deployed System Reports, Custom Reports, User Report, Ad Hoc Queries by incorporating the functionalities of Sort and Drill Down.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 Web Intelligence reports with multiple data providers like Universes, Personal Data Files and free-hand SQL.Manually performed System Testing, Regression Testing and Functional Testing. Generated Test data for identifying valid data, Invalid data, Partial data, and Bad data using SQL in SQL Server.Developed SQL programs on SQL Assistant to perform Unit test on WebI Reports.Ciber ITO (SAVVIS) Edison, NJ May 2012 Dec 2012 Business Objects DeveloperInvolved in production support, dealt with daily issues faced by users and resolved them.Created several WebI reports and DeskI reports for finance department.Designed Universe by creating the SAP Business Objects data model selecting and providing joins between the tables, indicating cardinalities.Created reports using SAP Business Objects functionalities i.e., slice and dice, drill down, cross tab, alerter and formulas etc.Scheduled daily, weekly and monthly reports using events, creating calendars.Involved in migrating from XI R2 to XI R3.1 also tested the reports after migration.Worked on Basic SAS reporting system to retrieve data from SAS data sources and delimited flat files.Created detailed WebI reports and linked them to Xcelsius with the help of OpenDoc.Used context operators like In, For Each, For All in WebI reports in order to meet the business requirements, Created Web Intelligence reports ad-hoc and canned reports.Migrated universes and reports from Dev/QA to production using Import WizardCreated report designing documents for further reference.Tuning the queries to improve the performance of the report refresh time.Created complex variables and calculation to meet the user requirements.Worked with offshore team and coordinated with them as onsite coordinator.Interacted with customer support regularly, to resolve the existing issues and generated the required reports.Involved in creating reports such as schedule of investments, statement of assets and liabilities, statement of operations, statements of changes in net assets, financial highlights and other reports.Philips Respironics, Pittsburgh Dec 2010 Apr 2011 Business Objects & Crystal Reports DeveloperInvolved in the creation of various report formats including master/detail reports, sub reports and cross tab reports and published them via the Crystal EnterpriseCreated dashboards with live streaming of data using Web Service connection (WSDL) in XcelsiusOpenDoc command and usage of Flash variables within XcelsiusCreated detailed Web Intelligence reports and linked them to open in Xcelsius with the help of Open Document functionDeveloped reports with multiple parameter fields and multiple grouping for various hierarchy levelsInvolved in setting up users and assigning privileges to these users to meet security requirementsCreated universes from multiple data sources which were coming from different databasesCreated predefined conditions, prompts and custom hierarchies in the process of building the universesResolved issues like loops by creating aliases and contexts as required removing the cyclic dependenciesExported the universes to dev, test and prod domains to make resources available to the usersCreated repository using supervisor, created users and groups, assigned rights to users and groupsCreated universes, classes and objects for management systemsResolving loops using aliases and contexts and check integrity of the universe and exported them to the Repository to make resources available to the users and groups lMUpdated and maintained Universes based on changing user requirements and data source changesDeveloped and deployed complex reports. Used multiple data providers, union, intersection, minus and master/detail, cross tab, chartsCreated templates for standardizing the structure of our corporate documentsWorked extensively with the major functionalities of SAP BusinessObjects like breaks, alerter, filters, sorts, query prompt and drill filtersCreated Report level variables by using used variable editorAnalyzed the reports using the drill through, slice and dice, created reports on web using Web IntelligenceSonata Software Ltd, Hyderabad, India May 2007- Mar 2010Business Objects DeveloperInstalled and configured Business Objects XI 3.1 Enterprise on Windows 2003 ServerMigrated & upgraded Business Objects from XIR2 to Business Objects from XI 3.1Analyzed functional and technical requirements and prepared deliverables including Software Requirement Specifications, User Interface Specifications, screen mock-ups, report mockupsDesigned universes based on user requirements as well as functional and technicalIdentified the basic tables and the logical relationship between the tables to create the most balanced and scalable universePerformed Integrity Checks to Universes to detect loops, cardinalities and joinsCreated Aliases and Shortcut Joins in order to resolve the loops in the newly developed UniversesCreated Classes, Objects, and Filters in the Universes as per the request submitted by the Report Developers and Business UsersExtensively used @functions (@select, @prompt, @where in the creation of filters, prompts, and conditionsCreated new set of groups to assign privileges to different set of users and have a control on the access they have to the reportsChanged the format of the reports into PDF, EXCEL and Scheduled the reportsConverted all Desktop Intelligence Reports to Web Intelligence Reports using Report Conversion ToolUsed Filters, Sections, Breaks, Sorts, Query Prompts and Drill filters functionalities in making the reports easy for analysisCreated Drill-Through Reports to provide users with more detailed information and query linkingDesigned and developed several complex reports using drill down features, sub reports, cross tab reports, labels, summary reportsConverted existing reports, which were developed in access into crystal reports using Crystal Reports 10Actively involved in a new report generation and customization of existing reportsUsed various crystal reports features e.g. conditional formatting, use of multiple groups and parameter passing and complex formula usageCreated detailed WebI reports and linked them to open in Xcelsius with the help of OpendocUsed context operators like In, ForEach, ForAll in WebI reports in order to meet the business requirementsCreated Web Intelligence Reports Ad-hoc and canned reportsCreated report designing documents for further referenceScheduled the Web Intelligence reports and published them on weekly basisTuning the queries to improve the performance of the report refresh timeCreated complex variables and calculation to meet the user requirementsTrained end users with business objects products like InfoView and Web Intelligence and BusinessObjectsCreated the reports using BusinessObjects functionalities like multiple data providers, prompts, slice & dice and drill downDeployed reports on the web using Crystal Publishing Wizard and scheduled reports using e-portfolio and management consoleInteracted with business users to refine requirements and this included conducting meetings, conference calls, and hand on process reviewEducation:Masters in business administration (Information Technology), Wilmington, DE, USA.Bachelor of Engineering in Information Technology, Osmania University, Hyderabad, AP, India |
