RUTHWIK

adav3s@r.postjobfree.com 609-***-****

* ***** ** *********** ********** in analysis, design, development, implementation, maintenance and administration of WebFOCUS /SSRS/Tableau reporting applications.

Excellent Verbal and Written Communication Skills have proven to be highly effective in interfacing across business and technical groups.

Experience in various stages of the Report Development Life Cycle - Requirement analysis, design, development, testing and implementation.

Delivered Business Intelligence and provided WebFOCUS consulting services for 5 years in various industries.

Expertise in business process requirements, business / system analysis, data modeling, design, development, documentation, testing, training and software upgrade / conversions with WebFOCUS.

Involved in the production of various reports including Web accessed reports, MRE reports, drill-down reports, ad hoc/ graphical /Canned reports, etc. using WebFOCUS tools such as Join Builder, Report Assist, Report Painter, Graph Assistant, etc.

Experience in customizing Business Intelligence Portals and Dashboards with drill-downs, filters in reports and charts using Report Painter and HTML composer in WebFOCUS

Experience transforming complex business requirements into rich data visualizations using WebFOCUS.

Very good experience in various stages of the Report Development Life Cycle-Requirement analysis, design, development, testing and implementation.

Development of ETL (extract, transform, and load) procedures to load reporting database from source data on a scheduled basis using Information Builder's Data Migrator tool.

Experience in preparing Requirement Specifications, Functional Design Specifications, Detail Design Specifications, Various test plans and test cases.

Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of reports generated in WebFOCUS.

Strong knowledge of Data Warehousing Concepts, Multidimensional Modeling and OLAP

Designed and developed Various Reports by accessing various databases such as Oracle, Focus DB2 and SQL Server

Experienced with migrating from WebFOCUS 7.x. to WebFOCUS 8.x.

A responsible software developer, fast learner, good technical abilities and skills developed by a strong work ethic and self-learning

Excellent interaction with business SMEs, client users, understanding business applications, business scenarios, business data flow, data relations and experience in testing, production support and post production releases.

Technical Proficiency:

Business Intelligence Tools: Information Builders (WF Developer Studio, WF Language and Dialogue Manager, WF Managed Reporting, Info Assist, WF Dashboards, Report Caster, WF Graphing, WF Active Reports, Visual Discovery).

Web Technologies: HTML, JavaScript, CSS.

Languages: PL SQL, Java Script, jQuery, XML, FOCUS.

Databases: DB2, Oracle, MS Access, SQL server, SAP BW

Operating Systems: Windows 10, UNIX, Linux

Work Experience:

Client: Verizon – Warren, NJ Jan 2019 – Till Date

Role: WebFOCUS Developer

Responsibilities:

Involved in working with business users to support the business needs by providing key metrics.

Development of reporting environment including reports and user interface for execution of reports using WebFOCUS (AppStudio 8.2.01/8.1.0.5) for creating reports and developing user interface

Collaborated with business partners / users / SMEs, business analysts and data analysts to gather and document business requirements for several types of reports.

Create Dashboard Applications, launch pages, and reports in the WebFOCUS Managed Reporting Environment.

Created various report layouts (Simple, grouped lists, Mailing Labels, Cross tab and parameter driven) with templates, this would present complex data summary report.

Create advanced level summary graphs with drilldowns to extensive detail reports, available in

EXCEL, HTML or PDF format.

Created Complex Compound PDF reports with Drill through Functionality and Created Coordinated Compound PDF reports.

Developed custom formatting options such as PDF output containing multiple page breaks, headings, and sub-headings with subtotals

Developed complex WebFOCUS style sheets to accommodate the report format requirements.

Worked with Developer Studio Advanced Graphics Tool to create graphs and to enhance report aesthetics, including drilldowns from graphs to details.

Used HTML Layout Painter, Report Painter, and Compound Layout Painter to develop the dashboard.

Developed complex HTML Launch page, HTML pages, with multiple dynamic dropdowns and list boxes using HTML composer.

Developed dashboards in Developer Studio, added the dashboards to enterprise BI portal and provided access to business users based on client's requirements.

Formulation of Joins, Creating Match Files and HOLD Files using Developer Studio and text coding.

Used SQL Pass-through to dynamically populate the dropdown boxes.

Used Java Script to validate date fields on the launch page.

Created standard filters, calculations, Temporary Fields, Drill Downs using OLAP Analysis when slicing and Dicing the data.

