OBJECTIVE

Seeking for a challenging role as a Sr. Business Intelligence Consultant in a prestigious company and recognize my skills in Data Modeling and Cleansing, Business Intelligence and other skills related to Business Intelligence Development and Administration in meeting the company's goals and objectives.

SUMMARY

• 12 years of experience in BI Tools like Tableau, BOBJ, Xcelsius and QlikView.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Good Knowledge of dimensional modeling (Star Schema and Snowflake Schema).
• Built, designed, and tested executive level Dashboards and Scorecards using various Business Intelligence Tools.
• Built dashboards/reports using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Expertise in creating Reports Dashboards and writing stories as per user requests.
• Expertise in developing Complex, Canned and Adhoc reports.
• Extensive experience in writing complex SQL to build reports & analyze the data.
• Solid experience in installation, administration, migration, configuration, technical support, troubleshooting, maintenance and overall health of the Tableau, BusinessObjects servers in multi cluster implementations.
• Experience in writing SDKs for various BI tools
• Expert in Data Extraction, Transforming and Loading (ETL) using BusinessObjects Data - services
• Timely & quality delivery of the products
• Experience in working Agile & Waterfall models.
• Extensive knowledge in software testing methodology and developing Test Plans, Test Procedures, Test Case Design and Execution, Modification Requests.
• Unique ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts. A strong team member with good Communication and Analytical skills.

TECHNICAL SKILLS

• Business Intelligence
• Tableau
• QlikView
• SAP Business Objects Suite (Web Intelligence,Info view,Designer,Desktop Intelligence,CMC,Xcelsius,Live Office,QAAWS and Voyager)
• SAP Lumira
• Database & Tools
• AWS Redshift/Aurora
• Spark SQL
• Teradata
• ORACLE 10/11g
• SQL Server 2000/2005
• MySQL
• MS Access
• TOAD
• PL/SQL Developer
• Management Studio
• Enterprise Manager
• Query Analyzer
• SQL Profiler and SSIS.
• Scripts
• Perl Script
• Shell Script
• JavaScript
• VBScript
• HTML and XML.
• Applications
• Microsoft Office
• Microsoft PowerPoint
• Visio
• Confluence and Visual SourceSafe
• ETL
• SAP Business Objects Data Services

PROFESSIONAL EXPERIENCE

Confidential, Camden, NJ

Sr. Business Intelligence Consultant

Responsibilities:

• Ability to translate user requirements into detailed technical or design specifications as well as create and maintain Universes and reports using BO tool set
• Created functional and technical specifications based on business and technical requirements
• Provided time and cost estimates and feasibility assessments for projects.
• Ability to work in a dynamic team-oriented environment as well as independently
• Wrote detailed level documentation for reports and universe design.
• Managed the resources, WEBI users, connections, and the Universe repository.
• Created Cost Management Reports and Contract Account Profile UW using Web and Crystal Reports.
• Scheduling Reports in Business Objects from one environment to another environment.
• Worked closely with management to design applications that made the business planning process easier.

Environment: SAP Business Objects Suite (Web Intelligence, Info view, Designer, Desktop Intelligence & CMC), Power BI, MS SQL Server and MySQL.

Confidential, Chicago, IL

Sr. Business Intelligence Consultant

Responsibilities:

• Gather & convert the business requirements into the technical documents for Proof of concept.
• Analyzed Business Required Document to understand the reporting requirements
• Extensive testing and migrating the reports & dashboards from development to Production system.
• Created the Test Case scenarios for the developed source systems which should be loaded in the database.
• Expertise in profiling the data for reporting use.
• Delivering the products as per assigned Sprints.
• Support on call for executive dashboards
• Develop & Maintain Power BI dashboards for various users.
• Install, Upgrade & maintain Tableau Server & propose upgrades as per the Tableau releases.
• Experience for hosting Tableau Server on cloud environment using Windows OS.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau Audit Dashboards to monitor the server performance & server usage.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Developed Tableau workbooks from using various connectors like Excel, Spatial file, Statistical file, Amazon Redshift, Amazon Aurora, Amazon Athena, WDC etc.
• Created shared extracts, published data sources to Tableau Server.
• Created WDC connectors using Javascript for couple of business solutions. Also, enabled the connectors on the Tableau Server as well.
• Provided business solutions using Tableau Dashboards
• Expertise in Designing reports using SAP Business Objects Suite.
• Creating Universe with number of Classes, objects, Derived Tables for Operational reporting requirement.
• Created canned reports, simple reports and Ad-hoc reports using Webi and Crystal Reports.
• Scheduling Reports in Business Objects using different types of events.
• Created List of Values, hierarchy and conditions in the universes for reporting needs to drill down reports on hierarchies.

