Data Architect

Ravinder K Arra

PROFESSIONAL SUMMARY

Over ** years of IT Experience in Enterprise Class Structure Design, software Development life cycle (SDLC) best practices, Development of Applications using Pega PRPC, JAVA, Oracle, Oracle Forms and UNIX. 8 years’ experience in BPM and Case Management Concepts. Experience with complete life cycle of Pega rules configuration, customization and deployment.

Experience in Application Setup, Data Modelling, SLAs, Correspondence, reporting generation, installing, upgrading and securing the application systems, PEGA integration services using REST, OpenText, Email, Geospatial, LDAP and external databases. Extensively used Connectors.

Experience in migrating the legacy data into pega application and dynamically creating the cases in appropriate stages. Moving data to PEGA and other integrated systems. Designed and implemented Decision Rules, Declarative Rules and Validation Rules

Experience in Pega Government Platform, PEGA Customer Frameworks, Mobile Development and deployment. Database design, tuning the applications for performance issues, problem solving and integrating with other application systems. Experience in configuring the BIX, creating the reports in enterprise reporting tools such as Jasper Soft Reporting and Customizing OOTB Reports.

Written Custom java script to support offline mobile application requirements.

Experience in programming using Java, JDBC, JNDI, XML, XSL, XSLT, SAX, DOM, SOAP, ANT.

Experience in troubleshooting and performance tuning of PRPC applications using Rules Inspector, Clipboard, Tracer, PAL, PLA, Log Analyzer & DB Tracer etc.

Experience in technical project dimensions solving complex business requirements. Develops and demonstrates an advanced knowledge of the PRPC Architecture and all PRPC design and implementation features.

Experience in working in AGILE based development environment and participating in Scrum sessions. PROFESSIONAL EXPERIENCE

Project Summary

As a Lead System Architect handled design/development of the following Projects/Frameworks at SFWMD Sfwmd.gov(South Florida Water Management District, West Palm Beach FL)

Right of Way Permitting Application.

Upgrade from PEGA 7.2.1 to PEGA 8.2.4 and PGP7.2.1 to PGP8.2.4

AVATAR (Mobile)

BIX Reporting.

ERP [Environmental Resource Permit Compliance Application]

Migrate the Legacy Data from Oracle/Forms to New PEGA Application to create the cases dynamically and keeping the right stage/step.

AVATAR (Agency Vegetation Action Tracking and Reporting)

Pega Government Plat Form customization of person/business/association to fit the district requirements.

ERP [Environmental Resource Permit Application]

South Florida Water Management District October 2019 to Present Lead System Architect, Right of Way Permitting Application. West Palm Beach, FL A ROW permit is a revocable license granted to a permittee to occupy or utilize a District right of way (regardless of whether the right of way is fee-owned or an easement). With exception of ROW Permits issued to governmental agencies and utility providers, the District can revoke a ROW Permit at any time, for any reason.

Created the ROW application built on Permitting Framework

Created the case types such as Application, Permit, RAI and refund.

Created the data model, flows, flow actions and sections

Configured the Edit validate and validation rules.

Created lookup data types and reusable data pages.

Configured the Service Level Agreement rules.

561-***-**** *******@*****.***

Created the correspondence rules for during approval/Reject to send letters to appropriate parties. Created the work group, workbasket, access groups and access roles.

Configured the rest service to automate the payment processing with payment gateway.

Created the dashboard widgets to display summary information.

Troubleshoot the issues of application using PRPC tools like Rules Inspector, Clipboard, and Tracer.

Integrated with Geospatial web application to draw permit boundary.

Integrated with Geospatial Rest service to get the boundary information to display on section.

Integrated with CMIS rest service to store the documents in EMC documentum content storage system.

Imported the person/business/association/search/update case types to application layer and customized according to the business needs.

Integrated with Mule Rest service to update the meta data of the documents.

Involved in user meetings with requirements fine tuning.

Created the correspondence rules, data transforms rules and paragraph rules required for the letters.

