SUMMARY:

• 15 yearsof professional experience in Software Requirement Analysis,Estimation, Design& Architecture, Development, Testing, Implementation and Documentationof business solutions using BI Reporting
• Tableau, Business Objects, SAS, Jasper & Actuate and Power BI. Proven ability to create quality software that exceeds customer expectations.
• Excellent team player and committed to work effectively with individuals at all levels.
• Capable of managing numerous projects while leading cross - functional teams to meet and exceed overall IT initiatives.
• Demonstrated consultative process skills with emphasis on written and relationship development skills.
• Over 15 years of IT experience in Analysis, Design, Development, Architectural design Implementation, Testing, and Support of Data Warehousing and Server Admin using Power BI, Tableau(v6 to 2020.1),Business Objects all versions from 5.1 to XI R4/IRD(Actuate/Jasper Base)/
• 3 years of experience in Power BI report development and server admin
• 7 years of experience in using Tableau dashboard designing/ Admin, Server Admin, Security, Licensing, Architectural design and Vendor management.
• 10 years of experience in using Business Objects (5x, 6.x, xir2, xir3, xir4.2).
• Installation & Configuration Of Power BI
• Creation of Workspace and assigning Security
• Creation of Apps and Publishing them for user
• Managing Power Bi Premium Work space
• Upgrading of Power BI Software
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Generated computed tables in Power BI by using Dax.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Created Azure Blob Storage for Import/Export data to/from .CSV File.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explore data in a Variety of ways and across multiple visualizations using Power BI
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Published reports and dashboards using Power BI.
• Created Dax Queries to generated computed columns in Power BI.
• Independently work with business team, BA to understand their requirement and propose solution
• Collaborate with end users, project stakeholders, and support partners to identify needs, goals, and metric measurements.
• Work with other leads, architects and managers to deliver the solution in timely manner. Like ETL team, DBA Team, Server team, Source team, Network team, suctioning team etc.
• Expert in Creating Extracts and publishing extracts to Tableau Server for groups
• Recommend best practices for building data visualizations using Tableau, BO, Power BI
• Solid understanding of Tableau presentation and data layer and implementation of Security with Tableau
• Involved in user training and mentoring
• Expert in Creating specs & Mockups for end user
• Experience in Developing verities of dashboards using maps (heat map, Symbol map, filled map, tree map),chart(bar chart, Pie chart, line chart, dual lines, Area chart, scatter plot) etc.
• Worked on data manipulation features in Tableau like calculated fields, Parameters, Table calculations, sets, filters, custom sorting etc.
• Experience in connecting to different databases like SQL Server, Oracle, Teradata etc
• Familiar With ETL tool(Informatica/SSRS) and their process
• Experience in Quality assurance and testing
• Expertise in Installing and Configuring Tableau Desktop, Tableau Public and Tableau Reader.
• Experience in connecting to data sources (Relational dbs. and Excel) using Tableau also connected to Hive2 in Hadoop, google big query using of data blending. Developed lot of KPIs and also action filters to redirect to detail.
• Implemented advanced parametric dashboard like sheet selector and field selector etc.
• Implemented Dynamic Bin and hyperlink to connect outside application outside Tableau
• Implemented best practices of data visualization in multiple business areas experienced in connecting to R & Rstudio in Linux Red hat environment
• Installation and configuration Tableau in Azure and Hadoop environment.
• Configured Load balancing and clustering of Tableau server.
• Experienced in Agile methodology, Define each work item as PBI and track them
• Experienced in SSIS package creation
• Experience to create data links and data loading scripts, including data transformations, reconciliations and accuracies
• Experienced in Creating/maintaining design related artifacts i.e. data models, Mapping documents, architecture diagrams, data flow diagrams in SSIS
• Experienced in version controlling using GitHub, TFS, VSS, Star Team
• Experience in Managing Installation, configuration, patching and upgrading of Tableau tool across the environments
• Experience in Managing the application’s users, groups, and integration with Windows Active Directory
• Experience in Implementing of SAML authentication in our Organization
• Expertise in Automating server job processes and monitoring Server components/services
• Expertise in Managing Tableau Server (like Clustering, Load Balancing, User Management etc)
• Managing 1500 to 2000 user base in tableau and around 100 concurrent users.
• Expert in handling multiple sites.
• Experience in Managing vendor relationship, Tableau Licensing and Invoicing
• Expert in migrating of Tableau dashboards and Data Sources from one environment to other
• Expert in Creating backups and restoration of Tableau repository using Tabcmd command
• Experienced in installation of Multi-node and Enterprise Deployments
• Experienced in creating subfolder and subfolder level permission and security
• Experienced in Tableau Metadata tables and Postgre SQL
• Experience in Creating Active directory, adding people to active directory and sync active directory users to Tableau server
• Expert in Installation, Configuration and setup Tableau in Cloud (Microsoft Azure)
• Expert in Implementing different authentication system in Tableau like Windows AD & SAML
• Expert in Monitoring Tableau server and troubleshooting of server issues using server logs
• Expert in Creating Permission groups and giving data source folder level access for personal files.
• Have extensively worked in developing BO Reports which includes both complex and medium range report. Worked in all most all modules of Business Objects.
• Have expert level experience of Business Objects universe configuration.
• Expert in Universe designing process with resolving loops, creating alias, context etc. and row/group level universe security implementation.
• Involvement of requirement gathering with customer.
• Involvement with both Technical and non-technical users for requirements and for training needs.
• Migration and release of BO universes and reports to different environment.
• Universe designing with multi star environment, Worked in OLTP &OLAP Environment.
• Worked both in OLTP and OLAP system, Implemented link universe
• Involved pre and post migration activity like backup plan, testing followed by migration, preparation of migration plan etc.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Extensively worked on performance tuning of BO Reports
• Worked in Report bursting/publishing/scheduling of BO Reports
• Expertise in developing and maintaining overall Test Methodology and Strategy, Documenting Test Plans, Test Cases and editing, executing Test Cases and Test Scripts
• Extensively worked on BO admin in server and content management.
• Knowledge of VB.net
• Installation and configuration of Informatica Power Center and other related products.
• Scheduling and Monitoring Informatica repository backups
• Monitoring of Informatica jobs
• Scheduling jobs through Control M for monthly and daily job cycles
• Developed mappings and maplets using mapping designer.
• Installation and configuration of SAS Server
• SAS Enterprise Guide Setup for users
• Monitoring of SAS Server and services
• Scheduling jobs through Control M for monthly and daily job cycles
• SAS Licensing and vendor Management

