Data Sales

ALEC MENGLIDE

*** **** **. ***. ****, New York, NY 10044 | 212-***-**** | 347-***-**** | i17ek7@r.postjobfree.com

SUMMARY

Effective and result-driven senior programmer/ analyst with extensive experience in development and implementation of various IT systems structures. Solid analytical skills. Highly motivated, dependable troubleshooter and problem-solver. User-oriented, prompt and accurate support provider. Excellent interpersonal relationships.

KEY TECHNICAL SKILLS AND STRENGTHS

Data Warehousing

Informatica PowerCenter 8.x

DataFlux dfPowerStudio 8.1

Data analyzing and cleansing

Application Development AS400

ERP System - Maintenance and Support Management

SQL

PROFESSIONAL HISTORY

Jan. – Mar. 2010 BRISTOL MYERS SQUIBB – Princeton, NJ

Consultant: Used DataFlux dfPowerStudio to profile, monitor and manage the quality of enterprise data for product single-access point project. Identified business rules to be used on all points of entry to integrate and standardize data across multiple systems and business units.

2002 – 2009 PFIZER - Peapack, NJ

Consultant: Designed and developed series of Informatica/ ETL processes to allow data migration from Pfizer Legacy ERP System (MAPS) into Oracle. Built new sources, targets, mappings, sessions and workflows using PowerCenter 8.x best practices and tools to move data from DB2 database files into Stage 2 Oracle tables. Developed solutions for complex data manipulation. Performed Back-End integration testing to guarantee data consistency writing SQL queries on Oracle tables. Used Master Data Management (MDM) tool DataFlux Power Studio to determine inconsistencies and redundancies for data profiling. Used dfPowerArchitect to create work flows for data collection, transformation, enrichment and normalization based on business rules requested by the target Oracle tables. Created text scripts developed with Quality Center to perform functional testing for all Informatica workflows. Designed Freiburg, Germany interfaces from MAPS to MES/ASSISTS systems. Wrote fully automated data extraction/consolidation processes to transfer data to a TANDEM machine via FTP. Analyzed, designed, coded and implemented Global Inventories System. Designed and developed stored procedures for Inventory, Work in Process, Purchasing and Planning modules needed for upgrade of new MAPS release. Maintained MAPS software and provided user support for worldwide Pfizer locations.

Sept. – Oct. 2002 TOWN OF HARRISON - Harrison, NY

Consultant: Developed and tested software indispensable to system security upgrade from 20 to 40.

Jan. – Aug. 2002 BARSA CONSULTING GROUP – Rye, NY

Consultant: Designed interactive application and provided support and maintenance for AR system. Designed and implemented enhancements to the communication between ‘in-house’ Billing System and Dynax System. Maintained Tracking Sales System for APRM product.

ALEC MENGLIDE

580 Main St. Apt. 1612, New York, NY 10044 | 212-***-**** | 347-***-**** | i17ek7@r.postjobfree.com

May 2000 – May 2001 GOLDMAN SACHS – New York, NY

Full time Senior Programmer Analyst, Futures Department: Developed programs destined to extract GMA data residing on AS400 that replicate into Global database and Sybase database in real time by utilizing DataMirror (DM) transformation server. Designed exit routines for maintaining referential integrity on all Global database tables using RPG/ILE with heavy embedded SQL using DM-obtained before/after transaction image. Provided maintenance and production support for Global database.

1998 – 2000 SIMON PROPERTY GROUP – New York, NY

Full time Senior Programmer Analyst: Designed interactive application in RPG/ILE for Lease Inquiry System, Accounting and Sales Analysis using APIs and stored procedures. Personally wrote an updated ‘in-house’ software CTI standards compliant. Managed and performed Y2K compatibility testing for SPG/CTI packages.

1991 - 1998 CORPORATE PROPERTY INVESTORS – New York, NY

Full time Senior Programmer Analyst, Project Leader: Managed a team of programmers in system design and development of rental modules software. Rewrote and maintained COBOL software packages. Designed and developed applications in RPG-400 to modify/ customize existing system to meet operations workload. Established operations schedules, restructured backup procedures and implemented systems security. Acted as Security Officer 1996-1998.

HARDWARE

IBM Midrange and Mainframes AS400, System 38, IBM390

IBM PC Laptops, Desktops and Servers (Compaq, Dell, HP)

SOFTWARE

Informatica/ETL, DataFlux, Mercury HP Quality Center

Mainframe Programming Languages (RPG/ILE-CLP, DDS, SQL, COBOL, Oracle TOAD)

Desktop User Tools (Word, Excel, Access, PowerPoint)

Financial Software: J.D. Edwards, CTI, GMI

COMMUNICATIONS

Client/ Access, TCP-IP, FTP, TelNet

______________________________________________________________________________________

LANGUAGES English, French, Romanian

EDUCATION

Computer Science Polytechnic Institute – Bucharest, Romania

______________________________________________________________________________________

Contact this candidate