Data Sql

ANITHA CHANDRASEKHARAN NAIR

*** ******* **, *** ***

Phone: +1-614-***-****

Braintree, MA 02184

Email ID: ***********@*****.***

Summary of Professional Experience

Oracle Certified Associate (Certified Year:2017)

Have 6+ years of professional experience in Oracle Database, Oracle SQL and PL/SQL development & Data Warehouse development using Oracle SQL & PL/SQL.

Currently employed with Syntel Inc. as Technical Specialist performing the role of oracle software developer in ESP core team for client State Street.

Lastly employed with Cognizant Technology Solutions as Associate – Projects performing the role of Offshore Lead of Data Migration & Data Warehouse development Stream in Voyager project for the client Affinion group.

Have experience with developing projects for Banking and Financial domains with specific experience in Core banking.

Good skills in requirement gathering, design, development, testing, documentation and implementation using Oracle SQL & Oracle PL/SQL with Oracle 9i /10g/11g backend.

Have experience in doing Extraction Transformation and Loading (ETL) of Operational Data Store (ODS) and Facts and Dimension tables in a Data Warehousing Environment using SQLLDR, Oracle SQL & PL/SQL.

Hands on experience in Performance tuning for SQL Queries and PL/SQL Code snippets like Stored Procedures, Functions, Packages & Triggers in Oracle using DBMS_PROFILER and tkprof utilities

Have hands on experience creating Logical Data Model and Physical Data Model for database for an application based on requirements and data flow information.

Had attended the Oracle trainings and received certificate of completion on

BPEL Process Manager, SOA Suite 10g and Oracle ADF for Forms/4GL Developers.

Good written and verbal communication skills and an able team player.

Skill Set

Languages : Oracle SQL, PL/SQL, UNIX.

RDBMS : Oracle 9.i / 10g / 11g

OS : HP UNIX, Windows 2000

Packages & Utilities : SQL Loader, TOAD, SQL Developer & MS Office 2010

Academic Chronicle

Qualification

Board of Examination

Year of Passing

Bachelor Of Technology (Electronics & Communication)

Kerala University

2006

Professional Experience

Organization

Designation

Period

Syntel Inc.

Technical Specialist

May 2017 - Till now

Free Lance /Volunteer Jobs

Volunteer

Apr 2014 – May 2017

COGNIZANT TECHNOLOGY SOLUTIONS

Associate – Projects

Nov 2012 – Jan 2014

EMSYNE, IT Division of MUTHOOT Group

Sr Software Engineer

Jun 2011 – Nov 2012

BSM BUSINESS SOLUTIONS (Previously SBN TECHNOLOGICS PVT LTD)

Software Engineer

Jan 2009 – Nov 2010

INFOSYS TECHNOLOGIES LTD

Software Engineer

Jul 2006 – May 2008

Certifications

Oracle Database SQL Certified Associate – Certified in 2017

Achievements

Was recognized and awarded the Associate of the Quarter in EIM Insurance Practice in Kochi for helping the Correspondence and Extracts stream of Voyager projects extending beyond the current role of Offshore Lead of Data Migration stream, while ensuring all the expected personal and the team’s project tasks and activities are not affected and have a streamlined delivery.

Was awarded the SPOT AWARD in INFOSYS TECHNOLOGIES LTD for doing Research & Development work on Oracle Business Intelligence and delivering the product on time single handedly.

Details of Professional Experience:

Projects done in Syntel Inc

Title : ESP – Enhancement & Support

Environment : Oracle SQL & PL/SQL in HP UNIX Platform, UNIX, Autosys Jobs

Client : State Street

Duration : From May 2017 till now.

Responsibilities : Senior Oracle SQL & PLSQL Developer

ESP (Enterprise Servicing Platform) is the client’s in-house product that incorporates multiple functionalities like Data Consumption, Normalization, Data Control, Monitoring and Data management, used by State Street as a repository for storing data from its multiple lines of business. The ESP – Enhancement & Support project aimed to design, develop and implement data sourcing solutions for its LOBs based on each business / application requirement. The product also made available the data for reporting needs for each business and application. My primary role and responsibilities were:

Coordinate and meet with Business Analysts and Application teams to analyze requirements for data storage for new application within ESP.

Design, develop and Unit Test ESP Objects, data load processes into the objects and Reporting Queries for new LOB / Applications.

Coordinate with Integration Testing and User Testing teams for Systems testing and UAT for new data load processes.

