We provide IT Staff Augmentation Services!

Center Associate Resume

0/5 (Submit Your Rating)

Hattiesburg, MS

PROFESSIONAL SUMMARY:

  • Overall 8 years of software development experience, with 4 years ETL experience using IBM DataStage, and 3+ years of experience as a PeopleSoft developer.
  • Worked on each phase of the software development lifecycle in ETL and ERP, from design to implementation and support.
  • Demonstrated expertise utilizing DataStage 8.1 and DataStage 9.1.
  • Strong supporting skills in database development using SQL Server Management Studio (SSMS).
  • Team player with excellent communication and problem solving skills.
  • Currently holds a Secret clearance.

TECHNICAL SKILLS:

ETL Tools: IBM DataStage 8.1/9.1, Microsoft SQL Server Integration Services 2008

Operating Systems: Windows Server 2003/2008, UNIX/Linux

Languages: Microsoft T - SQL, Oracle PL/SQL, XML, HTML, Sun Certified Programmer for Java 2 Platform 1.4

Databases: Microsoft SQL Server 2008 R2, Oracle 9i/10g

ERP Software: PeopleSoft Financials 8.9/9.0, PeopleSoft HCM 8.9, PeopleSoft CRM 8.9

Other Software: Microsoft Word, MS Excel, MS PowerPoint, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Hattiesburg, MS

Center Associate

Responsibilities:

  • Lead a team of ETL/DW developers in designing, implementing, and supporting ETL / data warehouse solutions.
  • Managed resourcing of the ETL team across multiple parallel development efforts and O&M activities.
  • Worked with project managers and business analysts to define ETL and data warehouse requirements.
  • Collaborated with Business Intelligence developers and data stewards to design flexible, efficient data models and transformations.
  • Designed data models and ETL for data warehouses feeding multiple report views and encompassing multiple subject areas.
  • Analyzed and tweaked DataStage ETL and SQL Server structures for performance improvement.
  • Performed IBM Information Server administration tasks, including installing and configuring Installation Server in accordance with Department of Defense STIG requirements.
  • Developed ETL using IBM DataStage and SQL Server, to load and transform data from multiple sources into standard data warehouse structures.
  • Worked with project managers and business analysts to define requirements.
  • Converted business requirements into database and ETL designs.
  • Designed data models for data warehouses supporting data from multiple sources and feeding multiple report views.
  • Implemented ETL using IBM DataStage and SQL Server, to load and transform data from multiple sources into standard data warehouse structures.
  • Built ETL using IBM DataStage and MS SQL Server to load and transform data from multiple sources into data warehouses.
  • Supported a PeopleSoft CRM 8.9 installation for a help desk / call center.
  • Developed new reports to provide statistics on help desk performance.
  • Documented the PeopleSoft CRM installation and configuration procedures.
  • Scrubbed PII from help desk data using PeopleSoft tools and Oracle PL/SQL.
  • Implemented additional enhancements to the PeopleSoft installation based on client requirements.

Confidential, Hattiesburg, MS

Application Developer

Responsibilities:

  • Created technical specifications and data mappings for PeopleSoft Financials 9.0 customizations according to the client’s business needs.
  • Developed SQR programs to extract data from PeopleSoft Financials 9.0 for integration into the client’s data warehouse.
  • Implemented SQR programs to interface a PeopleSoft Financials 8.9 system with numerous external data sources.
  • Implemented client business processes into a PeopleSoft Financials 8.9 system via extensive customization of the existing PeopleSoft pages and application code.
  • Created and executed test scripts for both technical and functional testing of the PeopleSoft customizations.
  • Constructed SQRs to populate a PeopleSoft HCM 8.9 system with legacy data files.

We'd love your feedback!