SUMMARY

• Around 7 years of experience in working with Business Intelligence tools like MSBI (SSAS, SSIS, SSRS)/ Business Objects.
• Hands on experience with all phases of Software Development Life Cycle (SDLC).
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables using Analysis Services
• Developing OLAP cubes using SSAS 2005/2008/2012 and Expertise skills in creating calculated measures and dimension members in SQL Server Analysis Services (SSAS) using Multidimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Generated different reports tools Pentaho, in SSRS creating datasets as parameterized stored procedures & OLAP cubes
• Conducted business requirements gathering meetings, designed and monitored the construction of ETL processes, and documented the data/ETL mappings.
• Proven proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, sort, data Conversion, and multicast, Union All, Merge Join, Merge and SCD to load data into SQL Server destination.
• Used Control Flow Tasks like for Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Designing packages.
• Strong Experience in Creating, Configuring, and Deploying SSIS Packages.
• Expertise in Extraction, Transformation, Loading data from SQL Server, Access, Excel, Flat Files and XML using, SSIS.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experience in building efficient SSIS packages for processing fact and dimension tables with complex transforms and SCD type I and type II changes.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Designed and monitored the construction of SSRS reports and hosted them on SharePoint/Native Mode.
• Expert in generating drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2008/2012.
• Wrote SSIS Packages for data loading changes in Slowly Changing Dimensions (Types 1, 2, and 3), and performed DTS & SSIS package monitoring, debugging, and performance tuning.
• Technical hands-on expertise in using Business Objects 6.x/XI r1/r2 /R3.X, BI 4.0 and BI 4.1 (Supervisor, Designer, Reporter, Security using CMC, CMS, CCM, Web Intelligence 3.1, Desktop Intelligence 3.1, BI Launchpad 4.0/4.1 etc.).
• Expertise in planning, designing, developing, maintaining and distributing Universes using Universe Designer Tool (UDT) and Information Designer Tool (IDT).
• Experience in building Corporate Dashboards using Business Objects Application Foundation (6.5), Business Objects Performance Management (XI r2), SAP Business Objects Dashboard 4.0(formerly Xcelsius 2008) Technical hands-on expertise in using SQL Server 2012/2008 R2/ 2005, with SSIS/SSRS/SSAS.
• Experience in cloud based environment and master data management.
• Excellent experience in PL/SQL, and SQL.
• Experience with TOAD.
• Comfortable with agile methodologies.

TECHNICAL SKILLS

Reporting Tools: Microsoft BI (SSRS, SSAS, SSIS)Report Builder 3.0SAPBI-4.0, UDT, IDT, Xcelsius, Lumira, BO Explorer, CMC Security Crystal Reports Enterprise.

ETL Tools: Microsoft SSISBusiness Objects Data Integrator 6.0/6.51/XI 3.x, Data Stage.

Databases: SQL Server 2012,Oracle 10g/ Oracle 11g /Exadata, SAP BW, MS Access, Teradata.

Other Technologies: ErWin2.5, Oracle Enterprise Manager, Oracle 9i., Microsoft SharePoint Designer 2007/2010, Microsoft InfoPath Forms 2007.

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

Business Intelligence Developer (MSBI)

Responsibilities:

• Designed and monitored the construction of the SQL Server Business Intelligence enterprise data warehouse.
• Generated Tabular Model in SSAS, partitioned, used different storage techniques, created DAX, MDX queries to retrieve and manipulate data off them.
• Designed complex SSAS Multidimensional cubes using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 and in adding calculations using MDX.
• Involved in writing MDX Queries for Analytical and Reporting purposes
• Created various KPIs, actions, aggregations for proper analysis of data in the cubes.
• Processed OLAP cubes with various processing options depending on the requirement.
• Designed and monitored construction of the ETL processes, and provided the ETL mappings in the design document.
• Created and Maintained SQL Server Agent Jobs for SSIS Packages.
• Customized sites on SharePoint Portal and hosted the SSRS and Power Pivot reports on to SharePoint.
• Created Power view reports using the Tabular SSAS models in Excel.
• Scheduled Reports using subscriptions in SharePoint.
• Used BI 4.0 Information Designer Tool to design Universes, joining tables, creating prompts and applies Contexts and Aliases to remove loops.
• Designing, creating, enhancing and testing of universes and reports using BI Launchpad and Business Objects XI 3.1 (Universe Designer, WebIntelligence).
• Created complex Business Objects Reports using Subqueries, Combined queries, Input Controls, Drill Filters and Hyperlinks etc.
• Created a couple of SAP BO dashboards (Xcelsius) for a project called Metadata using Live Office.
• Optimize web intelligence report performance on OLAP databases with Query Stripping enabled at query properties or document properties level.

Environment: Microsoft BI (SSAS, SSRS, SSIS -2012), MDX/DAX, SharePoint 2007/2010, SQL Server 2012, Business Intelligence Consumer Services (BICS), BEx Analyser, SAP BO Dashboards 4.1, Oracle 10/11g.

Confidential, MN

Business Intelligence Developer (MSBI)

Responsibilities:

• Involved throughout the complete system Development Life Cycle.
• Involved in discussions with the architecture team for the reporting data mart data model
• Involved in Requirements study, interact with the end users and responsible for gathering the reporting requirements.
• Worked with Business Analyst Team to help in the Designing report requirement templates/Mockups.
• Used BI 4.0 Information Designer Tool to design Universes, joining tables, creating prompts and applies Contexts and Aliases to remove loops.
• Was involved in a migration Project from XI 3.1 to XI 4.0. Converted. UNV universe (XI 3.1) to. Unx universe (BI 4.0) using Information Designer Tool. Also had to convert many DeskI Reports to Webi using Report Conversion Tool. RCT 4.0 and RCT 3.1.
• Designing, creating, enhancing and testing of universes and reports using BI Launchpad and Business Objects XI 3.1 (Universe Designer, Web Intelligence).
• Created complex Business Objects Reports using Input Controls, Drill Filters and Hyperlinks etc. for a high visibility project called Quick Glance.
• Developed WEBI reports on SAP BW Queries that use BICS.
• Created reports using SAP BI 7.3 which include Actual/Budget comparisons for Current Year and Prior Year flow data in commercial lines.
• Used Crystal Reports in "CatRM Project". It has around 10 complex reports that track the catastrophe management of The Confidential . Created Weekly Crosstab reports using complex date logic. Also Created Subreports, and passed parameters from Parent report to subreport.
• Created a dashboard called Quick Compare using Xcelsius Enterprise 2008. Used BIWS (BI as a Web Service) behind the scenes to make the dashboard get live data from database.
• Created New Users and Setup user security using Central Management Console.
• Designed templates for Webi documents and customized Webi Front Page.
• Developed standard and procedures and change control document templates for BO.
• Training and motivating End Users community and IT team in BO XI 3.1 basic and advanced reporting skills, universe designing, Xcelsius 2008 etc.
• Created OLAP Cubes using SQL Server Analysis Services 2008/2012.
• Understand data requirements from the business analyze source data and derive required datasets.
• Construct different hierarchical dimensions suitable for offer analyst to use.
• Build a set of reports which includes historical same-period comparisons.
• Enhance and build selected redirect reports with the flexibility of an OLAP service
• Created different kind of reports like cascading prompts, Drilldown reports, Drill through Reports, Parameterized reports, Sub reports and charts in SSRS.
• Developed large number of standard and customized reports using SSRS
• Generated several drill down and drill through reports using SSRS.

Environment: Microsoft BI (SSAS, SSRS, SSIS -2012), Business Objects XI 3.1, Business Objects BI 4.0/4.1, Business Objects Dashboard 4.0, SAP HANA, Business Intelligence Consumer Services (BICS), BEx Analyser, Business Explorer XI 3.1, SAP BW Infocubes, SharePoint 2010, SharePoint 2007/2010, SQL Server 2012, Oracle 10/11g.

Confidential, Des Moines, IA

Senior Business Intelligence Developer

Responsibilities:

• Involved in requirements gathering from the business users to build the reports.
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Resolving loops using in the Universes using contexts and aliases.
• Setup Custom Hierarchies in the Universes and set up Drill Functionality in the Universes.
• Linked Webi reports using complex hyperlinking and passing parameters.
• Created reports using Business Objects functionalities like queries, slice and dice, drill down, cross tab, master detail reports, formulas, etc.
• Create analytics like Interactive Metrics Trends, Goals & Speedometers using various metrics developed in Enterprise Performance Management XI.
• Migrated Universes, reports, Users and Groups etc. from development to QA to Production Environments. (Using Import Wizard)
• Experience in developing and designing and deploying reports through SSRS and Excel.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Generated several drill down and drill through reports using SSRS.
• Created reports in SSRS with different types of properties like chart controls, filters, Interactive Sorting, SQL parameters.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS and ability to export reports and query results to Excel or PDF.
• Scheduled SSRS reports for daily, weekly, monthly reports for executive management team and customer representatives for various streams of the organization.

Environment: Business Objects XI r2, Business Objects XI 3.1, Xcelsius 2008, Dash Board Manager, Performance Manager, BO SDK, SQL Server 2008 Enterprise Edition, Data Stage, MS SQL 2008 r2, SQL Server BI Suite (SSRS, SSIS and SSAS).

Confidential, New York, NY

Programmer Analyst/ Business Intelligence Developer

Responsibilities:

• Involved in requirements gathering from the business users to build the reports.
• Created users and groups and applied row level and objects level securities using Central Management Console.
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Involved in migration and deployment of the universes and reports across multiple domains.
• Resolving loops using contexts and aliases to remove the cyclic dependencies.
• Used Business Objects Developer Suite (Broadcast Agent, Supervisor, Designer, Info View) to perform various tasks specific to every component.
• Created reports using Business Objects functionalities like queries, slice and dice, drill down, cross tab, master detail reports, formulas, etc.
• Administered Business Objects security, domains, groups and users.
• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• Resolving problems like Loops, Chasm Trap and Fan Trap
• Created the reports using Business Objects functionalities like Queries, Drill down, Functions, Cross Tab, Master/Detail and Formulas etc.
• Created number of standard reports and queries based on existing classes/objects and also Used Free Hand SQL for creating complex Reports which were not possible to produce using the available Universes.
• Installed and configured Business Objects XI r1/r2 using Tomcat and WebLogic as Application and Web Servers.
• Applied hot fixes and patches to Business Objects Server.
• Implanted Business Objects with Info view and Broadcast Agent Server.
• Implemented Single Sign on from third-party applications directly to Business Objects Infoview with the help of Site Minder Tool.

Environment: Business Objects 6.5 (BO Reporter, Designer, Broadcast Agent, Supervisor, Web Intelligence, Info View), Business Objects XI, Crystal Enterprise 10, Oracle 8i, SQL, SQL*Plus, MS Office, Windows 2000, Unix, Microsoft InfoPath 2007, MS Access 2007, Microsoft SharePoint 2007.