We provide IT Staff Augmentation Services!

Sr. Programmer Analyst Resume

5.00/5 (Submit Your Rating)

Dearborn, MI

PROFESSIONAL SUMMARY:

  • 9+ years of IT Experience, includes Pega PRPC BPM tool, Java/J2EE, Oracle, Microsoft Sql Server, DB2 and related technologies in Healthcare, Logistic and Automobile industries
  • Around 3 years of PRPC (PegaRULES Process Commander) experience as design developer and PRPC work flow experience as a System Architect
  • Experience in trouble shooting the issues encountered in migration of Application from PRPC v6.2 SP2 to PRPC v7.1
  • Carry out Application Deployment and perform application migration in PRPC v7.1
  • Expertise in PEGA Implementation cycle includes modeling of Business Process, Analysis,
  • Designing, Development, Deployment, Integration and Testing the BRE and BPM Applications
  • Extensive knowledge in Design, Development, Migration and Deployment of PRPC (PegaRULES
  • Process Commander) and Java/J2EE based applications
  • Knowledge on PEGA applications that use CPM framework (Customer Process Management)
  • Interacted with the end users, Business Analysts for understanding the Business requirements
  • Extensively used UML - System Use case Diagrams, Activity Diagrams, Sequence Diagrams,
  • Deployment Diagrams and Class Diagrams
  • Expertise in PRPC flows, interpretation of Flow shapes, and interpretation of complex flow shapes for business scenarios, Activities, Class structure design, Decision and Declarative rules
  • Involved in design and development of Data Model, Class structure, Access Groups, Process flows,
  • Activities and UI properties
  • Expertise in developing User Interfaces, Screen Layouts using JSP’s and HTML
  • Worked on Debugging and Bug fixing Activities using Rules Inspector with Lead and System
  • Architects for Harness, Declare Expressions
  • Expertise in migration of rules using export & import utilities of PEGA
  • Extensively worked on Production support resolving several issues and monitoring the Pega Alerts and Exceptions
  • Experience in data migration from legacy systems to Oracle Databases using tools like SQL, PL/SQL, SQL*Loader and Unix Scripts
  • Experience in Performance Tuning and Optimization techniques of SQL query statements using Explain Plan, Hints, SQL*Trace and Tkprof
  • Extensive knowledge of using DBMS Oracle supplied package like UTL FILE, DBMS JOBS, DBMS SCHEDULAR, DBMS STAT, DBMS PROFILER etc
  • Experience using the latest features to optimize performance like Bulk Binds, Bulk collect, Inline views, Global Temporary Tables
  • Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages
  • Extensive experience in writing Static & Dynamic (REF) Cursors, Dynamic SQL, Records, PL/SQL tables & Exception handlers
  • Experience using External Tables to read the flat file and log files into database

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/XP/NT, Vista, MS-DOS, Unix, Linux.

Languages: C, C++, JAVA, J2EE,SQL,PL/SQL

Databases: Oracle 10g, Oracle 11g, PL SQL/SQL, DB2, SQL Server 2008/2012

BPM: PegaRULES Process Commander (PRPC 5.x,6.1 and 7.1.x)

Business Intelligence: OBIEE10.X&Siebel Analytics7.7 / 7.8, BIPublisher

Reporting Tools: Actuate 8/7.2/6,, eReport Designer Professional, eSpreadSheet, Business Objects XI, Cognos ReportNet 1.1, Crystal Reports 11

Java Technologies: Applets, JDBC, EJB, Java Beans, Servlets, JSP, Custom tags, Tag Libs.

Web Technologies: JSF, Struts, Ajax, HTML, DHTML, CSS, XML, JavaScript

PRPC Skill Set: SOAP Services, SQL and SOAP Connectors, Activities & Flow, Decision & Declare rules, Class Design, Security, Interfaces, CPM,CPMHC frameworks

Tools: Rational Rose, Visio 5, Explain Plan Analysis, Informatica 7.1.2/8.1.1 Power Center, SQL Navigator 3 / 4.1, TOAD, SQL Worksheet 1.6.0, Infra and SQL Query Analyzer 8, Rally, AccuRev, RSA

Version Control: Visual SourceSafe, SVN and CVS, Version one

