Data Reports

Vasanti Mane

Business Intelligence Developer–Reporting, Analyst and ETL

SUMMARY

Over 5 years of varying IT experience in Banking and Logistics Domain worked mainly in Business Intelligence and Data Warehousing Projects involving Reporting Tools such as Business Objects, Tableau and ETL tool like Informatica.

OBJECTIVES

To obtain a challenging role, working in varied Business Intelligence and Data Warehousing Projects with a leading organization where I can get a chance to explore and expand my business and technical skills and add value to the organization.

CERTIFICATIONS

1.Business Objects Certified Professional – Crystal Report XI (BOCP – CR).

2.Business Objects Certified Professional – Business Objects Enterprise XI.

EXPERIENCE

Experience working in Reporting and ETL Tools - Business Objects, Tableau and Informatica.

Well-versed with all stages of software development life cycle (SDLC) and Agile methodology.

Professional experience in Design, Development, Testing and Deployment of Reports and dashboards using Business Objects and Tableau.

Extensively Used CMC (Central Management Console) for applying security and scheduling the report.

Excellent Knowledge of Data warehousing concepts like Star Schema, Snow Flake Schema, Fact and Dimension tables.

Developed various Complex Reports, Summary Reports, Cross-tab Reports, Drill Through and Drill down Reports using different Data Sources in Web Intelligence, Desktop Intelligence.

Extensively used BO Universe and Crystal Reports.

Good knowledge of creating Tableau and Crystal Xcelsius dashboard.

Experience in Informatica Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager

Good experience in RDBMS such as Oracle and SQL Server

Experience in writing SQL Stored Procedures

Experience in creating test data for testing Informatica mapping rules and other ETL process.

Good experience in working with the Offshore Teams.

Ability in quick understanding and learning a new Technology.

Effective and self-motivated team player having good verbal and written communication.

PROFESSIONAL AND TECHNICAL SKILLS

TECHNOLOGY

Skills Set

Databases

Oracle 10G / 9i / 8i, SQL Server 2000/2005, MS Access 00/05

ETL Tools

Informatica

Business Objects Data Integrator(BODI)

Reporting Tools

SAP BO, Web Intelligence, Desktop Intelligence, Crystal Reports XIR2 / XI /10 and Tableau 9.2.

Languages

VB 6.0, ASP.Net, PL/SQL, C, C++

Operating Systems

Windows 95 / 98 / NT / 2000 / XP, MS-DOS, Unix

Other Tools

MS Office, Remedy

EDUCATION QUALIFICATIONS

Degree

School / University Name

Any specialization

M.Phil.

Bharathi Vidyapeeth, India

Information Technology

M.C.A.

Shivaji University, India

Computer Applications

B.Sc.

Shivaji University, India

Physics

PROFESSIONAL HIGHLIGHTS

1.Cognizant Technology Solutions, USA Jan 2015 to Feb 2016

Customer: Aetna

Role: Business Intelligence Developer

Description:

This project was initiated to support and enhance existing reports and dashboards which are created and deployed using BI tools business objects, Tableau and Informatica.

Responsibilities:

Worked closely with business users to gather and analyze requirements.

Performed data analysis and ad-hoc queries on the existing database.

Published Reports to CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats.

Enhanced and tuned Existing Reports for better performance.

Worked on Business Object universes to create Contexts, Joins, conditions and Aliases for resolving loops and checked the Integrity of the Universes.

Created multiple Business Intelligence (BI) reports in Cross Tab, Master Detail and Tabular formats.

Created various complex reports including Conditional, Drill-down, Top N, Summary, Form and Sub-reports based on multiple queries.

Converted DeskI Reports to WebI using Report conversion tool.

Created Derived Tables in the universe.

Experience in using different features of Tableau Desktop I.e. Filters, Parameter, Actions, Calculations (using logical, String, Table, Aggregate functions) and formatting the reports/dashboards (Layout Containers, Annotations, Mark Labels etc.)

Developed Tableau visualizations and dashboards using Tableau Desktop.

Developed Tableau workbooks from multiple data sources using Data Blending

Created action filters, parameters for preparing dashboards and worksheets in Tableau.

Worked on Informatica ETL jobs to monitor daily and weekly data transfer jobs based on support roster. Involved in on call support.

Supported QA team for QA testing.

Environment: SAP BO, Tableau 9.2, Oracle 11g, Informatica, Web Intelligence, UDT, IDT and Windows 2008 server

