Sri Chava

Sr BI Architect/Developer

SKILL SUMMARY

Over 12 years of IT experience in Data Warehousing and Business Intelligence using Spotfire, Business Objects, Qlik, Tableau, ETL, Oracle, SQL Server 2016/2012/2008/2005, SAP HANA, TERADATA.

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 & BO 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.

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.

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.

Have strong knowledge of BI architecture, admin roles and responsibilities, migration procedures.

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.

Knowledge in Data Warehousing Concepts in OLTP/OLAP System Analysis and developing Database

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 Reta

Excellent leadership, communication skills with impressive analytical and multi-tasking abilities.

TECHNICAL SKILLS

Business Intelligence: TIBCO Spotfire, Core Server, Tableau, TIBCO Spotfire Web Player, TIBCO Spotfire SDK, TIBCO Spotfire API 7.0, SSRS, Power BI, SAP Business Objects, Qlik

Data Warehousing and ETL: Information Links, SQL Stored procedures, Fact and Dimension Table Design, TOAD, Data Marts, COMPOSITE, 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, Impala, Teradata, MS Access (2000/2002), MySQL, SAP HANA.

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.

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, R Studio, ArcGIS 10.X & EBS.

EDUCATION

Master’s in computer science, USA

Bachelor of Technology, Hyderabad, India

PROFESSIONAL EXPERIENCE

Chevron, Houston, TX Jul’18-Current

BI Lead/Technical Architect

Responsibilities:

Developing R & Iron Python Scripts to Pass Inputs from Engineers to the Visualizations and Loading Type Curve Neighborhoods grouping wells on the Map Charts.

Working with GIS Teams on Interpolating Techniques and Replacing Shp Files with Schema from Hadoop that use static maps and Interpolating techniques for Grouping the wells

Working with Support teams and Infrastructure Teams to build sustainable Architecture for MCBU FIT Visualizations and managing the Security of Visualizations and Datasets at Multiple Levels Including Library Administration.

Design Spotfire Visualizations to Analyze Production Analysis of Wells in the Mid-Continental Business Unit for Unconventional & Tight Rock Sources.

Develop Visualization to analyze decline Curves and replace Third Party Tools like Harmony & (Oil Field Manager) OFM

Designed and Built Data Sources, Data Connection, Information Links and Scheduled Jobs in Automation Services Job Builder for Standard Dashboards in MCBU-Chevron.

Evaluate Factory Integrated Tools in the Permian Basin for the Performance and Architecture and Provide the Training and Support for the Engineers who use the tools

Integrate RAPID Decline Curve Analysis (TERR) data models with the Visualizations to Read and Write Back the data into the Datasources (SQL, Hadoop)

Working with Cisco Composite to analyze the Output from the API’s and Other External data sources and Provide an integrated Data source Via Information Links for the FIT Visualizations.

Environment: TIBCO Spotfire 10.x, 7.11 (Professional client, Spotfire Web Player, Automations, Web Player Server), R 3.6.1, Iron Python, Microstrategy 2019X, 2020, ORACLE 11.5, Teradata, Web Services, ArcGIS 10.x, Cisco Composite, ADS, Hadoop HUE, OFM, Harmony

Nestle Purina, St Louis, MO Jan’17-May’18

BI Lead/Admin

Responsibilities:

Interact with the customers and business analyst to assess the needs and requirements, performed impact analysis, described and documented.

Play an active role in the life cycle stages of planning, requirements definition, design, development, testing and support of Decision Support Systems and related components.

Created Dynamic Visualizations using advanced Trellis, Scatter plots, 3D Scatter Plots, Map charts and Tree Map, Text Area, Input Field, Lists, drop down lists, Property, Document Properties, On-Demand Data and In-Database. 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

Managed and tracked Cisco desktop virtualization pipeline across the commercial vertical

Developed R Scripts in TERR for custom data functions.

Used Filter Schemes to isolate the filter behaviors on visualizations

Used Dynamic calculations based on the markings user selects in the visualizations

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

Monitored Spotfire server to detect issues with server, LDAP Servers, network problems, external databases to reduce server downtime and eliminate performance bottlenecks

Analyzed the Action logs to find what the users are doing, when they login, who did what etc.

Created Action Controls and wrote scripts using Iron Python. Performed several customizations using the scripts

Created configuration blocks in Spotfire and setting up guided analysis

Work with data management staff to create/refine an operational framework that will define, develop and implement BI policies and security functions to ensure precise and secure delivery of knowledge and information Design or review significant changes for purposes of incident avoidance.

Worked with TSG (Testing Team), ETL Team to Test Database Changes and related Dashboard changes before promoting them to Production for the End-Users

Environment: TIBCO Spotfire 7.7 (Professional clients, Spotfire Web Player, Automations, Web Player Server), Microsoft SQL Server 2010/2012, Sharepoint, Business Objects 4.1, ORACLE 11.5, Teradata, WEB SERVICES, ArcGIS 10.x.

Bayer, St Louis, MO

BI Lead/ Developer Oct’13- Nov’16

Responsibilities:

Involved in requirement gathering from Business Users & Teams and translated the Functional requirements to Technical requirements & specifications.

Worked on Standardizing and developing the design for Product Performance Dashboards in Spotfire 7.0 using SQL Data Connectors, Information link, web services, Composite, Sharepoint & Flat Files.

