Post Job Free

Resume

Sign in

Sql Server Insurance

Location:
Posted:
August 01, 2017

Contact this candidate

Resume:

DINESH REDDY K

Email: ac1ly5@r.postjobfree.com

Mobile: +1-505-***-****

Profile Summary

Certified Lead System Architect having 8 years of IT experience into Analysis, Design & Development of Web based and BPM Applications.

7 years of experience into Designing and Implementation of complex Pega Rules Process Commander (PRPC) projects.

Analyze and define client’s business strategy and determine system architecture requirements to achieve business goals.

Gather detailed business requirements and use cases, and translate technical specifications into product requirements.

Create team strategies and establish project scopes of work; communicate project deliverable timeframes and benchmarks to clients.

Suggest architectural improvements, design and integration solutions and formulate methodologies to optimize object-oriented software and database development.

Leading the offshore team and coordinating with other project stake holders.

Ability to troubleshoot and resolve complex production issues.

Experience with Agile/Scrum Development methodology.

Experience in domains like Insurance, Capital Markets and Banking.

Excellent hands on experience in designing Application Architecture, Case Management, Data modeling, UI Development, Flows, Declarative Rules, Decisions, Activities, Agents and Reporting.

Experience in PRPC integration in Enterprise Environment using Connect-REST, Connect-SOAP, Connect-SQL, File Listener, Connect-JMS, Service-SOAP and Service-REST.

Good experience in troubleshooting & performance tuning using debugging tools such as Tracer, PAL, Clipboard, Logs, AES DB, DB Trace and System management Application (SMA).

Experience in defining DSS variables and log level settings.

Experience in creating Security levels/roles i.e. Access role to objects, privileges & access when rules.

Expertise in deployment activities using product rules and Application packaging wizard.

Experience in creating custom portals and skin rules.

Experienced in using DCO, PEGA Express wizard and good knowledge on DSM.

Expertise in writing Complex Queries, Stored Procedures, Functions and performed data analysis using Oracle, PL/SQL, SQL Server Management Studio.

Strong in OOPS Concepts and C, C++, APL and Core Java programming.

Hands on experience in .NET technologies like ASP.NET, C#.NET, ADO.NET, WCF and Win Forms.

Good Knowledge on web Application Development using J2EE technologies.

Experience in implementing CMMI Level 5 (version 1.3) process model.

Education

Bachelor in Computer Science & Engineering (BTECH) from JNTU Hyderabad, India

Technical Skills

BPM Tools

PRPC 5.5, 6.2, 6.3, 7.1 & 7.2

Frameworks

PEGA CPMi, PEGA Claims

Application Servers

IIS, IBM Web sphere, Apache Tomcat

Database

Microsoft SQL, MySQL, Oracle, IBM DB2

Programming Languages

APL, C, C++, Core Java and PL/SQL

Web Technologies

HTML5, XML, JSON, Web Services, SOAP, PHP, AJAX, CSS

Scripting Languages

JavaScript, JQuery

Microsoft Technologies

C#.NET, ASP.NET, ADO.NET, WPF, WCF

IDEs

Eclipse, Attachmate, Dyalog APL, Visual Studio, Blend, Visio

Certifications

Certified Lead System Architect (CLSA) in PRPC 7.1 from PEGA Systems.

Experience

Client: ULLICO, CIGNA Apr’17 – Till Date

Location: Des Moines, Iowa

Role: Lead Architect

VPAS claims is a claims processing workflow management system for various life insurance products for different clients.

Responsibilities:

Translated technical specifications into project scopes of work and product requirements while spearheading design and development of enterprise solutions.

As a Lead Architect, expertise in designing and implementing Enterprise class structure for the organization based on PEGA best practices and guardrails, which can be reusable and extendable.

Leading the offshore team and coordinating with other project stake holders.

Creating PRPC flow design, activities, integration connectors (connect SOAP, connect SQL), services and screen design (harness, section, flow action), Agents & SLAs. Creation of search reports using Report Definitions.

Responsible for managing administration work using SMA.

Involved in fixing the SIT and UAT Defects.

Responsible for creating rule set versions and on intervals involved in rules skimming activities.

Planning the deliverables in phases and allocating work to the team members and the coordinating with the other project stake holders.

Responsible for code and design specification reviews.

Involved in Production migration.

Guiding and mentoring the new resources in the team.

Environment: PRPC Developer studio V7.1.8, Oracle

Client: Zurich (Client Implementation) Nov’16 – Apr’17

Location: Atlanta, Georgia

Role: Technology Lead

