Description
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
Education
| SCHOOL | MAJOR | YEAR | DEGREE |
|---|---|---|---|
| Periyar University | Computer Science | 2009 | Master Degree |
| Bharathidasan University | 2003 | Master Degree | |
| Bharathidasan University | Madurai Kamaraj University | 2000 | Master Degree |
| National College Bharathidasan University | 1998 | Bachelor Degree | |
Accomplishments
Highlights:
Keywords