Worked with Automation serbices Job Builder and Job scheduler to schedule and replace the Spotfire Dashboards that consume time to load in the Web Player.

Created Database connection and Spotfire Dashboard file (DXP) in Spotfire server and developed Customized Reports by writing complex custom SQL in the data connectors.

Customized data by adding prompts, Filters, Calculations, Summaries and Functions. Integrated multiple data sources by inserting columns into alias files for the visualizations.

Created Spotfire Visualizations with Sharepoint datasource through Informatix and ODATA.

Created Shapefiles with alternate Boundaries to serve as the Base maps for the map view using ArcGIS.

Created Column elements, Filters, Joins & Information links for some dashboards which required Cached data.

Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting.

Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices.

Knowledge in Spotfire application performance monitoring, capacity planning, and tuning of the Spotfire environment.

Maintained MPM, APEX & FIR Universe serves multiple business in the company like Marketing & Technology development

Worked on the Product Performance Dashboard on Qlikview using integrated data sources like SQL Queries and Flat files.

Maintained Security at folder level by creating Spotfire User Groups and also creating a Role Based security Model using information Links.

Performed Unit testing & Integrated Unit Testing in PS environment and had close interactions with system test and user acceptance team to complete technical and functional testing.

Logged defects in Team Track and provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.

Environment: SPOTFIRE 6.5 & 7.0, COMPOSITE 6.2 & 7.0, Microstrategy,, Sharepoint, Business Objects 4.1, ORACLE 11.5, Teradata, WEB SERVICES, ArcGIS 10.x.

Arbella Insurance Group, Quincy, MA

Sr. Business Intelligence Developer Sep’12-Oct’13

R3: Financial And Billing Reporting

Arbella provides car insurance, home insurance, and business insurance in Massachusetts and Connecticut, as well as business insurance in New Hampshire and Rhode Island. The company has several applications in different departments catering to the growing IT needs of the customers as well as the employees. Management Information Department is responsible for proving and maintaining the ETL and Business Objects requirements from Departments like Finance and Billing, P Star and Claims.

Finance and Billing Reports will be generated based on the requirements from the business which include the complex Payments Processes and Transactions of FAB built by Stone River Corp.

Responsibilities:

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 and Store 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.

Lincoln Financial Group, Concord, NH

BI Developer Mar’11- Aug’12

Lincoln Financial Group is a diversified financial services organization headquartered in the Philadelphia region. With $153 billion in assets under management as of September 30, 2011, Lincoln Financial Group has been serving the financial needs of customers since 1905. Our goal is to provide comprehensive financial solutions that help our customers secure their retirement and manage life transitions. For financial professionals, Lincoln Financial is their partner of choice, offering innovative, industry-leading products and educational resources to help them build their book of business.

Responsibilities:

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.

Erie Insurance, Erie, PA

BI Engineer Aug'10- Jan’11

P0947: Claims Reporting

Erie Insurance Group is a multi-line insurance company, offering auto, home, commercial and life insurance through a network of independent insurance agents. Erie Insurance Group (EIG) has embarked on a project to create a centralized Claims repository with an objective to migrate the current portfolio of ad-hoc and scheduled Claims management operational reports to utilize the central Claims Repository.

The deliverables will include establishing central IIW Repository that collects information required to support Business Intelligence Reporting for the Claims Division, and the migration of historical data into the repository.

The goal for Claims Repository is to create single Insurance Industry standards based repository that will not only support today’s information reporting needs but also support the implementation of a new Claims Management Systems in the future. Business Objects Universes will be designed for future Claims Reporting requirements and will be based on the Claims Reporting Data Marts.

Responsibilities:

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

L&T Infotech, Mumbai, India

ETL developer May’ 06 – July’ 07

L&T Infotech is a global IT services and solutions provider. The company’s data come from different operational sources and stored in a data mart, then data is transformed and loaded into a centralized data warehouse for various strategic business reports.

Responsibilities:

Created new Universes and linked with the existing Universes and created reports using Universes and Free hand SQL as Data providers.

Involved in gathering and analyzing End User and Business Owners requirements, user interviews and drafting end users specifications and Business Intelligence needs.

Designed the Data Mart model with Erwin using Star Schema methodology.

Wrote Unix Shell Scripts to automate the process and Created Dimensions and Facts in the physical data model.

Used the Power center Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.

Designed, implemented and deployed some highly complex Business Objects Universes.

Worked on universe performance issues, rectifying loops and in correct joins.

Created classes, objects, Cardinalities, Contexts, Joins, External Strategies and Aliases for resolving Loops and checked the Integrity of the Universes.

The scope of the reporting systems included manufacturing materials management, finance and cost accounting.

Optimized and Tuned Reports performance by Analyzing tables, Checking Optimizer Modes and Partitioned tables.

Used SQL Query’s to generate business objects reports using free hand SQL as a data provider.

Involved in QA phase to test the Classes, Objects and Reports.

Environment: Business Objects 6.5, MS Excel, MS Access 2000, Oracle 8i, Windows 2000 Server, Informatica, Crystal reports 9.0, SQL Loader SQL Server 7.0/2000, Erwin 3.5.

www.linkedin.com/in/srikanth-chava-422b0664

972-***-****

addqze@r.postjobfree.com

Contact this candidate