Sales Data

OBJECTIVE

Intend to build a career with leading corporate of Hi-Tech environment with committed & dedicated people, which will help me to explore myself fully and realize my potential and also willing to work as a key player in challenging & creative environment

Experience Summary

11+ Year Total Experience, 4+ years of ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 9.6 using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer)

7+ years of work experience In ERP System, VB- Oracle, ASP. Extensive VB programming in functional areas of Sales,Material Management, Inventory, Production Planning, Finance Accounting, QA in ERP (Maarsman) Development/Implementation Process.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Extensively used Informatica client tools – Source Analyzer, Target designer, Mapping designer, Informatica Repository Manager and Informatica Workflow Manager.

Worked with Oracle databases.

Various kinds of the transformations were used to implement business logic.

According to transformation logic, we used various transformations like Filter, Sorter, Aggregator, Lookup, Expression, Filters, Router, Update Strategy, Joiner, Normalizer etc in the Mappings.

Working in SCD - slowly changing dimensions to maintain historical as well as incremental data using Type I, Type II and Type III strategies.

Involved in creating the technical specifications of HLD, LLD.

Working Experience in Informatica, SQL, PL/SQL, Unix.

Experience with Data flow diagrams, Data dictionary, Entity relation modeling and design techniques.

Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, SQL *PLUS, TOAD and SQL*DEVLOPER.

Loaded Data into Oracle Tables using SQL Loader.

Interacted with the clients on regular basis to understand and give better solutions to the Business requirements.

Quickly adapting to the new environment and ability to learn new technologies.

ERP (Maarsman) Package development and Implementation experience in VB 6.0, ORACLE.

Application Software Development experience in VB 6.0, ASP.

Academics

MCA 72% from Bharathiyar University, Coimbatore, Tamilnadu, 2004.

B.Sc 75% from Madras University, Dharmapuri Tamilnadu. 2000.

Organization

Designation

Duration

Easun Reyrolle Limited. Hosur, Tamil Nadu, India.

Senior Software Developer

Oct - 05 to Feb-16 and Oct - 16 to Dec - 17

TECHNICAL SUMMARY:

Programming Languages

Informatica Power center 9.6, VB 6,ASP, VB.Net.

Databases

Oracle 8i/9i/10G/11G

IDE Tools

PL/SQL developer, SQL Developer and SQL Navigator, putty

Reporting Tools

Crystal reports, ALV, Spreadsheet, Front Page

Versioning Tools

Microsoft Visual Source Safe 6.0

Oracle Utilities

Oracle SQL loader, UTL_FILE

Operating System

Windows 7/XP, UNIX

Internet Technology

ASP, HTML, ASP.Net

Professional Experience:

SCM Dashboard

Organization : Easun Reyrolle Pvt Ltd.

Environment : Informatica Power Center 9.6,Oracle 10g, SQL, UNIX

Duration : Oct - 2016 to Dec - 2017.

PROJECT DESCRIPTION

M Supply chain Management consists of Sales and operations, pricing, Analytics & Inventory management. It mainly focuses on business transformation process analysis & operational benefits projects to organization.

Role & Responsibilities:

Worked as Informatica Developer and involved in.

Understanding the Requirements and performing the development scope analysis.

Involved in Analysis, Documentation and Testing of workflows.

Debug the Informatica mappings and validate the data in the target tables once it was loaded with mappings.

Developed Informatica Mappings to capture data changes from the operational sources systems into data warehouse and data marts (SCD mappings).

Created Various Complex Transformations such as Update Strategy, Look Up, Filter and Router Transformations.

Developed mappings, sessions and workflows (ETL) for SCD types I and II to meet the above requirements.

Involved in the requirement study and understanding the functionalities.

Ability to interface and communicate effectively with team members and provide the guidance in the development activity.

Development and Reporting Analytics

Organization : Easun Reyrolle Pvt Ltd.

Environment : Informatica Power Center 9.6,Oracle 10g, SQL, UNIX

Duration : Oct - 2013 to Feb - 2016.

PROJECT DESCRIPTION

Maarsman is an ERP System, extract data from Inventory and Sales using different applications perform analysis and generate forecasted Data for Sales and Inventory. Data will be loaded from Logility to stating daily, staging archive and Data Warehouse using Informatica. All reference data will be looked up and transformed in Report,and aggregate data will be loaded into target tables. These tables will be used the Business in performing Business Intelligence and Analytics on Ship From Store Model.

Role & Responsibilities:

Involved in implementing the end to end ETL life cycle.

Understanding the Requirements from customer(Business users).

Used ETL to extract and load data from Oracle, Flat Files to Oracle DWH.

Involved in Analysis, Documentation and Testing of workflows.

Debug the Informatica mappings and validate the data in the target tables once it was loaded with mappings.

Created and Monitored Work Flows using Workflow Manager and Work Flow Monitor.

Worked extensively on different types of transformations like Update Strategy, Look Up, Filter and Router Transformations

Developed Informatica Mappings to capture data changes from the operational sources systems into data warehouse and data marts (SCD mappings).

Created Various Complex Transformations such as Update Strategy, Look Up, Filter and Router Transformations.

Created mappings using Unconnected lookup, Sorter, Aggregator, newly changed dynamic lookup and Router transformations for populating target table in efficient manner.

Involved in design of ETL processes using Informatica ETL tool to load data from heterogeneous Source System like Flat Files, SQL Server and ORACLE.

Sales and Distribution