Support existing data load processes and batches & also support business users with queries and clarifications.

Perform Peer Code reviews and ensure high quality deliverables from the Enhancement & Support team.

Undertake Performance Tuning activities to ensure the queries used in data load processes perform optimally.

Projects done in Cognizant Technology Solutions Ltd

Title : VOYAGER – Data Migration & Data Warehouse Development

Environment : Oracle SQL & PL/SQL in HP UNIX Platform

Client : Affinion Group

Duration : From December 2012 to January 2014.

Responsibilities : Offshore Lead & Senior Developer of Data Migration & DW Development team.

Affinion Group is an affinity marketer of membership, insurance, package enhancement, and loyalty programs with headquarters in Stamford, Connecticut. The Voyager Data Migration & DW Development project is a part of the larger Voyager Program intending to migrate existing Affinion Applications running in a Siebel environment to a new Web based system and to also develop the Data Warehouse environment of the new application. The project concentrated on two aspects – Designing the Data Model for the Helix Database which is the Oracle Database for the new system, migrate the data from Siebel system to Helix and also mapping and loading of the Data Warehouse of Helix Database by ETL jobs using Oracle SQL & Oracle PL/SQL. My primary role and responsibilities were:

Offshore team lead of the Data Migration & Data Warehouse track

Coordinating with the Onsite for requirements analysis, design, coding and Unit testing of Oracle SQL and PL/SQL Code snippets needed for Data Migration.

Coordinating with Onsite for requirement analysis, design, Source to Target Mapping, development and Unit Testing of ETL jobs using Oracle SQL & Oracle PL/SQL to load data into the Data Warehouse of Helix Database.

Prepared UNIX shell scripts to invoke and execute the Oracle PL/SQL and ETL code based on requirement.

Part of the Data Modeling team of Helix Database

Managing daily tasks for the offshore team.

Perform Code reviews and ensure high quality deliverables from the team.

Undertake Performance Tuning activities to ensure the procedures and functions used in data migration perform optimally.

Support SIT, UAT and Production Implementation for Data Migration track of Voyager Program

Projects done in EMSYNE, IT Division of MUTHOOT Group

Title : HARMONY

Environment : Oracle SQL & PL/SQL, .NET Front end with Oracle 11g Database

Client : MMGF (Muthoot M George Foundation)

Duration : From July 2012 till November 2012.

Responsibilities : Designing Logical/Physical Data Model of the application, design & development of Oracle Objects, SQL Query snippets, PL/SQL stored procedures, functions and Packages.

Project Harmony aims at automating the process of Muthoot’s charitable wing MMGF. The complete process of gathering new applications for financial help along with its applicant/beneficiary details, validating the same, enabling the approval/rejection process and disbursal of the approved amount are automated as part of this project. The application User Interface is being developed using .Net and the business logic is implemented using Oracle PL/SQL Stored Procedures / Functions and Packages. My primary role and responsibility included Logical/Physical Data Modeling of the application, design and development of the Oracle Objects, SQL Query snippets, PL/SQL procedures, functions and packages, Performance evaluation and Tuning, Unit testing, Coordination for SIT & UAT and Production Implementation.

Title : CORE BANKING SYSTEM

Environment : Oracle SQL & PL/SQL, .NET Front end with Oracle 11g Database

Client : Muthoot Finance

Duration : From June 2011 till November 2012.

Responsibilities : Designed & Developed Oracle Objects, SQL Query Snippets, PL/SQL stored procedures, functions and Packages for Core Banking Application modules like Loans, Deposits, Accounting & Bond systems. Also performed SQL Query and PL/SQL Code Performance Evaluation & Tuning. Supported the Application, post-production implementation doing BAU enhancements and Bug fixes.

Core Banking Solutions (CBS) Project aimed at developing a complete end to end banking solution with application modules like Loans, Deposits, Accounting and Bonds for the Muthoot Finance group. The application User Interface was developed using .Net and the business logic was implemented using Oracle PL/SQL Stored Procedures / Functions and Packages. My primary role and responsibility included design and development of the Oracle Objects, SQL Queries, PL/SQL procedures, functions and packages, Unit testing, Coordination for SIT & UAT and Production Implementation. Was also involved in Performance evaluation and performance improvement for SQL queries and PL/SQL code snippets used in the application. As part of post-Production implementation, we also supported the application doing BAU enhancements and bug fixes.

