SUMMARY:

• Eight years experience on Business Intelligence Applications
• Five 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
• Three years experience with SAP Business Objects
• Two years experience in ETL - SSIS and Pentaho
• Proficient in Data warehousing, Dimensional modeling (Star Schema, Snow flake) and Databases Oracle 8i/9i, SQL Server 2000, Teradata

TECHNICAL SKILLS:

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

Database: Oracle 11g-9, MS SQL Server 2000, Teradata

PROFESSIONAL EXPERIENCE:

Confidential, Memphis, TN

Spotfire Consultant

Responsibilities:

• Gathered business requirements and designed functional and technical requirements documentation.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports
• Worked on Spotfire Professional to create worksheet, dashboards and published them to Spotfire server for end user use
• Created Database connection and Spotfire Dashboard file (DXP) in Spotfire server
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Creating TERR script for predictive analysis using R statistical programming language.
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Spotfire.
• Connected to Spotfire using different connectors like SQL, Teradata, and Active Spaces.
• Achieved complex requirements i.e. complex dashboards using HTML, Python and Java scripts.
• Executed the queries in the Teradata and validated the data.
• Use In - memory capabilities of Tibco Spotfire, Spark as well as rich Machine Learning applications with easy to use Data visualization of Models using built in TERR (Tibco Runtime R engine) and Revolution R/R Studio.
• Customized Reports by writing complex custom SQL.
• Worked on a plan to develop the process for remote systems administration and ongoing Spotfire application enhancement and maintenance
• Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices.
• Experience with Spotfire application performance monitoring, capacity planning, and tuning of the Spotfire environment.
• Provided high level, complex support services and delegate low level support to off-shore support staff
• Implemented system modifications as per established requirements.
• Prepared project estimates and analyzed reporting issues.
• Formulated dashboard specifications and generated status reports.

Tibco Spotfire Developer and Admin

Responsibilities:

• Worked on Customer Care and after sales (CCA) project. CCA makes sure that the parts for services and repairs for every GM vehicle sold in North America are available when they are needed. CCA provides these parts through our two well-known brands: Genuine GM Parts and AC Delco.
• Used various visualizations like Bar, Line, Tree Map, Box Plot, Parallel Co-ordinate plot, Scatter Plot & Map Chart etc.
• Provided data analysis via visual representation using Excel Pivot Tables and Graphs, Access Charts, Graphs, and Spotfire in order to provide management with a top down view of findings
• Used property controls, filters, joins and custom functions to get data from information links
• Relay dependencies and risks to stakeholders
• Used MVC Framework Angular.js in the development for data binding and to consume REST full web services
• Proficient in creating power BI Dashboards and visualizations
• Managed and tracked Cisco desktop virtualization pipeline across the commercial vertical
• Set up the Queues, Topics, Connection Factories, and Bridges in TIBCO EMS Server.
• Performed Complex calculations using OVER Statements
• Used Lists, tags and Bookmarks for some interesting snapshots of data
• Used Filter Schemes to isolate the filter behaviors on visualizations
• Data on Demand was used to load data on demand into dxp files
• Used Dynamic calculations based on the markings user selects in the visualizations
• Used iron Python scripting for some customizations
• Worked closely with the Cisco Data Center sales and sales leadership to evangelize Citrix Solutions.
• Used Agile Methodology for Project Implementation
• Work in an Agile team and follow scrum model deploying code to production every month
• Implemented TIBCO Hawk rule base to monitor and test the BW engine, EMS Server, log files and database.
• SME for Crystal Reports and SAP Business Objects.
• Involved in development of commonly used angular components across teams such as Customer Directives for grid, pagination, conditional validations
• Used a graph table visualization to create a stand-alone Reports on corporate and Business Unit Dashboard Reports.
• Used Microsoft SQL server to hold Spotfire server database
• Strong Knowledge in understating of messaging concepts like EMS, RV,MQ Series
• Involved in the development, design, implementation, testing and maintenance of the rdy and dat production processes (Unix Shell scripts, C, SQL). Responsibilities included
• 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
• Deployed TIBCO Spotfire DXP files to UAT/Production environments.
• Created Action Controls and wrote scripts using Iron Python.Performed several customizations using the scripts
• Set up folder permissions using Library administration.
• Created configuration blocks in Spotfire and setting up guided analysis
• Set up Projects, Groups, Users and set up Permissions