Organization : ERL Phase (Canada).

Environment : VB.6, Oracle 10g, SQL, PL/SQL

Role : Technical Consultant and Development

Module : Ordering, Dispatch, Sales, FG

Duration : Jan - 2012 to Aug - 2013.

Organization Profile:

ERLPhase Power Technologies is an ISO 9001:2008 QMS certified manufacturer of digital fault recording systems and protective relays. Headquartered in Canada, ERLPhase Power Technologies is ERL’s (Easun Reyrolle Limited) worldwide center of excellence for protection, monitoring and control.

Roles & Responsibilities:

Involved in Group 1 production support and enhancement activities.

Involved in creation DLD document of snapshot update process.

Writing PL/SQL procedures and functions to accomplish the snapshot functionalities in Group 2.

Writing package blocks using PL/SQL to group procedures, Functions and Identifiers.

Preparing Technical Specifications.

Developing Reports, Module Pool Programs, Upload Programs and Smartforms.

Testing for developed programs.

Reports:

Developed a report to print purchase order details using ALV Grid display.

Developed a report for displaying sales order details, Pending and Dispatch Details using ALV.

Developed y sales & production report, report contains quarter wise Production and sales data.

Developed a report for material details – for totals and subtotals for material stock values by material group and material type.

Developed interactive report to display day wise sales report.

Created report to display month wise sales details. Selection criteria were date range, sales organization and customer.

Modified layout set using SMARTFORMS for SD module documents such as Invoice, Delivery, Sales Order etc.

Developed and Designed forms using SMARTFORMS for MM module like Purchase Order, MIGO, MIRO etc.

Modified new script layout set of payment voucher. Payment voucher is a script layout which will be attached to standard screen.

Tracking & Monitoring ERP

Organization : Easun Reyrolle Pvt Ltd..

Role : Application Consultant and Development

Duration : Jan - 2010 to Dec - 2011.

Environment : VB.6 Oracle 10g PL/SQL

Description:

This system keeps track of day-to-day Erp operations like Material Issues/ Receipt, Dispatch Sales Details, Material Shortage List, Production Planning, Purchasing details and the customers as well as the suppliers.

Roles & Responsibilities:

Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.

Designed logical and physical data models for star and snowflake schemas using Erwin.

Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.

Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.

Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.

Worked on XML along with PL/SQL to develop and modify web forms.

Designed Data Modeling, Design Specifications and to analyze Dependencies.

Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.

Used Discoverer 2000 to provide end users easy access to data and help in data analysis.

Created some Custom reports and Forms for the end users to check the details and errors.

ERP (Maarsman)

Organization : Easun Reyrolle Pvt Ltd..

Role : Application Consultant and Development

Duration : Oct - 2005 to Dec - 2009.

Environment : VB.6 Oracle 10g PL/SQL

Roles & Responsibilities:

Preparing Technical Specifications.

Developing Module, Master Screens, Transaction Screens, Print Reports, List Details.

Data Base Design, Table Creation and Creation of Table Relationship.

Testing and Implementation programs.

Design and Developing of workflow procedures.

Interacted with client to gather the requirements and implement the same in the project.

Has done many migrations of project’s application interfaces.

Was responsible for handling the Billing application and related Change requests.

Was responsible in implementing JSP pages for project specific, team member’s assigned workflow details and for proper monitoring of tasks assigned.

Implemented PL/SQL queries, triggers and Stored Procedures as per the design and development related requirements of the project

Modules:

BOM - (Bill Of Material Creation, ECN Note, Drawing Master, Product Specification, Report Screens).

SALES - (Customer Creation, Order Enquiry, Order Input, Delivery Challan, Packing, Billing, Sales Details, Report Screens).

PURCHASE - (Vendor Creation, Specification Enquiry, Purchase Order, Delivery Schedule, Order Amendment, PO Detail, Report Screens).

INVENTORY – ( GIN Creation, GRIR Creation, IQC Inspection Transaction, Goods Move To stock, Stores Tag, JJ Form Entry, Internal Material Issue, Subcontract Issues and Report Screens).

SHOPFLOOR – (Work Order Creation, Operation Master, Work Order Grouping, Production Receipt, WIP Entry, Label Printing and, Report Screens).

FAS – (Account Master Creation, Purchase Bill booking, Cash Billing, JV Entry, TB, Credit Note).

Payroll – (Employee Master, Payroll Process, Current Salary, Fixed Deduction, Earning/Deduction, Grade Master, Attendance Master, Leave Control, Leave Transaction, Loan and Advances Master and Report Screens).

This ERP Package is designed in Easun Reyrolle Limited; primary objective of this system is the maintenance in the organization details. This package is cover the all Customer, Supplier, BOM, Material, Sales order, Work operation and all details these are all helpful to the top management for Tack and know the states in the organization.

Web Application

Project Name

Duration

Environment

Internal Quality Audit System

6 Month

ASP, Oracle.

Employee Suggestion Systems

4 Month

ASP, Oracle.

Extranet (Customer/vendor details)

6 Month

ASP, Oracle.

Complaint Register

3 Month

VB.NET, Oracle.

Customer Survey System

3 Month

ASP, Oracle.

Personal Details

Name : Manivannan Chennaireddi Narayanan

Father’s Name : Narayanan C.

Date of Birth : 5th Nov, 1979.

Languages Known : English, Tamil and Telugu.

Mobile No : +1-314-***-****.

Passport No : M9854129 Valid Up to: 2025.

Contact this candidate