SUMMARY:

• Overall 13+ years of experience in Design, development and implementation of Business Intelligence Applications using SAP Business Objects Enterprise (XIR3/XI 4.2/4.1/4.0).
• Experience in working with various Business Objects tools such as Web Intelligence, Desktop Intelligence, Information Design Tool, Info View, BI Launch Pad, Dashboard Design 4.2/4.1/4.0, Lumira, CMC (Central Management Console), Xcelsius and Crystal Reports on Windows platforms.
• 5 Full life cycle implementation including Design of Universe, Report Development and Dashboard Design.
• Experience with Installing entire hardware, and software products like Tomcat, and Apache (Clustered and Standalone Environments).
• Installed and tested the BI4.0 application on sandbox.
• Worked with server team to provide them with list of specifications need to build the servers for BO 4.2/4.1/4,0
• Worked with Developers to consolidate the Business Objects repository before migrating to BO 3.1/ 4.0/4.1/4.2.
• Specialized knowledge in Microsoft Power BI , Flow and Analysis Services .
• 5+ Years of experience in Microsoft Power BI.
• Implemented Power BI & Snowflake in a self - service environment. Report migration from SSRS to Power BI.
• Experience creating complete Power BI report solutions.
• Experience with developing Power BI embedded applications.
• Experience knowledge in DAX.
• 5+ Experience in design, model and develop complex reports using Power BI & multiple data sources - OnPrem data storage and Snowflake.
• Experience with building visualizations/data sets in Power Bi and exposure other Microsoft Power Platforms like Power Apps/Power Automate.
• Expert in designing, developing, maintaining, and optimizing the Universes using Designer module.
• Extensive experience in developing data models in SAP HANA, SAP Business Objects Data Services.
• Extensive knowledge in SAP Business Warehousing - BW
• 2 years of extensive Tableau Experience in Enterprise Environment, in Tableau as a Developer and Analyst .
• Extensive knowledge of Data Warehousing Concept.
• Informatica Power Center, Power Exchange Metadata .
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Extensive experience in gathering, managing, and documenting business and functional requirements, communicating effectively with upper management, developers, and QA engineers.
• Experience in building Universes (UNX & UNV), retrieving data using Universes and Personal data files, and Free Hand SQL methods and creating Ad-Hoc reports using Business Objects & Web Intelligence Tools.
• Installation/configuration/upgrades/performancetuning/loadbalancing/capacityplanning/troubleshooting of servers including XIR2 through XI 4.0/4.1/4.2.
• Substantial experience in Business Objects Migration (5.1, 6.5 to XIR 2/3.0/3.1/4.0/4.1/4.2 ).
• Expertise in Administrative activities of Business Intelligence tools such as Business Objects XI 4.1, XI 4.0/XI 3.1/XIR2.
• Experience in deployment of Business Objects and Web Intelligence from various Database Sources SQL Server, Oracle, TeraData, MS SQL Server, DB2, Sybase and Access.
• Installed and configured BOE XI 4.2 Environment.
• Implemented 3rd party security authentication (WINDOWS AD) in BO apart from Enterprise Authentication.
• Configured and enabled the SSO using the Windows AD Authentication.
• Implemented Migration process for Business Objects XI 3.1 to 4.2 such as readiness assessment and deployment plan, Migration and system Upgrades, Co-Existence Planning, Deployment services and Education delivery.
• Worked extensively with the Business Objects Designer in preparing Universes from the warehouse database.
• Created various reports with functionalities like Cross tab, Embedded Summary, Calculate member of, Charts, Graphs, and sub reports.
• Worked with several features like Query Stripping, Input Controls, Sub Query, Scope of Analysis and Drill functionality.
• Developed Complex Universes.
• Fine-tuned universes and reports by creating aggregate tables and filters.
• Developed the highly summarized dash boards using Dashboards and created the real time dash boards using QAAWS and BI Widgets.
• Configured BW Publisher service for Crystal reports migration.
• Generated various Drill down reports and Alerts. Business Intelligence reports using Web Intelligence module.
• Created complex formulas to support various business functionalities using crystal reports.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/4.2.
• Worked on Real Time Info Cube and Data source object and also new and enhanced administration and monitoring features.
• Created the Test cases, Test Strategies and executed the Unit Testing and the UAT for the Entire environment.
• Experience in creating Dashboards using metrics and analytics.
• Excellent Knowledge of Database Systems - Oracle, SQL server, DB2 and Data warehouse concepts.
• Extensive Working experience in applying Relational Database Concepts, Entity Relation diagrams and Normalization concepts.
• Understanding of Teradata Logical Data models.
• Experience in Business Intelligence testing in various reports using Business Objects, Crystal Reports and Crystal Dashboards (Xcelsius).
• Experience in creating Universe based on Transactional/Analytical Data Model using Entity-Relationship Model, Dimensional Data Modeling using Star schema and Snowflake schema
• Extensively worked with SQL Queries, and capable of handling Oracle, SQL Server, MS Access databases and have good experience in database tuning and performance techniques.
• Experience in handling User management, Content management and Server Management in Business Objects Administration.
• Excellent communication and Interpersonal skills, enthusiastic learner and quickly acclimate to new BI environments.
• Created meaningful display charts using Business Objects Dashboard Design Tool in BO 4.0/4.1.
• Linking reports in Web Intelligence using Open Doc function.
• Good knowledge and experience in using Querying and Reporting modules of Business Objects Enterprise.
• In-depth knowledge in creation of WEBI reports and Dashboards.
• Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods. Solid knowledge of SQL.

