Business Intelligence Power Bi

Mohan Krishna Seemakurthi

Sr Business Intelligence Architect

413-***-**** / *****.******.**@*****.***

Summary:

With 12+ Years of IT experience in IT field as Business Intelligence Developing/Managing using Cloud Power BI, Snowflake, Azure Data Studio, SSIS, SSRS, Crystal Reports, Business Objects, Oracle Business Intelligence, Tableau, PL/SQL, LookML Qlik Sense and SQL DBA, Redshift, Monitoring CSS, HVAC Dashboards, Databricks, Data Analytics performance, ETL Data Pipeline, MS Fabric, Jenkins, Alteryx, tuning, Looker Troubleshooting and Maintenance of Data Base Datawarehouse design and Data modeling.

Manage Assignments and Track Progress agree timelines

Plan, organize, prioritize, and manage work efforts, coordinating with the EDW and other teams.

Participate in status reviews, process reviews, deliverable reviews, and software quality assurance work product reviews with the appropriate stakeholders.

Participate in business, functional, quality-of-service, and technical requirements gathering. Assist in developing Stakeholder / User requirements; an important part of the deliverables, the needs of the stakeholders will have to be correctly interpreted.

Develop report specifications - define the purpose of a report, its justification, attributes and columns, owners, and runtime parameters.

Work with business leaders and Stakeholders and Understand data and Data Analysis needs and Develop Technical Requirements.

Analyze the Large Build and Design Large Relational Database Architecture, Complex Data to Determine business Insights Using Service Reporting Tools

Dispatching the SQL Queries Joining Tables from Data source to Satisfy Requirement

Strong Analytical and Problem Solving and Project Management Skill and Communication Skills

Worked on Power BI (Power Pivot, Power Query) report & dashboards with SQL Server, advanced Analytics and Data security best practices

