Report Developer/ Analyst Resume
2.00/5 (Submit Your Rating)
Morrisville North, CarolinA
SUMMARY:
- 7 years of experience in System Designing, Data Analysis, Data designing, Product development, Application Development, Maintenance Data Warehousing and data visualization using Tableau as a front - end BI tool and create visualization based on customer requirements.
- Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
- Hands on experience on Tableau Desktop versions 7 and above, Tableau Reader and Tableau Server. Involved in trouble shooting of performance issues which were associated with Tableau reports.
- Strong Dashboard design experience and passionate practitioner of effective data visualization.
- Familiarity with best practices around visualization and design.
- Capable of processing large sets of structured, semi-structured and unstructured data and supporting systems application architecture.
- Good understanding of business environment, excellent communication skill and ability to work proactively in a fast-paced environment.
- Communicate effectively with colleagues and business users.
- Over 6 years experience in Information Technology; Database Engineering Business Objects 4.1/4.0/3.x/XIR2 (IDT, UDT, BILaunchPad, SAP Lumira, SAP Mobile, Business Objects Reporting, InfoView, Report Bursting, Report Conversion Tool, CMC, DeskI/WebI, Design Studio 1.6).
- Big Data Ecosystems: Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop, Cassandra, Oozie, Flume.
- Over 5 years of strong experience in Tableau 7 and above developing, designing and modifying Business Objects Universes, Reports, & Dashboards.
- 5 Years of experience in Oracle 11g/10g/9i.
- 3 Years of experience in SQL Server 2008/2012/2014.
- Over 5 years of experience working in Agile/Scrum framework.
- Over 3 years of experience in administering BO environment.
PROFESSIONAL EXPERIENCE:
Report Developer/ Analyst
Confidential, Morrisville, North Carolina
Responsibilities:
- Facilitated project status meetings and provided weekly status reports to all stakeholders.
- Led project teams, internal and external, to achieve project defined milestones and deliverables.
- 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.
- Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
- Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
Data Analyst
Confidential, Raleigh, North Carolina
Responsibilities:
- Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
- Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
- Develop business architecture using requirements such as scope, processes, alternatives, and risks.
- Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
- Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community
- Connected Tableau server to publish dashboard to a central location for portal integration.
- Generate KPI for customer satisfaction survey results and disease management
- Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
- Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
- Experience as SQL Developer with extensive experience of analytical techniques.
- Experience in writing SQL queries and optimizing the queries.
- Performed data analysis and data profiling using SQL on various sources systems.
- Utilized Tableau server to publish and share the reports with the business users.
- Designed, developed and supported BI solutions, involved in Debugging and monitoring, and troubleshooting issues.
- Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
- Enforced Kanban principles as a scrum master that resulted in reduction of Cycle time by 20% thus increasing team's throughput in less than 8 weeks.
- Coached new SM and trained global teams, which resulted in early delivery of project and reduced process waste caused by lack of common understanding.
- Provides team leadership to ensure project tasks are completed accurately and within the time estimated.
- Ensures that project and problem solutions meet the goals and objectives of the requesting departments.
- Rally, Git, Confidential Slack,notes.
BI Data Analyst
Confidential, Tucson, AZ
Responsibilities:
- Created complex dashboards which uses BI service to feed the data into xcelsius from the source webi reports. machine utilization, compliance and quality.
- Facilitate monthly meetings with clients to document requirements and explore potential solutions.
- Draft and maintain business requirements and align them with functional and technical requirements.
- Translate stakeholder requirements into over 10 different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.
- Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
- Created extensive custom joins for blending data from several different data sources.
- Worked on workbook Permissions, Ownerships and User filters.
- Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps,Trend Lines, Statistics. Groups, hierarchies , Sets to create detail level summary report and Dashboard using KPI's.
- Designed and developed standard reports, cross-tab reports.
- Installation & configuration Of Qlikview Software.
- Provide scripting support for the Analytics Department to meet complex business requirements
- Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users.
- Data analysis, Identifying deficiencies in business systems. Modeled all the dashboards with appropriate filters for comprehensive analysis by portfolio, application and employee roles, timestamps and location.
- Built leadership dashboards using Tableau to help drive multiple focus initiatives such as First Call Resolution, and agent schedule adherence.
- Created visualization for logistics calculation and department spend analysis. Connected Tableau server with share-point portal and setup auto refresh feature.
- Developed Tableau visualizations and dashboards using Tableau Desktop.
- Conducted Study to Build Universe's Classes and Objects involving everyday terms that supports Users.
- Object properties defining Measure, Dimension and Details were created using UDT and IDT.
- Increased new product development from one to eight. Led repair of four legacy products.
- Worked with Rally, Git, Confidential Slack,note
Business Objects Developer
Confidential, Purchase, NY
Responsibilities:
- Developed reports using filters, prompts, sorts, groups, subtotals, free hand SQL and multiple data providers, worked extensively with (@aggregate aware, @prompt) to overcome the problems with database when integrating with Business Objects Gathered Reporting Requirements and arrived at the Best Reporting Model using Business Objects teams.
- Experience in creating universe using Designer for adhoc and canned queries Created Joins, checked the integrity of the universe and resolved loops and traps using aliases and contexts.
- Set up aliases, contexts and short cuts joins by resolving loops, cardinalities and integrity checks of the universe, set up Aggregate Awareness to enhance the performance of SQL transactions.
- Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
- Worked on Teradata dual active systems project.
- Hierarchies created based on business rules for viewing data at selected level of detail.
- Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
- Extensively worked with alerts, filters and conditions in Business Objects.
- Designed universe for standard reporting and ad hoc reporting requirements. Involved in the extensive standards & guidelines documentation.
- Reviewed and verified technical specification to meet user requirement and approved architectural and design documents.
- Managed application development of an automated Medicare reimbursement posting system in an Oracle 9i, 10,11.
- Drafted Technical Design Documentation for the reports created as part of dashboard design.
Business objects developer
Confidential, Birmingham, AL
Responsibilities:
- Dashboards Using Advanced Multiple Drills Down, Dynamic Visibility, and Alert Features were designed to support Complex Requirement Scenario.
- Analyzing system functionality requirements, documents and scope of the work. Created webi reports from multiple sources & functionalities like slice & dice, drill down.
- Have resolved loops, Fan Traps and Chasm traps using context and alias and also have built custom hierarchies and predefined filters to facilitate easy drill down and addressed performance issues.
- Formatted Reports as per the User requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
- Developed Information Space’s in SAP Explorer for proof of concept as an alternative tool for rapid BA analysis.
- Used third party portal systems to deploy dashboards for end user and used EIC connections to send values from one portal to another. ensure that correct results are retrieved.
- Created Webi reports using Combined Query, Multiple Query, and Query-on-Query logic.
- Created Webi reports using complex functions, report context, and OpenDoc techniques to achieve desired formatted results.
- Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.