TECHNICAL SKILLS:

Tools: Tableau 2020.1.5, Informatica 9.6.1, SAS 9.4, Business Objects XI r3, r2, 6.5, 6.1, 5.x, 4.x; Web Intelligence XIR3,XIR2, 6.5, 6.1, 2.7 (WEBI); Power BI,SAS

Languages: Visual Basic 6; PL/SQL; SQL; SQL Plus, C++

Databases: Oracle 11I, 10I, 9I, 8I, 7; Teradata v2r5;MS Access,DB2,MS Sql Server,Hive2,Hadoop

Domain: Telecommunication, Banking & Finance, Manufacturing & Retail, Oil & Natural Gas,m Government sector, Association management

Operating Systems: Windows Server 2008/2003/7/Vista/XP/2000/NT/98; Windows 95; Unix

Database: SQL Server2008,Oracle 9i,Teradata

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

Tableau Admin

Responsibilities:

• Involved development and design of Power BI model and reports
• Creation of Power BI apps and shared to external and Internal users
• Creation of workspace and provide access to users
• Power Bi premium management
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explore data in a Variety of ways and across multiple visualizations using Power BI
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Published reports and dashboards using Power BI.
• Created Dax Queries to generated computed columns in Power BI.
• Creation of Summary tables
• Experienced in Agile methodology, define each work item as PBI and track them
• Experienced in Sales force report development and report type

Confidential, Madison, WI

Tableau Lead Developer

Responsibilities:

