Data Sql
Resume:
ANITA SINGH
PROFESSIONAL SUMMARY:
•Over * years of experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), Design, Testing Methodologies and Production Support and Implementation of Business Applications using the Oracle Relational Database Management System(RDBMS).
•Strong experience in developing distributed enterprise applications as well as Data warehouse.
•Development, testing and Maintenance business application development using Oracle 9i and Oracle 10g.
•Database programming with Triggers, Functions, Packages, Procedures Sequences and Ref-cursor.
•Experience in Performance Tuning & Optimization of SQL statements.
•Expertise in preparing Requirement Analysis, Functional Specs, Design Document & Program Specification
•Good experience in generating reports and letter using jasper (ireport).
•Strong Background in implementation of RDBMS and OOPS concepts.
•Good knowledge of UNIX command and shell script.
•Worked on materialized views like primary key, rowid, and sub query materialized views.
•Quick learner and a proactive individual with good communication and strong analytical skills, able to quickly grasp complexities and identify opportunities for improvements and resolution of critical issues
•Domain knowledge of telecom and insurance
•Experience in working in agile team.
TECHNICAL Profile:
Languages
Oracle 9i, Oracle 10g, SQL server 2008
Internet Technologies
XML, HTML
Operating System
DOS, Windows 2000/NT/XP, Linux. Unix
Database/Tools
Toad, SQL developer, SQL plus, putty
Version Control
SVN, VSS, Clear case
Reporting tools
Jasper Report, Oracle forms 10g, Report builder 10g
ETL tools
Data Junction, Talend
PROFESSIONAL EXPERIENCE
Client name:-Massachusetts Trial Court Feb 2017 – till date
Role:-PL/SQL Programmer Analyst
The Massachusetts Trial Court is composed of seven court departments with unique jurisdictions and responsibilities.
The Trial Court is committed to:
Fair and impartial administration of justice;
protection of constitutional and statutory rights and liberties;
equal access to justice for all in a safe and dignified environment;
efficient, effective and accountable resolution of disputes;
Prompt and courteous service to the public by committed and dedicated professionals utilizing best practices in a manner that inspires public trust and confidence.
Responsibilities:
•Analysis, Design and developed scalable and reusable database processes.
•Design and develop ETL jobs to perform complex processes.
•Designed, modeled and implemented Data Warehouse and Data Mart: tables, indexes, procedures, packages and UNIX configuration.
•Worked on creating XML for 4 million records using XMLAGG and XMLFOREST function in Oracle.
•Involved in parsing XML for inserting the records in mass courts tables.
•Involved in creating scripts for backend updates (like charge disposition of defendant).
•Involved in creating packages and procedure for Juvenile probation module.
•Involved in writing UNIX batch scripts to automate the process.
•Involved in performance tuning activity to improve the performance of query.
•Involved in data conversion activities.
Client name:-Union Privilege August 2016-Jan 2017
Company Name: - Info group Inc.
Role:-Database Developer
Union Plus benefits offered by the AFL-CIO's Union Privilege provides consumer savings, discounts, benefits, and education resources to active and retired labor union members and their families save money and support them through major milestones, celebrations and hardships.
Responsibilities:
•Design and develop scalable and reusable database processes.
•Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
•Design, code, and test major features, as well as work jointly with other team members to provide complex software enhancements for database.
•Design and develop ETL jobs to perform complex processes.
•Develop UNIX and Perl script for data auditing and automation.
•Construct and design documents and documentation to aid in maintenance and code reuse in accordance with team processes and standards.
•Develop strong working relationships with managers and analysts.
•Designed, modeled and implemented Data Warehouse and Data Mart: tables, indexes, procedures, packages and UNIX configuration.
•Developed PL/SQL packages to load Data Warehouse and Data Mart tables to satisfy the subscriber’s needs.
•Participate in code reviews in accordance to standards.
•Analyze data needs and independently develop logical and physical data models.
•Understand and work with data in with varying degrees of complexity and scale.
•Assisted in data analysis, star schema data modeling and design specific to data warehousing and business intelligence environment.
LA Care (Los Angeles CA) Jan 2016-July 2016
Sr. Oracle PL/SQL developer
L.A. Care is a leader in developing new programs through innovative partnerships designed to provide health coverage to vulnerable populations and to support the safety net.
Responsibilities:
•Developed PL/SQL Packages, Functions, Procedures, and Triggers to implement the Business Logic.
•Worked on PL/SQL Tables, Records and Collections (Nested table)
•Worked on Global temporary table as a part of performance tuning.
•worked on profiling and tracing PL/SQL program to analyze the execution of program in order to enhance performance of program
•Created Tables, Indexes, and Views, Sequences, Synonyms and stored program units.
•Involved in end to end testing and defect fixing And Involved in database design.
•Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
•Performance tuned stored procedure, function, view, trigger and query by utilizing indexes, partitioning, Explain Plan, SQL Trace & TKPROF utilities.
•Involved in designing Oracle forms and reports for the project.
•Involved in UNIX shell script using bash, ksh.
•Created and modified several UNIX scripting according to changing needs of the project and client requirement.
VPI Oct 2012 to Feb 2013
PL/SQL Developer - Project: - VPI (Veterinary pet insurance) offshore location
VPI uses application for making policy of pet like canine, reptile etc. for different counties in USA. Different product are available for pet accordingly coverage can be calculated. System can endorsed that policy. Claim can be done on that policy. Automatic denial of claim is possible in the system. Product has to be configured against each pet.
Responsibilities:
•Worked on File Handling for creation and updating of file.
•Fine tuning SQL queries to improve the execution time.
•Involved in activity for migrations of Oracle 9i to Oracle 10g.
•Developed UNIX Shell scripts to automate repetitive database processes.
•Performed debugging of the PL/SQL codes using the DBMS_OUTPUT.
•Participated in application planning, design activities by interacting and collecting requirements from the end users.
•Create indexes on some columns of tables to increase the applications performance
•Written PL SQL cursors for transaction processing
•Participated in the weekly status meetings, code reviews and requirements gathering meetings
Environment: Oracle 9i/10g, PL/SQL, SQL developer
Responsive Insurance Inc. (Florida worked from offshore) Oct-2011 to Sept-2012
Pl/SQL Developer
Responsive uses application for making policy of different vehicles of different counties in US. Rating can. Be done based on different factors of policy like age of drivers, No of drivers for that vehicle etc. There are four system involved in this project PAS (policy administration system) POS (point of sale) claims and Billing. All systems are dependent to each other. In PAS policy can be underwritten. Whereas in POS policy can be endorsed and renewed. POS is used by only policy agent
Responsibilities:
•Created Tables, Indexes, and Views, Sequences, Synonyms and stored program units.
•Coded complex SQL queries to retrieve data from the database depending on the business logic.
•Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
•Created Stored Program Units like Functions, Triggers and procedures for implementing complex database intensive business rules.
•Worked on DBMS_STATS and DBMS_PROFILER to enhance performance of PL/SQL programs.
•Managing Partitioned tables and Indexes for efficient and robust access of data.
•Written PL/SQL cursors for transaction processing.
•Worked on DBMS_SCHEDULER to schedule jobs.
• UTL_FILE to read and write from database.
•Involved in writing complex queries to generate reports as per client request as a part of production support.
Environment: Oracle 9i/10g, PL/SQL, UNIX, SQL developer
Elixir – UK Aug -2010 to July-2011
Software Developer
The Legal & General Group, established in 1836, is one of the UK’s leading financial services companies. Over 5.8 million people rely on them for life assurance, pensions, investments and general insurance plans. The software product developed for L&G is for Group Life Insurance, wherein the following Modules are taken care of:
Quotation: This module creates quote which includes the approx. premium amount to transfer the risk.
New Business: This module helps in creation and activation of Policy with accounting information.
Scheme Admin: This module handles the policy servicing.
Medical Underwriting: This module handles the medical underwriting for the specific members whose benefit amount is greater than a fixed amount for any product and the fixed amount is known as Free Cover limit.
Reinsurance: The module handles the re-transfer of risk of the insured to any reinsurance company.
Claims: This module handles the claim.
Finance: This module handles the generation of invoice, receipts and payments voucher.
Interface: This module handles the interaction between all the modules.
Responsibilities:
•Developed PL/SQL Packages, Functions, Procedures, and Triggers to implement the Business Logic.
•Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, TKPROF, Explain Plans and Trace Sessions.
•Rebuilding the Indexes for performance of SQL Queries with the help of INDEX_STATS.
•Used BULK COLLECT and BULK BINDING to minimize the execution time of PL/SQL code.
•Worked on PL/SQL Tables, Records and Collections.
•Created database objects like tables, views and used them to generate reports based on requirements using crystal reports.
•Worked on Database Link to import/export data.
•Used Pragma Exception INIT directive to associate selected exception name with oracle data base error number
•Created XML using XMLGEN package.
•Created reports using the source as XML by using reporting tools jasper.
•Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
Environment: Oracle 9i/10g, PL/SQL, SQL developer, Jasper ireport
Reliance Tech Services Ltd June 2009-June 2010
Client: Reliance Communication
SDP ERDB is the central database of E recharge system which consists of table, SP’s, views and other attributes of the DTH business. Application consists of Registration of different type of Dealers (i.e. Distributor, DSR and Retailers. It includes the processes where amount can be added and reversed from distributor’s account. Processes which are used to transfer amount to DSR’s and Retailers account.
Responsibilities:
•Developed various Procedures and Functions with Ref Cursor output Based on Business Requirements.
•Involved in End-to-End testing of a projects.
•Worked on Advanced Pl/SQL Concepts such as Bulk Collect, Bulk Bind and Composite Data Types.
•Worked on Collections Such as Nested Tables to Ignore Master and Child Table Relations.
•Worked on Util_File Package for Transfer the Data from Data Base to File and File to Data base Vice versa.
•Developed Various Queries, Sub Queries and Utilized Oracle Set Operators for various Conditions.
•Worked on Performance Tuning for Critical Queries and Modified the Procedures to Optimize the Execution Time.
•Created Tables, Indexes, Views, Synonyms and other objects.
•Prepared Technical Documentation, Test Documentations,
•Providing the Support to Production Team, Testing Team (SAT)
•Involved from the first drop till update to date change request.
Environment: Oracle 9i/10g, PL/SQL, UNIX, TOAD
Reliance Communication Aug 2008 to June 2009
SDP (Service Delivery Platform) is the central database of DTH which consists of SPs, Tables, Views and other attributes of the DTH business. The Application consists of end to end DTH system includes Pre-enablement of service, CAF entry, Service level MACDs and Offer level MACDs. CAF process consists of two sub process as Customer Creation and Service Creation. MACD process includes offer purchase, cancel, suspend and resume of service etc. Systems will interact with each other thru TIBCO as well as direct call thru dB link. The system like Billing and IVR are using the dB link to validate the customer / offer status. Transaction table is used to track the transaction across the system.
Responsibilities:
•Developed various Procedures and Functions with Ref Cursor output Based on Business Requirements.
•Involved in End-to-End testing of a projects.
•Worked on Advanced Pl/SQL Concepts such as Bulk Collect, Bulk Bind and Composite Data Types.
•Worked on Collections Such as Nested Tables to Ignore Master and Child Table Relations.
•Worked on Util_File Package for Transfer the Data from Data Base to File and File to Data base Vice versa.
•Developed Various Queries, Sub Queries and Utilized Oracle Set Operators for various Conditions.
•Worked on Performance Tuning for Critical Queries and Modified the Procedures to Optimize the Execution Time.
•Created Tables, Indexes, Views, Synonyms and other objects
•Prepared Technical Documentation, Test Documentations, Release Documentations Based on SRS
•Providing the Support to Production Team, Testing Team (SAT)
•Involved from the first drop till update to date change request.
Environment: Oracle 9i/10g, PL/SQL, UNIX, TOAD
Bright corner PVT Ltd Jan 2007 to Feb 2008
Client: Backgroudcheck
Background checks is the US Company which keeps the records of Criminals of all county have and state. The Client provides raw data files which is categorized according to the offense of criminal according to which different database is maintained of for different counties. Raw File is transformed using DJ Cosmos tool & the data is then loaded in SQL Server Database. After the database is created, various Validation scripts are run on the database to check integrity of data by creating various stored procedure/function as per the business Logic. Project includes the various methods for getting raw files. Either clients provides the raw file or Data can be extracted from different sites using Dot Net code
Responsibilities:
•Requirement gathering and Analysis.
•Prepare the required unit test cases for assigned modules
•Writing SQL Query, development of stored procedures
•Creation of Triggers to maintain the records of deleted data from tables
•On time delivery to client side using FTP server.
•Writing scripts on DJ Cosmos tools for data accuracy
•Writing Queries for cleaning of database i.e.(removal of special character)
Environment: - MS SQL server 2005, Data junction (ETL tools)
Education: Master of computer Application (M.C.A.) from Ranchi University
B Sc. (Computer Science) from Ranchi University
Contact this candidate