SUMMARY:

• Around 4 years of experience as Business Object, ETL Informatica and Tableau developer
• Experience focusing on Data warehousing, ETL process and Business Intelligence.
• Package Software: Expertise in Informatica ETL and Business Objects,Tableau reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.
• Drawing on experience in all aspects of data warehousing solutions (ETL Development and reporting solutions) I have been key in delivering innovative database /data warehousing solutions to the Healthcare, Energy, Banking Industries.
• Strong understanding of Relational, Dimensional, Star and Snowflake Schema
• Developed mappings in Informatica to load the data from various sources into the data warehouse and used different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Extensive experience in developing stored procedures, functions, Views and Triggers, Complex queries using SQL Server and Oracle PL/SQL
• SDLC: Around 4 years of IT experience in system analysis, design, coding and testing.
• Business Intelligence: 3.10 years of Business Intelligence experience using BO XI R2 and BO XI R3.
• Worked with BO XI R2/R3 for creating complicated reports including parameter based reports, graphical reports, sub - reports, formula based, well-formatted reports, analysis reports, drilling reports, data reports along with LOV.
• Excellent ability in creating specifications and gathering requirements from users and to develop Reports solutions.
• Expertise in designing Universes, WebI Reports, DeskI reports, and Client-Level Reports.
• Involved in design, prototyping, development, testing, maintenance and support of multiple universes.
• Experience in creating visualizations using Tableau.
• Hands on experience on Tableau Desktop versions 8.2/10.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Experience in coordinating and leading a team.
• Superior communication skills, strong decision making and organizational skills along with outstanding analytical and problem solving skills to undertake challenging jobs. Able to work well independently and also in a team.

TECHNICAL SKILLS:

Operating System: Windows XP, Windows 7/8/8.1/10

Tools: Business Objects XIR2, Business Objects XIR3, Universe Designer, Web-Intelligence, Tableau and MS Visio ETL Informatica PowerCenter 8.1/9.5.1

Languages: C, C++, VB.NET, C#, Java, PL/SQL

Databases: Oracle 9i/11g, MySQL Server 2005, MS Access 2000

Web Applications/Servers: ASP.NET, HTML (Basics)

PROFESSIONAL EXPERIENCE:

Confidential

Informatica/Business Objects/Tableau Developer

Responsibilities:

• Understand the system and interact with business analyst for the requirement and business logic
• Create technical documents based on design and requirements.
• Created documents such as Source-to-Target Data Mapping Document, and Unit Test Cases
• Part of ETL team in creating mappings in Informatica.
• Worked using different data transformations.
• Analyze the existing system - design and manage universe based on the Business Requirements
• Design, Develop and Maintain Universe by defining joins, cardinality between tables applying contexts and alias tables to remove cyclic dependencies
• Use @functions like @select, @where and @prompt function to create prompts which helps the user to select the values dynamically
• Customize the list of values (LOV’s) which helps the end users to select the values.
• Create Aggregate-Aware objects for better performance
• Develop Business Objects Universes with classes, objects and condition objects and develop hierarchies to support drill down reports.
• Create reports using Business Objects functionality like slice and dice drill down, cross tab, master detail tables and formulas, etc.
• Generate reports for web users (depending on users) using Web Intelligence and Info View.
• Create reports using Desktop Intelligence and Web Intelligence in BO XI R3 environment.
• Also created data visualization using Tableau desktop version 10 and followed visual best practice.
• Converted existing BO reports to tableau dashboards
• Developed Tableau data visualization using Cross tabs, Box and Whisker charts, Scatter Plots, Pie Charts and Bar Charts .
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Extensive testing and migrating the reports or objects from development to Production system

Environment: Informatica PowerCenter 9.5.1, Business Objects XI R3, Universe Designer, WebI, Tableau Desktop 10, Oracle 9i, Windows.

ETL/BO Developer

Responsibilities:

• Involved in the analysis of the user requirements and identifying the sources.
• Created technical specification documents based on the requirements.
• Involved in the preparation of High level design documents and Low level design documents.
• Involved in Design, Analysis, Implementation, Testing and support of ETL processes
• Done analysis of Source, Requirements, existing OLTP system and identification of required dimensions and facts from the Database.
• Created Data acquisition and Interface System Design Document.
• Extensively used ETL process for address data cleansing.
• Got trained in developing, support and maintenance for ETL process using Oracle and Informatica PowerCenter.
• Created common reusable objects for the ETL team and overlook coding standards.
• Reviewed high-level design specification and mapping standards.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline.
• Created various Documents such as Source-to-Target Data mapping Document, and Unit Test Cases
• Developed and managed existing Universes, Classes, Objects and Hierarchies based on Business logic. Created Contexts and Aliases for resolving loops and checked the Integrity of the Universes
• Prepared design documents.
• Created complex reports using aggregate awareness functions for SQL enhancement in Designer to handle user requests for report generators.
• Used Slice and Dice, Drill Down, Filters, Master Details, Cross Tab and formulas and developed Hierarchies to support drill down reports and created complex variables, multiple breaks and sorts in the reports
• Trained users on Ad-hoc reporting
• Used functions, formulas in Reports
• Testing Business Objects reports and validated values as per user requirements.
• Developed test cases to check reports
• Coordinated with QA team for Unit/System/Integration testing
• Prepared weekly status reports and reported to client management.
• Coordinated and conducted client meetings.

