Professional Experience Sql Server

Professional Summary:

Around * years of total IT experience.

Extensive knowledge in Design, Development, Migration, Deployment and Integration of PRPC.

Good Exposure in Finance and Insurance Domains.

Experience in complete Pega implementation cycle, including business process modeling, tool installation, development, testing, and deployment.

Clear understanding of using Clipboard, Tracer and SMA for debugging, PAL for performance analysis and Preflight tool to check application Guardrails Compliance.

Experience on CRM/CPMHC and IAC frameworks.

Experience in designing class structure, workflows and Rule set management in Pega PRPC.

Strong knowledge in implementing various PRPC components like Decision tables, Decision Maps, Declarative expressions, Constraints, and Indexes etc.

Expertise in creating Business Rule Engine, Business Process Management Application for Pega Rules Process Commander (PRPC).

Developed High Level Class structure and Developed Workflows in Pega PRPC.

Experience in Oracle Database, Developed SQL Scripts, Stored Procedures, functions and packages.

Experience with Web Scripting Languages: XML, CSS, JavaScript and HTML.

Worked on various development environments like IBM WebSphere, BEA WebLogic, Web services, Ant Deployments, CVS and frameworks like Struts and JUnit.

Involved in all stages of software development cycle, thorough with software methodologies like RUP and Agile.

Expertise in full life cycle development of system, requirement elicitation, making Use Cases, Class Diagram, Activity Diagrams, Deployment Diagrams and Sequence Diagram, sub systems.

Professional Experience

Client: Highmark Inc., PA Apr’ 16 - Present

Role: PEGA System Architect

Responsibilities

Developed required business rules for the Pega implementation for post change.

Implementation of Decision tables, Decision Maps and Declarative expressions.

Involved in testing and Bug Fixing Activities.

Implemented complex user interfaces using Sections, Harness and HTML stream rules.

Worked on DB mapping, remote db connection, and other DB related operations.

Implemented various PRPC components like Decision tables, Decision Maps, Declarative expressions,

Constraints and Index.

Created Decision Rules and Declarative Expressions as per the requirements Worked on the UI

Components, Class Hierarchy, Declare Expressions and decision Rules.

Involved in Change Management aspects including defining and implementing procedures/technologies for Harness,

Declare Expression and When Rules.

Took part in upgrade of oracle 10g to 11g and analyzed the effect of the upgrade on application.

Environment: PRPC 7.1.9, SP1, HTML, SOAP, BRE, Java, Oracle 10g & 11g

Client: Caterpillar Inc., Nashville, TN Oct’ 14 – Apr’ 16

Role: Pega PRPC Developer

The project was to automate the Information Requirement Checklist and integrate it with the workflow. The work involved a building custom User Interface (UI). The IRC was earlier built in MS Excel to meet the requirement in a timely fashion but later on wanted to automate it and tie it to the Ratings process workflow.

Worked on making enhancements to the workflow. Followed Dodd-Frank Act is to ensure and document the information that is used in the ratings processis sufficient, timely and reliable. Also worked on the Global Analytical Documentation and Retention project.

Responsibilities

Involved creating Mandatory and Situational document specialization for the documents uploaded to Document. This specialization was done based on Practice Area, Region, Sector, Job type, etc.

Used DCO, one of the latest requirements methodologies for quickly capturing client objectives.

Implementation of Decision tables, Decision Maps and Declarative expressions.

Created Mandatory and Situational document specialization for documents uploaded to Document.

Worked on making enhancements to the workflows, followed Dodd-Frank Act to ensure and document that the information used in the ratings processes sufficient, timely and reliable. Also worked on the Global Analytical Documentation and Retention project.

Worked on DB mapping, remote DB connection, and other DB related operations.

Designed and implemented complex user interfaces using Sections, Harness and HTML stream rules.

Used BIX (Business Intelligence Exchange) to extract PEGA BPM case data and other information from multiplier systems for advance Business Intelligence and Analytics.

