Hossein J. Ziayan

System Analyst

Contact information:

email:clp0h5@r.postjobfree.com

Cell phone: 774-***-**** Profile Summary

I have More than fifteen (15) years of experience in developing, analyzing, designing, implementing, customizing, supporting, and testing Client/Server and mainframe applications.

More than several years of experience PL/SQL in Oracle 11g/10g/9i/8.0/7.0/6.0/5.0. In addition, I have used Oracle application, Python, Perl, Visual Basic, XML, JSP, SQL Server 2000, and UNIX shell script.

Oracle E-Business suite (Logistics, Contracts, Install Bases, Field Services.

Job Experience Project : Genzyme Serialization

Project Duration : Feb. 2010 -Present

Location : Framingham, MA

Role : System analyst

PROJECT OVERVIEW:

Genzyme, One of the world’s foremost biotechnology companies, driven by patient safety and the threat of upcoming serialization and pedigree regulations, the client must be able to provide and maintain serialization records and pedigrees for prescription (Rx) drugs.

Also, design scalable IT systems to manage serialization data and integrate with current client applications.

In addition, require an increase in visibility of product movement and inventory levels in both the internal and external supply chain.

ROLE DESCRIPTION

1. Analyze new business requirements and design solution.

2. Design and impalement multi event, and n-level solution base on EPCIS protocol.

3. Complete transition of interface complexity from Axway to database objects.

4. Establish himself as an expert on designing and implementing new complex interface.

5. Create detailed knowledge transfer documentation for full time Genzyme resource

6. Extract, transfer and load data (ETL)

TECHNOLOGY/ APPLICATION EXPERIENCES:

- PL/SQL, Axway Platform, ETL, SOA, XML, UNIX script, WebMethods, WSDL, JMS

Project : WKH Data Conversion

Project Duration : Oct. 2009 - Jan. 2010

Location : Marlborough, MA

Role : System test analyst

PROJECT OVERVIEW:

The project was to re-engineer existing ETL processes to use new vendor feeds from Wolters Kluwer to build the Commercial Analytics Data Warehouse & reporting Data Mart.

ROLE DESCRIPTION:

Work in the testing team for the WKH Data Conversion at Sepracor

RESPONSIBLE :

- Developing SQL queries/scripts and similar artifacts to validate the completeness, integrity and accuracy of data against expected results

- Creating and executing test plans based on Functional Requirements, Design documents, and other project inputs

- Execute, monitor and debug Informatica workflow

TECHNOLOGY/ APPLICATION EXPERIENCES:

- PL/SQL, Informatica, ETL, UNIX script

Project : IDR Pricing Support

Project Duration : June 2009 - Sept. 2009

Location : Marlborough, MA

Role : Support Lead:

PROJECT OVERVIEW:

Wellington Management Company, LLP manage US, international and global equity, fixed income, currency, commodities, real assets, and active asset allocation portfolios for institutional clients and mutual fund sponsors in over 40 countries. IDR Pricing team monitors and support pricing systems.

ROLE DESCRIPTION:

Work as support lead generates artifacts that give insight into how the support team does its job and track quality of services delivered.

RESPONSIBLE DELIVERABLES:

- Documentation of Tivoli (Maestro) schedules and their dependencies.

- Expand existing support sheets to cover not only exceptional support

issues but standard issue as well.

- Merge existing metrics used to track Operate throughput with

Accenture standards.

- Document down stream clients who are dependent on Pricing services

and upstream vendors and Wellington services Pricing is dependent on.

- Generate a weekly status report that reflects issues addressed by

the Operate team and issues/risks faced by the team.

- Document the responsibilities of the Operate team and the operation

processes used to satisfy those responsibilities.

- Establish regular "Root Cause Analysis" session to identify recurring

issues that impact productivity and risk faced by the Operate team.

TECHNOLOGY/ APPLICATION EXPERIENCES:

- PL/SQL, Ascential data stage, ETL, Maestro Job Scheduler, UNIX script,

BMC remedy ticket, AccuRev source control, MyEclips, Perl,

Weblogic, Mercury Quality Center(TestDirector).

Project : CODA

Project Duration : Jan. 2009 - April 2009

Location : Lake Forest, IL

Role : Senior application developer

PROJECT OVERVIEW:

Takeda Pharmaceuticals North America, Inc. is among the top 15 pharmaceutical companies in the United States.

CODA project as the data source is to assess the capability of certain performance metrics for tracking progress during the conduct of clinical trial. The key futures are Investigator database, project planning, budgeting, trial management. Enhance the CODA to provide Region, Currency, currency conversion and aggregate functionally for new added futures.

ROLE DESCRIPTION:

Work as senior developer in the development team for the CODA enhancement, Responsible for taking part in writing technical designs, and developing/unit testing of PLSQL procedures and packages for the CODA database. Also responsible for front end enhancements

RESPONSIBLE DELIVERABLES:

-Analyze user request for enhancement on currency and region

- Update design document for new enhancements

- Design Database and Create ER diagram.

- Create package, procedure and function to support currency and regional enactments

- Create unit and integrated test

- Perform unit and integrated test

-Lead development team for new enhancements

TECHNOLOGY/ APPLICATION EXPERIENCES:

- Takeda Pharmaceuticals North America, Inc TD templates for design, implement and testing, PL/SQL, TOAD, Visaul Basic.COM.

Project : IQM

Project Duration : May 2008 - Dec. 2008

Location : Westborough, MA Role : Oracle Data warehouse/Developer

PROJECT OVERVIEW:

The Information and Quality Management (IQM) organization provides reliability reporting to several organizations: Product Management, Engineering, Supply based Management, Manufacturing, Global Services, Sales, Marketing, Legal, and external customers. Outdated data schemas, multiple access databases, and manual processing limits scalability, data integrity, and efficient processing. The IQM Data & Report consolidation effort will create a stable, scalable and flexible infrastructure and will help to achieve an efficient delivery of accurate reports.

ROLE DESCRIPTION:

Work in the development team for the IQM reporting initiative at EMC, Responsible for taking part in writing technical designs, and developing/unit testing of PLSQL procedures and packages for the consolidation of the IQDF data mart into the CQDM data mart.

Also responsible for SIR remediation and Unix shell scripting

RESPONSIBLE DELIVERABLES:

- Wrote PL/SQL code to analyze Historical data

- Analyze Business Requirement against actual environment (throughput, response time, data volume growth and system impact)

- Design Database and Create ER diagram.

- Extract, Transfer and load data from different databases.

- Cerate Tables, Synonyms, Packages, Views, Materialized views, procedures, Functions, Indexes, Triggers. Sequences, DB links, Constrains, types.

- Guide and lead other developer especially on Dynamic SQL

- Create Technical Design, Build and Test for several modules

- Performance tuning.

TECHNOLOGY/ APPLICATION EXPERIENCES:

- EMC TD templates, PL/SQL, ETL, and UNIX script, TOAD.

- Performance tuning

Project : Gelco/PAS integration

Project Duration : Dec. 2007 - May 2008

Location : Westborough, MA

Role : Oracle Technical Designer

PROJECT OVERVIEW:

Integrate Gelco Expense link which is used by EMC employees to submit their expenses with Oracle Accounting System (PAS) to associate expenses with project and improve traceability of projects costs

ROLE DESCRIPTION:

Provide advanced developer experience to a small project team tasked to integrate an external expense system with an existing Oracle Project Account and Tracking module. Assist in design and development of several external interfaces, new reports and extension enhancements.

RESPONSIBLE DELIVERABLES:

-Wrote PL/SQL to analyzes data

- Create technical design for interface, extension, conversion and report

- Extract ,Transfer and load data from third party application to Oracle data base

- Extract and Transfer data from Oracle database to third party application

- Create test scenarios

- Performance tuning

TECHNOLOGY/ APPLICATION EXPERIENCES:

- EMC TD templates, ETL, OAF, Oracle Open Interface, PL/SQL, XML DB, Control-M Job, Harvest and UNIX script.

Project : CSI

Project Duration : April 2007 - Sept. 2007

Location : Westborough, MA

Role : Oracle developer

PROJECT OVERVIEW:

EMC Corporation is the world's leading developer and provider of information infrastructure technology and solutions (10 most valuable IT product companies). Help organizations of every size around the world keep their most essential digital information protected, secure, and continuously available.

Support and enhance EMC CSI system by development new capability and resolve issues and fix bugs.

ROLE DESCRIPTION:

Using front end, back end APIs and PL/SQL to support, test, and enhance CSI system and resolve SIRs issues.

RESPONSIBLE DELIVERABLES:

-Wrote PL/SQL to updating items data

-Wrote PL/SQL to find all circular relationship and fix it

-Wrote PL/SQL to integrate and educe the number of lines in the 11i interface tables.

-Wrote PL/SQL to clean up "Pending" records.

-Analyze and resolve daily bug tickets

-PL/SQL programming to implement data conversions, data validation

TECHNOLOGY/ APPLICATION EXPERIENCES:

- Oracle Pl/SQL, Unix, Oracle E-Business suite (Field Service, Logistic, Contract, Install Base).

Project : ITAS

Project Duration : Dec. 2006 - March 2007

Location : Hartford, CT

Role : Oracle developer

PROJECT OVERVIEW:

The ITAS project vision was to implement an innovative tax administration system that provides benefits to the State of Connecticut in the areas of customer service, revenue collection, technical modernization and effective employee utilization.

ROLE DESCRIPTION:

Support ITAS system by testing, debugging, enhancing, and solving SIR's.

RESPONSIBLE DELIVERABLES:

- Debug and develop PL/SQL scripts

- Debug and develop Oracle Forms

- Debug COBOL programs

TECHNOLOGY/ APPLICATION EXPERIENCES:

- Oracle Forms, Oracle Reports, PL/SQL, UNIX script and COBOL programs

Project : Legacy Modernization

Project Duration : Oct. 2006 - Dec. 2006

Location : Pittsburgh, IL

Role : Software developer

PROJECT OVERVIEW:

To modernize Highmark's administrative system and processes into reliable, adaptable assets that contributes to Highmark's ability to respond to continuous, fast-paced change,

Accenture technology personnel worked side-by-side with Highmark engineers to deliver Legacy Modernization project.

ROLE DESCRIPTION:

Participate on following activity on claim validation: using COBOL, IMS, and BlueDEVEL

RESPONSIBLE DELIVERABLES:

- Create document specification

- Implement program

- Module and integration testing

TECHNOLOGY/ APPLICATION EXPERIENCES:

- mainframe, COBOL, IMS, BlueDEVEL, Highmark design template

Project : FAST

Project Duration : April 2006 - Sept. 2006

Location : Needham, MA

Role : Database and Software Developer

PROJECT OVERVIEW:

FAST is a leading enterprise search vendor and an Accenture Information Management Services alliance partner. As part of this project, Accenture technology personnel worked side-by-side with FAST engineers to deliver consulting services to FAST end-customers.

ROLE DESCRIPTION:

- Participate in all software lifecycle phases of a FAST product implementation at FAST and/or Accenture clients (this may include design, development, integration, testing, deployment, maintenance)

- Become an Accenture subject matter expert in FAST's product from a technical and functional perspective

RESPONSIBLE DELIVERABLES:

Participated in the following FAST client engagements for Ayna.com the most popular site for Arabic:

-installed FDS 4 and ESP5

-installed and configured JDBC connector

-updated license manager server

-fetched database records (MySQL) and fed into the FDS 4

-configured incremental database update of the FDS4

-configured RSS feed

-created and configured category-taxonomy classifier dictionary

-configured FDS pipe line

-created custom document processor stage to manage database fields

-created custom document processor stage to deal with multilingual encoding issues

-created custom pipe line to lemmatized multilingual documents

-trouble shooting using system document utility like spy, log, xml

-Modified index profile to support database fields

-administrated FDS search engine

TECHNOLOGY/ APPLICATION EXPERIENCES:

-Unix script, MySQL, Python, FAST search engine

Project : DB Consultant & Web Design

Project Duration : July 2005 - April 2006

Location : Worcester, MA

Role : DB Consultant

PROJECT OVERVIEW:

Extend website and enhance inventory of ECE on WPI (Worcester polytechnic institute)

ROLE DESCRIPTION:

Redesign database and extend ECE website

RESPONSIBLE DELIVERABLES:

-Redesign database, define relations, constrains, normalize

-Develop Web application

-Fix bugs on web application and Access program

-Developed user interactive screens.

TECHNOLOGY/ APPLICATION EXPERIENCES:

-Unix, Perl, JavaScript, Apache, MySQL, HTML

Project : National ID card

Project Duration : June 2004 - June 2005

Location : Tehran, Iran

Role : DB consultant

PROJECT OVERVIEW:

Online access to nation civil registration data

ROLE DESCRIPTION:

Database designer

RESPONSIBLE DELIVERABLES:

- Design data model

- Design database

- Developed server side programs

- Developed Java classes confirming J2EE design patterns

- Worked with Struts framework for rendering user interface with MVC architecture.

- Implemented the Swing GUI components in screen designing

- Established database connection using JDBC-ODBC

TECHNOLOGY/ APPLICATION EXPERIENCES:

-UNIX, Mainframe, J2EE, Weblogic, Oracle 9, Struts, MVC architecture

Project : Accounting System

Project Duration : Sept. 2001 - June 2005 Location : Tehran, Iran

Role : Technical lead

PROJECT OVERVIEW:

Develop interface, accounting system for TEJARAT bank in conjunction with CR2 Automated Teller Machine (ATM) controller on UNIX server and bank back office on mainframe.

RESPONSIBLE DELIVERABLES:

- Analyzed, designed, implemented project with complete documentation such as ERD, DFD, FDD

- Wrote programs and reports

- Designed database, created table, stored procedures, and triggered

- Performed normalization, referential integrity, and database fine-tuning and refined query strings

- Created network connection, defined constrains, roles, permissions, storage, storages extension policies, automatic backup, export, import, and recovery policies

- Extracted data from legacy system, converted data from DB2, migrated from Oracle 8 to Oracle 9i

- Created data warehouse reports and data analysis

- Designed, implemented, managed source control software (VSS), led project by using Microsoft Project, provided user manual, version control procedure, installing, and auditing control

- Led 24*7 support team

- Analyzed data and customer's records

TECHNOLOGY/ APPLICATION EXPERIENCES:

-Mainframe, Windows 2000 server, VB6, ADO, Crystal Reports, PL/SQL, ODBC, DB2, VSS, Oracle 8-9 Education: University/College Degree Year Amir Kabir University of Technology B.S. 2/1995 Training/Continuing Education Course Company/Vendor Date Taken Oracle Forms Developer 10g: Build Internet Applications Oracle university May 2007 Custom application design Accenture July 2007 Package Application Design Accenture October 2007 Application Analysis Concept Accenture, MIT course March 2008 Informatica PowerCenter Informatics September 2009 Advance Data Modeling Accenture Feb 2010 Certifications Certification Year Certified ACN-ASDA Application Designer 2009 Skills Skill Proficiency Database Technologies Expert Oracle-Database Expert Oracle-PL/SQL Expert COBOL Expert XML Proficient HTML Proficient Oracle-TOAD Advanced Visual Basic Advanced JAVA Proficient JavaScript Proficient ADM: Custom Development Proficient ADM: Packaged Development Proficient App Mntc & Prod Support Proficient BMC-Control-M Proficient C Proficient IBM-Informix / Red Brick Proficient IBM-Tivoli Monitoring Proficient Informatica-PowerCenter Proficient Linux Proficient Microsoft-DOS PC Architectures Proficient Microsoft-FAST search Proficient Microsoft-Office-Access Proficient Microsoft-SQL Server-Database Proficient Oracle-Forms Proficient Oracle-Reports Proficient PERL Proficient Python Proficient Test Management Proficient UNIX - Shell Scripting Proficient Arabic Novice IBM-Ascential-ETL Proficient Information Architecture / Taxonomy Proficient BEA-Weblogic Trained C++ Trained

Contact this candidate