Environment: (Web Intelligence, Info view, Designer, Desktop Intelligence & CMC), Power BI, AWS Redshift, AWS Aurora, MS SQL Server, MySQL and MS Visio.

Confidential, Chicago, IL

Sr. Business Intelligence Consultant

Responsibilities:

• Gather and Analyzed Business Requirements and created Functional and Technical specification documents for development.
• Created the Test Case scenarios for development task for unit testing of reports.
• Extensive testing and migrating the reports & dashboards from development to Production system.
• Delivering the products as per assigned Sprints.
• Support on call for reporting support and server’s maintenance
• Performed reporting inventory and cleanup of environments by running auditing reports to collect the user activities and automated reports to simplify administration activities.
• Designed, developed, tested, and maintained Tableau workbooks based on user requirements.
• Designed dashboards using Trend lines, Stacked Bar, Gantt View, Combo Chart, Scatter Plots, Heat maps, etc.
• Created action filters, parameters and sets for developing dashboards and worksheets in Tableau.
• Developed Tableau workbooks from multiple data sources using Data source joins and Data Blending.
• Developed shared data sources with web data connectors for API calls which are consumed for real time analytics.
• Install, Upgrade & maintain Tableau Server & propose upgrades as per the Tableau releases.
• Administered user, user groups, and scheduled instances for reports in Tableau
• Automated Tableau Backups & cleanup using PowerShell scripts.
• Automated Server Health dashboards and server activity dashboards.
• Worked on migration of dashboards on UAT to DEV environment.
• Expertise in Designing reports using SAP Business Objects Suite.
• Creating Universe with number of Classes, objects, Derived Tables for Operational reporting requirement.
• Created canned reports, simple reports and Ad-hoc reports using Webi and Crystal Reports.
• Scheduling Reports in Business Objects using different types of events.
• Created List of Values, hierarchy and conditions in the universes for reporting needs to drill down reports on hierarchies.
• Design, build, and provide administrative/technical/consulting support for SAP Business Objects XI 4.x
• Upgrade from BI XI R2 to BI 4.1 SP 6 and later upgraded to BI4.1SP7 P1 on all the environments and expand one node to three node environments in Test & Production systems

Environment: Tableau Server 9.2/9.3/10.1/10.3/10.5 , Tableau Desktop, Tableau SDKs, SAP Business Objects Suite (Web Intelligence, Info view, Designer, Desktop & CMC), SAP Lumira, Crystal Reports, AWS Redshift, AWS Aurora, MS SQL Server, MySQL, Oracle and MS Visio.

Confidential, Chicago, IL

Business Intelligence consultant

Responsibilities:

• Involved all the business meetings to understand the business requirements and convert the requirements into the technical documents to prepare the mockup designs for stakeholders.
• Provides Solution Performance (analysis/tuning) & works across business/technology teams to ensure alignment between business solution definition & systems architecture for the organization.
• Involved in the data model design sessions to convert the business requirements into a semantic data model to get the efficient reporting.
• Assign tasks to offshore team and scheduling daily calls to track the progress.
• Extensive testing and migrating the reports or objects from development to Production system.
• Created the Test Case scenarios for the developed source systems which should be loaded in the database.
• Developed methodology, Change and Release Management strategy for Development, Test and Production environments.
• Created and updated server architecture for scheduling tasks.
• Analyzed and resolved performance and server-based issues.
• Prepared backups using Tabadmin and Tabcmd commands.
• Formulated procedures for installation and configuration of Tableau desktop.
• Participated in performance tracking activity by evaluating server tasks.
• Modified data visualization dashboards and developed data connections.
• Expertise in Designing reports using SAP Business Objects XI 3.1/4.0 Suite.
• Creating Universe with number of Classes, objects, Derived Tables using inner/outer and equiv. joins as per requirement.
• Deployed Dashboards in an Enterprise Environment using Crystal Xcelsius and Info Burst
• Scheduling Reports in Business Objects using different types of events.
• Created List of Values, hierarchy and conditions in the universes for reporting needs to drill down reports on hierarchies.
• Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops
• Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.

Environment: Tableau Server, Tableau Desktop, SAP Business Objects Suite (Web Intelligence, Info view, Designer, Desktop Intelligence, CMC and Voyager), IBM Tivoli, Teradata, ORACLE 10/11g, MS Access and MS Visio.

Confidential, Norwalk, CT

Business Objects consultant