Involved in Daily Sprint Standup meetings to update the status of assigned stories. South Florida Water Management District September 2019 – December 2019 Lead System Architect, Upgrade Applications from PEGA 7.2.1 to PEGA 8.2.4 West Palm Beach, FL As the part of this project we are Upgraded the PRPC and applications from pega 7.2.1/pega7.4 to pega8.2.4 and PGP Framework from PGP7.2 to PGP8.2.4.

Prepared the detailed steps of the document to upgrade the PRPC version from pega7.2.1 to pega 8.2.4 and Upgraded the PGP 7.2 to PGP 8.2.4

Upgraded the dev/test/prod and fixed the issue rules related to pega8.2.4 and PGP 8.2

Modified the district specific overridden final rules to reflect the pega 8.2 changes

Modified the Changes related to JBOSS to tomcat.

Modified the agency Framework application rules related to PGP8.2 South Florida Water Management District January 2019 – September 2019 Lead System Architect, (Agency Vegetation Action Tracking and Reporting) West Palm Beach, FL This application process flow involves the creation of the work plan goes through the approval based on the resources involved, once approved next step it schedules the plan and initiates the work order, technicians on the fields access this mobile app and submitting their daily activity log in order to bill their work and get invoices. Designed the Enterprise class structure, cases, stages, process and views.

Created the screen flows.

Due to complex application lot of parameterize data pages was used in order to work this feature in mobile we need to create parameterize data pages using the java script API.

White listed the file value, Data Transform an and data pages wherever it is required.

Configured the build server URL and our app is mainly on apple IPAD so iPhone so downloaded the certification from apple developer site and configured.

Successfully build the mobile app and tested the features with online and offline.

Some sections we converted to table grid to repeat dynamic layout in order to work better on mobile.

Configured security to integrate with LDAP to connect to OID oracle internet directory to authenticate the user accounts.

Integrated with GIS app to draw the boundary of the work done. The Geospatial service has the features of offline support, once connected to the app calling the other GIS rest connector to get the boundary related information display on the section.

South Florida Water Management District October 2018 – January 2019 Lead System Architect, BIX (Business Intelligence Exchange) Reporting West Palm Beach, FL The ERP Environmental Resource Permit application has reporting specific requirements to track the net processing days in order the issue the permits in DEP defined no of days, the calculations to calculate the NPD is complex and other complex reports that are required to satisfy the complex requirements.

Configured the BIX tool by working with middleware resource

Configured Extract rule to map the all the cases properties in the same way as work object relationships.

Run the rules one time to get the script and run on the sql server to generate the physical tables.

Added the appropriate indexes and keys on the tables.

Configured the Agent Rule to run the extract rules periodically

Added the sql procedure to remove the duplicates and invoked the same in the agent activity to run right after the extract is done.

Created the complex reports in Jasper and integrated into pega invoke the report from pega.

Hand over to junior team members to for the further enhancement and other reports development. South Florida Water Management District January 2017 – September 2018 Lead System Architect, ERP Compliance/Enforcement Permitting Application West Palm Beach, FL The ERP Environmental Resource Permit compliance application is redesigned pega permitting portal to handle the ERP issued permits, Compliance, enforcement, public enquiry and submittal processing.

Created the cases such inspection, schedule, letter case, public enquiry and enforcement.

Defined the sections, data transforms, activities, decision rules, flows, flow actions and views

Modified the calendar control to show the scheduled inspections.

Tracking the Engineering/Environmental/Property related post permit compliance actions.

Configured the letter process to send the letters to customer to remind the unsatisfied compliance actions, violation letters and modified conditions.

Integrated with geospatial application to draw the boundary.

Integrated with ECM Open Text to store the documents in the file storage system

Build the rest services to update the meta data of the documents.

