Business Intelligence Developer

KUMAR KASUGANTI KIRAN

Ashburn VA-***** • adhijr@r.postjobfree.com • 571-***-**** • www.linkedin.com/in/kkasuganti

SR. BUSINESS INTELLIGENCE/ TABLEAU DEVELOPER

Sr Business Intelligence Developer with experience in design, development, and implementation of business intelligence (BI) and data warehousing projects. Able to develop metrics, dashboards, data visualizations and storytelling using Tableau and Power BI. Demonstrated ability to complete implementation of BI solutions for clients Fannie Mae, Gate Gourmet, Administrative Office of US Courts and FDIC. Worked with whole spectrum of Software Development Life Cycle, including requirement gathering, system designing, data modeling, application development, enhancement, deployment, maintenance, and support. US citizen with public Trust clearance

TECHNICAL SKILLS

BI Tools: Tableau, Power BI, Business Objects

ETL Tools: Alteryx, Informatica

Database: Oracle, Teradata, MS-SQL Server, MS-Access

Dev Languages: SQL, PL/SQL, Java, and Python

OS: Windows, UNIX, Sun Solaris, MS-DOS

PROFESSIONAL EXPERIENCE

Fannie Mae, Washington DC (Sr. Business Intelligence Developer) June 2012 - October 2020

Hosting and Engineering Services

Developed and maintained analytics, reports, metrics, and visualizations for Infrastructure demand, Server footprint, AWS cloud, Compute distribution, Storage and Network capacity.

Created detailed business functional/nonfunctional requirement specification and collaborated with teams to implement BI solutions for Infrastructure.

Converted around 40 Business Objects reports to Tableau for Hosting and Engineering services.

Developed metrics and reports for Infrastructure Demand which are used for analysis and forecast of complete Fannie Mae IT infrastructure.

Created Cloud infrastructure reports which are used for financial estimations and forecasting.

Developed Tableau visualizations for server retirement, compute distribution, network metrics.

Developed Power BI Visualizations and reports for Cloud Infrastructure management meetings.

Supported stakeholders as a Subject Matter Expert (SME) through troubleshooting, analysis of results and improving reports performance.

Generated complex Alteryx workflows for data cleansing, data preparation and loading from different sources.

Developed reporting solutions to Compute division for day to day operations and reporting on software licensing costs, applying patches and other operations.

Performed administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.

Engineering Operational Analytics and Compliance

EOAC team developed business intelligence reports using SAP Business Objects and Tableau to support enterprise wide business decisions for Fannie Mae.

Supported the business requirements to reduce system generated event monitoring incident tickets by analyzing millions of database records to find problem areas and creating automated scheduled reports to track project progress over time.

Provided monthly reporting of production support metrics to the business, including incident, change and problem trends, application monitoring compliance, and server upgrade tracking.

Created around 30 Business Objects and Crystal Reports for various business stakeholders and customers.

Multi Family Mortgage Business Operations

The primary objective of this project is to promote Integrated Database (IDB) to the Multifamily Operational Data Worked on updating the MMB Business Objects Reporting Universe.

Worked on Data Profiling, ETLs and analyzing the data for ODS, FRCO.

Designing of Snowflake Schema using Business Objects Designer module to map into Business requirements of the end user.

Kumar Kasuganti Kiran adhijr@r.postjobfree.com Page Two

Implemented Row level security for Business Objects Report.

Responsible for creating on-demand and schedule reports based on the business requirements

Created Complex and Multidimensional reports using Slice and Dice, Cross Tab and Hierarchies.

Used Alerts, Filters, Breaks, Sorts and Rankings, Customizing User Objects, List of Value (LOV’s) in the reports.

Migrated Business Objects to various environments and Production.

Done Unit Testing for Universe and interaction with end users.

Environment: Tableau, Power BI, Business Objects 4, Alteryx, Oracle, Clear Quest, UNIX and Windows NT

Gate Gourmet (E Gate Solutions) January 2012 - June 2012

Sr. Business Objects Developer

IFX4 and GGRI Business Intelligence Projects

Gate Gourmet is the world’s largest independent provider of catering and provisioning services for airlines and railroads. I worked on IFX4 and GGRI Business Intelligence projects.

Inflight Exchange (IFX4) is the airline industry's first centralized, web-based communications platform for air lines and their inflight supply chain.

Gate Gourmet Retails Intelligence (GGRI) is for Gate Gourmet Retail Solutions team which manages the sales data infrastructure, operations, product, and strategy on behalf of existing airline customers, if specified in contract.

Worked on implementation of Business Objects for IFX4 and GGRI Business Intelligence projects.

Gathered Business requirements, Reporting needs and interacted with Business teams.

Designed and developed the Universes by using Business Intelligence 4.0 Information Design Tool.

Worked on on-call and production support for Universe and Reports.