Environment: Tibco Spotfire Professional 7.5, Spotfire Web Player, Spotfire server, Servlets, Windows 2008 server, SQL Server 2008, Teradata

Spotfire Developer and Admin

Responsibilities:

• Used data table properties, property controls, filters, joins and custom functions to get formulated data from information links
• Created Information links, parameterization, defined join rules in Information designer.
• Used Filter Schemes to isolate the filter behaviors on visualizations
• C Programming, System Programming, Socket Programming on Linux, Network Programming through TCP/IP, 8051, ARM
• Involved in various System Integration testing of API
• Used Load on Demand to improve performance of spotfire dashboards
• Involved in logging, monitoring, and statistics facilities to effectively view system activities and track system performance using TIBCO/EMS.
• Good experience in JSP, Struts, Java script, angular JS, html, CSS, jQuery. Good knowledge in Apache ant, maven, Gradle, GIT, Jenkins/Hudson
• Responsibilities included completing a couple full life-cycle TDMS projects (detailed design, data design, coding, testing, implementation and support using C, Pro *C, Perl, PL/SQL, UNIX shell scripts, Tuxedo, Connect/Direct.
• Worked Extensively on Tibco EMS and RV.
• Deployed TIBCO Spotfire DXP files to UAT/Production environments.
• Installed Spotfire Server, Database drivers, Hotfixes
• Configured Spotfire server - Set up single sign on
• Wrote Spotfire server Backup scripts to take backups regularly
• Hands on experience on compiling, installing and configuring software in Linux and UNIX including Apache web servers, MySQL database servers and Tomcat.
• Involved in the AMS TIBCO Application support team efforts in successfully providing support to the current TIBCO frame work.
• 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, Borland, J Builder, SQL Server 2012

ETL Developer

Responsibilities:

• Used Pentaho Data Integration/Kettle to design all ETL processes to extract data from various sources including live system and external files, cleanse and then load the data into target data warehouse
• Created transformations that involve configuring the following steps: Table input, Table output, Text file output, CSV file input, Insert/Update, Add constants, Filter, Value Mapper, Stream lookup, Join rows, Merge join, Sort rows, Database Lookup, Set Environment Variables
• Used dimension lookup/update step to populate data into SCDs.
• Involved in Weekly meetings to streamline and define requirements and business rules to arrive at a general consensus between the analysts, business users, and software development team.
• Participated in design of Staging Databases and Data Warehouse database using Star Schema.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created cubes using schema workbench on top of DW star schema
• Dealt with slowly changing dimensions type 2 and multi-level hierarchical dimensions.
• Published cubes and reports onto Pentaho repository and refreshed Pentaho BI repository after uploading each object to be available for central use.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL and stored procedures.
• Used MDX queries to generate custom ad-hoc reports with addition of calculated members in the reports.
• Prepared mapping document for ETL and user manuals for end users in order to educate them about execution of BI reports.

Environment: Pentaho Kettle, Windows 2008, oracle 11g, Oracle AERS, TOAD

Business Objects 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

ETL /SSIS Developer

Responsibilities:

• Gathered business requirements and designed functional and technical requirements documentation.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Upgraded MS SQL Server 2000 databases to 2005, using Detach/Attach, Back up & Recovery and by Replication.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Converted existing BO reports to tableau dashboards
• Created different KPI using calculated key figures and parameters
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Involved in UAT of the applications by providing users with test cases and scenarios, and guiding them during the testing process.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created Views to reduce database complexities for the end users.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.

Environment: SQL Server 2008/2005, C#., VB, VBA, UAT, ASP, .NET, Tableau, SSIS, HTML, XHTML, Java, JSP, Oracle, PL/SQL, MS Office