Manohar Rao Gummadavelly

Mobile: +1-760-***-****

E-mail: ad4cwa@r.postjobfree.com

Summary

Having 15+ Years of experience in Software Development.

Excellent working experience in developing applications using PowerBuilder versions 5.0 through 2017.

Proficient in Datawindows, Datawindows buffers, PowerBuilder events, Dynamic Datawindows, windows types and window events.

Proficient in RDBMS, SQL scripts, stored procedures, database design, triggers and creating sql reports.

Good in Oracle PL/SQL, MS SQL, BI (SSIS, SSAS and SSRS) designing, developing, enhancing and maintaining large data sets processed through the MS BI stack.

Transformed data from one server to another server SQL Integration Services(SSIS).

Experience in importing/exporting data between different sources like Access/EXcel/Sql Server using SSIS.

Dealt with large relational datasets and good in performance tuning

Strong knowledge of application development techniques and methods

Outstanding analytical, troubleshooting, and problem-solving skills

Well Experienced in application support using Java-J2EE, Struts, Web Logic, JDO

Having very good knowledge in python programing and PyCharm.

Key areas of Expertise include, “Preparation of Project Plan, Identifying Risks, preparing Mitigation/Contingency plans and Effort Estimations”.

Has the capability to define and implement QA process and very good experienced in Unit and Integration Testing.

Expertise in driving projects through the entire Software Lifecycle, from inception to launch, while creating realistic schedules, proactively setting customer expectations, identifying and managing risks.

Extensive knowledge in Insurance Domain and Certified Domain Analyst in Insurance PLI (Internal)

Having knowledge in Agile methodlogy.

Having knowledge in AWS Cloud, Azure cloud, Storage Account and Azure Data Lake Storage

Flexible in nature with an ability to change responsibilities comfortably based on project demands.

Possess good leadership qualities, self - motivated, ability to learn new skills rapidly and perform multitasking

Technical Skills

GUI : PowerBuilder v5.0 – V12.5

Languages : Java J2EE (Struts, Web Logic, JDO) and Python

RDBMS : Oracle 8i & 10g, SQL Server 2000 & 2008, Sybase Adaptive

server anywhere

Script Language : JScript

O/S : Win 95 / 98 and Win 2000/NT/XP/7/8/10, MS-DOS

Web Technologies : HTML, DHTML

Version Control tools : VSS

Test Management Tools : HPQC, ALM

Domain : Insurance

Certifications & Achievements

Domain Analyst certification on Insurance PLI (Internal)

Received POB (Pat on Back) award in “Pursuit of Excellence”

Received “Client Appreciations” for extensive work on projects.

Received “Outstanding Performer” appreciation for the best performance in projects.

Project’s profile

American Electric Power Sep’2017 to Till Date

Virtual Agent

Sr. Developer

Project Description:

Virtual Agent is a Call center application used by agents to interact with the customers. The agents can receive the calls from customer and place an order based on customer requirement like open order, new install, Change order, Bill print, credit and payments.

Environment: PowerBuilder v12.1,2017, Oracle 9i, SQL Server2012,2014, MSBI (SSIS, SSAS and SSRS), Java Script, Python and .Net

Responsibilities:

