Venkateswarlu
*******************@*****.***
Summary
•Having 14 years of rich IT experience in project management, system analysis, software design, development, implementation and relationship management
•Extensive experience in UNIX, MicroFocusCobol, Acu-Cobol, Net Express 5.1, Shell Script, Oracle 10g, SQL Server 2012, SQL, PL/SQL Technologies.
•Hands on Experience on AS400, OBIEE, ODI, Mainframe (Cobol, JCL, DB2)
•Having 10+ years of experience on Life Insurance, Pensions, Annuities, Health Care Insurance, General Insurance, and Retail Domains
•Experience in coordinating between customer and offshore team as Technical onsite coordinator.
•In 2016 and 2017, received “STAR OF THE MONTH” award and couple of “Thank You” awards from Allianz Life Insurance Customer, and received many appreciations from Allianz CEO and from Sr Directors as well from Capability Managers.
•Extensive experience in full SDLC, end to end development of software products from requirement analysis to system study, design, coding, testing, de-bugging, documentation and implementation
•Having 9+ years of strong experience in Production Support, Maintenance, and more than 5 years of experience in Enhancements and Development projects.
•Excellent problem solving skills with a strong Technical and Functional background.
•Excellent team leading qualities with interpersonal, analytical and Communication skills.
•Committed, result oriented, hard working with a quest and zeal to learn new technologies.
•Ability to work in a fast-paced, team oriented environment under firm deadline schedules to meet cost, quality and timing.
•Monitor and Support the nightly batch cycle. As part of support addressing and fixing critical customer defects(P1, P2, and P3)
•To follow up on escalations and issues with clients and onsite managers.
•Identify issues and follow through with the relevant parties
•Review interface document thoroughly and ensure completeness and correctness
•Willing to work beyond normal hours if necessary
•Good experience in Analysis, Design, Coding and testing on medium size projects to large size projects
•Five years of onsite (USA, UK) working experience.
•Ensuring that the quality of the delivered product is meeting the HCL quality and security standards
•Support User Acceptance testing and deployment.
•Defect Prevention analyst and Configuration/Change Controller
•SLA monitoring for the priority incidents and problems for the business
Technical Skills
Operating Systems: AS400, Z/OS, HP-UNIX, Linux, Windows 9x, XP and MS-DOS
Languages: MicroFocusCobol, Acu-COBOL, Oracle 10g, SQL Server 2012, Net Express 5.1, SQL,
PLSQL, Shell Script, OBIEE, ODI, AS400, VSCobol, ISPF, JCL, DB2.
Primary skills: Net Express 5.1,Unix, VI Editor, MIcroFocusCobol, Acu-COBOL, SQL Server 2012,Oracle 10g, Shell Script, SQL, PL/SQL
Secondary skills: AS400, OBIEE, ODI, Z/OS, ISPF, VSCobol, JCL, DB2
Training Completed: Informatica, Hadoop, Qlikview, BigData
Databases: SQL Server 2012, Oracle 10g, DB2,
Tools : SQL Server 2012, PLSQL Developer, Serena Dimensions, SVN, CA work load, Service Now, HP-UX Reflection, Appworx, PVCS, DI0001, Unicenter, Exceed, TOAD, RETEK, Telnet, Putty, Cherwell, VCQ, Lotus Notes, PmSmart, and BUGZILLA, XPEDITER, FILEAID, CHGMAN, SPUFI.
Professional Experience
Allianz Company of North America Dec’15toTill Date
Sr-Technical Lead & Technical Onsite Co-Coordinator
Minneapolis,MN
CRS:
Bass is an on-line and batch Micro Focus Cobol application for the administration of Life Insurance Policies and Annuity Contracts. BASS is driven by parameters and set-up files maintained by the business community. BASS provides user information via batch reports and on-line query access. BASS maintains and reports IRX tax information for agents and policy holders.
Responsibilities
•Playing the role of Technical Onsite Coordinator.
•Understand the current/future business need and propose solution in the long-term perspective.
•Assist in the development, design and implementation of application Components using Micro Focus Cobol.
•Providing real time support to BASS application.
•Preparation of Technical Design Specifications.
•Identify issues and follow up with the relevant parties.
•SLA monitoring for the priority incidents and problems for the business.
•Involved in Allianz Life Insurance modules study and business functions clarifications.
•Maintaining and enhancing the system as per the change requested by the clients.
•Design, code, test, debug and document programs.
•Creating to rule based business components to identify which customer data needs to send to Account Updater partner.
•Coordinate development activities, evaluate and report performance of project by Generating Business user reports to identify the overall success rate.
•Analyze and fix defects found by QA & Product owners and work closely with Quality Assurance Team to close out all open defects.
•Validating the overall System functionality to meet business needs.
•Continuously improving the code quality & performance improvements.
•Generating unit test cases and generating code coverage analysis for the code developed.
•Create a Production support plan.
Environment: Windows XP/7,MS-DOS, MicroFocus Cobol, SQL, PL/SQL, VB 6.0, SQL Server 2012, Net Express 5.1, SQL Server,PLSQL Developer, BASS Client, SVN, CA Workload Automation, Crystal Reports, Service NOW
Admin Re, Mar’13 to Nov’15
Sr. Technical Consultant
UK
CRS:
Describes at a high level the changes that will be made to the FATCA solution (data, data structures and code) in order to make the FATCA solution work for the new CRS data capture and reporting requirements.
•FATCA (Foreign Account Tax Compliance Act) – Established to detect and deter the evasion of US tax by US persons who hide money outside the US. Financial Institutions are required to submit details of their US resident clients to the HMRC on an annual basis.
•CRS (Common Reporting Standard) – Expansion of FATCA covering a much wider population of countries. Global expansion and development of FATCA concept.
Quicken:
The Quicken Migration project is intended to facilitate the legal transfer, data migration and data transformation activities associated with migrating policy records and supporting documentation and document images from the HSBC bank (referred to as the client) into the Admin Re estate.
Alpha Modeling:
Annuities Operational Transformation project is identified as a business priority project within the Operational Transformation program by the Transformation Steering Group. The focus of the Annuities Operation Transformation project is to define changes to business processes and formulate business and system requirements for implementing these changes to the ALPHA system solution. To date a culture of break/fix analysis has led to symptoms of problems being targeted, rather than root cause. This has resulted in a continuous cycle of incidents being created and linked to legacy incidents that demonstrate similar symptoms.
Responsibilities
•Understand the current/future business need and propose solution in the long-term perspective.
•Involved in the analysis of the FSDs & QCs, Estimation, Coding, Unit- testing,
•Peer review, preparing the handover document.
•Follow the AdminRe process, and ensuring that the delivered work packages confirms to the customer requirements and agreed quality standards.
•Worked on PLSQL Packages, Procedures, Functions, Triggers, Synonyms, Views, Exception handling etc.
•As part of CRS, written more than 10 newer packages using above concepts.
•Ability to work in a fast-paced, team oriented environment under firm deadline schedules to meet cost, quality and timing.
•Worked with client team directly and involved all the faces of the SDLC, and resolved many PCR’s and QC’s within deadline and received very good applause as part of the Quicken and CRS projects.
•Worked on AdminRe business functionalities used in ALPHA (New Business, Coverage changes, Policy Termination etc).
•Develop documentation artifacts focusing on various layer - Business Process, Logical Design and Physical Design leveraging UML and Sparx Enterprise Architecture Tool
•Deliver Artifact Library providing documentation of AS IS ALPHA system which supports Annuities ReAssure and Drawdown ReAssure business processes
•Recommend ways to improve current operations of Annuities Customer Services (CS)
•Assist Admin Re to define the artifact library and the governance structure for documentation and knowledge management
Environment : Unix, MFCobol, Shell script, Oracle 10g, SQL, PL/SQL, VB 6.0, Oracle 10g,Pl/SQL Developer, Serena Dimensions, HP-UX Reflection, ReAssure ALPHA 2.15, Visual Studio, Jenkins, Sparx Enterprise Architecture
SBI General Insurance Company Ltd, Sep’13 to Dec’14
Associate Project Manager
India
HCL Technologies proposes an integrated customer centric business solution, covering all functionality and flexibility required to carry out the general insurance business. The proposed solution would support all Lines of Business, multiple delivery channels, and business partners of SBIGICL and the entire value chain of General Insurance Business. Considering the quick time to market envisaged by SBIGICL and the current state of Indian Insurance Industry, it is looking at a product that is functional, configurable, and modular. The solution is designed to deliver operational efficiency, operational controls, and superior service delivery capability, enhanced decision making, by providing right information at the right time. In addition to these, for SBIGICL program HCL Technologies would set up a PMO, Program Governance, Control and Risk Management capability to enable SBIGICL Senior Management to monitor and ensure the project performance
Responsibilities
•Publishing and having weekly status call on Incident Tracker, production Defect Tracker and Environment status tracker.
•Worked on OBIEE Environment Server related issues ( BI server restart, LDAP failure, OBIEE 11g upgrade in Pre-prod, DR-prod, UAT2, 3 and 4 Environments, Sanity checks in Pre-Prod and DR-Prod, Tuning of top queries consumed by more CPU, Static and Analytic Reports etc)
•Involved in Production Environment Upgrade (Upgrade to WLS 10.3.6, Reinstallation of OBIEE 11g with software only option, Configure the domain and components etc)
•Follow-up with Oracle for getting resolution for OBIEE Environmental issues.
•Handling Production Support Escalations, Client Interactions, Managing the team effectively.
•Understand the current/future business need and propose solution in the long-term perspective.
•Involved in the analysis of the CR, Estimation, Coding, and Unit- testing and installing the code on production environment.
•Performance Monitoring & Tuning Process
•Defect fixing process, RCA Preparation
•Release Management Process Approvals and Production Deployment status updates.
•Interaction with Other tracks (Source, CRM, and Claims etc.) for resolving the issue.
•Ensuring that the delivered work packages confirms to the customer requirements and agreed quality standards.
Environment: Unix, Shell script, SQL, PL/SQL, OBIEE, ODI, Oracle 10g, ODI(Oracle Data Integrator ), OBIEE(Oracle Business Intelligence Enterprise Edition), PLSQL Developer, Control-M
Shopko, Oct’10 to Feb ‘13
Project Lead
WI, USA
As part of Shopko engagement, HCL has to provide the L2/L3 support, enhancement and development activities for its application landscape.
The project is being executed as per HCLT’s onsite-offsite model. Herein the HCLT onsite team conducts the System Study, Design, development and testing of the modules that require real time data and the offshore carries the same for the modules that do not require the non real time data. Also the onsite team is responsible for bug fixing and working on production issues, automate things, improve the performance of the system and release of the production whereas the HCLT offshore team provides total support during all these phases.
Responsibilities
•Assess the existing application landscape and propose the optimum solutions to improve the Business Benefits with better ROI.
•Involved in the analysis of the SR, Estimation, Coding, and Unit- testing and installing the code on production environment.
•Worked on Large size Enhancements MDO, Commerce Hub, Market Max- Major Reclass and several medium size projects.
•Perform a peer review of the analysis & resolution documents before delivering it to the customer.
•Perform a peer review of the code changes implemented by the team members.
•Preparation of Technical Design Specifications
•Preparation of Unit Test Plans
•Review the test cases for the code changes as per the business cases
•Monitor the test results
•Follow the Shopko SISDM support & Maintenance process.
•Understand the current/future business need and propose solution in the long-term perspective.
•Leveraging the HCL matured development and support processes to improve the reduction in the development lifecycle with better quality.
•Support User Acceptance testing and deployment.
•Ensuring that the delivered work packages confirms to the customer requirements and agreed quality standards.
•Monitor and Support the nightly batch cycle.
•As part of 24 X 7 support addressing and fixing critical customer defects.
•To follow up on escalations and issues with clients and onsite managers.
•SLA monitoring for the priority incidents and problems for the business
Environment : Unix, Z/OS, MFCobol, VI Editor, Shell script, Oracle 10g, SQL, PLSQL, Abinitio, VSCobol, ISPF,JCL, DB2, Oracle 10g, DB2, Appworx, PVCS, DI0001, Unicenter, Exceed, SQL Developer, TOAD, RETEK, PmSmart, and SPUFI.
Hallmark Services Corporation, Oct ’08 to Sep ‘10
Project Lead
IL, USA
Hallmark Services Corporation is a wholly-owned subsidiary of Health Care Service Corporation serving as an administrator in the individual health insurance markets and is committed to offering an exceptional level of quality services. They use the System-80 application for administering health insurance for the under-65 consumer market. System-80 is both an Online and Batch application developed in Acu-COBOL, Perl and Unix Shell script. It uses the U/FOS database for the data storage. Runcbl is used for debugging the application. The Visual Cyber Query is used for report generation.
Responsibilities
•Co-ordinate with the customer for the incoming work and assigning it to the team.
•Analyze the Incidents, resolve them and preparing the resolution document for the same.
•Involved in the analysis of the SM, Estimation, Coding, Unit- testing and Installing the code on test
•Worked on Large size Enhancements Commission Agent project.
•Monitor and Support the nightly batch cycle.
•Perform a peer review of the analysis & resolution documents before delivering it to the customer.
•Perform a peer review of the code changes implemented by the team members.
•Follow the HSC support & Maintenance process.
•Co-ordinate the team and to enter the work details in Pmsmart, generate status report and share the same with the customer.
•Conduct meetings with the team and business users for smooth progress of the work.
•Follow the HCL Quality processes so that the work products are in line the OMS standards.
•Preparation of proposals and presentations for the customer.
Environment: Unix, Acu-Cobol, VI Editor, Shell script, VCQ, UFOS, Cherwell, SQL Developer, PmSmart
Wincor Nixdorf, Nov ’07- Aug ‘08
Consultant
UK
The objective of the project is to migrate the current version of MIDAS (MIDAS II) onto a new Cobol development environment to run under the Linux operating system and on a new Hardware environment. This new system and environment is known as MIDAS III.
Responsibilities
•Business Analysis and Migration of MFCobol Programs to Acucobol
•Onsite and Offshore Interaction
•Coding
•Unit testing
Environment: UNIX, MicroFocusCobol, Acu-cobol, Shell script, PVCS
Amisys Synertech Inc, Apr ’06 – Nov ‘07
Software Engineer
India
Community Care of Oklahoma (CCOK) intends to support their PPO processing line of business on Amisys Advance. Amisys Advance currently includes a claim re-pricing process referred to as face sheet processing.
835 Electronic Funds Transfer:
This enhancement proposes changes to the current X12 835 transaction logic to support electronic transmission of both payment and remittance to health plan providers. This will provide a complete solution supporting the HIPAA 835 transaction.
NPI:
The National Provider Identifier (NPI) is part of a HIPAA mandate requiring a standard unique identifier for healthcare providers. The NPI will replace other identifiers such as legacy payer identifiers, Medicaid Numbers, etc. Providers and health plans must use only the NPI to identify providers in standard EDI transactions – no legacy provider identifiers will be allowed.
Responsibilities
•Onsite Interaction.
•Business Analysis
•Preparation of Technical Design Specifications
•Preparation of Unit Test Plans
•Coding
•Unit testing
Environment : Unix, MicroFocusCobol, VI Editor, Shell script, Oracle9i, SQL, PLSQL, PVCS, BUGZILLA, SQL Developer, TOAD
Pleasant Holidays, Sep ’05 to Mar ‘06
Software Engineer
India
California based, Pleasant Holidays is one of the most important American tour operator servicing Hawaii, Mexico, Australia as well as many other South Pacific destinations. Each year, the company offers dream vacations to more than 500,000 vacationers.
Pleasant Holidays is one of the leading tour and travel promoters in the US. Currently, the system offers two kinds of applications, one is Call-center application and another one is Web-based application which enables the customers to book their holiday packages to their dream destinations.
This project aims at re-engineering the Call-center application (which is a Character based application) to web-enable the existing application using the SOA framework.
Responsibilities
•Onsite Interaction.
•Business Analysis
•Preparation of Technical Design Specifications
•Preparation of Unit Test Plans
•Coding
•Unit testing
Environment: Linux, Acu-Cobol, VI Editor, Shell script, Perl, PVCS, BUGZILLA.
Fiserv, Aug 03 –Aug 05
Software Engineer
India
Fiserv is a technology solution provider for financial service industries in and around the US. It provides a wide range of business process solution ranging from transaction processing for deposit, accounts to loan servicing, processing systems for insurance, securities, and retirement plan administration. Fiserv serve more than 13,000 clients worldwide, including banks, broker-dealers, credit unions, financial planners and investment advisers, insurance companies, agents, leasing companies, mortgage lenders, and savings institutions. Mortgage Serv is a mortgage banking servicing system which caters service for its clients such as General Motors Acceptance Corporation (GMAC), Mellon Bank, and Citicorp etc. who are involved in mortgage banking. Mortgage Serv is a loan servicing system, which involves various entities such as Borrower/Investor accounts maintenance, Default deduction, Delinquency management, Loss Mitigation Loan Warehousing and Information Services. Satyam Computer Services Ltd provides ODC service for software support and maintenance for various business processing systems of the Mortgage Serv Servicing system.
Responsibilities
•Onsite Interaction.
•Business Analysis
•Preparation of Technical Design Specifications
•Preparation of Unit Test Plans
•Coding
•Unit testing
Environment: Z/OS, ISPF,VSCobol, JCL, DB2, CHGMAN, SPUFI