Projects done in BSM BUSINESS SOLUTIONS

Title : Planned Maintenance System

Environment : Oracle SQL, Oracle PL/SQL and ADF Frame work in JDeveloper 11g IDE with Oracle 10g.

Client : Bernhard Schulte ShipManagement

Duration : From July 2009 till April 2010.

Responsibilities : Developed Oracle SQL Queries & PL/SQL stored procedures, functions and JSF WebPages for Equipment and Job Master Data Management modules using ADF framework in JDeveloper IDE.

Bernhard Schulte ShipManagement is a highly integrated maritime services company and a market leader in quality, versatility and fleet size. The IT division of BSM partnered with SBN Technologics to create an ERP system for BSM. PMS – Planned Maintenance System is a part of the ERP system for BSM. The system helps in Job Master Data Management, which contains scheduling of planned as well as unplanned Jobs and execution of jobs, and Equipment Master Data Management. As a part of the PMS team I was involved in development, unit testing, Supporting IT & UAT of Oracle SQL Queries and PL/SQL Procedures and Functions as well as the Front end ADF data entry forms for both the Job and Equipment Master Data Management modules.

Title : Job Order System

Environment : Oracle SQL, Oracle PL/SQL and ADF Frame work in JDeveloper 11g IDE with Oracle 10g.

Client : Bernhard Schulte ShipManagement

Duration : From January 2009 till July 2009.

Responsibilities : Developed Oracle SQL Queries & PL/SQL stored procedures, functions and JSF WebPages for JO System using ADF framework in JDeveloper IDE.

JO System is the sophisticated project management software that was developed for project management activities for BSM. This software enables the PM, PL and Team Leaders to Schedule skills that include analysis of the critical path using slack and delay data to optimize the use of resources, to finish their projects as early as possible. Tracking actual performance in terms of hours of work and completion dates builds a database which helps the project managers to estimate project duration while planning next project. JO system also provides the resources to view their daily/weekly/monthly schedule and can enter their time sheet.

Projects done in INFOSYS TECHNOLOGIES LTD

Title : Interfacing Oracle Field Service and Enterprise Asset Management / Work in Progress modules.

Environment : Oracle SQL, Oracle PL/SQL and Oracle Custom forms with Oracle 9.i in HP UNIX Platform

Client : Exterran

Duration : From July 2007 till March 2008.

Responsibilities : Developed Oracle SQL Code, PL/SQL stored procedures, packages and functions using Oracle seeded APIs and Open Interfaces.

Exterran is an Oil and Gas Company that manufacturers and rents Compressors, Compressor Packages and Engines. The CRM (Customer relationship management) stream of Infosys is working for the Services Excellence team which focuses on the Maintenance of Rental Compressors/Packages/Engines by Exterran. Field Service in itself is a complete module that can be used to create Service Requests and debrief for labor and material incurred by Exterran, on these repairs to charge the customers. Enterprise Asset management/WIP module is a parallel module which does costing of labor and has preventive maintenance schedules which is not possessed by Field Service. So we developed interfaces to exchange information between these two modules so as to use the functionalities provided by both to meet the requirements.

Title : DBI (Daily Business Intelligence) Reports for FS module.

Environment : Oracle SQL, Oracle PL/SQL with Oracle 11.i in HP UNIX Platform

Client : Exterran

Duration : From January 2007 till July 2007.

Responsibilities : Handled DBI Reports for FS (Field Service) module, did Requirement gathering, Designing, Development and Testing of the Custom DBI Reports single handedly and delivered it on time.

DBI (Daily Business Intelligence) being a fairly new technology, had done Research and Development work on DBI and came up with the suitable solutions. The development was done for four Main DBI Reports and two sub Reports for each of them, which will display online details of the task performed by the technicians, the various details of the Service Request in the Field Service module with the graphs and KPIs.

Title : Oracle Account Payables.

Environment : Oracle SQL, Oracle PL/SQL, with Oracle 9.i in UNIX Platform

Client : Exterran

Duration : From December 2006 till January 2007.

Responsibilities : Developed Control files, SQL script, PL/SQL stored procedures for Data loading and Interfacing for Oracle Account Payable Module.

The Data obtained from a legacy system is used for the creation of invoices, data is loaded into staging table using control file, the scheduled concurrent program will take the data from the staging table, validates it and will insert it in to open interface tables, which in turn will be used by a standard concurrent program for the creation of invoices.

Contact this candidate