HANU TEEGIREDDY

Professional Summary

Over ** years of IT experience with data analysis, data access, data structures, data manipulation, databases, data reporting solutions, and technical and user documentation.

Over 13Years of experience in Business requirement gathering, Analysis and Documentation of the requirements.

Over 12 plus years of experience in Designing BO Universe and creating reports based on the Universe in Desktop Intelligence and WEB Intelligence.

Over 9 years of experience in creating the user interactive Visualizations dashboards to show quarterly and monthly trending as per the Geo maps using the Tableau Desktop and Tableau server.

Extensive experience in Migration of Business objects older versions to the Latest BI 4.0 and up.

Involved in Installation and configuration of Tableau Software in AWS cloud services and configuring VPC, ELB, EC2, SES, S3 & Inbound rules.

Highly implemented the User testing and articulated all the different issues while migrations and Documented with the resolutions by interacting with the users and the SAP technical Support for the Future References.

Worked extensively on modules Supervisor, Designing Dash Boards, Web Intelligence reports, Desktop Intelligence Reports and Broadcast agent in SAP Business Objects and Crystal Xcelicus

Over 8 years of experience in Designing and Development of Relational / Dimensional Database on Oracle9i/10g and MS SQL Server 7.x/2000/2005/2008.

Hands on experience in Installing, Configuring and Troubleshooting the Installation issues of SAP BOXIR2, BI 4.0.

Good knowledge of Dimensional modeling, Data migration, Data cleansing, Data profiling, ETL Processes (Cognos, informatica, OWB), Data mining, Data audits and Web reporting features of data warehouses.

Experience in Migrating Tableau from older version to 2018.1 version.

Experience in Tableau Administration for configuration, adding users, managing licenses, and data connections, scheduling tasks, embedding views by integrating with other platforms.

Deployment of Tableau Server in clustered environment and performing upgrades

Clusters corresponding to developed, developing, and underdeveloped countries based on the metrics used as the clustering criteria.

Experience in setting up different authentication modes SAML/SSL in Tableau server.

Experience in Integrating Tableau with SAP BI using WDC

Experience with Advanced Visualization or Analytics tools like SAP Lumira, Design Studio, Tableau, Qlik View and Analysis for Office.

In-depth experience in Extraction Transformation and Loading (ETL) processes using IBM Data Stage 8.7, 8. 5., Oracle PL/SQL and DB2 and involved in creating Source to Target Mapping, Data Profiling and Automation of data quality checks.

Hands on experience with writing and tuning complex SQL with the Track wise Database to develop Repots on Crystal reports.

Theoretical Knowledge of Brio, SAP BW

Experience in Training users, Knowledge of facilitation, mentoring and Technical writing skills including documentation and editing of user manuals.

Strong background in SQL Server/Oracle RDBMS, Data Warehousing, Data Modeling, and Reporting.

Extensive knowledge in Linux/Unix environmentand used shell scripting for better Performance.

Strong Knowledge of Software Development Life Cycle (SDLC) and multiple Software Development Methodologies like Agile and Waterfall.

Excellent Experience in Designing, Developing, Documenting of ETL jobs and mappings in Server and Parallel jobs using DataStage

Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism.

Expertise in using Transformer, Unstructured Data Stage, Aggregator, Look-up, Filter, Join Stage, Sequential file stage, Funnel Stage and Oracle stages in DataStage.

Handled slowly changing dimension Type 1 and Type 2

Expert in working on various operating systems like UNIX, WINDOWS.

Technical Skills:

Business Intelligence

SAP Business Objects Suite 5i/6i/XI/XIR2/XIR3.x/4.0, BOE Premium Suite, Business Objects SDK, Web I, Desktop Intelligence, Dashboard Builder 3.x, Performance manager 3.x, CrystalXcelcius, Lumira1.27/1.28/1.31, Design Studio1.6 SP3, Crystal Enterprise 8.5/9/10/XI /2008/2011/2013, Tableau Desktop 8.1, Tableau Server, Cognos, SSRS (SQL Server Reporting Services).

Data Modeling

Erwin 4.x/3.x, MS Visio, Data Federator, BO Data services

ETL Tool

Informatica, IBM Data Stage 8.7/8.5, UC4, OWB, Data Integrator, SQL, DTS and SSIS

