SUMMARY

• Over 15+ years of experience in developing, maintaining of PowerBI, Business Objects, and Crystal Reports Applications and systems.
• Experience in Analysis, Design, Development, Testing and Implementation of Business applications and Client/Server applications.
• Proficient in SQL Server and T - SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Experienced in Unix shell scripting and ERWIN software experience with Informatica mapping and data mapping, and on Oracle 10g.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Used Power Query to acquire data and Power BI desktop for designing rich visuals.
• Extensive experience with data warehouse design, construction, and/or maintenance, to include design and implementation of data strategy methods, coding and documentation of scripts and stored procedures, and creation of index and view scripts.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
• Extensive experience in report writing using SQL Server Reporting Services like Table report, Matrix report, Chart Report, Pie charts, Drill Down, Cascading, Parameterized, Sub reports.
• Experienced in Design, Development and Testing of WebI reports, DeskI reports and Crystal Reports.
• Experienced in defining the BO Migration planning and building the migration strategy.
• Strong knowledge of data warehousing concepts, design techniques such as Star, Snow Flake schemas, multi-dimensional data model analysis using OLAP, Physical and Logical data modeling.
• Good team player with excellent communication, analytical, written and presentation skills with strong aptitude towards learning new technologies.

TECHNICAL SKILLS

Operating Systems: Windows - 2000/XP/2012, Linux - Red Hat, Solaris, AIX and UNIX

Databases: SQL Server 2012 and Oracle 11i/10g/9i

Languages/Scripts/API: C, C++, VB.Net, ASP, HTML, DHTML, Java Technologies, PL/SQL Scripts and XML

OLAP Tools: Power BI 2.76, Business Objects Enterprise XI 4.2, Crystal Reports XI, Xcelsius 08

ETL Tools: Informatica, Data Stage

Domain: Banking, Telecom, Healthcare, Financial and Service Industry

PROFESSIONAL EXPERIENCE

Confidential

Senior BI Architect

Responsibilities:

• Developed reports using Microsoft Power BI (Desktop, Service, Mobile)
• Developed calculated columns and measures using DAX in Power BI
• Extracted data from On-Premises and SaaS (Software as a Service) into Power BI desktop.
• Created data visualizations using various visual objects & Published reports and dashboards to the Power BI service through the Office 365 integration.
• Implemented row level security by restricting the users for the data access.
• Created Content packs that package up a dashboard, report, & dataset to send to specified team.
• Incorporated Power Pivot/View to create analytical reports/dashboards from tabular and multidimensional models.
• Developed dashboards with Power BI, which display key KPIs for business analysis and decision-making.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models.
• Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Responsible for Monitoring and Tuning Report performance and modified numerous reports/stored procedures that were not performing properly (slow response time, inconsistent results, poor format of the actual report).
• Converted query-based crystal Reports to query/stored procedure based BO Reports.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.

Environment: Windows 2008/2012 R2, SQL Server 2017, Power BI.

Confidential

Senior BI Architect/Lead

Responsibilities:

• Developed high level matrix based on business requirements, functional & technical specifications as well as development standards for assigned projects/applications.
• Designing current database by adding tables, relationships, creating stored procedures, views and performance tuning of SQL queries and stored procedures.
• Developed Power BI reports and dashboards from multiple data sources using data blending.
• Developed SQL queries/scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Explored data in a variety of ways and across multiple visualizations using Power BI. Strategic expertise in design of experiments, data collection, analysis and visualization.
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Provide technical consultation to end users, resolve user issues.
• Modernization system development - bringing up Teradata Data Warehouse, Hadoop, and revamping Aster; Sustainment of the Stabilization platform including critical CR/TR fixes until we transition to the Modernization platform Operations and infrastructure support across all environments - development, test and production.
• Extensive experience in installing, integrating, tuning and troubleshooting Apache, Tomcat, WebSphere and WebLogic application server.
• Involved in creating and validating Universes, providing technical support to the users on universe and reports.
• Responsible for weekly and monthly releases during the regular maintenance window.
• Involved in data analysis, logic flow, and documentation using SQL code, proficient in database development using triggers, procedures and functions. Proper resolutions of data anomalies.
• Involved in SQL tuning, modeling on DW/relational schemas/ETL with hands on experience in Electronic Data Interchange
• Configured LDAP and Implemented SSL on all new servers.

Environment: Business Objects Enterprise 4.2 SP3, Power BI, Windows 2008/2012 R2, SQL Server 2016, Netezza.

Confidential

Senior Business Objects Administrator

Responsibilities:

• Responsible for Business Objects Enterprise Administration activities like creation, migration and maintenance of users & groups, publishing, migration and BO Content management and report automation tools.
• Installation and Configuration of SAP BOXI 3.1 software with User and System Installation on UNIX platform in Standalone, Clustered and Distributed environment.
• Architecture and various forms of Security, Disaster Recovery and fail over setups, Load Balancing and performance tuning for Business Objects.
• Expertise in installation, configuration, testing, validation of BOE 4.2 SP2, SP4, SP5 and SP6 in Solaris environment.
• Managing Licenses, Data sources & Connections, Users and Groups, Server Management Tasks using Central Management Console (CMC).
• Involved in Weekly and Monthly deployment activities Reviewing reports and Universes, Improved report response time by tuning BO queries.

Environment: Business Objects Enterprise 4.2 Service Pack 2, Business Objects Enterprise XI 3.1 Service Pack 6 Fix pack 4.1, Windows 2012, Oracle 11g.

Senior Business Objects Developer

Confidential

Responsibilities:

• Interacting with Business users to know their Business views in modifying Reports accordingly.
• Document and prepared Universe, Report Technical specification documents based on functional specs.
• Interacting DBA and Data Modeler for resource requirements and modifications to Data mart.
• Created universes, classes and objects by retrieving the data from various data sources and connections.
• Resolved loops using contexts and aliases to remove the cyclic dependencies and report formatting issues.
• Worked extensively with @functions like @select, @prompt, @where and @aggregate aware to write flexible SQL queries and used Freehand SQL and Personal data files.
• Created reports with Multi-Level Scope of Analysis using drill down, drill across, drill up and slice and dice.
• Extensively worked on major functionality of BO like Breaks, Ranks, Alerter, and calculations, Filters, Sorts, Query Prompts, Variables, Hierarchy’s and Tuned complex SQL’s, derived tables.
• Created Cross - Tab Reports, Charts, Tabular, Parameterized Reports, Sub-Reports which contain several Date and time Formulas, Conditional suppression, Conditional Grouping and developed Dynamic Cascading prompts, which uses multiple data sources using Crystal Reports XI.
• Reviewing reports and Universes, Improved report response time by tuning BO queries.

Environment: Business Objects Enterprise XI 3.1 Service Pack 2,Crystal Reports XIR2, Xcelsius 2008 Service Pack 3,Windows XP, Oracle 11g.