SUMMARY:

• Passionate and resourceful IT and Mechanical Engineer with a Bachelor degree and 15 Years of practical diversified experience dedicated to work in Challenging and responsible leadership ETL Developer & an Engineering positions in the field of Mechanical, Research & development, checking Manufacturing Support to apply intensive knowledge of Information Technologies and engineering principles and practices to reach the necessary objectives, or position that utilizes my technical background in Mechanical design, engineering and development.
• I can make an immediate contribution to your company with my Valuable Fifteen Year’s practical engineering, design and Manufacturing experiences, analytical skills and broad educational background for design development, manufacturing implementation, troubleshooting problems and devising feasible solution, where decision are made within the limits of general practices and standards.
• I have a knack for innovative solutions to technically challenging design problems through work experiences in Research, Product development and manufacturing environments.

TECHNICAL EXPERTISE:

FRAME WORK: Manufacturing & Mechanical Technologies, Research & Development

RDMS: ETL Developer, Oracle 7, SQL * 3.1, PL/SQL * 2.1, MS Access

GUI: AutoCAD, Oracle / D2K, Visual Basic, Ms Office

INFORMATICA: Visual Basic - Crystal report, Developer 2000

PROFESSIONAL EXPERIENCE:

Confidential, MI

Informatica Developer

Responsibilities:

• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Extracted data from SAP system to Staging Area and loaded the data to the target database by ETL process using Informatica Power Center.
• Performed the performance and tuning at source, Target levels using Indexes, Hints and Partitioning in DB2, ORACLE and Informatica.
• Designed and developed various PL/SQL stored procedures to perform various calculations related to fact measures.
• Converted the PL/SQL Procedures to Informatica mappings and at the same time created procedures in the database level for optimum performance of the mappings.
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support.
• Performed Unit testing and maintained test logs and test cases for all the mappings.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Parsing high-level design specification to simple ETL coding along with mapping standards.

Confidential, MI

Informatica Developer

Responsibilities:

• Implemented Type 1 and Type 2 methodologies in ODS tables loading to keep historical data in data warehouse.
• Designed Incremental loading process to load data into staging tables.
• Created Worklets, Workflow and Tasks to schedule the loads at required frequency using Workflow Manager.
• Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs. Also involved in migration/conversion of ETL processes from development to production.
• Created reusable email tasks in Workflow manager for process exception handling.
• Participated in user meetings, gathered Business requirements & specifications for the data warehouse design. Translated the user inputs into ETL design docs.
• Worked with SQL, PL/SQL procedures and functions, stored procedures and packages within the mappings.
• Tuned Informatica mappings and sessions for optimum performance.
• Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.

Confidential, MI

Research & Development / Production Engineer / QC Engineer

Responsibilities:

• R & D of new processes and WORK WITH customer specific requirements
• Verifying all customer specifications against equipment capabilities
• VERIFYING CUSTOMER DESIGN SPECIFACTION AGAINST OUR CAPABILITIES AND MANUFACTURING POSIABELITIES
• CREATING MANUFACTURING WORK PROCESS FLOW AND Plan TO meet production schedules
• Supervise maintenance and operation of production machines and equipment to ensure productivity
• Design and implement any necessary changes in production equipment to ensure production activity as per ISO requirements
• TROUBLE SHOOTING- ROOT CAUSE ANALYSES ACORDENLY TO PFMEA AND CONTROL PLAN
• PREAPARING PPAP LEVEL 1,2, 3, 4 AND AS9102A FIRST ARTICLE
• RESPONSIBLE FOR INTERNAL AUDIT FOR 6-S,MONTHLY DEPARTMENTEL AUDIT,
• RESPONSIABLE FOR DRILLING-ROUTING-SCORING, MULTILAYER LAMINATION DEPARTMENT MONTHLY EQUIPMENT CALIBRATION.
• Underwriters Laboratories (UL) has program for Quarterly auditing of all UL Approved Product Category Wiring, Printed- Component at the Confidential Corp. Working as an internal auditor for Confidential Corporation before UL Auditor visit to Saturn I have to insure all Production Process is working as UL Approved Product Process Parameter.
• During the my pre-audit process, verifying Product process system, No-Violation of UL rules, calibration, management review, pre-audit findings verifications and Prepared Report for Management to review before Pre-Audit etc.
• Quality control engineer of Drilling-Routing-Scoring and Multilayer Lamination Department, UL Product, Image, Drilling, Etching, Inspection, Testing, Final inspection. Responsible for updating a work instructions, process, New product evaluation, new machine or new Process evaluation, calibration, maintenance of Plasma machines; weekly, bi-weekly, and monthly audit of departments.

Confidential

Mechanical Engineer

Responsibilities:

• Determine the most effective way to use the basic factor of Production - People, Machines, Material, Information, and Energy - to make a Product or to provide a service.
• I am the bridge between management goals and Operational Performance.
• Analyze all current process, identify waste and propose future Processes using tools such as value Stream Mapping and Standardize work.
• Develop/Streamline labor standards Database, Capacity Planning, scheduling and costing.
• Ensure measurement and control of direct and indirect labor standards.
• Develop business case and presentations.
• Develop standard operation process.
• Lead Business process improvement and cost reduction projects.
• Improve Material Handling in the plant & warehouse.
• Assist facilities engineers in the planning and design of facilities.
• Assist in establishing accident prevention measures and manage training programs for personnel concerning all phase of Production operations.

Confidential

Responsibilities:

• Involved in the Analysis of the fact of the manual
• Procedures and preparing the System and Procedures
• Manual, Designing the Data Structures for incorporating
• The analyzed fact preparing Layouts and the Back end
• Packages, Testing, Preparing User Training and
• Technical Manuals, User Training and Implementation.

Environment: Oracle/d2K, Windows - 95, MS Office - 97