PROFESSIONAL EXPERIENCE:

Confidential, Dearborn, MI

Sr. Programmer Analyst

Responsibilities:

  • Designed Business Rules to implement expansion and performance improvement using Pega PRPC
  • Worked with business line designees and lead system development resources to improve processing efficiency through systems and business process improvements
  • Participated in the design and development of Warranty Framework
  • Working with the Business users, Business Leads, and Business Analysts to define business requirements for designing, testing, and building Pega systems solutions to meet those requirements
  • Expertise in troubleshooting the production issues and monitoring the performance
  • Involved in the implementation of AES monitoring tool for production monitoring
  • Participated in development of Technical Requirements to provide end state requirements for line of business and development team
  • Created HTML rules, Properties (Data types), Embedded Pages and Correspondences
  • Participated extensively in designing application security which involved setting up Access groups, Access Roles, Operators, Application ID, Org Divisions, Org Units and Work groups
  • Developed and designed class structure, workflows as well as integration between systems for smooth and optimized operation of systems
  • Designed High Level Class structure, Workflows and Rule sets in Pega PRPC
  • Worked on class structure on top of the Warranty Framework
  • Coordinate with Off-Shore Team and provide the Off-Time support
  • Performed testing and Bug Fixing Activities

Environment: PRPC 6.2 SP2/ 7.1.9, PEGA PLA 2.0, Microsoft Sql Server Management Studio 2008/2012, DB2, IBM Web-Sphere Application Server, Java Script, SQL Developer, IE8/IE11.

Confidential, Virginia Beach, VA

Sr. Programmer Analyst

Responsibilities:

  • Implemented CPM framework in the Application, to make it more interactive.
  • Worked on CA (Customer Action) work interaction driver for interacting CPM framework with PRPC applications.
  • Created High Level Class structure, Workflows that facilitates the main business process.
  • Developed User Portals for the interaction with consumers
  • Involved in customizing the Data-Gadgets on the User Portals.
  • Created the Search reports using List Views and Summary Views for handling consumer protection plans and the products.
  • Involved in the production support which includes troubleshooting of the application issues, Agent Monitoring, Performance issues.
  • Made extensive use of SOAP services where in services were provided to Java interfaces
  • Involved in writing Test cases for QA analysts in testing the application in different scenarios.
  • Involved in Unit Testing of the application and debugging the application using Tracer.
  • Used Rational Rose and UML (OOAD) to design Use Case, Class, Activity, and Sequence diagrams for Functional Design documents
  • Created Decision Rules like When condition Rules, Decision Tree Rules, Decision Table Rules and Map Value Rules and Declarative Expressions as per the requirements.
  • Developed Harness, Flow actions, Sections based on the business requirements
  • Created Consumer Level and Claim Level Validations to smooth process with the migrated data
  • Created Outbound Email Correspondences to notify the backend team.
  • Created Decision Rules like When condition Rules, Decision Tree Rules, Decision Table Rules and Map Value Rules and Declarative Expressions as per the requirements.
  • Made extensive use of SOAP services where in services were provided to Java interfaces
  • Involved in writing Test cases for QA analysts in testing the application in different scenarios.
  • Involved in Unit Testing of the application and debugging the application using Tracer.

Environment: Pega Rules Process Commander 5.4,5.5, CPM 5.2,MS Visio 2005, HTML, XML, SOAP, Java, Microsoft Sql Server Management Studio 2008, Oracle SMART, Tomcat, CSS, Java Script, HTM

Confidential, Greensboro, NC

Programmer Analyst