Languages

C/C++, PL/SQL, Java 1.4, PL/SQL, .NET, SQL*PLUS

Web Technologies

HTML, UML, JSP, ASP, XML, ORACLE APPS RE12, EPIC

RDBMS

MS SQL Server 6.5/7.0/2000/2005/2008, Oracle 8i/9i/10g/11, MySQL, MS Access 97/2000, Teradata, DB2, Netezza, Trackwise

Operating System

Windows 9X/NT/2000/XP,2003, Unix, Linux

IDE

RAD 6.x/7.x, Win SQL, Aginity, Toad, PL/SQL Developer

Professional Experience:

Blue Shield of California, CA May’20 – Till Date

Project:Consumer Experience Operation Systems (COS) Data Visualization Engineer

Responsibilities:

Developed and productionize Next Best Action predictive model to predict the next best app to be targeted to the end user using Logistic regression.

Developed Market Opportunity Index using PCA and factor analysis to identify high potential countries for free services user acquisition and upsell, based on economic, demographic, technological and usage factors

Performed data cleansing and data mapping using python programming language for generating price variations to enable pricing decisions for profit analysis of contracts

Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.

Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.

Defined and created procedures to install Tableau desktop and server.

Collaborating as part of a cross-functional Agile team to create and enhance software that enables state of the art, next generation Big Data & Fast Data applications.

Building efficient storage for structured and unstructured data.

Utilized programming languages like Java, Scala and Open Source RDBMS and NoSQL databases.

Designed, developed and tested Tableau components required to support the reporting and analytics environments using established development standards.

Creating SQL Queries to provide ad-hoc reports, analysis, and datasets based on needs.

Experience in developing complex reports and visualizations in Tableau.

Improved data processing speed by building SQL automations.

Modifies existing ongoing report templates and dashboards built in the Tableau reporting platform.

Preparing Dashboards using calculations, parameters in Tableau.

Integrated Tableau with JAVA-API and Interacted with Dashboard with HTML web page and captured actions

Environment: Tableau 2018.1/10.1, JAVA API, MS SQL 2016/2012, Oracle, Windows Server, Machine Learning, AI, R MODEL, Python.

United Services Automobile Association, San Antonio, TX May 18 to April 20

Project: Security Identity Access Management ETL, Sr Data Analyst

Information Governance Metrics,

Knowledge Delivery Tools

Roles & Responsibilities:

Responsible for Creating and Cleaning up the Unwanted code and making the jobs to feed for 2 different systems of OIA and OIG.

Created the E3 Frame work in order to automate the jobs to run on daily bases and out put the file land on the shared drive accordingly with respect to each application

Create new OLCM jobs to create the new Object Roles of each users.

Responsible to monitor the logs and threshold limits and to contact the Customers to fix data and regenerate the new data files.

Created the UCD process for the Deployment and the versioning control of the releases.

Upgraded the Tableau dashboards from 10.5.1 -> 2018.1

Responsible to build and publish customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau Server

Create Tableau Scorecards, Dashboards using stack bars, bar graphs, scattered plots, geographical maps, line/pie graphs.

Perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples)

Created the custom SQL to render the data into Visualizations for Quarter to Quarter Changes and the Monthly differences.

Created the dashboards with multiple data sources and several standalone legacy data into the same dashboards with interactive filters with the CoSA values and the standards.

Responsible to design, develop and built DataStage parallel jobs using DataStage designer.

Responsible to create and use technical specification document.

Developed and supported the Extraction, Transformation and Load process (ETL) for a data warehouse from disparate systems using DataStage Designer.

Designed and developed Parallel jobs to extract data, clean, transform, and to load the target tables using the DataStage Client Components.

Designed and developed job sequencer to run multiple jobs with dependency and email notifications.

Used HIVE connector stage, Sequential File, SCD, Surrogate Key Generator, Transformer, Lookup, Join, Sort Stage, Modify, Copy, Filter, Change Capture and Change Apply stages, Funnel and Remove Duplicate Stage in creating ETL jobs

Experience in connecting to Cloud from Tableau

Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.

Used Load Commands to Load Data into Hive Tables as per the source files

Loading One File Data into Table and Reload the same file using Merge Command

Used GITHUB for source code repository.

Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.

