SUMMARY:

• Install, configure, diagnose, and resolve technical Windows PC problems
• Working knowledge of information systems industry terms and concepts
• Flexible innovative, multi - talented and willing to learn
• Excellent written and verbal communications skills
• Team player with global vision
• Excellent negotiation ability
• Powerful customer relations skills
• Self-motivated, with strong ambitions for the future
• Leader and manager with strong human resource skills
• Strong managerial skills; planning, prioritizing, and organizing
• Strong analytical skills; quantitative and financial
• Strong working knowledge of Windows Word, Excel, and Access

TECHNICAL SKILLS:

SOFTWARE: Integration ETL Architect / Developer using QualityStage Essentials v7.0, DataStage Enterprise Edition, DataStage Server v8.5, ETL, SQL, UNIDATA, UNIVERSE, REALITY PICK, PRIME INFO BASIC D3 UNIQUERY, Pick Systems, Microsoft Word, PowerPoint, Excel and AccessCertified on: AS400, RS6000, AIX, UNIX, SCO UNIX, LINUX, Windows NT, Windows 2000, Windows XP, Windows Vista

PROFESSIONAL EXPERIENCE:

Confidential

ETL Datastage/QualityStage and SQL Server Developer

Responsibilities:

• Working within an agile technically challenging work environment. Using Datastage/Qualitystage 9.1 to extract, transfer and load data from Oracle database tables.
• Ability to create complex Datastage data extraction jobs.
• Preforming Data Modeling procedures
• Using Rapid SQL 8.0 to verify data results within Oracle database tables.
• Designing high level Datastage processes.
• Developed Datastage jobs to read files from multiple applications using complex flat files and sequential file stages.
• Developed DataStage jobs for unit testing
• Developed DataStage jobs for loading data into Oracle tables using Oracle connector stages.
• Analyzed defects within DataStage application jobs and applied fixes to the DataStage jobs and Sequences
• Create Orcale code, store procedures, views, triggers and functions with Oracle database environment.
• Developed UNIX scripts within AIX UNIX operating system.
• Supporting DBA’s in business requirement, code reviews and documentation.
• Support user acceptance testing, job performance and optimization.
• Support implementation of jobs and deployment to the production environment.
• Setup initial testing environment.
• Perform DataStage job fixes.
• Perform peer-to-peer code reviews.
• Monitor DataStage production jobs and perform urgent changes when necessary.
• Worked independently and with other team members on daily data projects

Confidential

ETL Datastage/QualityStage and SQL Server Developer

Responsibilities:

• Working remotely, within a fast pace ttechnically challenging environment using SQL Server and Datastage/Qualitystage 9.1 to extracting, transfer and loading data from DB2 database tables.
• Ability to create Datastage data extraction jobs.
• Ability to create Qualitystage data matching jobs.
• Preforming Data Modeling procedures
• Using Rapid SQL 8.0 to verify data results within DB2 database tables.
• Designing high level Datastage and Qualitstage processes.
• Developed Datastage jobs to read files from multiple applications using complex flat files and sequential file stages.
• Performed reconciliation of the data by matching row counts and hash totals using SQL queries
• Developed DataStage jobs for unit testing
• Developed DataStage jobs for loading data into DB2 tables using DB2 connector stages.
• Analyzed defects within DataStage application jobs and applied fixes to the DataStage jobs and Sequences
• Create DB2 code, store procedures, view, triggers and functions with DB2 database environment.
• Developed UNIX scripts within AIX UNIX operating system.
• Supporting DBA’s in business requirement, code reviews and documentation.
• Support user acceptance testing, job performance and optimization.
• Support implementation of jobs and deployment to the production environment.
• Setup initial testing environment.
• Perform DataStage and QualityStage job fixes.
• Perform peer-to-peer code reviews.
• Monitor DataStage/QualityStage production jobs and perform urgent changes when necessary.
• Worked independently on daily and weekend data transfer and data validation projects
• Assisted in installation, managing and proformance tuning of Netezza databases and other records.
• Performed backups and recovery functions of Netezza databases.
• Provided technical assistance for efficient performance and security functions of Netezza database.

Confidential

Lead ETL DataStage Developer /SQL Server Developer

Responsibilities:

