SUMMARY

• Seven years experience on Business Intelligence Applications
• Three years experience in creating complex Spotfire dashboards and visualizations by using the key concepts filtering scheme, Data on Demand, property controls, Text Areas in TIBCO Spotfire reports using Tibco Spotfire Professional; Installation of Tibco Spotfire server, Administration, tuning,and monitoring the server
• Four Years Experience with SAP Business Objects - Created Business Objects Repositories, Designed Universes, Developed Full Client reports with multiple Data Providers, free hand SQL,
• Proficient in Data warehousing, Dimensional modeling (Star Schema, Snow flake) and Databases Oracle 8i/9i, DB2 UDB, SQL Server 2000,

TECHNICAL SKILLS

Software: Tibco Spotfire 7/6.5, Business Objects XI R3.3,R2, 6.5/5.1,Visual Basic 6

Database: Oracle 11g-9, MS SQL Server 2000, DB2 6.0 /7.0

Industry Experience: Finance, Insurance, HR, Education, Manufacturing, HealthCare

PROFESSIONAL EXPERIENCE

Confidential, MA

Tibco Spotfire Developer and Admin

Responsibilities:

• DevelopedSpotfireDashboards metrics for Customer, Employee, Financial and Operational metrics
• Installed Spotfire Server,Database drivers,Hotfixes
• Used Microsoft sql server to hold Spotfire server database
• Configured Spotfire server - Set up single sign on
• Monitored Spotfire server to detect issues with server,LDAP Servers,network problems,external databases to reduce server downtime and eliminate performance bottlenecks
• Analysed the Action logs to find what the users are doing,when they login,who did what etc
• Upgraded Spotfire from 6.5 to 7
• Used data table properties, property controls, filters, joins and custom functions to get formulated data from information links
• Worked on various visualizations like Tree Map, Box Plot, Parallel Co-ordinate plot, Scatter Plot & Map Chart etc
• Deployed TIBCO Spotfire DXP files to UAT/Production environments.
• Created Information links, parameterization, defined join rules in Information designer.
• Created Action Controls and wrote scripts using Iron Python.Performed several customizations using the scripts
• Used Lists,tags and Bookmarks
• Used Filter Schemes to isolate the filter behaviours on visualizations
• Used Over statements for calculations
• Used Dynamic calculations based on the markings user selects in the visualizations
• Worked on Tibco SpotFire Server, Web Player and Library administration.
• Created configuration blocks in Spotfire and setting up guided analysis to carry the filter selections from one analysis to other.
• Set up Projects, Groups, Users and set up Permissions

Environment: Tibco Spotfire Professional 6.5/7.0, Spotfire Web Player,Spotfire server, Windows 2008 server, SQL Server 2008, SSIS

Confidential, Atlanta,GA

Spotfire Developer and Admin

Responsibilities:

• Used data table properties, property controls, filters, joins and custom functions to get formulated data from information links
• Created Dashboards that provide Vehicle Sales, Vehicle Parts Analysis, Financial Reports etc
• Worked on various visualizations like Tree Map, Box Plot, Parallel Co-ordinate plot, Scatter Plot & Map Chart etc
• Deployed TIBCO Spotfire DXP files to UAT/Production environments.
• Created Information links, parameterization, defined join rules in Information designer.
• Installed Spotfire Server,Database drivers,Hotfixes
• Used Microsoft sql server to hold Spotfire server database
• Used Load on Demand to improve performance of spotfire dashboards
• Configured Spotfire server - Set up single sign on
• Wrote Spotfire server Backup scripts to take backups regularly
• Monitored Spotfire server to detect issues with server,LDAP Servers,network problems,external databases to reduce server downtime and eliminate performance bottlenecks
• Analysed the Action logs to find what the users are doing,when they login,who did what etc
• Created configuration blocks in Spotfire and setting up guided analysis to carry the filter selections from one analysis to other.
• Installed and Configured Spotfire Server
• Set up Projects, Groups, Users and set up Permissions

