SUMMARY

• Delivered Business Intelligence and Provided Webfocus consulting services for over 8 years for various industries.
• Have Exposure to Webfocus 8.
• Good working knowledge of BID (Dashboard) WebFOCUS - MRE, Developer Studio, Report Assistant, Report Library, Report Painter, Graph Assistant, Report Caster and Graph Editor.
• Experience in Designing/Developing HTML pages, Developing Canned/Ad-hoc Reports, Scheduling archiving and bursting the reports using report caster.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of reports generated in WebFOCUS.
• Expert in both of hand coding complex reporting logic & in Implementation, usage & user of various WebFOCUS - Graphical tools & Technologies available.
• Extensive experience in building various reporting & querying applications, including techniques like Co-ordinate/ Compound report layouts, Self Service applications, Parameterized Reports, Advanced Querying or complex but user friendly HTML Launch page interfaces, using complementary web technologies like HTML, JavaScript.
• Interact business partners, technical architects in requirements gathering, reviews, Design, Development, Testing and UAT.
• Experience in developing using Oracle 10g/9i/8i, Reports, SQL * Loader, SQL, PL/SQL, SQL Server, DB2, MS Access and have good experience on OLAP and OLTP databases.
• Designed and developed Various Reports by accessing various databases such as Oracle, DB2, SQL Server and MS Access.
• Expertise in creating complex launch pages, with chained dynamic drop downs and List Boxes using resource layout painter, html and JavaScript.
• Have experience in MRE administration and server administration.
• Excellent Verbal and Written Communication Skills have proven to be highly effective in interfacing across business and technical groups.
• Strong knowledge of Data Warehousing Concepts, Multidimensional Modeling and OLAP.

TECHNICAL SKILLS

Business Intelligence: WEBFOCUS 5.2.4/7.1.4/7.6.5 (MRE, Developer Studio), Dashboards, Report Caster, MRE, Graph Assistant, PDF composure, SAS (Statistical Analysis System), Microstrategy 9.0

Data Warehousing: Informatica 7.x, Datastage, SSIS

Databases: Oracle 10g/9i/8i/7.x, SQL Server2005, Teradata, DB2, MS Access 7.0

Programming: SQL, Transact SQL, PL/SQL, C, Java, UNIX Shell Scripts, VBScript, .Net, JavaScript, JSP, ASP, HTML 4.0, DHTML

Packages: Microsoft Project, MS-Word, MS-Excel and MS-PowerPoint

OS: Unix, Windows NT/2000/95/98/XP/vista

PROFESSIONAL EXPERIENCE

Confidential, Sacramento, CA

Senior Webfocus Consultant

Responsibilities:

• Converted 45 SQL reports to WebFOCUS reports.
• Created Level and Parent-Child based Master Files and extracted data from hierarchical Cube structures.
• Formulation of joins, Creating Match Files, Creating Hold Files using Text Editor.
• Created Focus reports that dynamically selects Master File using Dialog Manager Commands.
• Created Customized reports based on the requirements, which include Column Formatting, Styling, Total and Mailing Labels.
• Created permanent hold files to improve the performance of the reports.
• Used WebFOCUS efficiency techniques to leverage RDBMS processing,
• Utilized Dialogue Manager commands in Complex Reporting Applications.
• Utilized Report Caster to schedule and distribute the developed reports to Report Library.
• Created Stored SQL procedures in developing Complex reports.
• Used in lines style sheets and external style sheets (CSS) for WebFocus Reports.
• Responsible for retesting and regression of the application.
• Assisted in Architecture implementation of WebFOCUS & In Design & development of Reporting environment.
• Involved in configuring Data Adaptors.

Environment: WebFOCUS 7.7.02, Developer Studio, DB2, SQL Server 2005, Ultra Edit

Confidential, Mutual, WI

Sr. Webfocus Developer

Responsibilities:

• Worked on upgrading to 7.6.11 and testing the Self Service Applications, Report Caster and Focus Databases
• Created Data Check Procedures to compare the data from FOCUS data source to the SYBASE data.
• Responsible for the performance Tuning and optimization of backend procedures to reduce complexity and the Run Time.
• Responsible for Adding Enhancements to the Load procedure that update existing FOCUS Databases
• Added Enhancements to the Existing Procedures to In corporate new features according to the design Specifications and existing MACROS
• Created new procedures and applications maintained, as per design specifications and functional requirements.
• Formulation of joins, Creating Match Files, Creating Hold Files using Developer Studio 7.6.11 (Using Text Editor).
• Created Focus reports that dynamically selects Master File using Dialog Manager Commands.
• Created Customized reports based on the requirements, which include Column Formatting, Styling, Total and Mailing Labels.
• Created a web focus dashboard where filters can be applied to these reports by the Users.
• Enabled Layer security on the reports so that users can only view the information in their territory.
• Created Focus Procedures for Dynamic Dropdowns and submitted them to Report Caster for Monthly run.
• Created reports, Applied Google Map Longitude and latitude information to the report and layered them into the Web Focus Google Map Tools.
• Developed Report launch pages using HTML/DHTML, JavaScript.
• Created compound reports in HTML and PDF for displaying the data coming from more different reports.
• Responsible for maintenance of existing reports. Also worked on Production Support of System.
• Created project documentation and user manual in HTML format with screen-shots.
• Developed Test Cases from System requirements specification and Functional requirement documents
• Participated in GUI and User Acceptance Testing.
• Responsible for retesting and regression of the application.

Environment: Developer Studio 7.6.11/7.6.2 , Report Caster, Reporting Objects, Resource Layout, CSS, Self-Service Applications, BI Dashboard, Java Script, HTML, PL/SQL, Sybase, and Windows.

Confidential, TX

Sr. Webfocus Developer

Responsibilities:

• Involved in interaction with IT, business users and Source System SME’s to understand and gather business requirements, created functional and technical specifications accordingly.
• Designed FOCUS databases for various applications, created corresponding Master files and applied security to the master file to restrict usage.
• Created and scheduled a procedure to process tab delimited files supplied by SAP, extract relevant data and load it into a FOCUS Database.
• Used ReportCaster to schedule a daily job to extract relevant data from Powervision, JD Edwards, Maximo Interface tables and load it into a focus database to improve the performance of various reports.
• Provided Maintenance tools for the business users to manage output generated by the corresponding application.
• Extensively used HTML, JavaScript, AJAX and CSS, to create dynamic Launch pages with custom built Chained parameter selection and contextual menu options.
• Conducted Usability testing sessions with the end users and fine-tuned the applications to make them more intuitive.
• Created a logging mechanism for all the self-service applications to monitor usage and create an Audit trail.
• Designed and created an Incident management system to monitor the entire Server, ReportCaster logs, Data loads and Self Service applications. Also created a corresponding dashboard to provide a snapshot of all the activity and possible issues.
• Created a Data quality Dashboard and accompanying database to analyze the quality of data entered into the system and notify district operators accordingly.
• Used XSLT to transform the generic XML file generated by Webfocus to a custom XML output as defined by the Schema.
• Responsible for creating Excel template and the accompanying Macros according to the requirements specified by the user.
• Participated in converting mainframe FOCUS procedures to self-service web applications and decommissioning and archiving legacy applications.
• Responsible for the performance Tuning and optimization of existing procedures and drastically reduced the run time.
• Prepared Test scenarios and check list documents for testing the Data loads and web applications.
• Responsible for Performance and Regression testing the applications

Environment: Developer Studio 7.6.11/7.6.8 , AS400 / AIX, MRE 7.6.8, Report Caster, Self-Service Applications, BI Dashboard, Java Script, HTML, CSS, XSLT, XML, JD Edwards, Powervision, Maximo, SQL Server 2008, Excel VBA

Confidential, Columbus, OH

Webfocus Developer

Responsibilities:

• Create and Modify standard filters, calculations, Temporary Fields, Drill Downs using OLAP Analysis when slicing and Dicing the data.
• Created various report layouts (Simple, Grouped lists, Mailing Labels, Cross tab and parameter driven) with templates, this would present complex data summary report.
• Created several applications (Cascading, Pick list, drill down and Type-In) for effective filtering to finer details using Business Intelligence dash boards.
• Created drill through reports for providing better functionality, ad-hoc analysis of the data using OLAP Interface and Drill down on Measures.
• Implemented Exception highlighting for clarity and quick understanding.
• Generated weekly / monthly and ad-hoc reports using WebFOCUS Developer Studio 5.2.4
• Created multiple cubes for streamlining and easy access.
• Created templates for standard reports and extensively used features including, Ranking and sorting the data, formatting labels and display.
• Created and Published EWR Reports on WEB using HTML and JAVA Script.
• Customize Reports and URLs.
• Generate HTML and EXCEL reports and written code to view HTML reports in EXCEL format using WebFOCUS MRE.
• Modified SQL Stored Procedures and ran the jobs for report applications using Report Caster.