Environment: Informatica PowerCenter 9.5.1, Oracle 9i, Business Objects XI R3,Universe Designer,WebI and Windows.

BO-Hadoop

Responsibilities:

• Involved in requirement gathering and performed ETL Process.
• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities.
• Was part of the team for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.1.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Update Strategy, joiner and Rank transformations.
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Copied/Exported/Imported the mappings/sessions/ workflows from development to Test Repository and promoted to Production.
• Involved in creating the Source and Target Definitions in Informatica Power Center Designer
• Developed and updated documentation of processes and system.
• Designed/developed/maintained Business Objects Universes.
• Developed Business Objects Reports based on the new business Specifications and Report Standards.
• Determined the dimension attributes, Fact and involved in Star Model design.
• Develop and export Business Objects Reports to refresh automatically via Broadcast Agent daily, weekly and monthly at specific time with pre-defined conditions (filters).
• Supported user’s requests for reports and resolved technical problems.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Involved in development and deployment of Complex Reports.
• Generated analytical reports using Slice and Dice, Drill Down, Cross Tab and Master Detail.
• Tested Business Objects reports and validated values as per user requirements.
• Developed Web Intelligence ad-hoc reports to validate values
• Developed test cases to run the test for Business Objects
• Lead and trained a team of 2 in developing BO reports.
• Coordinating multiple teams on this project
• Prepared weekly status reports and reported to client management.
• Coordinated and conducted client meetings.

Environment: Informatica Power Center 8.1, SQL Server 2005, Oracle 9i/10g, Business Objects XI R3, Universe Designer, Web Intelligence, Windows

Confidential

BO Developer

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications to generate the Reports.
• Interpreted business requirements and created System Requirement Specifications.
• Created universes, classes, objects, complex measure objects, prompts, pre-defined conditions.
• Created universes for the users to do ad-hoc Reporting.
• Resolved loops by either creating aliases or contexts or by defining shortcut Joins.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.

Environment: SQL Server 2005, Oracle 9i/10g, Business Objects XI R3, Universe Designer, Web Intelligence, Windows

BO Developer Team Member

Responsibilities:

• Designed and created universe.
• Created joins, created objects based on requirement, filters in universe level.
• Generating the report based on the user requirements
• Maintaining and supporting the project.
• Used loops, chasm traps, Fan traps, Aliases, Contexts, customized LOVs in Universes, Implemented the row level security, Hierarchies in the universe by which the drill down option is available for user, created Conditions and Filters to improve report generation and Scheduled reports.
• Involved in designing different reports and universe modification based on customer requirements
• Creation of new reports using Web Intelligence having all the report functionalities like sections, Breaks, Alerter, Calculation, variables, Report Filters, Query Filters and Prompts as per the requirement.
• Created reports where user can analyze the data using drill down option.
• Work on formatting the reports according to the user requirements (client was very particular of alignment, colors.)
• Improving report performance
• Validation of universe changes

Environment: Oracle 9i/10g, Business Objects XI R2,DeskI,WebI,Universe Designer,Windows

Junior ETL/BO Developer

Responsibilities:

• Gathered business requirements from Business Analyst.
• Created Technical design document based on the functional design
• Designed the universe.
• Created universe.
• Created joins, created objects based on requirement, filters in universe level.
• Generating the report based on the user requirements(In order to display the check; hyperlink was used)
• Maintaining and supporting the project.
• Worked on and aware of concepts like architecture of BO, loops, chasm traps, Fan traps, Aliases, Contexts, how to resolve loops in the universes, Customized LOVs in Universes, Implemented the row level security, Hierarchies in the universe by which the drill down option is available for user, how to create Conditions and Filters to improve report generation, how to Schedule reports.
• Involved in designing different reports and universe modification based on customer requirements
• Creation of new reports using Web Intelligence having all the report functionalities like sections, Breaks, Alerter, Calculation, variables, Report Filters, Query Filters and Prompts as per the requirement.
• Created reports where user can analyze the data using drill down option.
• Work on formatting the reports according to the user requirements (client was very particular of alignment, colors.)
• Maintaining all existing reports and requirement based modification
• Improving report performance
• Validation of universe changes
• Coordinating multiple teams on various projects

Environment: SQL, Oracle 9i/11g, Business Objects XI R3, Universe Designer, Web Intelligence, Windows