Develop and support multiple applications built on SQL Server, Oracle, Power Builder ver 12.1, PL/SQL using Oracle 10G, RDBMS Oracle, Java Script,.Net (C#), DB2 or UDB, Oracle Warehouse Builder, Oracle Data Integrator

Used ETL(SSIS) to develop jobs for extracting,cleaning,transforming and loading data into data warehouse.

Create reports, stored procedures, views, triggers, and indexes using SSIS and SQL Server Reporting Services (SSRS).

Creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, effective functions, Cursors and Indexes using T-SQL.

Conducts Batch processes, Import, Export, Backup, Database Monitoring tools and tuning OS, Disk, SQL Server, Query level tuning.

Designs and develops major functional or performance enhancements for existing products or produces new software products or tools. Reviews requirements, specifications and designs to assure product quality; develops and implements plans and tests for product quality or performance assurance.

Work with existing legacy applications to convert, extend and enhance functionality, as well as developing new applications.

Create and analyze SQL queries, Stored Procedures, Functions, Cursors in SQL Server, modern deployment (CI/CD) techniques, performance tuning, integration, setup HA/DR environments for a complex multi-tier web application.

Performs competitive analysis for features at a product level scope. Leads the testing and fixing of new or enhanced products. Creates technical documentation of software products/solutions. Assists with the development and review of end user and technical end user documentation.

Support, configure, and troubleshoot MS clustering technologies at both the disk and SQL engine level, CSV volumes, File stream, ODBC, OLEDB, network Firewall.

Responsible for the delivery of products within budget, schedule and quality guidelines. Works with the team to develop, maintain, and communicate current development schedules, timelines and development status.

Maintain general database health on an ongoing basis to ensure database performance and health. This includes index maintenance, disk fragmentation health, IO balancing, memory balancing, etc.

Performs competitive analysis for features at a product level scope. Leads the testing and fixing of new or enhanced products. Creates technical documentation of software products/solutions. Assists with the development and review of end user and technical end user documentation.

Leads or participates in the software development lifecycle, which includes research, new development, modification, security, correction of errors, reuse, re-engineering and maintenance of software products.

After completion of the development tasks, performs testing, then initiate end to end testing and validation with the end user, which is performed in a development environment.

Participate in daily scrums, project planning, retrospective meetings and project review meetings. Perform query optimization, Technical Design, Coding, database optimization, scheduling of SQL jobs, Tunning.

DST Systems, Birmingham, Alabama, USA Apr’2017 to Aug 2017

Market Prominence

Sr. Developer

Project Description:

“MarketProminence” is a product which provides insurers a way to completely manage all aspects of their government health programs from Marketing, Sales and Enrollment, Transaction Processing, Payment Reconciliation, Premium Billing, Member Services such as retention and grievances, and all Compliance issues. MarketProminence’s automated solution for Medicare programs allows payor to track and manage all data related to a m ember through their lifecycle from initial contact through enrollment, membership and retention.

Environment: PowerBuilder v12.5, Oracle 11g and 12c, MS SQL Server 2012, T-SQL, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (SSIS, SSRS, SSAS), MS Office, MS Visio, Excel

Responsibilities:

Worked on analyzing the “Application Performance”

Co-ordinating with client SME’s to quickly gain the application knowledge

Praparing Understanding document with Observations, Challenges, Pain points and Recomondations for improvements

Reviewing the stored procedures, tables, views and suggested changes for improving performance

Identified slow running queries and performed optimization of stored procedures to improve the performance

Created complex stored procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Actively participating in all team meetings and ensuring all action items are tracked to closure

Updated existing and created new Stored Procedures using DB2

Performed Index tuning for tables and used Scan and Seeks for performance tuning.

Transformed the complex business logic and calculations into coding. Created and updated clustered and non-clustered indexes to keep up the SQL Server performance.

Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected.

Optimized SQL queries for efficiency and assisted the front end developer with their queries and procedures.

Performed performance tuning by studying execution plan, analyzing indexes and using SQL Profiler.

Chubb Insurance Company, Philadelphia, PA Mar’2014 to Mar’2017

Renaissance

Sr. Developer

Project Description:

Renaissance is a Windows based system for the Insurance Policy Administration and Maintenance of the Masterpiece range of personal lines products. It has around 14 applications inclusive and it covers the full life cycle including Quotations, Policy Issue, Endorsements, Renewal Review and Renewal.

Chubb, one of the Insurance Giant based on US and have different branches across the globe.

PLD stands for Personal Line Insurance and it insures Property, Valuable Articles and vehicles. PLD Underwriting System provide an end-to-end support and total solution for underwriters and brokers such as Data Entry, Data Maintenance for Client/broker, Quote preparation, Appraisal for the risks, Mid-Term Endorsements, Policy Document Generation and quality verification, Billing Tracking and renewals. This multi-tier and multi-user application has total 17 modules and using different technologies from PowerBuilder (versions 10.5 and 12.5), Java, JSP, VBA, SQL Server 2000 and WebSphere. Below are the details for the few important modules:

Service Centre: Is the heart of the whole system and handles from Data Entry to Policy Creation, Policy Issue and Developed in PB 10.5 and SQL Server 2000.

CATS: Called as Chubb Appraisal System, which handles the end-to-end work flow of an appraisal of a risk...

Environment: PowerBuilder v11.5 and V12.5, Oracle 10g, SQL Server 2008,Business Intelligence Development Studio (SSIS, SSRS, SSAS), Windows XP, NT, 2000

Responsibilities:

Analyzing the requirement specifications provided by the client and preparing the technical specification for the requirements

Worked on preparing the Project’s Schedule and Efforts plans.

Created complex stored procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications using Oracle.

Creation of database objects like tables, views, materialized views, procedures and packages in PL/SQL

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Supporting Agent Portal for Small Commercial Insurance group targeted to provide self-service interface for Chubb Agents to manage insurance policies for the small, and medium size business customers.

Transferring data between XML document and Oracle and SQL server.

Worked on database creation, performance tuning, backup planning and database administration.

Identified slow running queries and performed optimization of stored procedures to improve the performance

Creating Datawindow, User Object, Menus, Windows, Functions etc. in PowerBuilder

Designed Report Templates using information like Company Logo, Department Name.

Worked with various control flow tasks of SSIS including Data Flow Task, Execute SQL Task.

Created Packages for Transaction processing using containers as For-Each Loop, Sequence & controlling flow of data using tasks as Script, Data Flow, File System, and Execute Package.

Worked on complex reports which involve multiple tables having various functionalities like Drill Down, Parameterized and Chart reports.

Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.

Responsible for designing, creating and deploying the reports into the production server.

Extensively worked on production support for the project.

Actively participating in meetings with “BA’s and Clients” for requirements understanding

Participating in all project meetings and ensuring on time deliverables. Reviewing all tasks on day to day basis for any issues or risks.

During production support, flexible in time lines and providing required support so that all the service tickets are properly prioritzed and resolved. Engaging required parties if required for a quick turn over of tickets.

Very good in analyzing and debugging the issues as having good application knowledge which helped in identifying the root cause for quick resolution.

Chubb Insurance Company, Philadelphia, PA Mar 2009 to Apr 2014

PreCICE

Sr. Developer

Project Description:

PreCICE is a product developed on Client Server architecture, caters the Policy management processes covering Quote, Bind, Endorsements and Renewal of Property and casualty business for Chubb

Environment: PowerBuilder 8.0 and 10.5, Oracle 8i, Windows XP

Responsibilities:

Analysis of the specifications provided by the client

Preparing the technical specification for the requirements.

Responsible for delivering the work requests on time

Responsible for Application Design and Development

Preparation of “Design” documents and developing the Code in PowerBuilder and Oracle PL/SQL like writing Stored procedures.

Preparing the Quality documents to the project.

Worked on Test case preparation and performing Unit & Integration testing

Chubb Insurance Company, Philadelphia, PA July 2006 to Feb 2009

MP24 (Formerly known as Broker Site)

Sr. Developer

Project Description

This is an exciting development enabling to broker. To obtain online quote indications and binding quotes for both Masterpiece and Masterpiece INITIAL policies and capture the client information.

Environment: J2EE, JDO, Struts, Oracle 10g, Web logic, CVS, Jbuilder, Windows XP, NT

Responsibilities:

Analyzing the requirement specifications provided by the client.

Preparing the Schedule and Efforts required for the Requirements.

Identifying the Risks and Issues in the requirements during the Requirement Analysis.

Application development with coding in Java and SQL Server

Performing Unit Testing and Integration testing

Providing Status documents and Metrics on overall statistics

Defect management on QC provided by client

Managing the Issue tracking through internal tool

Extensively worked on production support for the project.

RAM Informatics Ltd. Hyderabad, India May 2005 to July 2006

Life Insurance Agency Development Evaluation and Review - LEADER (Company’s Product - Targeted towards Development Officers)

Application Engineer

Project Description

This is a product for Development Officers of Life Insurance Corporation India (LIC). There are four Modules, first module is to maintain and manipulate the client’s data, Second module involves Transactions - Renewal Transaction, third module involves calculation of Scheduled Premium Income, fourth module includes the Reimbursement of Expenses.

Environment: PowerBuilder 7.0, Adaptive Server Anywhere 6.0, Windows 98, NT, VB Script and 2000

Responsibilities:

Responsible for Analysis of the specifications provided by the client

Design and Development

Coding using PowerBuilder and Adaptive Server Anywhere

Unit testing & Integration testing

Responsible for Preparing the Quality documents to the project.

Work allocation to the team member

Interacting with consultant to get the requirements

Providing application presentation to clients

Giving Training to the clients

RAM Informatics Ltd. Hyderabad, India Mar 2004 – May 2005

Advanced Insurance Manager (A I M) (Company’s Product – Targeted towards LIC Agents

Application Engineer

Project Description

This is a product aimed at Life Insurance Corporation of India (LIC) Agents. There are six modules, first module is to maintain and manipulate the client’s data, second module is helpful in converting prospective customers, third module is to maintain agents commission, fourth module is HFL, fifth module is computerizing the activities of LIC Development officers and the final module is Key man Insurance for Corporate.

Environment: PowerBuilder 7.0 and 8.0, Adaptive Server Anywhere 6.0, Windows 98, NT and 2000

Responsibilities:

Responsible for analyzing the specifications provided by the client.

Design and Development

Coding using PowerBuilder and Adaptive Server Anywhere.

Unit testing & Integration testing

Responsible for Preparing the Quality documents to the project.

Interacting with consultant.

Providing application presentation to clients

Giving Training to the clients

Installation of product

Education

MCA (Master of Computer Applications) from IGNOU in 2006

Contact this candidate