SUMMARY:

• Highly qualified BI developer with over 9 years of verifiable experience different phases of software development life cycle (SDLC) including Analysis, Design, Development, Testing and Production With Experience in Spotfire 7.8, Business Objects(4.2), Cognos(10.2, Tableau (90,10,10.1), Qlikview (11,11.2 SR 10,12), DB2,Oracle Database 10g and 11g using PL/SQL & AWS, PostGRE, HIVE & Red Shift.
• Great experience in planning, building, and managing successful large - scale BI Data Warehouses and decision support systems.
• Hands-on experience in Installation, Migration and Administration of Spotfire & Qlikview associated with Different databases
• Strong Spotfire development experience with knowledge of Spotfire Professional Client, HTML, Java Script, Web Player, R Programming, Automation Job Services, ADS and Iron Python Scripting.
• Extensive experience in using Tableau functionalities for creating different Reports, Interactive Dashboards with page and Dashboard prompts using sets, joins, bins, hierarchies, sorting, grouping etc.
• Worked extensively on visualization properties and complex interactive features such as multiple markings, filtering schemes, configure bar chart, line chart, graphical table, combination chart, scatter plot, pie chart, table, cross table, and summary table visualizations.
• Implemented Folder level and Row level security using personalized information links
• Used data on demand to custom reports, well versed in using different data sources, components and schemas
• Optimized Information links and queries to increase performance using On-Demand data.
• Utilized multiple visualizations, calculated columns, summations and pivoted tables to demonstrate value of opportunities.
• Expert in designing Spotfire dashboards / reports with complex and multiple data sources.
• Have strong knowledge of Spotfire architecture, admin roles and responsibilities, migration procedures.
• Performed day to day administration of Spotfire, including group/library management, upgrades, monitoring log files, performance tuning, troubleshooting and reporting.
• Extensive Experience with Geo-spatial data while trying to meet the Cartographic needs of the Spotfire Visualizations.
• Used ArcGIS & Python to create Base Maps and Heat maps for Map Visualizations using various Interpolation Techniques like Kriging.
• Expertise in designing and modeling of QlikView with complex multiple data sources (SQL, Flat Files, Excel and Access, ) relational designs .
• Proven analytical and problem solving capabilities in understanding and delivering solutions to meet end-user requirements.
• Knowledge in Data Warehousing Concepts in OLTP/OLAP System Analysis and developing Database
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers .
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC).
• Extensive knowledge in various languages like Java, J2EE, ASP.NET, VB.NET, C#.NET, Java Script, VB Script, Advanced PL/SQL, Transact-SQL, Perl and Shell scripting.
• Experience in diversified project sectors such as Insurance, Telecom, Manufacturing and Retail.
• Experience in using different application servers like Apache Tomcat v4.x/5.x/6, IBM WebSphere Application Server (WAS) v5.x/6.x, IBM Web Sphere Process Server 6.1.2, JBOSS application server 4.2, Web Logic Application server .
• Excellent leadership, communication skills with impressive analytical and multi-tasking abilities.

TECHNICAL SKILLS:

Business Intelligence: TIBCO Spotfire (5.0, 7.0, 7.5, 7.8) Core Server, Tableau 7.X,8.X, TIBCO Spotfire Prof Client, TIBCO Spotfire Web Player, TIBCO Spotfire SDK, TIBCO Spotfire API 7.0, Windows Server 2012, SAP Business Objects (3.1, 4.1), Qlikview 10.0/9.0.

Data Warehousing and ETL: Information Links, SQL Stored procedures, Fact and Dimension Table Design, TOAD, Data Marts, COMPOSITE (6.2,7.0), Erwin/ Data modeling and Informatica Powercenter 9.5.x

Database: Oracle (8i/9i/10g/11g), SQL Server (6.5/7.0/2000/2005 ), IBM DB2, Teradata, MS Access (2000/2002), MySQL.

Programming: C, C++, JAVA, JSP, Servlets 2.4, EJB2.0/3.0, JDBC 2.0/3.0, JMS UNIX/shell scripting, PL/SQL, Iron Python, R Script, HTML and Visual Basic.

RDBMS Tools: Toad, OEM, PL/SQL Developer, SQL* Plus, SQL* Loader, DB Visualizer, SQL Server Management Studio.

Additional: XML, XSLT, VBScript, Java Script, Visual Studio.NET 2008/2005/2003, .NET Framework 4.0/3.5/2.0, Active Directory, Scheduler, Eclipse, REMEDY, HTML, DHTML, Web Sphere Studio Application Developer, ArcGIS 10.X, Apache Axis 1.2 & EBS.

PROFESSIONAL EXPERIENCE:

Confidential,Kansas City, MO

TIBCO BW Developer