Responsible to create the ETL jobs using the Data Stage and the Control M automated jobs.

Responsible to understand the production environment and priorities the work based on the business needs to and deliver the reports in regular releases.

Responsible to work as a team in an agile environment with the scrum meetings and participating in the work shop sessions based on the assigned stories.

Working as an individual to develop the analytical data into the operational dashboards which has a high visibility for the higher management in the organization.

Used Agile methodology (SCRUM) for Development

Environment: DataStage 11.5, Tableau 2018.1, Hadoop, HIVE, UNIX, Putty, Shell Scripting, Business Objects 4.3 Suite, IBM Data Stage 11.5, Control M,UCD

Texas Commission of Environmental Quality, Austin TX June 17 to April 18

Project: PIRCS and WCC BO Crystal Lead Analyst

Roles & Responsibilities:

Responsible to automate the agency Official Reposes and other Letters to reduce the manual efforts using the Crystal Reports 2016.

Developed well-formatted reports involving cross tab, sub-reports, table/section breaks using crystal Report 2016.

Extensively involved in using formula fields, parameter fields, group selection and record selection for different conditional statements and suppress the records based on the criteria of the response.

Created the Complex SQLs to retrieve the data as per the business requirements using the Command Line Queries.

Responsible for creating the automated Scripts to update the backend data by using the spreadsheets into the WCC Oracle Apps Applications.

Involved in creating Dash Boards for the Monthly/Quarterly/Yearly Analysis for the Financial Trending Reports using Tableau,

Experience with Tableau application performance monitoring, capacity planning, and tuning for multiple members on multiple projects

Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.

Preparing Dashboards using calculations, parameters in Tableau.

Created Profiles in CMC to support to report bursting feature for different groups within the Agency.

Involved in testing the code and analyzing the report based on the client’s specifications and moved the entire code into UAT and then into Production in no errors

Worked on the Tableau reports to generate Heap Maps on the TCEQ portal to Portrait the locations of the resources based on the Departmental Inputs of the Customers.

Created the TableauDashboards using Multiple data sources and created the Aggregation, KPI by data blending.

Involved in tuning Complex SQL and Pl/SQL using Explain Plan and Hints.

Utilized Agile Methodology/Scrum (SDLC) to managed projects and team.

Created the Dynamic prompts and static parameters into the Business View Manager for creating the cascading parameter and refresh the LOVS dynamically.

Worked with the BO Enterprise Team to Support the Production Environment issues based on their Priority levels.

Environment: Business Objects 4.3 Suite, Tableau 10.1/9.3,JIRA, TOAD Data Modeler, PL/SQL, SAP Design Studio 1.6, IBM Data Stage, Oracle OCI, ORACLE Apps, BO Data Services

Whole Foods Market, Austin TX Oct’17 to May 17

Project: Product Grade Reporting Senior BO Lead Analyst

Role &Responsibilities:

●Design and Develop the Sales Product Reports system in SAP Business objects 4.2 Reports.

●Conducted the Scrum Meetings and acted as a Scrum Master to the Team for Agile Methodologies.

●Develop and deploy the vendor entity mappings relations of the Customer with the Analytical dashboard using the SAP Designer and Spotfire.

●Created the complex Crystal reports using the IDT Universes derived from the Sales Data marts and their entity relationships.

●Derived the Universes from the Data model using the Information Design Tool (IDT) & UDT with complex cardinalities, joins, contexts, aggregations of tables, Derived tables and the predefined filters etc.

●Worked with ETL teams and used ODI designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges model.

●Developed the data loads Procedure to embed the Business Logic to Data Columns to Calculate the Product sales as per the brand and the Delivery, Expiry dates for each warehouse inventories.

●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 with the usage of quick filters for on demand, needed information.

●Published views and dashboards in Tableau Server for auditor review.

●Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

●Tuned SQL queries for improving the reports performance.

●Ran the Explain Plan to evaluate the cost estimation of the Query Generation to analyze the PL SQL blocks to increase the performance of the table.

●Developed Universe user documentation guide for end user reference.

●Developed test cases and involved in user acceptance testing and performance testing.

●Worked on Full End to End Life Cycle for the reports in different Environments with in the Project plan.

●Responsible for creating the users and applying the restrictions both the folder levels and the data level restrictions based on their Regional settings.

