Resume

Sign in

Oracle Pl Sql developer

Location:
Farmington Hls, Michigan, United States
Posted:
December 31, 2018

Contact this candidate

Resume:

Anitha Ramaswamy (ac727y@r.postjobfree.com)

Phone Number: 740-***-****

PROFESSIONAL SUMMARY:

14+ years of Software Development experience in the various facets of PL-SQL Development, ETL– Requirements Elicitation, Data Modeling, ETL Design, Implementation and Reporting Solutions

Good knowledge in ETL Architecture, Data Warehouse Design and Development, Data Conversion and Data Migration

Worked with various clients in Banking, Financial and Insurance domains.

Worked on Trans union credit data analysis,development and reporting.

Designed logical and physical data models using ER/Studio Architect for the credit application.

Expertise in development of complex queries, development of Database objects and stored procedures using PL/SQL for data processing and reporting.

Expertise on Database schemas, Complex Queries, Stored Procedures, Triggers, Cursors, Index and Collections.

Expertise in Query performance tuning and optimization.

Experienced in dynamic SQL, PL/SQL Collections, Exception handling and tuning.

Worked on materialized views, pipelined function and large object handling.

Analyzed the requirements and translated requirements to Logical and Physical Data Model using ERWIN tool.

Knowledge on Relational Models and Best Practices for Data Modeling.

Translated complicated enterprise specific Business rules into appropriate Business logic components such as Stored Procedures and Triggers.

Experience in Software Design, Development, Testing and implementation of Client/Server Applications Using Java.

Experience in Software Development with sound knowledge of Manual and exposure to Automated Testing of Web-based and client server applications

Extensive business knowledge in handling customer queries in banking domain

Excellent understanding of CMMI audit procedures.

Developed good process consulting skills and suggested process changes, generating cost benefit scorecards, metrics reports and provide PMO support.

Excellent Oral, written, communication skills, interpersonal and time management skills.

Analytical, Quick Learner, Excellent problem solving and debugging skills, possesses excellent communication skills, Team Player and will prove a valuable asset to any organization.

TECHNICAL SKILLS:

Programming Languages

SQL and PL/SQL, Shell scripting

Core Java, JDBC, JVM, Java Swings, EJB, JAXB and Web Methods 6.0

Database

Oracle 9i, 10g, 11g,12c

Configuration management tools

Visual Source Safe, Clear case, SVN

Operating Systems

UNIX, Windows (3.x, 95, NT, 2000, XP)

Development Tools

Toad, SQL Developer, Tableau, SQL *Loader, WSAD, Eclipse

Other Tools

ER/STUDIO Architect, Talend data integration, JIRA, ERWIN r8.0, HP Quality Center, MS VISIO

EDUCATION & EXPERIENCE:

B.E in Electrical & Electronics from Government College of technology, Coimbatore, India.

M.S (Software Engineering) from Birla Institute of Technology & Science, Rajasthan, India

12+ Years worked in Cognizant technology Soln US Corp/India for various clients (JP Morgan & Chase and MetLife).

2+ Years working in Openwave computing for IHS Markit Client.

PROFESSIONAL EXPERIENCE:

Openwave Computing

Client - IHS Markit

Polk Connect (South Field- Michigan) October 2016 –Till Now

Lead Developer

Polkconnect application generates various dashboards for customers, vehicle services and campaign services. Also provides the KPI for customers. It offers features for the dealers to generate service related campaigns and parts related campaigns and share with the other dealers in the same group.

Responsibilities:

Understanding the business cases from JIRA and translate them into technical specifications.

Performing impact analysis of the enhancements.

Designing table changes needed whenever new markets introduced to the system.

Creating jobs to extract data from warehouse, transform to datamart by applying business rules.

Scheduling jobs in the job monitor and execute them on a monthly basis as well as for new market onboarding.

Perform data aggregation related activities to speed up some online processes.

Developing packages and stored procedures for business requirements.

Worked highly on SQL query tuning, stored procedure optimization and code rewriting of existing application.

Worked on data cleansing process and generate the match keys to identify unique records.

Perform code review for the software defect fixes by team members.

Prepare scripts for the defect fixes and deploying the code in higher environments.

Prepared dataflow and process flow diagrams for the existing application.

Getting the credit data and categorize into various credit bands and generating reports based on credit score ranges.