COMPUTER SKILLS:

Languages:

Proficient with T-SQL, Oracle PL/SQL, MS SQL:

Trilingual: Fluent in English, Spanish, And Hindi (Read, Write and Speak)

Software:

BI Tools: SAP BO 4.2/4.1/4.0, SAP Business Objects XI R3.1/R3/, SAP Information Design Tool, SAP Universe Design Tool, Web Intelligence, BI Launch pad, Xcelsius 2008, Dashboard Design Tool, Lumira, Crystal Reports, Query As A Web Service, Live Office, ETL CMC, Import Wizard, Publishing Wizard, Report Conversion tool and Lifecycle Manager, Visualization

Databases: SQL Server, DB2, MS Access, Oracle RDBMS, Teradata.

Microsoft Power BI Report/Dashboard: Power BI Components, Desktop, Saas, Gateway, Embedded, and Report Server

Reporting Tool: Business Objects Reporting Tool such as Web intelligence, and Business Intelligence Reporting, additional Microsoft Excel Reporting and Visualizations.

Data Modeling: SAP HANA Studio.

Web Servers: Apache

Application Server: Tomcat

GUI/Development Tools: Designer and SQL Navigator, Toad, and Squirrel.

Dimensional Modeling: Star Schema Modeling, Snowflake Modeling, Fact and Dimensions Tables & Data Integrator

Management Tools: MS Project, MS Visio, Word, Excel, Power Point.

EXPERIENCE:

Power BI/Reporting Developer

Confidential, NJ

Responsibilities:

• Managed Business Intelligence projects from conceptualizations to implementation.
• Developed project plans, prepared a schedule, and ensured work according to same.
• Analyzed business requirements and developed project deliverables accordingly.
• Works independently and follow the agile methodology and processes.
• Suggest changes to senior management using analytics to support your recommendations. Actively participate in the implementation of approved changes
• Proven expertise in various business analysis methodologies and techniques, including data analysis, use case development, story writing, user acceptance testing, and product documentation.
• Facilitate business and systems analysis discussions and translate findings into clearly defined business requirements.
• Participate in system integration testing and user acceptance testing with the business users to ensure a high-quality delivery.
• Administered projects and prepared regular status reports.
• Coordinated with various stakeholders and management for execution of project appropriately.
• Sound knowledge of Customer Relationship Management (CRM).
• Work with Data Warehouse team and business operational teams to understand data sources and implement new requirements.
• Lead projects at various stages from requirements gathering and business rules analysis to creating physical database model, SSIS/SSAS development, BO Universe Architecture and Reporting.
• Participated in data warehouse business analysis sessions and involved in data mart creation from conceptual to physical design.
• Actively participate in the overall Data Warehouse/Business Intelligence strategy. Used Informatica tool extensively to extract data from database and load it into data warehouse repository.
• Lead projects at various stages from requirements gathering and business rules analysis to creating physical database model, SSIS/SSAS development, BO Universe Architecture and Reporting.
• Hands on SSIS, SSAS development and production support of around 32 data marts and the Enterprise Data Warehouse, Meta data and Universe creation for reporting.
• Lead and improvised existing Enterprise Data Warehouse.
• Extracted Data using SSIS from XML, SQL Server, Oracle and flat files, Excel perform transformations and populate the data warehouse.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema and Snowflake) and maintenance.
• Query Optimization for improving the performance of the data warehouse.
• Maintained through understanding of all major data sources internal to the organization experience and knowledge of report writing.
• Document ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, prepared test data for testing, error handling and analysis.
• Design, Development, Implementation of Data Migration and SSIS Application development projects and build across Development, QA and PROD environments.
• Multi Master Replication/ Streams Support (High Availability) for mission critical databases.
• Extensively involved in the Analysis, design and Modeling. Worked on Snowflake Schema, Data Modeling, Data Elements, Issue/Question Resolution Logs, and Source to Target Mappings, Interface Matrix and Design elements.
• Design and develop logical and physical data models that utilize concepts such as Star Schema, Snowflake Schema and Slowly Changing Dimensions.
• Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Created self-servicing metadata models such as relational, DMR and power cubes for different functional areas using operational data stores/databases, including SQL Server, Oracle, and Teradata.
• Coordinating with various teams to minimize the impact on high priority jobs during critical issues. Meet project deadlines and deliverables by following up on resolving dependencies on timely basis.
• Designed, developed, implemented and supported reporting, analytics and business intelligence solutions utilized to support business analytical and reporting needs.
• Maintained good working relations with all key teams of organization.
• Impo r te d dat a from SQL Serve r D B , Azure SQL D B to Po wer Bl to g enerate re po r ts. Assisted technical team in developing and analyzing operational reports.
• Used Load balancer, message queues to improve resiliency and worked at Scale by making use of Caching, Partitioning and other Techniques.
• Deployed a web services on a virtual machine which gives complete control over the execution environment, and App Service Platform as service.
• Added multiple Web servers for automatic load balancing between each instance.
• Created Da x Quer i es to generated computed columns in Po wer B l.
• Use d P ower B l, Power Pivot t o de ve lop data ana l ysis proto t ype , and used Power Vi ew and Po wer Map to vi sualize re po r ts. Generated computed tables i n Po wer B l by us in g D a x.
• Developed reports, dashboards & scorecards, data exploration, and visual analytics using existing and emerging technologies and tools.
• Created 10 reports from Scratch and Pu bl ish ed Power B l Rep or t s in the require d or i g i n at i ons an d Made Po we r Bl Dash bo ards a va il ab l e in Web clients and mobil e apps. P ublished repo r ts an d das hboards using P ower Bl.
• E x p l ore data in a Var i ety of w ays and across mu l tiple v isu aliz at i ons us in g Power B l
• Use d P ower B l Gateways to kee p the das hboards and repo r ts up to date.
• Instal l ed an d Configu red Ente rp rise Gateway and Perso n al Gateway in Po wer B i Serv i ces.
• Maintained the production deployment process to ensure that best practices are followed.
• Develop and maintain internal tools and services to monitor production jobs to ensure they execute as expected. Proactively monitored application and infrastructure alerts and reacted quickly.