Implemented whole life cycle of Business Objects

Worked on Data Profiling, ETLs and supported ETL teams.

Implemented Row level security and created security profiles for Business and Data security.

Converted OBIEE reports to Business Objects

Responsible for creating on-demand and schedule reports based on the business requirements

Created Complex and Multidimensional reports using Slice and Dice, Cross Tab and Hierarchies.

Used Alerts, Filters, Breaks, Sorts and Rankings, Customizing User Objects, List of Value (LOV’s) in the reports.

Support business users and application developers in the creation of Web Intelligence, Dashboards, and Live Office reports.

Trained business users and created User documentation.

Environment: SAP Business Intelligence Business Objects 4.0, Information Design Tool, Dashboards 4.0, Web Intelligence,

Oracle 10g and Windows XP/Windows 7.

FDIC (Federal Deposit Insurance Corporation) September 2010 - January 2012

Sr. Business Objects Developer

4C (Communication, Capability, Challenge and Control-Asset Servicing Technology Enhancement Project), CMMI Level 3 Project

One of the FDIC’s mission-critical functions is the management and liquidation of the assets of failed financial institutions. The 4C system is an integrated, end-to-end web-based application that provides full functionality to support franchise marketing, asset marketing and asset management. 4C provides a consistent interface that is used across business lines and for different types of assets. 4C provides an enterprise solution for servicing the assets obtained from failed financial institutions.

Worked on implementation of Business Objects for 4C Closed Banks Application.

Designed and developed the Universes for the above Program Areas.

Implemented whole life cycle of Business Objects

Designing of Snowflake Schema using Business Objects Designer module to map into Business requirements of the end user.

Implemented Row level security for Business Objects Report

Migrated Reports from Hyperion to Business Objects

Kumar Kasuganti Kiran adhijr@r.postjobfree.com Page Three

Created on-demand and schedule reports based on the business requirements

Created Complex and Multidimensional reports using Slice and Dice, Cross Tab and Hierarchies.

Used Alerts, Filters, Breaks, Sorts and Rankings, Customizing User Objects, List of Value (LOV’s) in the reports.

Migrated Business Objects to various environments and Production.

Support business users and application developers in the creation of Web Intelligence, Crystal Reports, Xcelsius, Desktop Intelligence, and Live Office reports.

Develop custom reporting applications using BO XI SDKs.

Worked on Operations and Maintenance of Application.

Done Unit Testing for Universe and Business Object Reports and interaction with end users.

Environment: Business Objects 4.0/XI (Web Intelligence, Designer, CMC), Crystal Reports 2010, Live Office R3, Xcelsius, Oracle 10g, Clear Quest, Documentum, UNIX and Windows XP/Windows 7.

Administrative Offices of US Courts, Washington DC March 2008 - August 2010

Sr. Business Objects Developer

The project is for modernization of legacy Main Frame system to Data warehousing using Business Objects tools. The Office of Judges Programs (OJP) in the Administrative Office of the United States Courts (AO) is engaged in the modernization of the system for collecting, processing, analyzing, and reporting on caseload throughout the federal judiciary. To accomplish this objective, the New Streamline Timely Access to Statistics (NewSTATS) project has been initiated.

NewSTATS provides decision support information to chief judges, individual judge’s chambers, clerks of court, and management in the administrative office.

NewSTATS is also focused on providing improved statistics gathering, analysis, and reporting services to the courts and other judiciary users while containing costs for these same services.

Worked on implementation of Business Objects for BANKRUPTCY, CJRA and CIVIL program areas.

Designed and developed the Universes for the above Program Areas.

Implemented whole life cycle of Business Objects

Worked on Data Profiling, ETLs and analyzing the data for various program areas.

Designing of Snowflake Schema using Business Objects Designer module to map into Business requirements of the end user.

Implemented Row level security for Business Objects Report

Migrated Reports from Hyperion to Business Objects

Created Complex and Multidimensional reports using Slice and Dice, Cross Tab and Hierarchies.

Used Alerts, Filters, Breaks, Sorts and Rankings, Customizing User Objects, List of Value (LOV’s) in the reports.

Migrated Business Objects to various environments and Production.

Support business users and application developers in the creation of Web Intelligence, Crystal Reports, Xcelsius, Desktop Intelligence, and Live Office reports.

Develop custom reporting applications using BO XI SDKs.

Worked on Operations and Maintenance (O&M) of BANKRUPTCY.

Done Unit Testing for Universe and Business Object Reports and interaction with end users.

Environment: Business Objects XI R2 (Web Intelligence, Designer, CMC), BO Data Integrator XI, Xcelsius, Informix, Clear Quest, Documentum, UNIX and Windows NT

EDUCATION

Master of Business Administration (MBA)

Kakatiya University, INDIA

Contact this candidate