We provide IT Staff Augmentation Services!

Business Analyst Resume

Philadelphia, PA

SUMMARY:

  • 9+ years of IT experience in Business Analysis, System Analysis, Data analysis, Software Design, Development, Implementation and Maintenance of Business Intelligence and Data Warehousing Platforms across Airline Services, Banking, Retail, Insurance and Technology domains.
  • Over 5 years of Tableau Experience in enterprise environment including report / dashboard design, development, maintenance and support using various versions (10.x/9.x/8.x/7.x) of Tableau Desktop and Tableau Server.
  • Highly Proficient in Agile, Iterative, and Waterfall software development life cycles.
  • Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
  • Expert in Data Visualization, Data Analysis, Business Intelligence, IT Analysis/Design, and Client/Server System Architecture.
  • In depth understanding of the Gap Analysis i.e., As - Is and To-Be business processes and strong experience in gathering requirements and converting these requirements into Technical Specifications documents.
  • Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, line diagrams, pareto charts, funnel charts, scatter plots, pie-charts, donut charts, bubble charts, funnel charts, heat maps, tree maps according to the end user requirements.
  • Expertise in using advance Tableau features like Calculated fields, Sets, Groups, Parameters, context filters, quick filter, global filters, custom geo coding, Actions, LOD, Adhoc Calculations, etc.
  • Integrated Tableau into Front-End Web Application using JavaScript API to call parameters and filters as well as individual sheets.
  • Expertise in designing and developing analytical reports, dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data by integrating data from multiple sources and help users to identify critical KPIs and facilitate strategic planning in the organization.
  • Proficient in analysis, design and implementation of data warehousing/ BI solutions using Tableau,Alteryx, Informatica, MicroStrategy, Tableau and Database technologies.
  • Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
  • Hands-on experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling.
  • Posses’ strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
  • Adept in analyzing bugs, interacting with team members in fixing errors and User Acceptance Testing (UAT) and also assisted in Post - Production support.
  • Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.
  • Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Analytical Tools: Tableau 10.x, 9.x, 8.x, 7.x (Desktop/Server/Reader/Public/Online), MicroStrategy (Desktop/Server), Google Analytics (Adobe Site Catalyst), SSRS.

Data Integration (ETL) Tools: Alteryx, Informatica, MS SQL Server Integrated Service (SSIS),OBIEE

Data Modeling /UML Tools: Power Designer, ERwin, MS Office ( Visio, Word, Excel)

RDBMS: Teradata, Oracle, MS SQL Server, DB2, Sybase, Access,Hadoop

SQL Tools: Teradata SQL Assistant, PL/SQL Developer, Toad, SQL Server Management Studio

Service Management: CA Service desk, Lotus Notes

Document Management: SharePoint, Documentum

UI Tools: CICS, ROSE, PUTTY, Visible Analyst, Lotus Notes

Defect management tool: Mercury Test Director, HP Quality center

Scripting Languages: C, C++, HTML, JavaScript, Python, PERL, SQL, PL/SQL, and XML

Scheduling Tools: AutoSys, Control M

Operating Systems: UNIX, Linux, Windows 8/ 7/XP/2000

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia,PA

Business Analyst

Responsibilities:

  • Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
  • Performed data analysis and data profiling using SQL on various sources systems including Oracle and Teradata
  • Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
  • Creating customized Tableau Dashboards, integrating Custom SQL from Teradata and Oracle, Hadoop and performing data blending in reports.
  • Designed, developed, tested, and maintained Tableau reports and dashboards based on user requirements.
  • Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
  • Mastered the ability to design and deploy rich visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
  • Created Complex calculated fields in getting Turn Around Time and Aging of the devices as per business requirement for the given time frame.
  • Created side by side bars, Scatter Plots, Stacked Bars, Filled Maps and Symbol Maps according to deliverable specifications.
  • Actively involved in the creation of users, groups, projects, workbooks and the appropriate
  • Involved in Performance Tuning of the database which included creating indexes, optimizing SQL statements and monitoring the server.

Environment: Tableau 10.x/9.x(Desktop/ Server), Erwin 9.1, Teradata, Teradata SQL Assistant, Oracle 11g, Hadoop, VISIO, JIRA, MS Office Suite (Word, Excel, PowerPoint).

Confidential, Chicago, IL

Sr. Business Analyst/Sr. Data Developer