Environment : Power BI’s Components , Power BI Reporting/Dashboard , Business Objects 4.2/4.1 , SQL Server, Microsoft Azure, Oracle, SSMS, SSRS, SSIS, T-SQL, Business Intelligence Client Tools xi4.2/4.1 , Web Intelligence, Tableau, Business Intelligence Launch Pad, Data Warehouse Bus Architecture, Teradata, Windows 10 , Microsoft Excel

Business Intelligence Project Lead

Confidential, Windsor, CT

Responsibilities:

• Data Architect/Modeler/Analyst Data Warehouse.
• Perform data modeling, data source analysis, data sourcing specifications, ETL design & specification.
• Create conceptual, logical, and physical data models to define the informational needs of the Data Warehouse
• Extensively involved in the Analysis, design and Modeling. Worked on Snowflake Schema, Data Modeling, Data Elements, Issue/Question Resolution Logs, and Source to Target Mappings, Interface Matrix and Design elements.
• Extensively Worked on Star Schema, Snowflake Schema, Data Modeling, Logical and Physical Model, Data Elements, Issue/Question Resolution Logs, and Source to Target Mappings, Interface Matrix and Design elements.
• Design and develop logical and physical data models that utilize concepts such as Star Schema, Snowflake Schema and Slowly Changing Dimensions.
• Developed a complex provider scorecard dashboard with multiple tabs using dynamic visibility. This dashboard shows the high-level information of rolling 12 months of provider performance data varying across different areas like productivity, machine utilization, compliance, and quality. The dashboard also has the capability of drilling down to the detail data on to the detail Web Intelligence reports
• Coordinated with various stakeholders and management for execution of project appropriately.
• Developed, interpreted, and present a point of view and recommendation with respect to analytics/KPIs.
• Maintained good working relations with all key teams of organization.
• Assisted technical team in developing and analyzing operational reports.
• Designed progress controls to monitor progress for same.

Environment : Business Intelligence Client Tools xi4.1/4.0, Business Intelligence Launch Pad and Information Design tool, Salesforce, Tableau, Dashboard 4.1 SP5, SQL Server, SSMS, SSIS, Oracle, T-SQL, Teradata, Windows 10. Microsoft Live Office. Data Warehouse.

Business Intelligence Lead

Confidential, Hartford, CT

Responsibilities:

• Collaborate with key internal stakeholders and management to create/develop operational dashboards and standard reporting.
• Analyzed data to identify areas of concern or best practices opportunities and partner with stakeholders to further assess, determine counter measures or establish new processes as needed.
• Conducted a variety of tasks and support in creating BI reports, requirements, communications, and other key activities. Analyzed business requirements in collaboration with business end users, improving the quality, viability, and fit for requirements. Performed financial analysis to enhance decision making. Supported Operations team and developed productivity reports, in addition to analytical support.
• Developed effective queries for retrieving and analyzing data from a variety of sources, contributing to vendor evaluations as part of reporting enhancements, and supporting data driven decisions.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems from DB2, Oracle, SQL Server, Flat files to load into Staging, ODS, Enterprise Data warehouse, and subject oriented Data marts for Sales, Marketing and Finance departments.
• Worked extensively with the Business Objects Designer in preparing Universes from the warehouse database.
• Created 10 Web Intelligence reports from scratch.
• Key Achievements: Increased selling of insurance premiums by 45% due to implementation of KPIs created from CRM system, resulting in enhanced customer relationships.

Environment : Business Intelligence Client Tools xi4.1/4.0, Business Intelligence Launch Pad and Information Design tool, Dashboard 4.1 SP5, SQL Server, SSMS, SSIS, T-SQL, ETL, Oracle, DB2, Windows 10. Microsoft Live Office.

Business Intelligence Developer

Confidential, Mellon, NY

Responsibilities:

• Designed and creation of database tables/views and processes to facilitate complex reporting in Business Objects / Oracle environments to replace complex manual processes.
• Provided technical advice and skills transfer on BusinessObjects solutions to end-users at all levels within organizations.
• Responsible for the development of bespoke computer-based training content using Business Objects Knowledge Accelerator toolset to produce technical documentation for both end-users and support staff.
• Involved with the security set up and users and group access of the new Business Objects system through Central Management Center (CMC).
• Post go live, worked on report errors; performance enhancements; system maintenance; migration of legacy client reports; setting up new clients.
• Provided consultancy to new permanent staff on Business Objects usage, change processes and general guidance.

Environment : Business Intelligence Client Tools xi4.0, Business Intelligence Launch Pad and Information Design tool, Dashboard 4.1 SP5, SQL Server, SSMS, SSIS, T-SQL, Windows 10. Microsoft Live Office.

Business Intelligence Developer/Administrator

Confidential, NJ

Responsibilities:

• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department
• Created Users, User groups, defined the security and administered the User community Repository domains, using CMC
• Created universes using Business Objects Designer & Created reports using Desktop Intelligence/ Web Intelligence.
• Optimized the performance of the dashboards. Reduced the dashboard loading time by scheduling the backed source Web Intelligence reports for the live office and changing the live office refresh option to pick from the latest instance.
• Worked on Import Wizard to promote Reports/Universe to Production
• Created access level for specific functionality for User/Groups
• Implemented migrations of repositories (Universes, Reports, Securities, Categories) from DEV to UAT and then to PROD.

Environment : Business Intelligence Client Tools xi3.1, Business Intelligence Launch Pad and Information Design tool, Dashboard 4.1 SP5, SQL Server, SSMS, SSIS, T-SQL, Windows 10. Microsoft Live Office.

Programmer Analyst

Confidential, NJ

Responsibilities:

• Work as part of a cross-functional team to launch our new analytics software solution, Pyramid Analytics. Transition existing reporting to the new platform, ensuring the accuracy of data.
• Use a detailed understanding of the data sources, business processes, and key metrics and KPIs that drive our business to convey opportunities for improvement.
• Collaborate with stakeholders to understand and define reporting requirements and prioritize requests.
• Created Metrics and Dashboards in Xcelsius used single value selector, mapped chart, background, collaboration and text components
• Created two complex dashboards which uses live office to feed the data into Xcelsius from the source Web Intelligence reports
• Developed Provider scorecard reports using Web Intelligence as the reporting tool
• Developed complex Web Intelligence Core Measures Scorecard report which is used by the organization to track various core measures of the hospitals by month, quarter, year against the benchmarks
• Developed a complex provider scorecard dashboard with multiple tabs using dynamic visibility. This dashboard shows the high-level information of rolling 12 months of provider performance data varying across different areas like productivity, machine utilization, compliance and quality. The dashboard also has the capability of drilling down to the detail data on to the detail Web Intelligence reports
• Re-Developed an existing dashboard which shows the high-level rolling 12-month information of patient medication administration. This dashboard also had drill down capabilities to get to the detail data by month and by facility.

Environment : Business Intelligence Client Tools xi3.0, Business Intelligence Launch Pad and Information Design tool, Dashboard 4.1 SP5, SQL Server, SSMS, SSIS, T-SQL, Windows 10. Microsoft Live Office.