Responsibilities:

  • Involved in tables design with team members and DBAs and load the files from other sources
  • Involved in QC and System Integration Testing
  • Developed /modified existing Oracle objects procedures, functions, triggers, cursors and packages
  • Used functions, procedures for staging, transformation and loading of the data into base tables
  • Extensively uses external tables to load the exported files from other different
  • Assisted in reviewing data transformation rules and provide technical suggestions in data transformation logic
  • Assist Business users in reviewing data transformation rules and provide technical suggestions in data transformation logic
  • Conduct data validation meetings with business users after populating target database
  • Establish and maintain well written documentation related to difficulties, complexities and anomalies that may exist in the target staging database
  • Implemented CPM framework in the Application, to make it more interactive.
  • Created High Level Class structure, Workflows that facilitates the main business process.
  • Developed User Portals for the interaction with consumers
  • Involved in customizing the Data-Gadgets on the User Portals.
  • Created the Search reports using List Views and Summary Views for handling consumer protection plans and the products.
  • Involved in the production support which includes troubleshooting of the application issues, Agent Monitoring, Performance issues.
  • Developed Harness, Flow actions, Sections based on the business requirements
  • Created Consumer Level and Claim Level Validations to smooth process with the migrated data
  • Created Outbound Email Correspondences to notify the backend team.
  • Prepared UI Mockups based on client requirements using HTML and Java Scripts and converted them into web modules using JSP, Servlets, Java Scripts and HTML
  • Developed the server side components following the MVC architecture and Struts Framework
  • Developed various types of reports regarding the enquiry received, Registration received.
  • Prepared test plan development used JUnit for testing for Unit Test
  • Client side validations were done using JavaScript

Environment: Oracle 10g, Microsoft Sql Server Management Studio 2008, TOAD, PL/SQL, PL/SQL Navigator, UNIX, SQL*Loader, MS Office.

Confidential, Richmond, VA

Sr. Oracle Developer

Responsibilities:

  • Created some of Validation rules as per requirement
  • Involved with Process Architects in designing of Flows
  • Analyzed business requirements to design and implement the CPM Rule Set and Class structure and hierarchy
  • Creation of Rule-sets, Service Process and Properties using Pega CPM Service Process Accelerator
  • Creation of Class structure in Pega PRPC, HTML rules, Properties and Embedded Pages
  • Created new Custom Enterprise Portal using Harness rules for new Bankruptcy Account Opening and maintain accounts through UI
  • Defined Service Level Rules (SLAs) for bankruptcy accounts processing
  • Generated Summary Reports based on processing of bankruptcy accounts related work
  • Developed separate work flows for pending, updating and completed bankruptcy cases
  • Developed PRPC Declarative rules and Decision tables for determining the status of accounts
  • Developed several flow actions and Activities for actions like Route, Transfer, Reassign, Notify
  • Successfully deployed the Application by packaging the Flow Rules
  • Created Declarative expressions for a value change on the properties
  • Unit testing of Developed Applications and solved tickets in UAT and Production environments
  • Updating the client with weekly calls about the project status

Environment: SQL, HTML, XML, Oracle 10g, Web Logic, JAVA, Windows XP, MS Visio

Confidential, Richmond, VA

Oracle Developer

Responsibilities:

  • Used Rational Rose and UML (OOAD) to design Use Case, Class, Activity, and Sequence diagrams for Functional Design documents
  • Prepared UI Mockups based on client requirements using HTML and Java Scripts and converted them into web modules using JSP, Servlets, Java Scripts and HTML
  • Developed the server side components following the MVC architecture and Struts Framework
  • Developed various types of reports regarding the enquiry received, Registration received.
  • Prepared test plan development used JUnit for testing for Unit Test
  • Client side validations were done using JavaScript
  • Coordinated with the business users to clarify requirements
  • Involved in analysis and coding of the requirements
  • Involved in tables design with team members and DBAs
  • Extensively used UTL File to Read and Write from text Files and also utilized external tables to load the files received from other sources
  • Designed and developed Oracle Forms & Reports using Forms and Reports
  • Involved in QC and System Integration Testing
  • Developed /modified existing Oracle objects procedures, functions, triggers, cursors and packages
  • Generated DDL statements for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures
  • Used functions, procedures for staging, transformation and loading of the data into base tables
  • Extensively uses external tables to load the exported files from other different
  • Assisted in reviewing data transformation rules and provide technical suggestions in data transformation logic
  • Assist Business users in reviewing data transformation rules and provide technical suggestions in data transformation logic
  • Performed the uploading and downloading of flat files to and from UNIX server
  • Conduct data validation meetings with business users after populating target database
  • Establish and maintain well written documentation related to difficulties, complexities and anomalies that may exist in the target staging database

Environment: Oracle 10g, TOAD, PL/SQL, PL/SQL Navigator, UNIX, SQL*Loader, MS Office.

We'd love your feedback!