Developed the code for and connected Profit and Loss reports, Balance sheet reports and Analytical Reports to the portal through which the users can run or schedule reports.

Developed reports and made changes to portals using App Studio based on business requirements.

Scheduled tasks using Report Caster for automated distribution of reports to E-mails.

Developed test cases and executed test plans for unit testing, integration testing, user acceptance testing, documentation and test progress tracking.

Environment: WebFOCUS 8.2.01/8.1.05 Report caster, HTML, Java script, DB2, SSRS, QlikView

Client: Express Scripts; Franklin Lakes, NJ Sep 2016 to Dec 2018

Role: WebFOCUS Developer

Responsibilities:

Involved in all phases of SDLC from requirement, design, development, testing, deployment and support to production environment.

Conducted business analysis workshop, collaborated with stake holders to document business requirements, data sources and business processes for the upgrade implementation.

Designed and developed processes to convert/migrate existing reports from WebFOCUS 7.7.05 to WebFOCUS 8.0.09 in this upgrade of enterprise business intelligence application based on the business requirements.

Had thorough study of the Business requirements and gathered the necessary information to start the report design.

Identified the data sources and the underlying tables and created the metadata.

Created MFD’s on the text files that are ftp’d and accessed the data of the text files into the report.

Created launch page which using resource layout painter, html and JavaScript and it is used for passing the parameters for running the report.

Used App path and App Hold commands in WebFOCUS to improve the performance of the report by creating permanent hold files.

Created self-service applications to generate reports in HTML, PDF, EXCEL, ACTIVE output formats and parameterize the reports and customize the style changes needed in various formats.

Created INCLUDE files for calling one focexec files in another focexec files.

Created Focus reports that dynamically selects Master File using Dialog Manager Commands.

Promotes best practices within business areas.

All reports involved multiple drilldown reports and custom formatting options especially in the PDF output with multiple page breaks, headings, and sub-headings with subtotals.

Interacted with the users (Analytical and Developers) and participated in knowledge transfer.

Created Browser Compatible (IE8, Firefox, Chrome and Safari) launch pages for all the reports which have dynamic drop downs and dynamic List Boxes using resource layout painter, html and JavaScript.

Designed, developed, implemented changes and supported the dashboard’s UI and KPI.

Experience working with WebFOCUS Report Caster to schedule tasks to automatically distribute reports to e-mail.

Experience working with post-production product releases.

Environment: WebFOCUS 8.0.09, SQL, JavaScript, jQuery, HTML, and CSS.

Client: Voya Financial - Windsor, CT. Feb 2015 – Aug 2016

Role: WebFOCUS Developer

Responsibilities:

Involved in all the phase of the project development, & interaction with Various Business Users to transform the Business Logic to reports.

Develop WebFocus Reports for CRS Reporting application using Developer Studio.

Designed and developed SQL data tables, procedures, and functions as part of developing business intelligence reporting systems.

Used Data Migrator tool for ETL (extract, transform, and load) procedures to load reporting database from source data.

Created Reporting procedures for populating database driven Dropdown boxes.

Worked with SQL to interact with database.

Used BI Dashboards for launching MRE Reports.

Used JavaScript & Style sheet for formatting the report.

Transform Data into various Line Graphs to analysis the business requirement.

Created applications for Business Intelligence Enterprise reporting using; FOCUS, SQL, JavaScript, JQuery, CSS and HTML languages.

Created launch pages for all the reports which have chained dynamic drop downs and List Boxes using resource layout painter, html and JavaScript.

Create advanced level summary graphs with drilldowns to extensive detail reports, available in

EXCEL, HTML or PDF format.

Developed parameter driven WebFOCUS reports, charts, and graphs.

Created Reporting Objects, Metadata, Stored Procedures and Database Objects for Enterprise reporting.

Created WebFOCUS dashboards showing key metrics in tabular and graphical formats with drilldown to successive levels of detail

Designed Ad-hoc reports and queries according to client requests.

Interacted with Business owners and data team for requirement gathering.

Utilized Dialogue Manager commands in Complex Reporting Applications.

Used Report Caster to schedule reports.

Environment: WebFOCUS version 7.7.06, 7.7.03 (MRE, Developer Studio, Info Assist, HTML Painter, Report Caster), SQL Server, DB2, Oracle, PL/SQL, CSS Web FOCUS, ACCESS, JavaScript, XML, HTML, Windows

Contact this candidate