Sql Server Reports

Senior Business Intelligence Developer

KIRAN

PH: 510-***-****

E-mail: ********@****************.***

SUMMARY

Ten plus (10+) years of real time IT experience in Business Intelligence field in USA.

Expertise in gathering reporting requirements and business rules from business users

Expertise in translating requirements into user stories using Jira and Rally project tracking softwares

Expertise in Tableau 10.0/9.x/8.x/7.x desktop (Filters, data blending, Parameters, Sets, Groups, LOD Objects, Dashboard/Worksheet Actions, Visualizations, Hierarchies, Extracts, Connections), Tableau Application Server 10.x/9.x/8.x/7.x responsibilities including Users/Groups creation, workbook Permissions, Usage Statistics, Schedules & Subscriptions

Expertise in creating Oracle Business Intelligence tool OBIEE 11g/10g Interactive Dashboards with drill-down, hyperlinks and guided navigation capabilities involving Sections, columns, Tables, Pivot Tables, Charts/Graphs, column selector, view selector, Session variables, Custom SQL and more OBIEE features

Expertise in testing data integrity related errors in dashboards and identifying if the issue is within the report or in ETL or in Source and recommend solutions accordingly

Expertise in Business Intelligence tools using Business Objects XI R2/6.5/6.1/5.1.7 (Supervisor, Designer, Reporter, Broadcast Agent, ZABO, Web Intelligence), Application Foundation, Performance analysis, Goal Management

Scheduled and published reports using Tableau Application Server, iBots in OBIEE and Broadcast Agent server, WEBI XI using business Objects.

Technical knowledge in ACL Software and Informatica

Knowledge of Oracle Applications/E-Business Suite

Knowledge in Data warehouse concepts like Star Schema, Snowflake Schema and Multi-Dimensional Model in relation to query and analysis requirements

Excellent communication and interpersonal skills, Self-Starter, quick learner, Strong sense of responsibility, adapt to new environments and integrity in work

TECHNICAL SKILLS (worked & have knowledge on):

BI Tools

Tableau Desktop 10.0/9.x/8.x/7.x, Tableau Server 10.0/9.x/8.x, OBIEE 11g/10g (RPD, Answers, Dashboards, iBots), Business Objects XI R1/R2/6.x/5.x, Web Intelligence 6.x/2.x, WEBI SDK, Info view 2.0/1.0, Designer, Supervisor, BCA, ZABO, Application Foundation 6.x/2.5

Databases

Oracle 11i/10g, SQL Server 200X, MS-Access, Teradata, ACL Exchange Server 5

Database Tools

SQL Navigator, TOAD, MS SQL Query Analyzer, Teradata SQL Assistant, Oracle PL/SQL, Splunk 6.2.5, ACL Software 11.1

Programming Languages

C, C++, Java 2.0, Javascript, PL/SQL, SQL, HTML

Other

JIRA, Rally, Adobe Works, MS-Office Suite 20xx (Word, Access, PowerPoint, Excel, outlook), MS Visio, Oracle User Productivity Kit (UPK), Oracle Applications/EBS, Oracle Financials

Operating Systems

Windows 7/XP/2000/9x. MS-DOS

Methodologies

Agile/Scrum, Waterfall, SDLC/Prototyping

EDUCATION

2003-2005 - Master’s Degree in Interdisciplinary Studies majoring in Computer Science, Texas A&M University – Commerce, Texas, USA

1996-2000 - Bachelor’s Degree in Computer Science & Engineering, Jaya Engineering College, Madras University, Chennai, INDIA

PROFESSIONAL EXPERIENCE

Verticals worked for: Insurance, Finance/Banking, Bio-Medical, Networking

Clientele

CISCO Systems, Milpitas, CA NOV’16 – Current

Engineer IT – Sr. Tableau Developer

Responsibilities:

As part of WW Collaboration Sales team, involved in gathering requirements for tableau dashboard

Involved in war rooms for KPI metrics, forecast analysis and pipeline data analysis

Involved in identifying the business insights on low performing areas on KPI metrics through tableau dashboards that helped business make executive decisions

Involved in analysis of pipeline trend, bookings projection & product sales data

Developed tableau dashboards using tableau 10 and acted as tableau application admin

Utilized SFDC report downloads tableau data source for building reports and dashboards

Involved in creating performance dashboard on tableau server to analyze tableau data statistics and the usage of dashboards by customers.

Working with various stakeholders to demo the tableau dashboards that help them improve their business needs

Working as a collaborator between offshore team and onsite team to get the projects to completion

Perform internal QA analysis on dashboards, reports that are ready for UAT

Migrate dashboards and reports between different environments (Dev, Stage, Prod)

Coordinate with database teams onsite and offshore in case of any database issues, SQL data load fail, new requirements to create SQL table, view or a stored procedure

Provide knowledge transfer to customers and power business users on tableau