Zurich is an US-based insurance and retirement business process solutions provider.

The CSWD (Non-Live) is a web application which enables CSR to enter new policies, and financial and Non-Financial requests of existing policies for various clients’ policy holders. This system enables managers assign, monitor the work of a CSR. And also generates various reports on the work requests on quantity and quality of work done by a CSR.

Responsibilities:

Requirement gathering from client's IT team.

Managing other vendor's offshore development team

Involved in designing the class structures and data models based on PEGA best practices

Involved in identifying stages in case & flows

Preparation of technical design document.

Rule set backup and maintenance.

Created roles and user portals

Created flows to handle Exceptions in the system.

Created roles and user portals

Presented Technical effort to business users and internal teams

Environment: PRPC Developer studio V7.1.6, MS SQL Server 2008

Client: McCamish Base product Mar’16 – Oct’16

Location: Hyderabad, India

Role: Technology Lead

McCamish is an US-based insurance and retirement business process solutions provider.

Various life insurance/retirement services providers uses McCamish Policy administration system to issue or manage their policies. This application enables CSR to enter new policies, and financial and Non-Financial requests of existing policies for various clients’ policy holders. This system enables managers assign, monitor the work of a CSR. And also generates various reports on the work requests on quantity and quality of work done by a CSR.

Responsibilities:

Studying and understanding the functional specifications/Use cases.

Responsible to develop; enhance the application for any business and Technical changes.

Created various data tables to maintain work Types, Work Statuses etc.

Prepared Access Roles and Access Groups for PRPC work flow team

Created and modified the Process flows, User Interface Rules (Harness, Section Rules) as required by the application.

Environment: PRPC Developer studio V6.2 SP2, MS SQL Server 2008. (Now upgraded to Pega V 7.1.5 and SQL server 2012.)

Client: Horace-Mann Sep’15 – Feb’16

Location: Hyderabad, India

Role: Technology Lead

Horace-Mann is an US-based life insurance and retirement business process solutions provider. This application provides an interface to the CSR to interact with the customer through phone call. This system will give managers the ability to monitor the SLA of work requests and generate the reports on the request. This system enables managers assign, monitor the work of a CSR. And also generates various reports on the work requests on quantity and quality of work done by a CSR.

Responsibilities:

Participated in Requirements, Design and Development phases.

Analysis, Design and implement the data migration process.

Develop a mechanism of data extraction from pega database to external SQL database.

Worked on creating declare index rules and activities for extraction process.

Identified and developed all the necessary rules required as per requirements.

Actively involved in fixing production related data issues.

Environment: PRPC Developer studio V6.2 SP2 (CPMi frame work), MS SQL Server 2008.

Client: Fiserv Investment Services Oct’14 – Sep’15

Location: Bangalore, India

Role: Senior Developer

Unified Wealth Platform is the trading and portfolio management system for the Portfolio Focus program. It is a secure web-based desktop system, which provides portfolio management tools including block trading, account rebalancing, and model portfolio construction. The system simplifies trading and saves time by automating the entire trading process/resolution. An intuitive front-end (called the “Dashboard”) greatly simplifies account administration and trading by automatically highlighting accounts on a daily basis that require FA’s attention (ex: new money deposited that needs to be invested, client portfolios that have drifted from the model, etc.).

Responsibilities:

Interact with BA’s to understand the requirements in Story card

Involved in preparing all the documents required for CMMI level 5 process

Involved in designing the class structures and data models based on PEGA best practices

Involved in identifying stages in case & flows

Implementation of Decision tables, Decision Maps, Declarative expressions, Activities & Routing

Design and development of User interfaces using Harness, sections and flow action rules

Designed screen flows & process flows and Defined SLA’s in Workflows & Correspondence

Configured a SOAP connector, SOAP service, File Listener & Connect SQL Rules

Created Rules for Validation, Integration rules like Rule-RDB-SQL using methods like RDB Save, RDB Open, RDB List, Creation of Work Objects, assigned to Operators

Created List view and Summary view reports

Worked with Clipboard and Tracer tool for troubleshooting the issues

Involved in bug Fixing Activities with Lead and System Architects

Continues interaction with onsite development team and followed agile development methodology

Environment: PEGA 7.1, UWP-APL Framework, WCF, JSON, SQL Server-2012 and APL

Client: Fiserv Card Solutions July’13 – Sep’14

Location: Bangalore, India

Role: Senior Developer

Fiserv in its card solutions segment offers a range of credit cards, such as travel cards, balance transfer, low APR, personal loans and cash back, charity, football, and student credit cards; as well as online services. Application uses Smart Invetigate & PEGA CPM frameworks

