SUMMARY

• Over 7 years of experience in Software Development, Implementation, Maintenance of Business Intelligence (BI), Tableau, Power BI and End - to-End implementation of Business Intelligence using Oracle Business Intelligence (OBIEE)/BI Publisher/OBIA.
• Involved in Full Life Cycle Development of Reporting Projects includes Requirement Gathering analysis, Design, Development, Testing and Production rollover.
• Worked wif end users/customers to understand business requirements, recommended technical solutions, and documented functional requirements.
• Experience in Tableau Desktop, Tableau Reader, Tableau server installation, configuration, and administration & experience in creating Tableau Mobile dashboards.
• Experience in creatingPower BIdashboards/reports using tabular models and good in managing Gateways and content packs.
• Explore data in a variety of ways and across multiple visualizations usingPower BI.
• Experience in publishingPowerBIDesktop reports created in Report view to the PowerBI service.
• Experience in creating Power BI Dashboards (Power View, Power Query, Power Pivot, and Power Maps).
• Converting all operational excel report into Power BI Reports.
• Experience wif Azure Cloud Services (PaaS, SaaS & IaaS), Azure Virtual Machines, Azure Storage, Azure Data Factory, Azure active directory, application insights and logic apps.
• Designed and developed end-to-end BI solutions according to standard OLAP methodologies using Oracle Business Intelligence (OBIEE).
• Exclusively worked onOBIEEAdministration (RPD) (Physical, Business Model & Mapping, and Presentation Layers), Answers, Dashboards, Catalog Manager
• Experienced in creating various physical layer objects like connection pools, alias tables and various BMM layer objects such as logical columns, logical tables, logical table sources and hierarchies.
• Experienced in designing customized interactive dashboards inOBIEEusing drill down, guided navigation, prompts, filters, and variables
• Experience in Converting Oracle reports into Oracle BI Publisher Reports.
• Experience in creating aggregates, hierarchies, filters, table calculations, calculated measures.
• ExperiencedinSQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers,and Indexes.
• Experience in BI Suite for ETL Development DTS/SSIS, Reporting (SSRS) and Analysis SSAS, Performance Point Server, MOSS and Dashboard reporting.
• Good knowledge of Data warehousing, Bottom-Up and Top-Down Design methodologies, Operational Data Store (ODS), OLAP, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables using Analysis Services.
• Strong experience in database programming in writing T-SQL Stored procedures, Triggers, Constraints, Indexes and Batch Scripts using various DDL and DML commands.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL, HTML, XML, Visual Basic, C, C++, CSS, C#, JAVA/J2EE, JavaScript, ASP.NET

Specialties: Business Intelligence (BI), Software Management and SDLC, ETL, Data Collection, Azure Data Factory, Azure Devops, Git and Jenkins.

Database Tools: MS SQL Server Enterprise Manager, MS-Office, SQL Server Management, MS Visual Studio, RDBMS SQL Server 2005/2008/2012/2014.

BI Tools: OBIEE 12C, OBIEE 11g/10g, Data Visualization, OBIA 7.9.6.4, Power BI, Power BI Service, Tableau Desktop, Tableau Server, SSIS, SSRS.

Tools: and Packages: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler Import and Export Wizard, Business Intelligence Development Studio (BIDS), Tableau.

Operating System: Windows NT/2000/95/98/XP, Windows 2003 server, UNIX, Linux, Solaris

Documenting and Data Modelling Tools: MS Visio, MS Project, MS Office (Word/ excel/ Access/ PowerPoint).

Methodologies: Data Modeling-Logical/Physical/Dimensional, Star/Snowflake Schema, OLAP, SDLC (Waterfall, Agile, Iterative).

PROFESSIONAL EXPERIENCE

Confidential, Hoboken, NJ

Power BI/ OBIEE Developer

Responsibilities:

• Document the impact analysis of the existing reports due to changes in parent-child hierarchies of Entity, Account and Responsibility Centers.
• Identify consulting equivalent reports in RIS and document the changes required by consulting users.
• Create new reports for consulting report that are not available in RIS
• Co-ordinate wif EBS, Hyperion, ETL, and DG teams for data related issues.
• Work wif offshore team to complete report changes and testing.
• Create projects in Oracle data visualizer using relational databases and flat files.
• Provide day-to-day support to the user regarding report extracts, security and addressing the data related issues.
• Performed performance tuning of long running reports.
• Developed and designed Azure Devops pipelines to manage the resources across multiple subscriptions in Azure.
• Automated account, Scheduler and Notification Hub, IoT Hub, Log Analytics, and other PaaS services.
• Worked on GIT to maintain source code in Git and GitHub repositories
• Used Power BI Custom visuals like Power KPI, Chiclet Slicer, Infographic Designer, Spline Chart to make the visuals look and understand better
• Created DAX Queries to generate computed columns in Power BI.
• Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Extract dataset from different data source including SQL Server, excel and flat file prepare datasets for Power BI.
• Worked on Power Query in Power BIdesktop to edit the queries and Model for data modelling and establishing the relationships.
• Worked on Power BIservice by publishing the Power BIreports onto Power BIserver and collaborated team using Power BIservice to create the dashboards.
• Generated computed tables in Power BI by using DAX.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explore data in a variety of ways and across multiple visualizations using Power BI
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Identify the data feed changes and co-ordinate wif ETL teams of downstream application to update the ETL workflow and OBIEE reports.