Development Environment:

o Oracle 12c, Advanced PL/SQL, SQL, Tableau charts, JIRA.

Cognizant Technology Solutions

Client - MetLife

Group life (Greenville-SC) Sep 2011 – Mar 2016

Team Lead

The group life systems had multiple applications which required Adhoc reports to be generated for large volumes of data.

Responsibilities:

Involved in requirements gathering, analysis, estimation, design and testing activities of project.

Created Oracle PL/SQL packages, procedures, functions using Toad.

Created Oracle PL/SQL scripts to perform data extraction, manipulation and loading of CSV, and flat-files.

Maintained the existing data model and added new tables to the

Performed Internal Quality review for various group life applications.

Suggest the process changes and templates required to meet the CMMI level2 standards.

Providing PMO support for Electronic death match and Path finder projects.

Generating Client specific scorecards on the expenses for the Client specific activities.

Using AD, UAT defects and Production defects conducted defect prevention meetings with the team and reporting the AD and PM metrics to MetLife senior management.

Co coordinating various insurance product teams to produce volumetric report with the details about insurance policy, billing, premium etc... information for each products and services offered on a half yearly basis

Generated monthly metrics report for various insurance applications to give an overall understanding of how AD releases are progressing which will showcase how the change requests are impacting the application and causing production defects.

Helping the team to come up with the estimations for their projects

Performing estimation audits for the estimations created by the development team.

Environment

o Languages :PL/SQL, SQL, Shell scripts, SQL loader

o Database : Oracle 9i,10g

o Operating System: UNIX

Languages UNIX, Oracle, PL/SQL, TOAD, SQL Developer, SQL Loader and Erwin Data modeler.

Cognizant Technology Solutions

Client - JP Morgan & Chase

Client Central (Columbus-OH) Dec 2010 –Aug 2011

Project Lead

Client Central (CC) is conceptualized to be the authoritative source for wholesale party information within JPMC and would include information regarding both active and prospective clients, parties acting in third party roles between JPMC and its clients, vendors, and parties to support instrument reference data (e.g. issuer, exchanges, and regulatory bodies). The project has two types of interfaces both thick and thin. The thick UIs comprise Java Swing and this will be installed in all the client systems. The thin client comprises JSP, Java Script, HTML and Struts framework. All the server components were deployed in Web sphere and the back end is Oracle. The clients can use any UIs they need. The Client information and relationships will be maintained with the help of these online screens.

Responsibilities:

Involved in project requirement analysis, estimations and design activities.

Translated client data requirement s to logical data model using ERWIN modeler.

Created and maintained data model whenever there are new table requirements.

Generated DDL for DB objects.

Created relational model for customer and account creation.

Provided estimations, assigned tasks to team members and tracked the tasks to closure and delivered modules on time.

Developed packages, procedures, function to implement business requirements.

Developed stored procedures using REF cursors, dynamic queries and dynamic tables.

Worked on SQL query tuning, stored procedure optimization, error logging and debugging activities.

Response to user queries and clarification on client central application.

Scheduled the defects reported by users in BAU releases.

Conducted defect review meetings with Client Managers.

Offshore support by providing functional and technical solutions.

Design review and code review of software defect fixes for BAU release

Deploy the code in testing environment for IST and UAT.

Provide necessary steps and test data for user sign off for the defect fixes.

Production deployment and verification for Quarterly BAU releases.

Interaction with Index production support team for Index related issues.

Reviewing production support cost statistics on a monthly basis.

As a member of Design review team, performed code review and design review activities

Responsible for ensuring quality of delivery.

Environment:

o Languages : PL/SQL, SQL, SQL* Loader, Java, JSP, Servlets, JavaScript, Struts, EJB, Blaze Advisor 7.2

o Methodology: OOAD methodology.

o Database : Oracle 10g, 11g, ERWIN r8.0

Cognizant Technology Solutions

Client - JP Morgan & Chase

Client Central (Chennai IND) Jul 2007- Nov 2010

Sr PL/SQL Developer

The objective of Client Central project was to deliver the new functionalities requested by various Lines of Business (LOB) and involved conversion and migration of data related to these new functionalities. As a result of JPMC’s accelerated effort to consolidate more customer data into Client Central, migration of customer data with complex business mapping, and capturing and processing were also included in the scope of the project.

