TECHNICAL SUMMARY:

Business Objects Tools: Business Objects 4.x/3.1/R2, Web Intelligence, Universe Design Tool (UDT), Information Design Tool (IDT), Desktop Intelligence, InfoView, BI Launchpad, CMC, Import / Export wizard, Report Conversion Tool, Analysis for Office(AO)

ETL Tools: Informatica Powercenter, UC4

Reporting Tools: BO, OBIEE, Crystal Reports

Data Visualization Tools: Tableau Desktop 10 / 9, Tableau Public 10

Query Tools: TOAD, SQL*PLUS, MS SQL Express, SQL Analyser, SQL Navigator

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2005, MS Access, Sybase, Teradata

Operating Systems: Windows Server 2013, Windows 7/ XP/2000/98/95, DOS, UNIX.

Testing Tools: Quality Center 9.0, JIRA

Programming Languages: SQL, PL/SQL, C, C++, Visual Basic

WORK EXPERIENCE:

Confidential

Responsibilities:

• Experience in Business Intelligence Reports development using SAP Business Objects 4.x/XI - R3.1/R2 with BI Launchpad, Infoview, Web Intelligence, Webi Rich Client, Desktop Intelligence, Crystal Reports.
• Report development using features like single/multiple Data Providers, Combined Queries, Subqueries, Merged Objects, Crosstabs, Charts, Hyperlinks, Drill functionality, Scope of Analysis, Ranking, Sorting, Slice and dice, Query Filters, Report Filters, Input Control, Optional prompts, Variables, Formula editor / Expression Builder, Conditional Formatting, Breaks, Sections, Custom SQL etc.
• Universe Development using UDT /IDT and features like Connections, Table joins, Alias, Context using Data Foundation, Defining classes and Objects - dimension, measure, detail, filter conditions objects in Business Layer, Check integrity, Object Properties, BO Functions like @prompt(), @select(), Dummy/hidden objects, Derived tables, Hierarchies, SQL functions in object definition, Query Panel, Objects format editing, Aggregate Awareness etc.
• Experience in BO Reports testing .
• Creation of Test cases, Test Data for positive and negative test scenario, Query analysis, Building ad hoc test reports for Universe objects/conditions testing, Reviewing Design documents for new Change request, Functional and White box testing of WEBI reports. Root cause analysis of Data related issues using SQL scripts and troubleshooting, In BI Support projects - Analyzed and resolved BO Reports related issues in WEBI reports and Universe. Resolving L3 through L1 level of issues. Customer Interaction and issue logging using tools like JIRA, QC etc. Functional testing of the various DB scripts which includes procedures, functions, etc and validating data
• Experience in BO Admin activities .
• Familiar with Import and Export of BIAR files, Creation of Users, Folders, Groups, and Roles. Checking rights, Scheduling reports, testing SSO settings. Participated in BI Upgrade project and did the required installations and configuration settings like SSO, Publishing Certificate etc.

Confidential

Responsibilities:

• Experience in Dashboard development using Tableau. Developed different type of charts - Bar Chart, Pie Chart, Line Chart, Scatter Plot, Treemap, Heat Map, Maps chart for Geographical data, Dual axis charts, Trend lines, etc
• Creating and modifying Oracle View scripts to be used in source for the Tableau Data Extracts
• Modification of Source data in Tableau by adding custom columns, changing data formats
• Manipulating table/charts data using different Level of Details.
• Using different features like Sort, Filter, Parameters, Groups, Sets, Hierarchies, Data Range, Trend lines for correct representation of data.
• Created calculated fields, Aggregate calculations using group functions.
• Used Context Filters in tables for logical grouping.
• Used joins between multiple data sources.
• Used data blending to collect data from different types of source
• Created dashboard to represent different charts of same subject area and used common input controls for all
• Meeting with end users and demo of the charts and dashboards which are ready to be released for UAT
• Tableau visualizations testing by comparing the charts with underline source data using SQL, creating custom charts.

Confidential

Responsibilities:

• Experience in ETL Testing and Data Analysis using Informatica Powercenter, SQL
• Design document review for change requests, Creation of Test plan and Test case scenario documents, Review and modification of mapping / data transformation documents to understand data flow before actual ETL load.
• Preparation of Test data using system applications by considering all business scenarios, Analyzing Source Qualifier query to validate fulfilment of business requirement and test data, Scheduling ETL jobs using third party tool like UC4, etc
• White Box testing of ETL jobs by executing test workflows. Using Mapping designer, Workflow Manager and Workflow monitor tools to troubleshoot issues.
• Analyzing and testing the data flow through various transformations, filters / parameters set in session properties, Running specific session / task vs entire workflow, testing the script in command line task, Parameter file contents, ETL load strategy etc, Simulating actual PROD ETL execution scenario by modifying parameter file in QA and running the session.
• Functional testing of ETL jobs. Preparing SQL script for source/target Data validation. Test data preparation in source system, Using Quality Center for defects tracking, Review of Functional and Design documents of ETL changes. Querying the database for validation of test data in source and target system. Using SQL options - MINUS, DBLink, UNION, JOINS for data analysis.
• Issues reporting and follow up using Test management tool QC (Quality Center). Preparation of Test Result document with details of Functional and Integration testing done

Confidential

Responsibilities:

• Analysis of Opportunities data to develop a Logistic Regression model in R programming.
• This was to find out the possibility of opportunities to be converted into actual sales.
• Identifying correct attributes for the model, splitting the record set for training the model and testing purpose.
• Finding the accuracy of the model.
• Analysis of inter relation of Products and Customers data to find out Association of Rules .
• Deriving the parameters like Support, Confidence and Lift in the source data to find out the possibility of customers buying certain set of products.
• Running these models against different csv files containing different periods of data.
• Plotting appropriate graphs for representation of the results found.
• Used libraries like caTools, plyr, arules and functions like glm, predict, ddply, apriori, inspect etc in R for these algorithms