Responsibilities:

  • Involved in full project lifecycle of SDLC and coordinated with all project teams.
  • Interacted with Subject Matter Experts & End Users and gathered business requirements.
  • Acted as liaison between Business Intelligence and Business User groups to relay change requests.
  • Performed extensive GAP analysis in the project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
  • Worked in coordination with clients for feasibility study of the project in Tableau and with DB Teams for designing the database as per project requirement.
  • Created Users, Groups and projects in Tableau environment.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Gathered data from different data sources like MySQL, Excel, Oracle, MSSQL, Hadoop and Hive etc.
  • Created extracts and scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
  • Used different Mark types and Mark properties in views to provide better insights into large datasets.
  • Developed dashboards with interactive views, drill downs, and published them to the portal with user level security.
  • Utilized advance features of Tableau software like to link data from different sources together on one dashboard and to filter data in multiple views at once.
  • Built complex calculations using advance functions (ATTR, LOD, DATEDIFF, Ifs, Nested Ifs, RANK DENSE, OR, NOT, AND, and Quick Table calculations).
  • Created Heat Map showing sales data by color that were broken into regions allowing business user to understand sales pattern (least vs. highest) in various regions.
  • Developed various reports using Tableau features like Parameters, Filters, Sets, Groups, Actions, etc. to present users with various scenarios of predictive analysis.
  • Generated guided navigation links for Interactive dashboards in Tableau.
  • Developed reports to analyze multiple measures using Blended Axes, and Dual Axes.
  • Created and updated custom SQL scripts to serve as data sources for various reports and handled performance issues effectively.
  • Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
  • Oversee the performance of Design to develop technical solutions from Analysis documents.
  • Provided post implementation production support.

Environment: Tableau 9.x/8.x (Desktop/ Server), Alteryx, Teradata, Oracle, SQL Server, Hadoop, SSIS, VISIO, MS Office Suite (Word, Excel, PowerPoint).

Confidential

Sr.Data Analyst/Sr. Tableau Developer

Responsibilities:

  • Oversee the performance of Design to develop technical solutions from Analysis documents.
  • Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Analyzed the source systems and created Business Requirement Document (BRD).
  • Designed data marts to accommodate views/tables (AGG tables) with various calculated metrics from DW (Fact & Dimension) data to suffice source needs for Tableau reporting.
  • Created Data Flow Diagrams (DFDs) to define flow of data through the system and to create overview of reporting database layers/ data marts.
  • Extracted digital marketing data from Adobe Marketing Cloud in Tableau Data Extract (TDE) format by connecting to Adobe Site Catalyst for developing Business Intelligence dashboards.
  • Used Data Blending, Groups, combine Adobe Marketing Cloud data and other aggregated data, spotlight into compare and analyze data in different perspective.
  • Created best visualizations reports as per the business requirements using Tableau desktop professional edition.
  • Designed and developed Tableau visualization solutions by connecting to Google Analytics, Oracle and SQL databases.
  • Developed custom SQL connections and calculated fields within Tableau to facilitate automated production of data visualizations.
  • Used JavaScript API to set and create filters, select and highlight elements in the view, and process the view to retrieve updated data.
  • Enabled tableau Actions to drill down from Dashboard to worksheet.
  • Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
  • Designed and developed trend reports including forecast and trend lines.
  • Configured incremental data refresh for the data sources.
  • Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
  • Mentored power users to blend Google Analytics data and Offline data.
  • Background in installing and upgrading of Tableau server and server performance tuning for optimization.
  • Responsible for authorizing the users based on their privileges.
  • Involved in migration activities related to Tableau across the environments.
  • Designed filters, power prompts, and complex financial calculations for various analytical reports.
  • Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.
  • Established, maintained and ensured adherence to application standards for data reporting.

Environment:: Tableau 8.x(Desktop/Tableau server), Alteryx, Google Analytics, SQL developer, SQL 2008, Oracle, MS Access, Windows 2007 server, Java 1.5 platform, Microsoft office Suite (Office, Excel, PowerPoint)

Confidential, Chicago, IL

Data Analyst/Tableau Developer