Environment: Business Objects 4.2 Suite, Tableau 9.1, FPS, Web Intelligence Rich Client, PL/SQL, ODI 12c, Oracle 11g, SSRS, DB2, BO Data Services.

Texas Education Agency, Austin TX Jan’16 to Aug’16

Project: Texas Students Data Services Senior BO Lead Developer

Role &Responsibilities:

Upgraded the BO Environment from version BI 4.1 version with BI 4.3 SP3.

Recreated the reports into Crystal Enterprise/2013 version to connect with the database tables and the stored procedures.

Configured and integratedLDAP Authentication, mapping extended user attributes in the LDAP Directory to Business Objects and applying security using extended user attributes on Business Objects Universes and Reports (.unx).

ETL inbound/outbound XML files validation matching source/legacy systems.

Design, develop and maintenance of Business Objects Universe’s using Information Design Tool to drive Static and ad-hoc reports.

Developed complex Reports using Web I/Crystal Reports for Enterprise, Dashboards for data analysis.

Developed the Analytical Dashboard reports in SAP Design Studio with HANA as the data source to Project the Student accounting information in the Student GPS.

Developed reports using LOVs, drill down, filters, dynamic cascading prompts and alerts.

Developed the reports with Lumira to display Summary reports with bargraphs, piecharts and linegraphs representing the (year-over-year) data efficiently and interactively with Visual effects on the Mobile Applications.

Developed well-formatted reports involving cross tab, sub-reports, table/section breaks using Web I /Crystal Reports for Enterprise.

Extensively involved in using formula fields, parameter fields, group selection and record selection in Crystal Reports for Enterprise.

PEIMS web application development and validation of Business functional requirements.

Created PL/SQL scripts for verification of the required functionality.

Created summarized views to improve the performance of the reports.

Tuned SQL queries for improving the reports performance.

Developed test cases and involved in user acceptance testing and performance testing.

Actively worked on Team Forge tracking tool to conduct the Scrum Meeting and Retrospective for sprint Models.

Environment: Business Objects 4.3 Suite, Crystal Reports 2013/Enterprise, Team Forge, Web Intelligence Rich Client, PL/SQL, SAP Design Studio 1.6, IBM Data Stage 8.7/8.5, Oracle 11g, SSRS, BO Data Services

Eli Lilly, Indianapolis, IN Sep’15 to Dec 15

Project: HR Dashboard Using SAP LUMIRA/Tableau Sr Programmer Analyst

Roles and Responsibilities:

Developed the Dashboards with Lumira to display Summary reports with bargraphs, piecharts and Organizational Geographical representation ofthe (year-over-year) data efficiently and interactively with Visual effects on the Mobile Applications.

Developed well-formatted reports involving cross tab, sub-reports, table/section breaks using Web I /Crystal Reports for Enterprise.

Involved in publishing of various kinds interactive data visualizations from Tableau Desktop to Tableau servers.

Involved in creating dashboards using different types of charts like Pie charts, Do-nut chats, Bubble charts, combination chats, geo maps etc...

Extensively participated in translating business needs into rich visualizations using Tableau Desktop.

Involved in designing the dashboards for the HR Dash boards using Tableau for different Sources of data to leverage the dashboards for the Business Owners and the I pad/Mobile Users.

Participated in Conversion of Corporate Data warehouse (CDW) to Enterprise Data warehouse (EDW) Reports Using Agile Methodology.

Extensively worked on the SAP Design studio to develop the reports using the Cumulative IDT universes to design the cross-tab reports with the various Radio buttons, input controls and different filters in the filter panel which leverage the users to filter the data based on their needs.

Extensively worked on Business objects info view for Importing, Exporting, setting up the credentials to the Viewers/Ad-hoc users/Developer and scheduling the reports to trigger and sending emails at respective timestamps required to the end users.

Worked with ETL Development Team for extracting data from SAP Rapid Marts, perform Transformations as per the requirement and Load the data into existing Oracle DB Using BODS.

Involved In creating and Maintaining Crystal reports 2008 with different Drilldown Detailed Reports using Sub reports and Cross Tab reports for Trending charts