• Worked with Business Analysts, end users and third party vendors to finalize interface agreement documents that captured data mapping between various enterprise applications.
• Used various TIBCO Active Enterprise products to facilitate the integration of several enterprise applications
• Configured TIBCO Business Works processes to receive XML files from trading partners and generate messages to update the billing system.
• Developed XSDs, XPATH transformations and XSLT mapping using TIBCO Designer.
• Created BW SOAP Server processes to handle incoming requests for collections.
• Configured the publication and subscription services of the ADB (Active Database) adapter to integrate with backend Oracle 9i database.
• Installed and configured TIBCO EMS Server on a UNIX/Solaris platform.
• Configured several EMS client applications for durable subscriptions to ensure guaranteed delivery of messages.
• Modified various destination properties using queue and topic configuration files.
• Analtics and Visualization using Tibco Spotfire
• Setup bridges for several destinations to facilitate logging of mission critical messages into a database for archival purposes.
• Configured TIBCO Business Works billing system query and update processes to provide customer care system with real-time billing system data.
• Generated Unit test scripts, performed integration testing for the project and created the Unit and Integration test result Documents.
• Set the Load balancing and Fault tolerance properties for TIBCO BusinessWorks Engine.
• Developed and implemented the Audit and Error handling standards for all interfaces.
• Performed Development, Testing and Deployment of the application in different (development, testing and Production) environments
• TDD environment.

Environment: TIBCO Business Works, TIBCO Designer, TIBCO EMS,TIBCO AMX BW,TIBCO ADB Adapter, SAP Adapter,TIBCO Hawk, TIBCO Administrator, Oracle 9.i, SQL Plus, REST web services and JSON

Confidential, Quincy, MA

Sr. Spotfire Developer

• Communication with Business Analysts and Testing Team to follow through on the end to end Life cycle of the Reports.
• Develop Reports for the Transactional Database from different applications like PStar, Oracle EBS (HR and Financials.)
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop
• • Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• • Created Tableau workbooks with calculations, parameters, Quick Filters.
• • Worked and generating various workbooks and dashboards extracting date from various sources such as Oracle, SQL Server and data files using data blending and joins.
• Designing and developing the information links, Data Source, Columns, Joins, Filters andStore Procedures.
• Creating visualization using advanced Heat Map, Trellis, Scatter plots, 3D Scatter Plots, Map charts, Tree Map
• Creating Dynamic Visualizations using Text Area, Input Field, Lists, drop down lists, Property, Document Properties and On-Demand Data.
• Maintaining Maps for Custom Sales Territories by creating Shape files and integrating Geo-Spatial data from the Field agents & Customers.
• Structured the Spotfire library to publish and share all the analysis material, information links, data sources to end user according to their role and knowledge
• Created Information Links for many databases for populating data into Visualization from underlying databases such as Sql Server and Oracle.
• Managed created dashboards in Spotfire cloud with regarding to user's roles.
• Integrated Spotfire visualization into client's Salesforce environment.
• Trained Spotfire tool and gave guidance in creating Spotfire Visualizations to couple of colleagues

Environment: SPOTFIRE 5.0 & 6.5, Tableau 7.x, Qlikview 10.0/9.0, Sharepoint, Business Objects 3.1, WEB SERVICES, SQL Studio, Oracle 10g, EBS, EBIE Experts,ArcGIS, Team Track.

Confidential, Concord, NH

Spotfire Developer

• Hands on development assisting users in creating, modifying Spotfire visualization dashboard and getting data into Spotfire from different data source.
• Apply the best design practices for analyses and dashboards.
• Expert in manipulate existing data columns, merge data, add data tables, connect to in-database data, using bookmarks, tags, and lists to capture aspects of your dynamic analysis and consider the available aggregation options and expression shortcuts.
• Created master detail and summary reports to view the data in an analyzed way
• Configured the Spotfire Application Server and the Web Player Server for optimal use.
• Suggested best practices for the Server infrastructure, Information Model, Library setup, and group administration.
• Performed daily admin tasks of user registration, security configuration and usage monitoring.
• Optimized Information links and queries to increase performance Design and implementation of a global, enterprise class Spotfire environment.
• Experience in working with embedding and integrating the TIBCO Spotfire Web Player into web sites and controlling the Web Player from remote applications using the APIs.
• End to end experience in designing and deploying data visualizations using TIBCO Spotfire.
• Provided 24/7 customer support to TIBCO Spotfire users.
• Experienced in tuning long running SQL queries for better performance.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Installed TIBCO Spotfire Server in Dev, QA, UAT and Prod environments.
• Deployed TIBCO Spotfire in clustered environment by mapping server nodes to primary machine.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Participated on business requirement document preparation.
• Designed the integration of Enterprise Management Reporting Portal to provide single point of entry, developing Drill-to-Detail (D2D) for deep linking and cross-system Interoperability
• Maintained and updated the dashboard reports as required by client.
• Conducted and guided TIBCO Spotfire BI application global roll out, managed QA Testing, User Acceptance Testing, software update, migration deployment and parallel run, stabilizing the server platform and application to achieve the steady state for transitioning.
• Designed Executive Sales Analysis Dashboard that offers fast and flexible access to all key information across the enterprise.
• Maintained user guides and documentation for TIBCO Spotfire applications.

Environment: Tibco Spotfire professionals 4.0 and 5.0, Spotfire web player, Oracle10g, Teradata, TOAD, SQL, and Tableau 8.2.

