Resume

Sign in

Data Developer

Location:
Norristown, Pennsylvania, United States
Salary:
120000
Posted:
February 21, 2018

Contact this candidate

Resume:

Meenakshi Sundaram Chellappa

Tech Lead - Oracle PL/SQL & ETL Developer

Email: ac4kca@r.postjobfree.com

Cell: 484-***-**** / Home: 484-***-****

PROFESSIONAL SUMMARY

14+ years of IT experience with skills in Design, Development, Administration and implementation of various projects using Object Oriented and Multidimensional Analysis. Involved in full life cycle development including Design, ETL strategy and Troubleshooting. Worked extensively with Investment Banking and Finance Domain.

Working as Oracle PL/SQL and ETL Developer on variety of Window and UNIX platforms with Oracle 12c/11g/10g/9i/8i.

Oracle Certified Associate (OCA) and Oracle Certified Professional (OCP)

Worked with clients in different domains like Banking, Investments, Finance and Telecom.

Experienced on complete Software Development Life Cycle (SDLC) using various methodologies like Agile, Scrum and Kanban dashboard, Waterfall Model

Strong experience in Data Migration, Data Conversion and Oracle PL/SQL scripts.

Extensive hands-on experience in using database languages SQL and PL/SQL.

In Depth Knowledge of Performance Tuning of Oracle procedures.

Solid experience in loading data using tools like Export / Import/expdp/impdp, good knowledge on utilities like Tkprof.

Sound experience in fine tuning the database using utilities like SQL Tuning, SQL trace, Explain plan.

Expertise in stored procedures, Functions, Triggers and necessary test plans to ensure the successful execution of the data loading processes.

Worked with database objects such as Views (including Materialized Views), Stored procedures, Functions, Triggers, Sequence Generators and Partitions on Oracle.

Worked on Oracle Object types, analytics, BulkCollects, MultiSet.

Worked with Various Oracle Developer tools such as Toad, PL/SQL Developer, SQL Tools, SQL Developer and PRO*C.

Analyzed tables and indexes for Cost Based Optimization (CBO) for improving performance and work efficiently

8+ years of Data warehousing ETL experience using Informatica Power Center and Oracle Warehouse Builder (OWB) tool, working in Master Data Management (MDM), Big Data and Data warehouse.

Extensive experience in developing ETL processes to extract, transform and load data from various source systems into Data Warehouses and Data Marts.