Worked extensively on Power BI and Services (publishing, collaborating and managing Reports and Dashboards

Experience in publishing reports to Power BI services and setting up the necessary connection settings.

Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Power BI Reports and dashboards.

Develop graphic representations of complex business processes. Assist in creating workflows using formal notation such as the Business Process Modeling Notation (BPMN).

Extensive Experience of around 3.5 years in Tableau Desktop and Tableau Server in various versions of Tableau 8.0, 8.1, 8.2, 9.0, 9.3, 10 as a Developer.

Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

Experience in working with Self Service MS BI end user tools such as Excel 2010 (Power pivot), Performance Point Server (PPS), Power view. Created Splunk Dashboards for different sorts of business clients in association.

Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers and User-defined Functions.

Experience with Splunk technical implementation, planning, customization, integration

with big data and statistical and analytical modeling.

Expertise in Actuate Reporting, development, deployment, management and performance tuning of accurate

Headed Proof-of-Concepts (POC) on Splunk implementation, mentored and guided other team members on Understanding the use case of Splunk.

TECHNICAL SKILLS:

Reporting Tools: Power BI, SQL Server Reporting services (SSRS), Crystal Reports, Business Objects WEBI, Tableau, Qlink

Dimensional Data Modeling Tools: Dimensional data modeling using Erwin modeling (Erwin 4.1/4.0/3.5.5/3.5.2), Physical & Logical Data Modeling, multidimensional modeling, Snowflake Schema/ Star Schema modeling (Normalization / De-Normalization Techniques), Erwin, Visio, automation

ETL Tools: Informatica, SSIS, C++,C

Databases: Snowflake,BigQuery,Oracle Cloud, Azure, Hadoop cloud, Oracle 10g/9i/8i/8.0, MS SQL Server, 2008/2005, MS Access, Siebel, Sybase, Teradata, Informix, Netezza.

Data warehousing: Python, R, Star-Schema Modeling, Snowflakes Modeling, FACT, dimension tables.

Operating Systems: Windows Server 2003/2000/NT, Windows Vista/ XP/ME/98/95, DOS, UNIX.

Windows Utility: MS-Word, MS-Excel and MS-PowerPoint.

Web Servers: Web Logic, Web Sphere, Apache Tomcat

Query Tools: TOAD, SQL*PLUS, SQL*Loader, SQL Navigator.

EDUCATION:

Master’s in software engineering - University of Houston Clear Lake - 2014

Bachelor’s in computer science in JNTUH -2011

PROFESSIONAL WORK EXPERIENCE:

Commonwealth of Virginia

GSK Solutions, Houston, TX 12/12/2022- Present

Role: Business Objects Developer/Power BI Architect

Responsibilities:

Developed Power BI model used for financial reporting of P & L and Headcount.

Designed and documented the entire Architecture of Power BI POC

Expertise in writing complex DAX functions in Power BI and Power Pivot Tables Macros.

Automated Power Query refresh using power shell script and windows task scheduler.

Used various sources to pull data into Power BI such as Snowflake, HANA, Oracle, SQL Azure VLOOKUP etc.

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 queries 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.

Worked on all types of transformations that are available in Power BI query editor

Design and Development of Business Objects Universes using Information Designer Tool (IDT), which suits the standard, analytical and ad-hoc reporting requirements.

Interacted with Business Users, Business owners to know their business requirements in developing and modifying Universes and Reports accordingly.

Migrating Reports from BOBJ to Power BI Paginated reports and Dashboards

Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.

written SQL Script views, PL/SQL and stored procedures from Data Warehousing Perspective

Designed and maintained complex Universes, resolved loops by creating aliases and contexts.

Use of Business Objects Designer module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.

Loading Data from Different source systems to Data warehouse using informatica/SSIS

Creating PL/SQL statements and stored procedures, Common Table Expression, Join Types.

Creation of different types of reports, such as: Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc. In Design Studio.

Creation of reports like, reports by product, reports by customer, reports by period and comparative reports.

Created Joins, Contexts and Aliases for resolving Loops and checked the Integrity of the Universes.

Created Scorecard reports using Desktop Intelligence functionalities like Combined Queries, Drill Down, Functions, Cross Tab, Master Detail and Formulas.

Organized data in the reports by inserting Groups, Filters, Sorting, Ranking and highlighting the data using Alerts.

Generated Reports using the Universe as the main Data provider and using the personal data files provided by the users and Free-hand SQL as data provider.

Extensively used multiple data providers for building reports.

Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.

Capital Group

EA Team inc, Edison, JN 06/01/2016 -12/11/2022

Business Objects / Crystal Reports / Power BI Lead

Responsibilities:

Inventory, Accounts Payable and Purchase Orders were the different subject areas within the data warehouse Bank.

Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs.

Created custom hierarchies to aid in Drill-Through analysis of WebI documents and built cascading prompts.

Configure and maintain using Report Manager and Report

Server for SSRS, Deployed and Scheduled the Reports in Report Manager, Created Reports using Charts, Gauges, Tables, matrix.

Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.

Created Drill Down Reports, Drill Through Report by Region, created multiple visualizations like Heat Maps, Bar Graphs and Bullet Graphs.

Preparing Dashboards using calculations, parameters in Tableau.

Using Power BI Desktop, multiple dashboards were created from the tabular model according to business requirements.

Various Financial services Custom visuals like Power KPI, Chiclet Slicer, Infographic Designer, Spline Chart were used to make the dashboard more interactive and Customer Investment Bank. Experience

Participated in the complete development lifecycle: analysis, design, build and test reports

Created several complex Web Intelligence and Desktop Intelligence reports to help management to track and monitor contract, commodity and price compliance.

Created reports linking several universes for different subject areas like Purchase Orders, Accounts Payable, Pharmacy and Inventory for seamless reporting.

Loading Analyzed Data from different source systems to Data warehouse using informatica/SSIS

Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report. Extensively used Calculations, Variables, User Objects in the creation of reports.

Created User Prompts, Conditions and Filters to improve the quality of report generation.

Scheduled Reports using scheduler Infoview as well as CMC.

Key metrics ‘procure to pay cycle times’, ‘diversity spend’, ‘cash discounts captured and missed’

spanning across different subject areas has been re-created using Xcelsius.

Consolidation of reports by groups/regions and designing templates catering to the needs of sourcing/financial analysts & material and cost specialists.

Providing support for the users on application usage and conducting training walk through of salient features of the application.

Commonwealth of Kentucky

HCL Global Systems; Farmington Hills, MI 01/01/2016- 06/01/2016

Role: Business Objects /Crystal Reports

Responsibilities:

Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Initiated DBA interactions for resource requirements and modifications

Based on the requirements, extracted the data from IBM Main frames by creating data stores using ODBC connection.

Strong Programming experience in MS SQL SERVER using T-SQL, SSIS (SQL server Integration Services) and SSRS (SQL Server Reporting Services)

Created new mappings and updated old mappings according to changes in Business logic

Installed and configured business Object Suite of products.

Implemented Publishing Wizard and Import Wizard for migration of reports.

Reviewed Business requirements documents from business analysts and prepared functional specification documents and completed the report application development.

Create/Modify/Troubleshoot Report issues in Webi, Deski and Crystal reports.

Enhancements/Troubleshoot Universe issues using Designer.

Migrating Webi Reports and Universe from 3.1 to 4.0 using UMT.

Migrated Universe/reports/folders/groups/Users using Import Wizard across platforms.

Used Footprints, web-based application for tracking/open Incidents, RM, RFCs and work on them on priority and timely delivery.

Create and add users/Groups from Active directory and Enterprise Authentication.

Designed Universes using Business Objects Designer.

Created Joins, Contexts and Aliases for resolving Loops and checked the Integrity of the Universes.

Created Scorecard reports using Desktop Intelligence functionalities like Combined Queries, Drill Down, Functions, Cross Tab, Master Detail and Formulas.

Organized data in the reports by inserting Groups, Filters, Sorting, Ranking and highlighting the data using Alerters.

Generated Reports using the Universe as the main Data provider and using the personal data files provided by the users and Free-hand SQL as data provider.

Extensively used multiple data providers for building reports.

Extensively used Crystal Xcelsius to build Dashboards and Scorecard presentation.

Designed and developed Crystal Reports like Cross Tab Reports, Top N Records for highlighting significant data, summary reports with drill-down capabilities.

Gaming Labs

SAPVIX INC 01/01/2015-12/31/2015

Business Objects / Crystal Reports

Responsibilities:

Design and Development of Business Objects Universes using Information Designer Tool (IDT), which suits the standard, analytical and ad-hoc reporting requirements.

Upgrading existing Universes to Business Objects 4.2.

Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting.

written SQL Script views, PL/SQL and stored procedures from Data Warehousing Perspective

Migrating Reports and Universe from R3 to R4 using Upgrade Management Tool (UMT).

Use of Business Objects Designer module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.

Creating PL/SQL statements and stored procedures.

Creation of different types of reports, such as: Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc. In Design Studio.

Creation of reports like, reports by product, reports by customer, reports by period and comparative reports.

Created Joins, Contexts and Aliases for resolving Loops and checked the Integrity of the Universes.

Created Scorecard reports using Desktop Intelligence functionalities like Combined Queries, Drill Down, Functions, Cross Tab, Master Detail and Formulas.

Organized data in the reports by inserting Groups, Filters, Sorting, Ranking and highlighting the data using Alerts.

Generated Reports using the Universe as the main Data provider and using the personal data files provided by the users and Free-hand SQL as data provider.

Extensively used multiple data providers for building reports.

Scheduling the Reports and Training and supporting the Developers.

EDF Renewable Energy

Andhus Technologies Itasca, IL 06/01/2014-12/01/2014

Role: SAP Business Objects /Crystal Reports

Responsibilities:

Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Initiated DBA interactions for resource requirements and modifications

Based on the requirements, extracted the data from IBM Main frames by creating data stores using ODBC connection.

Strong Programming experience in MS SQL SERVER using T-SQL, SSIS (SQL server Integration Services) and SSRS (SQL Server Reporting Services)

Created new mappings and updated old mappings according to changes in Business logic

Installed and configured business Object Suite of products.

Implemented Publishing Wizard and Import Wizard for migration of reports.

Reviewed Business requirements documents from business analysts and prepared functional specification documents and completed the report application development.

Create/Modify/Troubleshoot Report issues in Webi, Deski and Crystal reports.

Enhancements/Troubleshoot Universe issues using Designer.

Migrated Universe/reports/folders/groups/Users using Import Wizard across platforms.

Used Footprints, web-based application for tracking/open Incidents, RM, RFCs and work on them on priority and timely delivery.

Create and add users/Groups from Active directory and Enterprise Authentication.

Designed Universes using Business Objects Designer.

Created Joins, Contexts and Aliases for resolving Loops and checked the Integrity of the Universes.

Created Scorecard reports using Desktop Intelligence functionalities like Combined Queries, Drill Down, Functions, Cross Tab, Master Detail and Formulas.

Organized data in the reports by inserting Groups, Filters, Sorting, Ranking and highlighting the data using Alerters.

Generated Reports using the Universe as the main Data provider and using the personal data files provided by the users and Free-hand SQL as data provider.

Extensively used multiple data providers for building reports.

Extensively used Crystal Xcelsius to build Dashboards and Scorecard presentation.

Designed and developed Crystal Reports like Cross Tab Reports, Top N Records for highlighting significant data, summary reports with drill-down capabilities.

Designing and developing Master controlling sequencer jobs using the DataStage Job Sequencer.

Prepared user document and involved in hand on training for the users

Migrated few BO reports and universe from BO XI R2 both full client and thin client to BO XI 3.0.

Performance Testing the Crystal Reports.

Creating Triggers, Stored Procedures, functions, packages, @prompts.

Increased the Report Performance By using some advanced SQL statements and Methodologies.

Troubleshoot the reports and Deliverables on Time

Followed Agile Methodology in Developing.

Contact this candidate