Environment: WEBFOCUS MRE 7.1.4/5.3.4/5.2.4 , Developer Studio 7.1.4/5.3.4/5.2.4 , Report Caster, Reporting Objects, OLAP, mainframe, BI Dashboard, Ms Access, Visual Basic and SQL Server, Access Manager.

Confidential, Lincoln, NE

Webfocus Developer

Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Designed and developed the Master Data Report tool for the users to build their own reports with multiple options to choose.
• Supported the Network Administrator in installation and configuration of Developer Studio7.6.5 and the Report Server on Windows XP and AIX respectively.
• Configured the iWay adapter for Oracle data source for creating MFD’s and accessing the tables for reporting.
• Configured the Report Caster, LAN drive and InfoPAC for report distribution, versioning and purging, used the SFTP option in Report Caster for moving the reports from OOD servers to UNIFI servers
• Administered the FID domain in maintaining the FID Security based on the roles of Users
• Configured Ereports portal to access the self service reports on role based security
• Provided Technical along with the demos on the latest FLEX Enable and Active Dashboards a knowledge transfer for other Developers at the client site
• Developed the front end screens for the reports using HTML, JAVASCRIPT which provides the users with various selection criteria, sort options, filters
• Created interactive KPI’s in the form of Pie charts, line graphs and Bar charts using Advanced Graph Assistant for visual inspection of the data
• Used PDF Layout Painter in creating compound reports with multiple graphs and grid reports accessing data from different sources
• Migration of Reports developed in Crystal Reports into WebFOCUS for the GEAC systems
• Migration of Extracts developed in Information Extract into WebFOCUS for the IVIS systems
• Build database queries and test cases for the testing team to test the reports
• Created Bank-Rec Extracts as comma delimited files which are used to feed into Mainframe
• Developed reports like Income statements, Balance sheets, General Ledger, etc.
• Worked with the DBA’s to create indexes, optimize SQL PASSTHRU queries and alter joins
• Created self-service applications to generate reports in HTML, PDF, EXCEL, ACTIVE output formats and parameterize the reports and customize the style sheets for various formats

Environment: Web Focus 5.2.3, Developer Studio 5.2.3, and HTML Resource layout, Report Library, HTML, JAVASCRIPT, Windows XP Pro, AIX and Oracle 10g

Confidential, Dallas, TX

Webfocus Developer

Responsibilities:

• Interacted with business analysts and Developers to gather the requirements for creating reports for generating Comparison Graphs reports.
• Used JavaScript and Cascade style sheets for Developing Front End Pages especially during Self- Service Applications.
• Created Drill down Reports using Focus code and Dialogue manager commands.
• Populated Multi Select List boxes with Focexec Driven Procedures.
• Involved in logical division of reports into modules based on their business functionality
• Created Business Detailed reports and Ad-hoc reports using Query Studio
• Developed Standard Reports and Templates, List Reports, Cross-tab Reports, Charts, multiple levels of Drill through Reports and Master Detail Reports by using Report Studio
• Used SQL PASSTHRU queries for complex reports to provide better performance
• Prepared the test cases for functional and data validation, performed Unit Testing and system integration testing.
• Worked with the View Builder in designing the Dashboard layout and provided Domain trees, Role trees in maintaining the various levels of the domains and user roles.
• Imported the metadata from Mainframe systems to WebFOCUS and created focus files and updated data in the tables using MODIFY.
• Developed table driven dynamic drop down boxes for the reports.
• Developed reports with mouse-over to enable users understand the functionality, criteria and assumptions of the report.
• Developed self-service applications for the Accounting and financial statements and also used HTML and JAVA Script.
• Performed Load Test on Generating Graph’s by observing Server performance and improved efficient method in generating Report.
• Used Compound Reports for embedding Graphs, which are stored in GIF format in PDF.
• Used Style Sheet for aligning reports and Positioned Graphs in Different Graphs in PDF for Comparison of 2 different Graphs generated with different Parameters.

Environment: Web Focus 4.3/5.2.3, Developer Studio 5.2.3, Resource Layout, Self-Service Applications