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.