Proficient in using Informatica Workflow manager, Workflow monitor, Server manager, pmcmd (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.

Involved in analysis, design, testing and deployment and loading of data from heterogeneous source systems to the warehouse according to the end users requirements.

Strong understanding of the principles of DW using Fact Tables, Dimension Tables, Star and Snowflake schema, data vault modeling.

Extensively used transformation such as Source Qualifier, Expression, Filter, Router, Aggregator, Rank, Joiner, Sequence Generator, Normalizer, Look Up and Update Strategy to implement complex business logic.

Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ER Studio and ERWIN.

Team player, enthusiast and quick learner with excellent communication skills.

Role included active interaction with Leads for Development, Technical, DBA, Configuration Management, Interfaces, Production Support, and entire Project management team. Primary POC providing daily and weekly status for functional testing via status calls, and status reports to Client and internal PMO team.

Ability to work effectively in cross-functional team environments and experience of providing training to business users.

Knowledge in JAVA/J2EE/AngularJS and JUnit creating web services development experience and testing in SOAP UI.

Creating new screens by using Application Development Framework (ADF)

Strong exposure in Crystal Reports XI/8.5/8.0. Business Objects development oriented reports for Banking, Investments, Telecom, financing, retail, insurance, costing, payroll and billing statements formatted in systems

TECHNICAL COMPETENCIES

RDBMS:

Oracle 12c/11g/10g/9i/8i,MS SQL Server 2005, MS Access, MySQL

Database Tools:

SQL* Loader, SQL* Plus, Toad, PL/SQL Developer, Oracle APEX 4.0,SQL Navigator, Oracle ADF Faces, Putty, ER Studio 9.5/11, ERWin 3.5.2

Reporting Tools:

Crystal Reports 8.5, BI Publisher, BOXI

Environment

Windows XP/NT/2003, UNIX and Linux

Languages:

SQL, PL/SQL, Java, EJP, PHP, VB.NET, VS 2005, C, C++, PRO*C, XML

ETL Tools:

Informatics Power Center 10x/ 9.x/8.6/8.1, Oracle Warehouse Builder (OWB).ODI

Other Tools

Star Team, BMC (Magic Ticket), CONTROL-M, SOAP UI and hp Quality center, Rally, Confluence, Fittness, Docker, Jenkins, Source Tree and GIT Status, Fitnesse, WinSP

PROFESSIONAL EXPERIENCE

Client: SEI Investments, Oaks PA (Dec. 2012 – Till Date)

Scope: Development/Maintenance

Industry Practice: Investment Banking (Wealth Management)

Project: SEI Wealth Platform (SWP)

Module: Iron Horse - Custody

Role: Tech Lead (Oracle PL/SQL and ETL Developer)

SEI is a leading global provider of comprehensive wealth management solutions to Manager of Banks, Trust & Private Wealth Institutions, Investment Advisors, Investment Managers, SEI Wealth Network for families and Individuals.

SWP is Developing Agile and Scrum methodology. Mutual Fund Process for Custody developing Charles Schwab, NSCC, DTCC, DST Orders and Confirm Mutual Fund Processing, Custodian Accounts, Fund Accounts, Nostro Accounts, Income and Dividends, Long Term and Short Team Capital Gain. CSTOA, Account Maintains, Firm Branch Report, Global (Multi Currency) Net Settlements, Custody Net Settlements, Fill Pricing, Order Incitation, Trades, Transactions, Activity Services, Currency Movement, Cash Receipt, Free Movements, Receiver Authorized Delivery (DTCC RAD), Tax, Fees Services, Contribution, Distribution, Withholding, Currency Sweep Models, Accounting, Portfolios and Firms Details,

Account Settlement and Information services, Equities, Corporate and Municipal Bonds, Government Bonds, Money Market Instruments, Money Market Reform, NSCC UFA, Currency Sweep Characteristics and Loaders, Asset Services and Securities Processing.

ONESOURCE - Tax and Accounting (PAN) maintains Global Tax Services.

RR Donnelley (RRD) - Client Account Address details maintains.

Envestnet - Client Account and Firm broker details maintains.

Wells Forgo Bank – Mutual Fund Process, Money Market, Monet Market Reform, Equity, Bonds, Account and Portfolios Maintains.

Responsibilities:

Creating PL/SQL Packages, Stored Procedures, Functions, Cursor and Triggers to implement the Business Logic and developing various Transaction handlers for the web service application.

Designed and Developed ETL Interfaces using PL/SQL Stored Procedures, UTL_FILE, External Tables, SQL*Loader Oracle Utilities for the Staging Area and Target Database.

Generated server side PL/SQL scripts for data manipulation, validation and created various snapshots and materialized views for remote instances.

Created Test environment for data staging using SQL & PL/SQL scripts and optimized critical queries to eliminate Full Table scans & reduce Disk I/O.

Optimize SQL queries for better performance. Fine Tuned the SQL queries using hints for maximum efficiency and performance.

Tuning of stored procedures & developed business logic in database layer using PL/SQL. Performance tuned multiple SQL queries and PL/SQL blocks using Explain Plan, Hints and SQL Trace.

Involved in exhaustive Performance Tuning using DBMS_Profiler, Explain Plan, Monitoring and Optimization of PL/SQL blocks and Batch frame work process in both Development and Production environment for Oracle.

Created and manipulated PL/SQL tables (i.e. Index-by Tables and Nested tables) and Varrays. Involved in creating Procedures, Packages and appropriate REF Cursors to handle BULK collects and BULK binds.

Proficiently developed Design documents (HLD & LLD), Unit Test Cases (UTS) and project documentation (user guides, run book, standard report instructions, demos).

Analyzed Oracle Objects & Created Partitions for very large tables in Production to reduce disk contention & improve performance.

Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors, UTL File I/O and Exception handling.

Generated DDL scripts for new database objects like tables, views, sequences, functions, synonyms, indexes, triggers and granting privileges.

Wrote Integrity Checks, Data Cleansing scripts, SQL Queries to fetch data from multiple tables that had millions of records using Joins that produced Reports & Logs.

Wrote the Migration scripts satisfying the new Business Requirement converting the data from its present form into a new form.

Wrote the validation script around the Migration done performing all the Business Validations as part of Pre & Post Migration.

Experience on ETL workflows working in Informatica Power-Center/Power Exchange, working in Master Data Management (MDM), Big Data and Data warehouse.

Pull data from one schema (EDB) to another schema (Data Warehouses) using ETL Informatica transformation tools.

Using Service now ticket request and Incident for any issues tracking and resolve the problems.

Creating Fitnesse fixture automation testing for developed Store Procedure.

Handling UNIX/Linux server Oracle database via connecting Putty.

Works independently to develop, configure, code and test programs from specifications.

Presents all work in design review and code review sessions to senior team members, and must be able to explain and support decisions made and actions taken.

Develop ETL data workflows and code for new data integrations and maintain/enhance existing workflows and code.

Estimates own work effort for input to project planning.

Now we are doing upgrading Oracle Cloud Database.

Environment: Oracle 12c/11g, TOAD, SQL * Plus, PL/SQL developer, SQL * Loader, Export/Import, Informatica 9x and 10x, XML, JAVA/J2EE, Rally, ER Studio 9.5/11, Windows 7, DUDE, Fitnesse, Putty, WinSP, Source Tree, GIT Stash, Confluence, Dockers, Jenkins, Dynatrace, UNIX and Linux.

Client: SEI Investments, Oaks PA (Dec. 2010 – Dec.2012)

Scope: Development/Maintenance

Industry Practice: Investment Banking (Wealth Management)

Project: Global Wealth Management Platform (GWMP)

Module: Open Architecture

Role: Senior Oracle PL/SQL Developer

GWP is a single integrated platform delivered via the Internet Web services that provides users with the information and functionality needed to enable sales, marketing, advice, service, administration and business management. Relationship Management, Customer services, Activity Management, Assets Maintenances, Currency Disbursement and Withholdings, Currency Balance and Orders deals with creation of data related to Account Groups, Account, Portfolios, End Client and profiles, Order Initiation, Cash Disbursements, Free Receipts, Free Delivery and Free Movements, Withholdings and Contribution’s services.

Responsibilities:

Creating PL/SQL Packages, Stored Procedures, Functions, Cursor and Triggers to implement the Business Logic and developing various Transaction handlers for the web service application.

Designed and Developed ETL Interfaces using PL/SQL Stored Procedures, UTL_FILE, External Tables, SQL*Loader and Oracle Utilities for the Staging Area and Target Database.

Analyzed and Designed Data Marts according to User requirements identified various Dimensions and Measures and implemented the Star Schema.

Facilitated migration of large volume of Oracle Data between the environments via Partitioned tablespaces and Transportable tablespaces

Performed security operations like recreation of grants & synonyms, compiling invalid code objects after the change of primary objects and ensuring database security and integrity with auditing features.

Generated server side PL/SQL scripts for data manipulation, validation and created various snapshots and materialized views for remote instances.

Created Test environment for data staging using SQL & PL/SQL scripts and optimized critical queries to eliminate Full Table scans & reduce Disk I/O.

Optimize SQL queries for better performance. Fine Tuned the SQL queries using hints for maximum efficiency and performance.

Tuning of stored procedures & developed business logic in database layer using PL/SQL. Performance tuned multiple SQL queries and PL/SQL blocks using Explain Plan, Hints and SQL Trace.

Involved in exhaustive Performance Tuning using DBMS_Profiler, Explain Plan and TKPROF utility, Monitoring and Optimization of PL/SQL blocks in both Development and Production environment for Oracle.

Created and manipulated PL/SQL tables (i.e. Index-by Tables and Nested tables) and Varrays. Involved in creating Procedures, Packages and appropriate REF Cursors to handle BULK collects and BULK binds.

Proficiently developed Design documents (HLD & LLD), Unit Test Cases (UTS) and project documentation (user guides, run book, standard report instructions, demos).

Analyzed Oracle Objects & Created Partitions for very large tables in Production to reduce disk contention & improve performance.

Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors, UTL File I/O and Exception handling.

Generated DDL scripts for new database objects like tables, views, sequences, functions, synonyms, indexes, triggers and granting privileges.

Wrote Integrity Checks, Data Cleansing scripts, SQL Queries to fetch data from multiple tables that had millions of records using Joins that produced Reports & Logs.

Wrote the Migration scripts satisfying the new Business Requirement converting the data from its present form into a new form.

Wrote the validation script around the Migration done performing all the Business Validations as part of Pre & Post Migration.

Hands on experience on ETL workflows working in Informatica Power-Center/Power Exchange.

Handling UNIX/Linux server Oracle database via connecting Putty.

Interaction with the offshore team on a daily basis on the development activities.

Environment: Oracle 11g/10g, TOAD, SQL * Plus, PL/SQL developer, SQL * Loader, Export/Import, Informatica 8.5, Python, XML, JAVA/J2EE, SOAP UI, Star Team, HP Quality Center, Rally, Windows XP and UNIX.

Client: British Telecom Global Services – UK (Nov. 2009 – Dec. 2010)

Project: BTGS – Seven Sisters Platform (ANDES – Agora)

Role: Technical Associate (Oracle PL/SQL Developer)

Description:

The British Telecom Global Services (BTGS) Master Data Management (MDM) programs are a cross-functional initiative aimed at implementing a harmonized product portfolio across country/region supported by a standard set of systems and processes.

This will improve the customer service of BT Global and reduce cost through standardization and rationalization of systems and processes. So, the program involves a number of system replacements.

The BTGS – Seven Sister Platform (ANDES – Agora) Central Repository of data migration project is an End to End (E2E) data processing. The part of Big Friendly Giant (BFG) Transient Reconciliation Database (BTRDB) components solution provides a GUI screen.

Developing MPLS, iVPN networks and Reuters Operations.

Roles & Responsibilities:

Worked on PL/SQL programming Packages, Stored Procedures, Functions, Cursors and Triggers.

Developing PL/SQL codes for various Work Packages as well as Change Requests.

Responsible for preparing Low Level Design (LLD), UTP (Unit Test Planning) documents, Unit testing of the codes and Preparing Release notes, Deployment and Support for product builds and Maintenance of database.

Worked in Data Warehousing for OWB (ETL) tool extracting the data like .csv format creating various kinds of reports data analyzing, reconciliations, data validation, quality checking, Matching report data to Data Base data (Count the Data), Consolidation and DWH testing. Handling Customers wise and country wise reports. Pull the data from one schema to another schema. Developing Pro*C, SQL*Loader scripts like Control file, Log file and BAT file, work on it External tables (flat file) exports (Transform) and imports (Load).

Generate the report from OWB consolidated report, Discrepancy report like .xls format, creating the Hyperlinks in .xls spread sheet reports send to Client.

Creating new Objects, Joins table, structures and altering existing entity’s and attributes, Materialized Views, Sequences and Indexes changing in design descriptions as per Client requirements.

Expanded Physical Data Model (PDM) for the OLTP application using ERwin.

Provide Oracle Application Server and Oracle APEX implementation and support.

Interacting with business regarding solving various codes issues and preparing daily, weekly reports and process performance monitors / Reports consolidated entity lists.

Responsible for Analysis, Design, Development, Deployment and Support for product builds and Maintenance of database. It consists of BT Customers, Suppliers, Contracts, Sites, and Products and Inventory information.

Environment: Oracle 10g, Oracle Warehouse Builder (OWB) Tool, SQL Developer, Toad, hp Quality Centre, Oracle J Developer 10g, Oracle ADF Faces, BMC Remedy, PHP, Oracle APEX 4.0, ERWIN 3.5.2, Java, J2EE, PRO*C, Windows and Unix.

Sun Chemical Sales Analytics - India (May 2008 – Sep. 2009)

Role: Software Engineer

Description:

Sun chemical is a leading chemical company. Portfolio ranges from chemicals, plastics, performance products. A web-based portal was designed to cater the needs of the sales and marketing team.

Roles & Responsibilities:

Worked on PL/SQL programming Packages, Stored Procedures, Functions, Cursors and Triggers.

Using UNIX (Shell Scripting) environment.

Worked for data warehousing tool in Informatica (ETL) Extracting reports from process flow identified and data validation the business requirements for data Analysis, Quality, Matching, Consolidation various kind of reports for data warehousing testing.

Gathered knowledge from the client side and reverse transitioned to the team.

Assisting the Test Team during the functional testing and Unit testing.

Worked on designing the logical model and Oracle ERP application.

Performed impact analysis on the change requests from clients and proposed solutions.

Environment: Oracle 10g, Toad, Crystal Reports 8.5, Informatica (ETL), Pro*C, Oracle ADF Faces, Windows and UNIX.

Client: Wozniak Technologies - India (Dec. 2004 – Apr 2008)

Project: Stock Books and Automated System

Role: Developer

Description:

The system is designed to gather customer details, vendor’s details, raw material details, product details. It maintains activities such as purchasing updating, Daily sales updating, billing, all payment and receipts with cheque details. Then we can view the outstanding balances purchase & sales stock, bending bills, reminder for cheque and stock reaching the reorder level and printing option.

General Stores and Inventory module deals with sales and purchase of Items, Issue of Items, Maintenance of Stock, Automatic Reorder level Setting, creating Invoice, Barcode Reading, Online request for stock from various sub-stores, Online stock transfer, maintenance of stock at different sub-stores, Physical stock verification and adjustment, Return of items to supplier etc.

Roles & Responsibilities:

Data Base Designing, Writing Stored Procedure & Trigger.

Creating Report Module using in Crystal Reports 8.5.

A central database or web location where sales and marketing indicators and reports can be easily retrieved.

Provides self-service to information, and reduces the time and staff needed for reporting.

Involved in design and development of data model (star schema).

Environment: Oracle 9i, SQL Developer, SQL Server, T-SQL, MS Access, VB.NET, ADO.NET, ASP.NET (VS 2005), PRO C, Crystal Reports 8.5, Forms 6i & Reports 6i, Window XP

Educational Qualification:

Master of Philosophy (M.Phil) in Computer Science, Periyar University (2009)

Master of Computer Applications (M.C.A) in Bharathidasan University, Trichy (2000 - 2003)

Master of Commerce (M.Com.) in Madurai Kamaraj University (1998 – 2000)

Bachelor of Commerce (B.Com.) in National College, Bharathidasan University (1995 –1998)

Certifications:

ORACLE Certified Professional – Oracle Certified PL/SQL, Forms and Reports, Build Internet Applications Developer (OCP)

ORACLE Certified Associate – Oracle Certified SQL Developer (OCA)

References: - Available Immediately on Request.



Contact this candidate