Description
SUMMARY * 10+ years of experience in areas of Analysis, Design, Development, Testing, Implementation, Client interaction and project releases. Good Exposure to Trade Surveillance, Risk compliance, Media Telecommunication, Retail and Insurance Client/Server based Enterprise applications using high-end databases such as Oracle 11g / 10g / 9i on UNIX, Linux and Windows enterprise platforms. * Being an Actimize product specialist, have successfully developed and implemented numerous complex Actimize Trading and brokerage surveillance solutions for Global Control Room, Information Barrier Surveillance, Associate Investment Monitoring, region and country specific surveillance LOBs. * Extensively worked on Actimize Visual Modeler 3.6, 4.0, 4.3, 4.7, 4.9, 4.14 and Actimize Risk Case Manager/Designer 4.0, 4.3, 4.6, 5.1 and 5.7 * Practical Experience with different software development Methodologies like Agile Methodology, Waterfall and V-model. * Extensive working knowledge in developing Packages, Stored Procedures, Functions and Database Triggers for developing applications. * Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques * Extensive experience in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing. * As a Database Analyst, I was responsible for receiving incidents and requests from end-users, analyzing those and responding to end-users with the solutions. * Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility &TKProf. * Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces. * Extend and maintain existing ETL processes to accommodate new or changed data feeds. Proactively diagnose research, monitor and resolve database-related faults and performance problems including high CPU, memory, blocking, deadlocking and timeouts. * Review and fine tune scripts, stored procedures, functions, and triggers related to bug fixes before releasing to production. Project Summary: Develop, enhance and implement Actimize trading and brokerage surveillance solutions for Global Control Room/Information Barrier Surveillance, Associate Investment Monitoring, AMRS Fixed Income and APR LOBs to fulfill the regional and global regulatory requirements. Responsibilities: * Being an Actimize product specialist, have successfully developed and implemented numerous complex Actimize Trading and brokerage surveillance solutions for Global Control Room, Information Barrier Surveillance, Associate Investment Monitoring, region and country specific surveillance LOBs. * Developed new model and enhancement using Actimize Visual Modeler 4.9, 4.14 and Actimize Risk Case Manager/Designer 5.1 and 5.7 * Developed database functions, procedures, and packages in PL/SQL, Oracle11g as back-end to process the actimize models. * Developed complex data queries to generate reports required by business users Enhanced and maintained existing rate schedules for all the Adhoc models. * Actively involved in Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility & TKProf on surveillance to meet the exception delivery SLA * Data Analysis and Data Design as per surveillance needs * Debugged various defects related to implementation of business logic * Tuning of the SQL queries, which takes long time to process the request using oracle Explain Plan, Hints to reduce the response time * Interacting with business users and compliance managers to understand the surveillance requirements * Preparing and reviewing functional requirement specification documents and technical specification documents * Supporting QA team in defining, preparing and executing test cases and test plans * Conducting User Acceptance Testing by coordinating with the Business Users and Business Analysts. * Onsite - Offshore coordination and assisting onsite and offshore project managers and client managers in various management activities such as tracking, estimation, planning, access management, various metric reports, status report. Project Summary: The objective of the Procurement Reform Project is to improve performance of the public procurement system progressively in across the world, focusing largely on the key sectorial ministries and targeting their implementing agencies. The additional financing will help finance the costs associated with the funding gap and the scaling up of activities to enhance the impact of a well-performing project implemented by the Central Procurement Technical Unit (CPTU) of the Implementation Monitoring and Evaluation Division (IMED) of the Ministry of Planning (MoP). The financing will support expansion of the capacity development program and rolling out of electronic government procurement (e-GP) combined with procurement performance monitoring. It's mainly to ensure continuity of the program and enable timely processing of project including its effectiveness within the project time period. Responsibilities: * Designed the application system structure and functional modules. Used the functional document to design application logical and physical structure. * Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL languages. * Developed Packages, Procedures Functions and Database triggers using PL/SQL. PL/SQL query tuning using Explain Plan, optimizers, hints, Indexing strategies, cost measurement etc. Error review, log and restudy/recode of the system. * Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL* Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences. * Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL. * Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE. * Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module. * Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application. * Debugged various defects related to implementation of business logic Project Summary: Mobile Remote Access (MRA) U-verse App manage DVR, schedule recordings, browse the TV guide, and, with a qualifying AT&T U-verse TV plan, watch from a library of hit TV shows on smartphones. Using U-verse App browse available TV content for current or future viewing, search for content, and remotely manage recordings of shows and movies on your U-verse DVR and With qualifying TV plans, download select popular TV episodes/series from the Mobile Library to select smartphones. Search U-verse TV program listings, schedule program or series recordings, and manage or delete stored DVR content. Responsibilities: * Designed, developed and tested software using Agile Methodology. * Worked in development, testing and production environment using packages, stored procedures, functions. * Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle11g as back-end. * Worked on creating non-production instances using Export / Import utilities / Data pump Schema and User management. * Created various SQL and PL/SQL scripts for verification of the required functionalities. * Created Records, Tables, Objects, Collections (Nested Tables and Varrays), Table Partitioning and Error Handling. * Worked on Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility & TKProf. * Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Global Temporary table spaces. * Successfully provided round the clock support to all the applications and proposed new ideas and solutions for improvising existing system. * Developed UNIX Shell Scripts to execute procedures and publish the files. * Run batch jobs for loading database tables from Flat Files using SQL*Loader. * Used File Transfer Protocol (FTP/SFTP) tool to transfer files from one server to other. * Created Unit Test plans and involved in primary unit testing. * Responsible for the development and maintenance of end-user documentation. Project Summary: PNMR Services Company ("PNMR Services") is a subsidiary of PNM Resources, Inc. (NYSE: PNM). PNM Resources is an energy holding company based in Albuquerque N.M., with 2006 consolidated operating revenues of $2.5 billion. In Texas they handle the IT system for TNMP is an electric transmission and distribution company in Texas In an effort to attain there new Business Outcomes, focus on its core competencies and reduce its costs, PNMR Services has outsourced its Application Management Services, including Maintenance and Support for these application groups Customer Service Application Group, Complex Billing Application Group, EDI Application Group and Ancillary Application Group. Responsibilities: * Effectively developed CIS system enhancements as requested by Business Optimized the Bill print processed which took nearly 6 hrs to run daily to 2 hrs saving 4 hours of processing time daily . * Developed complex data queries to generate reports required by business users Enhanced and maintained existing rate schedules for Complex billing in Lodestar Billing Expert. * Created an effective new interface during implementation for Advance Metering system Handled both frontend and backend processing for all the applications Developed new business processes as per Business requirement. * Handling end-to-end communication with client for business requirements, user acceptance testing and day-to-day business requirements and trouble shooting. * Single point of contact to the Client and the business user for the offshore counterparts * Successfully provided round the clock support to all the applications and proposed new ideas and solutions for improvising existing system * Effectively handled and resolved production defects * Performed the Disaster recovery setup for CIS system and Lodestar Complex billing System and tested the Disaster recovery systems successfully. Wal-Mart GLS PH2 (USA) Responsibilities: Effectively developed CIS system enhancements as requested by Business Optimized the Bill print processed which took nearly 6 hrs to run daily to 2 hrs saving 4 hours of processing time daily . * Developed complex data queries to generate reports required by business users Enhanced and maintained existing rate schedules for Complex billing in Lodestar Billing Expert. * Created an effective new interface during implementation for Advance Metering system Handled both frontend and backend processing for all the applications Developed new business processes as per Business requirement. * Handling end-to-end communication with client for business requirements user acceptance testing and day-to-day business requirements and trouble shooting. * Single point of contact to the Client and the business user for the offshore counterparts * Successfully provided round the clock support to all the applications and proposed new ideas and solutions for improvising existing system * Effectively handled and resolved production defects * Performed the Disaster recovery setup for CIS system and Lodestar Complex billing System and tested the Disaster recovery systems successfully. Project Summary: The project aimed to develop and maintain a single Warehouse Management System which is functionally rich and technically flexible, allowing its distribution customers globally to operate at the lowest cost. The proposal is to create a global system known as Global Logistics System (GLS) which would encapsulate functionalities of different Warehouse management systems running across DC's. This application is used in Wal-Mart whole around the Globe. The system is used by the DC workers to automate the Receiving/Shipping/Order Filling and Distribution to various Stores located at different places of the country. Responsibilities: * Gathered the business requirements from the client and translated the business details into technical design and specifications. * Designed the application system structure and functional modules. Used the functional document to design application logical and physical structure. * Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL languages. * Developed Packages, Procedures Functions and Database triggers using PL/SQL. PL/SQL query tuning using Explain Plan, optimizers, hints, Indexing strategies, cost measurement etc. Error review, log and restudy/recode of the system. * Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL* Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences. * Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL. * Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE. * Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module. * Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application. * Debugged various defects related to implementation of business logic * Interacted with client to gather the requirements and implement the same in the project * Responsible for team member's assigned workflow details and for proper monitoring of tasks assigned. Responsibilities: * Gathered the business requirements from the client and translated the business details into technical design and specifications. * Designed the application system structure and functional modules. Used the functional document to design application logical and physical structure. * Developed various backend application programs such as Views Functions Triggers Procedures and Packages using SQL and PL/SQL languages. Developed Packages Procedures Functions and Database triggers using PL/SQL. PL/SQL query tuning using Explain Plan optimizers hints Indexing strategies cost measurement etc. Error review log and restudy/recode of the system. Extensively worked in Oracle SQL PL/SQL SQL*Plus SQL* Loader Query performance tuning Created DDL scripts Created database objects like Tables Views Indexes Synonyms and Sequences. Extensively used the advanced features of PL/SQL like Records Tables Object types and Dynamic SQL. * Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN SQL*TRACE TKPROF and AUTOTRACE. * Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE DMBS_SQL and PL/SQL Collections and used BULK Binding involved in writing database procedures functions and packages for Front End Module. * Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application. * Debugged various defects related to implementation of business logic * Interacted with client to gather the requirements and implement the same in the project Responsible for team member's assigned workflow details and for proper monitoring of tasks assigned. Project Summary: India based insurance company, is one of the largest implementations of the product PREMIA 10, an insurance product developed by 3i-infotech Limited to streamline processes to meet the demands of its growing lines of business. The customization of the product PREMIA 10 to meet the requirements of OICL using PL/SQL and Oracle D2K was one of the critical tasks involved in this project. Responsibilities: * Actively involved during data migration and production support for more than 1500 offices of various head, Regional, divisional and branch offices. * Developed and optimized complex stored procedures, functions, triggers to handle complex Business rules and history data * Tuning of the SQL queries, which takes long time to process the request using oracle Explain Plan, Hints to reduce the response time Shikhar Insurance Company Project Summary: Shikhar Insurance Company Limited a Nepal based insurance company, is one of the largest implementations of the product PREMIA 10, an insurance product developed by 3i-infotech Limited to streamline processes to meet the demands of its growing lines of business. The customization of the product PREMIA 10 to meet the requirements of SICL using PL/SQL and Oracle D2K was one of the critical tasks involved in this project. Responsibilities: * Tuning of the SQL queries, which takes long time to process the request using oracle Explain Plan, Hints to reduce the response time * Provided constant technical support for applications to ensure optimal durability and reliability - Investigated and resolved technical operational issues of the applications. * Managed Code and Development Reviews to ensure that the deliverables satisfy the requirements * Ensured assigned deliverables are on time and within the assigned budget * Provided individuals with positive and development feedback and creating Performance Feedback Forms for team members * Attended Weekly Conference Call meetings with clients/counterparts to discuss team tasks, staffing, issues and other concerns. Amana Takaful Insurance PLC Ltd Project Summary: Amana takaful insurance is one of the largest implementations of the product PREMIA 10, an insurance product developed by 3i-infotech Limited to streamline processes to meet the demands of its growing lines of business. The customization of the product PREMIA 10 to meet the requirements of SICL using PL/SQL and Oracle D2K was one of the critical tasks involved in this project. Responsibilities: * Strong development skills in application development and developing Database Packages, Stored Procedures/Function using PL/SQL. * Post production supported the project with any upcoming issues with the Oracle database packages and procedures * Commendable knowledge on all aspects of product development methods - analysis, design, development, testing and problem solving. * Single-Handedly responsible of creating Oracle 10g SQL queries, triggers, procedures functions and Packages for handling the Migration related data's. * Responsible of conducting the weekly status & requirement review meetings w/ biz users Star Health and Allied Insurance Company Project Summary: Largest health implementations of the product PREMIA 10g, an insurance product developed by 3i-info tech Limited to streamline policy and claims administration. The customization of the product PREMIA 10g to meet the requirements of STAR using PL/SQL was one of the critical tasks involved in this project. Also tools like Product Configuration, etc. that helped in achieving certain features with ease were developed alongside using forms. Responsibilities: * Creating Back-end stored procedures, triggers and packages using PL/SQL * Created vital reports using Reports 9i, 10g as per the client's requirements * Perform all levels of data analysis, including data mappings, data feeds, data models, and data transformation. * Fine-tuned the SQL queries by using index strategies and also optimization techniques. * Carried out the Data migration activities which include getting the data from the customer, uploading the same into the database with corresponding validation and verification using PL/SQL and SQL Loader * Support and maintenance of application Testing and bug fixing coordinating with other developers to ensure that daily builds are error free.
Accomplishments
Highlights:
Keywords
