Herry Patel

Involved in maintaining 3 tier applications for Asurion’s US clients and Canadian clients

• Some of them includes ATT, Verizon and Sprint
• Mobility insurance features were defined and retrieved from database and from Amazon RDS
• Involved in moving data from legacy system to horizon platform using oracle packages and procedures
• Also maintained daily jobs to process enrollment file from clients and process them in timely manner to consume from claim flow
• Managed oracle packages which process Node JS requests and fulfill required features for the Mobility claim flow
• Experience to monitor and debug through Kibana to understand cause for the production defects and redirect to appropriate team
• Provided support for any ad-hoc requests to mock up data in DB and manipulate asset configuration
• Created automation for the new asset set up
• Business leverage Automated CCP tool to add, delete of move assets from one tier to another
• Worked with Oracle objects as packages, procedures, indexes, collections, triggers and views
• Also worked with front end developers to fulfill requirements in cost effective ways.
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
• Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
• Migrated legacy systems to modern big-data technologies, improving performance and scalability while minimizing business disruption.

• Managed and Enhanced Liberty mutual compensation application and integrated reporting system which provide data for Sales Bonus, commissions and productive bonus
• Maintain and developed commission plan code written in Oracle packages and enhanced for their own sales rep, third party clients and direct response center’s employees
• Involved in Sprint refinement, Sprint planning, retro and Stack Holder’s Demo
• Also managed JIRA and Trello board to keep track of all action items from ceremonies to insure every aspect of Agile methodology satisfied
• Played lead role in Informatica retirement project
• Analyzed existing Informatica nightly workflows and underneath Perl Scripts, replicate those in to Unix bash shells
• Also designed ESP jobs to invoke UNIX shells
• Lead Off shore team in areas of application implementation and migration
• Involved in creating SFTP jobs to Transfer policy data, payroll information, General ledger to/from different servers (windows, UNIX and Mainframe)
• Monitored batch Generations from CA workstation for Critic Nightly batch job run and supported Production run during warranty periods
• Involved in Creating Scripts to fetch reporting data and developed MicroStratagy of Sales team’s monthly goal, productivity, performance and cross sell data
• Transfer data from staging database to other LM channel database Using DB links
• Involved in Building ingestion and validation checks around incoming data and store in Oracle
• Part of oracle 12c migration from Oracle 11 g
• Worked with oracle global temporary tables to hold data in run time and compute complex bonuses for sales rep
• Performed all programming objects of oracle including creating table, views, indexes, triggers, materialized views, PL-SQL collections and bulk collection techniques
• Also used oracle supplied packages like DBMS_STATS, DBMS_MVIEWS
• Involved in Performance tuning using explain plan and SQL trace
• Worked with SQL Loader, external tables and global temporary tables
• Used Pragma Autonomous transaction to logging error during process without committing transaction
• Involved in creating instead of triggers in order to Give DML functionality on complex views
• Developed scripts to prep reporting Schema for Micro-strategy and actuate reporting tools
• Worked with rational team concert and Bit bucket to maintain code versions, also involved in merging activity in case of conflicts between streams or branches
• Worked on SQL queries for Hyperion to SAS EG migration
• Logical and Physical Data modeling using SQL data modeler.
• Improved software efficiency by troubleshooting and resolving coding issues.
• Saved time and resources by identifying and fixing bugs before product deployment.
• Collaborated with cross-functional teams to deliver high-quality products on tight deadlines.
• Enhanced user experience through designing and implementing user-friendly interfaces.
• Contributed to a positive team environment through effective communication, problem-solving, and collaboration skills.
• Developed customized software solutions for diverse clients, resulting in increased satisfaction and repeat business.
• .Streamlined workflows by creating reusable code libraries for common functions and features across multiple projects.
• .Mentored junior developers to improve their technical skills, fostering a culture of continuous learning within the team.
• Developed software for desktop and mobile operating systems.
• .Consistently met project milestones while maintaining rigorous quality control standards throughout all stages of the development life cycle.
• Increased development speed by automating repetitive tasks using scripts and tools.
• .Achieved faster development cycles using Agile methodologies, including Scrum or Kanban processes.
• .Created comprehensive documentation detailing software functionality for future reference or maintenance purposes.
• .Boosted customer satisfaction rates through timely resolution of reported technical issues during the support phase of projects.
• .Ensured seamless migrations from legacy systems to modern platforms through meticulous planning, testing, and execution.
• Collaborated on stages of systems development lifecycle from requirement gathering to production releases.
• Participated in regular code sprints, contributing to rapid development and iteration of software products.
• Implemented automated testing frameworks, reducing bugs at launch and ensuring higher quality releases.