Responsibilities:

  • Worked closely with the business users to identify various KPI’s and designed solutions to enhance business decision-making.
  • Involved in System Analysis & Design of the Enterprise Data Visualization Architecture.
  • Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
  • Developing and maintaining high level overview of the data flows using MS Visio
  • Thoroughly analyzed the current Architecture, databases and designed schemas on campaign data, the tables/views of which are used as data sources for Tableau reporting
  • Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
  • Involved in Extraction, Transforming and Loading (ETL) data flows to creating mappings/workflows to extract data from Flat File sources and load into DW environment.
  • Developed and modified Business Intelligence analytical reports/ dashboards using Tableau Desktop.
  • Created Executive Dashboard sourcing heterogeneous sources extracting huge records with decent performance.
  • Used Tableau URL Actions to navigate from the main Dashboard to detail Reports.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
  • Developed and published customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
  • Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
  • Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
  • Defined best practices for Tableau report development.
  • Created ad-hoc SQL queries for customer reports, executive management reports.

Environment:: Tableau 8.x/7.x (Desktop/ Server), Teradata, Teradata SQL Assistant, MS SQL Server, SQL, PL/SQL, SQL Developer, Control-M, MS Visio, MS Project, MS Office ( Word, excel, PowerPoint)

Confidential, Franklin Park, IL

Data Analyst/Tableau Developer

Responsibilities:

  • Acted as liaison between Business Intelligence and Business User groups to relay change requests.
  • Conducted Requirement walk-through meetings with key stakeholders.
  • Performed detailed requirement analysis and created data mapping documents
  • Performed extensive GAP analysis in the project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
  • Oversee the performance of Design to develop technical solutions from Analysis documents.
  • Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
  • Actively participated in Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
  • Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
  • Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
  • Mentored business power users to create reports/dashboards using tableau desktop.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
  • Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
  • Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
  • Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
  • Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
  • Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
  • Scheduled frequency and time to refresh data for the when sources are publishing or extracted to server.
  • Design and development of various reports and dashboards that can be easily accessible through Tableau App in iPads, iPhones, and other smart mobile phones.
  • Built complex SQL queries to validate ETL/Reporting code in Teradata and Oracle.
  • Monitoring the project during Development phase and involved in User acceptance testing (UAT) once the change requests are released from system testing.
  • Developed test cases and test plans for unit and system tests for new or modified programs and job streams.
  • Involved and guided/mentored other team members in their problem-solving efforts.

Environment: Tableau 8.x/7.x (Desktop/Server), Teradata 12/13, Oracle 10g/11g, Informatica 8/9, Power Designer, TOAD, Micro Strategy 8/9, Autosys, UNIX, MS VISIO, MS Office.

Confidential

Data Analyst /Business Systems Analyst

Responsibilities:

  • Worked with end users to gain an understanding of information and core data concepts behind their business.
  • Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.
  • Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
  • Worked on claims data and extracted data from various sources such as flat files, Oracle and Mainframes.
  • Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
  • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
  • Extensively used Informatica Power Designer to pull the data from various data bases and integrate the data.
  • Design, Create and Monitor workflows using workflow designer and workflow monitor.
  • Performed data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
  • Written SQL scripts to test the mappings and developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
  • Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
  • Identify & record defects with required information for issue to be reproduced by development team.

Environment: Teradata, Oracle, PL/SQL, SQL Server 2008, MS SQL, Informatica, MicroStrategy, ErwinDB2, HP Open View, Lotus Notes, Windows XP, MS Office Suite (Word, Excel, PowerPoint).

Confidential

SQL BI Analyst / Developer

Responsibilities:

  • Created and/or strengthen systems for data collection, management, reporting and analysis. Advised the agency on technology needs to maximize efficiency and support a culture of managing to data
  • Assisted in the creation and documentation of the business processes for data collection, entry, reporting, review and use of data to strengthen performance management
  • Implemented logical and physical data modeling
  • Developed PL/SQL stored procedures for the end-user report requirements
  • Created crystal reports on the stored procedures and exported the Business Objects reports to WEBI, to be viewed by all users on the intranet and extranet
  • Created many simple, complex and adhoc reports using Crystal reports as main data providers and having the Powerful functionalities like @functions and formulae.
  • Created queries for multidimensional analysis using slice, dice and drill modes
  • Created SSIS packages to load data from Oracle to Sql Server using various transformations in SSIS
  • Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views)
  • Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views)
  • Identified the dimension, fact tables and designed the data warehouse using star schema
  • SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
  • Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
  • Created report snapshots to improve the performance of SSRS
  • Migrated database from SQL server 2000 to SQL server 2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures

Environment: Windows XP/2000 Advance Server, SQL Server 2000/2005, SSIS, SSRS, Crystal Reports, Web Intelligence, InfoView, MS Excel, MS Word, MS PowerPoint, Windows 2000/2003.

Hire Now