Information

Name:

Danish Asghar

Position

(IT Analyst)

Job Title:

Business Analyst

Cell

240-***-****

Email

ad12hw@r.postjobfree.com

Introduction

I have 2 plus years of experience in IT industry as Business Analyst and BI with strong background in Databases and Data warehousing concepts. I have experience in different parts of SDLC process and complete understanding. Within the SDLC process I do have very strong understanding and hands on work experience with Agile. I have been responsible for creating and maintaining the product backlog gathering requirement from stakeholders and creating user stories and making sure the sprints are running smoothly and supporting the team throughout the sprint planning and organizing the sprint reviews, and communicating business requirements to the IT teams. Expertise in Tableau /10.1/10.0/9.3/9.2, Tableau Server, Tableau Online, Tableau Public, Tableau Reader. Experience in connecting tableau to various other data sources like Hive, Teradata, Oracle and experience in establishing respective driver connections and worked on creating schemas. Experience in performance tuning for the Tableau Visualizations and Tableau server. Experience in create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.

Professional SUMMARY:

2 years of experience in IT industry as a Business Anaylist and Business Intelligence with strong background in Databases and Data warehousing concepts

In-depth knowledge of system development life-cycle, project planning techniques and information modeling techniques

Expertise in all phases of data warehousing lifecycle along with implementation and testing of software products

Advance technical knowledge with good understanding of business processes

Good communicator, excellent interpersonal skills and ability to work effectively with less supervision

1 year of experience in performing data queries and generating timely reports on all weekly, daily, monthly basis

Experience in using Tableau’s flexible commands to build an application with options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like Finance, Sales, Marketing and HR

In and out knowledge of all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.

Expertise in using statistical techniques to generate reports that maintain compliance with industry standards. Experience in planning Disaster Recovery in Tableau Server

Worked on several interactive dashboards with Filtering, highlighting and an ability to combine multiple data sources

Experience in using SQL for tableau and in writing queries for generating tabular reports, formatting report layout and expressions

Created interactive, real-time dashboards customizations. Created data models for tableau

Created calculated fields to interact with parameters dynamically to visualize the data

Created sets and used them in the calculated fields to retrieve the specific data by combining multiple sets. Setup and configuration of Tableau server 10.0/9.2 in various environments

TECHNICAL SKILLS:

Software

Tableau Desktop 10./9.3/9.2, Tableau reader,

Tableau Public

Operating Systems

Windows XP/2000/Vista

Databases

MS Access, MS SQL Server, Oracle 10g/11g PL/SQL.

Project Management Tools

MS Office, MS Project, JIRA

Methodologies

Waterfall, Agile

Design Tools

MS Visio, Dynamics CRM,

PROFESSIONAL Experience:

Capital One Jan20, 2017 – Aug26, 2017

Tableau Consultant

Responsibilities:

Experience in designing and development of Tableau visualization solutions

Experience in setting up and configuring Tableau server 9.3 in various environments

Worked on creating interactive, real-time dashboards

Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet

Expertise in Tableau 10.0. Used joins to join multiple data sources in Tableau 10.0

Published Tableau dashboard on Tableau Server and embedded them into portal

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Created Business requirement documents for creating dashboards

Experience in creating New Schedules and checking the tasks daily on the server

Experience in working extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps

Worked on connecting tableau to various other data sources like Teradata, Oracle and experience in establishing respective driver connections.

Experience in creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality

Expertise in creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau

Interacted with Business Analysts and Data Modelers to understand the requirements and defined Mapping documents and Design process for various Sources and Targets

Defined best practices for Tableau report development and effectively used data blending feature in tableau

Created organized, customized analysis and visualized projects and dashboards to present to the High Level Management

Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently

Good SQL reporting skills with an ability to write SQL queries and create SQL views

Involved as a technical expert providing input to application design regarding performance tuning and administration requirements.

Rewrote and customized SQL queries to map data for better performance.

Created scripts to create new tables, views, for new enhancement in the application

Created indexes on the for faster retrieval of the data to enhance performance

Created databases objects like tables, views, materialized views, procedures and packages using PL/Sql.

Geico Insurance Mar10, 2014 – Nov07, 2015

Guidewire BA/Consultant

Responsibilities:

Developed and maintained effective relationships with business partners to understand their needs, develop solutions, and assisted in end-user training.

Responsible for requirements gathering using JAD sessions, personal and group discussion, analysis, detailed process flow design, user acceptance testing and rollout of new & modified feature functionality deployed on the e-commerce website applications.

Experience in Merchandising, Pricing, Campaign Management.

Utilized Agile Software Development Methodology using tools, Rally.

Worked on Agile/ SCRUM technology and participated in demos at various sprints.

Prepared interview questionnaires for the clients to gather requirements and prepared Functional Specifications and User Requirements.

Developed mockups, wireframe and User Interface (UI) to create exact scenarios of new application.

Participated in reviews of RFP from external vendors and wireframe screens for new Order Management System.

Worked with the project manager to estimate best/worst case scenarios, track progress with weekly estimates of remaining work to do, conducted informal meetings.

Worked with the project manager for planning and organizing the project activities, and in communicating with other business center mangers and stakeholders of the project.

Identified issues associated with each line of business and created and maintained an issue log with action items which was a key document for meeting the deadlines in the project.

Suggested fine tuning in requirements and as-is system based on Analysis of available data and discussions with support groups.

Analyzed business requirements and their feasibility in areas such as timelines, technical, implementation aspects, and was responsible for communicating back to business.

Proposed and prepared a template for storing e-mails exchanged by the Product Analysts, Underwriters, & Business Analysts for easy reference and retrieval of information in preparing requirements document.

Handled change management requests by preparing and maintaining different versions of the document and effectively delivering the newer versions for reviews and sign offs well before deadlines.

Responsible for writing Business Use Cases, Business Rules, logical analysis and change management of requirements.

Effectively mad use of Tables Functions, indexes, table partitioning, collections, and analytical functions

Data modeling using normalizing techniques.

Created packages and procedures to automatically drop table indexes and create indexes for the tables.

Use data dictionary to filter out key components

Adhvan Corp March 2011-Nov2011

SQL Developer Internship

Germantown, MD

Developed stored procedures for data processing requirements using PLSQL.

Developed database triggers and functions as per the solution design document.

Developed a working knowledge in Oracle cursor management and exception handling

Used performance enhancing features like direct-path inserts, bulk collections and inserts, PLSQL collections, parallel operations, SQL query hints

Use of advanced SQL techniques like start-with-connect-by for hierarchical relationships, max-over- partition-by queries

Developed code as per the company established coding standards and security guidelines

Involved in the support, maintenance, and production support of the rolled out code and applications

Worked with the DBA’s to undertake stress testing of the application and the queries and recommend optimization techniques. Participated in design discussions to support project and baseline work.

Worked with application DBA staff to develop database design that would help with optimal query execution

Created and managed users, roles and profiles, audited and monitored databases and user access

EDUCATION:

Strayer University

Bachelors in information systems with software engineering

ITT Technical Institute, USA

Associates Degree in Computer and Electronics Engineering Technology (CEET)

Watkins Mill High School, Maryland, USA

High School Diploma

Contact this candidate