• Work remotely using DataStage 8.5 and SQL Sever 8.0
• Created DataStage jobs to extract date from legacy system files.
• Developed DataStage jobs to read files from multiple applications using flat and sequential files
• Developed SQL queries to reconciliation of matching data record counts.
• Analyzed defects within DataStage application jobs and applied fixes within job DataStage jobs and Sequences.
• Created SQL data staging tables and loaded extracted data into SQL Server 2008 data warehouse.
• Responsible for monitoring DataStage production jobs and restarting production jobs.
• Monitor data warehouse production processes and restarting any aborted processes due to lost network communications with the production server.

Confidential - Houston Texas

DataStage Administrator/Lead Datastage Developer

Responsibilities:

• Using DataStage Server 7.5.3 to extract data from the universe multi value files and load into SQL Server 2005 data warehouse.
• Design advanced SQL queries, stored procedures, triggers, scripts maintain, modify, and optimize the SQL store procedures for SQL server databases. Responsibilities include - mentoring other data processing staff on the use and functionality of DataStage. Creating source to target data mapping for all Pick/universe data files. Developing DataStage jobs to handle the loading of critical data within the SQL database tables. Scheduling DataStage production ETL production jobs. Monitoring all DataStage production job processes and making critical adjustments where need.
• Responsible for supporting Pick Universe legacy systems, within a AIX Unix environment Making Modifications, test, debug and document programs on large, complex projects using the Pick database and programming using Pick Universe to current system software.

Confidential - Plano Texas

Programmer Analyst / SQL Developer

Responsibilities:

• Responsible for supporting Pick Universe legacy systems, within a AIX Unix environment Making Modifications, test, debug and document programs on large, complex projects using the Pick database and programming using Pick Universe to current system software.
• Revise and update programs and documentation, developing specifications, developing new system modules.
• Developing Data conversion modules for data transfer of legacy system data files.
• Exporting data from the Pick Universe data files, determining data requirements needed to be loaded into SQL data base tables.
• Design advanced SQL queries, stored procedures, triggers, scripts maintain, modify, and optimize the SQL store procedures for SQL server databases.
• Using QuailityStage as a data quality tool to qualify and cleans the universe data
• Using DataStage to extract data from the universe multi value files and load into DB2 and SQL data warehouse.
• Collaborate with applications developers on data modeling and system diagrams.
• Manage database performance, capacity, replication, backup and security.
• Work with external entities of the company to transfer data. Assist business analysts and end-users with reporting needs
• Involved in requirements gathering and source data analysis and identifiedbusiness rules for data migration and for developing data warehouse data marts. Involved in identifying the data inputs from various source systems depending upon the business requirement. Created source to target mapping documents from staging area to Data Warehouse and from Data Warehouse to various Data Marts. Involved in low-level design and developed various jobs and performed data loads and transformations using different stages of DataStage and pre-built routines, functions and macros.
• Based on business requirements, design, develop and maintenance of applications using Visual C#. and ASP.Net with Visual Studio 2005, SSIS, and SQL Reporting Services.

Confidential - Westborough, MA

Software Consultant / ETL Developer

Responsibilities:

• Responsible for executing and completing development of DataStage Server 7.5 and QualityStage 7.0 jobs. Including gathering requirements, analyzing, designing, testing, implementing ETL and Data Quality processes.
• Worked as part of the development team responsible for making enhancements and supporting ETL jobs within the Data Warehouse environment
• Skillfully utilized metadata and data quality processes and procedures
• Interact with Management to better understand business, and system challenges to develop, diagnose, and modify ETL jobs related to Data Warehouse integration issues.
• Managed ETL DataStage and QualityStage integration projects as assigned to be on time and within allocated budget.
• Provided guidance and transfer knowledge on job requirements to other ETL DataStage and QualityStage developers
• Provided Administrative support on AIX Unix system for DataStage and QualityStage production jobs. Provided installation and upgrade support of AIX Unix systems. This would include administrative procedures of creating new directories, new mount drives, copying, uncompressing, untar of system and application files. Performance tuning of unix system and newly installed applications. Provided documentation of all upgrades, installations, performance tuning, and production jobs executed on AIX system.
• Developed ETL application at RBC in Toronto Canada, using XML product tools to migrate informatica data to DataStage jobs.

Confidential - Newport Beach, CA

Senior Programmer Analyst

Responsibilities:

• Developed and maintained a Pick mortgage software system on AIX UNIX system, running D3 Pick. Provided installation and upgrade support of AIX Unix systems. This would include administrative procedures of creating new directories, new mount drives, copying, uncompressing, taring, untaring of system and application files. Performance tuning of AIX unix operation system and newly installed applications.
• Designed and developed new software, maintaining and supporting existing software
• Assisted with deployment of software
• Created technical documentation (Design documents, workbooks, etc.).
• Reviewed codes/designs, and assisted QA with developing test cases and test plans.
• Advised Business Analysts, Technical Developers and Technical Operations Departments.

Confidential - Hoffman Estates, IL

Senior Programmer Analyst

Responsibilities:

• Develop and maintain advance Pick software on a SCO UNIX system, running Advanced Pick.
• Developing financial and cost analysis reports for every bed manufacturing plant.
• Provided technical support for the Citrix Network system, setting up new employees from different company factors located in different part of the country.

Confidential - Phoenix, AZ

Senior Programmer Analyst

Responsibilities:

• Develop and modify existing Pick software applications on an AIX UNIX operating system run Universe Pick environment. Provided installation and upgrade support of AIX Unix systems. This would include administrative procedures of creating new directories, new mount drives, copying, uncompressing, untar of system and application files. Performance tuning of unix system and newly installed applications.
• Provided software support for the inventory control system. This software was developed for the food warehousing industry.

Confidential - Sugar Land, TX

Senior Programmer/Systems Analyst

Responsibilities:

• Modified existing Pick software applications on a RS6000 system
• Developed, documented, and maintained AIX UNIX operator systems
• Provided software support for the Service Order, Payroll, Accounting, and Reports Generating Systems

Confidential - Lakeland, FL

Senior Programmer Analyst

Responsibilities:

• Modified existing Pick software applications on General Automation Sequoia system
• Designed, Engineered, and implemented Y2K software applications
• Developed, documented, and maintained AIX UNIX operator systems
• Provided software analysis applications for Order Entry Systems
• Supported Sales/Contract Processing System, Finance and Mortgage Banking Applications Customer Reservations Package, Project Management Time and Tracking System 4GL Screen Code Generation System.

Confidential - San Diego, CA

Senior Programmer Analyst

Responsibilities:

• Monitored and maintained a SCO UNIX platform system
• Modified existing Universe Pick Applications: Purchase Order, Inventory, and Sales Order Systems

Confidential - Irvine, CA

Senior Programmer Analyst

Responsibilities:

• Modified Unidata Pick software application on a HP 9000 AIX (UNIX Platform)
• Modified company’s P.O.S. system to handled credit card information
• Developed, documented, and maintained AIX UNIX operator systems
• Provided software analysis applications for Order Entry System

Confidential - South Lakeland, FL

Senior Programmer Analyst

Responsibilities:

• Modified existing Pick software applications on General Automation Sequoia system
• Designed, Engineered, and implemented Y2K software applications
• Developed, documented, and maintained AIX UNIX operator systems
• Provided software analysis applications for Order Entry System
• Supported: Sales/Contract Processing System, Finance and Mortgage Banking Applications, Customer Reservations Package, Project Management Time and Tracking System, 4GL Screen Code Generation System

Confidential - Redlands, CA

Senior Programmer Analyst

Responsibilities:

• Developed and maintained Pick software application
• Consolidated multiple databases into a single insurance eligibility data repository
• Modified the claims processing applications to run more efficiently
• Coordinated applications developments, and software enhancements.

Confidential - Perris, CA

Senior Programmer Analyst

Responsibilities:

• Developed, documented, and maintained SCO UNIX operator systems
• Developed, modified receiving and accounting software applications
• Provided software analysis applications for accounting departments
• Developed and maintained personal computer applications; DOS and Microsoft
• Developed static database application; Rbase rev. 4.5 relational database software.

Confidential - Santa Ana, CA

Responsibilities:

• Computer Operations/Programmer Analyst/Data Processing Coordinator
• Developed, Documented, and maintained Reality Pick/PROC software applications on four McDonnell Douglas Series 18 computer systems.
• Provided software application and hardware technical support for all MIS department internal Super Mini Pick Base computer systems, Microsoft PC-Based computer systems, and peripherals
• Provided software application support for Finance Sales/Marketing, and Payroll departments.
• Provided technical support for installations of new computer systems and data communication equipment.
• Supervised day shift computer operations personnel, Tape Librarian, and Report Distributor.