Created the migration rules to migrate the existing data to pega built application South Florida Water Management District April 2016 – December 2016 Lead System Architect, Migrating the Legacy Data into ERP Permitting Application West Palm Beach, FL The ERP Environmental Resource Permit application is redesigned pega permitting portal built on PGP which is built on PRPC to replace the oracle forms/Java application, all the new permits was created on new permitting portal but we need to migrate the existing data to new built pega Permitting portal.

Created the oracle views to map the properties on the pega data model

Created the migration specific flows, decision rules, data transforms and activities.

Created the integration classes using database mapping wizard to map the Oracle views

Created data migration specific starting flows

Two main cases application and Permit cases and 11child cases crated as part of this process

Created the re-usable case types, Data transforms and activities. South Florida Water Management District January 2016 – April 2016 Lead System Architect, (Agency Vegetation Action Tracking and Reporting) West Palm Beach, FL This application process flow involves the creation of the work plan goes through the approval based on the resources involved, once approved Next step it schedules the plan and initiates the work order to verify the work an inspection is conducted during or upon completion of work.

Created the screen flows, created the data transform to eliminate the duplicates on list items.

Configured the Edit validate and validation rules. Configured the Service Level Agreement rules.

Created the work group, workbasket and modified the flow to assign to workbasket, Created the declarative rules.

Created the Plan Search case, section, data page and report definition rules.

Created the when rules conditionally hide the sections if the property value meets the criteria.

Created the data page, imported the reference data.

Modified the Dashboard report to the user requested properties.

Unit testing of the own stories and verify for the other developer stories.

Troubleshooting the issues of application using PRPC tools like Rules Inspector, Clipboard, and Tracer. Involved in user meetings with requirements fine tuning.

Created the correspondence rules, data transforms rules and paragraph required for the letters.

Involved in Daily Sprint Standup meetings to update the status of assigned stories. South Florida Water Management District January 2013 – December 2015 Lead System Architect, ERP Permitting Application West Palm Beach, FL An Environmental Resource Permit (ERP) will be required for new projects or changes to existing projects that impact wetlands, surface waters or floodplains. Some activities are exempt from environmental resource permits. Customer submits the application for permit once is review complete either they issue permit or deny permit.

Involved in analysis, design and development of Class structure, Access Group, Process Flows, Activities UI and Integration.

Designed and implemented User Interfaces using Sections, Harness and Portals.

Defined PRPC components like Decision tables, Declare Onchange and Declare Trigger etc.

Involved in testing and troubleshooting the issues of application using PRPC tools like Rules Inspector, Clipboard, and Tracer

Created Activities, steps and methods and calling other activities for implementing core business logic.

Created Connect-SQL rules for querying the external database

Troubleshoot and communicate with PEGA Support team in order to resolve technical issues which require hot fix from PEGA systems.

Creating the 55 letters and attaching to case most of the letters are in PDF format.

Created the Permit Document consisting of most of the permit information collected and reviewer applied business conditions.

Integrating with Geospatial, MULE ESB, Documentum file storage. South Florida Water Management District September 2005 – December 2012 Lead System Architect, West Palm Beach, FL

Applications Support, Identity Management Project, Job Builder Access Application support and Enhancements.

Legacy Code, C, C++, Pro*C and Pro* Fortran Programs upgraded from oracle 8i to 11g database libraries.

MOSCAD/ACE Project, Flow Project, DAS project search utility.

Forms migration from 6i to 10g to 11g, Linux to Solaris Upgrade Project.

Discharge Monitoring Report (DMR) and Pesticide Report Enhancements VBA code.

NRTRinge Project. [nexrad rainfall data accumulations 15, end of day and monthly basin/pixel wise] Los Angeles Unified School District

September 2004 – September 2005

Senior Consultant West Palm Beach, FL

LAUSD required a Decision Support System (DSS) that would analyze student, teacher performance from various perspectives such as school, time, student program, school category, grade, gender, ethnicity, language classification, home language, poverty indicator. System has 700 detail reports to display all the required information, over 700,000 students with more than 35,000 teachers.

Responsible for the developing Oracle Reports9i, Identifying Extract Transform Load design issues. Developed more than 700 reports, Created the Single Plan document template. Solved the integration issues with the portal

