EXPERIENCE SUMMARY

• Experience in analysis, design, development, testing and implementation as an SQL, PL/SQL ETL Developer.
• Having 10 years of experience in Information Technology which includes Oracle, SQL Server, Teradata, SQL, PL/SQL Development, ETL Development, Java Programming, Web Applications Development and Planview Project Management, Tool Administration Development.
• Excellent knowledge in Software Development Life Cycle SDLC Metrics that includes requirements gathering, functional and technical specifications, design, development, testing and production deployment.
• Strong experience in Data warehouse concepts, ETL.
• Programming experience in C, C ,Java, J2EE .Net. Using Programming routines in Talend ETL Development.
• Strong Exposure in writing Simple and Complex SQL Queries, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Proficient in Performance Tuning of ETL Jobs Database Queries. Good knowledge of key Oracle performance related features such as Execution Plans and Indexes.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience with Oracle Supplied Package.
• Experience in Data Migration from various legacy systems to target database using Talend and Informatica ETL Jobs.
• Expertise in Data Warehouse applications, directly responsible for the Extraction, Transformation and Loading of data directly from different heterogeneous source systems like flat files, Excel, Oracle, SQL Server, Teradata.
• Experience in creating Projects, Users, Code repository in Talend Admin Center TAC .
• Excellent knowledge in Talend Open Studio and TAC, TOAD and SQL Developer
• Very good knowledge in scheduling the ETL Jobs in Autosys tool.
• Involved in DBA Activities like refreshing Development database with Production database and improving database queries performance with index creation.
• Experience in understanding complicated performance issues and worked with DBA's to suggest valuable ways to fix the problem.
• Experience in Planview 9/10/11 with Enterprise Portfolio Management EPM , Project Portfolio Management PPM .
• Experience in Planview Customization, Automation and Administration activities like creating configured screens, scripted dialogs, building life cycles and user provisioning.
• Very good knowledge in Planview database, Data mart load and migration of financial management data from FM09 to FM10.
• Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.
• Strong problem solving technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.
• Significant experience in 24/7 Production Support Environment.

TECHNICAL SKILL SET

PRESENT WORK EXPERIENCE

SQL, PL/SQL, ETL Planview Developer

Confidential

Responsibilities:

• Has involved in gathering business requirements, documenting them, and converting them into robust system designs
• Created database Tables, Views, Triggers, Indexes, Materialized views.Wrote Stored Procedures, Functions to implement the business logic
• Worked with DBA team to improve the performance of data mart load, jobs and queries.
• Worked on refreshing Development database from Production.
• Worked on creation configuration of Talend Environment.Created Projects, Users, SVN repository in Talend Admin Center TAC .
• Developed ETL Jobs with Talend Studio Citi Grand Central. Developed Reusable ETL components Joblets with Talend Open Studio
• Developed complex ETL jobs include different databases Oracle, Teradata and SQL Server.
• Used exception handling, data rejection strategy, emailing status in ETL Jobs and database stored procedures.
• Createdchange requests to move the database changes objects/ data updates , ETL Jobs to UAT and Production environments.
• Developed ETL jobs for various Inbound and Outbound feeds.Used SFTP components to transfer files from one server to other.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Planview Administration Creation of new structures, fields, scripted dialogs configured screens, work model, strategy model,and financial models.
• Planview financial data migration from FM9 to FM10.
• Migration ETL jobs from Citi Grand Central tool to Talend environment.
• Creation of Autosys Jobs to facilitate automation scheduling of data processing
• Worked with Business objects team to improve the performance of reports.
• Worked with application developers to improve the application performance while retrieving the data from database.
• Performing UT/IT and coordination UAT activities to ensure data credibility
• Performance tuning operation in ETL Talend and Oracle stored procedures/Queries so as to avoid slowness and to improve processing time
• Used Batch files for loading database tables from flat files using SQL loader.
• Developed complex ETL jobs in Talend using different components like Routines, Schema Checker, SFTP, TMap, Filterer, Teradata multi load, and Teradata fast load.
• Fixing all the issues and bugs that may come up during the phase of production.
• Reviewing work products from offshore.

Environment:

Planview 10.X, 11.1,Oracle 11g/10g, Teradata,SQL, PL/SQL,Talend Studio 5.4.1, Talend Admin Center 5.4.1,TOAD, SQL Developer,SQL Server Management Studio, Microsoft Visual Studio 10, Autosys,ASP, .Net,Java, Windows, Unix and Service Now.

PAST WORK EXPERIENCE

PL/SQL, ETL Developer Confidential

Responsibilities:

• Developed Informatica Mappings, Transformations, Workflows ETL Jobs to load the wind energy data into GE Wind Energy data warehouse.
• Developed Batch files and java programs using JDBC to pull the wind energy data from different sites SQL Servers .
• Developed DTS packages BCP Scripts to load the data from flat files to SQL Server database.
• Created Oracle Teradata Tables, Views, Indexes. Wrote Stored Procedures, Functions to implement the business logic
• Migration of data from Oracle data warehouse to Teradata.
• Wrote complex SQL queries to provide the wind energy weekly and monthly summary reports.
• Making sure of the data passage between the SQL servers and the Teradata database.
• Worked on database issues raised by the clients and also have done the changes in database as required by the client.
• Also involved in running the Informatica workflows to load the data into the final tables of database
• Also working in delivering the weekly Metrics which refers to the percentage of data coverage for the week pole wise which is done for every fiscal week.
• Responsible for database performance and tuning.
• Creation of automated data load process.
• Handling all related Production issues.

Environment:

Oracle 10g, SQL Server 2008,Teradata, SQL, PL/SQL, Informatica Power Center 8.6.1, TOAD, SQL Developer,SQL ServerManagement Studio,Java, JDBC,SQL Server DTS packages,BCP, Batch files,Windows andUNIX.

Java, J2EE Database Developer Confidential

Responsibilities:

• Developed EUPM Dashboard, Cash Accelerator web applications using Java, JDBC, Servlets, JSP, XML, and XSLT.
• Analysis of HP Business Availability Center database.
• Created database links to load the data from HP BAC system to Web Application database.
• Developed batch processing jobs to download the flat files from HP FTP site.
• Developed JDBC programs and batch jobs to load the data from flat files to MYSQL and Oracle databases.
• Developed tables, views, triggers, functions and procedures in web application database.
• Wrote SQL, PL/SQL functions and procedures to process the data received from BAC database.
• Performance tuning of SQL Queries, procedures and functions.
• Worked on deployment of web applications.
• Worked on raising change requests to move the web application, database code to UAT and Production Environments.

Environment:

HP BAC,Oracle 9i/10g, MY SQL, SQL, PL/SQL, TOAD, SQL Developer, Java, JDBC, JSP, Servlets, J2EE,Net beans, Eclipse, Windows B