Environment: Tableau Desktop, Server 10.0, MS SQL Server 2016, Business Objects WEBI, SFDC, Smart sheet, BOX, MS Office 2016 (Excel, Word, Power Point, One Note), MS Outlook 2016, Agile methodology

VISA Inc., Foster City, CA MAY’15 – OCT’16

Contractor - Senior Tableau Developer

Responsibilities:

Gather requirements from business users and converted them to Jira user stories.

Involved in meetings with stakeholders to understand the User Stories, KPI metrics and dashboard/report mock-ups prior to development.

Responsible for development of dashboards & reports using Tableau Desktop 9.2.6

Responsible for creating new/Enhancing existing tableau workbooks using Tableau Extracts, Live Connection, Custom SQL as links to data sources.

Acted as Tableau Admin (Application level) to Create/Add Users, grant permissions to users for accessing workbooks/views, Publish/Schedule workbooks/dashboards and to generate Statistical data related to Usage and Performance.

Applied hyperlinks to navigate to different dashboards and sheets/tabs using Actions, used filters to filter the data on the dashboard reports, used parameters to change to different views or hide views on the dashboard in tableau workbooks.

Applied blending on common columns in the tableau extracts from different data sources to pull data from multiple data connections.

Involved with Java scripting team to apply the Java Script API and interface tableau dashboards and sheets developed.

Responsible for Unit Testing, migration of workbooks/dashboard per different phases of the project (development to UAT to production).

Environment: Tableau Desktop/Server 9.2.6/9.2.4/9.0.1, Tableau Javascript API 2.x, Oracle (ODS), MS Excel 2013, MS Power Point, Oracle PL/SQL, Jira, Informatica, Windows 7 Enterprise, Splunk 6.2.5

CISCO Systems, Milpitas, CA MAR’13 – MAY’15

Engineer – BI Tableau Developer

Responsibilities:

Responsible for gathering requirements from business users and transformed them into Rally user stories

Involved in war room discussion of User Stories, metrics analysis

Responsible for the development of various ad hoc/complex dashboards & reports using Tableau Desktop 8.2.4/7.x

Responsible for creating new/Enhancing existing tableau workbooks using Tableau Extracts, Live Connection, Custom SQL as links to data sources.

Developed a powerful Audit tableau Dashboard used by executive level to track errors within each team

Worked with ACL software team to get the .fil files in the form of excel as one of the data sources for tableau.

Acted as Tableau Admin (Application level) to Create/Add Users, grant permissions to users for accessing workbooks/views, Publish/Schedule workbooks/dashboards and to generate Statistical data related to Usage and Performance.

Applied hyperlinks, blending, Actions, filters, parameters tableau workbooks.

Responsible for Unit Testing, UAT and generating test scripts.

Responsible for migration of workbooks/dashboard per different phases of the project (development to testing to production).

Responsible for developing GMI Mobile dashboard/reports using OBIEE for users to demo know-how and to provide the look and feel of dashboards/reports on Apple iPad using OBIEE.

Responsible for creating multiple dashboards involving multiple pages, guided navigation from one page to another, hyperlinks to navigate from Summary reports to Details report and to Ad-hoc/stand-alone reports.

Performed Unit Testing and data integrity testing for the reports/dashboards developed.

Involved in knowledge transfer sessions to testers, Analysts and business Users.

Environment: Tableau Desktop/Server 8.x/7.x, OBIEE 11g (Answers, Dashboards, iBots, Repository), Teradata, Oracle, PL/SQL, Clarity-PPM, Rally Software, MS Office 2007/2010, Windows XP, SQL Assistant for Teradata, TOAD, ACL 11.1, ACL Exchange Server 5

Beckman Coulter Inc., Brea, CA NOV’07 – FEB’13

Senior Applications Architect/Senior IT Analyst

Responsibilities:

Conducted interactive sessions with business users to gather requirements for new reports and to finalize requirements

Involved in interactive analysis of report requirements, metrics analysis, Story board design and KPI analysis, validation of OBIEE Data Model

Continuous support for Global Service Reporting Team creating stand-alone reports, dashboards.

Developed and maintained several ad hoc, complex dashboards and reports using OBIEE and BO XI R2

Responsible for functional and technical documentation including Unit test Documents, UAT scripts, MD050s, MD070s, migrating reports/dashboards between various environments (DEV, INT, UAT and PROD).

Scheduled and published various dashboards and reports to different users/groups using iBots in OBIEE, BO XI R2 scheduling feature

Responsible for Unit Testing of the reports, both canned and ad-hoc, developed.

Provided knowledge transfer sessions for testers, business analysts, business Users, technical assistance/support to analysts, business community/business users and responded to inquiries regarding errors, problems or questions.