Environment: Business Objects 4.2, SAP LUMIRA 1.28, Tableau Desktop 8.3/7.0, Tableau server/Administrator, Crystal Reports 2011, Design Studio1.6 SP3, Remedy ARS, Web Intelligence Rich Client, PL/SQL, Oracle 11g, SSRS, Track wise, BO Data Services, SAS, Crystal Xcelsius

Texas Education Agency, Austin TX March’14 to Aug’15

Project: Texas Students Data Services Senior BO Lead Developer

Role &Responsibilities:

Installing, configuring and administering the Business Objects 4.1 SP1/4.0 SP6 environments and configuring Development, Test and Production cluster environments.

Upgraded the BO Environment from version 3X to BI 4.1 version. Migrated all the Users groups, Universes, BO reports from the prior versions using promotion management tool.

Recreated or modified the universes according to the new requirements and converted all Unv files into the unx files and recreated the row level restrictions based on the required data restrictions.

Configured and integratedLDAP Authentication, mapping extended user attributes in the LDAP Directory to Business Objects and applying security using extended user attributes on Business Objects Universes and Reports (.unx).

Developed the Analytical Dashboard reports in SAP Design Studio with HANA as the data source to Project the Student accounting information in the Student GPS.

Designed and implementedPEIMSApplication integration with Business Objects Java SDK, thereby eliminating the need of coding security and Java Viewer, prompt pages etc., at the application and creatingBI4Workspaces, which lets the users to view TSDS Dashboards/PEIMS Reports to which they have access within the Portal/PEIMS Application itself.

Worked with the Business Users and the Analysts to conduct the user sessions and the demonstrated the New User interface of the BI Launch Pad and the features and the enhancements with the Advantages over the older versions of BO.

ETL inbound/outbound XML files validation matching source/legacy systems.

Involved in creating interactive dashboards in Tableau.

Scheduled extract files to provide latest information in dashboards in Tableau server.

Design, develop and maintenance of Business Objects Universe’s using Information Design Tool to drive Static and ad-hoc reports.

Created Joins, defined Contexts and Aliases for resolving loops in the universes.

Developed complex Reports using Web I/Crystal Reports for Enterprise, Dashboards for data analysis.

Developed reports using LOVs, drill down, filters, dynamic cascading prompts and alerts.

Developed well-formatted reports involving cross tab, sub-reports, table/section breaks using Web I/Crystal Reports for Enterprise.

PEIMS web application development and validation of Business functional requirements.

Created PL/SQL scripts for verification of the required functionality.

Created summarized views to improve the performance of the reports.

Developed Universe user documentation guide for end user reference.

Developed test cases and involved in user acceptance testing and performance testing.

Providing training for the end users for interacting with BI Workspaces, scheduling their own reports etc.

Environment: Business Objects 4.0 Suite, Crystal Reports 2008/XI, Remedy ARS, Web Intelligence Rich Client, PL/SQL, IBM Data Stage 8.7/8.5, Oracle 11g, SSRS, BO Data Services, Crystal Xcelsius

Shire Pharmaceuticals, Wayne, PA Jan’13 to March’14

Project: CMSO, CBI Sampling and BI Upgrades BO Lead Specialist/Architect

Role &Responsibilities:

Responsible to coordinate the operations of the business to provide the support to 3 different applications with a team Size of 6 people.

Experienced in leading, developing and delivering Training materials to users.

Acted as systems/software engineer for system architecture planning, technical design, software development and test, and software, hardware, and interface integration in BO Admin Support

Worked with server team to provide them with list of specifications need to build the servers for new environment set up.

Administered user, user groups, and scheduled instances for reports in Tableau.

Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.

Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in Tableau Desktop.

Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in Tableau.

Worked on Bubble chart, drill down analysis using tableau desktop for ADHD and GIBCO Portals

Installed and tested the BI 4.0 application on sandbox before moving to live systems and resolved issues accordingly.

Extensively used BO Life Cycle Management to migrate reports across different environment (i.e. Dev, test and prod).

Created/Administered users/user groups/Security in Supervisor/CMC.

Created Profiles in CMC to support to report bursting feature.

Designed and migrated (UNV to UNX) Universes using Information Design Tool (IDT) and developed Web Intelligence and Crystal reports in BI 4.0 Launch Pad.

Performed the User Training Sessions with Lab sessions on the Data marts, Universes and Reports in respective to the users Business Area.

