We provide IT Staff Augmentation Services!

Senior Reports Developer Resume

SUMMARY

  • 8 Years of experience in Business intelligence application design, development of various data warehousing projects using Tibco Spotfire and Tableau.
  • Experience with creating Complex Spotfire Dashboards, Maintaining the existing Dashboards, Reports and Administration activities
  • Expertise in SDLC Process that involves Requirements gathering, data analysis, prototype design and deploying the dashboards/Solutions into Production.
  • Expert in designing Spotfire dashboards / reports with complex multiples data sources (SQL, Excel, Flat files) relational design and optimizing applications.
  • Created multiple visualizations, calculated columns, Custom expressions and drill down techniques for detail analysis. Utilized features such as multiple tables, visualizations, drill down and other analytics reporting and analysis tools to deliver business insights.
  • Experience in creating the complex functions inTERR/R and good experience in creating webforms using HTML, Python and Java Script.
  • Worked on designing dashboard / reports /and Build KPI metrics that give better understanding of data and outliers and professional looks using TIBCO Spotfire Professional. Expertise in Data Warehouse and Database development skills using Oracle SQL, Teradata, MS SQL Server and Netezza. Created Complex Information Links to pull the data from Oracle 10g/11g, SQL Server, and Flat files and SAS datasets.
  • Developed reports using Spotfire Professional and published the same to Spotfire Server for Business Users use. Designed and deployed reports with Drill Down, Drill Through and Drop - down menu option and Parameterized and Linked reports using Spotfire
  • Capable of Understanding the business environment and translate business requirements into technical Specifications.

TECHNICAL SKILLS

Operating Systems: MS Windows 2000, XP, Vista, MS 2003 server, UNIX

Language: SQL, Iron Python, R, JavaScript, HTML and XML

Spotfire: Spotfire professional 5.0, 6.5, Spotfire Professional 7.6,7.8,10.3,Spotfire web player

Business Intelligence: Tableau 5.0,6.0,10.3,10.5

Databases: Oracle 9i/11g, SQL Server 2005/2008, MS-Access, IBM Netezza, DB2

Other Technologies: Visio, MS Office (Word, Excel, PowerPoint, Project, and Outlook).

PROFESSIONAL EXPERIENCE

Confidential

Senior Reports Developer

Responsibilities:

  • Gathered Requirements from Business users, analyze the requirements, perform data analysis, create wireframes and build complex Spotfire and Power BI Dashboards.
  • Created data sources, Columns, Joins, Filters and Information links using Information designer.
  • Created Complex Visualizations Bar Charts, Line Charts, Combination Charts, Tree Maps, Pie Charts etc.
  • Involved in migrating the dashboards from Development to Production environments.
  • Creating Visualizations using Text Areas, Input Fields, Property Controls, Document properties, using Prompts and calculated columns and custom expressions etc.
  • Used POWER BI, Power Pivot to develop data analysis prototype, and used power view and Power Map to visualize reports.
  • Created DAX expressions to create computed columns and tables in Power BI.
  • Worked on data import and direct query in Power BI.
  • Created data transformations like data append, merge, split columns, calculated columns, measures etc and models.
  • Worked on data import and direct query in Power BI.
  • Created parameters and used on - premises data gate ways in Power BI Service to schedule the Power BI Reports/Datasets.
  • Used POWER BI, Power Pivot to develop data analysis prototype, and used power view and Power Map to visualize reports.
  • Published power BI reports into the server to be used for business users online.
  • Converted existing reports into Power BI.
  • Created Information Links for many databases for populating data into Visualization from underlying databases such as Teradata, MS SQL Server and Oracle etc.
  • Created measures and customized columns in Power Bi direct query.
  • Set up incremental refresh to auto refresh reports in import query whenever the new data hits
  • Implemented Row level Security in Power BI.
  • Created KPI Dashboards that tells a story on the Inventory, Documents Reviews, Bookings and Applications Information.
  • Trained Business users on the Report Usage and make them to use more automated reporting services than excel reports.

Environment: Power BI Desktop, Power BI Service, Tibco Spotfire Client 7.6, 7.8, 10.3, Oracle, Microsoft SQL Server, Teradata, Iron Python, R, R-Studio