Involved in testing and Bug Fixing Activities.

Implemented various PRPC components like Decision tables, Decision Maps, Declarative expressions, Constraints, and Indexes etc.

Involved in bug Fixing Activities with Lead and System Architects for Harness, Declare Expressions and When Rules.

Environment: PEGA PRPC 6.3, SQL, HTML, and Oracle 10g, Web logic, UNIX, JAVA, MS Visio.

Client: MetLife Inc., New York Jan’13 – Oct’14

Role: Pega PRPC Developer

The objective of this project is to provide complete Prospects and Renewal health policies information of the company in form of ad hoc reports. This application currently generate huge amount of information that would help the organization better service its members. It includes developing Reports for Contracts, Renewals, Marketing and Underwriter Process Associates in Kaiser Permanente Applications.

Responsibilities

Worked with line of business to evolve existing production processes to comply with new government and corporate regulations.

Developed all the business rules for the PEGA implementation.

Implemented various PRPC components like Decision tables, Decision Maps, Declarative expressions, Constraints, and Indexes etc.

Involved in integrating the CPMHC with other PRPC applications.

Involved in developing UI Screens, activities, and correspondence.

Created High Level Class structure, Class Hierarchy, Workflows and technical design document.

Provided technical insight and direction on project initiatives from PEGA expertise perspective

Designed and developed the User interface for the application by creating the harness and section rules

Created Data classes and DB tables for integrating with external systems.

Developed Validation Rules and Integration rules pertained to Rule-Connect- and Rule-Service.

Implemented various PRPC components like Decision tables, Decision Maps, Declarative expressions, Constraints, and Indexes etc.

Used BIX to extract all BPM data: Work details, Assignments and Processes.

Participated in the requirements gathering and analysis with the business users.

Administration activities like creation of Access Groups, applications, operator IDs, rule set versioning and locking, taking wraps and importing on QA machines for Quality Assurance.

Created product rules and migrated zip files from development to QA, UAT & monitored Performance when regularly.

Environment: PEGA PRPC 6.1 SP2, CPMHC, CTI, SQL, HTML, XML, and Oracle 10g, Web logic, JAVA,

Bangalore Software Services Pvt. Ltd, Bangalore, India June’ 10 – Aug’ 12

Role: Java/J2EE Developer

Responsibilities

Developed Session Beans for JSP clients.

J2EE Architecture was a combination of Apache Struts implementing MVC model.

Involved in design and development of three-tier architecture.

Developed Use Case Diagrams and Class Diagrams using Rational Rose.

Developed the user interfaces using JSP embedded with JSTL based on MVC architecture.

ANT script is used to create WAR and EAR files.

Created Java Servlets and other classes deployed as EAR file, connecting to SQL server database using JDBC.

Developed the business logic using Java Beans and Session Beans.

Developed a tool to retrieve and send data to third party service provider. This feature was implemented using XML, SOAP.

Developed Event Logging & Error Reporting application using Servlets.

Built customer tag handlers and description library.

Developed view pages and Java Beans (JSP, Java Beans, HTML, SQL)

Developed system to access to legacy system database (JDBC).

Developed remote accessing to customers requirements.

Modeled EJBs and other classes using Rational Rose.

Designed data flow system, divided data flow to modules, defined function and interface.

Designed database RE diagrams tables, data constrains, triggers, stored procedures and functions (MS SQL Server, SQL).

Developed procedures and functions, user interfaces and error handles for bookkeeping and RMB transaction modules (SQL), writing user manual and training users.

Environment: JDBC, JSP, XML, Oracle 10g Schema 1.0, XSLT 1.0, XSL,Spring Framework SOA,MQ Series, JSF, Hibernate,Web Logic 6.0, Oracle 8i, J2EE(Servlets, JSP, JDBC, JDK1.2. Struts, WAS 5.0, WSAD 5.1, ANT.)

Contact this candidate