• Developed and enhanced BSPN application one the core application of CNO Financial Group
• Analyze the sales of all insurance policies for the clients, track the entire agent’s personal and down-line commission of each cycle and compare territory business reports for client
• Troubleshoot technical and functional problems in the database packages and utilize the database error logs and debugger to identify the bottlenecks
• Optimized database performance by analyzing database objects
• Analyzed the existing Stored Procedures, Functions, Triggers and packages
• Worked thoroughly on performance issues
• Involved in File loading process and used Sql Loader and External tables to import data from flat files and delimited files
• Created and maintained database scripts for different environments using Harvest
• Worked with Autosys Scheduler to run job and deploy DB code to next environment
• Involved in Creation of Schema objects tables, indexes, views, triggers, sequences, synonyms, roles, packages
• Also maintained security with appropriate Grants/Privilege
• Used materialized views and views on data warehouse tables to perform BSPN reporting on home page
• Provide support to production, development, QA and staging databases
• Involved in writing complex queries dynamic SQL using bind variables, hierarchical queries using connect root by to get down-line commission for agents, agent and office hierarchy tree
• Monitor daily running jobs and their logs
• Troubleshoot critical nature jobs if required
• Involve in Tuning, Performance, and Optimization of queries and standardization of the codes
• Used SQL trace and hints for better performance
• Worked with SQL Data Modeler and ERWIN to create a data model.

• Supported and enhanced Automotive resource international’s business applications which maintains their client’s commercial vehicles
• As a Team member interacted with Tech architects and Business Analysts in doing research and solving client specific data migration scripts
• Involved in data analysis of source system and designed New Database model (Physical and Logical) to manage accident claims for ARI’s UK Clients
• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers and Packages using Oracle 10g and 11g
• Fine-tuned PLSQL programs and SQL Queries for maximum efficiency in various schemas across databases using oracle Hints, Explain Plans, TKPROF method and Trace sessions for Cost Based Optimization (CBO)
• Involved in creating batch programs using PL-Sql
• Involved in DATA migration and create migration script using XML
• Received XML Parameters from UI and processed in Backend
• Imported Data from flat files to database through staging tables using SQL LOADER
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger
• Used Instead of trigger in couple of occasion to avoid mutating errors
• Extensively worked on Oracle 10g Packages using Ref Cursors to transfer the data as cursor from one application to another application
• Involved in Documenting business rules, functional and technical designs, test cases, and user guides and associated with QA team to review Test cases
• Involved on event driven operations towards Oracle Database programming with PL/SQL packages from UI application programmed with .NET
• Involved in analyzing and adding new features of Oracle 11g like DBMS_SHEDULER, Create Directory, Data pump, CONNECT_BY_ROOT in existing Oracle 9i application
• Extensively involved in writing PL/SQL packages using Oracle 11g new feature along with REGEXP functions
• Extensively added PL/SQL compiler warnings to identify WHEN OTHERS exception handlers that do no re-raise errors using RAISE or RAISE_APPLICATION_ERROR
• Encapsulated error handling and use of autonomous transaction for logging
• Extensively used PL/SQL features like collections, nested table, Varrays and Bulk collect for high performance of stored procedures
• Involved in the development of ERD Diagrams/ Dimensional diagrams for business requirements using PL SQL developer
• Responsible for designing and maintaining fully integrated and multiple level help system for the modules.
• Conducted thorough code reviews to maintain consistency, improve code quality, and adhere to industry best practices.