Environment: TibcoSpotfire 6.5/5.5, Windows 2008 server, SQL Server 2012

Confidential, Rockville, MD

Business Objects /Tableau Developer

Responsibilities:

• Created, and optimized Business ObjectsUniverses for FDA Adverse Event Reporting System-FAERS
• Created Various reports like Quick Query, Profile Report and DASR report. Implemented 2nd level and 3rd level drilldown navigation to reports from master reports
• Performed the following project management related activities for several different projects:
• Developed and maintained project plans and schedules, scheduled status meetings in collaboration with the Manager. Created presentations and other project updates for meetings. Maintained change control processes making use of change tracking tools
• Interacted with users and Gathered, addressed business and technical requirements; translated business requirements into technical requirements and specifications
• Created scripts for Oracle Tables, Indexes, Users, Roles, views and Stored Procedures and Functions using SQL,PL/SQL
• Used Tableau Actions-Filter,URL and Highlights,Groups,Quick Filters and Parameters,Maps,Calculations,
• Created Dashboards using Tableau as performance of BO dashboards is not satisfactory.
• Set up Tableau Server, performed upgrades and administration activities like creating users,groups,projects,schedules etc
• Troubleshooting Tableau Dashboards- Fixed Issues related to Datasources, Linking Datasources, Hyperlinks, Data Mismatch, Extract failures, Permission, Tableau Memory Issues, Slow rendering of dashboards on server
• Performed source data assessment and identified the quality and consistency of the source data.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces
• Set up best practices for Tableau development and administration
• Prepared TestData and Validatedprograms and the reports against the oracle 11i database

Environment: Tableau 7, SAP Business Objects,Windows 2008, oracle 11g,Oracle AERS, TOAD

Confidential, MD

Business Objects Architect/ Developer

Responsibilities:

• Spearheaded the Business Objects 6.5 to XI 3.0 migration project. Designed and implemented the roadmap for migrating Business Objects the deployment from 6.5 to XI 3.0
• Interacted with users and Gathered, addressed business and technical requirements; translated business requirements into technical requirements and specifications
• Created scripts for Oracle Tables, Indexes, Users, Roles, views and Stored Procedures and Functions using SQL,PL/SQL
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces
• Prepared operation instruction manuals to business users
• Set up best practices for all Business Objects development and administration
• Prepared Test Data and Validated programs and the reports against the oracle 9i database
• Created, and optimized Business ObjectsUniverses for Financial, Procurement and Fixed Assets using Designer
• Performed Administrative tasks like Setting up user profiles, assigning rights and privilegesfor groups, setting up Categories using Central Management Console
• Created Financial, Procurement and Fixed Assets reports and Xcelsius Dashboards.
• Created HR Reports like Grant Certification, Leave Accruals, W2 Audit, Payroll, CIGNA, Retirement Projections, Pension Enrollment etc
• Use advanced Business Objects techniques to present data including contexts, drill downs, hierarchies, advances functions, predefined conditions, prompts
• Tuned Universes, created Contexts and Aliases for resolving Loops, Fan Traps, Chasm Traps, and checked the Integrity of the Business Objects Universes
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure
• Created Indexes and Summary tables for improving the performance of reports
• Designed and Developed Datamarts using Star Schema and Snow Flake Schemas

Environment: Business Objects(Designer, Desktop Intelligence,Central Management Console, Web Intelligence, Xcelsius, Websphere), Windows 2003, oracle 9i

Confidential, Reston,VA

Business Objects Developer

Responsibilities:

• Created, and optimized Business ObjectsUniverses
• Performed Administrative tasks like Setting up user profiles, assigning rights and privilegesfor groups, setting up Categories using Central Management Console
• Involved in tuning performance of reports by creating aggregate tables
• Setup and maintained user security using Supervisor..
• Used Aggregator, Sequence Generator, Update strategy, Lookup, Stored procedure Filter and Expression transformations in Informatica
• Provided End-user support and training.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.

Environment: Business Objects 6.5, Oracle 8i,Informatica,Crystal Reports 9.0