We provide IT Staff Augmentation Services!

Datastage Etl Developer/analyst Resume

2.00/5 (Submit Your Rating)

SUMMARY

  • Highly accomplished Business and Technical Project Manager responsible for various development projects in the business applications development arena.
  • Experienced in all areas of Project Management, Business (BLC) and System Development Life Cycle (SDLC) Methodologies for business application development. In addition, directed several run time improvement (RTI) efforts on multiple development platforms.
  • A background in business applications development, production support, enterprise system architecture, systems engineering, and database utilization allows me to effectively manage the project across functional areas.

CORE COMPETENCIES

  • Team Leadership
  • Communications
  • Goal Setting & Work Prioritization
  • Requirements Gathering
  • Business Process Improvement
  • Project Plan Development
  • Functional & Technical Specifications Development
  • Resource Planning and Tracking
  • Offshore Resource Management
  • Scope Management
  • Reporting and Metrics
  • Testing (Unit, Integration, System, Regression, UAT)
  • Risk and Dependency Management
  • Change Management
  • Release Planning and Management
  • Information Analysis for Rapid Problem Identification & Resolution
  • Contingency Planning and Disaster Recovery

AREAS OF EXPERTISE

  • Finance
  • Corporate Accounting
  • Cost Accounting
  • Human Resources
  • Payroll
  • Insurance Compensation
  • Accounts Payable & Receivables
  • Enterprise Address Standardization
  • National Change of Address (NCOA)
  • Call Center Knowledge Management
  • Insurance Claims Automation
  • Towing & Emergency Road Service Programs

PROJECT TOOLS

  • MS Office Suite
  • MS Project
  • MS Live Meeting
  • Mercury Test Director
  • Visio
  • Lotus Notes
  • SharePoint
  • Primavera
  • Trac
  • Lync

TECHNICAL SKILLS

  • DataStage (ETL) job coding
  • DataStage process automation using DataStage job sequencers
  • ColdFusion web site development
  • HTML programming
  • ColdFusion Application Server installation & configuration
  • InfoMaker
  • Dataflux
  • Master Data Management (MDM) Hub Architecture
  • MS IIS installation & configuration
  • Installation and configuration of NT Server
  • Installation and configuration of Windows NT Workstation
  • Installation and configuration Novell Netware
  • Intel hardware - specifications & build of servers & workstations
  • Unix System Administration
  • AIX (Kornshell) Scripting
  • Unix VI Editor
  • AIX batch COBOL coding
  • AIX batch process automation
  • BMC Scheduler
  • Custom interface development
  • Systems Engineer
  • Enterprise Systems Architect
  • Mainframe batch coding: COBOL EZTrieve RPG Assembler Machine Language
  • IBM Utilities: IDCAMS IEBGENER SYNCSORT IEBCOPY IEFBR14 FTP TSO JCL JCL PROCS PCL VSAM File Aid CA - 7 Scheduler
  • Mainframe online coding (CICS)
  • Mainframe memory core dump solving
  • Data modeling
  • Mainframe batch process automation
  • Mainframe run time improvements (RTI)
  • Mainframe Operating Systems: DOS VSE/VM MVS/ESA OS/390
  • Databases: IMS DL/I DB2 (Mainframe & AIX) IBM Universe (AIX) Teradata

PROFESSIONAL EXPERIENCE

Confidential

Datastage ETL Developer/Analyst

Responsibilities:

Responsible for converting/migrating existing Enterprise Data Warehouse (EDW) production processes consisting of Teradata V14.13 BTEQs, Datastage jobs and Kornshell scripts to a new Linux grid computing environment. This included converting Datastage V8.1 server jobs and V9.1 parallel jobs to V11.3 parallel jobs. The new processes executed out of confidential's Control-M scheduler running on Linux servers. In addition, provided on-call support for existing production processes executing out of Task Scheduler on Windows Servers 2003 & 2008 R2 during the conversion/migration.

Confidential

IT Project Manager

Responsibilities:

Responsible for managing implementation of Right Answers knowledge management application for call center agents across the US. This includes managing the vendor and internal technical teams implementing Websphere Virtual Enterprise servers on Windows Server 2008 R2. This configuration was used to host the RightAnswers application and Java 7 in conjunction with IIS 7. A SQL Server 2008 database was installed in support of the RightAnswers application. In addition, responsible to PMO for budget, status reporting, capital accounting, resource plan, project plan, risk and dependency management. This $2,000,000+ project requires interaction with business and IT stakeholders, sponsors, and executives.

Confidential

Business Project Manager

Responsibilities:

Managed multiple P&C Claims projects in a matrix environment (usually 2-3 concurrently). Projects included management of the company's roll out of their new Tow/Emergency Road Service (ERS) program. This included oversight of third party administrators (Road America and Agero), Java software automation of vendor invoicing and EDI 820 payment processing pertaining to Towing and ERS Claims. In addition, responsible for preparing Business Case Proposals, Business Case Development, Project Charters and High Level Solution Design, consistent with the Business Life Cycle. Other responsibilities included risk and dependency management, stakeholder identification, preparing work schedules, budgets, and management reports for multiple agile development projects ranging from $150,000 Business Case Development projects to $2,000,000+ application development projects.

Confidential

Technical Project Manager

Responsibilities:

Served as Technical Project Manager over three development groups (Mainframe COBOL & RPG, AIX COBOL & KornShell scripting, DataStage ETL). Managed multiple IT projects (usually 3- 4 concurrently), all related to business product offerings in the company's membership billing, road service, insurance agent commissions, payroll, human resources, customer relationship management (CRM), & membership counselor inquiry systems. This included enhancements, new product & service development, up to and including, the final phases of software release. In addition, ensured timely defect resolution, resource management, implementation planning and adherence to established standards.

Confidential

Network Engineer / Cold Fusion Web Developer

Responsibilities:
  • Installed and configured Cold Fusion (V4.5) development & production environments on Windows NT Server Operating System (V4.0);
  • Installed and configured Cold Fusion Application Server (V4.5) in support of Cold Fusion web site development;
  • Installed and configured IIS Server (V2.0, V3.0, V4.0) in support of Cold Fusion web site development;
  • Upgraded from IIS V2.0 to IIS V3.0 in support of Cold Fusion development & production environments;
  • Upgraded from IIS V3.0 to IIS V4.0 in support of Cold Fusion development & production environments;
  • Installed and configured Windows NT Server (V4.0) for development and production servers;
  • Designed and implemented web site using Cold Fusion (V4.5) development software;
  • Installed and configured Windows Workstation (V4.0);
  • Installed and configured SMC Barricade HW Firewall in support of Cold Fusion web site development;
  • Installed and configured SMC Barricade HW Firewall in support of Cold Fusion web site development;
  • Managed Windows NT (V4.0) hard drive partitions using Partition Magic (V4.0) in support of Cold Fusion web site development;
  • Set up FTP Server on Windows NT Server (V4.0) to send and receive files in support of Cold Fusion web site development;
  • Provided technical support for existing small office Novell and Windows networks;
  • Provided software and hardware recommendations to executive management;
  • Provided budget estimates for upgrades and new computer hardware & software ;
  • Built & configured purpose specific Intel based Novell Netware, Windows NT servers & Windows workstations ;
  • Troubleshoot network problems and recommend solutions;
  • Troubleshoot synchronous & asynchronous communications and recommend solutions;
  • Convert 10-baseT network to Ethernet network;
  • Supervised office move(s), setup, & configuration, of all computer related equipment & Ethernet cabling installation at the new office site;
  • Provided industry specific training for software installed at client site.

Confidential

Business Systems Analyst

Responsibilities:

Primary Business Analyst for the Insurance Broker Commissions System. Duties included c reating business design documents and technical design specifications for Broker Commissions System enhancements. In addition, I was responsible for verifying the Powerbuilder programmer's code matched the technical design specifications to insure timely and accurate broker commission checks were distributed to insurance brokers.

Confidential

Mainframe Programmer/Systems Analyst

Responsibilities:

Performed systems engineering and programmer duties in support of Government Cost Accounting Mainframe Software Application. These duties included; functional requirements gathering, analysis, design, development, QA, and implementation in support of new development and software enhancements to; COBOL, EZTrieve, & Assembler programs. Duties included:

We'd love your feedback!