Project Quality
Resume:
Title:Staff Information Systems Analyst
******************@*****.***
Document
Source below
NAME: PARTHASARATHI.D, PARTHASARATHI.D
ADDRESS:
ADDRESS2:
CITY: CHENNAI
STATE:
ZIP: 600090
CANDIDATE ID: 2284394
US CITIZENSHIP:
EDUCATION:
EXPERIENCE:
WILL RELOCATE: -
JOB WANTED:
RATE NEEDED:
TELEPHONE:
EMAIL: ******************@*****.***
HOMEPAGE:
COMMENTS:
HOTTEST SKILLS: 2167, 3270, 80.86, a+ certification, abap, active server, activex,
animation, apache, applet, as 400, as/400, as400, assembly language, athlon, autocad,
automatic test equipment, aviation, baan, banyan
REVISION: 22-MAY-02
YOE:
RESUME:
EXPERIENCE SUMMARY
A total of over 10 years of experience, of which over 7 years of experience in IT
Industry, which includes nearly 2 years of experience in Datawarehousing - Microstrategy
7.0, Cognos -Impromptu 5.0, Powerplay 6.5, Business Objects, Microsoft OLAP Tool and
Datamodelling Tools like Platinum Erwin 3.5x and MS Visio. Experienced to plan and execute
all phases of software life cycle starting with User Requirement Study, Business Analysis,
Design Business Model, Functional Validation Development, Testing, Implementation,
Maintenance, Training, Communication and Co-ordination.
Good understanding of ETL Tools like DataJunction, Informatica - Power Center. Possesses
good knowledge of Manufacturing, Quality, Process Industries and Retail Applications.
Played vital role in the Implementation of ISO 9001 and QS 9000 Quality Standards in the
Engineering and Automotive industries.
TECHNICAL ENVIRONMENT
HARDWARE
PC Pentium
OPERATING SYSTEM
Windows NT 4.0, Windows 95 / 98,Windows 2000 Professional / Server
MIGRATION / ETL TOOLS
SQL *Loader, DataJunction, Informatica
OLAP TOOLS
Microstrategy 7.0 / 6.0 DSS Suite, Cognos Impromptu 5.0, Powerplay 6.5, Datamodelling
Platinum Erwin 3.5.2, MS Visio, Intellimine - ROLAP Tool, Business Objects BI Suite,
Microsoft SQL OLAP
SOFTWARE
Java 2.0, HTML 4.0, XML, JSP, Enterprise Java Beans 1.2, Visual Basic 5.0, Crystal
Reports, Developer 2000 (Forms 4.5, Reports 2.5)
DATABASE
Oracle 8.0 / 7.x, MS SQL Server 7.0 / 6.5, MS Access
MAJOR ASSIGNMENTS
Organization: DSQ Software Limited, Chennai
I. Project: PROMOTOR INFORMATOR (QUALITY MANAGEMENT GROUP) - DATA MART
March 2001 Till Date
This in-house project is being executed for the Quality Management Group of DSQ Software
Limited. The transaction system and the warehouse are both hosted on Windows NT servers
using SQL Server 7.0 and Oracle 8 respectively and COGNOS tools are used to develop user
interfaces.
As a Systems Analyst, was responsible for the following:
i Designing and developing the Data Mart
for Quality Management Group
i The source system was studied in detail and extraction methodologies were designed
i The user requirement analysis was studied and evaluated, appropriate data model was
designed using Platinum Erwin 3.5.
i The Star OLAP schema was designed using Platinum Erwin 3.5
i COGNOS tools are used to develop user interfaces
i SQL Server Data transformation services was used to extract data from the source
system
i Aggregate tables are built to improve query performance
i Reports include Project Status Tracking, Defect analysis and Phase wise Effort, etc
i The catalog has been configured according to the database and the basic reporting has
been done by Impromptu Reporter
i Implemented the analytic and reporting applications utilizing Powerplay Transformer
and Portfolio Manager
Environment: PC Pentium, Windows NT 4.0, MS SQL Server 7.0, Oracle 8.0, Cognos Impromptu
5.0, Powerplay 6.5, Transformer 6.5, Portfolio 6.5 and Scheduler 5.0
II. Project: DATA MART FOR RESOURCE MANAGEMENT SYSTEM
December 2000
March 2001
This in-house project is being executed for the Quality Management Group of DSQ Software
Limited. The Datamart for Resource Management System is on Oracle 8.0 running on Windows
NT. The subject areas for the Data Mart are Project details, Employee details, Employee
skills, and Group and Certification details of an employee.
As a
Systems Analyst, was responsible for the following:
i Designing and developing the Data Mart for Resource Management Group
.
i The source system was studied in detail and extraction methodologies were designed.
i The user requirement analysis were studied and evaluated
i Appropriate data model was designed with LDM, PDM
i Measures and dimensions were designed using Microstrategy DSS Architect
i Analysis of data was done using DSS Agent
i The Data Model was designed using Platinum Erwin 3.5.2
i Based on the Schema design, the Data Mart tables were created and data was loaded
using PL/SQL scripts
i Configured the DSS Intelligence server and the metadata was configured according to
the database
i Designed the Project source manager
i Implemented the analytic and reporting applications utilizing DSS Agent and Architect
Environment: PC Pentium, Windows NT, Oracle 8.0, MS SQL Server 7.0, Microstrategy 7.0 DSS
Suite and Platinum Erwin 3.5.2
Organization: Systech India Pvt. Ltd., Chennai
I. Project: WEB ENABLED ERP PRODUCT DEVELOPMENT FOR
SYSTECH SOLUTIONS INC, USA
July 2000
November 2000
Zorro is a web enabled ERP package to provide solutions to various Vertical industries.
This is developed in Java backend using EJB/Servlets and dynamic HTML, XML front pages.
This Product is platform independent and provides ASP solution for various industries this
integrates the whole Supply Chain scenario of the enterprise into one entity.
As a Project Leader, was responsible for the following:
i Functional head for Production, Plant Maintenance and Quality modules
i Overseeing the Quality procedures related to the project
i Designed and developed the functional specifications and industry required
characteristics
Environment: PC Pentium, Windows 98, Windows NT, Java 2.0, HTML 4.0, XML, JSP 2.0 and
Enterprise Java Beans 1.2
II. Project: INTELLISYS ON-SITE IMPLEMENTATION FOR IMGEARS, CHENNAI
May 2000
July 2000
An ERP package customized to their specific needs in accordance with ISO 9001 and QS 9000
quality requirements, which in turn generates reports and adhoc reports. Intellisys takes
care of the Inventory and Production management system as per the Customers Order
requirement/according to the manufacturing conditions; MRP run will take care for the
Production Planning; Quality Management in accordance with ISO9000 and QS 9000 System is a
special feature. Automatic Posting of various transactions taken place in all modules are
integrated and updated simultaneously.
As a Project Leader, was responsible for the following:
i Analyzing for the different type of reports
i Held discussions with the clients related to design / specification study
i Tracking of Project Schedule
i Designing the functional validation and business flow as per the user Client
requirement.
i Black Box, White box testing for Quality testing the package
i Debugging and Testing
i Overseeing
the Quality procedures related to the project
i Project Implementation
Environment: PC Pentium, Windows 95 / 98 Windows NT, Oracle 8.0.5, Visual Basic 5.0 and
Crystal Reports
III. Project: SALES DATAMART IN MANUFACTURING INDUSTRY FOR IMGEARS, CHENNAI
April 2000
July 2000
Regular analysis and adhoc reports with respect to Purchase, Production and Sales with
respect to Customer and Time Period; Stock maintenance and Inventory Control as per the
Customer requirement.
As a Project Leader, was responsible for the following:
i Held discussions with the clients related to design / specification study
i Responsible for finishing the job ahead of schedule.
i System
Design - LDM, PDM through proper business process study as per the Clients
business requirement
i Analyzing for the different type of reports
i Debugging and Testing
i Pilot Run Testing, Black Box, White Box Testing
i Overseeing the Quality procedures related to the Datamart
i System Implementation
Environment: PC Pentium, Windows NT, Oracle 8.0, MS SQL Server 6.5 and Intellimine (A
ROLAP tool used for the ERP Product Intellisys)
IV. Project: DEVELOPMENT OF MANUFACTURING DATAMART FOR
SYSTECH SOLUTIONS INC, USA
January 2000
March 2000
Regular manufacturing, inventory report generation, purchasing and goods control and
adhoc reports for typical manufacturing company. It takes care of the extensive Shop floor
analysis like production stock requirement, finished goods status, WIP stock status, Goods
under QC Check, MRP list for different Products grouped by item-wise.
As a Project Leader, was responsible for the following:
i Getting the User requirements and formulated the related design/specification study
i System design using Logical Data Modeling and Physical Data Modeling through proper
business process study
i Analyzing for the different type of reports
i Overseeing the Quality procedures related to the project
i Debugging and Testing
i Pilot Run Testing, Black Box, White Box Testing
i System Implementation
Environment: PC Pentium, Windows 95 / 98, Windows NT, MS Access and Microstrategy 6.0 DSS
Suite Tool
V. Project: DATAMART SOLUTION FOR APPAREL WHOLESALE ENTERPRISE (APPAREL INSIGHTS)
October 1999
December 1999
Regular Sales report generation and adhoc reports applicable for typical apparel
industry; Procurement and quality conditions as per the apparel industry standards and are
customized; Manufacturing and Inventory Characteristics as per the industry standards.
As a Project Leader, was responsible for the following:
i Studied and analyzed for the business requirements and formulated a detailed design /
specification study.
i Overseeing the Quality procedures related to the project.
i Analyzing for the different type of reports as per Client requirement
i System design using Logical Data Modeling and Physical Data Modeling through proper
business process study
i Debugging and Testing
i Pilot Run Testing, Black Box, White Box Testing
i System Implementation
Environment: PC Pentium, Windows 95 / 98, Windows NT, MS Access, Microstrategy 6.0 DSS
Suite OLAP tool
VI. Project: ERP PRODUCT DEVELOPMENT (INTELLISYS)
June 1999
April 2000
Intellisys integrate the Core functions of a manufacturing Organization to enhance
Operational efficiency by virtue of Seamless integration of various modules like MM, PP,
FI, CO, QA, SD and HR. It emphasis Client / Server Architecture. It is modular structured
meeting the requirements of various vertical Solution industries and is scalable in
nature.
As a Project Leader, was responsible for the following:
i Held discussions with the clients related to design / specification study
i Responsible for Project tracking and Control
i Part of the core team in the design and development of Intellisys Package
i Functional Head for Production and Quality modules.
i Coordinated for Materials-Inventory and Sales modules.
i Debugging and Testing
i Pilot Run Testing, Black Box, White Box Testing
i Overseeing the Quality procedures related to the project.
i System Implementation
Environment: PC Pentium, Windows 95 / 98, Windows NT, Oracle 8.0.5, Visual Basic 5.0 and
Crystal Reports 4.6
Organization:
L.G.Balakrishnan & Bros Ltd
., Coimbatore
I. Project: BUSINESS PROCESS REENGINEERING
June 1998
June 1999
Regular Process / Product analysis in a well-defined structure for the entire
manufacturing Process. Restructuring the entire Organisational flow into appropriate
modules for effective functionality and responsibility along with authority. Carrying out
the whole organisational activities into modular level like Procurement, Manufacturing,
Quality and Sales, Customer Support to speed up the cycle process.
As a Programmer, was responsible for the following:
i Conducted Process analysis at vital stages of manufacturing using the In-house
Quality Software tool, FMEA software
i Generated feedback analysis report for various causes, which aided in for effective
Customer Relationship Management
i Responsible for coordinating MIS to produce relevant reports for Vendor Analysis,
Customer Complaints, Quality Test analysis and Overall Unit Performance.
Environment: PC Pentium, Windows 95, Oracle 7.0 and Visual Basic 5.0
II. Project: QUALITY SYSTEM INTEGRATION
April 1997
June 1998
The organizational quality system has been restructured in accordance with the QS9000
standards. Various activities like Sales and Marketing, Purchase, Finance, HR, Production,
Quality and R&D were redesigned as per the clause conditions and are integrated company
wise to achieve overall Quality System standard.
As a Programmer, was responsible for the following:
i Designed System standards in accordance with QS9000 stipulations
i Responsible for conducting Internal quality audits and System Procedure review for
Manufacturing, Development, Quality and Vendor analysis were standardized and Work flow
system was strictly adhered to.
i Documented the Business System design for automating the workflow across the
organization.
Environment: PC Pentium, Windows 95, Oracle 7.0, PL/SQL and Developer 2000 (Forms 4.5,
Reports 2.5)
Organization: PRICOL, Coimbatore
I. Project: BUSINESS SYSTEM ANALYSIS THROUGH MIS REPORT
January 1996
April 1997
Regular manufacturing, Inventory report generation, Purchasing and Goods Inward supply,
regulation reports and adhoc reports; detailed quality report generation for regular,
Performance tests
As a Programmer, was responsible for the following:
i Generating the Goods Inward report analysis periodically and the Supply status over a
time period for the HOS/HOD.
i Coordinated with MIS for the Supply, Production / Process and Quality performance of
the concerned unit and Profit/Loss analysis for the unit periodically.
i Generated SPC and Quality Assurance test reports for the Processed goods.
Environment: PC Pentium, Windows 3.11, FoxPro and Dbase IV
II. Project: COSTING ANALYSIS THROUGH MIS REPORT
February 1995
December 1995
An integrated MIS approach to estimate the overall Profit-Loss analysis for the
responsible unit; here the overall unit consumption are taken into account like raw
materials, Labour, Power, Overheads, Depreciation of Capital goods etc. and the Unit
Profitability is computed periodically.
As a Programmer, was responsible for the following:
i Data collection, record input, computational analysis and quality procedures related
to the project.
i Generating the monthly Costing Sheet to the Department Head and for the management
review meeting
Environment: PC Pentium, Windows 95 and FoxPro
III
. Project: QUALITY SYSTEM INTEGRATION
December 1993
January 1994
A well defined Quality Procedure in accordance with ISO9001 quality standards for Heat
Treatment Process for Auto assembly, machine shop, Pumps division, Industrial gauges
division, Defense division were .The Work Instructions, Work Order, Process sheet, GR/GI
entry, Purchase and Quality testing of process are integrated to streamline the whole
system.
As a Programmer, was responsible for the following:
i Formulating the QS standards for Purchase, Planning, Process and Quality, Testing
i Business requirement study for the entire system in Heat Treatment section were done
in detail
i Vendor analysis study was made in detail to provide periodic Vendor Evaluation
feedback
Environment: PC Pentium, Windows 95, Oracle 7.1, PL/SQL and Forms 3.0
FUNCTIONAL EXPERIENCE
I) Organization : Spheroids & Alloys (P) Ltd., Coimbatore
Duration : November 1991 November 1993
Designation : Engineer Quality Control
Responsibilities :
i Looked after the Physical, Chemical & Metallurgical lab for regular testing and
analysis of various grades of Cast Iron, SG Iron, Alloy CI and Steel Castings
i Control techniques in Melting and Molding Process.
i Heat Treatment Process Control
i Value Engineering through Energy auditing, Melt Control etc,
i Post Welding Operational Techniques and control measures
i Formulated process control plan for Casting and Welding as per AWS specification for
IBR certification process.
i Defects Analysis in Melting, Molding and Heat Treatment Process and their appropriate
control measures.
II) Organization : PSG II, Coimbatore
Duration : July 1991 October 1991
Designation : Engineer Management Trainee
Responsibilities :
i Study of Melting, Molding and Heat Treatment Processes for various Grades of Cast
Iron, SG Iron and Steel Castings
i Study and Monitoring of Physical, Chemical and Metallurgical Lab Testing Activities
TRAINING UNDERGONE
i Training in Business Objects 5.0, Cognos Impromptu 5.0, Powerplay 6.5 tools in
Datawarehousing from DSQ Software Limited
i Training in SQL OLAP, Oracle Express, Oracle Discoverer, Warehouse Builder tools in
Datawarehousing from Systech Solutions Pvt. Limited
i Training in Quality System Procedures from Systech Solutions (P) Ltd.
i Training in Business Process Reengineering Practice from LGB
i Training in ISO 9001 and QS 9000 Standards from LGB
i Training in QS 9000 Quality Systems from LGB
i Training in TQM Practice & Methodology from PRICOL, India
i Training in Change Management from PRICOL, India
i Training in Testing methods and SPC implementation from PRICOL
i Training in SPC methodologies from PRICOL
i Training in ISO 9001 Quality Systems from PRICOL
Contact this candidate