• Development of Tableau dashboards
• Creation of different data sources, extracts for Tableau and publish them into tableau server
• Development of Tableau dashboard for WHIO and render them in web portal for health care and Health system
• Implementation of best practices for Tableau dashboard designing
• Refresh of store procedure for Tableau dashboards and modification of SPs
• Working on migration of Tableau dashboards and Data Sources from one environment to other
• Creating backups and restoration of Tableau repository using Tabcmd command
• Experienced in Tableau Metadata tables and Postgre SQL
• Backup and restore of tableau server/content
• Involving in Managing Installation, configuration, patching and upgrading of Tableau tool across the environments, upgraded from v2018.v2019
• Experienced in Managing the application’s users, groups, and integration with Active Directory
• Expert in Automating server job processes and monitoring Server components/services
• Managing vendor relationship, Tableau Licensing and Invoicing

Confidential, Madison, WI

Tableau Admin & Architect

Responsibilities:

• Installation & Configuration Of Power BI premium services in Confidential mutual
• Creation of Workspace and assigning Security
• Creation of Apps and Publishing them for user
• Managing Power Bi Premium Work space
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Generated computed tables in Power BI by using Dax.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Created Azure Blob Storage for Import/Export data to/from .CSV File.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explore data in a Variety of ways and across multiple visualizations using Power BI
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Published reports and dashboards using Power BI.
• Created Dax Queries to generated computed columns in Power BI.
• Creation of specs for Tableau dashboard, Creation of Tableau data source for end user
• Monitoring of Tableau server and troubleshooting of server issues using server logs
• Developed verities of dashboards using maps (heat map, Symbol map, filled map, tree map),chart(bar chart, Pie chart, line chart, dual lines, Area chart, scatter plot) etc.
• Worked on data manipulation features in Tableau like calculated fields, Parameters, Table calculations, sets, filters, custom sorting etc.
• Expertise in Installing and Configuring Tableau Desktop, Tableau Public and Tableau Reader.
• Connecting to different data sources (Relational dbs. and Excel) using Tableau also connected to Hive2 in Hadoop, using of data blending. Developed lot of KPIs and also action filters to redirect to detail.
• Implemented advanced parametric dashboard like sheet selector and field selector etc.
• Implemented Dynamic Bin and hyperlink to connect outside application outside Tableau
• Understanding and implementing best practices of data visualization
• Managing with Installation, configuration, patching and upgrading of Tableau tool across the environments
• Manage the application’s users, groups, and integration with Active Directory
• Automate monitoring & server job processes
• Should be capable of doing Tableau Server Management (like Clustering, Load Balancing, User Management etc)
• Handling multiple sites.
• Managing vendor relationship, Tableau Licensing and Invoicing
• Should be familiar with tableau migration and scheduling.
• Taking back ups and restoration of Tableau repository
• Good knowledge on Tableau Metadata tables and Postgre SQL
• Setting of tableau and BO jobs using control M
• Creation of active directory, adding people to active directory and sync active directory users to Tableau server
• Installation, Configuration and setup Tableau in Cloud (Microsoft Azure)
• Creation of Permission group and given data source folder level access for personal files.
• Creation of extracts and publish extracts for groups
• Installation and configuration Tableau in Azure and Hadoop environment.
• Also working in SAS, BO and Power BI admin
• Design and Development of BO Universe and reports
• Conversion of BO reports to Tableau
• Migration of BO Reports from one environment to other.
• Installation & Configuration of Power BI
• Creation of Workspace and assigning Security
• Creation of Apps and Publishing them for user
• Managing Power Bi Premium Workspace
• Upgrading of Power BI Software
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Generated computed tables in Power BI by using Dax.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Created Azure Blob Storage for Import/Export data to/from .CSV File.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explore data in a Variety of ways and across multiple visualizations using Power BI
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Published reports and dashboards using Power BI.
• Created Dax Queries to generated computed columns in Power BI.
• Creation of Summary tables
• Configured Load balancing and clustering of Tableau server

Environment: / Tools: Tableau 2018.1.5 SQL Server, SAS, Power BI, Linux, Business Objects 4.2, SSIS

Confidential, Phoenix, AZ

Technical Lead

Responsibilities:

• Experience in business requirement and converted them into Tableau dashboard designing
• Experience in creating data model/ data source for dashboard and publish them into Tableau server
• Developed verities of dashboards using maps (heat map, Symbol map, filled map, tree map),chart(bar chart, Pie chart, line chart, dual lines, Area chart, scatter plot) etc.
• Worked on data manipulation features in Tableau like calculated fields, Parameters, Table calculations, sets, filters, custom sorting etc.
• Worked on data blending and cross data joins
• Experience in Connecting to different data sources
• Managing vendor relationship, Tableau Licensing and Invoicing
• Expert in migration of Tableau dashboards and Data Sources from one environment to other
• Expert in creating backups and restoration of Tableau repository using tabcmd command
• Experienced providing permission for different groups
• Experienced in Tableau Metadata tables and Postgre SQL
• Creation of Custom SQL for Tableau Dashboard
• Expert in Creating Active directory, adding people to active directory and sync active directory users to Tableau server
• Expert in Installation, Configuration and setup Tableau in Cloud (Microsoft Azure)
• Experience in Implementing different authentication system in Tableau like Windows AD & SAML
• Experience in Creating Permission groups and giving data source folder level access for personal files.
• Expert in Creating Extracts and publishing extracts to Tableau Server for groups
• Creating specs & Mockups for end user
• Experience in Monitoring Tableau server and troubleshooting of server issues using server logs
• Expertise in Installing and Configuring Tableau Desktop, Tableau Public and Tableau Reader.
• Connecting to different data sources (Relational dbs. and Excel) using Tableau also connected to Hive2 in Hadoop, google big query using of data blending. Developed lot of KPIs and also action filters to redirect to detail.
• Experienced in version controlling using GitHub, TFS, VSS, Star Team

Environment: / Tools: Business Objects XIr3, Oracle data base, Tableau8, SQL Server

Confidential, Boston

Technical Leader

Responsibilities:

• Delivered 30 Tableau Dashboard and 312 BO Webi Reports of high complexity and medium range with multiple data provider and multi sectioning and grouping report.
• Creation of Tableau Data sources and Publish them into Tableau server
• Worked on all the data manipulation features in Tableau like calculated fields, Parameters, Table calculations, sets, filters, custom sorting etc.
• Connected to different data sources (Relational dbs. and Excel) using Tableau
• Developed verities of tableau dash board like map, chart etc.
• Good knowledge in the capabilities of Tableau like Data blending, metadata management and architecture etc.
• Understanding and implementing best practices of data visualization
• Expertise in Installing and Configuring Tableau Desktop, Tableau Public and Tableau Reader.
• Managing Tableau server, content
• Have involved in Tableau upgrade
• Managed multiple sites
• Developed new universe and updating of old universe.
• Modification of existing reports as per customer request (as per change request)
• Publish the report in corresponding group
• Taken care Report migration from Dev to BUAT
• Involved performance enhancement activities.
• Developed dashboards which includes geographical Mapping functionalities and advanced data visualization features of Tableau involving multiple dimensions and measures
• Team management (with 20 member team) which involves activity distribution, status reporting, creation of metrics for better improvement and tracking purpose.
• Prepare capacity planning
• Effort estimation.
• Preparation of training planning for new team member. Co-ordination between offshore and onsite.

Environment: / Tools: Business Objects XIr3, Tableau7, Oracle data base, IRD reporting and ESP data base

Confidential

Business Objects Lead

Responsibilities:

• Update and Maintain Universe based on changing user requirements.
• Create and Test Universe objects.
• Deploy universe-using Repository.
• Developed various reports in Webi.
• Developed reports by using Free hand SQL.
• Modification of reports as per user request
• Update and Maintain Developed Reports based on changing user requirements.
• Prepared the user manual.
• Schedule the report in corporate
• Monitoring of production system by using Informatica.
• Performance enhancement of reports and universes.
• Team handling
• Estimation
• Weekly status report

Environment: / Tools: BO XIR2/Oracle/Informatica 7

Confidential

BO Lead, Solution Architect

Responsibilities:

• Understanding RDD(requirement Development Docs) and converting to technical design docs
• Responsible for tuning the SQL queries.
• Creating universes and reports
• Creating impact analysis documents.
• Responsible for BO build and release build to different environment.
• Responsible for Configuration management.
• Creation of users & groups in CMC.
• Responsible for Scheduling the reports
• Responsible for BO estimation and preparing LDD,RDD.
• Supervising and conducting UAT and Production movement.
• Resolve production issues and business queries by Client.

Environment: / Tools: BO XIR2, Oracle 9i; Win XP.