Environment: OBIEE 10.1.3.4.1 (Answers, Dashboards, iBots), UPK 3.5.1, Informatica 8.1, Business Objects XI R2/6.5 (Designer, Desktop Intelligence, Web Intelligence (Infoview), Oracle Apps/EBS, SQL Server 2000 with SP3,Oracle 11i, MS Office 2010/2007/2003, Windows XP, TOAD for Oracle 8.6.0.38

Vedicsoft Solutions Inc., Iselin, NJ OCT’05 – NOV’07

Computer Systems Analyst

Clientele

Beckman Coulter Inc., Fullerton, CA MAR’07-NOV’07

Business Objects XI Reports Developer

Responsibilities:

Responsible for gathering the business requirements and in documentation.

Created and developed financial reports, Auto & Home insurance reports in BO6.5 and WEBI XI R1.

Developed service/cost analysis reports using WEBI XI R2.

Modified the existing reports depending on the user requirements.

Developed highly complex reports using reporter and used various techniques like Master-Detail, Sectioning, Filters, Slice and Dice, Ranking.

Responsible for self-debugging errors occurred in Web Intelligence.

Created reports and generated graphs for multi-dimensional analysis using Slice & Dice functionality.

Scheduled and monitored reports using XI R2 Scheduling.

Published various reports to different users/groups in XI R2.

Responsible for Unit Testing of the reports, both canned and ad-hoc, developed.

Provided technical assistance/support to analysts, business community/business users and responded to inquiries regarding errors, problems or questions.

Environment: Business Objects XI R2/6.5 (Designer, Desktop Intelligence, Web Intelligence/Info view), Oracle Apps/EBS, SQL Server 2000,Oracle 11i, MS Office 2003/2007, Windows XP, TOAD for Oracle 8.6.0.38.

City National Bank, Los Angeles, CA OCT’06-FEB’07

Business Objects Consultant

Responsibilities:

Created reports in full client using BO 6.5, modified BO Universes, used @ functions, creating Classes, Objects and hierarchies for the multidimensional analysis of database

Reports involved master-detail sections, drill-up/drill-down functionalities, alerters, filters, ranking and sorts

Built queries by creating and applying complex conditions and sorts, User Object, LOVs and by writing free hand SQL

Scheduled, published reports on daily/weekly/monthly basis using broadcast agent

Created and maintained users/user groups using BO Supervisor 6.5.

Environment: Business Objects 6.5 (WEBI (Infoview), Supervisor, Designer, BCA), Business Objects Data Integrator 6.5, Oracle 10g, SQL Server, Oracle Financials, PL/SQL, TOAD, Windows Professional, MS Access & MS Excel 2002.

Farmers Insurance, Los Angeles, CA JUL’06 – SEP’06

BO WEBI REPORTS DEVELOPER

Responsibilities:

Responsible for gathering the business requirements and in documentation.

Developed highly complex reports using reporter and used various techniques like Master-Detail, Sectioning, Filters, Slice and Dice, Ranking.

Developed and modified reports in Versions Business Objects XI R1 & R2.

Involved in building reports based on the data marts APDM, HPDM & MLCDM

Created reports and generated graphs for multi-dimensional analysis using Slice & Dice, Drill Up/Down functionality.

Scheduled, published and monitored reports in WEBI to other Users/Developers/Power Users.

Responsible for creating test database in Access and unit test the reports accordingly for data consistency, tested Universe table joins, contexts, defects in reports, fixing the defects in reports.

Interacted with ETL Team to fix the data defects in the reports.

Environment: Business Objects XI R1 & R2 (Designer, WEBI), TOAD for DB2 V 8.2, DB2, AIX server, Informatica V7, MS Access, Excel, Word, Windows XP.

ACS-INC, SANTA ANA, CA JAN‘06 – JUN’06

OPEN SYSTEMS DEVELOPER W/BUSINESS OBJECTS

Responsibilities:

Modified the existing reports depending on the user requirements.

Maintained and Modified Universes using Designer and exported them to the Repository.

Developed highly complex reports using reporter and used various techniques like Master-Detail, Sectioning, Filters, Slice and Dice, Ranking.

Responsible for the Up gradation of the repository from one version to the other.

Migrated Universes, Reports from one version to the other.

Responsible for unit testing, self-debugging the errors occurred in Web Intelligence.

Created reports and generated graphs for multi-dimensional analysis using Slice & Dice, Drill Up/Down functionality.

Scheduled, published, monitored reports using BCA console, publisher

Used BO Supervisor for creating the repository, creating users and groups, assigning privileges to them, creating categories and setting permissions for various users.

Responsible for the safe recovery of the bomain.key file, Uninstalling – Installing - - Configuring Business Objects 6.5, Configuring Application Foundation 6.5.

Created Dashboards from the existing metric universes using Dashboard Manager.

Environment: Business Objects 6.5.1/6.1.3 (Designer, Supervisor, Web Intelligence 6x, Broad Cast Agent, Publisher, ZABO), Application Foundation 6.5, SQL, Windows Professional, SQL Server 2k3 (Advanced) with SP4.

Contact this candidate