Responsibilities:

Developed all the business rules for the Pega implementation

Designing and building user interfaces using Sections, Harnesses, and Rule-Obj-HTML in PRPC

Designed Class Structures, Workflows and Rule sets for case creation, assignment and case resolve

Created Data classes and DB tables for integrating with external systems

Worked on the UI components, Declare Expressions and decision Rules

Developing SLAs (Service level Agreements) in Workflow in PRPC

Customized rules in Pega Smart Investigate Framework according to requirements

Developed web services to support external applications to access data

Creation of activities for implementing core business logic

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

Develop Use Cases based on detailed requirements as defined by Business Analysts

Developed SOAP Integrations to connect with ESB layer

Prepared high level design document from requirements

Preparation and Execution of unit test cases and Troubleshooting and debugging

Support for the code migration by defining the Product and patch rule files

Created Product rule set to migrate rules across various environments

Provide support during System Integration and Implementation

Environment: PRPC 6.2, Java, HTML, XML, Web Services, Websphere and Oracle 10g

Client: Hanover Insurance July’12 – May’13

Location: Bangalore, India

Role: Software Developer

One of the major themes within the PL Strategy is the ease of doing business. In our quest to increase our book of business, one of the key areas we are focusing on within this initiative is to make our systems attractive as well as easy to use. Today agents have the choice of placing their business with whichever company they please, and one of the decision points involved in this is the ease and flexibility that a company's application provides to them. Quote proposal provides the estimated premium and Cross selling information.

Responsibilities:

Involved in Tech Design and Technical specification documents and defining standards using Proprietary Architectural Practice methodology.

Involved in discussions with Data architect for preparing Field requirement specifications.

Involved in requirements gathering, guided business analyst to understand the existing Quote detail.

Created client project to interact with Process server deployed BPEL process and WebSphere deployed loss handling service for PL QPP.

Involved in PEGA PL and CL pay plan services and Marketing message service class hierarchy design and developing web services.

Worked on activities, maps, decisions rules.

Environment: Java/J2EE, PRPC 6.3, Oracle 9, XML Spy, SOAP UI

Client: NTT Data Jan’12 – Jun’12

Location: Bangalore, India

Role: Software Developer

Real time Rating (RTR) is ACORD based interface to accept requests to quote both the Homeowners and personal Auto Lines of Business. If the Agent likes the returned quote, phase I of the project will have them bridge the quote into our POS application, utilizing our existing Business Partners application Pre-fill and Flood. Having flooded the quote into our POS application, the Agent will be navigated as deep into the POS page flow as the bridged data allows where they will be prompted to complete the entry process and submit the quote for issue. To achieve this end, both new and existing functionality will be built, re-used and/or modified and extended utilizing a combination of new state of the art and existing technologies.

Responsibilities:

Worked with Business Analysts to understand the requirements.

Created a Design and Technical Specification documents.

Designed the Real Time Rating workflow for Auto and Home Quotes.

Created Service SOAP to create the Auto and Home Quotes.

Worked with Release Management team to deploy the components.

Played as single Point of contact in offshore for Testing and UAT Team.

Environment: PRPC 6.2, SQL Server 2012, XML Spy, SOAP UI

Client: Fiserv Jan’11 – Dec’11

Location: Bangalore, India

Role: Systems Engineer

APL is an end to end portfolio management system which is developed on legacy language called A Programming Language. This project is initiated to migrate the legacy code and data in files system to .net environment.

Responsibilities:

Learnt Legacy technology APL and proved by winning prize in worldwide competition.

Studying and understanding the legacy code and building functions.

Involved in enhancing and unit testing modules.

Actively involved in document preparation on code analysis.

Environment: APL, C# .Net, SQL Server, ESB, XML, UNIX, Attachmate Extreme

Client: Propart Solutions Sep’09 – Dec’10

Location: Hyderabad, India

Role: Trainee Engineer

Operations Management System Development (OMSD) is a Web based applications which will automate the data capturing process of quarry, plant operations including plant maintenance and dispatch of all Robo plants in India, and develops Products Costing and MIS system as add-on to SAP Business One ERP package.

Responsibilities:

Actively involved in document preparation on code analysis.

Involved in Requirements study.

Preparing and Execution of test cases.

Involved in Smoke, Functional, System and Regression Testing.

Reporting the bugs through Bug Tracking tool bugzilla.

Attended touch base meeting daily on status updates.

Environment: ASP.NET, C# .Net, SQL Server, WCF, AJAX, XML



Contact this candidate