Environment: OBIEE 12c, BI Publisher 12c, Oracle DVD 12c, Power BI, Power Pivot, Power Query, Oracle 11g, Azure Data Factory, Azure Devops, Windows, MS SQL Server.

Confidential, Hoboken, NJ

Tableau/Power BI Developer

Responsibilities:

• Involved in designing and deploying rich graphic visualizations wif Drill Down and Drop-Down menu option and parameterized using Tableau.
• Designed and implemented proof of concept solutions and created advanced BI visualizations using Tableau platform.
• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects wifin Tableau Desktop.
• Involved in creating database objects like tables, views, procedures, triggers, functions using SQL to provide definition, structure and to maintain data efficiently.
• Responsible for creating reports using SQL Server Reporting Services (SSRS) and created various types of reports like table report, trend charts etc.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues TEMPeffectively.
• Created Workbooks and dashboards for analyzing statistical billing data in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly wif the usage of quick filters for on demand-needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
• Responsible for creating SQL datasets for Power BIand Ad-hoc Reports.
• Created Tabular Models as a source toPower BIdashboards and scheduled jobs to refresh it in a timely manner.
• Developed and maintained multiplePower BIdashboards/reports and content packs.
• PublishedPowerBIDesktop reports created in Report view to thePowerBIservice.
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BIreports.
• Designed and implemented Dashboards and Scorecards wif business KPIs using Performance Point Server and published them Via Power BI.
• Worked on Power Query in Power BIdesktop to edit the queries and Model for data modelling and establishing the relationships
• Worked on Power BIservice by publishing the Power BIreports onto Power BIserver and collaborated team using Power BIservice to create the dashboards.
• Implemented real-time responsive reporting solutions wifPower BI, by connecting to the SQL Server database through On-Premises Gateway also used DAX for doing calculated measures and for creating new columns.
• Created hierarchies in Power BIreports using visualizations like Bar chart, Line chart, etc.

Environment: Tableau Desktop/Server, Power BI, Oracle, SQL, PL/SQL, T-SQL, SSRS, SSIS, MS SQL Server, Windows, MS Excel/Access.

Confidential, North Carolina

Tableau / BI Developer

Responsibilities:

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Converted all existing excel report into Tableau visualizations.
• Hands on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Working on generating various dashboards in Tableau server using various sources such as SQL Server/Teradata/Oracle/Excel/Text data etc.
• Involved in the migration of OBIEE reports to Tableau.
• Involved in the migration of Oracle Discoverer reports toAlteryxApps.
• Required to create users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau.
• Involved in creating a dual-axis bar chart wif multiple measures.
• Created report schedules on Tableau server.
• Developed Tableau data visualization using Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Involved in license management SLAs wif Tableau support.
• Developing Dashboards and preparing ad-hoc Reporting.
• Developed story-telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly wif the usage of quick filters for on demand-needed information.
• Scheduled extract refresh and subscriptions for weekly and monthly reports.

ENVIRONMENT: Tableau 8.x/9.x, OBIEE 11G, SQL Server 2012, Alteryx9.5/10, MS Access, MS Excel

Confidential

SQL/BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes, and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
• Generated Sub-Reports, Crosstab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Configured the report viewing security for various users at various levels using SSRS Report Manager.
• Played a major role in production support of SSAS cube and SSIS jobs.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• UsedSSISto createETLpackages to validate, extract, transform and load data to data warehouse and data marts
• Created SSIS packages to clean and load data-to-data warehouse.
• Created package to transfer data between OLTP and OLAP databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, CSV files to data warehouse.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved wifQuery Optimizationto increase the performance of the Report.
• EmployedFiltered Indexesto improve query performance and reduce the storage and maintenance cost.

Environment: SQL Server 2008/2012, SSAS, SQL Server Integration Services 2008, Oracle 11g, SQL Server Reporting Services 2008, PL/SQL, Microsoft Visual Studio 2010.