We provide IT Staff Augmentation Services!

Reporting Analyst Resume

Cincinnati, OH

SUMMARY:

  • Over 6 Years of IT experience in ETL, Business Intelligence, Business Architecture, Data Warehousing, and Web based, Client/Server applications in Development, testing and implementation in various domain such as Insurance, Banking and Retail industries.
  • Extensive experience in Data Modelling, Data Profiling, Data Integration, Data Migration and Data Mining.
  • Experience in SQL Queries, E - R and Dimensional Model, Star/Snow Flake Schema design, Modelling dimensions, hierarchies and facts, Database Architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
  • Expert in Tableau 6.x/7.x/8.x/9.x/10.x (Desktop, Server, Mobile, Public), Tableau Desktop, Tableau Reader and Tableau Server and Experience including analysis, modeling, design, and development of Tableau reports and Created dashboards by using Level of Detail concept (LOD’s)
  • Extensive experience in creating several reports such as drill down, drill through reports, parameterized reports, linked reports, Heat Maps, Bar Charts, Line Charts, Histograms, Tree maps, Pie-Charts, Dual Charts, Action Dashboards and cascading reports using Tableau
  • Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms
  • Experience in configuring reports from different data sources using data blending
  • Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security
  • 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
  • Expertise in Teradata, Oracle, SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), UNIX, Microsoft Office Suite
  • Proficient in Building compelling, interactive dashboards in Tableau that answer key business questions using calculations, parameters, calculated fields, groups, sets and hierarchies.
  • Developed reports using Advance Analytics like Reference Lines, Reference Bands, Trend Lines, Box plots and Custom Geocoding.
  • Proficient in using SQL for developing complex Stored Procedures, Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
  • Experience in developing source to target Mapping Document for migration and Data Transformation documents for the development team to facilitate the development of interfaces.
  • Proficient in writing SQL queries to perform data driven tests and involved in front-end and back-end testing.
  • Experience in performing Data Analysis and Data Validations to ensure the Data is as per Business needs.
  • Experience in creating various kinds of reports like Parameterized, Cached, Drill through, Drill down, Sub reports in SSRS.
  • Familiar with SSIS Packages - Dataflow, Control flow items and SQL Import/Export wizard operations to move Data between different Sources.
  • Experience in Requirement Gathering Methodologies with complete end to end participation in all areas of Software Development Life Cycle (SDLC) which includes traditional Waterfall and Agile (SCRUM) and Expertise in preparing Business Requirements Document (BRD), Software Requirements Specification (SRS), Functional Specifications Document (FSD) and assisting in developing test plans.

TECHNICAL SKILLS:

Microsoft SQL Server 2005/2008/2008 : R2, 2012/2014/2016 SQL Server Management Studio (SSMS), Netezza, SQL Server Business Intelligence Development Studio(BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Oracle 8i/9i/10g/11g, MySQL, IBM CastIron, Business Objects, MS-Access, MS-Excel, SQL, T-SQL,IBM DB2, HTML, DHTML, ASP, ASP.NET, XML, Visual Studio 2005/2008/2012/2015 , SQL Profiler, ERWIN, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, CINCINNATI, OH

REPORTING ANALYST

Responsibilities:

  • Created Rich dashboards using Tableau to show the KPI Summary of different metrics and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
  • Designed, developed, tested and maintained Tableau functional reports based on user requirements.
  • Worked with AQT to query the data from database IBM DB2.
  • Mastered the ability to design and deploy rich dashboards with Drill down and Drop down menu and parameters using Tableau.
  • Involved in creating database objects like tables Views, Procedures, Triggers functions using SQL to provide definition structure and to maintain data efficiently.
  • Extensively involved in creating Graphic visualizations using measures and dimensions data from multiple data sources by using data blending.
  • Created different KPI using calculated key figures and parameters.
  • Used LOD’s in development of different Tableau reports.
  • Developed Tableau data visualizations using Cross tabs, Heat maps, Box and whisker plots Geographic chart and Density chart.
  • Developed donut charts and implemented complex features like creating visualizations in tool tips.
  • Worked extensively with advance analysis actions, trend lines to the product performance and statistics.
  • Responsible for creating automated refresh schedules for the daily analysis of product performance.
  • Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
  • Provided production support to Tableau users and had written custom SQL to satisfy business requirements.
  • Involved in creating dual axis charts to show fidelities of the product.
  • Created combined fields, bins, sets, geo coding and hierarchies using Tableau desktop.
  • Developed rolling filters to show the quarterly data of each profit center of Bank.
  • Worked closely with the Consumer Analytics Business team to provide data across the different Bankers.
  • Created certain Action Filters driving from one dashboard to the other dashboard to understand the complete book of Business.

Confidential, BETHESDA, MD

Tableau / BI DEVELOPER

Responsibilities:

  • Generate KPIs for customer satisfaction survey results and disease management.
  • Connected Tableau server to publish dashboard to a central location for portal integration.
  • Connected Tableau server with share-point portal and setup auto refresh feature.
  • Created visualization for logistics calculation and department spend analysis.
  • Developed reports from the client perspective and demoed to the Stakeholders in explaining the functionality and the filters which can be applied according to the business development.
  • Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
  • Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Extracting data from different sources connecting them and used the same to create dashboard
  • Worked extensively with the Mobile Application data comparing with Mobile Browser data.
  • Analyzed and reported monthly business performance against forecasted sales goals.
  • Involved in collecting Business Intelligence reporting data from managers, staff across divisions and across geographies.
  • Responsible for weekly and monthly statistics reports.
  • Used Web Trends and Omniture, web site analysis tools to develop Mobile Application and Website performance reporting.
  • Worked with Adobe Analytics to satisfy different ad hoc requests.
  • Created different segments which helps in retrieving data more efficiently.
  • Preparing statistical analysis and updating analyzed training reports.
  • Dealt with site catalyst Adobe debugger, developed new codes and tags.
  • Developed multiple Adobe reports on a recurring basis to show the trend of different metrics which helps in making business decisions.
  • Had written many custom SQL queries to run the recurring reports in a timely manner.
  • Used Netezza which is compatible with both, Business Intelligence and analytic tools.
  • Assessed the data from Netezza environment using Aginity Workbench/ Win SQL for implementation of Business reports.
  • Optimize queries and ETL to improve the performance of data delivery.
  • Had been part of data integration from Netezza to Analysis Workspace.
  • Experience on working around SQL on Hadoop technology Aginity Workbench (Hadoop).

ENVIRONMENT: WinSQL Lite - Netezza 6.x/7.x, Analysis Workspace, Adobe Analytics, Tableau 10.5, Excel, Aginity Workbench (Hadoop), Aginity Workbench (Netezza).

Confidential, VIENNA, VA

Tableau Developer/ BI Data Analyst

  • Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
  • Created data blending in case of merging two different datasets.
  • Interacted professionally with a diverse group including executives, managers.
  • Designed the Conceptual and Physical Data Models, as well as the major components of the user Created and assisted users in Tableau dashboard development
  • Responsible for the full data life cycle from Business requirements analysis and data feed definition to data mapping and feed validations.
  • Worked with users to Organize, Analyze and document Business requirements for reports, and relevant workflows.
  • Worked extensively on Data Quality (running Data Profiling, Examine Profile outcome); Metadata management (loading metadata, mapping metadata, or perform data linkage)
  • Loaded data from flat data files into SQL Server 2014/2008 Database tables using Import/Export wizard, SSIS and CastIron tools.
  • Designed SSIS package that extract Financial Data from a SQL Server Database by using Lookup task, for each Loop Container. Used the slowly changing dimension task and its accompanying wizard to load a new dimension.
  • Built different kind of reports using SSRS like parameterized reports, Ad hoc reports, Drilldown reports and Drill through report.
  • Create adhoc Excel Reports for Business and Finance Team, perform Pivoting, Data calculations.
  • Extensively involved in Data Analysis, Data Cleansing, Requirements gathering, Business Analysis, Data Mapping, Entity Relationship diagrams (ERD), Architectural design docs, Functional and Technical design docs, and Process Flow diagrams
  • Written several SQL statements to confirm successful data transfers between source and target.
  • Written Transact-SQL statements that use joins or sub queries to combine data from multiple tables.

ENVIRONMENT: Windows Server 2010, IBM CastIron, SQL Server 2016/2014/2008 , MS Office, IIS7, MS SharePoint Server 2010/2007, SQL Reporting Services, Microsoft Visual Studio 2013/2012, SSDT, SSIS, Tortoise SVN.

Confidential, Greenbelt, MD

Tableau Developer/ BI Data Analyst

Responsibilities:

  • Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
  • Expert in info graphics and Dash boarding for data visualization.
  • Interact professionally with diverse group of professionals in the organization including managers and executives.
  • Experience in standardizing Tableau for shared service deployment.
  • Extensively used data blending, embed functionalities in Tableau.
  • Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Defined best practices for Tableau report development.
  • Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
  • Provided 24/7 production support for Tableau users.
  • Experience in providing Tableau server and tableau desktop training.
  • Installed drivers for the Teradata and upgraded ODBC drivers to 13.00.00.01 for better performance.

ENVIRONMENT: Tableau Server v6/v7, Tableau Desktop v6/v7, Windows Server Standard R2, Clear quest, Clearcase, Oracle, Info view, Excel, TSQL, UNIX

Confidential, Owing Mills, MD

BI Data Analyst / Tableau Developer

Responsibilities:

  • Gathered Business Requirements, interacted with the Business Users, Project Manager to get a better understanding of the Business Processes.
  • Involved in Exploring, Designing, Building, and Deployment of the high-level dashboards for Board of Directors, Decision makers for critical metrics using Tableau.
  • Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
  • Coordinating and conducting business, systems requirements analysis meetings with business and technology partners, business analysts, data modelers, solution architects, DBA's and project managers.
  • Created Filter and URL actions to navigate from the Executive Dashboard to the Detail Report and implemented the back button logic to navigate back to it.
  • Developed dashboards using calculated fields with different logics for trends, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Worked extensively with Advance Analysis using LOD expressions, Scatter plots, Box plots, Background images, Maps, Trend Lines and log Axes, groups, hierarchies and sets to create detail level summary report and Dashboard using KPI's.
  • Involved in Design and development of test plans based on high-level and detailed designs.
  • Tested the ETL business logic for different feeds and checking the log files for data counts.
  • Responsible for different Data mapping activities from Source systems to SQL Server.
  • Performed List import activities to ensure data availability for direct marketing staff.
  • Involved in list importation procedures and audit testing using SQL programming skills.
  • Troubleshooting and problem solving all SQL development.
  • Read data from Flat files, Excel files to SQL Server tables by using SSIS.
  • Assist Development Team with Data Integration Processes for Business from different Systems like SQL, NetSuite, Certain, using Cast Iron Integration Appliance.
  • Gather Business requirements for reports development.
  • Involved in making of technical specifications for Financial and Budget reports development.
  • Developed Reports using SQL Server Reporting Services
  • Documentation of all modules for user level and system level maintenance.

ENVIRONMENT: Windows Server 2008R2, 2003, IIS7, SQL Server 2008, MS SharePoint Server 2007, SSRS, SSIS, MS Office.

Confidential

Business Data Analyst

Responsibilities:

  • Served on project teams throughout the requirements phase of a critical regulatory project to assist the senior BA’s.
  • Participated in all aspects of Requirements Definition including gathering and eliciting requirements, scribed and published meeting minutes, and tracked project issues and open items with business partners and stakeholders
  • Created process flow maps & Entity Relationship (E-R) diagrams for the project using Microsoft Visio.
  • Gathered business requirements, leaded effort and worked hard to understand the business processes from SME’s to create a new repository on SharePoint site to enhance interdepartmental communication
  • Assisted in gathering training material, created an online Training Survey and analyzed the survey to make recommendations for an improvement in the organization
  • Supported a Global Reference Data group focused on Client Onboarding and Client Data
  • Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues
  • Summarized reports for Management in Excel. Setup documents with macros.
  • Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio and MS Word
  • Developed and optimized convoluted stored procedures, scripts, Extraction Transformation and Load (ETL) process and database objects
  • Actively involved in performance tuning at source, transformation, target and workflow levels
  • Designed and developed data mappings based on the business requirements and business rules
  • Developed business process models in Agile to document existing and future business processes
  • Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
  • Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio

ENVIRONMENT: SQL/Server, Oracle10&11g, MS-Office, ER Studio, XML.

Hire Now