Responsibilities:

Worked on ad-hoc report requests from various LOBs which required time consuming data manipulations using Oracle.

Worked on Oracle database Triggers to invoke server side components.

Handled Ad-hoc report requests from various LOBs which required time consuming data manipulations.

Provided scripts to deployment team, verifying the implementation in the UAT environment.

Responsible for preparation and implementation of data scripts relating to JPMC P1 and P2 (Priority 1 and 2) issues having high business impact across LOBs like IB, PB, TSS and CB within the said SLA.

Analyzed and implemented the solutions for data integrity issues and Oracle performance tuning requirements at the database level that might result from possible application/software level defects.

Automated the reports using Unix shell scripts and sent reports to LOB Admin(s) on a periodic basis.

Developed excellent technical and application specific skills by working in Oracle technologies and Core Java.

Performed the requirement analysis, estimation, design review and code review.

Detailed knowledge of the business needs and design of the Client Central system.

Environment:

o Languages :PL/SQL, SQL, Shell scripts, Java, JSP, Servlets, JavaScript, Struts, EJB, Blaze Advisor 5.5

o Methodology: OOAD methodology.

o Database : Oracle 9i,10g

o Operating System: Solaris 5.8

Used Oracle and Toad IDE for enhancements of the database components and procedures. Web Sphere 6.0 is used for deploying the application and Clear case is used for configuration management.

Cognizant Technology Solutions

Client - JP Morgan & Chase

Client Central (New York City-NY/Chennai-IND) Oct 2005-Jun 2007/May 2004- Sep 2005

Pl/SQL & Java Developer

The objective of Client Central project was to deliver the new functionalities requested by various Lines of Business (LOB) and involved conversion and migration of data related to these new functionalities. As a result of JPMC’s accelerated effort to consolidate more customer data into Client Central, migration of customer data with complex business mapping, and capturing and processing were also included in the scope of the project.

Responsibilities:

Design of Reporting Modules which can be used for reporting purposes.

Development of UI screens for Report Manager using Java Swings

Development of Server module which executes the queries and converts the data to XLS file.

Development of PL/SQL Queries and Stored procedure.

Designed screens to Client creation, Account creation, Merge accounts & Reporting.

Wrote load balancing server side code, when multiple huge reports running at same time.

Lead the BUILD and IST Testing team for multiple build releases.

Worked on customization of reports based on user credentials.

UTP preparation and testing all the functions of UI screens and report.

Test plan and test scenario preparation and testing of client manager, hierarchy manager and report manager modules.

Test design, test execution and defect tracking through Quality center.

Offshore coordination of testing activities.

Performed automated core regression testing using silk test scripts.

Developed the help module.

Conducted UAT exit and entry toll gate meetings.

Environment:

o Languages :PL/SQL, Java, JSP, Servlets, JavaScript, Struts, EJB, Blaze Advisor 5.5

o Methodology: OOAD methodology.

o Database : Oracle 9.1

o Operating System: Solaris 2.6.

Cognizant Technology Solutions

Client - ING VYSYA

ING Surround Replacement (Bangalore-India) Nov 2002-May 2004

Java Developer

ING provides online services to its customers via ING Access web application, where participants are able to view their Account details and perform transactions on internet. The customer data to display on ING Access is stored on different servers depending on the products.

ING Access retrieves data to display via system called ‘Surround’. Currently, Surround retrieves data from respective servers when requested from ING Access and sends it back to ING Access. There are few other applications that require same or more data from Surround. Surround does not integrate data needs of all the systems and it utilizes old (outdated) technology. Hence, to reduce the high maintenance cost of Surround and to get advantage of latest technology, Information Integration Services (IIS), a Surround replacement will be implemented

Responsibilities:

Analysis and design of project requirements.

Organized the training sessions on web methods for new trainees.

Leading the team by giving technical guidance

Preparation of High level and low level design document for the project

Preparation of POCs for the project decisions.

POCs to communicate to document literal Web Service through Java client.

Environment:

o Languages : JAXB, JAVA, Web Methods Developer 6.5, Integration Server 6.5, and Modeler 6.5, web Methods JDBC Adapter

o Methodology: OOAD methodology.

o Database : Oracle 9.1



Contact this candidate