Informatica/tableau Developer Resume
Buffalo New, YorK
SUMMARY
- 7.4 years of experience and knowledge in different phases of software development life cycle (SDLC) including analysis, design, development, testing and maintain& support.
- 3 years of Extensive experience with design and development of Tableau visualization solutions.
- Extensive experience in Tableau Desktop in various versions of Tableau (8.x/9.x/10.x) and VizQL, SQL.
- Good experience on SAP - ABAP on various domains MM, SD, HR and FI.
- Experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL.
- Experience in Tableau Desktop/Server, creating highly interactive Data Visualization Reports
- And Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.
- Created various views in Tableau (Pie Chart, Bar charts, stacked chart, Line charts, scatter plot).
- Knowledge on different type of functions like logical, Number, String, Aggregate and date functions.
- Proficient in design and development of various dashboards, reports utilizing
- Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
- Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
- Experience on create Hierarchies, Groups and Sets (Constant set & Computed set).
- Experience in creating interactive dashboards using Actions, formatting and parameters.
- Designed Dashboards with Quick filters and Parameters to handle views more efficiently.
- Created views with different axis like individual axis, Blended axis and dual axis for comparison.
- Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
- Generated context filters and used performance actions while handling huge volume of data.
- Expertise to create Dashboards and Interactive Dashboards.
- Created relationship between two different Data Source’s by using Data- blending.
- Interact with Tableau-Server to publish the data-view and scheduling the reports.
- Expertise in Agile Scrum Methodology to implement project life cycles of reports design and development
- Knowledge on ETL Informatica Power center tools Extract transforming and loading.
- Knowledge on phyton.
- Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
- Good team player with strong work ethics, desire and ability to quick learn new technologies and fast work in fast ever-changing environment.
TECHNICAL SKILLS
Business Intelligence: Tableau Desktop/server 8.x,9.x,10.x, Tableau Public
ETL Tools: ETL Informatica Power center 8.6/9.1
Data Modeling: Dimensional data modeling, Star and Snowflake Modeling, Fact and Dimensions Tables
Database: Oracle 9i/11g, SQL Server, DB2
Database Tools: TOAD, SQL Developer, SQL Plus
Environment: Windows 2008, windows 2003, XP
Languages: PL/SQL, SQL, Unix, Java, C
ERP Tool: SAP ABAP, PeopleSoft
PROFESSIONAL EXPERIENCE
Confidential, Minneapolis
Tableau Developer
Responsibilities:
- Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
- Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
- Worked extensively with Advance Analysis Actions, Calculations, Parameters, Maps, Trend Lines, Statistics and table calculations.
- Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard.
- 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 dashboards/reports.
- Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
- Used detail filters and context filters to limit the data that is to be viewed in the sheet and dashboards based on the business logic.
- Utilized Measure Name and Measure Value fields to create visualizations with multiple measures and dimensions.
- Created effective visualizations by using marks, filter and different formatting options.
- Created action button for interaction of dashboards.
- Used statistical techniques to describe data Using groups, bins, hierarchies, sorts, sets, and filters to create focused and effective visualizations.
- Extensively used Horizontal, Vertical Containers and other dashboard components to make the dashboard more interactive and to make the dashboard look pretty.
- Utilized several dashboard objects Vertical Panes, Horizontal Panes, Blank, Tiled, Floating, Text, Web-page, Image in order to create efficient dashboard using tableau desktop.
- Executed and tested required queries and reports before publishing dashboards.
- Publish the dashboards to business users through server.
Environment: Tableau (Desktop/Server) 9.x,10.x SQL Server, Oracle,Toad.
Confidential, Buffalo, New York
Tableau Developer
Responsibilities:
- Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
- Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
- Created different calculated key figures and parameters as per the user requirements.
- Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts, Line charts and Bar Charts.
- Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
- Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard.
- Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
- Used detail filters and context filters to limit the data that is to be viewed in the sheet and dashboards based on the business logic.
- Utilized Measure Name and Measure Value fields to create visualizations with multiple measures and dimensions.
- 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 dashboards/reports.
- Created effective visualizations by using marks, filter and different formatting options.
- Used statistical techniques to describe data Using groups, bins, hierarchies, sorts, sets, and filters to create focused and effective visualizations.
- Extensively used Horizontal, Vertical Containers and other dashboard components to make the dashboard more interactive and to make the dashboard look pretty.
- Utilized several dashboard objects Vertical Panes, Horizontal Panes, Blank, Tiled, Floating, Text, Web-page, Image in order to create efficient dashboard using tableau desktop.
- Executed and tested required queries and reports before publishing dashboards.
- Hands on experience in all stages of system development efforts, including requirement analysis, design, testing and implementation.
- Utilized Tableau server to publish and share the reports with the business users.
Environment: Tableau (Desktop/Server) 9.x,10.x SQL Server, Oracle.
Confidential, North Wales, PA
Tableau Developer
Responsibilities:
- Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications.
- Prepare dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
- Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs.
- 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
- Designed, Developed and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
- Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, calculations and Relationships.
- Used statistical techniques to describe data Using groups, bins, hierarchies, sorts, sets, and filters to create focused and effective visualizations.
- Used Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
- Used detail filters and context filters to limit the data that is to be viewed in the sheet and dashboards based on the business logic
- Used Sheet filters to produce multiple chart types in a single view.
- Generate context filters and use performance actions while handling huge volume of data.
- Involved in Tableau Server to publish the developed views and reports.
Environment: Tableau (Desktop/Server),8.x/9.x, SQL Server, oracle.
Confidential
Informatica/Tableau developer
Responsibilities:
- Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
- Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data.
- Consolidation, standardization for the unstructured flat file data.
- Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.5.
- Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
- Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
- Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, Joiner and Rank transformations.
- Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
- Experience in designing the data views by using tableau desktop for analyzing the users.
- Developed several worksheets filled with Bar, Line, Pie, Maps Charts and Highlight Tables for rich visualizations and analyzing of the data.
- 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 dashboards/reports.
- Used statistical techniques to describe data Using groups, bins, hierarchies, sorts, sets, and filters to create focused and effective visualizations.
- Used detail filters and context filters to limit the data that is to be viewed in the sheet and dashboards based on the business logic
- Hands on experience in all stages of system development efforts, including requirement analysis, design, testing and implementation.
Environment: ETL Informatica power center 9.5, SQL, Oracle, Tableau (desktop/server) 8.x
Confidential
Software Consultant
Responsibilities:
- Responsible for designing technical specifications based on functional specifications.
- Development of the objects as per technical specification and project standards.
- Developed the report for displaying output and sent Email of Late Coming Employee data to the manager and Employee.
- Developed the report for displaying output and sent Email of Unauthorized Absent Employee data to the manager and Employee.
- Created Standard Text though SO10 for dynamic changes.
- Enhance the HRESS B EMP LANE PROFILE UI5 BADI to show the employees attendance status.
- Enhance the BADI for Leave Encashment application validation.
- Enhance the program to update the info type 0267.
- Create WDA object for creating Deputation Application.
- Interacted with the Business Analyst for functional walk-thru.
- Unit testing.
Environment: HR Module, DDIC, Reports, Enhancements, BADI.
Confidential
ABAP Consultant
Responsibilities:
- Responsible for designing technical specifications based on functional specifications.
- Development of the objects as per technical specification and project standards.
- Developed a PR screen enhancement for work order assignment (ME51N, ME52N).
- Enhance the MIGO Badi for GR creation.
- Developed the Exit for Asset Code releasing through CJ88 transaction.
- Created Z table for saving the Work Order Details, PR Details, PO details, GR details,
- Asset Code details and MSN details.
- Created RFC for sending and fetching PR details with message and status.
- Created RFC for GR details with message and status.
- Created RFC to sending the Asset Code and getting the response.
- Worked on BAPI for upload the MSN details into standard table ANLE.
- Changing SAP-SCRIPT as per client requirement.
- Enhance the sender’s name change for ASN emails in report.
- Changed in report based on requirement.
Environment: MM & FI & SD modules, Reports, Enhancement, Badi, Function module, DDIC, Interfaces.