SUMMARY:

• BI Developer with 7 years of experience in Enterprise Reporting and Business Intelligence solution.
• 4+ years of experience in implementing full lifecycle Business Intelligence Solutions, including Requirements Gathering, Designing, Developing Universes, Reports and Dashboards using SAP Business Objects Suite.
• 3+ years of experience in implementing Business Intelligence Solutions, including Requirements Gathering, Designing and Developing solutions in MS SQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Integration Services (SSIS).
• Experience in Developing Performance Dashboards, Score cards, Metrics, What if analysis, Prompts, Drills, Search (using Add - ons), Reports/Dashboards using TABLEAU.
• Technical hands-on expertise using SAP Business Objects BI4.0 & SAP Business Objects Enterprise XI3.1 (Universe Designer, Info View, Web Intelligence, Import Wizard, Report Conversion Tool, CMC).
• Extensive Knowledge in SAP Business Objects BI4.0 (Interactive Analysis, Dashboard Design Tool, Information Design Tool and BO Explorer).
• Expertise in creating complex universes using Joins, Conditions, Filters, LOV, cardinality, Aliases, Contexts, Index Awareness, @Prompts, @Aggregate Awareness and resolving problems like Loops, Traps.
• Designed and developed BO single and multisource universes using Universe Design Tool and Information Design Tool.
• Expertise in developing complex reports using multiple data providers, employing functionalities like Merge Dimension, Prompts, Slice and Dice, Drill down, Variables, Functions, Hyperlinks, Input Control and Filters.
• Experience in Dashboards4.0 for creating dashboards using Combo Box, List Box, Dynamic Visibility, What-if presentation, Slider, Filtered rows and Alerts.
• Experience working with Import Wizard and Report Conversion Tool for migrating the Universes and Reports between different environments like Development, QA and Production.
• Technical hands-on expertise in developing & deploying cubes using SQL Server Analysis Services involving multidimensional data.
• Experience with Creating dimensions, cubes and modifying measures and attributes, creating hierarchies and relationships among dimensions and facts in MS SQL Server Analysis Services (SSAS).
• Experience in creating tabular models using various complex data sources including database tables, excel, flat-files etc.
• Extensive Knowledge in designing complex reports using Cascading parameters, Drill-Through Reports, Parameterized Reports, Sub reports and AdHoc reports using SQL Server Reporting Services (SSRS).
• Experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008R2/2008.
• Expertise in data Extraction, Transformation and Load using MS SQL Server Integration Services (SSIS).
• Experience working with various transformations like Conditional split, aggregate, merge join, sort, Multicast to load data into Data Warehouse.
• Experience in Data Conversion and Data Migration using SSIS services across different databases like Oracle, MS access and flat files.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security. Experience with Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management. End to end experience in designing and deploying data visualizations using Tableau.
• Certified in INSURANCE Domain on INS21- Property& Liability Insurance Principles, INS23 - Commercial Insurance.
• Worked on several Agile Projects possessing strong knowledge on its process and practice. Have completed SCRUM Team Member certification.
• Experience in Testing and Bug Fixing of Universes/Reports and logging defects using IM Quality Center.
• Extensive knowledge in Data Warehousing concepts, Dimensional data modeling, Star Schema, Snow-Flake Schema, Normalization/De-normalization, Physical and Logical modeling.
• Involved in various phases of project life cycle such as Design, Development, Implementation, Testing and Maintenance.
• Managed Offshore-Onsite model and experienced in implementing outsourced projects from planning to delivery phase.
• Responsible for Project management activities like project estimation, planning, cost and schedule tracking, resource management and performance reporting for multiple projects.
• Excellent communication, interpersonal and analytical skills with the ability to work independently and in a team.
• In depth knowledge in Insurance Domain and ability to relate Technical with Business requirement needs.

TECHNICAL & DOMAIN SKILLS:

