Business Analyst Resume
SUMMARY
- 11+ years of IT Experience in Business Analysis, Business Intelligence applications, Data Warehousing applications, Data Visualization, Data Analysis, Federal Government, Mortgage, Media, Financial, Health Care, manufacturing, Banking, Automobile Industries.
- Depth Experience of Software Development Life Cycle (SDLC) Phases such as Requirement analysis, Design, Development, Testing and Deployment of Business Intelligence and Database platforms.
- Hands on experience in publishing of various kinds of interactive dashboards, and workbooks from Tableau Desktop to Tableau Servers.
- Extensive Tableau Administrator Experience including Installation, configuration, create users, user groups, managing licenses and data connections technical support, troubleshooting, reporting and monitoring of system usage, automatic backup and schedule.
- Worked on all Tableau tools including Tableau Desktop, Tableau Public, Tableau mobile, Tableau cloud and Tableau Reader.
- Implemented on Tableau Server in multi - tier and upgrade Tableau platforms in clustered environment.
- Proficient in managing all phases of data warehouse life cycle, including requirements. gathering, analysis, preparing Business specifications, designing technical specifications, Software requirement specifications, designing and developing reports, performance tuning, testing, migrating to production and post production support.
- Experience in creating active directory users, groups, projects, Data connections, settings, granting permission to new users for particular dashboard, Scheduling Extract, Monitoring User and server Activity, managing product key.
- Good understanding of Tableau Desktop architecture for designing and developing dashboards.
- Extracting data from different sources connecting them and used the same to create dashboards.
- Very Good technical, analytical, interpersonal, presentation and leadership skills. Good experience in interaction with Business users, functional and technical team to meet the project goals deadlines.
- Strong understanding of Data Warehouse concepts, Star Schema, Snowflake Schema, Business Process Analysis, Physical and Logical data modeling.
- Highly proficient in design and development of prototype reports/ dashboards in Tableau during the requirement gathering phase to visualize
- Experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
- Sound Knowledge in database programming using SQL in Oracle, Teradata, Sybase, DB2, and SQL Server.
- Developed technical documentation of different lifecycle deliverables and user manuals.
- Proficient in Reviewing, analyzing, and evaluating business needs and user requirements.
- Experience in delivering simultaneous large-scale, mission critical projects on time.
- Ability to handle multiple tasks and work independently as well as in a team with Agile method and sprint scrum meetings system.
TECHNICAL SKILLS
Reporting Tools: Tableau Suite of Tools 10.5, 9.x/5.X which includes Desktop, Server, online and Public and Administration of Tableau Server, Crystal XcelsiusXI, Dashboad4.1, Web Intelligence 4.1/Business Objects and Crystal reports XI.
Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema ModelingSnowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer, Visio.Sharepoints.
Databases: Oracle-12C/10g/9i/7, Teradata 14.10/14/13, MS, MS SQL Server-2012, 2008, DB2, MS Access, Informex, Redshift,SAP BW/BI,SAP HANA.
SQL Programming: SQL, TSQL,MYSQL, PL/SQL
Tools: SQL Developer, Teradata SQL assistant, SQL Navigator, TOAD 7.x, MS - Visio.
PROFESSIONAL EXPERIENCE
Confidential
Business Analyst
Responsibilities:
- Extensive experience in installing, configuring, administering, and troubleshooting Tableau environment.
- Backup of application and its components configuration files Application Metadata and repository.
- Monitor the space usage, log files for any error and server usage and planning schedules.
- System performance management monitor the performance of Tableau applications.
- Support, monitor manage the high availability on Dashboards and user security.
- Upgraded new versions in all three lower and Prod and distribution servers environments.
- Configured cluster environments, take care users service requests, Incidents .
- Maintain great relationship with customers and internal clients, proactive and calm, courtesy, and confident during stressful situations to make things work in time.
- Hands on experience in query Optimization and troubleshooting etc.
- Understanding of the whole system integration project including the 3 layers of the project such as source applications), data (composite virtualization) and presentation layer (tableau visualization).
- Working with windows firewall, network and website designer teams fix issues embedded dashboard code to publish on public website.
- Created criminal and new starts dashboards in Tableau through universbridge connection.
Environment: Tableau 10.5/10.2/9.0 (Sever/Desktop), Oracle, SQL Server, SQL Assistant, SQL Server Management Studio, IBM Informix, SQL, Microsoft Office Suite ( Word, Excel, PowerPoint, Visio).