Confidential

Senior Spotfire Developer

Responsibilities:

  • Gathered requirements from business users and performed data analysis and reporting solutions.
  • Extensively worked with existing reports according to the user requirements.
  • Developed Cross table, Bar chart, Tree map and complex reports which involves Custom Expressions and property controls.
  • Worked on azure environment.
  • Understanding complex SQL Queries and good at writing SQL queries.
  • Used Iron Python to create power actions in test areas.
  • Loading data into Spotfire and checking the data loaded properly.
  • Created different set of filters by limiting data with in report and see the performance of it.
  • Good at involving complete Life cycle Development Process of a reporting solution that involves gathering business requirements analyzing business needs and documenting business information.
  • Creating information designer to create the Data elements and information links.
  • Generated complex reports by linking data from multiple sources using functionalities such as combined queries, slice and dice, drilling methodology, filters, ranking, sections.
  • Maintained the data source folders and report folders using the tool option library administrator.
  • Using web player to check the report is accessible through it without having any formatting issues.
  • Added on demand data table to improve performance of the reports.
  • Able to work on own initiative as a part of a team backed by excellent organizational and communication skills along with the capability to solve problems as they arise.

Environment: Tibco Spotfire Client 7.6, 7.8, 10.3,Oracle, Microsoft SQL Server , Iron Python , R, R-Studio

Confidential, NJ

Senior Reports Developer

Responsibilities:

  • Gathered Requirements from Business users, analyze the requirements, perform data analysis, create wireframes and build complex Spotfire and Tableau Dashboards.
  • Created Complex SQL scripts to extract the data from SQL Server, Oracle and Teradata.
  • Created data sources, Columns, Joins, Filters and Information links using Information designer.
  • Creating Complex Visualizations Bar Charts, Line Charts, Combination Charts, Tree Maps, Pie Charts etc.
  • Involved in migrating the dashboards from Development to Production environments.
  • Creating Visualizations using Text Areas, Input Fields, Property Controls, Document properties, using Prompts and calculated columns and custom expressions etc.
  • Created Information Links for many databases for populating data into Visualization from underlying databases such as Teradata, MS SQL Server and Oracle etc.
  • Optimized Information Links and queries to increase performance design and implementation of global, enterprise class Spotfire environment
  • Created calculated columns, LOD s, Parameters, sets and groups and Table calculations in Tableau.
  • Worked on Tableau data joining and data blending.
  • Published tableau dashboards on the Tableau server and set up permissions based on the access level.
  • Implemented Row level Security in both Spotfire and Tableau.
  • Created KPI Dashboards that tells a story on the Inventory, Documents Reviews, Bookings and Applications Information.
  • Modified the existing Spotfire Reports and improved the performance of the Dashboards.
  • Trained Business users on the Report Usage and make them to use more automated reporting services than excel reports.

Environment: Tibco Spotfire Client 7.6, 7.8, Tableau 10.3,10.5, Oracle, Microsoft SQL Server, Teradata , Iron Python , R, R-Studio

Confidential, Chicago

Spotfire Developer

Responsibilities:

  • Gathered requirements from business users and performed data analysis and reporting solutions.
  • Developed Spotfire Visualizations that has multiple data tables.
  • Used data table properties, Property Controls, Filters, Joins and custom functions to get formulated data from information links.
  • Worked on various visualizations like Bar Charts, line Charts, cross tables, Maps, Combination charts etc.
  • Used Load on Demand to improve performance of Spotfire dashboards.
  • Created configuration blocks in Spotfire and setting up guided analysis to carry the filter selections from one analysis to other.
  • Created Information links, Parameterization, defined join rules in Information designer.
  • Created Action Controls using Iron Python and Bookmarks in an analysis file.
  • Worked on Tibco Spotfire Server, Web Player and Library administration.
  • Created Complex Information links that involves multiple database tables, Joins and Filters.

Environment: Tibco Spotfire Professional 4.0,5.0, Spotfire Web Player, Spotfire server, Windows 2008 server, SQL Server 2008

Hire Now