TECHNICAL SKILLS:

Platforms: Windows, UNIX, LINUX

Database: Oracle 11g, MySQL, SQL Server

Languages: SQL, PL/SQL, C/C++, Java

Software: Informatica Power Center, Erwin, People Soft, BlackLine, Oracle Financials, BIQ, IIPAS, Oracle BPM, Hyperion Enterprise, HPSM, ADR, TWS, AutoSys

Tools: Toad, Excel, Power Point, Word, Visio, Project, Proxy, Citrix, Editpad, WinZip, Remote Desktop Connection

PROFESSIONAL EXPERIENCE:

Enterprise Resource Planning Analyst

Confidential, Minnetonka MN

Responsibilities:

• PeopleSoft
• Production subject matter expert for the PeopleSoft Asset Management module
• Responsible for closing incident/problem requests to meet the required service level agreements
• Prioritized incident/problem requests from low to high in regards to impact to business community
• Create SDLC documentation for code changes to include Request, Design, Testing and Deployment documents
• Contacted vendor to remediate complicated software issues
• Create necessary ADR’s for production installations and procured the necessary approvals from IT and Business Users
• Lead projects related to the PeopleSoft Asset Management application to include Great Britain and India asset conversions, Recalculation of the Bonus Depreciation for all assets put into service for the newly enacted Economic Reinvestment Act of 2010, Added two new books, an Alternative Minimum Tax,
• Responsible for closing incident/problem requests to meet the required service level agreements
• Prioritize incident/problem requests from low to high in regards to impact to business community
• Lead, develop, and maintain vendor relationship to remediate complicated software issues
• Lead Wintel Optimization Project. This project included moving the application and database from physical servers to virtual servers for cost savings reasons.
• Create project plans for infrastructure change.
• Create SDLC documentation for code changes to include Request, Design, Testing and Deployment documents
• Create necessary ADR’s for production installations and procured the necessary approvals from IT and Business Users
• Install and Administer the BlackLine General Ledger Account Reconciliation software application. The application is installed on the Windows 2008 servers using the IIS7 Web Server and SQL Server 2008 for the database.
• Update and research SQL server code for any failures or inefficiencies in the BlackLine application
• Lead HPSM Incident Review meeting wif BlackLine business owners
• Oracle Financials
• Production subject matter expert for the PHS Oracle Financial application
• Responsible for closing incident/problem requests to meet the required service level agreements
• Prioritize incident/problem requests from low to high in regards to impact to business community
• Administer the Pacific Health Care Oracle Financial application. The data from Pacific Health Care flows directly into the Confidential transactional accounting software PeopleSoft
• BIQ - Data Warehousing Application
• Production subject matter expert for the BIQ application
• Responsible for closing incident/problem requests to meet the required service level agreements
• Prioritize incident/problem requests from low to high in regards to impact to business community
• Lead, develop, and maintain vendor relationship to remediate complicated software issues
• Maintain and updated extracts from PeopleSoft for Accounts Payable Cube imports
• Infrastructure Changes
• Analyze, give recommendations and lead installations for 61 department servers This included Application Servers, Database Servers, Citrix Servers, Web Servers, ETL Servers and Network Storage Devices
• Product Life Cycle Management
• Planned for upgrades to supported applications
• Product maintenance included Windows 2008 SP2, Siteminder Access Manager R12, SQLServer:, Tivoli Workload Scheduler 8.6, Windows: 2008, Windows .NET Framework 2.0, Data Stage 8.7, Oracle 11g Release 2, Red hat Enterprise Linux 5.6, DB2

Informatica ETL Developer\Business Analyst

Confidential - Minneapolis, MN

Responsibilities:

• Identification of source data and the extraction transformation and loading (ETL) of data into a variety of target databases - Informatica
• Database modeling activities to provide visual representations of the conceptual and physical designs of the information management environment - Erwin
• Retrieval of the data from the operational databases as well as the bank data warehouse through the use of sophisticated query and analysis tools - Toad
• Design and develop complex mappings, and workflows to meet business needs - Informatica
• Write complex SQL queries to extract information, transform the data, and load operational as well as data warehouse databases - Toad, Oracle, SQL Server 2005, MySQL
• An intermediate knowledge of operational and data warehousing concepts to load a multitude of data feeds
• Analyzing complex workflows for performance efficiency
• Monitoring Informatica workflows and JCL for proper execution while maintaining an on call rotation - Informatica, Proxy, JCL
• Managed as many any as four projects at one time gathering requirements, performing data profiling, writing SDLC documentation, which include Function Requirements, Technical Requirements, Test Scripts, Deployment instructions and User Acceptance documentation.
• Performed all necessary procedures to define, develop and install projects into the Confidential production environment.

File Transfer Hub Administrator

Confidential -Minneapolis, MN

Responsibilities:

• This included installing the DataExpress, and Connect Direct software on the productions servers as well as the disaster recovery servers - Proxy
• Writing and updating batch scripts, Connect Direct programs, mainframe programs, DataExpress jobs - JCL
• Encrypting data using SSL s, and PGP keys - GNUPG, RoboFTP
• Solved software issues wif the technical support representative from DMB and Sterling Commerce
• Querying the SQL Server 2005 databases for file transfer information - SQL Server 2005

Hyperion System Administrator

Confidential - Minneapolis, MN

Responsibilities:

• Production subject matter expert for the Hyperion application
• Writing consolidation scripts in the proprietary autopilot language
• Updating the procedural manual to provide updated disaster recovery information