Tracing report errors and up to database level and if found data issues; assign to ETL team

Modifying the report server configuration changes on IAS

Tuning the SQL Queries & reports formatting process, Resolving issues on time. Thomson Financials January 2004 – September 2004

Senior Consultant Rockville - MD

The Purpose of this Project is to convert the Wachovia Bank Securities data to the Thomson one advisor Data base from SQL server to Oracle database.

Responsible for any design changes of the E-R Diagram, converting existing WSI Envision data to Thomson One Advisor Data Model Configured Heterogeneous Data Services to access SQL Server data from Oracle, Extraction, Transformation and Loading data into Staging Tables. Responsible for developing PL/SQL / SQL Scripts using appropriate improved performance features Merge, for all, case end case, and bulk bind.

Wrote the PL/SQL scripts for data conversion of the following modules (For fa households, prospects, internal accounts, external accounts, branch views Plans and asset allocation modules) Used the SQL *loader to load all configuration data from flat files to oracle tables. Wrote Technical Design Documents explaining the architecture and identified functional gaps between the applications and data mapping.

A&E Television Networks January 2003 – January 2004 Onsite Team Lead Stamford - CT

The Purpose of this Project is to develop the Inventory Reports from Wholesale and Consumer Data from existing smart store database.

Responsible for developing PL/SQL Functions and Procedures for the system, Migrating Data from Advantage to Smart Store using Shell Scripts, Pro*C and PLSQL.

Developing Inventory Reports for Consumer Data. Modifications to the Existing Wholesale Reports. Developed around 40 Reports (some of custom folders containing complex queries and stored functions to satisfy the company complex Los Angeles, CA

business rules.). Developed various kinds of reports like (Page item layout, crosstab layout and table layout). Developed the Smart – Store Data base Entity Relationship Diagram and generated the Table Data Structure, Indexes and Constraints Scripts Using Designer6i.

Dua Computer Resources Inc. December 2000 – December 2002 Consultant Offshore

Sales Quantum (client Licensing Ventures Inc)

Works of districts Permitting (client SFWMD)

Water Use Permitting (client SFWMD)

Citicorp Information Technologies & Industries Pvt. Ltd. February 1999 – November 2000

Associate Consultant Offshore

Security management system,

Term deposit,

Application processing system and

Transaction processing.

The overall concept of the project is how the banking is done on the web. The Customer can access is account from one branch to another branch. Customer can use this facility anywhere, anytime, interacting with the host database as well as branch databases.

Building the business components in c and VB and Front-end ASP, HTML, Java Script. CERTIFICATIONS & SKILLS

Certifications:

Certified System Architect V7.1

Certified Senior System Architect V7.2

Certified PEGA Decisioning Consultant V7.2

Certified CLSA-R/CLSA-A Pending the AppBuild to get CLSA v7.4

Certified Scrum Master (CSM)

Certified Oracle SQL/ PL/SQL from BrainBench and Oracle.

Pega certification verification link:

(https://academy.pega.com/verify-certification?fname=Ravinder&lname=Arra) Skills:

OS: SUN Solaris, UNIX, Linux, Windows2007/2010

BPM Tools: PEGA (PRPC) V7.x, V8.x

Middleware: WebLogic, WebSphere, Tomcat, JBOSS

Languages: JAVA, C, C++, PRO*C, SQL, PL/SQL

ESB & Web: Mule, HTML, XML, CSS, JSON, JavaScript & jQuery Server-Side Servlets, JSP

RDBMS: Oracle 8i/9/10g/12c, MS SQL Server, MS Access Tools: TOAD for Oracle, Version one (Sprint tracking), Microsoft Management Studio, Any point Studio, Jasper Studio. Framework: PEGA Government Platform 7.x/8.x, Pega Customer Service7. x. EDUCATION

Osmania University 1997

Master of Computer Applications Hyderabad-INDIA

Contact this candidate