Confidential, Erie, PA

Business Intelligence Consultant

• Responsible for the analysis, development of business intelligence solutions, dashboards.
• Experience with TIBCO Spotfire Data Visualization, Dashboard development
• Responsible for the design, development, documentation and quality assurance.
• Estimate the effort required to develop custom visualization and dashboards based on client business needs
• Responsible for managing Users/Groups/Roles and security.
• Responsible for upgrade, applying hot fixes & Analyzing tracks and logs. Configuring bootstrap and database drives on Spotfire Server.
• Responsible for creating Information Links and Data Sources & adding Data Columns from different sources.
• Responsible for publishing analysis for Web Player users.
• Led functional requirements gathering and functional design process.
• Led definition of the reporting solution including report standards, quality, security and management.
• Led the development of a strategy to support current and future reporting needs .
• Tested and debug code, both own and that produced by fellow team members.
• Coordinated with the Data Architect to support data model changes.
• Worked with end users and development teams to ensure that new and existing data models and databases are consistent with approved data architecture standards.
• Ensured that Quality Assurance test plans are executed before releasing product enhancements for user acceptance testing.
• Provided production support by troubleshooting and resolving any production issues that may arise.
• Responsible for performance tuning of anything connected to data systems and ensuring efficient operations and maximizing resources to provide the best results for our clients.

Environment: Windows Server 2012/2008/2003, IIS 8/7/6/5, Spotfire Server 3.3/4.5/5.5/6.0, Spotfire Professional Enterprise 3.3/4.5/5.5/6.0, Spotfire Web Player 3.3/4.5/5.5/6.0, SQL, T-SQL, PL/SQL, Oracle 10g, Iron python, JavaScript, HTML,TOAD, WinSQL.

Confidential, Columbus, OH.

SAP Business Intelligence Developer

Responsibilities:

• Designed and implemented OLAP reports, by extracting data from the data warehouse.
• Integrated queries, reports, powerful analysis, and decision support work flow using Crystal Reports.
• Developed various Universes out of Finance/Controlling (FI/CO) and Supply Chain modules of SAP and Ross meant for GL, Profit Center, Cost Center, AR/AP etc.
• Generated report for web-based query using Crystal Enterprise and Worked as Crystal Enterprise Administrator.
• Created the reports using Crystal Reports functionality like Queries (Stored Procedures), Sub Reports, Drill down, Cross-Tab, Master/Detail and Formulas etc.
• Created complex data-manipulation formulas in Crystal Dictionary that user can access without the need to understand formula concepts.
• Extensively worked with stored procedures, triggers and views in Oracle 9i.
• Created hierarchy and conditions in the universes and Created users and set permissions for the users using Crystal Management Console.
• Published reports on to users in organization using Publishing Wizard of Crystal Enterprise.
• Designed, developed and tested reports based upon data generated using Business Objects XI R2.
• Created reports using Business Objects functionalities like Queries, Slice & Dice, Drill down, @Functions, Formulae etc.
• Used Broadcast Agent and WEBI, BCA Console, Admin Console.
• Created Unit Test Case’s and Tested in different Environments (Dev., Test, Prod).
• Developed various Charts and Graphs like Bar chart (Side By Side, Stacked), Line graphs, Pie Charts etc by using Chart expert using Crystal Reports.

Environment: Business Objects XIR2, Web Intelligence, Infoview, Desk Intelligence, DB visualizer, Oracle 9i, PL/SQL, Crystal Reports 9/ Crystal Enterprise 9, Crystal Xcelsius, SAP Business Explorer, TOAD, UNIX.

Confidential, Corona, CA

Business Intelligence Developer

Responsibilities:

• Involved in dimensional modeling of the data warehouse to design the business process.
• Extracting data, transformed and loaded into Oracle database according to the specifications.
• Used various transformations like lookup, update strategy, router, filter, sequence generator, source qualifier/Joiner on data and extracted according to the business rules and technical specifications.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Performed daily maintenance tasks like space management, rectified locking and looping problems by using context and aliases and worked on changing dimensions.
• Improved the performance of the mappings using various optimization techniques.
• Performance tuning of the ETL - by utilizing dynamic cache for Lookups partitioning the sessions.
• Developed/modified Universes based on requirements from end users; created Objects including Dimensions, Details and Measures; created Hierarchies to provide drill down functionality to end-users.
• Created new Universes and linked with the existing Universes and created reports using Universes and Free hand SQL as Data providers.
• Built Full Client and WEBI reports, developed Trend Analysis Reports and Comparison Reports with drilling capabilities for the end-user to generate ad-hoc reports.
• Analyzed reports using Slice and Dice, Drill Up/Down, Cross tab, Master Detail, and Formulas and Created Aggregate Tables wherever necessary.
• Created Test Scripts to ensure in-depth functionality of Reports; tested reports based upon data generated by Enterprise Transaction and Customer Information systems.

Environment: BusinessObjectsXIR2, WebI, MS SQL Server, Oracle 10g/9i, PL/SQL, Crystal Reports, Crystal Xcelsius, UNIX.