Responsibilities:

• Hands on experience with implementation on large installations on Unix/windows environment
• Involved in enterprise BI security setup
• Worked as Subject Matter Expert (SME) for Business Objects
• Review an Architecture Assessment Analysis (Sizing Analysis). expertise in BusinessObjects ETL and Reporting software installation, configuration, tuning, performance monitoring, issues resolution and user assistance
• Clustered multiple Business Objects servers together for load balancing
• Having extensive knowledge on audit reviewing, advanced troubleshooting and experience to provide solutions (or) suggest solutions
• Customization of Business Objects Enterprise using SDK
• Expertise in BusinessObjects 4.0 software installation and configuration
• Installed SAP business objects mobile client and server to view reports from IPad also Installed Business Objects explorer on Linux servers
• Used SAP security authentication in BusinessObjects 4.0
• Worked with BI team to configure RFC destination and Create BusinessObjects enterprise definition on SAP BI servers
• Deployed single sign on BusinessObjects Enterprise and its other Reporting tools
• Experienced in promoting SAP BusinessObjects environments through development, QA, UAT, DR and production using LCM (Life Cycle Management)/Promotion Management/ Import wizard
• Perform environment refreshes and apply software patches and fixes.
• Clustered the servers successfully by distributing the Business Objects Services effectively between all the servers to make the Business Objects Environment Highly available and get the "FAILOVER" to work efficiently.
• Experienced in scheduling the reports, programs in CMC
• Installation of Client Tools and coordinate with System Admin to verify compatible with Server.
• Automating and simplifying the administration, auditing and monitoring of BI platform through APOS System
• Expertise in providing guidance in the design, development and implementation of business intelligence capabilities with emphasis on products offered by BusinessObjects Data Services
• Experience with Data Integrator for ETL (Extraction, Transformation, and Loading) of data from multiple sources database systems to Data Warehouses.
• Upgraded Data Services 12.2.2 to 4.1
• Created Global variables to read the files from the shared location from the BODS Designer Also worked on the FTP process to put & get the files on the data-exchange servers.
• Migrated all the Projects of the team from DEV TO TEST TO PS TO PROD, & scheduled the jobs as part of the Administrator.
• Experience maintaining and monitoring connections and extractions between Data Services and multiple source systems
• Scheduled BODS batch jobs through IBM TWS on daily basis
• Implementation of Training and Mock systems for users, providing technical & system documentation for Business owners and users.

Environment: SAP Business Objects Suite (Web Intelligence, Info view, Designer, Desktop Intelligence, CMC and Voyager), Business Objects Data Services, IBM Tivoli, Teradata, ORACLE 10/11g,

Confidential

SAP Consultant

Responsibilities:

• Involved in requirement gathering from Business users, Responsible for understanding end user requirement and convert into functional requirement and involved in Designing reports using BI Tools.
• Involved in Security Design and Implementation, performance tuning of reports, unit testing and documenting the processes.
• Uploaded Master and Transactional data from flat files.
• Responsible for writing Perl Script, Shell Script to load individual Source Systems in database.
• Created the test case scenarios for the developed source systems which should be loaded in the database.
• Experience in transforming MS Access Process to ORACLE SQL’s. Also, loaded data from Access to Oracle 11g and automated the process using Autosys jobs and Shell script.
• Created database tables from excel sheets using shell scripts.
• Documented the daily operational process of generation of different financial reports.
• Created Autosys Job Schedulers to schedule the data loads.
• Writing technical specs and training users to create reports.
• Used Business Objects Developer Suite (Publisher View, CMC, Designer, and Info View) to perform various tasks specific to every component.
• Defined BO XI R2 user security model, defined users, groups, and Role based user, Universe Security and Administration, Authentication strategy Single Sign on LDAP.
• Converting Micro Strategy reports to Business Objects and also converting Business Objects reports to Micro Strategy.
• Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.
• Designed several universes and used various methods to optimize queries on database, universe and reporting level.
• Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.
• Deployed Dashboards in an Enterprise Environment using Crystal Xcelsius and Info Burst.
• Involved in migrating the BOXI R2 to BOXI 3.1 and also from BOXI 3.1 to BOXI 4.0.
• Used Xcelsius Dashboard to Visualize and to enhance the data presentation along with developing dynamic charts and graphics.
• Participated in User Acceptance testing.
• Providing support for the users on application usage and conducting training walk through of salient features of the application.

Environment: SAP Business Objects Suite (Web Intelligence, Info view, Designer, Desktop Intelligence, CMC, Xcelsius, Live Office, QAAWS and Voyager).