2.R Systems International, Noida, India Dec 2012 to Dec 2013

Customer: State Bank of India

Role: Business Object Developer

Description:

This project comprises of various applications which deals with Credit Card processing, maintaining customer history data as well as transactional data and customer personal Information etc.

Responsibilities:

Interacted with the business users to gather the requirements.

Developed High level and Detail Design Document

Monitored and supported data warehouse and data marts.

Resolved business queries of users by writing and running SQL script on oracle.

Carry out analysis of the given data and draw correct inferences, in keeping the objectives of the analysis.

Performed data analysis on the existing data warehouse's

Created users, groups.

Worked on Informatica ETL jobs to monitor daily and weekly data transfer jobs based on support roster.

Effectively used Change Management Request using support central tool.

Created Derived tables at universe level to resolve report level complexity.

Implemented Row Level, Object Level security for data restriction at Universe level

Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.

Used Filters and Conditions, Slice and Dice.

Wrote Complex SQL Queries for Data validation purpose.

Worked on Crystal Xcelsius for dashboards.

Involved in Documentation, Weekend Support and Testing.

Supported QA team for QA testing.

Environment: BO XI3.1, Oracle 11g, Web Intelligence, Crystal Xcelsius, Crystal Report, CMC, Universe Designer, Import wizard, CCM, UNIX, Informatica and Windows 2008 server

3. OTIS ISRC, Pune, India Oct 2008 to Oct 2009

Customer: OTIS

Role: Business Objects Developer

Description:

eLogistics was designed to decrease the sales cycle time, improve order quality, increase productivity and reduce costs. The eLogistics will yield dramatic improvements in reducing order errors and order cycle time, and will also enable the company to move to market-based pricing.

Responsibilities:

Involved in the Requirements gathering and Designing of Business Objects Report development.

Designed, built, and maintained Business Objects universes.

Worked on Business Objects XI Web intelligence reports.

Created complex reports using cascading prompts.

Created Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.

Created multiple Business Intelligence (BI) reports in Cross Tab, Master Detail and Tabular format.

Used Filters and Conditions, Slice and Dice

Created various complex reports including Conditional, Drill-down, Top N, Summary, Form and Sub-reports.

Administration using CMC –Applied security based on role of the employee.

Extensively Used BODI to develop ETL

Created reports based on multiple queries.

Row level restrictions applied in the universe.

Always made the deliverables on time, in proper quality and to the user satisfaction.

Interacted with the QA team to test the reports.

Interacted with team lead and updated the status.

Created technical and user documentation which has the step-by-step process of creating reports and using the functionality of Business Objects.

Environment: BO XIR2, SQL Server 2005, Web Intelligence, BODI, CMC, Universe Designer, Import wizard, and Windows 2003 server

4.OTIS ISRC, Pune, India May 2008 to Sept 2008

Customer: OTIS

Role: Business Objects Developer

Description:

France SDW project is for Sales department. All level users can see their related sales, margin and discount in report. Similar security has been applied to the users at Branch, Region, Zone and Company level.

Reports are divided into two categories.

Standard Reports

All the reports that are used by all the users have been grouped as “Standard Reports. These reports were available to all the users. However, the data displayed in the reports was secured depending upon the user’s profile or portfolio.

Management Reports

All the reports that are prepared for the analysis by the management have been grouped as “Management Reports”. These reports were available to Management users only.

Responsibilities:

Created Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.

Worked on Business Objects XI Web intelligence reports.

Created hierarchies, complex objects using various @functions and aggregate aware objects in the universe

Created complex reports using cascading prompts and List of objects.

Created multiple Business Intelligence (BI) reports in Cross Tab, Master Detail and Tabular format.

Developed various charts and graphs like Bar chart (side by side, stacked), line graphs, pie charts etc.

Provide weekly updates to Team lead.

Interacted with the QA team to test the reports.

Environment: BO XIR2, Oracle 10g, Web Intelligence, BODI, CMC, Universe Designer, Import wizard, and Windows 2003 server

5.Deknot, Pune, India Dec 2004 to Mar 2006

Role: Crystal Report Trainee

Description:

This project was initiated to design and develop various reports in HR module of HRPS system.

Responsibilities:

Created tables, inserted data into the table in SQL Server 2000.

Developed user interface sheets.

Extensively used Grid Views with sorting and paging.

Created and tested reports.

Environment: Windows 2000, ASP.Net, SQL Server, Crystal Report.

Contact this candidate