Tools: SAP Business Objects BI 4.0/XI 3.1 (Information Designer Tool, Universe Designer Tool, Webi Rich Client, Dashboards, Import Wizard, CMC), Microsoft SQL Server Analysis Services(SSAS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Integration Services (SSIS), Tableau Desktop 10.0 and SAP Lumira 41

Databases: Oracle 9i/10G/11G, SQL Server 2008, MS Access

DB Querying Tools: Toad 11.5, SQL Server Management Studio

Languages: SQL, PL/SQL

Operating Systems: Windows XP/ 2000/2003/2008

Others: Microsoft Suite 2010(Excel, PowerPoint, Access), HP ALM Quality Center, Ultra Edit

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

Senior Business Intelligence Developer

Responsibilities:

• Interacted with Business Managers and representatives from Customer Care Team ( Confidential ) & Customer Care Center ( Confidential ) in gathering business requirements and Involved in project activities like Impact Analysis and creating business requirement documentation, project estimates.
• Planning of timelines, resources and cost estimates for each phase of the project (development, quality, testing and deliverance).
• Analyzed source system reports in Report Builder and documented metrics involved in each of those.
• Design database models and ER diagrams integrating existing and new tables, based on business requirements and corporate database development standards. Create data mapping of the new fields to existing or new data sources using SQL Server Analysis Services (SSAS).
• Designed and developed SQL Server Reporting Services (SSRS) reports based on the tabular model exactly mimicking the source report.
• Performed QAT and involved in hosting the reports to the server and providing access to business users.

Environment: SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Oracle 10g, SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Report Builder 3.0.

Confidential

Responsibilities:

• Interacted with Business Managers and Executives in gathering business requirements and Involved in project activities like Impact Analysis and creating business requirement documentation, project estimates.
• Planning of timelines, resources and cost estimates for each phase of the project (development, quality, testing and deliverance).
• Involved in Sprint planning, review, retrospective and demo during development.
• Design database models and ER diagrams integrating existing and new tables, based on business requirements and corporate database development standards. Create data mapping of the new fields to existing or new data sources using SQL Server Analysis Services (SSAS).
• Developed dashboards, reports utilizing Tableau visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• ·Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart. Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• ·Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's.
• Utilized Tableau server to publish and share the reports with the business users. Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group. Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Environment: SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Oracle 10g, Tableau Desktop 10, Tableau Server.

Confidential

Responsibilities:

• Interacted with Business Managers and Executives in gathering business requirements and Involved in project activities like Impact Analysis and creating business requirement documentation, project estimates.
• Planning of timelines, resources and cost estimates for each phase of the project (development, quality, testing and deliverance).
• Created optimized SQL queries consisting of Facts and Dimensions to load the SQL server tables that are populated on daily basis.
• Scripted Stored Procedures to join those tables into a master tables with a check to bring in rolling 2 years data.
• Worked on creating SQL server job to process the tables and monitored for any failures and fixes.
• Design SSAS tabular model with required calculation as per the business.
• Built efficient SSIS packages for processing fact and dimension tables with complex transformations like Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Developed power pivot report with slicers, report filter and trend graph.

Environment: SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Oracle 10g, Microsoft Excel.

Confidential

Responsibilities:

• Interacted with Business Managers and Executives in gathering business requirements and Involved in project activities like Impact Analysis and creating business requirement documentation, project estimates.
• Planning of timelines, resources and cost estimates for each phase of the project (development, quality, testing and deliverance).
• Involved throughout the complete system Development Life Cycle.
• Involved in discussions with the architecture team for the reporting data mart data model
• Used BI 4.0 Information Designer Tool to design Universes, joining tables, creating prompts and applies Contexts and Aliases to remove loops.
• Created complex Business Objects Reports using Input Controls, Drill Filters and Hyperlinks etc.
• Evaluated other Reporting Tools like COGNOS, MicroStrategy and Microsoft BI.
• Designed financial reports, HR reports, standard and adhoc reports, and universes, as part of POC

Environment: SAP BI4.0 (Information Designer Tool, Infoview), Oracle 10g

Confidential

Business Intelligence Lead Developer

Responsibilities:

• Demonstrated numerous demos to business owner and user community so as to have a strong understanding about developed Business Objects application and the product features.
• Created Business Objects Universe using Designer involving complex joins, cardinalities.
• Created new Universes and fine-tuned existing ones by resolving join problems, setting up aggregate awareness, defining hierarchies, cascading LOV, @Functions and more.
• Extensively used Universe features like @functions including @Aggregate awareness and Derived Tables.
• Applied restrictions on the connections at the universe level so that a user can have access to particular Ad group.
• Implemented Security features of Business Objects like row level, object level and report level to make the data secure.
• Created hierarchies and customized LOV’s at universe level for the end-user.
• Interacted with universe users and supported regularly to generate the required reports and to solve the existing issues.
• Enhancements to existing universe like adding new tables, creating new dimensions and measures.
• Creating reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill Down, Cross Tab, Charts, Input Controls, Master Detail and Formula.
• Developed Master/Detail and company trending analysis reports using bar graphs and used Drill Filters for drilling down on graphs and tables to display data at various organizational levels.
• Peer review of reports to follow Standards and Guidelines. Experienced in reviewing reports and presenting to end users and also making modifications if required based on user requirements.
• Validated the universe joins, cardinalities, derived tables, dimensions, measures and filters.
• Have used Alerts, Variables, Prompts, and also generated hyperlink reports using OPENDOC / Document Link function in WEBI reports.
• Involved in four phases of Migration such as Planning & Assessment, Migration, Validation, and Deployment
• Performance Tuning of the reports in BO.
• Worked on Migration, Best Practices for Migration, Migration Process, and Analyzing Repository and Import Wizard functionality.
• Created different types of reports, like master/detail, cross tab and chart (for trend analysis). Used filters, conditions, calculations, etc using BO.
• Conducted user training sessions and supported them with their requests for enhancements, modifications and new adhoc reports.
• Provided End Users Training to Corporate customers in order to effectively use the business Objects product functionalities for optimal output.

Environment: SAP BO XI R3.1 (Designer, Web Intelligence), Oracle 10g

Confidential

Business Objects Developer\Tester

Responsibilities:

• Involved in project activities from Requirements Gathering, impact analysis, Creating the Business Requirement Document, Functional Specification Document, Technical Design Document, Report Design and unit testing.
• Created New Universes from scratch in Business Objects XI3.1 and Built WEBI reports.
• Used Complex functionalities in universes like Aggregate Awareness, Shortcut Join, Cascading Prompts, Derived Tables, @Functions etc.
• Resolved Join Path problems like Loops and Traps Using Alias and Context.
• Developed Webi/Webi Rich client reports by using advanced functionalities like Optional prompts, Data tracking, Custom SQL at Report level and calculation contexts.
• Created around 150+ Webi reports using Multiple Data providers, Merge functions, complex calculations, optional prompts, data tracking, sorts,ranking,master detail,breaks etc
• Created 20+ Complex reports which had hyperlinks on measures with a functionality to open a child report which has detailed information about this measure count.
• Created canned and adhoc reports for Business Users reporting.
• Worked with the ETL team to analyze data issues and provided analysis results to help them resolve the issues.
• Have provided reusable BI solutions to resolve issues and have added value by proposing numerous ways to improve report performance.
• Created, optimized, reviewed and executed many ORACLE SQL queries to validate report data and help ETL team to analyze data issues.
• Responsible for Report and Universe Testing and Bug Fixing using IM QualityCenter.
• Schedule/monitor Prod reports based on frequency (Daily/Weekly/Monthly/Quarterly/Annual).
• Migrated Universe/Reports across environments using Import Wizard.
• Created user ID, provide access to requested application through Central Management Console.

Environment: BO XIR3.1 Designer, Web Intelligence, Info View, Import Wizard, Oracle 10G, IM Quality Center

Confidential

Business Objects Developer

Responsibilities:

• Participated in requirement gathering and prepared design documents based on customer requirements.
• Assessed the feasibility of recreation of the report in Business Objects based on the functionality used in the MSTR reports.
• Worked on mapping document across the two DB to look for unavailable fields in the destination environment.
• Arriving at BO report design which is in least contrast to the MSTR report.
• Implementing BO reporting technique such as Hyperlinks, Breaks, Sections, Fold/Unfold, report level variable to exactly mimic the source report.
• Implementing complex functionalities in reports like Hyperlinks, Drill down, Merge Dimensions etc.
• Created various types of reports having charts, cross tabs, Forms and Master detail relationship.
• Testing of Universe and Reports in QA and PROD Environments and provided Sign- off.
• Following BO Reporting Standards for report creation.
• Perform data validation across MSTR and BO reports post report creation.
• Fine tune Oracle SQL queries to improve performance which served as source for monthly data dump.
• Using WITH clause, Optimizer Hints to achieve performance improvement in the queries.
• Supported Incident Tickets and Requests Resolution using BMC Remedy Tool.
• Participated in code review and unit testing of the functionalities.
• Migrated reports and universes across environments from DEV to PROD QA to PROD using Import Wizard.
• Ensure Maintainability of application with user.

Environment: BOXIR2 Designer, Web Intelligence, Import Wizard, Oracle 10G, BMC Remedy, MicroStrategy.