SUMMARY

• 10+ years of experience in Information Technology in leading Data Warehousing using Business Intelligence solution development and data Analysis using multiple BI Tools Power BI & Tableau, Cognos10.2/11, SAP Business Objects HANA and, Siebel Analytics and OBIEE Tools in various versions on Windows and UNIX Environments.
• Well - versed experience in deploying, designing, and developing and Administration Data Warehousing and Business Intelligence solutions in healthcare, Insurance, finance, telecommunications, manufacturing domains and service industry including efforts from requirement gathering and implementation
• Has passion for Data and deriving quick data driven insight/solution to answer business Problem.
• Well versed in the Global Delivery Model for execution of projects involving onsite and offshore teams.
• Produced attractive visuals/dashboards/ Interactive Dashboards using various Reporting tools to convey the story inside the data.
• Expertise in comprehensive Software Development Life Cycle ( SDLC ) using waterfall model and agile methodology.
• Eexperience in DataAnalysis, Data Integration, Data Mapping, Data Conversion, Data Migration, Data flows and Metadata Management Services and Configuration in OLTP and OLAP environments.
• Over4 yearsof experience inMigrating/Upgrading BI Tools like Universes and reports and Dashboards fromBusiness Objects XIR4 and BO to OBIEE and Power BI, Tableau and Cognos.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Expertise in dimensional data modeling, Star Schema Modeling, fact and dimensional table design, physical and logical data modeling.
• Eexperience in conversion scripts using SQL, PL/SQL, stored procedures, functions, and packages to migrate data from SQL server database to Oracle database.
• Strong complex reporting skills - complex Drill-Through, Cross-Tabs, Summary Reports.
• InteractedwithCustomersforrequirement gathering,TEMPeffectiveanalysisand also to provideend-user training. extensive experience on Power BI and Tableau Desktop versions including in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users, and adding them to the specific group and scheduled instances for reports
• Experienced in Development, Implementation, Testing and support for various data warehousing applications using SAP BW and Business Objects XI 4.0/3.1/R2/6.5, InfoView, BI Launch Pad, IDT, Desktop Intelligence, Web Intelligence, Import Wizard, UDT, CMC, CCM and SAP Dashboard 4.0 Xcelsius.
• Experience in Data Modeling, Data Loading, Report development and Performance tuning.
• Expertise in documenting the client and technical information in a timely and well-organized manner.
• Hands on experience with Data Extraction, Transformation and Data Loading in Data Warehouse environment.
• Performance tuning and Enhanced Universes with SQL Queries for the Report Performance.
• Experienced in Production Support role 24/7 to resolve the issues using a trouble ticket system
• Efficiently mapped Business requirements and processes to technical solutions.
• Good functional knowledge of SD, SCM, MM, FI, HR, and general business process ofSAP R/3 systemandECC.
• Demonstrated excellent interpersonal skills and communication skills during identification of user requirements.
• Capable of working in a team or individually, self-motivated with good problem solving skills.
• Team-Oriented and focused on delivering exactly what the client needs to succeed in a timely manner, with amazing communication skills.

TECHNICAL SKILLS

Dahsboard Tools: Power BI, Tableau9, QlikView, SAP Xcelsius

Reporting Tools: Cognos 10.2, OBIEE-11g, SSIS/SSRS Reporting, SAP Business Objects - XI4.0/XIR3/XIR2/6.x/5.x,2008, BEx Analyzer, Crystal Reports, Cognos 10.2

Data Warehousing Tool: Oracle9i/10g/11g, Teradata, SQL Server, MS Access 2000/XP/2007, SAP BI 7.0/7.3, BW 3.5, SAP HANA, Visual Studio -2019

Programming Languages: SQL, PL/SQL, HTML, C, Java, UNIX, Shell Script.

Operating Systems: Win XP SP2/SP3, win 2000, Win NT 4.0 and UNIX

