Senior Project Engineer Resume
4.00/5 (Submit Your Rating)
SUMMARY:
- 5 plus years of experience in Information Technology subjecting to Retail domain with emphasis on PL/SQL, ETL tool Informatica Power Center, FATWIRE CMS (Content Management System) tool, and UNIX
- Expertise in all phases of SDLC (Software Development Life Cycle) from design, development, testing, maintenance and support.
- Extensively worked on PL SQL Stored Procedures, Functions, Packages and Database Triggers using SQL and PL/SQL.
- Expertise in creating database objects like tables, views, sequences, indexes using SQL Developer.
- Expertise in Optimizing the queries to improve the performance.
- Expertise in DDL, DML, DCL and TCL statements.
- Extensive exposure to concepts of Data warehouse like Design, Data Modeling, OLTP and ETL.
- Experience in Extraction, Transformation and loading (ETL) of data from various sources into Data Warehouses using Informatica Power Center Tools (Designer, Workflow manager, Workflow Monitor and Repository Manager).
- Experience in developing mappings using Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Sequence Generator and Lookup Transformations.
- Developed test plans, test cases and test procedures for unit testing, system testing and interpreted test results.
- Extensively used UNIX Shell Script for automating batch programs.
- Expertise in Oracle SQL and PL/SQL with profound knowledge and solving complex production issues using appropriate analytical skills to the fullest.
- Hands on experience in Production Support and Maintenance.
- Experienced in documentation and presentation that meets the current business standards. Prepared technical and functional design documents for implementation, customizations and conversions projects.
- Expertise in FATWIRE (CMS Tool) Creation of Flex Asset Model, Basic Asset Model and Workflow. Customization of Attribute Editors, Publishing and Search. XML Post Utility, Bulk Loader Utility. Working on FATWIRE by creating CS - Element, Templates and site entry.
- Worked closely on tools like - Putty (Network file transfer application), WinSCP (Windows Secure cope) for FTP and SFTP.
- Worked on Agile tool JIRA and adapted to the Principles of Agile methodologies
TECHNICAL SKILLS:
Operating System: Microsoft Windows XP and Windows 7
Database: Oracle 9i / 10g
Languages: PL/SQL, UNIX Shell Script, Fatwire CMS
ETL Tool: Informatica Power Center 9.6.1
Developer Tools: SQL Developer, UNIX Putty, WINSCP (Windows Secure Copy), Fatwire (Content Management Tool)
Ticketing Tool: JIRA
PROFESSIONAL EXPERIENCE:
Confidential
Senior Project Engineer
Responsibilities:- Coordinated with Product Managers to achieve new enhancements to meet their expectations.
- Created and modified PL/SQL stored procedures, packages and functions for moving data from Fatwire system to front end system.
- Created scripts to create new tables, views, queries for new enhancement in the application.
- Worked on queries tuning by rewriting queries to improve the performance.
- Created adhoc reports to merchandising team by writing SQL queries to analyze data.
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
- Worked on Informatica Power Center components- Designer, Workflow Manager, Workflow Monitor and Repository Manager
- Involved in ETL code to Extract, Transformation, cleansing and loading data from source to target data structure.
- Created mappings using Expression, Lookup, Sorter, Normalizer, Aggregator, and Router transformations for populating target table in efficient manner.
- Created Informatica Power Center Mappings, Mapplets and Transformations using the Designer and developed Informatica sessions as per the business requirement.
- Used Informatica to extract, transform and load data from different input sources like flat files and XML files and DB.
- Developed workflows using task manager, worklet designer and workflow designer in workflow manager and monitored the results using workflow monitor.
- Performed Unit testing of Informatica ETL process to ensure ETL logic.
- Used workflow Scheduler to schedule the job.
- Involved in performance tuning of SQL Queries, Sources, Targets and sessions.
- Developed the UNIX shell scripts for the PL/SQL procedures job run.
- Coordination with business users for user acceptance testing, signoffs and implementation.
- Handled multiple projects in this duration which were implemented successfully on time. Attained customer appreciation for the involvement and prompt efforts made by the team.
Environment: s: Informatica Power Center 9.6.1 Oracle SQL Developer Unix Putty JIRA WINSCP
Confidential
Support Engineer
Responsibilities:
- Identified the issues in stored procedures and packages and solve by raising BUG fix.
- Responsible for support and maintenance of FATWIRE content Management tool for the merchandising team.
- Worked on problems, incidents, operational activities and others through usage of FATWIRE, PL/SQL Developer for the report generation
- Written complex queries for report generation.
- Solved production issue raised by customers on FATWIRE and identify the issues on the procedures and packages.
- Solved the incident tickets and close after satisfied by incident owner in JIRA.
- Analyzed problem rose by the merchandising team while using FATWIRE tool and provided solution for that.
- Monitored the automated jobs and provided the solution if there was any failure
- Follow-up on tickets and fixing the issues
Environment: s: Oracle SQL Developer Unix Fatwire Informatica Power Center Design Putty WINSCP