We provide IT Staff Augmentation Services!

Sr. Programmer Analyst/etl, Data Integration Resume

4.00/5 (Submit Your Rating)

Beaverton, OR

SUMMARY:

  • Actively seeking full - time opportunity as a Programmer Analyst, DWH/BI solutions developer, Systems / Technical Analyst, Informatica Developer, Data Engineer in an Agile and engaging role where my skills and multifaceted experiences are best matched.
  • 5+ years of experience in distributed data management, rich media content development.
  • Skilled in development and implementation of Database/Data Warehousing/Client/Server applications for data analysis, extraction, transformation and loading.
  • Effective at conducting meetings and brainstorm sessions.
  • Excellent communication, negotiation, analytical, and presentation skills.
  • Exposure to Agile Development and interaction all levels on a SDLC.
  • Ability to perform as part of a team and exceptional talent for quickly learning new systems, company protocols and managing team roles.
  • Agile Certified Scrum Master

TECHNICAL SKILLS:

Tools: Informatica 9.1, SAP Business Objects Profitability Cost Management, Microsoft SQL Server 2005,2008,2012, SSMS, SSRS, TOAD, SQL Developer, Oracle 10g/11g, Talend Open Studio, MatLab, MS Office Suite, MS Visio, Adobe Photoshop, Accordent, Topaz, VMware, Citrix, Altova Suite, Erwin

Programming Languages: SQL, PL/SQL, C

Operating System: Windows 98/2000/XP/Vista/Win7, Linux, Backtrack 3-4, CentOS, OSX

EXPERIENCE:

Sr. Programmer Analyst/ETL, Data Integration

Confidential, Beaverton, OR

Responsibilities:

  • Data analysis, modelling and data support
  • Digital and ongoing support of global merchandizing users
  • BI, Reporting and Analytics operations support
  • Integrate Informatica to relational databases.
  • Application integration within the PI framework, involving high-risk data elements
  • Analyze product level attributions on a published element for feed packaging and repository services
  • Extraction, validation and packaging of data elements for transport
  • XML schema generation, validation, parsing and data validation
  • Design and support operational objects
  • Translate business requirements to technical requirements.
  • Third party vendor support for geographical and global marketing campaigns.
  • Performance tuning and operations analysis
  • Standards compliance and performance based designing.
  • Directing and monitoring test plan execution, performance tuning and quality control checks.
  • Code, generate, package and validate custom XML feeds based on business requirements.

Environment: Oracle 11g, Informatica 9.1, Autosys, XML, Altova XML Tool Kit, Erwin, Windows 7, WebEx, MS Office Suite, Unix, GXS, Adobe, Google, Yahoo, SVN, Toad, PL/SQL, Java, Team City, Splunk, Jira

Programmer Analyst/ETL

Confidential, Omaha, NE

Responsibilities:

  • Developer analyst on the Finance Delivery and Distributed Data Management team, working on the Activity Based Costing and Activity Based Management cost accounting to estimate and analyze the productive capital investment to improve the cost-to-product development and profitability reporting in a major Midwest Health care agile enterprise.
  • Integrate SAP Business Objects Profitability Cost Management to BCBSNE enterprise SQL Server 2005
  • SAP PCM application suite operations support.
  • Analysis of costing and activity driven costing methodology to optimize and pave possible Six Sigma/Power Four based projects.
  • Analysis of repository services
  • Test plan development, execution and performance tuning
  • Data extraction, product cost mapping, resource validations and activity drivers by activity mapping.
  • Design and support Profitability/Contribution Margin reports by Line Items
  • Support FEP and Government reimbursement trace-back costing reports.
  • Data modeling to warehouse trending data off PCM to Microsoft SQL Server 2005
  • HIPAA and PHI standard compliance
  • Health check and standard compliance of the Informatica, ETL tool services and components
  • Programming and development of data load processes for monthly and yearly costing
  • SAP PCM application and server services trouble shooting and debugging.

Environment: SAP Business Objects Profitability and Cost Management (PCM), MS Office Suite, Microsoft SQL Server, SSMS, SSRS, Informatica 9.1, ER Studio, Windows 7, Citrix.

Supervisor/Internet Media Developer

Confidential, IL

Responsibilities:

  • Involved the production and development of rich media content to Accordent®- delivery software to encode local media for server storage and streaming.
  • Maintenance of media server for the media and delivery code content on Black Board® for 3 full terms at Confidential .
  • In corporation and testing of flash based objects in instructor led distance learning programs.

Environment: Accordent, Topaz, MS Office Suite, Adobe Photoshop, IE, Firefox, SQL, TOAD, Oracle 11g, MS Visio.

Research Assistant

Confidential, Chicago

Responsibilities:

  • Research project aimed at creating and implementing virtual machine based test bed for Next Generation 911 services.
  • Test bed implementation of the NG 911 system setup based on the Confidential startup which relies on the ESINet for delivery of voice, video and messages to the PSAP using the SIP Protocol
  • Virtual Machine based installation of the test bed running multiple OS’s on a single hardware to implement and test the usage of the system as a standalone.
  • Server based caller identification and authentication.

Environment: Windows XP, CentOS, SIPc, PSAPd, SQL Server, SSRS,SSMS TOAD, Brekeke SIP server, VMware, MS Office Suit, Talend.

We'd love your feedback!