ETLTools: Informatica 8.6/6.1, Oracle Data Integrator (ODI)/Data Services XI3.0, 3.1, 3.2

Application Servers: Apache 1.3.27, IIS 5.0 and Tomcat 4.0.6

UML Diagram Tools: Microsoft Visio

Microsoft Tools: Microsoft Office Suite (Word, Excel, Access, PowerPoint, and Outlook

PROFESSIONAL EXPERIENCE

Confidential

BI Technical Lead - Power BI/SSRS/SSAS

Responsibilities:

• Designed, developed, tested, and maintained Power BI functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Power BI.
• Design and development of Power BI visualization solutions like Dashboards, Standard Reports, Scorecards, charts and Ad-hoc Reports
• Adept in developing, publishing and scheduling Power BI reports as per the business requirements
• Iimplemented complex features in charts like creating bar charts in tooltip.
• Developed calculated measures using Data Analysis Expression language (DAX)
• Developed multiple dashboards, analytical reports, KPIs and Interactive reports based on business requirements to support executive business needs
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations and Power BI Prep workflows for data cleaning, transformation.
• Also involved in administration tasks such as Setting permissions, managing ownerships, and providing access to the users and adding them to the specific group.
• Created PL/SQL stored procedures, functions, and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created application roles for setting object level & data level security & permissions for users
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Used SQL Server Visual Studio tool to build high performance data integration solutions including extraction, transformation, and load packages for data warehousing. Extracted data from the XML file and loaded it into the database.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 dat maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.

Environment: Power BI, SSRS/SSAS, Microsoft Excel, Oracle 10g, SQL Server 2008, TOAD, Alteryx

Confidential - Durham - NC

BI Development and Administration - Technical Lead

Responsibilities:

• Understand the Requirements and Functionality of the application from specifications.
• Designed, developed, tested, and maintained Power BI functional reports based on user requirements.
• Power BI Developer, primary activities included designing technology roadmap for Power BI, Product installation and implementation development of insightful dashboards, serving as SME point of contact for Power BI and delivery of solutions adhering to BI industry best practices.
• As a Power BI SME, responsible for the design, development and production support of interactive data visualizations used across the company.
• Implemented row level security for the Power BI dashboards and used various advanced table calculations for the dashboards.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Dropdown menu option and Parameters using Tableau.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Converted existing reports to Power BI dashboards
• Created different KPI using calculated key figures and parameters
• Developed Power BI 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.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations and Power BI Prep workflows for data cleaning, transformation.
• Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's
• Strong Dashboard design experience and passionate practitioner of TEMPeffective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Power BI users and Wrote Custom SQL to support business requirements.
• Utilized Power BI 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.

Environment: Power BI, Tableau 9, Oracle 10g, SQL Server 2008, TOAD, Alteryx, Service Now

Confidential - Durham - NC

BI Reporting Technical Lead/Administration

Responsibilities:

• Developing new recommendations to TEMPeffectively report data of mid to high level complexity related to varied business metrics Design, code, test, debug and document reporting solutions, while enhancing existing reports to ensure dat solutions continue to meet business needs.
• BI Solution Architecture and development Involving Data integration, cleaning data Modeling, DWBI Development
• Analyzing business requirements/queries and development of metrics/KPO to business state and performance s
• Used various sources to pull data intoTableau such as SQL Server, Oracle.
• Extract or collect data for performing queries and developing the reports
• Develop and analyze operational performance metrics and reports to ensure the quality and integrity of extracts though the use of validation and audit strategies
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.

Confidential - Durham - NC

BI- Financial Reporting Analyst, Administration/OBIEE - 11g Migration to Tableau

Responsibilities:

• Acted as aliaison between business users and BI teamto facilitate understanding of business requirements.
• CreatedRequirements Traceability Matrix and Mapping Documentto trace requirements in BI implementation.
• ConductedFunctional Requirements review and walk throughwith BI Architect, Designers, and Stakeholders.
• Involved in Creating and Administering the RPD and Physical Layer, Business Model & Mapping
• Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
• Analyzed Functional & technical design documents.
• Developed metadata repository usingOracle BI Repository Model/OBIEE Answers OBIA/OBIEE Administration toolin Physical, Business Model and Mapping, and Presentation Layer.
• Designed and developed variousInteractive Dashboardsand reports with drilldowns, guided navigation, filters, and prompts.
• Designed and developed various BIP Reports using RTF Template in BI Publisher for Dashboard creations. implementing Data-level security and Object-level (Dashboards/Reports) security among users, groups and web-groups.
• Integrated BI Publisher with OBIEE. Created Templates and Reports such as Turn Over/Period/Department, Prompts such as Customer Name in BI Publisher
• Created varioussession and repository variablesand initialized them in theInitialization Blocksto change metadata dynamically as the environment changes. worked as POC's project deliverables and support for in corporate feedback into the solution and created best practices for User training to end users.
• Strong knowledge of Microsoft BI reporting tools (SSRS, SSAS) and other reporting tools e.g. Power BI
• Strong knowledge of Microsoft BI reporting tools (SSRS, SSAS) and other reporting tools e.g. Power BI
• The ability to demonstrate strong analytical skills and be a keen problem solver
• Design and development of Power BI visualization solutions like Dashboards, Standard Reports, Scorecards, charts and Ad-hoc Reports
• Proven ability to express complex technical concepts in business terms
• An ability to work as a team and build TEMPeffective relationships, both within the team and with other stakeholders
• Proven ability to deliver on tight deadlines, and to prioritize tasks

Confidential - Cary - NC

BI Project Lead: Onsite Co-Ordinator

Responsibilities:

• Involved in Creating and Administering the Physical Layer, Business Model & Mapping
• Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
• Analyzed Functional & technical design documents.
• Worked during the whole life cycle of the project from requirements gathering to deployment.
• Acted as aliaison between business users and BI teamto facilitate understanding of business requirements.
• CreatedRequirements Traceability Matrix and Mapping Documentto trace requirements in BI implementation.
• ConductedFunctional Requirements review and walk throughwith BI Architect, Designers, and Stakeholders.
• Analyzed the data and developedLogical Star Schemamodel with consultation from Data Modelers and Business Analysts.
• Developed metadata repository usingOBIEE Administration toolin Physical, Business Model and Mapping, and Presentation Layer.
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the (RPD)BMM layer as per the business requirements.
• Designed and developed various RTF Template,Interactive Dashboardsand reports with drilldowns, guided navigation, filters, and prompts.
• Created varioussession and repository variablesand initialized them in theInitialization Blocksto change metadata dynamically as the environment changes.
• Worked towards the Performance Tuning of Dashboards and Reports with Business Analysts and DBAs.
• Implementedsecuritybased onLDAP Autantication.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Createdsecurity settingsin OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
• IntegratedBI Publisherwith OBIEE to build reports in word, excel and doc format.
• Created various templates, reports, and prompts in BI Publisher.
• Developed test cases and performedUnit Testing and Integration Testingof the Repository and Web Catalogs.
• Provided guidance and support to end users during the implementation and in production.
• Created Various BI Publisher Reports on top of BI Answers and aligned them on various Dashboards as per the requirement.
• Dashboards and Reports were assigned to existing Security groups on role based access of the data to users.
• Involved in Design and Data Modeling using Star schema.
• Primary responsibilities include gathering business requirements, designing the functional and technical specifications.
• Involved in implementing SAP Business Objects XI 4.1 to Tableau migration across all business verticals.
• Involved in POC for Tableau migration from BOBJ/OBIEE11g.
• Involved in Design and Development of custom business intelligence solution (Metadata and Dashboards/Reports) using SAP Business Objects to Tableau
• BOXI4/Tableau Administration and crating users and groups

Confidential - Jacksonville-FL

Business intelligence OBIEE Technical Lead

Responsibilities:

• Wrote technical reports on test and analysis results and facilitated presentations to stakeholders.
• Developed data management plans to collect, manage, and analyze data.
• Performed problem solving and resolution for technical quality, inspection, and customer quality issues. Supported Test Readiness Reviews (TRR) and System Verification Reviews (SVR) through gathering verification artifacts. Analyzed and interpreted test data and prepared technical reports. Collaborated with end users and QA testers to determine requirements.
• Created varioussession and repository variablesand initialized them in theInitialization Blocksto change metadata dynamically as the environment changes.
• Worked towards the Performance Tuning of Dashboards and Reports with Business Analysts and DBAs.
• Implementedsecuritybased onLDAP Autantication.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Createdsecurity settingsin OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
• IntegratedBI Publisherwith OBIEE to build reports in word, excel and doc format.

Confidential - Richmond - VA

SAP BI/OBIEE Project Lead

Responsibilities:

• CreatedRequirements and Mapping Documentto trace requirements in BI implementation.
• ConductedFunctional Requirements review and walk throughwith BI Architect, Designers, and Stakeholders.
• Involved in Creating and Administering the RPD and Physical Layer, Business Model & Mapping
• Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
• Analyzed Functional & technical design documents.
• Developed metadata repository usingOracle BI Repository Model/OBIEE Answers OBIA/OBIEE Administration toolin Physical, Business Model and Mapping, and Presentation Layer.
• Designed and developed variousInteractive Dashboardsand reports with drilldowns, guided navigation, filters, and prompts.
• Designed and developed various BIP Reports using RTF Template in BI Publisher for Dashboard creations. implementing Data-level security and Object-level (Dashboards/Reports) security among users, groups and web-groups.
• Integrated BI Publisher with OBIEE. Created Templates and Reports such as Turn Over/Period/Department, Prompts such as Customer Name in BI Publisher
• Interacted with clients and assisted in business requirements gathering, including working with end users to interpret functional requirements into report specifications.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business report requirements and provided Several Report Mock-ups to finalize the requirements.
• Converted business requirements (BTRD) to (TDD) technical requirement documents.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Used designer Information Design Tool (IDT) to create Universes and resolve Join Path Problems utilizing contexts and Alias tables.
• Created linked universes and developed Complex reports dat involved multiple data providers, Master/Detail charts, cross tab charts and complex variables and calculation contexts.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Migrated universes and reports from SIT/UAT to production using Upgrade Management Tool.
• Generated reports using SQL server reporting services (SSRS).
• Scheduled Jobs and Alerting using SQL Server Agent.
• Design/Develop Test Plans, Test Cases and documentation of various processes involved.
• Implemented Custom Logging, Auditing and Custom Email Notification using SSIS 2008.
• Used SQL Server Reporting Services (SSRS) for creating matrix and tabular, drill down, drill through, and parameterized reports based on the requirements.
• Documentation of all the processes involved in maintaining the database for future reference.
• Implemented changes in Cubes (SSAS) as per the requirement.
• Worked with DBAs in order to schedule SSIS packages as jobs either daily, monthly, yearly or ad-hoc.
• Responsible for maintaining and supporting production databases.

Environment: Business Objects XI4.1/XI3.1, IDT Universe Designer, Web Intelligence, Desktop Intelligence, Crystal Reports, InfoView, Xcelsius 2008, QlikView 9, Import Wizard, UMT. QWAS, Live Office, Dashboard Manager, Performance Management, SAS, Microsoft Excel, Oracle 10g, SQL Server 2008, SSRS, SSIS, PL/SQL, TOAD, Apache Tomcat 5.5.26, Windows 2003, Informatia Power Center 8.1, HP Quality Center 9.2, Windows NT.

Confidential - Maumee - OH

Business Objects Developer/Administrator/Lead

Responsibilities:

• System study, interaction with users, management and designing, coding, testing & implementation of the system.
• Involved in gathering user requirements.
• Analyzed the existing database and designed Universes using Designer module for generating reports.
• Exported universes to the repository to making resources available to the users.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Created and modified the existing Universes by adding new classes/objects, prompts, hierarchies based on the business requirement.

Environment: Business Objects XIR2, Designer, Desktop Intelligence, Crystal Reports 2008, CMC, Oracle 9i

Confidential - Atlanta - GA

SAP BW/BO Developer

Responsibilities:

• Loaded data into Dimensions (manual) and Applications from BW and external sources.
• Performed an initial study of the current reporting application, to finalize the data elements required for reporting.
• Interaction with users & management, performance of analysis, designing, coding, testing & implementation.
• Created Repository for BO development, created Universes and Complex Reports.
• Involved in working with different database environments and moving of the universes and reports between PROD, DEV, and TEST.
• Created the OLAP Universes on top of BEX queries and generated the WebI reports.
• Created Complex Crystal Xcelsius Reports from the output of Business Objects report data.
• Created Xcelsius dashboards for the (Sales management) application.
• Used QaaWS to provide dynamic functionality.
• Working on creating Universes, Business Intelligence Layer for end users to develop the Adhoc/Canned reports.
• Created user objects including Dimensions, Details, Measures, Filters and Prompts, LOV
• Defined Report Level Ranking, Database Ranking and Alerts in Reports based on the specifications.
• Designed Universes by defining joins, cardinality between tables, linked the existing Universes using Business Objects XI R3.1.
• Configured the Data services to connect to the SAP R/3 BW.

Environment: SAP BI 7.0, ECC6.0, Business Explorer 7.0, BO XI R3.1, Crustal Reports, Crystal Xcelsius, Windows XP.

Confidential, Lewisville, TX

SAP BW BOBJ Developer (BW 3.0, Web I, CR)

Responsibilities:

• Involved in gathering end user Functional and Technical requirements, User/System Documentation, User training and testing developed reports for final deployment.
• Used Business Objects XIR3 extensively and Involved in Full SDLC (software development life cycle) rules are followed for designing new components.
• Designed, created and maintained Universes for Business Objects and Web Intelligence users using Business Objects Designer Module.
• Worked on Informatica Power Center Source Analyzer, Data warehousing Designer, Mapping & Mapplet Designer and Transformation Designer.
• Created Web Based reports using Web Intelligence and Dashboards for various reports such as Cross Tab and Master Detail Reports using the Java Report Panel.
• Generated various reports on a daily, weekly and monthly basis using Business Objects Report module.
• Involved in writing free hand SQL, as data provider for retrieving data when universe doesn’t provide required data.

Environment: SAP Business Objects XI R3/R2, Designer XI R3/R2, XiR3.1, Desktop Intelligence, Crystal Reports 2008, Oracle 10g, SQL, PL/SQL, UNIX

Confidential

Business Objects Developer

Responsibilities:

• Analyzed Business Processes and the already developed Scope of the support project
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Involved in Installation and Configuration of all products of Business Objects.
• Worked on Business Objects Administration like CMC and CMS maintenance & security issues
• Assigned privileges to users and groups using Supervisor.
• Worked in setting up the CMS and Audit database, Input and Output FRS repository systems.
• ImplementingSecurity Features of Business Objects like row level, object level and report level to make the data secure
• Extensively used Business Objects Designer to design and maintain Data Warehouse Universe.
• Used designer to create Universes and resolve Join Path Problems utilizing contexts and Alias tables.
• Designed and developed Universes and reports according to user requirements.
• Constructed different types of reports, such as Master/Detail, Cross Tab and chart (for trend analysis). Use of filters, conditions, calculations, etc.
• Created linked universes and developed Complex reports dat involved multiple data providers, Master/Detail

Environment: Business Objects XI R3/R2, Designer XI R3/R2, XiR3.1, Desktop Intelligence, Crystal Reports 2008, Oracle 10g, SQL, PL/SQL, UNIX