PROFESSIONAL SUMMARY

• Experience with the BI tools Tibco Spotfire Professional, Web player, Tableau and Business Objects.
• Seven 7 years of experience in IT industry with a strong background in Analysis, Design and Development in the field of Database and implementation of Business Intelligence applications.
• Experience in creating Complex Spotfire Dashboards or Reports Using Tibco Spotfire Professional.
• Developed cross table, Bar chart, Tree map and complex reports which involves Property Controls, Custom Expressions.
• Created Complex Information Links to pull the data from Oracle 10g/11g and SAS datasets.
• Expert in Writing SQL Queries on Oracle and DB2.
• Created various Reports using Tableau and involved in Performance tuning.
• Knowledge in Relational and Dimensional Modeling.
• Knowledge in Data warehousing Concepts in OLTP/OLAP System Analysis and developing Database Schemas like Star Schema and Snowflake Schema for Relational and Dimensional Modeling.
• Domain Knowledge in Banking and Financial, Manufacturing and Utilities.
• Converted multiple reports from Excel, Tableau and BO to Spotfire.
• Developed and prepared new and enhancement of existing Business Objects applications.
• Extensively worked on Relational Databases like Oracle 11g/10g and DB2 and database access tool TOAD.
• Knowledge on ETL tools like Informatics.
• Good Programming Experience in COBOL, DB2 and JCL.
• Proven ability to understand business problems and able to apply technology to formulate workable solutions with excellent Interpersonal and Communication Skills.
• Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes, and corrections.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE:

Confidential

Position: Spotfire Consultant

Responsibilities:

• Gathered Business requirements and designed technical requirements documentation.
• Created various complexes Cross tables, Bar Charts, Line Charts and Tree map.
• Created Data sources for Report creation.
• Customized data by adding Property Controls, Filters, Calculations, Summaries and Functions.
• Created Information Links By using Information Designer to pull the data from Oracle Database and SAS data sets required to create the reports.
• Used Automation Job Service Builder to Export DXP file during Migration Process.
• Developed reports using Spotfire Professional and published the same to Spotfire Server for Business Users use.
• Experience in Writing SQL Queries.
• Created various prototypes and showed them to the users.
• Created Action Controls using Python Scripting.
• Experience in enhancing the visualizations using Custom expressions.
• Experience in creating Bookmarks.
• Experience in Handling Multiple data tables in Analysis.
• Converted Various Excel, Tableau and BO Reports to Spotfire.
• Enhanced some of the Reports Created in Tableau 6.0.
• Conducting Unit testing of the reports developed in Spotfire Professional.
• Responsible for the migrating the reports from Development to Acceptance / Production Server.
• Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices.

Environment: Spotfire professionals 3.2, 5.0, Spotfire web player, Spotfire enterprise player, Tableau 6.0, Business objects, Oracle 11g, SAS, Toad.

Confidential

Position: BI Developer

Responsibilities:

• Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and Business logic underlying the requirement.
• Created Reports /Visualizations using Tableau Desktop and Published them on the Server.
• Created Bar charts, Line Charts and tabular visualizations.
• Used various complex expressions to create Calculated columns used in the reports.
• Published the Reports on the server for Tableau Readers and granted tab level access.
• Experience in writing Complex SQL Quires.
• Established data source connections from Oracle.
• Unit testing of all the reports.
• Created various prototype visualizations and Demoed to the Users.
• Worked on developing training program, user guide for Tableau desktop and Tableau Reader in terms of best developing and design practices.

Environment: Tableau 6.0, Tableau Reader, Oracle 10 g, Excel

Confidential

Position: System Engineer

Responsibilities:

• Reviewing the requirement sent by the Client / Onsite coordinators.
• Preparing test case as per the SRS/developer design document
• Doing data validation testing using both source target system.
• Writing Executing SQL queries for Data validation testing for fact dimensions tables in target DB warehouse data mart .
• Doing functional testing, regression testing re-testing of our ETL testing process.
• Doing testing of informatica workflow monitoring the workflow log when job is running.
• Executing test case reporting defects in QC.
• Attending review meeting with team.

Environment: IBM Mainframes Online and Batch, Excel

Confidential

Position: Software Engineer

Responsibilities:

• Reviewing the requirement sent by the Client / Onsite coordinators.
• Preparing the Design documents and Estimation documents.
• Coding and changing the Programs/ jobs according to requirement.
• Unit Testing and logging the results.
• Delivering of the changed software elements to Onsite coordinators who will be coordinating in moving them to production.

Environment: IBM Mainframes Online and Batch, Excel