SUMMARY:

• Over all 9 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 with the BI tools TIBCO Spotfire Professional, TIBCO Spotfire Admin, Web player, Tableau and Business Objects.
• Intensive scripting with TERR, Iron Python, JS & HTML Scripting coding to design executive dashboards.
• Experience in creating Complex TIBCO Spotfire Dashboards or Reports Using Tibco Spotfire Professional.
• Programming Experience in Basic SAS with different Procedures like Proc SQL, Proc Report, Proc tabulate, proc print, Proc Sort, drop, keep, retain, date manipulations, formats and SAS EG etc.
• Experience with Hadoop Echo system tools and databases HDFS, Sqoop, HBASE, HIVE, PIG and Map Reduce
• Good Experience in Data analysis, data extraction using SQL.
• Experience with Microsoft reporting tools SSRS.
• Experience with PL/SQL procedures, Stored Procedures in Netezza, Functions and Triggers.
• Strong Experience with tableau server, security access, publishing the dashboards and access control.
• Developed cross table, Bar chart, Tree map and complex reports which involves Property Controls, Custom Expressions.
• Experience in developing complex visualization Map charts and Parallel Co - ordinate plots.
• Good experience with SAS Programming and reports.
• Developed cross table, Bar chart, waterfall, tornado, 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, ESSBASE, Teradata and DB2.
• 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.
• Extensively worked on Relational Databases like Oracle 11g/10g and DB2 and database access tool TOAD.
• Developed and prepared new and enhancement of existing Business Objects applications.
• Converted multiple reports from Excel, Tableau and BO to TIBCO Spotfire.
• Domain Knowledge in Banking and Financial, Manufacturing and Utilities.
• 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.

TECHNICAL SKILLS:

TIBCO: Spotfire Professional 3.0, 5.0 and 6.5 TIBCO Spotfire Web playerTableau 8.0, Business Objects, Informatica ETL and Dataware Housing

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, HIS, Apache) and SSRS (SQL Server Reporting Service)

Operating Systems: Windows 7/VISTA/NT/ XP/ ME/ 2000/, UNIX.

Databases: Oracle 11g/10g and DB2, ESSBASE, SQL server, Teradata

Programming Languages: C, C++, SQL, PL/SQL, COBOL, XML, SAS EG Grid

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

TIBCO Spotfire Developer

Responsibilities:

• Gathered Business requirements and designed technical requirements documentation.
• Created various complexes Waterfall Charts, Tornado Charts, Bullet Graphs, table and cross tables, bar charts, combination charts and line charts
• Created Data sources for Report creation.
• Customized data by adding Property Controls, Filters, Calculations, custom expressions and Summaries and Functions.
• 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, Action controls to navigate to the different pages or visualizations. .
• Working knowledge in HTML, JavaScript to create Guided Analysis
• Experience in enhancing the visualizations using Custom expressions.
• Experience in creating Bookmarks.
• Experience in Handling Multiple data tables in Analysis.
• Giving security access to the DXP files of folders or Information links.
• Conducting Unit testing of the reports developed in Spotfire Professional.

Environment: TIBCO Spotfire professionals 7.6.0, 5.0, Spotfire enterprise player, Business objects, Oracle 11g, Toad, and ESSBASE.

Confidential, Washington DC

TIBCO Spotfire Analyst

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.
• Working knowledge in HTML, JavaScript to create Guided Analysis
• 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.
• Giving security access to the DXP files of folders or Information links.
• 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: TIBCO Spotfire professionals 3.2, 5.0, Spotfire web player, Spotfire enterprise player, Tableau 6.0, Business objects, Oracle 11g, SAS, Toad.

Confidential, Georgetown KY

Spotfire consultant

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.
• Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices.
• Created various prototype visualizations and Demoed to the Users.

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

Confidential

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.

Confidential

System Engineer

Responsible

• Working as a single point of contact for the above mentioned two service areas which includes direct interaction with all of UK and ROI users.
• Creating new distribution centers.
• Preparing the jobs to generate reports.
• Unit Testing and logging the results.
• Delivering of the generated and tested reports to the service manager.
• Coordinating in moving them to production.