Expert in creating web intelligence documents using level input controls, merged dimensions, data tracking, open doc and complex filters (query and report level).

Developed complex universes by using advanced features like aggregate aware, Derived SQL, LOV and hierarchies.

Developed and implemented Universesby defining joins, cardinality between tables, creating prompts and queries, applying contexts and alias tables to remove cyclic dependencies using Business Objects Designer.

Created complex WEBI reports with time, trending and comparative reports to make the Live Dash boards in Crystal Xcelsius and Lumira.

Executed tasks and duties with sensitive deadlines in timely manner.

Environment: Business Objects 4.0/3.x, Crystal Reports 2008/2011, Tableau Suite 6.1,TOAD, Oracle 11g, UC4, Netezza, Track wise, SQL Server, Oracle and SQL.

Blue Cross Blue Shield of North Carolina, Chapel Hill, NC Oct’11 to Dec’12

Project: CDW Retirement with BO Upgrade Lead BO Developer/Analyst

Role &Responsibilities:

Participated in Conversion of Corporate Data warehouse (CDW) to Enterprise Data warehouse (EDW) Reports Using Agile Methodology.

Conducted and Facilitated the Conversion of Desk I Reports to Web I and Crystal reports in BI 4.0 Environment.

Created and maintained custom universe and analyzed over 300+ universes inventoried

Specific to project needs.

Extensively usedBO Life Cycle Managementto migratereports across different environment (i.e., Dev, test and prod).

Obtained and analyzed User’s Information and Security levels in BO 6.5 and implemented new Security in SAP BO 4.0.

Created Profiles in CMC to support to report bursting feature.

Designed and migrated (UNV to UNX) Universes using Information Design Tool (IDT) and developed Web Intelligence and Crystal reports in BI 4.0 Launch Pad.

Performed the User Training Sessions with Lab sessions on the Data marts, Universes and Reports in respective to the users Business Area.

Designed Crystal Report 2011 templates with conditional Formatting as per the end user requirements

Created complex Billing Reports and Claims reports with complex Logics and the Adjustments in the billing Claims based on the adjudications and the Negotiations from the Providers and Medical Agencies.

Published Universes and Report documents to the Repository as part of the production deployment and made them available to the users.

Developed complex universes by using advanced features like aggregate aware, Derived SQL, LOVs and hierarchies.

Developed and implemented Universesby defining joins, cardinality between tables, creating prompts and queries, applying contexts and alias tables to remove cyclic dependencies using Business Objects Designer.

Created complex WEBI reports with time, trending and comparative reports to make the Live Dash boards in Crystal Xcelcisus.

Environment: Business Objects 4.0/3.x, Crystal Reports 2008/2011, TOAD, Teradata 13.x, Abinitio, SSIS, SSRS, Oracle and SQL.

Eli Lilly, Indianapolis, IN May’11 to Sep’11

Project: Implementation of SAP Rapid Marts BO Specialist/Application Support

Roles and Responsibilities:

Responsible for Implementing the Ad-hoc changes and supporting the Finance reports for Business requirements in different SAP modules GL, AP, SD, MM, PP, AR.

Worked on the HIPAA standards and completed basic Epic Training for the Special Clinical Data and the required reports for the Sales and Distribution, Receivables and Professional Billing (PB) Reports.

Worked on Full End to End Life Cycle for the reports in different Environments with in the Project plan.

Responsible for creating the users and applying the restrictions both the folder levels and the data level restrictions based on their Regional settings.

Extensively worked in supporting the BOBJ 4.0 Reporting and the universes changes.

Responsible for creating Professional Billing (PB) reports with Business objects XI R3 Reports WEBI and Crystal Reports (on demand, Ad-Hoc reports, Frequency reports, Summary reports, Sub reports, Drill-Down, Dynamic Grouping, Cross-Tab, and Graphical, Aging reports).

Participated in review of Existing universes and their modifications to meet the user reporting requirements. Implemented enhancements to the existing universes, fixed joins and contexts problems, applied aggregate awareness to speed up the query time, created cascading prompts and new objects with customized LOV’s to support the current environment.

Involved in creating Dash Boards for the Monthly/Quarterly/Yearly Analysis for the Financial Trending Reports using Crystal Xcelcisus.

Created

Contact this candidate