TECHNICAL SKILLS:

SOFTWARE: Confidential Datastage, DataStage Enterprise Edition, DataStage Server v8.5, Integration ETL Architecture, Management, Development using Confidential Information Governance, QualityStage Essentials v7.0, ETL, SQL, UNIDATA, UNIVERSE, REALITY PICK, PRIME INFO BASIC D3 UNIQUERY, Pick Systems, Microsoft Word, PowerPoint, Excel and Access

HARDWARE: 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

PROFESSIONAL EXPERIENCE:

Confidential - Houston Texas

Senior Analyst/Lead Confidential Datastage 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.
• Worked on Confidential InfoSphere DataStage to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Ability to create complex Infosphere Datastage data extraction jobs.
• Preforming Data Modeling procedures
• Using Rapid SQL 8.0 to verify data results within Oracle database tables.
• Designing high level Infosphere Datastage processes.
• Developed Infosphere Datastage jobs to read files from multiple applications using complex flat files and sequential file stages.
• Developed Infosphere DataStage jobs for unit testing
• Developed Infosphere DataStage jobs for loading data into Oracle tables using Oracle connector stages.
• Analyzed defects within Infosphere nDataStage application jobs and applied fixes to the Infosphere 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 Infosphere DataStage job fixes.
• Perform peer-to-peer code reviews.
• Monitor Infosphere DataStage production jobs and perform urgent changes when necessary.
• Worked independently and with other team members on daily data projects

Confidential - Boston Massachusetts

Senior Analyst/Lead Confidential Datastage Developer

Responsibilities:

• Working remotely, within a fast pace ttechnically challenging environment using SQL Server and Confidential Infosphere Datastage/Qualitystage 9.1 to extracting, transfer and loading data from DB2 database tables.
• Ability to create Infosphere Datastage data extraction jobs.
• Ability to create Infosphere Qualitystage data matching jobs.
• Preforming Data Modeling procedures
• Using Rapid SQL 8.0 to verify data results within DB2 database tables.
• Designing high level Infosphere Datastage and Infophere Qualitstage processes.
• Developed Infophere 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 Infophere Datastage jobs for unit testing
• Developed Infophere Datastage jobs for loading data into DB2 tables using DB2 connector stages.
• Analyzed defects within Infophere Datastage application jobs and applied fixes to the Infophere 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 Infophere Datastage and Infophere Datastage job fixes.
• Perform peer-to-peer code reviews.
• Monitor Infophere 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.
• Ability to develop Android application using Confidential mobile data for Black Barry and Samsung mobile devices.

Confidential - Scottsdale Arizona

Senior Analyst/Lead Confidential Datastage Developer

Responsibilities:

• Work remotely using Infophere Datastage 8.5 and SQL Sever 8.0
• Created Infophere Datastage jobs to extract date from legacy system files.
• Developed Confidential Infophere 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 Infophere Datastage application jobs and applied fixes within job Infophere Datastage jobs and Sequences.
• Created SQL data staging tables and loaded extracted data into SQL Server 2008 data warehouse.
• Responsible for monitoring Infophere 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

Senior Analyst/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

Senior Analyst/ Confidential Datastage Developer

Responsibilities:

• Extensively worked on Confidential information server DataStage 8.5 to create Parallel Jobs using various stages like Aggregator, Transformer, Dataset, Row Generator, Column Generator, Filter, Funnel, Join, Lookup, Lookup File Set, Copy, Peek, Oracle Enterprise, DB2 UDB, Change Capture, Remove Duplicates, Merge, Pivot, Sequential file and FTP Stages
• 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 identified
• 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

Senior Analyst / 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

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

Programmer Analyst

Responsibilities:

• Develop and maintain advance Pick software on a SCO UNIX system, running Advanced Pick.
• Developing financial and cost analysis reports from the Profit and Loss statement sheet for every bed manufacturing plant. The reports would include, the cost of manufacturing bed/mattress products, the gross profile for the quarterly period after credit or discounts from the gross revenue of bed/mattress sold. Reporting all the operating expenses from manufacturing the bed/mattress products for each 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

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

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

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

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

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

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

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

Computer Operations/Programmer Analyst/Data Processing Coordinator

Responsibilities:

• 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.