We provide IT Staff Augmentation Services!

Informatica Etl Developer\business Analyst Resume

Minnetonka, MN

SYSTEM/APPLICATION COMPETENCIES:

Platforms: Windows 2005 2008, UNIX, LINUX

Database: Oracle 11g, MySQL, SQL Server 2005 2008

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:

Informatica ETL Developer\Business Analyst

Confidential, Minnetonka, MN

Responsibilities:

  • 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, and Earnings and Profits Tax books
  • Update PeopleSoft extracts which are written in SQL (Oracle)
  • Provide on call assistance for nightly batch processing
  • Update Materialized views for Corporate Accounting
  • Create HPSM Change Tickets for production Installations
  • Lead HPSM Incident Review meeting with Corporate Accounting business owners
  • Lead HPSM Incident Review meeting with Tax Accounting business owners
  • Write and execute complex queries to remediate production data issues and job failures
  • Write complex queries to analyzing and verify production data
  • Intersegment Intercompany Pricing and Agreement System
  • Production subject matter expert for the IIPAS 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
  • Create SDLC documentation for code changes to include Request, Design, Testing and Deployment documentation within the HPSM change ticket application
  • Installed break fix scripting update for ECG file transfer remediation
  • Lead HPSM Incident Review meeting with Corporate Accounting business owners
  • Eagle Wings - Statutory Filing Application
  • Production subject matter expert for the Eagle Wings 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
  • Create SDLC documentation for Quarterly and Annual upgrades changes to include Request, Design, Testing and Deployment documents
  • Create project plans for Quarterly and Annual upgrades.
  • Create necessary ADR’s for production installations and procured the necessary approvals from IT and Business Users
  • Retire 14 servers from an unused instance of the Eagle Wings application for a $227,000 annual savings
  • Lead, develop, and maintain vendor relationship to remediate complicated software issues
  • Production subject matter expert for the BlackLine 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
  • 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 with 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: 2005 2008, Tivoli Workload Scheduler 8.6, Windows: 2003 2005 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 Bank 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 certificates, and PGP keys - GNUPG, RoboFTP
  • Solved software issues with 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

Hire Now